<?
 require_once("conf_func.php");   
 			$whTbl=trim($_REQUEST['whTbl']);
			
				if(trim($_REQUEST['st_mm'])=="" and trim($_REQUEST['st_yy'])!=""){
						$job_start=trim($_REQUEST['st_yy'])."0101";
				}else if(trim($_REQUEST['st_mm'])!="" and trim($_REQUEST['st_yy'])!=""){
						$job_start=trim($_REQUEST['st_yy']).str_pad(trim($_REQUEST['st_mm']),2,"0",STR_PAD_LEFT)."01";	
				}else{
						$job_start="";
				}
				if(trim($_REQUEST['ed_mm'])!=""  and   trim($_REQUEST['ed_yy'])!=""){
						$endyear=cal_days_in_month(CAL_GREGORIAN, (int)trim($_REQUEST['ed_mm']), (int)trim($_REQUEST['ed_yy']) );
						$job_end=trim($_REQUEST['ed_yy']).str_pad(trim($_REQUEST['ed_mm']),2,"0",STR_PAD_LEFT).$endyear;		
				
				}else if(trim($_REQUEST['ed_mm'])=="" and trim($_REQUEST['ed_yy'])!=""){
						$job_end=trim($_REQUEST['ed_yy'])."1231";
				}else{
						$job_end="";
				}
 
 $job_name=trim($_REQUEST['job_name']);
 $job_owner=trim($_REQUEST['job_owner']);
 $client=trim($_REQUEST['client']);
 $type_endowment=trim($_REQUEST['type_endowment']);
 $type_id=trim($_REQUEST['type_id']);
 $job_status=trim($_REQUEST['job_status']);    
			 
			$type_ref=trim($_REQUEST['type_ref']);
			$emp_code=trim($_REQUEST['emp_code']);
			$orderby=trim($_REQUEST['orderby']);
			$ord=trim($_REQUEST['ord'])=="" ? "desc" : trim($_REQUEST['ord']);
			$wheis="";
			
			if($job_name!=""){
					$wheis.=" AND j.job_name  LIKE   '%".mysql_real_escape_string(str_replace(" ","%",$job_name))."%' ";
			}
			if($job_owner!=""){
					$wheis.=" AND j.job_owner   LIKE   '%".mysql_real_escape_string(str_replace(" ","%",$job_owner))."%'  ";
			}						
			if($client!=""){
					$wheis.=" AND j.client   LIKE   '%".mysql_real_escape_string(str_replace(" ","%",$client))."%'  ";
			}					
			if($type_endowment!=""){
					$wheis.=" AND j.type_endowment='".mysql_real_escape_string($type_endowment)."' ";
			}
			if($type_id!=""){
					$wheis.=" AND j.type_id='".mysql_real_escape_string($type_id)."' ";
			}
			if($job_status=="y"){
					$wheis.=" AND j.job_status='y' ";
			}else	 if($job_status=="h"){
					$wheis.=" AND j.job_status!='y' ";
			}					
			
						
			if($type_ref!=""){
					$wheis.=" AND j.type_ref='".mysql_real_escape_string($type_ref)."' ";
			}
			if($emp_code!=""){
					$wheis.=" AND jt.emp_code='".mysql_real_escape_string($emp_code)."' ";
			}
			
			if(strlen($job_start)==8 and strlen($job_end)==8){					
					$wheis.="  AND j.job_start BETWEEN '".mysql_real_escape_string($job_start)."' AND '".mysql_real_escape_string($job_end)."' ";
			}else if(strlen($job_start)==0 and strlen($job_end)==8){
					$wheis.="   AND IF(j.job_end<>'',j.job_end,j.job_start) <=  ".$job_end ;  
			}else if(strlen($job_start)==8 and strlen($job_end)==0){
					$wheis.="   AND j.job_start >=  ".$job_start ;  
			}else{
			
			}
			
			$sqlData="SELECT j .*,jt.emp_code,jt.job_postion,jy.type_name  FROM job j  LEFT JOIN job_temp jt ON ( j.job_code = jt.job_code )   LEFT JOIN job_type jy ON(j.type_id=jy.type_id AND j.type_ref=jy.type_ref) WHERE 1   ".$wheis."     ";
 			 
  
			$rstotalRow=mysql_query($sqlData."GROUP BY j.job_code ");
			$totalrow = mysql_num_rows($rstotalRow); 
			mysql_free_result($rstotalRow);			
			

