|
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 : |
<?php
session_start();
$timestart = microtime();
$pagename = "labor_exam";
include_once("../../config/config_epm.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_pathumthani WHERE ccDigi= '".$ccDigi."' ");
$r_am = mysql_fetch_assoc($am);
return $r_am["ccName"];
}
?>
<!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>
<TITLE></TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<style>
.bg_th{
background-image:url(images/horiz-bg.png);
background-repeat:repeat-x;
background-color:#305086;
font-weight:bold;
color:#FFFFFF;
text-align:center;
}
</style>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<link href="../../common/tooltip/css/style.css" type="text/css" rel="stylesheet">
<script src="../../common/tooltip/jquery_1_3_2.js"></script>
<script>
//alert('xxx');
//File Ajax tooltip
var url_tooltip = 'http://<?=$_SERVER['SERVER_NAME'];?>/pathumthani_integration/integration/application/elderly/ajax.elderly_register.php';
//var height_tooltip = 250;
</script>
<script src="../../common/tooltip/tooltip_personal.js"></script>
<script type="text/javascript">
function calDate(t)
{
var so = document.getElementById('span_old');
var old = new String(t.value);
if(old.length == 10)
{
yyyy = (parseInt(old.substr(6,10)) - 543)+"";
mm = old.substr(3,2);
dd = old.substr(0,2);
var d1 = new Date(parseFloat(yyyy),parseFloat(mm),parseFloat(dd));
var d2 = new Date();
var diff = ((d2-d1)/(24*60*60*1000)/365);
diff = diff.toFixed(0);
if(diff < 1)
{
alert("กรุณาระบุวันเดือนปีเกิดให้น้อยกว่า วันที่ปัจจุบัน");
so.innerHTML = "...";
}
else
{
so.innerHTML = diff;
return diff;
}
}
so.innerHTML = "...";
return 0;
}
</script>
<style type="text/css">
<!--
.style5 {font-size: 12px}
.style6 {color: #666666; font-weight: bold; font-size: 12px; }
-->
</style>
</HEAD>
<?php
$strSearch="";
if($_GET['p']){
$strSearch.="&p=".$_GET['p'];
}
$arrPrename = array();
$strSQL = "SELECT id, prename_th FROM tbl_prename ORDER BY priority ASC";
$rsConn = mysql_query($strSQL);
while( $Result = mysql_fetch_array($rsConn) ) {
$arrPrename[$Result['id']] = $Result['prename_th'];
}
$sqlexsum = "SELECT
SUM(IF( LEFT(labor_personal.d_ampur_id,2 )='13',1,0 ) ) AS count_ampur,
SUM(IF(labor_personal.d_ampur_id IS NULL OR labor_personal.d_ampur_id='' OR LEFT(labor_personal.d_ampur_id,2 )!='13' ,1,0 )) AS count_ampur_na,
IF( LEFT(labor_personal.d_ampur_id,2 )='13',labor_personal.d_ampur_id,99999999 ) AS d_ampur_id
FROM
labor_trainning_course
Inner Join labor_personal ON labor_personal.id_card = labor_trainning_course.id_card
GROUP BY labor_personal.d_ampur_id
ORDER BY labor_personal.d_ampur_id DESC
";
$resexsum = mysql_query($sqlexsum);
while($rowsum = mysql_fetch_assoc($resexsum)){
$arrPCVExSum[$rowsum['d_ampur_id']][0] += ($rowsum['d_ampur_id']!="99999999")?$rowsum['count_ampur']:$rowsum['count_ampur_na'];
$arrExSumData[$rowsum['d_ampur_id']] = $rowsum;
}
$arrPCExSum = percentage_2d($arrPCVExSum); #show($arrPCExSum);
### ส่ง พารามิเตอร์ สำหรับ export
$strSQL_1="SELECT
labor_personal.id_card,
labor_personal.prename,
labor_personal.fname,
labor_personal.lname,
labor_personal.birthdate,
labor_personal.d_ampur_id,
labor_trainning_course.register_date,
labor_trainning_course.runid
FROM
labor_trainning_course
Inner Join labor_personal ON labor_personal.id_card = labor_trainning_course.id_card
WHERE labor_personal.id_card <> ''
";
if($_GET['start_register_date'] && $_GET['end_register_date']){
$arr_start_register_date = explode("/",$_GET['start_register_date']);
$arr_end_register_date = explode("/",$_GET['end_register_date']);
$strSQL_1.=" AND labor_trainning_course.register_date
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_register_date=".$_GET['start_register_date']."&end_register_date=".$_GET['end_register_date'];
}
if($_GET['id_card']){
$strSQL_1 .= " AND labor_personal.`id_card` LIKE('%".str_replace("-","",$_GET['id_card'])."%') ";
$strSearch .= "&id_card=".$_GET['id_card'];
}
if($_GET['fname']){
$strSQL_1 .= " AND labor_personal.`fname` LIKE('%".$_GET['fname']."%') ";
$strSearch .= "&fname=".$_GET['fname'];
}
if($_GET['lname']){
$strSQL_1 .= " AND labor_personal.`lname` LIKE('%".$_GET['lname']."%') ";
$strSearch .= "&lname=".$_GET['lname'];
}
if($_GET['d_ampur_id']){
if($_GET['d_ampur_id']!="99999999"){
$strSQL_1 .= " AND labor_personal.`d_ampur_id` = '".$_GET['d_ampur_id']."' ";
}else{
$strSQL_1 .= " AND LEFT(labor_personal.d_ampur_id,2) != '13' OR labor_personal.d_ampur_id IS NULL ";
}
$strSearch .= "&d_ampur_id=".$_GET['d_ampur_id'];
}
###
?>
<BODY>
<p/>
<br />
<table width="99%" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td align="center"><strong style="color:#000000; font-size:12px;">ทะเบียนผู้สมัครเพื่อเข้ารับการฝึกอบรมฝีมือแรงงาน</strong></td>
</tr>
<tr>
<td align="center">ข้อมูล ณ วันที่ <?=dateFormat(date('Y-m-d'),'thaidot')?></td>
</tr>
</table>
<table width="99%" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td width="60%" height="119" align="left" valign="top"><table width="60%" border="0" bgcolor="#CCCCCC" cellpadding="3" cellspacing="1">
<tr class="bg_th">
<td width="60%" align="center"><strong>อำเภอ</strong></td>
<td width="20%" align="center">จำนวนผู้สมัคร</td>
<td width="20%" align="center"><strong>ร้อยละ</strong></td>
</tr>
<?php
ksort($arrExSumData);
$count_course_all = 0;
$arrPCExSum_all = 0;
if($arrExSumData)
foreach($arrExSumData as $key=>$rowData){
$arrPCExSum_all+=$arrPCExSum[$rowData['d_ampur_id']][0];
?>
<tr bgcolor="#FFFFFF">
<td align="left">
<span class="style6">
<?php
if($rowData['d_ampur_id']!="99999999"){
$count_course_all+=$arrPCVExSum[$rowData['d_ampur_id']][0];
echo ccName($rowData['d_ampur_id']);
}else{
$count_course_all+=$arrPCVExSum[$rowData['d_ampur_id']][0];
echo "อยู่นอกพื้นที่จังหวัดปทุมธานี";
}
?>
</span>
</td>
<td align="right"><span class="style5">
<?php
if($arrPCVExSum[$rowData['d_ampur_id']][0]>0){
echo '<a href="index.php?p=labor_practice&d_ampur_id='.$rowData['d_ampur_id'].'">'.number_format($arrPCVExSum[$rowData['d_ampur_id']][0]).'</a>';
}else{
echo 0;
}
?>
</span></td>
<td align="right"><span class="style5">
<?=$arrPCExSum[$rowData['d_ampur_id']][0]?>
</span></td>
</tr>
<?php } ?>
<tr bgcolor="#DDDDDD">
<td align="left"><strong>รวม</strong></td>
<td align="right"><?php
if($count_course_all>0){
echo '<a href="index.php?p=labor_practice&d_ampur_id=">'.number_format($count_course_all).'</a>';
}else{
echo 0;
}
?>
</td>
<td align="right"><?=number_format($arrPCExSum_all, 2)?></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 = 'ระดับความรุนแรงน้อย;ระดับความรุนแรงปานกลาง;ระดับความรุนแรงมาก';
if($arrExSumData)
foreach ( $arrExSumData as $Key => $Val ) {
if($Val['d_ampur_id']!="99999999"){
$dataGraph .= $Val['count_ampur'].';';
$catagory .= ccName($Val['d_ampur_id']).';';
}else{
$dataGraph .= $Val['count_ampur_na'].';';
$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 width="83%" align="right"><img src="img/search.png" alt="ค้นหา" width="16" height="16" border="0" align="middle" title="ค้นหา" /><a href="#" onclick="window.open('search_labor_practice.php','export','toolbar=0,location=0,directories=0,status=0,menubar=0,height=550,width=700,resizeable=1,scrollbars=1'); clearText();"><strong>ค้นหา</strong></a></td>
<td width="17%" align="right"><a href="../import_export/export_excel.php?ProfileID=3&Encoding=TIS-620" target="_blank"><img src="../../images/dash_icon/ico_xls.png" alt="Excel" title="Excel" width="16" height="16" border="0" /></a> <a href="?p=xml_export&profile_id=3"><img src="../../images/dash_icon/ico_xml.png" alt="XML" title="XML" width="16" height="16" border="0" /></a> <img src="../../images/dash_icon/ico_pdf_disabled.png" alt="PDF" title="PDF" width="16" height="16" /> </td>
</tr>
<tr>
<td colspan="2"><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> <a href="index.php?&p=<?php echo $_GET['p']?>">ล้างค่าการค้นหา</a></td>
</tr>
<tr>
<td align="left">
<?php echo ($_GET['start_register_date'] != "")?' <strong>วันที่ยื่นคำร้องจาก</strong> "'.$_GET['start_register_date'].'"<br/>':"";?>
<?php echo ($_GET['end_register_date'] != "")?' <strong>วันที่ยื่นคำร้องถึง</strong> : "'.$_GET['end_register_date'].'"<br/>':"";?>
<?php echo ($_GET['id_card'] != "")?' <strong>เลขบัตรประชาชน</strong> : "'.$_GET['id_card'].'"<br/>':"";?>
<?php echo ($_GET['fname'] != "")?' <strong>ชื่อ</strong> : "'.$_GET['fname'].'"<br/>':"";?>
<?php echo ($_GET['lname'] != "")?' <strong>นามสกุล</strong> : "'.$_GET['lname'].'"<br/>':"";?>
</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<br />
<table align="center" width="99%" border="0" cellpadding="3" cellspacing="1">
<tr>
<td width="58%">
<?php
if($_GET['debug'] == "on")
{
echo "<pre>";
echo $strSQL_1;
}
$rsConn = mysql_db_query($dbname,$strSQL_1);
$all_row = mysql_num_rows($rsConn);
$board_row_per_page = 10;
$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";
}
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" title="<?=$CSh?>" width="16" height="16" border="0" /></a>
<? if($View==''){?>
<? if($page==1){?>
<img src="img/page_div_icon/xFirst.gif" align="absmiddle" />
<? }else{?>
<img src="img/page_div_icon/First.gif" align="absmiddle" border="0" width="10" height="12" onclick="<?=$prevTen;?>" style="cursor:pointer;"/>
<? }?>
<? if($page==1){?>
<img src="img/page_div_icon/xPrevious.gif" align="absmiddle" />
<? }else{?>
<img src="img/page_div_icon/Previous.gif" align="absmiddle" border="0" width="7" height="12" onclick="<?=$prev;?>" style="cursor:pointer;"/>
<? }?>
<?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" align="absmiddle" />
<? }else{?>
<img src="img/page_div_icon/Next.gif" align="absmiddle" border="0" width="7" height="12" onClick="<?=$next;?>" style="cursor:pointer;"/>
<? }?>
<? if($page==$loop_page){?>
<img src="img/page_div_icon/xLast.gif" align="absmiddle" />
<? }else{?>
<img src="img/page_div_icon/Last.gif" align="absmiddle" border="0" width="10" height="12" onClick="<?=$nextTen;?>" style="cursor:pointer;"/>
<?
}
}#End View=
?></td>
<td align="right"><table><tr><td><img src="images/add.png" align="absmiddle" border="0"/></td>
<td><strong style="color:#000033;"><a href="index.php?p=labor_practice_keyin">ทะเบียนเพื่อเข้ารับการฝึกอบรม</a></strong></td>
</tr></table>
</td>
</tr>
</table>
<table width="99%" border="0" align="center" bgcolor="#CCCCCC" cellpadding="3" cellspacing="1">
<tr align="center">
<td width="50" height="30" class="bg_th">ลำดับ</td>
<td width="90" class="bg_th">วันที่สมัคร</td>
<td width="115" class="bg_th">เลขบัตรประชาชน</td>
<td class="bg_th">ชื่อ-นามสกุล </td>
<td width="90" class="bg_th">อายุ(ปี)</td>
<td width="100" class="bg_th">การศึกษาสูงสุด</td>
<td width="100" class="bg_th">สถานภาพแรงงาน</td>
<td width="200" class="bg_th">เหตุผลที่สมัครเข้าฝึก</td>
<td width="80" class="bg_th">การจัดการ</td>
</tr>
<?php
$query = mysql_query($strSQL_1);
while($row = mysql_fetch_assoc($query)){
$int_num++;
$rowNumb = ($int_num+($board_link_num*$page)-$board_link_num);
?>
<tr bgcolor="#FFFFFF" onmouseover="this.style.backgroundColor='#dbf2ae'" onmouseout="this.style.backgroundColor='#FFFFFF'">
<td align="center"><?php echo $rowNumb?></td>
<td align="center"><?php echo dateFormat($row['register_date'], "thaidot")?></td>
<td align="center"><?php echo searchReplace($_GET['id_card'],pinFormatX($row['id_card']));?></td>
<td ><?php echo $arrPrename[$row['prename']].searchReplace($_GET['fname'],$row['fname'])?> <?php echo searchReplace($_GET['lname'],$row['lname'])?></td>
<td align="center"><?php echo birthday_year($row['birthdate'])?></td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"><a href=# onclick="window.open('index.php?module=elderly_history_lecturer&course_training_id=<?=$row['id_card']?>','export','toolbar=0,location=0,directories=0,status=0,menubar=0,height=550,width=800,resizeable=1,scrollbars=1,fullscreen=0');"></a>
<a href="profile_labor.php?hid_card=<?=$row['id_card']?>&app=labor_practic" target="_blank"><img src="../../images/dash_icon/ico_preview.png" align="absmiddle" border="0" title="ดูทะเบียนผู้สูงอายุ"/></a>
<a href="index.php?p=labor_practice_keyin&runid=<?=$row['runid']?>&action=edit"><img src="../../images/dash_icon/ico_edit.png" align="absmiddle" border="0" title="แก้ไข"/></a>
<a href="javascript:if(confirm('ยืนยันลบ ?')) window.location.href='index.php?module=elderly_register&id=<?=$row['id_card']?>&course_training_id=<?=$row['course_training_id']?>&action=delete';"><img src="../../images/dash_icon/ico_del.png" align="absmiddle" border="0" title="ลบ"/></a></td>
</tr>
<?php
}
?>
</table>
<?
$id_card = $_POST['id_card'];
$get = "&id_card=".$id_card;
$get .= "&firstname=".$firstname;
$get .= "&surname=".$surname;
$get .= "&birthdate=".$birthdate;
$get .= "&district=".$district;
$get .= "&subdistrict=".$subdistrict;
$get .= "&elderly_branch_intellect_runid=".$elderly_branch_intellect_runid;
$get .= "®ister_date=".$register_date;
$get .= "&graduated=".$graduated;
$get .= "&occupation=".$occupation;
$get .= "&study=".$study;
$get .= "&teaching=".$teaching;
?>
<?
$time_e = microtime();
$stime = number_format($time_e - $time_start,12);
?>
<div> </div>
<div style="width:99%" align="right">ใช้เวลาในการประมวลผลก่อนการแสดง <strong><?=$stime?></strong> วินาที</div>
<form name="form2" id="form2" method="get">
<input name="p" id="p" type="hidden" value="<?=$_GET['p']?>" size="100"/>
<input name="start_register_date" id="start_register_date" type="hidden" value="" />
<input name="end_register_date" id="end_register_date" type="hidden" value="" />
<input name="id_card" id="id_card" type="hidden" value="" />
<input name="fname" id="fname" type="hidden" value="" />
<input name="lname" id="lname" type="hidden" value="" />
</form>
</BODY>
</HTML>