|
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">
<?
if($_GET['parent_id']==""){
$parent_id=0;
}
$get = mysql_query("SELECT * FROM labor_master_position WHERE parent_id=$parent_id ");
while( $ros = mysql_fetch_assoc($get) ){
if($_GET['parent_id']==""){
$chk = "SELECT
labor_personal_typework.id_card,
labor_personal_typework.position_id,
labor_personal.p_moo_id,
labor_personal.p_tambol_id,
labor_personal.p_ampur_id,
labor_personal.p_province_id,
labor_personal.fname,
labor_personal.lname
FROM
labor_personal_typework
Inner Join labor_personal ON labor_personal_typework.id_card = labor_personal.id_card
WHERE
labor_personal_typework.id_card!=''
AND labor_personal_typework.position_id IN (SELECT position_id FROM labor_master_position WHERE parent_id=$ros[position_id])
";
$ckj = "SELECT SUM(position_qty) AS position_qty FROM labor_vacancy WHERE position_id IN (SELECT position_id FROM labor_master_position WHERE parent_id=$ros[position_id]) ";
}else{
$chk = "SELECT
labor_personal_typework.id_card,
labor_personal_typework.position_id,
labor_personal.p_moo_id,
labor_personal.p_tambol_id,
labor_personal.p_ampur_id,
labor_personal.p_province_id,
labor_personal.fname,
labor_personal.lname
FROM
labor_personal_typework
Inner Join labor_personal ON labor_personal_typework.id_card = labor_personal.id_card
WHERE
labor_personal_typework.id_card!=''
AND labor_personal_typework.position_id =$ros[position_id]
";
$ckj = "SELECT SUM(position_qty) AS position_qty FROM labor_vacancy WHERE position_id =$ros[position_id] ";
}
//echo $chk."<hr>";
$per = mysql_num_rows(mysql_query($chk));
$job_row = mysql_fetch_assoc(mysql_query($ckj));
if($job_row['position_qty']>0){
$job = $job_row['position_qty'];
}else{
$job = 0;
}
$dis_ex = $job-$per;
if($job==0 and $per==0){
$score4 = $score4+1;
}else if($dis_ex>0){
$score1 = $score1+1;
}else if($dis_ex<0){
$score2 = $score2+1;
}else if($dis_ex==0){
$score3 = $score3+1;
}
}
?>
<table width="95%" border="0" cellspacing="1" cellpadding="1" bgcolor="#CCCCCC">
<tr>
<td width="37%" class="bg_th"> </td>
<td width="23%" class="bg_th">รวม (หมวดหมู่งาน)</td>
</tr>
<tr>
<td align="left" bgcolor="#FFFFFF"><strong>ขาดแคลนตลาดแรงงาน</strong></td>
<td align="center" bgcolor="#FFFFFF"><?=number_format($score1)?></td>
</tr>
<tr>
<td align="left" bgcolor="#FFFFFF"><strong>หมวดตำแหน่งงานไม่เพียงพอ</strong></td>
<td align="center" bgcolor="#FFFFFF"><?=number_format($score2)?></td>
</tr>
<tr>
<td align="left" bgcolor="#FFFFFF"><strong>หมวดตำแหน่งงานเพียงพอ</strong></td>
<td align="center" bgcolor="#FFFFFF"><?=number_format($score3)?></td>
</tr>
<tr>
<td align="left" bgcolor="#FFFFFF"><strong>หมวดตำแหน่งงานที่ไม่อยู่ในความสนใจ</strong></td>
<td align="center" bgcolor="#FFFFFF"><?=number_format($score4)?></td>
</tr>
</table></td>
<td width="1%"> </td>
<td width="42%" align="right" valign="top">
<?
$xgraphur_link = "http://202.129.35.106/graphservice/graphservice.php?category=ขาดแคลนตลาดแรงงาน;หมวดตำแหน่งงานไม่เพียงพอ;หมวดตำแหน่งงานเพียงพอ;หมวดตำแหน่งงานที่ไม่อยู่ในความสนใจ&data1=".(int)$score1.";".(int)$score2.";".(int)$score3.";".(int)$score4."&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"> </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>
<table width="90%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td width="45%" class="bg_th">ประเภทงาน</td>
<td width="16%" align="center" class="bg_th">อัตราว่าง (ตำแหน่ง)</td>
<td width="18%" align="center" class="bg_th">คนต้องการงาน (ราย)</td>
<td width="21%" align="center" class="bg_th">ผลต่าง (อัตราว่าง - คนต้องการงาน)</td>
</tr>
<?
if($_GET['parent_id']==""){
$parent_id=0;
}
$get = mysql_query("SELECT * FROM labor_master_position WHERE parent_id=$parent_id ");
while( $ros = mysql_fetch_assoc($get) ){
if($_GET['parent_id']==""){
$chk = "SELECT
labor_personal_typework.id_card,
labor_personal_typework.position_id,
labor_personal.p_moo_id,
labor_personal.p_tambol_id,
labor_personal.p_ampur_id,
labor_personal.p_province_id,
labor_personal.fname,
labor_personal.lname
FROM
labor_personal_typework
Inner Join labor_personal ON labor_personal_typework.id_card = labor_personal.id_card
WHERE
labor_personal_typework.id_card!=''
AND labor_personal_typework.position_id IN (SELECT position_id FROM labor_master_position WHERE parent_id=$ros[position_id])
";
$ckj = "SELECT SUM(position_qty) AS position_qty FROM labor_vacancy WHERE position_id IN (SELECT position_id FROM labor_master_position WHERE parent_id=$ros[position_id]) ";
}else{
$chk = "SELECT
labor_personal_typework.id_card,
labor_personal_typework.position_id,
labor_personal.p_moo_id,
labor_personal.p_tambol_id,
labor_personal.p_ampur_id,
labor_personal.p_province_id,
labor_personal.fname,
labor_personal.lname
FROM
labor_personal_typework
Inner Join labor_personal ON labor_personal_typework.id_card = labor_personal.id_card
WHERE
labor_personal_typework.id_card!=''
AND labor_personal_typework.position_id =$ros[position_id]
";
$ckj = "SELECT SUM(position_qty) AS position_qty FROM labor_vacancy WHERE position_id =$ros[position_id] ";
}
//echo $chk."<hr>";
$per = mysql_num_rows(mysql_query($chk));
$job_row = mysql_fetch_assoc(mysql_query($ckj));
if($job_row['position_qty']>0){
$job = $job_row['position_qty'];
}else{
$job = 0;
}
$dis_ex = $job-$per;
if($dis_ex>0){
$font = '<font color="#006600">';
}else if($dis_ex<0){
$font = '<font color="#CC0000">';
}else{
$font ='<font color="#000000">';
}
$total_job = $total_job+$job;
$total_per = $total_per+$per;
################################################################################
?>
<tr>
<td bgcolor="#FFFFFF">
<? if($parent_id<1){ ?><a href="?p=<?=$p?>&parent_id=<?=$ros['position_id']?>&part_name=<?=$ros['position_name']?>"><? } ?>
<?=$ros['position_name']?>
</a>
</td>
<td align="right" bgcolor="#FFFFFF"><?=$job?></td>
<td align="right" bgcolor="#FFFFFF"><?=$per?></td>
<td align="right" bgcolor="#FFFFFF"><strong>
<?=$font?>
<?=$dis_ex?>
</strong></td>
</tr>
<?
}
$total_ex = $total_job-$total_per;
if($total_ex>0){
$font = '<font color="#006600">';
}else if($total_ex<0){
$font = '<font color="#CC0000">';
}else{
$font ='<font color="#000000">';
}
?>
<tr>
<td bgcolor="#CCCCCC"><strong>รวม</strong></td>
<td align="right" bgcolor="#CCCCCC"><?=$total_job?></td>
<td align="right" bgcolor="#CCCCCC"><?=$total_per?></td>
<td align="right" bgcolor="#CCCCCC"><strong>
<?=$font?>
<?=$total_ex?>
</strong></td>
</tr>
</table>
<p> </p>