$rsSUB=mysql_query("SELECT * FROM employee_group ORDER BY emp_sub, g_name_th ;");	
	  if($rsSUB){
	  		$s=0;
			while($rowSUB=mysql_fetch_assoc($rsSUB)){
					$gGID[trim($rowSUB['emp_group'])]=trim($rowSUB['g_name_th']);
			}  mysql_free_result($rsSUB);	
		}	
 
//---------------------SPILT page-----------------------//
 
 	if((int)$_REQUEST['page']==0){

			$page=1;

	}else{   $page=(int)$_REQUEST['page'];  }

	$pagesize = (int)$_REQUEST['pagesize']==0 ? 20 : (int)$_REQUEST['pagesize'] ; 
	
	$totalpage = ceil($totalrow/$pagesize);
	
	$start_from = ($page-1) * $pagesize;


//------------------End Spit page-------------------//

$linkPage=$PHP_SELF."?type_ref=".$type_ref."&emp_code=".$emp_code."&st_mm=".trim($_REQUEST['st_mm'])."&st_yy=".trim($_REQUEST['st_yy'])."&ed_mm=".trim($_REQUEST['ed_mm'])."&ed_yy=".trim($_REQUEST['ed_yy'])."&pagesize=".trim($pagesize)."";
  
 
 $rsListName=mysql_query(" SELECT emp_code, emp_name FROM employee WHERE   emp_status!='ลาออก' and  emp_status!='เสียชีวิต'   and  emp_status!='ตัดโอนอัตรา'   and  emp_status!='เกษียณอายุราชการ'    ORDER BY emp_name");
 $whTbl="job";
if($rsListName){
		$txtOP='';
		while($rowN=mysql_fetch_assoc($rsListName)){
				$emp_name[$rowN['emp_code']]=$rowN['emp_name'];
				$txtOP.="<option value='".$rowN['emp_code']."'   ".($emp_code==$rowN['emp_code'] ? "selected" : "" )." >".$rowN['emp_name']."</option>";
		} mysql_free_result($rsListName);	
} // end if $rsListName
// $arrGropEmployee  // array Group from require_once conf_func.php
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<meta name="robots" content="noindex,nofollow"> 
<title>ระบบฐานข้อมูล งานบริการวิชาการ งานสร้างสรรค์ และงานอื่นๆ ที่เกี่ยวข้อง [ARCH KKU]  รายงาน - ( วิจัย / งานบริการวิชาการ / งานสร้างสรรค์ / ทำนุบำรุงศิลปะวัฒนธรรม)</title>
<link href="st.css" rel="stylesheet" type="text/css" />
	<script src="jcontrol.js" language="javascript" type="text/javascript"></script>
	<script language="javascript" type="text/javascript">
		function getTypeJob(vData,displayId){				 
				var form=document.fform;	
				//alert(vData);
				var url="jcontrol_data.php?typedata=getTypejob&vData="+trim(vData) ;
				if(vData!=""){
					getdata2(url,trim(displayId));
				}else{
					 document.fform.elements['type_id'].disabled=true;
				}
				
		} // end function	
		function goto(){				
						if(document.fform.treport[0].checked==true){
							document.fform.action='job.php' ;
							document.fform.submit();
						}else if(document.fform.treport[1].checked==true){
							 
							document.fform.action='job_export2.php' ;
							document.fform.submit();
						}else if(document.fform.treport[2].checked==true){
								 
							document.fform.action='job_export2.php' ;
							document.fform.submit();
		
							
						}
				//}
		}		
	</script>
</head>
<body class="font_normal12"  bgcolor="#382509"  style="margin:2px;"  >
<div align="center">

<table width="1000" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="15" height="15"><img src="images/15x15_L_top.gif" /></td>
    <td style="background-image:url(images/15x2_line_top.gif); background-repeat:repeat-x;"></td>
    <td width="15" height="15"><img src="images/15x15_R_top.gif" /></td>
  </tr>
  <tr bgcolor="#FFFFFF">
    <td style="border-left:#382509 solid 2px; " align="center">&nbsp;</td>
    <td  align="left">	
