|
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 : /proc/self/root/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}
.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 pathumthani_integration.industry_register WHERE code='".$_GET['runid_del']."' ");
//mysql_query("DELETE FROM pathumthani.da_deprecrate WHERE type_id='".$_GET['type_id_del']."' ");
}
?>
<!-- <strong style="color:#000033; font-size:18px;"><img src="images/unpublish_f2.png" align="absmiddle" border="0"/>ทะเบียนโรงงานอุตสาหกรรม</strong>
-->
<?
$strSearch="";
$strSQL_1 = "SELECT
industry_register.type_id,
industry_register.code,
industry_register.fact_class,
industry_register.fname,
industry_register.job,
industry_register.location,
industry_register.ampur,
industry_register.tambol,
industry_register.muban,
industry_register.fyear,
industry_register.eyear,
industry_register.capital,
industry_register.import_status
FROM industry_register
WHERE industry_register.code IS NOT NULL
";
if($_GET['p']){
$strSearch.="&p=".$_GET['p'];
}
if($_GET['code']){
$strSQL_1.=" and code LIKE('%".$_GET['code']."%') ";
$strSearch.="&code=".$_GET['code'];
}
if($_GET['fname']){
$strSQL_1.=" and fname LIKE('%".$_GET['fname']."%') ";
$strSearch.="&fname=".$_GET['fname'];
}
if($_GET['location']){
$strSQL_1.=" and location LIKE('%".$_GET['location']."%') ";
$strSearch.="&location=".$_GET['location'];
}
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['import_status']){
$strSQL_1.=" and import_status = '".($_GET['import_status'])."' ";
$strSearch.="&import_status=".($_GET['import_status']);
}
if($_GET['import_status1']){
if($_GET['import_status1']!='-1'){
$strSQL_1.=" and import_status = '".($_GET['import_status1'])."' ";
}else{
$strSQL_1.=" and import_status != '4' ";
}
$strSearch.="&import_status1=".($_GET['import_status1']);
}
if($_GET['fact_class']){
$strSQL_1.=" and fact_class = '".$_GET['fact_class']."' ";
$strSearch.="&fact_class=".$_GET['fact_class'];
}
$strSQL_1.=" ORDER BY industry_register.update_time DESC ";
//echo $strSQL_1;
/*$s = getmicrotime();
$rsConn1 = mysql_query($strSQL_1)or die(mysql_error());
$Rows = mysql_num_rows($rsConn1);
$e = getmicrotime();*/
//echo ($e-$s);
/*$time_e = getmicrotime();
$stime = number_format($time_e - $time_start,12);*/
?>
<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="86%" border="0" bgcolor="#CCCCCC" cellpadding="3" cellspacing="1">
<tr class="bg_th">
<td rowspan="2" align="center"><strong>จำพวกอุตสาหกรรม</strong></td>
<td rowspan="2" align="center"><strong>เงินทุน (ล้านบาท)</strong></td>
<td colspan="3" align="center"><strong>จำนวนโรงงาน (โรง)</strong></td>
</tr>
<tr class="bg_th1">
<td align="center"><strong>ดำเนินกิจการ</strong></td>
<td align="center"><strong>เลิกกิจการ</strong></td>
<td align="center"><strong>รวม</strong></td>
</tr>
<?
$data1='';
$data2='';
$catagory='';
$totalCapital=0;
$totalActive=0;
$totalNon=0;
$allTotal=0;
$sql_2="SELECT *
FROM industry_class
";
$rs_2=mysql_db_query($dbname,$sql_2);
while ( $Result_2 = mysql_fetch_assoc($rs_2)) {
$sqlClass1="SELECT SUM(capital) AS ALL_CAPITAL,
SUM(if(import_status!='4',1,0)) AS ACTIVE_INDUSTRY,
SUM(if(import_status='4',1,0)) AS NONACTIVE_INDUSTRY
FROM industry_register
WHERE fact_class='".$Result_2['class_id']."'
";
/*if($_GET['code']){
$sqlClass1.=" and code LIKE('%".$_GET['code']."%') ";
}
if($_GET['fname']){
$sqlClass1.=" and fname LIKE('%".$_GET['fname']."%') ";
}
if($_GET['location']){
$sqlClass1.=" and location LIKE('%".$_GET['location']."%') ";
}
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);
$sqlClass1.=" and ampur like '%".str_replace('อำเภอ','',$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);
$sqlClass1.=" and tambol like '%".str_replace('ตำบล','',$resultTambol['ccName'])."%' ";
}
if($_GET['muban']){
$sqlClass1.=" and muban LIKE('%".$_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==''){
$sqlClass1.=" and type_id ='-999' ";
}else{
$sqlClass1.=" and type_id IN($str_no1) ";
}
}
if($_GET['fyear']){
$sqlClass1.=" and fyear = '".$_GET['fyear']."' ";
}
if($_GET['eyear']){
$sqlClass1.=" and eyear = '".$_GET['eyear']."' ";
}
if($_GET['import_status']){
$sqlClass1.=" and import_status = '".($_GET['import_status'])."' ";
}
if($_GET['import_status1']){
if($_GET['import_status1']!='-1'){
$sqlClass1.=" and import_status = '".($_GET['import_status1'])."' ";
}else{
$sqlClass1.=" and import_status != '4' ";
}
}
if($_GET['fact_class']){
$sqlClass1.=" and fact_class = '".$_GET['fact_class']."' ";
}*/
$rsClass1=mysql_db_query($dbname,$sqlClass1);
$resClass1=mysql_fetch_assoc($rsClass1);
$tempCapital=$resClass1['ALL_CAPITAL']/1000000;
$totalCapital+=$tempCapital;
$totalActive+=$resClass1['ACTIVE_INDUSTRY'];
$totalNon+=$resClass1['NONACTIVE_INDUSTRY'];
$tempIndustry=$resClass1['ACTIVE_INDUSTRY']+$resClass1['NONACTIVE_INDUSTRY'];
$allTotal+=$tempIndustry;
$data1.=$resClass1['ACTIVE_INDUSTRY'].';';
$data2.=$resClass1['NONACTIVE_INDUSTRY'].';';
$catagory.='จำพวกที่ '.$Result_2['class_id'].';';
?>
<tr bgcolor="#FFFFFF">
<td align="left"><strong><?=('โรงงานอุตสาหกรรมจำพวกที่ '.$Result_2['class_id'])?></strong></td>
<td align="right"><? if($tempCapital!=0){ ?><a href="?p=<?=$_GET['p']?>&fact_class=<?=$Result_2['class_id']?>"><? }?><?=number_format($tempCapital,2)?></a></td>
<td align="right"><? if($resClass1['ACTIVE_INDUSTRY']!=0){ ?><a href="?p=<?=$_GET['p']?>&fact_class=<?=$Result_2['class_id']?>&import_status1=-1"><? }?><?=number_format($resClass1['ACTIVE_INDUSTRY'])?></a></td>
<td align="right"><? if($resClass1['NONACTIVE_INDUSTRY']!=0){ ?><a href="?p=<?=$_GET['p']?>&fact_class=<?=$Result_2['class_id']?>&import_status1=4"><? }?><?=number_format($resClass1['NONACTIVE_INDUSTRY'])?></a></td>
<td align="right"><? if($tempIndustry!=0){ ?><a href="?p=<?=$_GET['p']?>&fact_class=<?=$Result_2['class_id']?>"><? }?><?=number_format($tempIndustry)?></a></td>
</tr>
<? }?>
<tr bgcolor="#DDDDDD">
<td align="right"><strong>รวม</strong></td>
<td align="right"><? if($totalCapital!=0){ ?><a href="?p=<?=$_GET['p']?>&fact_class="><? }?><?=number_format($totalCapital,2)?></a></td>
<td align="right"><? if($totalActive!=0){ ?><a href="?p=<?=$_GET['p']?>&fact_class=&import_status1=-1"><? }?><?=number_format($totalActive)?></a></td>
<td align="right"><? if($totalNon!=0){ ?><a href="?p=<?=$_GET['p']?>&fact_class=&import_status1=4"><? }?><?=number_format($totalNon)?></a></td>
<td align="right"><? if($allTotal!=0){ ?><a href="?p=<?=$_GET['p']?>&fact_class=&import_status1="><? }?><?=number_format($allTotal)?></a></td>
</tr>
</table>
<table width="86%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="right">
<?
$data1=substr($data1,0,strlen($data1)-1);
$data2=substr($data2,0,strlen($data2)-1);
$catagory=substr($catagory,0,strlen($catagory)-1);
//$catagory='ขนาดเล็ก;ขนาดกลาง;ขนาดใหญ่';
//$columntitle="รายงานข้อมูลโรงงานอุตสาหกรรมจำแนกตามจำพวก";
$columntitle='กราฟแสดงจำนวนโรงงานจำแนกตามการดำเนินกิจการ';
$seriesname='ดำเนินกิจการ;เลิกกิจการ';
$xgraphurl_link = $graph_path ."?category=$catagory"."&data1="."$data1"."&data2="."$data2"."&outputstyle=&numseries=2&seriesname=$seriesname&graphtype=column&title=$columntitle&xname=&yname=&subtitle=&graphstyle=srd_allvisible_lg.scs";//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('labor_register_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('labor_register_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="labor_register_xls_export.php?<?=$strSearch?>"><img src="img/xls_logo.gif" alt="Excel" title="Excel" width="16" height="16" border="0" align="absmiddle" /></a>
<a href="labor_register_pdf.php"><img src="img/pdf.gif" alt="PDF" title="PDF" width="16" height="16" border="0" align="absmiddle" /></a>
<a href="labor_register_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['fact_class'] != "")?' <strong>โรงงานอุตสาหกรรมจำพวกที่</strong> "'.$_GET['fact_class'].'"<br/>':"";?>
<?php echo ($_GET['import_status1'] != "")?(($_GET['import_status1'] != "4")?' <strong>สถานะการดำเนินกิจการ</strong> = "ดำเนินกิจการ"<br/>':' <strong>สถานะการดำเนินกิจการ</strong> = "เลิกกิจการ"<br/>'):'';?>
<?php echo ($_GET['code'] != "")?' <strong>เลขทะเบียนโรงงาน</strong> = "'.$_GET['code'].'"<br/>':"";?>
<?php echo ($_GET['fname'] != "")?' <strong>ชื่อโรงงาน</strong> = "'.$_GET['fname'].'"<br/>':"";?>
<?php echo ($_GET['location'] != "")?' <strong>ที่ตั้งโรงงาน</strong> = "'.$_GET['location'].'"<br/>':"";?>
<?
if($_GET['ampur'] != ""){
$strSQL_ampur = "SELECT ccaa.ccDigi,ccaa.ccName,ccaa.ccType
FROM ccaa
where ccaa.ccType = 'Aumpur' AND ccaa.ccDigi ='".$_GET['ampur']."'
";
$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['tambol'] != ""){
$strSQL_tambol = "SELECT ccaa.ccDigi,ccaa.ccName,ccaa.ccType
FROM ccaa
where ccaa.ccType = 'Tamboon' AND ccaa.ccDigi ='".$_GET['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/>':"";
?>
<?php echo ($_GET['muban'] != "")?' <strong>หมู่บ้านที่ตั้งโรงงาน</strong> = "'.$_GET['muban'].'"<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/>':"";
?>
<?php echo ($_GET['fyear'] != "")?' <strong>ปีรับใบอนุญาติ</strong> = "'.$_GET['fyear'].'"<br/>':"";?>
<?php echo ($_GET['eyear'] != "")?' <strong>ปีสิ้นอายุ</strong> = "'.$_GET['eyear'].'"<br/>':"";?>
<?
if($_GET['import_status'] != ""){
$strImport='';
if($_GET['import_status']=="1"){
$strImport='ข้อมูลจากการ key';
}else if($_GET['import_status']=="2"){
$strImport='ข้อมูลจากการ import ไฟล์ XML';
}else if($_GET['import_status']=="3"){
$strImport='ข้อมูลจากการ import ไฟล์ EXCEL';
}else if($_GET['import_status']=="4"){
$strImport='ข้อมูลโรงงานอุตสาหกรรมที่เลิกกิจการ';
}
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 />
<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> หน้า
<? }?>
<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_register_keyin"><img src="images/add.png" alt="ขึ้นทะเบียนโรงงานอุตสาหกรรม" title="ขึ้นทะเบียนโรงงานอุตสาหกรรม" border="0" align="absmiddle" /></a><a href="?p=labor_register_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%" rowspan="2"><strong>ลำดับที่</strong></td>
<td width="12%" rowspan="2"><strong>เลขทะเบียนโรงงาน</strong></td>
<td width="15%" rowspan="2"><strong>ชื่อโรงงาน</strong></td>
<td width="8%" rowspan="2"><strong>อำเภอ</strong></td>
<td width="5%" rowspan="2"><strong>อก. จำพวกที่</strong></td>
<td width="17%" rowspan="2"><strong>ประเภทอุตสาหกรรม</strong></td>
<td width="7%" rowspan="2"><strong>เงินทุน<br />(ล้านบาท)</strong></td>
<td colspan="2"><strong>สถานะการดำเนินกิจการ</strong></td>
<td width="7%" rowspan="2"><strong>การจัดการ</strong></td>
</tr>
<tr class="bg_th1">
<!--<td width="12%"><strong>หมวดอุตสาหกรรม</strong></td>-->
<!--<td width="17%"><strong>ประกอบกิจการ</strong></td>-->
<!--<td width="7%"><strong>สถานะการนำเข้าข้อมูล</strong></td>-->
<td width="5%"><strong>ดำเนินกิจการ</strong></td>
<td width="5%"><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 type_name,parent_id FROM industry_type WHERE type_id='".$Result_1['type_id']."' ";
$rsConn_2 = mysql_db_query($dbname,$strSQL_2);
$Result_2 = mysql_fetch_assoc($rsConn_2);
$strSQL_3 = "SELECT type_name FROM industry_type WHERE runid='".$Result_2['parent_id']."' ";
$rsConn_3 = mysql_db_query($dbname,$strSQL_3);
$Result_3 = mysql_fetch_assoc($rsConn_3);
$strSQL_4 = "SELECT type_name FROM industry_type WHERE type_id='".$_GET['type_id']."' ";
$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);
$eyearImg='';
if($Result_1['eyear']<(date('Y')+543)){
$eyearImg='<img src="img/dash_notpass.png" alt="หมดอายุ" title="หมดอายุ" width="16" height="16" border="0" align="absmiddle" />';
}
?>
<tr bgcolor="#FFFFFF" onmouseover="this.style.backgroundColor='#dbf2ae'" onmouseout="this.style.backgroundColor='#FFFFFF'">
<td align="center"><?=$rowNumb?></td>
<td align="left"><a class="personPopupTrigger" rel="code:<?=$Result_1['code']?>,get_2:var_2"><?=searchReplace($_GET['code'],$Result_1['code'])?></a>
<?=$eyearImg?>
</td>
<td align="left"><a class="personPopupTrigger" rel="code:<?=$Result_1['code']?>,get_2:var_2"><?=searchReplace($_GET['fname'],$Result_1['fname'])?></a></td>
<td align="left"><?=$Result_1['ampur']?></td>
<td align="center"><?=$Result_1['fact_class']?></td>
<?php /*?><td align="left"><?=searchReplace($Result_4['type_name'],$Result_3['type_name'])?></td><?php */?>
<td align="left"><?=$Result_2['type_name']?></td>
<?php /*?><td align="left"><?=$Result_1['job']?></td><?php */?>
<td align="right"><?=number_format(($Result_1['capital']/1000000),2)?></td>
<td align="center"><?=($Result_1['import_status']!='4')?'<img src="img/right.gif" width="16" height="16" border="0" align="absmiddle" />':''?></td>
<td align="center"><?=($Result_1['import_status']=='4')?'<img src="img/right.gif" width="16" height="16" border="0" align="absmiddle" />':''?></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="center">
<a href="?p=labor_register_preview&code1=<?=$Result_1['code']?>&view=1"><img src="img/Preview-icon.png" alt="ดูข้อมูล" title="ดูข้อมูล" width="16" height="16" border="0" align="absmiddle" /></a>
<a href="?p=labor_register_keyin&code1=<?=$Result_1['code']?>&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="?runid_del=<?=$Result_1['code']?>" onClick="return Conf(this)"><img src="img/icon-delete.png" alt="ลบ" title="ลบ" width="16" height="16" border="0" align="absmiddle" /></a>
</td>
</tr>
<? }?>
</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"> <strong><span class="style1">***</span> หมายเหตุ:</strong></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>
<td align="left"><strong>"อก."</strong> ย่อมาจาก "อุตสาหกรรม"</td>
</tr>
<?
$sqlNoteClass=" SELECT * FROM industry_class ";
$rsNoteClass=mysql_db_query($dbname,$sqlNoteClass);
while($resNoteClass=mysql_fetch_assoc($rsNoteClass)){
?>
<tr bgcolor="#FFFFFF">
<td align="left"><strong>"โรงงานอุตสาหกรรมจำพวกที่ <?=$resNoteClass['class_id']?>"</strong> หมายถึง <?=$resNoteClass['note']?></td>
</tr>
<? }?>
</table>
<?php /*?><table width="80%" 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/contract.png" width="16" height="16" ></td>
<td>ข้อมูลจากการ key</td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="center" width="20"><img src="img/icon-briefcase.png" width="16" height="16" ></td>
<td>ข้อมูลจากการ import ไฟล์ XML</td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="center"><img src="img/import1.png" width="16" height="16" ></td>
<td>ข้อมูลจากการ import ไฟล์ EXCEL</td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="center"><img src="img/pin_red.png" width="16" height="16" ></td>
<td>ข้อมูลโรงงานอุตสาหกรรมที่เลิกกิจการ</td>
</tr>
</table><?php */?>
</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="code" id="code" type="hidden" value="<?=$code?>" size="100"/>
<input name="fname" id="fname" type="hidden" value="<?=$fname?>" size="100"/>
<input name="location" id="location" type="hidden" value="<?=$location?>" size="100"/>
<input name="ampur" id="ampur" type="hidden" value="<?=$ampur?>" size="100"/>
<input name="tambol" id="tambol" type="hidden" value="<?=$tambol?>" size="100"/>
<input name="muban" id="muban" type="hidden" value="<?=$muban?>" size="100"/>
<input name="type_id" id="type_id" type="hidden" value="<?=$type_id?>" size="100"/>
<input name="fyear" id="fyear" type="hidden" value="<?=$fyear?>" size="100"/>
<input name="eyear" id="eyear" type="hidden" value="<?=$eyear?>" size="100"/>
<input name="import_status" id="import_status" type="hidden" value="<?=$import_status?>" size="100"/>
</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>