|
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");
?>
<!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'];
}
$sqlexsum = "SELECT
COUNT(labor_course_training.course_training_id ) AS count_course,
labor_master_course_branch.branch_name,
labor_course_training.course_branch_id
FROM
labor_course_training
Inner Join labor_master_course_branch ON labor_course_training.course_branch_id = labor_master_course_branch.branch_id
GROUP BY labor_course_training.course_branch_id
";
$resexsum = mysql_query($sqlexsum);
while($rowsum = mysql_fetch_assoc($resexsum)){
$arrPCVExSum[][] = $rowsum['count_course'];
$arrExSumData[] = $rowsum;
}
$arrPCExSum = percentage_2d($arrPCVExSum); #show($arrPCExSum);
### ส่ง พารามิเตอร์ สำหรับ export
$strSQL_1="SELECT
labor_course_training.course_year,
labor_course_training.company_period,
labor_course_training.course_period,
labor_course_training.course_training_id,
labor_course_training.course_name,
labor_master_course_branch.branch_type,
labor_master_course_branch.branch_name
FROM
labor_course_training
Inner Join labor_master_course_branch ON labor_course_training.course_branch_id = labor_master_course_branch.branch_id
WHERE course_training_id <> ''
";
if($_GET['course_training_id']){
$strSQL_1 .= " AND labor_course_training.`course_training_id` LIKE('%".$_GET['course_training_id']."%') ";
$strSearch .= "&course_training_id=".$_GET['course_training_id'];
}
if($_GET['course_name']){
$strSQL_1 .= " AND labor_course_training.`course_name` LIKE('%".$_GET['course_name']."%') ";
$strSearch .= "&course_name=".$_GET['course_name'];
}
if($_GET['course_branch_id']){
$strSQL_1 .= " AND labor_course_training.`course_branch_id` LIKE('%".$_GET['course_branch_id']."%') ";
$strSearch .= "&course_branch_id=".$_GET['course_branch_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
$count_course_all = 0;
$arrPCExSum_all = 0;
foreach($arrExSumData as $key=>$rowData){
$count_course_all+=$rowData['count_course'];
$arrPCExSum_all+=$arrPCExSum[$key][0];
?>
<tr bgcolor="#FFFFFF">
<td align="left"><span class="style6"><?php echo $rowData['branch_name'];?></span></td>
<td align="right"><span class="style5">
<?php
if($rowData['count_course']>0){
echo '<a href="index.php?p=labor_course&course_branch_id='.$rowData['course_branch_id'].'">'.number_format($rowData['count_course']).'</a>';
}else{
echo 0;
}
?>
</span></td>
<td align="right"><span class="style5">
<?=$arrPCExSum[$key][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_course&course_branch_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 = 'ระดับความรุนแรงน้อย;ระดับความรุนแรงปานกลาง;ระดับความรุนแรงมาก';
foreach ( $arrExSumData as $Key => $Val ) {
$dataGraph .= $Val['count_course'].';';
$catagory .= $Val['branch_name'].';';
}
$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_course.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"><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" /> </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=labor_course">ล้างค่าการค้นหา</a></td>
</tr>
<tr>
<td align="left">
<?php echo ($_GET['course_training_id'] != "")?' <strong>รหัสหลักสูตร</strong> "'.$_GET['course_training_id'].'"<br/>':"";?>
<?php echo ($_GET['course_name'] != "")?' <strong>ชื่อหลักสูตร</strong> "'.$_GET['course_name'].'"<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_course_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="200" class="bg_th">กลุ่มสาขาอาชีพ</td>
<td width="150" class="bg_th">ระยะเวลาฝึก<br>
ในสพร./ศพจ.(ชม.)</td>
<td width="150" class="bg_th">ระยะเวลาฝึก<br />
ในสถานประกอบการ(ชม.)</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 $row['course_year']?></td>
<td align="center"><?php echo searchReplace($_GET['course_training_id'],$row['course_training_id']);?></td>
<td ><?php echo searchReplace($_GET['course_name'],$row['course_name'])?></td>
<td align="center"><?php echo $row['branch_name']?></td>
<td align="center"><?php echo $row['course_period']?></td>
<td align="center"><?php echo $row['company_period']?></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=# onclick="window.open('elderly_register_preview.php?course_training_id=<?=$row['course_training_id']?>','export','toolbar=0,location=0,directories=0,status=0,menubar=0,height=550,width=800,resizeable=1,scrollbars=1');"><img src="../../images/dash_icon/ico_preview.png" align="absmiddle" border="0" title="ดูทะเบียนผู้สูงอายุ"/></a>
<a href="index.php?p=labor_course_keyin&runid=<?=$row['course_training_id']?>&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="course_training_id" id="course_training_id" type="hidden" value="" />
<input name="course_name" id="course_name" type="hidden" value="" />
</form>
</BODY>
</HTML>