|
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 : |
<? 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");
$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}
.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:#305086;
font-weight:bold;
color:#FFFFFF;
text-align:center;
}
</style>
<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/pauper_surway/ajax.pauper_surway.php';
</script>
<script src="../../common/tooltip/tooltip_personal.js"></script>
<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>
</head>
<body>
<?
/*function searchReplace($key="", $data = ""){
$arrS = explode(" ",$key);
$search = array();
$replace = array();
if(is_array($arrS)){
foreach($arrS as $value){
$replace[] = '<span style="background:#FFCC99;">'.$value.'</span>';
}
}else{
$replace[] = '<span style="background:#FFCC99;">'.$key.'</span>';
}
$search[] = $key;
$data_replace = str_replace($search, $replace, $data);
return $data_replace;
}*/
if($_GET['runid_del']){
mysql_query("DELETE FROM pathumthani_integration.pauper_surway_general WHERE run_id='".$_GET['runid_del']."' ");
mysql_query("DELETE FROM pathumthani_integration.pauper_surway_header WHERE run_id='".$_GET['runid_del']."' ");
mysql_query("DELETE FROM pathumthani_integration.pauper_surway_leader WHERE run_id='".$_GET['runid_del']."' ");
mysql_query("DELETE FROM pathumthani_integration.pauper_surway_file WHERE run_id='".$_GET['runid_del']."' ");
mysql_query("DELETE FROM pathumthani_integration.pauper_surway_expense WHERE run_id='".$_GET['runid_del']."' ");
mysql_query("DELETE FROM pathumthani_integration.pauper_surway_develop WHERE run_id='".$_GET['runid_del']."' ");
}
?>
<strong style="color:#000033; font-size:18px;"><img src="images/unpublish_f2.png" align="absmiddle" border="0"/>ทะเบียนข้อมูลตำแหน่งงานว่าง</strong>
<?
$strSearch="";
$strSQL_1 = "SELECT
pauper_surway_header.run_id,
pauper_surway_header.surway_id,
pauper_surway_header.level,
pauper_surway_header.village_name,
pauper_surway_header.mun_id,
pauper_surway_header.ban_id,
pauper_surway_header.moo,
pauper_surway_header.soi,
pauper_surway_header.road,
pauper_surway_header.aumpher_id,
pauper_surway_header.tambol_id,
pauper_surway_header.province_id,
pauper_surway_header.name_meeting,
pauper_surway_header.lastname_meeting,
pauper_surway_header.date_surway,
pauper_surway_general.run_id,
pauper_surway_general.type_id,
pauper_surway_general.type_area,
pauper_surway_general.salary,
pauper_surway_general.expense,
pauper_surway_general.debt,
pauper_surway_general.poverty_reg,
pauper_surway_general.detail_poverty_reg,
pauper_surway_general.detail_poverty_reg2
FROM
pauper_surway_header
Inner Join pauper_surway_general ON pauper_surway_header.run_id = pauper_surway_general.run_id
WHERE
pauper_surway_header.run_id IS NOT NULL ";
if($_GET['surway_id']){
$strSQL_1.=" and pauper_surway_header.surway_id LIKE('%".$_GET['surway_id']."%') ";
$strSearch.="&surway_id=".$_GET['surway_id'];
}
if($_GET['name_meeting']){
$strSQL_1.=" and pauper_surway_header.name_meeting LIKE('%".$_GET['name_meeting']."%') ";
$strSearch.="&name_meeting=".$_GET['name_meeting'];
}
if($_GET['village_name']){
$strSQL_1.=" and pauper_surway_header.village_name LIKE('%".$_GET['village_name']."%') ";
$strSearch.="&village_name=".$_GET['village_name'];
}
/*if($_GET['ampur']){
$sqlAmpur=" SELECT ccaa.ccDigi,ccaa.ccName,ccaa.ccType FROM ccaa WHERE ccaa.ccType = 'Aumpur' AND ccaa.ccDigi LIKE '".substr($_GET['ampur'],0,4)."%' ";
$rsAmpur=mysql_db_query($dbname,$sqlAmpur);
$resultAmpur=mysql_fetch_assoc($rsAmpur);
$strSQL_1.=" and ampur like '%".str_replace('อำเภอ','',$resultAmpur['ccName'])."%' ";
$strSearch.="&ur=".$resultAmpur['ccName'];
}*/
/* if($_GET['tambol']){
$sqlTambol=" SELECT ccaa.ccDigi,ccaa.ccName,ccaa.ccType FROM ccaa WHERE ccaa.ccType = 'Tamboon' AND ccaa.ccDigi LIKE '".substr($_GET['tambol'],0,6)."%' ";
$rsTambol=mysql_db_query($dbname,$sqlTambol);
$resultTambol=mysql_fetch_assoc($rsTambol);
$strSQL_1.=" and tambol like '%".str_replace('ตำบล','',$resultTambol['ccName'])."%' ";
$strSearch.="&tambol=".$resultTambol['ccName'];
}
if($_GET['muban']){
$strSQL_1.=" and muban LIKE('%".$_GET['muban']."%') ";
$strSearch.="&muban=".$_GET['muban'];
}
if($_GET['type_id']){
$sqlTypeID1=" SELECT * FROM industry_type WHERE type_id='".$_GET['type_id']."' ";
$rsTypeID1=mysql_db_query($dbname,$sqlTypeID1);
$resultTypeID1=mysql_fetch_assoc($rsTypeID1);
$sqlTypeID=" SELECT * FROM industry_type WHERE parent_id='".$resultTypeID1['runid']."' ";
$rsTypeID=mysql_db_query($dbname,$sqlTypeID);
$str_no1='';
while($resultTypeID=mysql_fetch_assoc($rsTypeID)){
$str_no1.="'".$resultTypeID['type_id']."'".',';
}
$str_no1=substr($str_no1,0,strlen($str_no1)-1);
if($str_no1==''){
$strSQL_1.=" and type_id ='-999' ";
}else{
$strSQL_1.=" and type_id IN($str_no1) ";
}
$strSearch.="&type_id=".$_GET['type_id'];
}
if($_GET['fyear']){
$strSQL_1.=" and fyear = '".$_GET['fyear']."' ";
$strSearch.="&fyear=".$_GET['fyear'];
}
if($_GET['eyear']){
$strSQL_1.=" and eyear = '".$_GET['eyear']."' ";
$strSearch.="&eyear=".$_GET['eyear'];
}*/
if($_GET['public_amphur']){
$strSQL_1.=" and pauper_surway_header.aumpher_id = '".($_GET['public_amphur'])."' ";
$strSearch.="&public_amphur=".($_GET['public_amphur']);
}
if($_GET['public_tambol']){
$strSQL_1.=" and pauper_surway_header.tambol_id = '".($_GET['public_tambol'])."' ";
$strSearch.="&public_tambol=".($_GET['public_tambol']);
}
if($_GET['public_Mun']){
$strSQL_1.=" and pauper_surway_header.mun_id = '".($_GET['public_Mun'])."' ";
$strSearch.="&public_Mun=".($_GET['public_Mun']);
}
if($_GET['public_Subtambol']){
$strSQL_1.=" and pauper_surway_header.village_name = '".($_GET['public_Subtambol'])."' ";
$strSearch.="&public_Subtambol=".($_GET['public_Subtambol']);
}
if($_GET['type_key']){
$strSQL_1.=" and pauper_surway_header.type_key = '".($_GET['type_key'])."' ";
$strSearch.="&type_key=".($_GET['type_key']);
}
$strSQL_1.=" GROUP BY pauper_surway_header.run_id ORDER BY pauper_surway_header.run_id DESC ";
//echo $strSQL_1;
?>
<br />
<br />
<table width="99%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center"><strong style="color:#000000; font-size:14px;">ทะเบียนข้อมูลตำแหน่งงานว่าง จังหวัดปทุมธานี</strong></td>
</tr>
<tr>
<td align="center"><strong style="color:#000000; font-size:12px;">ข้อมูล ณ วันที่ <?=dateFormat(date('Y-m-d'),'thaidot')?></strong></td>
</tr>
</table>
<br />
<table width="99%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" align="center" width="60%"><table width="60%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr class="bg_th">
<td align="center"><strong>ระดับความเร่งด่วน</strong></td>
<td align="center"><strong>จำนวน</strong></td>
<td align="center"><strong>ร้อยละ</strong></td>
</tr>
<?
$strSqlHeader="
SELECT
SUM(if(level='1',1,0)) AS NUM_LESS,
SUM(if(level='2',1,0)) AS NUM_MID,
SUM(if(level='3',1,0)) AS NUM_MORE
FROM pauper_surway_header
WHERE run_id IS NOT NULL
"; //(year(now())+543)
//echo $strSqlYear;
if($_GET['id']==''){
//$strSqlHeader.=" aumpher_id='".$Result_1['ccDigi']."' ";
}else{
if(strlen($_GET['id'])<=3){
$strSqlHeader.=" and mun_id='".$_GET['id']."' ";
}else{
if(strlen(cutZero($_GET['id']))==4){
$strSqlHeader.=" and aumpher_id='".$_GET['id']."' ";
}else if(strlen(cutZero($_GET['id']))==6){
$strSqlHeader.=" and tambol_id='".$_GET['id']."' ";
}
}
}
//$strSqlHeader.=" ";
//echo $strSqlHeader;
$rsHeader = mysql_db_query($dbname,$strSqlHeader);
$Result_Header = mysql_fetch_assoc($rsHeader);
$totalALL=$Result_Header['NUM_LESS']+$Result_Header['NUM_MID']+$Result_Header['NUM_MORE'];
if($totalALL==0){
$percen_less=0;
$percen_mid=0;
$percen_more=0;
$percen_all=0;
}else{
$percen_less=($Result_Header['NUM_LESS']*100)/$totalALL;
$percen_mid=($Result_Header['NUM_MID']*100)/$totalALL;
$percen_more=($Result_Header['NUM_MORE']*100)/$totalALL;
$percen_all=($totalALL*100)/$totalALL;
}
$data1='';
$data1.=$Result_Header['NUM_LESS'].';'.$Result_Header['NUM_MID'].';'.$Result_Header['NUM_MORE'];
//$seriesname.='จำพวก '.$Result_Class['class_id'].';';
?>
<tr bgcolor="#FFFFFF">
<td align="left"><strong>อำเภอเมืองปทุม</strong></td>
<td align="center">2<a href="report_surway_want_family.php?level=1&id=<?=$_GET['id']?>" target="_blank"> </a></td>
<td align="center">40.0</td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="left"><strong>อำเภอคลองหลวง</strong></td>
<td align="center">3<a href="report_surway_want_family.php?level=2&id=<?=$_GET['id']?>" target="_blank"> </a></td>
<td align="center">60.0</td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="left"><strong>อำเภอธัญบุรี</strong></td>
<td align="center">0<a href="report_surway_want_family.php?level=3&id=<?=$_GET['id']?>" target="_blank"> </a></td>
<td align="center">0</td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="left"><strong>อำเภอหนองเสือ</strong></td>
<td align="center">0<a href="report_surway_want_family.php?level=3&id=<?=$_GET['id']?>" target="_blank"> </a></td>
<td align="center">0</td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="left"><strong>อำเภอลาดหลุมแก้ว</strong></td>
<td align="center">0<a href="report_surway_want_family.php?level=3&id=<?=$_GET['id']?>" target="_blank"> </a></td>
<td align="center">0</td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="left"><strong>อำเภอลำลูกกา</strong></td>
<td align="center">0<a href="report_surway_want_family.php?level=3&id=<?=$_GET['id']?>" target="_blank"> </a></td>
<td align="center">0</td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="left"><strong>อำเภอสามโคก</strong></td>
<td align="center">0<a href="report_surway_want_family.php?level=3&id=<?=$_GET['id']?>" target="_blank"> </a></td>
<td align="center">0</td>
</tr>
<tr bgcolor="#DDDDDD">
<td align="left"><strong>รวม</strong></td>
<td align="center">5<a href="report_surway_want_family.php?level=&id=<?=$_GET['id']?>" target="_blank"> </a></td>
<td align="center">100.0</td>
</tr>
</table>
<table width="60%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="right">
<?
$catagory='อำเภอเมืองปทุม;อำเภอคลองหลวง;อำเภอธัญบุรี;อำเภอหนองเสือ;อำเภอลาดหลุมแก้ว;อำเภอลำลูกกา; อำเภอสามโคก';
//$columntitle="รายงานข้อมูลโรงงานอุตสาหกรรมจำแนกตามจำพวก";
$columntitle='กราฟแสดงจำนวนผู้ถูกเลิกในแต่ละอำเภอ';
//echo $catagory;
$graph_path = "http://202.129.35.106/graphservice/graphservice.php"; //Sapphire Graph
//$catagory = 'ระดับความรุนแรงน้อย;ระดับความรุนแรงปานกลาง;ระดับความรุนแรงมาก';
/*$w1=375;
$h1=188;*/
//$w1=400;
//$h1=200;
$countData=count($data);
$dataGraph='';
for($cD=1;$cD<=$countData;$cD++){
$dataGraph.='&data'.$cD.'='.$data[$cD];
}
$data1='2;3;0;0;0;0;0';
$xgraphurl = $graph_path ."?category=$catagory"."&data1="."$data1"."&outputstyle=&numseries=1&seriesname=&graphtype=pie&title=$columntitle&xname=&yname=&subtitle=&graphstyle=srd_allvisible_lg.scs";
$xgraphurl_link = $graph_path ."?category=$catagory"."&data1="."$data1"."&outputstyle=&numseries=1&seriesname=&graphtype=pie&title=$columntitle&xname=&yname=&subtitle=&graphstyle=srd_allvisible_lg.scs&xcontrol=1";//srd_sf_004
?>
<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.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.php','export','toolbar=0,location=0,directories=0,status=0,menubar=0,height=550,width=700,resizeable=1,scrollbars=1'); clearText();"><strong>ค้นหา</strong></a>
<a href="xls_export.php"><img src="img/xls_logo.gif" alt="Excel" title="Excel" width="16" height="16" border="0" align="absmiddle" /></a>
<img src="img/pdf_b.gif" alt="PDF" title="PDF" width="16" height="16" border="0" align="absmiddle" />
<a href="xml_export.php"><img src="img/xml.gif" alt="XML" title="XML" width="16" height="16" border="0" align="absmiddle" /></a>
</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" style="text-decoration:underline">
<strong>เงื่อนไขการค้นหา</strong>
</td>
</tr>
<tr>
<td align="left"><?php echo ($_GET['surway_id'] != "")?' <strong>รหัสเเบบสำรวจ</strong> "'.$_GET['surway_id'].'"<br/>':"";?>
<?php echo ($_GET['name_meeting'] != "")?' <strong>ชื่อผู้ให้ข้อมูล</strong> : "'.$_GET['name_meeting'].'"<br/>':"";?>
<?
if($_GET['public_amphur'] != ""){
$strSQL_ampur = "SELECT ccaa.ccDigi,ccaa.ccName,ccaa.ccType
FROM ccaa
where ccaa.ccType = 'Aumpur' AND ccaa.ccDigi ='".$_GET['public_amphur']."'
";
$rsConn_ampur = mysql_db_query($dbname,$strSQL_ampur);
$Result_ampur = mysql_fetch_assoc($rsConn_ampur);
echo ' <strong>อำเภอ</strong> = "'.$Result_ampur['ccName'].'"<br/>';
}//?'ปี พ.ศ. = "'.$_GET['year'].'"<br/>':"";
?>
<?
if($_GET['public_tambol'] != ""){
$strSQL_tambol = "SELECT ccaa.ccDigi,ccaa.ccName,ccaa.ccType
FROM ccaa
where ccaa.ccType = 'Tamboon' AND ccaa.ccDigi ='".$_GET['public_tambol']."'
";
$rsConn_tambol = mysql_db_query($dbname,$strSQL_tambol);
$Result_tambol= mysql_fetch_assoc($rsConn_tambol);
echo ' <strong>ตำบล</strong> = "'.$Result_tambol['ccName'].'"<br/>';
}//?'ปี พ.ศ. = "'.$_GET['year'].'"<br/>':"";
?>
<?
if($_GET['public_Mun'] != ""){
$strSQL_Mun= "ccaa_pathumthani.ccDigi,
ccaa_pathumthani.ccName,
ccaa_pathumthani.ccType,
ccaa_pathumthani.ccMoo,
ccaa_pathumthani.ccMun,
ccaa_municipality.municipality_name
FROM
ccaa_pathumthani
Inner Join ccaa_municipality ON ccaa_pathumthani.ccMun = ccaa_municipality.municipality_id
WHERE ccDigi ='".$_GET['public_tambol']."' AND ccMun='".$_GET['public_Mun']."'
GROUP BY ccMun
";
$rsConn_Mun = mysql_db_query($dbname,$strSQL_Mun);
$Result_Mun= mysql_fetch_assoc($rsConn_Mun);
echo ' <strong>เทศบาล</strong> = "'.$Result_Mun['municipality_name'].'"<br/>';
}//?'ปี พ.ศ. = "'.$_GET['year'].'"<br/>':"";
?>
<?
if($_GET['public_Subtambol'] != ""){
$strSQL_Subtambol= "ccaa_pathumthani.ccDigi,
ccaa_pathumthani.ccName,
ccaa_pathumthani.ccType,
ccaa_pathumthani.ccMoo,
ccaa_pathumthani.ccMun,
FROM
ccaa_pathumthani
WHERE ccDigi ='".$_GET['public_Subtambol']."' AND ccType='Village'
";
$rsConn_Subtambol = mysql_db_query($dbname,$strSQL_Subtambol);
$Result_Subtambol= mysql_fetch_assoc($rsConn_Subtambol);
echo ' <strong>ชุมชน/หมู่บ้าน</strong> = "'.$Result_Mun['ccName'].'"<br/>';
}//?'ปี พ.ศ. = "'.$_GET['year'].'"<br/>':"";
?>
<?
if($_GET['type_id'] != ""){
$strSQL_type = "SELECT *
FROM industry_type
where type_id='".$_GET['type_id']."'
";
$rsConn_type = mysql_db_query($dbname,$strSQL_type);
$Result_type= mysql_fetch_assoc($rsConn_type);
echo ' <strong>หมวดอุตสาหกรรม</strong> = "'.$Result_type['type_name'].'"<br/>';
}//?'ปี พ.ศ. = "'.$_GET['year'].'"<br/>':"";
?>
<?
if($_GET['type_key'] != ""){
$strImport='';
if($_GET['import_status']=="1"){
$strImport='ข้อมูลจากการ key';
}else if($_GET['import_status']=="2"){
$strImport='ข้อมูลจากการ import ไฟล์ ';
}
echo ' <strong>การนำเข้าข้อมูล</strong> = "'.$strImport.'"<br/>';
}//?'ปี พ.ศ. = "'.$_GET['year'].'"<br/>':"";
?>
</td>
</tr>
<?php /*?><tr align="right">
<td height="20"><br />
โรงงานอุตสาหกรรมทั้งหมด <strong><?=number_format($Rows)?></strong> โรง
(ใช้เวลาในการประมวลผลก่อนการแสดง <strong><?=$stime?></strong> วินาที)
</td>
</tr><?php */?>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<br /><br />
<table width="99%" border="0" align="center" cellpadding="3" cellspacing="1">
<tr>
<td width="75%">
<?php
//echo "".$strSQL_1;
$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> หน้า
<? }?>
<a href="<?=$Klink?>"><img src="img/Search-Add.gif" alt="<?=$CSh?>" width="16" height="16" border="0" /></a>
<? 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';"/>
<? }?>
<? 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>$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';"/>
<? }?>
<? 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_position_keyin"><img src="images/add.png" alt="เพิ่มคนว่างงาน" title="เพิ่มคนว่างงาน" border="0" align="absmiddle" /><a href="?p=labor_position_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%">ลำดับ</td>
<td width="16%">ชื่อบริษัท</td>
<td width="11%"><strong>อำเภอ</strong></td>
<td width="25%">ที่ตั้ง</td>
<td width="15%">เบอร์โทรศัพท์</td>
<td width="12%">วันที่ประกาศ</td>
<td width="17%"><strong>การจัดการ</strong></td>
</tr>
<?
/*$strSQL_1 = "SELECT
industry_register.runid,
industry_register.type_id,
industry_register.code,
industry_register.fact_class,
industry_register.fname,
industry_register.job,
industry_register.import_status
FROM industry_register
GROUP BY industry_register.update_time
";*/
//echo $strSQ;
$rsConn_1 = mysql_db_query($dbname,$strSQL_1);
$i_1=0;
/*while ( $Result_1 = mysql_fetch_assoc($rsConn_1)) {
$i_1++;
$strSQL_2 = "SELECT count(run_id) as runid FROM pauper_surway_family WHERE run_id='".$Result_1['surway_id']."' ";
$rsConn_2 = mysql_db_query($dbname,$strSQL_2);
$Result_2 = mysql_fetch_assoc($rsConn_2);
$strSQL_3 = "SELECT * FROM pauper_surway_home WHERE home_id='".$Result_1['type_id']."' "; //ประเภทที่อยุ่อาศัย
$rsConn_3 = mysql_db_query($dbname,$strSQL_3);
$Result_3 = mysql_fetch_assoc($rsConn_3);
$strSQL_4 = "SELECT * FROM pauper_surway_live WHERE live_id='".$Result_1['type_area']."' ";//ประเภทที่ดิน
$rsConn_4 = mysql_db_query($dbname,$strSQL_4);
$Result_4 = mysql_fetch_assoc($rsConn_4);
$rowNumb = ($i_1+($board_link_num*$page)-$board_link_num);
?>
<? if($Result_1['level']=="4") {
$style = "background: -moz-linear-gradient(left, #66FF33, #FFFFFF); background: -webkit-gradient(linear, left top, right top, from(#66FF33), to(#FFFFFF)); filter: progid:DXImageTransform.Microsoft.Gradient(StartColorStr='#66FF33', EndColorStr='#FFFFFF', GradientType=1);";
}
else if ($Result_1['level']=="3"){
// $color='#FF3366';
$style = "background: -moz-linear-gradient(left, #FF3300, #FFFFFF); background: -webkit-gradient(linear, left top, right top, from(#B50000), to(#FFFFFF)); filter: progid:DXImageTransform.Microsoft.Gradient(StartColorStr='#B50000', EndColorStr='#FFFFFF', GradientType=1);";
//$style ="background-image:url(images/type3.jpg);";
}else if($Result_1['level']=="2"){
// $color='#FF9900';
$style = "background: -moz-linear-gradient(left, #FF9900, #FFFFFF); background: -webkit-gradient(linear, left top, right top, from(#FF9900), to(#FFFFFF)); filter: progid:DXImageTransform.Microsoft.Gradient(StartColorStr='#FF9900', EndColorStr='#FFFFFF', GradientType=1);";
//$style ="background-image:url(images/type2.jpg);";
}else if($Result_1['level']=="1"){
// $color='#FFFF99';
$style = "background: -moz-linear-gradient(left, #FFFF99, #FFFFFF); background: -webkit-gradient(linear, left top, right top, from(#FFFF99), to(#FFFFFF)); filter: progid:DXImageTransform.Microsoft.Gradient(StartColorStr='#FFFF99', EndColorStr='#FFFFFF', GradientType=1);";
// $style ="background-image:url(images/type1.jpg);";
} else {
$style ="#FFFFFF";
}*/?>
<tr bgcolor="#FFFFFF">
<td align="center" style="<?=$style?>">1</td>
<?php /*?><td align="left"><?=searchReplace($Result_4['type_name'],$Result_3['type_name'])?></td><?php */?>
<?php /*?><td align="left"><?=$Result_1['job']?></td><?php */?>
<td align="left">บริษัท อะโกร จำกัด</td>
<td align="left">เมืองปทุมธานี</td>
<?php /*?><td align="center"><?
if($Result_1['import_status']=='1'){
echo '<img src="img/contract.png" alt="การนำเข้าข้อมูลจากการ key" title="การนำเข้าข้อมูลจากการ key" width="16" height="16" border="0" align="absmiddle" />';
}else if($Result_1['import_status']=='2'){
echo '<img src="img/icon-briefcase.png" alt="การนำเข้าข้อมูลจากการ import file XML" title="การนำเข้าข้อมูลจากการ import file XML" width="16" height="16" border="0" align="absmiddle" />';
}else if($Result_1['import_status']=='3'){
echo '<img src="img/import1.png" alt="การนำเข้าข้อมูลจากการ import file EXCEL" title="การนำเข้าข้อมูลจากการ import file EXCEL" width="16" height="16" border="0" align="absmiddle" />';
}else if($Result_1['import_status']=='4'){
echo '<img src="img/pin_red.png" alt="การนำเข้าข้อมูลโรงงานที่เลิกกิจการ" title="การนำเข้าข้อมูลโรงงานที่เลิกกิจการ" width="16" height="16" border="0" align="absmiddle" />';
}
?></td><?php */?>
<td align="left">156/11 ม.5 ต.บางกรอก อำเภอเมืองปทุมธานี</td>
<td align="center">025-354656</td>
<td align="center">12-05-2553</td>
<td align="center">
<a href="form_surway_preview.php?runid=<?=$Result_1['run_id']?>&view=1"><img src="img/Preview-icon.png" alt="ดูข้อมูล" title="ดูข้อมูล" width="16" height="16" border="0" align="absmiddle" /></a>
<a href="form_surway.php?runid=<?=$Result_1['run_id']?>&code=<?=$Result_1['code']?>&edit=1"><img src="img/icon-write.png" alt="แก้ไข" title="แก้ไข" width="16" height="16" border="0" align="absmiddle" /></a>
<a href="" onClick="return Conf(this)"><img src="img/icon-delete.png" alt="ลบ" title="ลบ" width="16" height="16" border="0" align="absmiddle" /></a> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="center" style="<?=$style?>">2</td>
<td align="left">บริษัท นิ่มซี่เส็ง</td>
<?php /*?><td align="left"><?=searchReplace($Result_4['type_name'],$Result_3['type_name'])?></td><?php */?>
<?php /*?><td align="left"><?=$Result_1['job']?></td><?php */?>
<td align="left">คลองหลวง</td>
<?php /*?><td align="center"><?
if($Result_1['import_status']=='1'){
echo '<img src="img/contract.png" alt="การนำเข้าข้อมูลจากการ key" title="การนำเข้าข้อมูลจากการ key" width="16" height="16" border="0" align="absmiddle" />';
}else if($Result_1['import_status']=='2'){
echo '<img src="img/icon-briefcase.png" alt="การนำเข้าข้อมูลจากการ import file XML" title="การนำเข้าข้อมูลจากการ import file XML" width="16" height="16" border="0" align="absmiddle" />';
}else if($Result_1['import_status']=='3'){
echo '<img src="img/import1.png" alt="การนำเข้าข้อมูลจากการ import file EXCEL" title="การนำเข้าข้อมูลจากการ import file EXCEL" width="16" height="16" border="0" align="absmiddle" />';
}else if($Result_1['import_status']=='4'){
echo '<img src="img/pin_red.png" alt="การนำเข้าข้อมูลโรงงานที่เลิกกิจการ" title="การนำเข้าข้อมูลโรงงานที่เลิกกิจการ" width="16" height="16" border="0" align="absmiddle" />';
}
?></td><?php */?>
<td align="left">156/11 ม.5 ต.บางกรอก อำเภอเมืองปทุมธานี</td>
<td align="center">025-856435</td>
<td align="center">12-05-2553</td>
<td align="center">
<?php /*?><a href="form_surway_preview.php?runid=<?=$Result_1['run_id']?>&view=1"></a><?php */?><img src="img/Preview-icon.png" alt="ดูข้อมูล" title="ดูข้อมูล" width="16" height="16" border="0" align="absmiddle" />
<?php /*?><a href="form_surway.php?runid=<?=$Result_1['run_id']?>&code=<?=$Result_1['code']?>&edit=1"></a><?php */?><img src="img/icon-write.png" alt="แก้ไข" title="แก้ไข" width="16" height="16" border="0" align="absmiddle" />
<?php /*?><a href="" onClick="return Conf(this)"></a><?php */?><img src="img/icon-delete.png" alt="ลบ" title="ลบ" width="16" height="16" border="0" align="absmiddle" /> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="center" style="<?=$style?>">3</td>
<td align="left">บริษัท แอมฟาโกลด์</td>
<?php /*?><td align="left"><?=searchReplace($Result_4['type_name'],$Result_3['type_name'])?></td><?php */?>
<?php /*?><td align="left"><?=$Result_1['job']?></td><?php */?>
<td align="left">คลองหลวง</td>
<?php /*?><td align="center"><?
if($Result_1['import_status']=='1'){
echo '<img src="img/contract.png" alt="การนำเข้าข้อมูลจากการ key" title="การนำเข้าข้อมูลจากการ key" width="16" height="16" border="0" align="absmiddle" />';
}else if($Result_1['import_status']=='2'){
echo '<img src="img/icon-briefcase.png" alt="การนำเข้าข้อมูลจากการ import file XML" title="การนำเข้าข้อมูลจากการ import file XML" width="16" height="16" border="0" align="absmiddle" />';
}else if($Result_1['import_status']=='3'){
echo '<img src="img/import1.png" alt="การนำเข้าข้อมูลจากการ import file EXCEL" title="การนำเข้าข้อมูลจากการ import file EXCEL" width="16" height="16" border="0" align="absmiddle" />';
}else if($Result_1['import_status']=='4'){
echo '<img src="img/pin_red.png" alt="การนำเข้าข้อมูลโรงงานที่เลิกกิจการ" title="การนำเข้าข้อมูลโรงงานที่เลิกกิจการ" width="16" height="16" border="0" align="absmiddle" />';
}
?></td><?php */?>
<td align="left">156/11 ม.5 ต.บางกรอก อำเภอเมืองปทุมธานี</td>
<td align="center">089-4356565</td>
<td align="center">12-05-2553</td>
<td align="center">
<a href="form_surway_preview.php?runid=<?=$Result_1['run_id']?>&view=1"><img src="img/Preview-icon.png" alt="ดูข้อมูล" title="ดูข้อมูล" width="16" height="16" border="0" align="absmiddle" /></a>
<a href="form_surway.php?runid=<?=$Result_1['run_id']?>&code=<?=$Result_1['code']?>&edit=1"><img src="img/icon-write.png" alt="แก้ไข" title="แก้ไข" width="16" height="16" border="0" align="absmiddle" /></a>
<a href="" onClick="return Conf(this)"><img src="img/icon-delete.png" alt="ลบ" title="ลบ" width="16" height="16" border="0" align="absmiddle" /></a> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="center" style="<?=$style?>">4</td>
<td align="left">บริษัท สุขสวัสดิ์</td>
<?php /*?><td align="left"><?=searchReplace($Result_4['type_name'],$Result_3['type_name'])?></td><?php */?>
<?php /*?><td align="left"><?=$Result_1['job']?></td><?php */?>
<td align="left">คลองหลวง</td>
<?php /*?><td align="center"><?
if($Result_1['import_status']=='1'){
echo '<img src="img/contract.png" alt="การนำเข้าข้อมูลจากการ key" title="การนำเข้าข้อมูลจากการ key" width="16" height="16" border="0" align="absmiddle" />';
}else if($Result_1['import_status']=='2'){
echo '<img src="img/icon-briefcase.png" alt="การนำเข้าข้อมูลจากการ import file XML" title="การนำเข้าข้อมูลจากการ import file XML" width="16" height="16" border="0" align="absmiddle" />';
}else if($Result_1['import_status']=='3'){
echo '<img src="img/import1.png" alt="การนำเข้าข้อมูลจากการ import file EXCEL" title="การนำเข้าข้อมูลจากการ import file EXCEL" width="16" height="16" border="0" align="absmiddle" />';
}else if($Result_1['import_status']=='4'){
echo '<img src="img/pin_red.png" alt="การนำเข้าข้อมูลโรงงานที่เลิกกิจการ" title="การนำเข้าข้อมูลโรงงานที่เลิกกิจการ" width="16" height="16" border="0" align="absmiddle" />';
}
?></td><?php */?>
<td align="left">11/15 ม.4 ต.คลองหนึ่ง อำเภอคลองหลวง</td>
<td align="center">025-243345</td>
<td align="center">12-05-2553</td>
<td align="center">
<a href="form_surway_preview.php?runid=<?=$Result_1['run_id']?>&view=1"><img src="img/Preview-icon.png" alt="ดูข้อมูล" title="ดูข้อมูล" width="16" height="16" border="0" align="absmiddle" /></a>
<a href="form_surway.php?runid=<?=$Result_1['run_id']?>&code=<?=$Result_1['code']?>&edit=1"><img src="img/icon-write.png" alt="แก้ไข" title="แก้ไข" width="16" height="16" border="0" align="absmiddle" /></a>
<a href="" onClick="return Conf(this)"><img src="img/icon-delete.png" alt="ลบ" title="ลบ" width="16" height="16" border="0" align="absmiddle" /></a> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="center" style="<?=$style?>">5</td>
<td align="left">บริษัท นิ่มซี่เส็ง</td>
<?php /*?><td align="left"><?=searchReplace($Result_4['type_name'],$Result_3['type_name'])?></td><?php */?>
<?php /*?><td align="left"><?=$Result_1['job']?></td><?php */?>
<td align="left">เมืองปทุมธานี</td>
<?php /*?><td align="center"><?
if($Result_1['import_status']=='1'){
echo '<img src="img/contract.png" alt="การนำเข้าข้อมูลจากการ key" title="การนำเข้าข้อมูลจากการ key" width="16" height="16" border="0" align="absmiddle" />';
}else if($Result_1['import_status']=='2'){
echo '<img src="img/icon-briefcase.png" alt="การนำเข้าข้อมูลจากการ import file XML" title="การนำเข้าข้อมูลจากการ import file XML" width="16" height="16" border="0" align="absmiddle" />';
}else if($Result_1['import_status']=='3'){
echo '<img src="img/import1.png" alt="การนำเข้าข้อมูลจากการ import file EXCEL" title="การนำเข้าข้อมูลจากการ import file EXCEL" width="16" height="16" border="0" align="absmiddle" />';
}else if($Result_1['import_status']=='4'){
echo '<img src="img/pin_red.png" alt="การนำเข้าข้อมูลโรงงานที่เลิกกิจการ" title="การนำเข้าข้อมูลโรงงานที่เลิกกิจการ" width="16" height="16" border="0" align="absmiddle" />';
}
?></td><?php */?>
<td align="left">265 ม.2 ต.คลองหนึ่ง อำเภอคลองหลวง</td>
<td align="center">083-5435454</td>
<td align="center">12-05-2553</td>
<td align="center">
<a href="form_surway_preview.php?runid=<?=$Result_1['run_id']?>&view=1"><img src="img/Preview-icon.png" alt="ดูข้อมูล" title="ดูข้อมูล" width="16" height="16" border="0" align="absmiddle" /></a>
<a href="form_surway.php?runid=<?=$Result_1['run_id']?>&code=<?=$Result_1['code']?>&edit=1"><img src="img/icon-write.png" alt="แก้ไข" title="แก้ไข" width="16" height="16" border="0" align="absmiddle" /></a>
<a href="" onClick="return Conf(this)"><img src="img/icon-delete.png" alt="ลบ" title="ลบ" width="16" height="16" border="0" align="absmiddle" /></a> </td>
</tr>
<?php /*?><? }?><?php */?>
</table>
<?
$time_e = getmicrotime();
$stime = number_format($time_e - $time_start,12);
?>
<br />
<!--<p><span> <strong>หมายเหตุ</strong></span></p>-->
<table width="99%" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td width="20%" align="left"> </td>
<td align="right">ใช้เวลาในการประมวลผล <?=$stime?> วินาที</td>
</tr>
</table>
<table width="99%" border="0" align="center">
<tr>
<td width="50"></td>
<td valign="top">
<table width="100%" cellpadding="0" cellspacing="1" border="0" bgcolor="#FFFFFF">
<tr bgcolor="#FFFFFF">
<td align="left"> </td>
</tr>
</table>
</td>
<?php /*?><td width="5"></td>
<td valign="top" width="326">
<table width="70%" cellpadding="0" cellspacing="1" border="0" bgcolor="#000000">
<tr bgcolor="#EFEFEF">
<td colspan="2" align="center"><strong>การจัดการ</strong></td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="center"><img src="img/Preview-icon.png" alt="ดูข้อมูล" title="ดูข้อมูล" width="16" height="16" border="0" align="absmiddle" /></td>
<td>Preview ข้อมูล</td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="center"><img src="img/icon-write.png" alt="แก้ไข" title="แก้ไข" width="16" height="16" border="0" align="absmiddle" /></td>
<td>แก้ไขข้อมูล</td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="center"><img src="img/icon-delete.png" alt="ลบ" title="ลบ" width="16" height="16" border="0" align="absmiddle" /></td>
<td>ลบข้อมูล</td>
</tr>
</table>
</td>
<td width="398"></td><?php */?>
</tr>
</table>
<br />
<form name="form2" id="form2" method="get" >
<input name="surway_id" id="surway_id" type="hidden" value="<?=$surway_id?>" size="100"/>
<input name="name_meeting" id="name_meeting" type="hidden" value="<?=$name_meeting?>" size="100"/>
<input name="village_name" id="village_name" type="hidden" value="<?=$village_name?>" size="100"/>
<input name="public_amphur" id="public_amphur" type="hidden" value="<?=$public_amphur?>" size="100"/>
<input name="public_tambol" id="public_tambol" type="hidden" value="<?=$public_tambol?>" size="100"/>
<input name="public_Subtambol" id="public_Subtambol" type="hidden" value="<?=$public_tambol?>" size="100"/>
<input name="public_Mun" id="public_Mun" type="hidden" value="<?=$public_Mun?>" size="100"/>
<input name="type_key" id="type_key" type="hidden" value="<?=$type_key?>" size="100"/>
</form>
<script language="javascript">
function clearText(){
document.getElementById("surway_id").value = "";
document.getElementById("name_meeting").value = "";
document.getElementById("village_name").value = "";
document.getElementById("public_amphur").value = "";
document.getElementById("public_tambol").value = "";
document.getElementById("public_Subtambol").value = "";
document.getElementById("public_Mun").value = "";
document.getElementById("type_key").value = "";
}
</script>
</body>
</html>