MINI SHELL

Server : Apache/2.2.2 (Fedora)
System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686
User : apache ( 48)
PHP Version : 5.2.9
Disable Function : NONE
Directory :  /home/pathumthani_integration/integration/application/labor/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : //home/pathumthani_integration/integration/application/labor/labor_vacancy_index.php
<? session_start() ; 
//header("Content-Type: text/html; charset=windows-874"); 
set_time_limit(0) ; 

include_once("../../config/config_epm.inc.php");
include_once("manage_user.inc.php");
include_once("function/function.inc.php");
include_once("../../inc/function.php");

function ccName($ccDigi=""){
		$am = mysql_query("SELECT ccDigi,ccName,ccType FROM ccaa WHERE ccDigi= '".$ccDigi."' ");
		$r_am = mysql_fetch_assoc($am);
		return $r_am["ccName"];
}

function getMainPosition($position_id="", $position_type="position_type", $position_footer=""){
	if($position_type == "position_type"){
		$sql = " SELECT * FROM `labor_master_position` WHERE position_type_id='".$position_id."' ";
		$query = mysql_query($sql);
		$row = mysql_fetch_assoc($query);
		$position_footer = $row['position_name'];
	}else if($position_type == "position_id"){
		$sql = " SELECT * FROM `labor_master_position` WHERE position_id='".$position_id."' ";
		$query = mysql_query($sql);
		$row = mysql_fetch_assoc($query);
		$position_footer = $position_footer;
	}
	
	if($row['parent_id']>0){
		getMainPosition($row['parent_id'], "position_id",$position_footer);
	}else{
		echo "- ".$row['position_name']."<br/>&nbsp;&nbsp;(".$position_footer.")<br/>";
	}
}

$time_start = getmicrotime();
?>
<!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=tis-620" />
<title><?=$title_name?></title>
<script language="javascript">
function mOvr(src,clrOver){ 
	if (!src.contains(event.fromElement)) src.bgColor = clrOver; 
} 