<? include("menu_navi.php"); ?>		

<div align="left"  style="padding:0px;  color:#3e3e3e">&nbsp;&nbsp;&nbsp;
	<img src="images/10.png"  hspace="5" />	รายงานผลงานต่างๆ  &gt;&gt;  <img src="images/09.png"  hspace="5"  /><b>รายงาน( วิจัย / งานบริการวิชาการ / งานสร้างสรรค์ / ทำนุบำรุงศิลปะวัฒนธรรม)</b></div>
<div align="right" style="background-image:url(images/linehide_top.gif); height:25px; width:900px; background-repeat:no-repeat;  padding-top:3px; ">
	<b style="color:#999999">ค้นหาข้อมูล  รายงาน( วิจัย / งานบริการวิชาการ / งานสร้างสรรค์ / ทำนุบำรุงศิลปะวัฒนธรรม)</b>&nbsp;&nbsp;&nbsp;&nbsp;
</div>	
<div align="left" style="background-image:url(images/linehide_middle.gif); background-repeat:repeat-y;   width:900px;display:none;  " id="areaF_on">
			<form action="" method="post" style="margin:0px;" name="fform" >
			<input type="hidden"  id="fname" name="fname" value="240919" /> 
			<input type="hidden"  id="whTbl" name="whTbl" value="" /> 
			<div align="center" style="padding:5px; ">
			<table width="95%" border="0" cellspacing="1" cellpadding="1">
			<tr>
			  <td  align="right">ชื่องาน</td>
			  <td align="left"><input    type="text" autocomplete="off"  name="job_name" id="job_name"  maxlength="500"   style="width:200px; " value=""     /></td>
			  <td  align="right">เจ้าของโครงการ</td>
			  <td align="left"><input    type="text" autocomplete="off"  name="job_owner" id="job_owner"  maxlength="500"   style="width:200px; " value=""     /></td>
			  </tr>
			<tr>
			  <td  align="right">ผู้รับบริการ</td>
			  <td align="left"><input    type="text" autocomplete="off"  name="client" id="client"  maxlength="500"   style="width:200px; " value=""     /></td>
			  <td  align="right">ประเภทแหล่งทุน</td>
			  <td align="left"><select name="type_endowment" id="type_endowment"  style="width:200px;">
					<option value="">--------</option>
					<option value="ภายนอก"  >ภายนอก</option>
					<option value="ภายใน"  >ภายใน</option>
			</select></td>
			  </tr>
			<tr>
			  <td  align="right">ประเภทงาน</td>
			  <td align="left"><select name="type_ref" id="type_ref"   style="width:200px;"  onchange="getTypeJob(this.value,'div_type_id');" >
                <option value=""   >----ทุกงาน----</option>
                <?
					 for($i=1;$i<=count($arrJobType);$i++){
							?>
			    <option value=""  <? if($type_ref==$arrJobType[$i]['typeis'] and $type_ref!="" ){ echo  "selected" ; }?>  >
			      			      </option>
			    <?
					 } // end for										
					?>
              </select></td>
			  <td  align="right">ชื่อบุคลากร</td>
			  <td align="left"><select  name="emp_code" id="emp_code"  style="width:200px;"  >
			    <option value="">---ทุกๆ คน---</option>
			    			    </select>			  </td>
			  </tr>
			<tr>
			    <td  align="right">กิจกรรม</td>
				<td align="left"><span id="div_type_id"><select name="type_id" id="type_id"  style="width:200px;" disabled >
					<option value="">--------</option>
			<?
				if(trim($type_id)!=""){
			 		$rsList=mysql_query("SELECT * FROM job_type WHERE type_ref='".mysql_real_escape_string($rowData['type_ref'])."' ;");
		
					if($rsList){
							while($row=mysql_fetch_assoc($rsList)){
									echo "<option value='".$row['type_id']."' ".($type_id==$row['type_id'] ? "selected" : "")."  >".$row['type_name']."</option>";
							} mysql_free_result($rsList);
						}
			 }
			?></select></span></td>
				<td  align="right">สถานะ</td>
				<td align="left">
					<select id="job_status" name="job_status"   style="width:200px;"  >
							<option value="">------ทุกสถานะ----</option>
							<option value="h" >รอข้อมูลเพิ่มเติม</option>
							<option value="y" >สมบรูณ์แล้ว</option>
					</select>
				</td>
			  </tr>
			  <tr>
			    <td width="14%" align="right">ช่วงที่เริ่มทำ </td>
			    <td width="26%" align="left"><select  name="st_mm"  id="st_mm" >
							<option value="">----ทุกเดือน----</option>		
					<? 
							for($mm=1;$mm<=12;$mm++){
									echo "<option value='".$mm."'  ".($mm==(int)($_REQUEST['st_mm']) ? "selected" : "")." >".mmThai($mm)."</option>";
							} // end for $mm
					?>
				</select>&nbsp;&nbsp;
				
				<select  name="st_yy"  id="st_yy" > <option value="">--ทุกปี--</option>  
							<?
									for($yy=date("Y",mktime(0, 0, 0, date("m"),   date("d"),   date("Y")-5));$yy<=date("Y",mktime(0, 0, 0, date("m"),   date("d"),   date("Y")+5));$yy++){
											$thaiyear=$yy+543;
											echo "<option value='".$yy."'  ".($yy==(int)($_REQUEST['st_yy']) ? "selected" : "")." >".($thaiyear)."</option>";
											//echo "<option value='".$yy."'  ".($yy==date("Y",mktime(0, 0, 0, date("m"),   date("d"),   date("Y"))) ? "selected" : "")." >".($thaiyear)."</option>";
									} // end for $yy
							?>				
				</select></td>
			    <td width="13%"  align="right">ถึงวันที่</td>
			    <td width="47%" align="left"><select  name="ed_mm"  id="ed_mm" >
							<option value="">----ทุกเดือน----</option>		
					<? 
							for($mm=1;$mm<=12;$mm++){
									echo "<option value='".$mm."'  ".($mm==(int)($_REQUEST['ed_mm']) ? "selected" : "")." >".mmThai($mm)."</option>";
							} // end for $mm
					?>
				</select>&nbsp;&nbsp;
				 
				<select  name="ed_yy"  id="ed_yy" >   <option value="">--ทุกปี--</option>
							<?
									for($yy=date("Y",mktime(0, 0, 0, date("m"),   date("d"),   date("Y")-5));$yy<=date("Y",mktime(0, 0, 0, date("m"),   date("d"),   date("Y")+5));$yy++){
											$thaiyear=$yy+543;
											echo "<option value='".$yy."'  ".($yy==(int)($_REQUEST['ed_yy']) ? "selected" : "")." >".($thaiyear)."</option>";
											//echo "<option value='".$yy."'  ".($yy==date("Y",mktime(0, 0, 0, date("m"),   date("d"),   date("Y"))) ? "selected" : "")." >".($thaiyear)."</option>";
									} // end for $yy
							?>				
				</select></td>
		      </tr>
			  
			  <tr>
			    <td  align="right">ดูข้อมูลแบบ  </td>
			    <td align="left">
				<input type="radio" name="treport"     id="treport" value="html"  checked="checked" onclick="if(this.checked==true){  document.fform.elements['orderby'].disabled=true; ; document.fform.elements['pagesize'].disabled=false;  }" /> html     &nbsp;&nbsp;&nbsp;&nbsp;
		<input type="radio" name="treport"     id="treport" value="msw" onclick="if(this.checked==true){  document.fform.elements['orderby'].disabled=false;  document.fform.elements['pagesize'].disabled=true;  }"  /> <img src="images/ft/page_white_word.png"  border="0"/>     &nbsp;&nbsp;&nbsp;&nbsp;
		<input type="radio" name="treport"     id="treport" value="mse"  onclick="if(this.checked==true){  document.fform.elements['orderby'].disabled=false; document.fform.elements['pagesize'].disabled=true;  }" /> <img src="images/ft/page_white_excel.png" border="0" />				</td>
			    <td  align="right">เรียงข้อมูลตาม</td>
			    <td align="left">
						<select name="orderby" id="orderby"  disabled="disabled"  style="width:150px;" >
								<option value="type_ref">ประเภทงาน</option>	
								<option value="job_code">รหัสงาน</option>															
								<option value="job_start">ช่วงที่เริ่มทำ</option>
								<!--<option value="emp_name">ชื่อบุคลากร</option>-->
								<option value="type_endowment">ประเภทแหล่งทุน</option>								
						</select> &nbsp;&nbsp; &nbsp;&nbsp; จำนวนที่ต้องการแสดง : 
						<select name="pagesize" id="pagesize" >
								<option value="20"  >20</option>
								<option value="50" >50</option>
								<option value="" selected>ทั้งหมด</option>
						</select>				</td>
		      </tr>
			</table>
			
				<input type="button" name="bbSearch" id="bbSearch" value="ค้นหา"  style="width:100px; font-weight:bold" onclick="goto()" />
	</div>
	
