|
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();
//include("../../config/config_durable_articles.inc.php");
include_once("../../config/config_epm.inc.php");
$graph_path = "http://202.129.35.106/graphservice/graphservice.php";
$APP_ID=1;
if($_GET["debug"] == "on"){
echo "<pre>";
print_r($_SESSION['SS_PERMISSION']);
echo "</pre>";
}
// echo "<pre>";
// print_r($_SESSION);
// echo "</pre>";
//labor_personal
//working_status
?>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<link rel="stylesheet" href="css/template.css" type="text/css" />
<link rel="stylesheet" href="css/style.css" type="text/css" />
<style type="text/css">
.witetext {
color: #FFF;
}
</style>
<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>
<p align="center"><strong>รายงานเปรียบเทียบข้อมูลแรงงาน จากสถานะการมีงานทำ</strong></p>
<table width="95%" border="0" align="center" cellpadding="1" cellspacing="1">
<tr>
<td> </td>
<td> </td>
<td align="right">ข้อมููล ณ วันที่
<?
$gdate = mysql_fetch_assoc(mysql_query("SELECT add_date FROM labor_personal ORDER BY add_date DESC "));
$day = explode(" ",$gdate['add_date']);
echo $day[0];
?>
</td>
</tr>
<tr>
<td width="57%" align="right"><table width="95%" border="0" align="right" cellpadding="1" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td width="23%" rowspan="2" class="bg_th"> </td>
<td colspan="3" align="center" class="bg_th"><span class="witetext"><strong>จำนวนแรงงานภาพรวม</strong></span></td>
</tr>
<tr>
<td width="21%" align="center" class="bg_th"><span class="witetext"><strong>ว่างงาน</strong></span></td>
<td width="27%" align="center" class="bg_th"><span class="witetext"><strong>มีงานทำ</strong></span></td>
<td width="29%" align="center" class="bg_th"><span class="witetext"><strong>ทั้งหมด</strong></span></td>
</tr>
<tr>
<td colspan="4" bgcolor="#CCCCCC"><strong>จังหวัดปทุมธานี</strong></td>
</tr>
<?
$get = mysql_query("SELECT * FROM labor_master_want ");
while( $ros = mysql_fetch_assoc($get) ){
$y = mysql_num_rows(mysql_query("SELECT * FROM labor_personal WHERE want_id='$ros[want_id]' AND p_province_id LIKE '13%' AND working_status='Y' "));
$n = mysql_num_rows(mysql_query("SELECT * FROM labor_personal WHERE want_id='$ros[want_id]' AND p_province_id LIKE '13%' AND working_status='N' "));
$yn_total = $y+$n;
$y_total = $y_total+$y;
$n_total = $n_total+$n;
if($y>0 and $n>0){
$yn_percen = ($y/$n)*100;
}
?>
<tr>
<td bgcolor="#FFFFFF"><?=$ros['detail']?></td>
<td align="right" bgcolor="#FFFFFF"><?=$n?></td>
<td align="right" bgcolor="#FFFFFF"><?=$y?></td>
<td align="right" bgcolor="#FFFFFF"><?=$yn_total?></td>
</tr>
<?
}
?>
<tr>
<td colspan="4" bgcolor="#CCCCCC"><strong>จังหวัดอื่นๆ</strong></td>
</tr>
<?
$get = mysql_query("SELECT * FROM labor_master_want ");
while( $ros = mysql_fetch_assoc($get) ){
$y = mysql_num_rows(mysql_query("SELECT * FROM labor_personal WHERE want_id='$ros[want_id]' AND ( p_province_id NOT LIKE '13%' OR p_province_id IS NULL ) AND working_status='Y' "));
$n = mysql_num_rows(mysql_query("SELECT * FROM labor_personal WHERE want_id='$ros[want_id]' AND ( p_province_id NOT LIKE '13%' OR p_province_id IS NULL ) AND working_status='N' "));
$yn_total = $y+$n;
$y_total = $y_total+$y;
$n_total = $n_total+$n;
if($y>0 and $n>0){
$yn_percen = ($n/$y)*100;
}
?>
<tr>
<td bgcolor="#FFFFFF"><?=$ros['detail']?></td>
<td align="right" bgcolor="#FFFFFF"><?=$n?></td>
<td align="right" bgcolor="#FFFFFF"><?=$y?></td>
<td align="right" bgcolor="#FFFFFF"><?=$yn_total?></td>
</tr>
<?
}
?>
<tr>
<td bgcolor="#CCCCCC"><strong>รวม</strong></td>
<td align="right" bgcolor="#CCCCCC"><?=$n_total?></td>
<td align="right" bgcolor="#CCCCCC"><?=$y_total?></td>
<td align="right" bgcolor="#CCCCCC"><?=$y_total+$n_total?></td>
</tr>
</table></td>
<td width="1%"> </td>
<td width="42%" align="right">
<?
$xgraphur_link = "http://202.129.35.106/graphservice/graphservice.php?category=ว่างงาน;มีงานทำ&data1=".$n_total.";".$y_total."&outputstyle=&numseries=1&seriesname=&graphtype=pie&title=กราฟแสดงการเปรียบเทียบการมีงานทำของประชาชน &xname=&yname=&subtitle=&graphstyle=srd_allvisible_lg.scs";
?>
<table width="400" align="right" border="0" bgcolor="#000D70">
<tr>
<td align="right"><a href="<?=$xgraphur_link?>" target="_blank"><img src="images/maximize.gif" align="absmiddle" border="0" /></a></td>
</tr>
<tr>
<td>
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="400" height="200" >
<param name="movie" value="<?=$xgraphur_link?>">
<param name="quality" value="high">
<param name="wmode" value="transparent">
<embed src="<?=$xgraphur_link?>" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="400" height="200" wmode="transparent"></embed>
</object>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="right"><strong><a href="?p=labor_report_person&action=detail&show=aumpur&digi=13&part_name=จังหวัดปทุมธานี">แสดงข้อมูลของจังหวัดปทุมธานี </a>| <a href="?p=<?=$_GET['p']?>&action=detail">แสดงข้อมูลของทุกจังหวัด</a></strong></td>
<td> </td>
<td> </td>
</tr>
</table>
<p> </p>
<table width="95%" border="0" align="center" cellpadding="1" cellspacing="1">
<tr>
<td><?
#function genlink all part name.
#Create By Narong Roumsuk (Di). 2010/09/28
if($_GET['part_name']==''){
//unset($_SESSION['industry_part_name']);
$_SESSION['industry_part_name'] = array();
}
function genPart($prevPart,$namePart){
/*print"<script language='JavaScript'> alert('test') </script> ";*/
if(!$_SESSION['industry_part_name']){
$_SESSION['industry_part_name'] = array();
}
$arr=$_SESSION['industry_part_name'];
$numArrPart=count($arr);
$chk=0;
$chkII=0;
for($i=0;$i<$numArrPart;$i++){
if($arr[$i][caption]==$namePart){
$chk=1;
$chkII=$i;
}
}
if($chk==1){
/*print"<script language='JavaScript'> alert('test') </script> ";*/
$tempArr=array();
for($i=0;$i<=$chkII;$i++){
$tempArr[]=array(caption=>$arr[$i][caption],prevpart=>$arr[$i][prevpart]);
}
$_SESSION['industry_part_name']=array();
$_SESSION['industry_part_name']=$tempArr;
}else{
$_SESSION['industry_part_name'][]= array(caption=>$namePart,prevpart=>$prevPart);
}
$arr=$_SESSION['industry_part_name'];
$numArrPart=count($arr);
$strPart='';
for($i=0;$i<$numArrPart;$i++){
$strPart.='<a href="'.$arr[$i][prevpart].'">'.$arr[$i][caption].'</a> ==> ';
}
echo $strPart;
}#end function genlink all part name.
echo '<br>';
//addCart($_SERVER['HTTP_REFERER'],$_GET['part_name']);
if($_GET['part_name']!=""){
genPart($_SERVER['HTTP_REFERER'],$_GET['part_name']);
}
?></td>
</tr>
</table>
<?
if($_GET['action']=="detail"){
if($_GET['show']==""){
$sql_area = "SELECT * FROM ccaa WHERE ccType='Changwat' ORDER BY ccName ASC ";
$area_type = "จังหวัด";
}else if($_GET['show']=="aumpur"){
$sql_area = "SELECT * FROM tbl_ccaa WHERE ccDigi LIKE '$digi%' AND ccType='Aumpur' ";
$area_type = "อำเภอ";
}else if($_GET['show']=="tumbon"){
$sql_area = "SELECT * FROM tbl_ccaa WHERE ccDigi LIKE '$digi%' AND ccType='Tamboon' ";
$area_type = "ตำบล";
}else if($_GET['show']=="mooban"){
$sql_area = "SELECT* FROM tbl_ccaa_village WHERE ccDigi LIKE '$digi%' ";
$area_type = "หมู่บ้าน";
}
?>
<table width="95%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td width="27%" rowspan="3" class="bg_th"><?=$area_type?></td>
<td colspan="9" align="center" class="bg_th">แสดงจำนวนแรงงานรายพื้นที่</td>
</tr>
<tr>
<td colspan="3" align="center" class="bg_th">นักศึกษา</td>
<td colspan="3" align="center" class="bg_th">คนว่างงาน</td>
<td colspan="3" align="center" class="bg_th">ต้องการเปลี่ยนงาน</td>
</tr>
<tr>
<td width="11%" class="bg_th">ได้งาน</td>
<td width="11%" class="bg_th">ว่างงาน</td>
<td width="8%" class="bg_th">ทั้งหมด</td>
<td width="8%" class="bg_th">ได้งาน</td>
<td width="7%" class="bg_th">ว่างงาน</td>
<td width="9%" class="bg_th">ทั้งหมด</td>
<td width="7%" class="bg_th">ได้งาน</td>
<td width="6%" class="bg_th">ว่างงาน</td>
<td width="6%" class="bg_th">ทั้งหมด</td>
</tr>
<?
//echo $sql_area;
$area = mysql_query($sql_area);
while( $row = mysql_fetch_array($area)){
$area_name = str_replace("จังหวัด","",$row['ccName']);
if($_GET['show']==""){
$digi = substr($row['ccDigi'],0,2);
$link = "?p=labor_report_person&action=detail&show=aumpur&digi=$digi&part_name=$area_name";
$sql_and = " AND p_province_id = '$row[ccDigi]' ";
}else if($_GET['show']=="aumpur"){
$digi = substr($row['ccDigi'],0,4);
$link = "?p=labor_report_person&action=detail&show=tumbon&digi=$digi&part_name=$area_name";
$sql_and = " AND p_ampur_id = '$row[ccDigi]' ";
}else if($_GET['show']=="tumbon"){
$digi = substr($row['ccDigi'],0,6);
$link = "?p=labor_report_person&action=detail&show=mooban&digi=$digi&part_name=$area_name";
$sql_and = " AND p_tambol_id = '$row[ccDigi]' ";
}else if($_GET['show']=="mooban"){
$digi = substr($row['ccDigi'],0,8);
$sql_and = " AND p_moo_id = '$row[ccDigi]' ";
//$link = "?p=labor_report_person&action=detail&show=aumpur&digi=$digi";
}
$y1 = mysql_num_rows(mysql_query("SELECT * FROM labor_personal WHERE want_id='1' AND working_status='Y' $sql_and "));
$y2 = mysql_num_rows(mysql_query("SELECT * FROM labor_personal WHERE want_id='2' AND working_status='Y' $sql_and "));
$y3 = mysql_num_rows(mysql_query("SELECT * FROM labor_personal WHERE want_id='3' AND working_status='Y' $sql_and "));
$n1 = mysql_num_rows(mysql_query("SELECT * FROM labor_personal WHERE want_id='1' AND working_status='N' $sql_and "));
$n2 = mysql_num_rows(mysql_query("SELECT * FROM labor_personal WHERE want_id='2' AND working_status='N' $sql_and "));
$n3 = mysql_num_rows(mysql_query("SELECT * FROM labor_personal WHERE want_id='3' AND working_status='N' $sql_and "));
$yn1 = $y1+$n1;
$yn2 = $y2+$n2;
$yn3 = $y3+$n3;
$total_y1 = $total_y1+$y1;
$total_y2 = $total_y2+$y2;
$total_y3 = $total_y3+$y3;
$total_n1 = $total_n1+$n1;
$total_n2 = $total_n2+$n2;
$total_n3 = $total_n3+$n3;
$total_yn1 = $total_yn1+$yn1;
$total_yn2 = $total_yn2+$yn2;
$total_yn3 = $total_yn3+$yn3;
?>
<tr>
<td bgcolor="#FFFFFF"><a href="<?=$link?>"><?=$area_name?></a></td>
<td align="center" bgcolor="#FFFFFF"><?=$y1?></td>
<td align="center" bgcolor="#FFFFFF"><?=$n1?></td>
<td align="center" bgcolor="#FFFFFF"><?=$yn1?></td>
<td align="center" bgcolor="#FFFFFF"><?=$y2?></td>
<td align="center" bgcolor="#FFFFFF"><?=$n2?></td>
<td align="center" bgcolor="#FFFFFF"><?=$yn2?></td>
<td align="center" bgcolor="#FFFFFF"><?=$y3?></td>
<td align="center" bgcolor="#FFFFFF"><?=$n3?></td>
<td align="center" bgcolor="#FFFFFF"><?=$yn3?></td>
</tr>
<?
} // end loop
?>
<tr>
<td align="center" bgcolor="#CCCCCC"><strong>รวม</strong></td>
<td align="center" bgcolor="#CCCCCC"><strong>
<?=$total_y1?>
</strong></td>
<td align="center" bgcolor="#CCCCCC"><strong>
<?=$total_y2?>
</strong></td>
<td align="center" bgcolor="#CCCCCC"><strong>
<?=$total_y3?>
</strong></td>
<td align="center"><strong>
<?=$total_n1?>
</strong></td>
<td align="center"><strong>
<?=$total_n2?>
</strong></td>
<td align="center"><strong>
<?=$total_n3?>
</strong></td>
<td align="center"><strong>
<?=$total_yn1?>
</strong></td>
<td align="center"><strong>
<?=$total_yn2?>
</strong></td>
<td align="center"><strong>
<?=$total_yn3?>
</strong></td>
</tr>
</table>
<?
}
?>
<p> </p>