function mOut(src,clrIn){ 
	if (!src.contains(event.toElement)) src.bgColor = clrIn; 
} 
</script>
<style type="text/css">
<!--
A:link {
	FONT-SIZE: 12px;color: #000000;	FONT-FAMILY: Tahoma,  "Microsoft Sans Serif";TEXT-DECORATION: underline;FONT-WEIGHT: bold;
}
A:visited {
	FONT-SIZE: 12px; COLOR: #000000; FONT-FAMILY: Tahoma,  "Microsoft Sans Serif"; TEXT-DECORATION: underline;FONT-WEIGHT: bold;
}
A:active {
	FONT-SIZE: 12px; COLOR: #014d5f; FONT-FAMILY: Tahoma,  "Microsoft Sans Serif"; TEXT-DECORATION: underline;FONT-WEIGHT: bold;
}
A:hover {
	FONT-SIZE: 12px; COLOR: #f3960b; FONT-FAMILY: Tahoma,  "Microsoft Sans Serif"; TEXT-DECORATION: underline;FONT-WEIGHT: bold;
}
.style1 {color: #FF0000}
.style2 {font-size: 24px}
.h_menu {color:#FF9900}
-->
.bg_th{
  background-image:url(images/horiz-bg.png);
  background-repeat:repeat-x;
  background-color:#305086;
  font-weight:bold;
  color:#FFFFFF;
  text-align:center;
  }
  .bg_th1{
  background-repeat:repeat-x;
  background-color:#385d97;
  font-weight:bold;
  color:#FFFFFF;
  text-align:center;
  }
</style>
<script language=JavaScript> 
function Conf(object) {
if (confirm("ยืนยันการลบข้อมูล")==true) {
return true;
}
return false;
}

function CheckIsIE() 
{ 
if (navigator.appName.toUpperCase() == 'MICROSOFT INTERNET EXPLORER') { return true;} 
else { return false; } 
} 


function PrintThisPage() 
{ 

if (CheckIsIE() == true) 
{ 
parent.iframe1.focus(); 
parent.iframe1.print(); 
} 
else 
{ 
window.frames['iframe1'].focus(); 
window.frames['iframe1'].print(); 
} 

} 

</script> 

<link href="../../common/tooltip/css/style.css" type="text/css" rel="stylesheet">
<script src="../../common/tooltip/jquery_1_3_2.js"></script>
<script>
//File Ajax tooltip
var url_tooltip = 'http://<?php echo $_SERVER['SERVER_NAME'];?>/pathumthani_integration/integration/application/industry/labor_register_tooltrip.php';
</script>
<script src="../../common/tooltip/tooltip_personal.js"></script>

</head>
<body>
<? 
//include("header.php"); 

if($_GET['runid_del']){
		mysql_query("DELETE FROM labor_vacancy_register WHERE vacancy_register_id='".$_GET['runid_del']."' ");
		mysql_query("DELETE FROM labor_vacancy WHERE vacancy_register_id='".$_GET['runid_del']."' ");
		//mysql_query("DELETE FROM pathumthani.da_deprecrate WHERE type_id='".$_GET['type_id_del']."' ");
	}
?>
<!-- &nbsp;&nbsp;<strong style="color:#000033; font-size:18px;"><img src="images/unpublish_f2.png" align="absmiddle"  border="0"/>ทะเบียนโรงงานอุตสาหกรรม</strong>
--> 
 <?

 	$strSearch="";
	$strSQL_1 = "SELECT
						SUM(labor_vacancy.position_qty) AS sum_qty,
						COUNT(labor_vacancy.position_id) AS count_position,
						labor_vacancy_register.date_announce,
						labor_master_company.company_name,
						labor_master_company.company_taxid,
						labor_vacancy_register.vacancy_register_id,
						labor_master_company.d_ampur_id,
						labor_vacancy.position_id
						FROM
						labor_vacancy
						Inner Join labor_vacancy_register ON labor_vacancy_register.vacancy_register_id = labor_vacancy.vacancy_register_id
						Inner Join labor_master_company ON labor_vacancy_register.company_taxid = labor_master_company.company_taxid
						WHERE	labor_vacancy_register.vacancy_register_id IS NOT NULL 
						";
						
				#Begin Exsum
				$strSQL_exsum	.= $strSQL_1."  GROUP BY labor_master_company.company_taxid ";
				$query_exsum = mysql_query($strSQL_exsum);
				while($row_exsum = mysql_fetch_assoc($query_exsum)){
					$d_ampur_id = substr($row_exsum['d_ampur_id'],0,2);
					$num_register['all'] += 1;
					$arr_sum_qty['all'] += $row_exsum['sum_qty'];
					$arr_count_position['all'] += $row_exsum['count_position'];
					if($d_ampur_id==13){
						$arrPCVExSum[$row_exsum['d_ampur_id']][0] +=1;
						$num_register[$row_exsum['d_ampur_id']] +=1;
						$arr_sum_qty[$row_exsum['d_ampur_id']] += $row_exsum['sum_qty'];
						$arr_count_position[$row_exsum['d_ampur_id']] += $row_exsum['count_position'];
					}else{
						$arrPCVExSum[99999999][0] +=1;
						$num_register[99999999] +=1 ;
						$arr_sum_qty[99999999] += $row_exsum['sum_qty'];
						$arr_count_position[99999999] += $row_exsum['count_position'];
					}
				}
				$arrPCExSum = percentage_2d($arrPCVExSum); #show($arrPCExSum);
				
				#End Exsum
				
				if($_GET['p']){
						$strSearch.="&p=".$_GET['p'];	
				}
				if($_GET['start_date_announce'] && $_GET['end_date_announce']){
					$arr_start_register_date = explode("/",$_GET['start_date_announce']);
					$arr_end_register_date = explode("/",$_GET['end_date_announce']);
					$strSQL_1.="	AND 	labor_vacancy_register.date_announce 
											BETWEEN '".($arr_start_register_date[2]-543)."-".$arr_start_register_date[1]."-".$arr_start_register_date[0]."' 
											AND '".($arr_end_register_date[2]-543)."-".$arr_end_register_date[1]."-".$arr_end_register_date[0]."' ";
					$strSearch.="&start_date_announce=".$_GET['start_date_announce']."&end_date_announce=".$_GET['end_date_announce'];
				}
				if($_GET['company_name']){
					$strSQL_1 .= "	AND labor_master_company.`company_name` LIKE('%".$_GET['company_name']."%') ";
					$strSearch .= "&company_name=".$_GET['company_name'];
				}
				if($_GET['d_ampur_id']){
					if(substr($_GET['d_ampur_id'],0,2)==13){
						$strSQL_1 .= "	AND labor_master_company.d_ampur_id ='".$_GET['d_ampur_id']."' ";
					}else if($_GET['d_ampur_id']==99999999){
						$strSQL_1 .= "	AND LEFT(labor_master_company.d_ampur_id,2) != '13' ";
					}
					$strSearch .= "&d_ampur_id=".$_GET['d_ampur_id'];
				}

				$strSQL_1.="	  GROUP BY labor_master_company.company_taxid ";
				//echo $strSQL_1;
				
 ?>
<br />
<table width="99%" border="0" cellpadding="0" cellspacing="0" align="center">
 		<tr>
        		<td align="center"><strong style="color:#000000; font-size:14px;">ข้อมูลตำแหน่งงานว่าง จังหวัดปทุมธานี</strong></td>
        </tr>
        <tr>
        		<td align="center">ข้อมูล ณ วันที่ <?=dateFormat(date('Y-m-d'),'thaidot')?></td>
        </tr>
</table>
 
 <br />
<table width="99%" border="0" cellpadding="0" cellspacing="0" align="center">
 		<tr>
        		<td valign="top" align="left" width="60%">
                		<table width="75%" border="0" bgcolor="#CCCCCC" cellpadding="3" cellspacing="1">
                                <tr class="bg_th">
                                  <td align="center"><strong>อำเภอ</strong></td>
                                  <td align="center"><strong>จำนวนประกาศ <br/>(รายการ)</strong></td>
								   <td align="center"><strong>จำนวนตำแหน่ง <br/>(ตำแหน่ง)</strong></td>
								   <td align="center"><strong>จำนวน (อัตรา)</strong></td>
                                  <td align="center">ร้อยละ<strong></strong></td>
                                </tr>
								<?php
								$sql_ccaa_pathumthani = mysql_query("SELECT ccDigi,ccName,ccType FROM ccaa_pathumthani WHERE ccType='Aumpur' ");
								while($row_ccaa = mysql_fetch_assoc($sql_ccaa_pathumthani)){
								$arrPCExSum['all'][0] += $arrPCExSum[$row_ccaa['ccDigi']][0];
								$arrExSumData[$row_ccaa['ccName']] = (($arrPCExSum[$row_ccaa['ccDigi']][0])?$arrPCExSum[$row_ccaa['ccDigi']][0]:'0.00');
								?>
                                <tr bgcolor="#FFFFFF">
                                        <td align="left"><?php echo $row_ccaa['ccName']?></td>
                                        <td align="right">
										<?php 
										if($num_register[$row_ccaa['ccDigi']] > 0){
											echo '<a href="?p=labor_vacancy_index&d_ampur_id='.$row_ccaa['ccDigi'].'">'.number_format($num_register[$row_ccaa['ccDigi']]).'</a>';
										}else{
											echo 0;
										}
										?>
										</td>
										<td align="right">
										<?php 
										if($arr_count_position[$row_ccaa['ccDigi']] > 0){
											echo '<a href="?p=labor_vacancy_index&d_ampur_id='.$row_ccaa['ccDigi'].'">'.number_format($arr_count_position[$row_ccaa['ccDigi']]).'</a>';
										}else{
											echo 0;
										}
										?>
										</td>
										<td align="right">
										<?php
										if($arr_sum_qty[$row_ccaa['ccDigi']] > 0){
										 	echo '<a href="?p=labor_vacancy_index&d_ampur_id='.$row_ccaa['ccDigi'].'">'.number_format($arr_sum_qty[$row_ccaa['ccDigi']]).'</a>';
										 }else{
										 	echo 0;
										 }
										 ?>
										</td>
                                        <td align="right"><?php echo (($arrPCExSum[$row_ccaa['ccDigi']][0])?$arrPCExSum[$row_ccaa['ccDigi']][0]:'0.00')?></td>
                                </tr>    
								<?php
								 } 
								 $arrPCExSum['all'][0] += $arrPCExSum[99999999][0];
								 $arrExSumData[99999999] =  (($arrPCExSum[99999999][0])?$arrPCExSum[99999999][0]:'0.00');
								?>     
								   <tr bgcolor="#FFFFFF">
                                        <td align="left">อื่นๆ</td>
                                        <td align="right">
										<?php 
										if($num_register[99999999] > 0){
											echo '<a href="?p=labor_vacancy_index&d_ampur_id=99999999">'.number_format($num_register[99999999]).'</a>';
										}else{
											echo 0;
										}
										?>
										</td>
										<td align="right">
										<?php 
										if($arr_count_position[99999999]>0){
											echo  '<a href="?p=labor_vacancy_index&d_ampur_id=99999999">'.number_format($arr_count_position[99999999]).'</a>';
										}else{
											echo 0;
										}
										?>
										</td>
										<td align="right">
										<?php 
										if($arr_sum_qty[99999999] > 0){
											echo  '<a href="?p=labor_vacancy_index&d_ampur_id=99999999">'.number_format($arr_sum_qty[99999999]).'</a>';
										}else{
											echo 0;
										}
										?>
										</td>
                                        <td align="right"><?php echo (($arrPCExSum[99999999][0])?$arrPCExSum[99999999][0]:'0.00')?></td>
                                </tr>                           
                                <tr bgcolor="#DDDDDD">
                                        <td align="right"><strong>รวม</strong></td>
                                        <td align="right">
										<?php 
										if($num_register['all']>0){
											echo '<a href="?p=labor_vacancy_index&d_ampur_id=">'.number_format($num_register['all']).'</a>';
										}else{
											echo 0;
										}
										?>
										</td>
										<td align="right">
										<?php 
										if($arr_count_position['all']>0){
											echo '<a href="?p=labor_vacancy_index&d_ampur_id=">'.number_format($arr_count_position['all']).'</a>';
										}else{
											echo 0;
										}
										?>
										</td>
										<td align="right">
										<?php
										if($arr_sum_qty['all'] > 0){ 
											echo '<a href="?p=labor_vacancy_index&d_ampur_id=">'.number_format($arr_sum_qty['all']).'</a>';
										}else{
											echo 0;
										}
										?>
										</td>
                                        <td align="right">
										<?php echo number_format($arrPCExSum['all'][0],2);?>
										</td>
                                </tr>
                        </table>
                        <table width="75%" border="0" cellpadding="0" cellspacing="0">
<tr>
                                		<td align="right">
                                        <?				
										$catagory='';
										
										$columntitle='กราฟแสดงสัดส่วนข้อมูลตำแหน่งงานว่าง';
										//echo $catagory;
										$graph_path = "http://202.129.35.106/graphservice/graphservice.php";  //Sapphire Graph
										if($arrExSumData)
										foreach ( $arrExSumData as $Key => $Val ) {
											 if($Key != "99999999"){
												$dataGraph .= $Val.';';
												$catagory .= $Key.';';
											}else{
												 $dataGraph .= $Val.';';
												$catagory .= 'อื่นๆ;';
											}	
										}
										
										$xgraphurl_link = $graph_path."?category=".substr($catagory, 0, strlen($catagory) - 1)."&data1=".substr($dataGraph, 0, strlen($dataGraph) - 1)."&outputstyle=&numseries=1&seriesname=&graphtype=pie&title=$columntitle&xname=&yname=&subtitle=&graphstyle=srd_allvisible_lg.scs&xcontrol=1";
											?>
                                            <a href="<?=$xgraphurl_link?>" target="_blank">[แสดงข้อมูลรูปแบบกราฟ]</a>
                                        </td>
                          </tr>
                  </table>
          </td>
          <td valign="top" width="40%">
          		<table width="100%" border="0" cellpadding="0" cellspacing="0">
                		<tr>
                        		<td align="right">
                                		<a href="#" onclick="window.open('search_labor_vacancy.php','export','toolbar=0,location=0,directories=0,status=0,menubar=0,height=550,width=700,resizeable=1,scrollbars=1'); clearText();"><img src="img/search.png" alt="ค้นหา" title="ค้นหา" width="20" height="20" border="0" align="absmiddle" /></a>
										<a href="#" onclick="window.open('search_labor_vacancy.php','export','toolbar=0,location=0,directories=0,status=0,menubar=0,height=550,width=700,resizeable=1,scrollbars=1'); clearText();"><strong>ค้นหา</strong></a>&nbsp;&nbsp;
                                        <img src="../../images/dash_icon/ico_xls_disabled.png" alt="Excel" title="Excel" width="16" height="16" border="0" />
                                        <img src="../../images/dash_icon/ico_xml_disabled.png" alt="XML" title="XML" width="16" height="16" border="0" />
                                        <img src="../../images/dash_icon/ico_pdf_disabled.png" alt="PDF" title="PDF" width="16" height="16" />&nbsp;
                                </td>
                        </tr>
                        <tr>
                        		<td>
                           		  <table width="100%" border="0" cellpadding="0" cellspacing="2" bgcolor="#E6E6E6" align="center" style="border:1px solid #5595CC;">
                                        		<tr>
                                                		<td align="left"><strong style="text-decoration:underline">เงื่อนไขการค้นหา</strong> &nbsp;&nbsp; <a href="index.php?&amp;p=<?php echo $_GET['p']?>">ล้างค่าการค้นหา</a></td>
</tr>
                                                <tr>
                                                        <td align="left">
															<?php echo ($_GET['start_date_announce'] != "")?'&nbsp;<strong>วันที่ประกาศจาก</strong>  "'.$_GET['start_date_announce'].'"<br/>':"";?>
														  <?php echo ($_GET['end_date_announce'] != "")?'&nbsp;<strong>วันที่ประกาศถึง</strong> : "'.$_GET['end_date_announce'].'"<br/>':"";?>			
														<?php echo ($_GET['company_name'] != "")?'&nbsp;<strong>ชื่อสถานประกอบการ</strong> : "'.$_GET['company_name'].'"<br/>':"";?>
                                                        </td>&nbsp;
</tr>
                                              
                                        </table>
                                </td>
                        </tr>
                </table>
          </td>
        </tr>
</table>
 
 

<br />
		<table width="99%" border="0" align="center" cellpadding="3" cellspacing="1">
				<tr>
						<td width="75%">
                        <?php
						
	 	$rsConn = mysql_db_query($dbname,$strSQL_1);
		$all_row = mysql_num_rows($rsConn);
		$board_row_per_page = 20;
		$total_page = ceil($all_row/$board_row_per_page);
		$page = ($_GET['page'])?$_GET['page']:1;
		$page = ($page > $total_page)?$total_page:$page;
		$page = ($page <= 0)?1:$page;
		$limit_start = ($page==1)?0:(($page*$board_row_per_page)-$board_row_per_page);
		$limit_end = $board_row_per_page;
		if($View==''){
			$strSQL_1 .= " LIMIT ".$limit_start.", ".$limit_end;
			$num = $limit_start ;
		}
		
		if(isset($cols)&&isset($sort)){
			$solink="&cols=$cols&sort=$sort";
		}
		
		$text_search =  "";
		$prev_page = $page - 1; $prev_page = ($prev_page <= 1)?1:$prev_page;
		$prev = "self.location='".$PHP_SELF."?".$strSearch.$text_search."&search=$search&page=$prev_page$link$solink'";
		$next_page = $page + 1; $next_page = ($next_page >= $total_page)?$total_page:$next_page;
		$next = "self.location='".$PHP_SELF."?".$strSearch.$text_search."&search=$search&page=$next_page$link$solink'";
		
		$prev_Tenpage=$page-$board_row_per_page;$prev_Tenpage=($prev_Tenpage<= 1)?1:$prev_Tenpage;
		$prevTen = "self.location='".$PHP_SELF."?".$strSearch.$text_search."&search=$search&page=$prev_Tenpage$link$solink'";
		$nextTenPage=$page+$board_row_per_page;$next_TenPage=($next_TenPage >= $total_page)?$total_page:$next_TenPage;
		$nextTen = "self.location='".$PHP_SELF."?".$strSearch.$text_search."&search=$search&page=$nextTenPage$link$solink'";
	?>
	<? if($View==""){$Klink="?".$strSearch.$text_search."&View=All"; $CSh="ข้อมูลทั้งหมด"; $Klink2="?".$strSearch.$text_search."&View=";}else{$Klink="?".$strSearch.$text_search."&View=";$CSh="ข้อมูล ".$board_row_per_page." รายการล่าสุด";$Klink2="?".$strSearch.$text_search."&View=All";}?>
	ทั้งหมด <b> <font color="#CC0000">
	<?=number_format($all_row);?>
	</font> </b> รายการ
	<? if($View==""){?>
	แบ่งเป็น <b><font color="#0033CC">
	<?=number_format($total_page);?>
	</font></b> หน้า
	<? }?>
	&nbsp;&nbsp;<a href="<?=$Klink?>"><img src="img/Search-Add.gif" alt="<?=$CSh?>" width="16" height="16" border="0" /></a>&nbsp;&nbsp;&nbsp;&nbsp;
		  <? if($View==''){?>
			<?  if($page==1){?>
			<img src="img/page_div_icon/xFirst.gif" />
			<? }else{?>
			<img src="img/page_div_icon/First.gif" align="absmiddle" border="0" width="10" height="12"  onclick="<?=$prevTen;?>" onMouseOver="style.cursor='hand';"/>
			<? }?>
	&nbsp;
	<?  if($page==1){?>
	<img src="img/page_div_icon/xPrevious.gif" />
	<? }else{?>
	<img src="img/page_div_icon/Previous.gif" align="absmiddle" border="0" width="7" height="12"  onclick="<?=$prev;?>" onMouseOver="style.cursor='hand';"/>
	<? }?>
	<?php
	$board_link_num = $board_row_per_page;
	$ii = 1;
	if ( $board_link_num > $total_page ){
		$loop_page = $total_page;
	
	} else {
		$bx = ceil($board_link_num / 2);
		$pp = $page - $bx;
		$pn = $page + $bx;
		$loop_page = $pn;
		$ii = $pp;
		if ( $total_page <= $loop_page ) {
			$loop_page = $total_page;
			$ii = $loop_page - ($board_link_num -1);
		}
		if ( $ii < 1 ) {
			$ii = 1;
			$loop_page = $ii + ($board_link_num -1);
		}
	}
	
	for($i=$ii;$i<=$loop_page;$i++){
		if ( $i==$page || !$page ) {
			$txt = '<b style="color:#0033CC;">'.$i.'</b>';
		} else {
			$txt = $i;
	
		}
	?>
	<a href="<?=$PHP_SELF;?>?Sort=<?=$Sort;?>&search=<?=$search?>&<?=$text_search?>&page=<?=$i;?><?=$strSearch;?>"><?=$txt;?></a>
	<?
	} # for
	?>
	<? if($page==$loop_page){?>
	<img src="img/page_div_icon/xNext.gif" />
	<? }else{?>
	<img src="img/page_div_icon/Next.gif" align="absmiddle" border="0" width="7" height="12" onClick="<?=$next;?>" onMouseOver="style.cursor='hand';"/>
	<? }?>
	&nbsp;
	<? if($page==$loop_page){?>
	<img src="img/page_div_icon/xLast.gif" />

	<? }else{?>
	<img src="img/page_div_icon/Last.gif" align="absmiddle" border="0" width="10" height="12" onClick="<?=$nextTen;?>" onMouseOver="style.cursor='hand';"/>
	<? 
		} 
	}#End View=
		?>
                        </td>				
                        <td width="25%" align="right">
                        
                        <a href="?p=labor_vacancy_keyin"><img src="images/add.png" alt="ขึ้นทะเบียนข้อมูลตำแหน่งงานว่าง" title="ขึ้นทะเบียนข้อมูลตำแหน่งงานว่าง" border="0" align="absmiddle" /></a>
                  <a href="?p=labor_vacancy_keyin">ขึ้นทะเบียนข้อมูลตำแหน่งงานว่าง</a></td>
				</tr>
		</table>
		<table width="99%" border="0" align="center" bgcolor="#CCCCCC" cellpadding="3" cellspacing="1">
				<tr class="bg_th">
				  <td width="4%"><strong>ลำดับที่</strong></td>
				  <td width="6%"><strong>วันที่ประกาศ</strong></td>
				  <td width="11%"><strong>ชื่อสถานประกอบการ</strong></td>
				  <td width="11%"><strong>หมวดตำแหน่งงาน</strong></td>
				  <td width="7%"><strong>จำนวนตำแหน่ง (ตำแหน่ง)</strong></td>
				  <td width="7%"><strong>จำนวน (อัตรา)</strong></td>
				  <td width="8%"><strong>อำเภอ</strong></td>
				  <td width="7%"><strong>การจัดการ</strong></td>
		  </tr>
          
          <?
		$rsConn_1 = mysql_db_query($dbname,$strSQL_1);
		$i_1=0;	
		while ( $Result_1 = mysql_fetch_assoc($rsConn_1)) {
				$i_1++;
				
				$rowNumb = ($i_1+($board_link_num*$page)-$board_link_num);
		  ?>
				<tr bgcolor="#FFFFFF" onmouseover="this.style.backgroundColor='#dbf2ae'" onmouseout="this.style.backgroundColor='#FFFFFF'">
						<td align="center" valign="top"><?php echo $rowNumb?></td>
						<td align="center" valign="top"><?php echo dateFormat($Result_1['date_announce'],'thaidot')?></td>
						<td align="left" valign="top"><?php echo searchReplace($_GET['company_name'],$Result_1['company_name'])?></td>
						<td align="left" valign="top">
						<?php
						$sql_position = "SELECT
												labor_vacancy.position_id,
												labor_master_position.position_name
												FROM
												labor_vacancy
												Inner Join labor_master_position ON labor_vacancy.position_id = labor_master_position.position_type_id
												WHERE labor_vacancy.vacancy_register_id='".$Result_1['vacancy_register_id']."'
												";
						$query_position = mysql_db_query($dbname,$sql_position);
						while ( $row_position = mysql_fetch_assoc($query_position)) {
							getMainPosition($row_position['position_id']);
						}
						?>
						</td>
                        <td align="center" valign="top"><?php echo $Result_1['count_position']?></td>
						<td align="center" valign="top"><?php echo $Result_1['sum_qty']?></td>
						<td align="left" valign="top"><?php echo ccName($Result_1['d_ampur_id'])?></td>			
                        <td align="center" valign="top">
                                <a href="?p=labor_vacancy_keyin&vacancy_register_id=<?=$Result_1['vacancy_register_id']?>&edit=1"><img src="../../images/dash_icon/ico_edit.png" alt="แก้ไขข้อมูล" title="แก้ไขข้อมูล" width="16" height="16" border="0" align="middle" /></a>&nbsp;
                                <a href="?p=labor_vacancy_index&runid_del=<?=$Result_1['vacancy_register_id']?>" onClick="return Conf(this)"><img src="../../images/dash_icon/ico_del.png" alt="ลบข้อมูล" title="ลบข้อมูล" width="16" height="16" border="0" align="middle"  style="cursor:pointer;"/></a>
                        </td>
				</tr>
                <? }?>     				
		</table>
 <?
 $time_e 	= getmicrotime();
$stime		= number_format($time_e - $time_start,12);
 ?>
<br />
 <!--<p><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<strong>หมายเหตุ</strong></span></p>-->
 <table width="99%" border="0" cellpadding="0" cellspacing="0" align="center">
 		<tr>
        		<td width="20%" align="left">&nbsp;&nbsp;&nbsp;<!--<strong><span class="style1">***</span> หมายเหตุ:</strong>--></td>
          <td align="right">ใช้เวลาในการประมวลผล <?=$stime?> วินาที</td>
        </tr>
 </table>
 
<br />
<form name="form2" id="form2" method="get" >
	<input name="p" id="p" type="hidden"   value="<?=$_GET['p']?>" size="100"/>
	<input name="start_date_announce" id="start_date_announce" type="hidden"   value="" />
	<input name="end_date_announce" id="end_date_announce" type="hidden"   value="" />
	<input name="company_name" id="company_name" type="hidden"   value="" />
</form>

<script language="javascript">
	function clearText(){
		document.getElementById("code").value = "";
		document.getElementById("fname").value = "";
		document.getElementById("ampur").value = "";
		document.getElementById("tambol").value = "";
	   document.getElementById("muban").value = "";
	   document.getElementById("type_id").value = "";
	   document.getElementById("fyear").value = "";
	   document.getElementById("eyear").value = "";
	   document.getElementById("location").value = "";
	   document.getElementById("import_status").value = "";
	 }
</script>
</body>
</html>

Anon7 - 2021