</form>
</div>
<div align="center" style="background-image:url(images/linehide_.gif); height:20px; width:900px; background-repeat:repeat-x; "><img src="images/lineshow_on.gif" id="show_on"  style="cursor:pointer" onclick="if(document.getElementById('areaF_on').style.display=='none'){ document.getElementById('areaF_on').style.display='block' ; this.src='images/lineshow_off.gif'; }else{ document.getElementById('areaF_on').style.display='none' ; this.src='images/lineshow_on.gif';  }" /></div>	
<?
			$Worder="  ORDER BY  j.job_code      ".$ord."  ";
			if($orderby!="emp_code"  and $orderby!=""){
					$Worder=" ORDER BY    j.".$orderby."        ".$ord." ";
			}else if($orderby=="emp_code"  and $orderby!=""){
					$Worder=" ORDER BY    jt.emp_code        ".$ord."   ";
			}
 


			if($emp_code!=""){
					$sqlData2=$sqlData."  ".$wheis."  ".$Worder."  LIMIT ".$start_from." , ".$pagesize." ";
			}else{
				$sqlData2="SELECT te.* ,pp.byMD,pp.emp_group ,jt.emp_code,jt.job_postion  FROM ( SELECT j .* ,jy.type_name  FROM job j    LEFT JOIN job_type jy ON(j.type_id=jy.type_id AND j.type_ref=jy.type_ref) WHERE 1   ".$wheis."  ".$Worder."  LIMIT ".$start_from." , ".$pagesize."  ) as te  LEFT JOIN job_temp jt ON ( te.job_code = jt.job_code )  LEFT JOIN job_plan_status pp ON ( te.job_code = pp.job_code ) ";			
			}			
  			$rsData=mysql_query($sqlData2);

			//echo $sqlData2;
						echo "<hr>";
			if($rsData){
			?>
			
			<div align="left"  style="width:500px; float:left; height:30px; clear:both"><b style="text-decoration:underline">รายงาน( วิจัย / งานบริการวิชาการ / งานสร้างสรรค์ / ทำนุบำรุงศิลปะวัฒนธรรม)</b> </div>
			<div align="right"  style="width:400px; float:left; height:30px;">
			<b>จำนวนงานทั้งหมด 
					    งาน</b> ขณะท่านอยู่ที่หน้า 			
   				 <select  name="page"  id="page" onchange="window.parent.location=this.value " >
<?

			for($i=1;$i<=$totalpage;$i++){				
						if($page==$i){	
							 echo "<option value=\"".$i."\"  selected >".$i."</option>";	
						}else if($page>$i){	
							echo "<option value='".$linkPage."&ord=".$ord."&page=".$i."'>".$i."</option>";	
						}else if($page<$i){	
								echo "<option value='".$linkPage."&ord=".$ord."&page=".$i."'>".$i."</option>";	
						}			
	
			} // end for
	
		?></select>
				/ <b></b>&nbsp;&nbsp;
				<? if($page>1){ ?><a href="&ord=&page=-1" title="ก่อนหน้า"><img src="images/pre_p11.gif" border="0" align="absbottom"   /></a><? } ?><? if($page<$totalpage){ ?><a href="&ord=&page=1"  title="หน้าต่อไป"><img src="images/next_p11.gif" border="0" align="absbottom" /></a><? } ?>
		</div>
					<table width="1800" border="0" cellpadding="1" cellspacing="1"  bgcolor="#CCCCCC" class="font_normal12" style="clear:both"  >
					  <tr bgcolor="#EBEBEB">
						<td width="5%"><a href="&orderby=job_code&ord=asc"><b>รหัสงาน</b><? if($ord=="asc" and  $orderby=="job_code" ){ ?><img src="images/ord_asc.png" border="0" hspace="2" /><? }else  if($ord=="desc" and  $orderby=="job_code" ){ ?><img src="images/ord_desc.png" border="0" hspace="2"  /><? } ?></a></td>
						<td width="17%"  ><a href="&orderby=job_name&ord=asc"><b>ชื่องาน</b><? if($ord=="asc" and  $orderby=="job_name" ){ ?><img src="images/ord_asc.png" border="0" hspace="2" /><? }else  if($ord=="desc" and  $orderby=="job_name" ){ ?><img src="images/ord_desc.png" border="0" hspace="2"  /><? } ?></a></td>
						<td width="6%"><a href="&orderby=type_ref&ord=asc"><b>ประเภทงาน</b><? if($ord=="asc" and  $orderby=="type_ref" ){ ?><img src="images/ord_asc.png" border="0" hspace="2" /><? }else  if($ord=="desc" and  $orderby=="type_ref" ){ ?><img src="images/ord_desc.png" border="0" hspace="2"  /><? } ?></a></td>
						<td width="8%"><a href="&orderby=type_id&ord=asc"><b>กิจกรรม</b><? if($ord=="asc" and  $orderby=="type_id" ){ ?><img src="images/ord_asc.png" border="0" hspace="2" /><? }else  if($ord=="desc" and  $orderby=="type_id" ){ ?><img src="images/ord_desc.png" border="0" hspace="2"  /><? } ?></a></td>
						<td width="7%">
						<b>ผู้ร่วมทำโครงการ</b></td>
						<td width="5%"><a href="&orderby=type_endowment&ord=asc"><b>ประเภทแหล่งทุน</b><? if($ord=="asc" and  $orderby=="type_endowment" ){ ?><img src="images/ord_asc.png" border="0" hspace="2" /><? }else  if($ord=="desc" and  $orderby=="type_endowment" ){ ?><img src="images/ord_desc.png" border="0" hspace="2"  /><? } ?></a></td>
						<td width="8%"><a href="&orderby=job_owner&ord=asc">เจ้าของโครงการ<? if($ord=="asc" and  $orderby=="job_owner" ){ ?><img src="images/ord_asc.png" border="0" hspace="2" /><? }else  if($ord=="desc" and  $orderby=="job_owner" ){ ?><img src="images/ord_desc.png" border="0" hspace="2"  /><? } ?></a></td>
						<td width="7%"><a href="&orderby=client&ord=asc">ผู้รับบริการ<? if($ord=="asc" and  $orderby=="client" ){ ?><img src="images/ord_asc.png" border="0" hspace="2" /><? }else  if($ord=="desc" and  $orderby=="client" ){ ?><img src="images/ord_desc.png" border="0" hspace="2"  /><? } ?></a></td>
						<td width="7%"><a href="&orderby=job_start&ord=asc">วันที่ทำโครงการ<? if($ord=="asc" and  $orderby=="job_start" ){ ?><img src="images/ord_asc.png" border="0" hspace="2" /><? }else  if($ord=="desc" and  $orderby=="job_start" ){ ?><img src="images/ord_desc.png" border="0" hspace="2"  /><? } ?></a></td>
						<td width="7%"><a href="&orderby=allowance_spend&ord=asc">งบดำเนินการ (ใช้จริง) <? if($ord=="asc" and  $orderby=="allowance_spend" ){ ?><img src="images/ord_asc.png" border="0" hspace="2" /><? }else  if($ord=="desc" and  $orderby=="allowance_spend" ){ ?><img src="images/ord_desc.png" border="0" hspace="2"  /><? } ?></a></td>
						<td width="5%"><a href="&orderby=allowance&ord=asc">งบประมาณทั้งหมด<? if($ord=="asc" and  $orderby=="allowance" ){ ?><img src="images/ord_asc.png" border="0" hspace="2" /><? }else  if($ord=="desc" and  $orderby=="allowance" ){ ?><img src="images/ord_desc.png" border="0" hspace="2"  /><? } ?></a></td>
						<td width="8%"><b>อื่นๆ</b></td>
						<td width="5%"><a href="&orderby=job_status&ord=asc"><b>สถานะ</b><? if($ord=="asc" and  $orderby=="job_status" ){ ?><img src="images/ord_asc.png" border="0" hspace="2" /><? }else  if($ord=="desc" and  $orderby=="job_status" ){ ?><img src="images/ord_desc.png" border="0" hspace="2"  /><? } ?></a></td>
						<td width="5%"><a href="&orderby=update_date&ord=asc"><b>ปรับปรุงเมื่อ</b><? if($ord=="asc" and  $orderby=="update_date" ){ ?><img src="images/ord_asc.png" border="0" hspace="2" /><? }else  if($ord=="desc" and  $orderby=="update_date" ){ ?><img src="images/ord_desc.png" border="0" hspace="2"  /><? } ?></a></td>
					  </tr>
					  <?
					  $rowh='';
					  $i=0;
					  while($rowD=mysql_fetch_assoc($rsData) ){
						  if($rowh!=$rowD['job_code']) {  
						  		$i++; 
								$k=0;	
								$Ljob_code[$i]=trim($rowD['job_code']);
								$LbyMD[$i]=trim($rowD['byMD']); 
								$Lfile_ref[$i]=trim($rowD['file_ref']);
								$Ljob_name[$i]=htmlspecialchars(trim(stripslashes($rowD['job_name'])))	;
								$Ltype_ref[$i]=htmlspecialchars(trim(stripslashes($arrJobType2[$rowD['type_ref']])));
								$Ltype_name[$i]=htmlspecialchars(trim(stripslashes($rowD['type_name'])));
								$Ltype_endowment[$i]=htmlspecialchars(trim(stripslashes($rowD['type_endowment'])));
								$Ljob_owner[$i]=htmlspecialchars(trim(stripslashes($rowD['job_owner'])));
								$Lclient[$i]=htmlspecialchars(trim(stripslashes($rowD['client'])));
								$Ljob_start[$i]=trim($rowD['job_start']);
								$Ljob_end[$i]=trim($rowD['job_end']);
								$Lallowance_spend[$i]=htmlspecialchars(trim(stripslashes($rowD['allowance_spend'])));
								$Lallowance[$i]= is_numeric(trim($rowD['allowance'])) ? number_format(trim($rowD['allowance'])) : trim($rowD['allowance']);
								$Lother[$i]=htmlspecialchars(trim(stripslashes($rowD['other'])));
								$Ljob_status[$i]=($rowD['job_status']!="y"? "รอข้อมูลเพิ่ม" : "");
								$Lupdate_date[$i]=$rowD['update_date'] ;
								$dx=explode("x",$rowD['emp_group']);
								$dxx='';
								for($s=1;$s<=count($dx);$s++){
								  if(trim($dx[$s])!=""){  $dxx.=" - ".$gGID[$dx[$s]]."<br> "; }								  	 
								} //end for
								$LGID[$i]=$dxx;
						  }// end if
						 				
								$k++;    
								$Ljob_postion[$i][$k]=trim($rowD['job_postion'])=='head' ? '<b>(หัวหน้า)</b>' : '' ; 	
								$Lemp_code[$i][$k]=trim($rowD['emp_code']);	
							$rowh=$rowD['job_code'];
					   } mysql_free_result($rsData);
					   
 
					   for($i=1;$i<=count($Ljob_code);$i++){
					?>
						  <tr bgcolor="#FFFFFF"    onmouseover="this.style.backgroundColor='#EEEEEE';"  onmouseout="this.style.backgroundColor='#FFFFFF';"  >
							<td valign="top" align="left">  </td>
							<td  valign="top" align="left"><img src="images/documents_edit.png" hspace="2" /><a href="_form.php?id="  target="_blank"><b></a></b>       </td>
							<td valign="top" align="left"></td>
							<td valign="top" align="left"></td>
							<td valign="top" align="left">
							<? 
											if( count($Lemp_code[$i])>0){
														for($k=1;$k<=count($Lemp_code[$i]);$k++)	{ 
																if($k!=1){
																	echo ", ";
																}
																echo $emp_name[$Lemp_code[$i][$k]]."  ".$Ljob_postion[$i][$k]."   ";
														}// end for k
											} // end if			
							?></td>
							<td valign="top" align="left"></td>
							<td valign="top" align="left"></td>
							<td valign="top" align="left"></td>
							<td valign="top" align="left">