|
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/industry/ |
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");
?>
<!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;
}
.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:#305086;
font-weight:bold;
color:#FFFFFF;
text-align:center;
}
.style1 {
font-size: 18px;
font-weight: bold;
}
</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>
</head>
<body>
<?
//include("header.php");
//$year=date('Y')+543;
?>
<table width="95%" border="0" align="center" cellpadding="3" cellspacing="1">
<tr>
<td width="38%"><strong>กระดานแสดงข้อมูลด้านอุตสาหกรรม ข้อมูล ณ วันที่ <?=dateFormat(date('Y-m-d'),'thaidot')?></strong></td>
<td width="62%">
<form name="form1" id="form1" method="get" onsubmit="report_industry_expansion.php?row=<?=$_GET['row']?>">
<?
$sqlYear1=" SELECT industry_register.fyear
FROM industry_register
WHERE industry_register.fyear IS NOT NULL AND industry_register.fyear!=''
GROUP BY industry_register.fyear
ORDER BY industry_register.fyear ASC ";
$rsYear1=mysql_db_query($dbname,$sqlYear1);
$resYear1=mysql_fetch_assoc($rsYear1);
$sqlYear2=" SELECT industry_register.fyear
FROM industry_register
WHERE industry_register.fyear IS NOT NULL AND industry_register.fyear!=''
GROUP BY industry_register.fyear
ORDER BY industry_register.fyear DESC ";
$rsYear2=mysql_db_query($dbname,$sqlYear2);
$resYear2=mysql_fetch_assoc($rsYear2);
/*$year_start_value=(date('Y')-5)+543;
$year_end_value=(date('Y')+543);*/
if($_GET['year_start']){
$year_start_value=$_GET['year_start'];
}else{
$year_start_value=(date('Y')-1)+543;
}
if($_GET['year_end']){
$year_end_value=$_GET['year_end'];
}else{
$year_end_value=(date('Y')+543);
}
?>
<strong>เลือกปี พ.ศ. </strong>
<select name="year_start" id="year_start">
<option value="">เลือกปี พ.ศ.</option>
<?php
for($y1=$resYear1['fyear'];$y1<=$resYear2['fyear'];$y1++){
?>
<option value="<?=$y1?>" <? if($y1==$year_start_value){ echo "selected"; } ?>>
<?=$y1?>
<?
}
?>
</select>
<strong>และ</strong>
<select name="year_end" id="year_end">
<option value="">เลือกปี พ.ศ.</option>
<?php
for($y1=$resYear1['fyear'];$y1<=$resYear2['fyear'];$y1++){
?>
<option value="<?=$y1?>" <? if($y1==$year_end_value){ echo "selected"; } ?>>
<?=$y1?>
<?
}
?>
</select>
<input type="submit" name="Submit" value="ตกลง" />
</form>
</td>
</tr>
</table>
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="4">
<tr><td valign="top" align="center" width="60%">
<table width="85%" border="0" align="center" bgcolor="#CCCCCC" cellpadding="3" cellspacing="1">
<tr class="bg_th">
<td width="200"><strong>รายการ</strong></td>
<td width="100"><strong>ปี พ.ศ. <?=$year_start_value?></strong></td>
<td width="100"><strong>ปี พ.ศ. <?=$year_end_value?></strong></td>
<td width="100"><strong>หน่วย</strong></td>
<td width="100"><strong>อัตราการขยายตัว (%)</strong></td>
</tr>
<?
$rows[1]= array(id=>"1",caption=>"จำนวนโรงงาน",unit=>'โรง');
$rows[2]= array(id=>"2",caption=>"ด้านเศรษฐกิจ (เงินลงทุน)",unit=>'ล้านบาท');
$rows[3]= array(id=>"3",caption=>"ด้านแรงงาน",unit=>'คน');
$rows[4]= array(id=>"4",caption=>"ด้านสิ่งแวดล้อม (น้ำทิ้ง)",unit=>'ลบ.ม./ปี');
$rows[5]= array(id=>"5",caption=>"ด้านพื้นที่อุตสาหกรรม",unit=>'ไร่');
$numRows=count($rows);
for($x=1;$x<=$numRows;$x++){
$strSQL_1_1 = "SELECT
SUM(industry_register.capital) AS numCapital,
SUM(industry_register.men) AS numMen,
COUNT(industry_register.code) AS numCode,
SUM(industry_register.fact_area) AS numFact_area
FROM industry_register
WHERE fyear='".$year_end_value."'
";
//echo $strSQL_1_1;
$rsConn_1_1 = mysql_db_query($dbname,$strSQL_1_1);
$Result_1_1 = mysql_fetch_assoc($rsConn_1_1);
$strSQL_1_2 = "SELECT
SUM(industry_register.capital) AS numCapital,
SUM(industry_register.men) AS numMen,
COUNT(industry_register.code) AS numCode,
SUM(industry_register.fact_area) AS numFact_area
FROM industry_register
WHERE fyear='".$year_start_value."'
";
$rsConn_1_2 = mysql_db_query($dbname,$strSQL_1_2);
$Result_1_2 = mysql_fetch_assoc($rsConn_1_2);
//echo $Result_1_1['numCode'].' '.$Result_1_2['numCode'];
if($x==1){
$numberYearEnd=number_format($Result_1_1['numCode']);
$numberYearStart=number_format($Result_1_2['numCode']);
if($Result_1_2['numCode']==0){
$delta=0;
}else{
$delta=(($Result_1_1['numCode']-$Result_1_2['numCode'])/$Result_1_2['numCode'])*100;
}
}
else if($x==2){
$numberYearEnd=number_format(($Result_1_1['numCapital']/1000000),2);
$numberYearStart=number_format(($Result_1_2['numCapital']/1000000),2);
if($Result_1_2['numCapital']==0){
$delta=0;
}else{
$delta=(($Result_1_1['numCapital']-$Result_1_2['numCapital'])/$Result_1_2['numCapital'])*100;
}
}
else if($x==3){
$numberYearEnd=number_format($Result_1_1['numMen']);
$numberYearStart=number_format($Result_1_2['numMen']);
if($Result_1_2['numMen']==0){
$delta=0;
}else{
$delta=(($Result_1_1['numMen']-$Result_1_2['numMen'])/$Result_1_2['numMen'])*100;
}
}
else if($x==4){
$strSQL_1_3 = "SELECT wage_qnty1,wage_qnty2
FROM industry_register
WHERE fyear='".$year_end_value."'
";
$rsConn_1_3 = mysql_db_query($dbname,$strSQL_1_3);
$totalWage_qnty=0;
while($Result_1_3 = mysql_fetch_assoc($rsConn_1_3)){
if(substr($Result_1_3['wage_qnty2'],0,2)=='ลบ' && substr($Result_1_3['wage_qnty2'],strpos($Result_1_3['wage_qnty2'],'/')+1,1)=='ว'){
$totalWage_qnty+=($Result_1_3['wage_qnty1']*356);
}else if(substr($Result_1_3['wage_qnty2'],0,2)=='ลบ' && substr($Result_1_3['wage_qnty2'],strpos($Result_1_3['wage_qnty2'],'/')+1,2)=='อา'){
$totalWage_qnty+=($Result_1_3['wage_qnty1']*52);
}else if(substr($Result_1_3['wage_qnty2'],0,2)=='ลบ' && substr($Result_1_3['wage_qnty2'],strpos($Result_1_3['wage_qnty2'],'/')+1,2)=='เด'){
$totalWage_qnty+=($Result_1_3['wage_qnty1']*12);
}else if(substr($Result_1_3['wage_qnty2'],0,4)=='ลิตร' && substr($Result_1_3['wage_qnty2'],strpos($Result_1_3['wage_qnty2'],'/')+1,1)=='ว'){
$totalWage_qnty+=($Result_1_3['wage_qnty1']/1000)*356;
}else if(substr($Result_1_3['wage_qnty2'],0,4)=='ลิตร' && substr($Result_1_3['wage_qnty2'],strpos($Result_1_3['wage_qnty2'],'/')+1,2)=='อา'){
$totalWage_qnty+=($Result_1_3['wage_qnty1']/1000)*52;
}else if(substr($Result_1_3['wage_qnty2'],0,4)=='ลิตร' && substr($Result_1_3['wage_qnty2'],strpos($Result_1_3['wage_qnty2'],'/')+1,2)=='เด'){
$totalWage_qnty+=($Result_1_3['wage_qnty1']/1000)*12;
}
}
$strSQL_1_4 = "SELECT wage_qnty1,wage_qnty2
FROM industry_register
WHERE fyear='".$year_start_value."'
";
$rsConn_1_4 = mysql_db_query($dbname,$strSQL_1_4);
$totalWage_qnty_1=0;
while($Result_1_4 = mysql_fetch_assoc($rsConn_1_4)){
if(substr($Result_1_4['wage_qnty2'],0,2)=='ลบ' && substr($Result_1_4['wage_qnty2'],strpos($Result_1_4['wage_qnty2'],'/')+1,1)=='ว'){
$totalWage_qnty_1+=($Result_1_4['wage_qnty1']*356);
}else if(substr($Result_1_4['wage_qnty2'],0,2)=='ลบ' && substr($Result_1_4['wage_qnty2'],strpos($Result_1_4['wage_qnty2'],'/')+1,2)=='อา'){
$totalWage_qnty_1+=($Result_1_4['wage_qnty1']*52);
}else if(substr($Result_1_4['wage_qnty2'],0,2)=='ลบ' && substr($Result_1_4['wage_qnty2'],strpos($Result_1_4['wage_qnty2'],'/')+1,2)=='เด'){
$totalWage_qnty_1+=($Result_1_4['wage_qnty1']*12);
}else if(substr($Result_1_4['wage_qnty2'],0,4)=='ลิตร' && substr($Result_1_4['wage_qnty2'],strpos($Result_1_4['wage_qnty2'],'/')+1,1)=='ว'){
$totalWage_qnty_1+=($Result_1_4['wage_qnty1']/1000)*356;
}else if(substr($Result_1_4['wage_qnty2'],0,4)=='ลิตร' && substr($Result_1_4['wage_qnty2'],strpos($Result_1_4['wage_qnty2'],'/')+1,2)=='อา'){
$totalWage_qnty_1+=($Result_1_4['wage_qnty1']/1000)*52;
}else if(substr($Result_1_4['wage_qnty2'],0,4)=='ลิตร' && substr($Result_1_4['wage_qnty2'],strpos($Result_1_4['wage_qnty2'],'/')+1,2)=='เด'){
$totalWage_qnty_1+=($Result_1_4['wage_qnty1']/1000)*12;
}
}
$numberYearEnd=number_format($totalWage_qnty,2);
$numberYearStart=number_format($totalWage_qnty_1,2);
if($totalWage_qnty_1==0){
$delta=0;
}else{
$delta=(($totalWage_qnty-$totalWage_qnty_1)/$totalWage_qnty_1)*100;
}
}
else if($x==5){
$fact1=$Result_1_1['numFact_area']/1600;
$fact2=$Result_1_2['numFact_area']/1600;
$numberYearEnd=number_format($fact1,2);
$numberYearStart=number_format($fact2,2);
if($Result_1_2['numFact_area']==0){
$delta=0;
}else{
$delta=(($fact1-$fact2)/$fact2)*100;
}
}
?>
<tr bgcolor="#FFFFFF">
<td align="left"><strong><?=$rows[$x][caption]?></strong></td>
<td align="right"><a href="report_3year.php?year=<?=$year_start_value?>&caption=<?=$x?>" target="_blank"><?=$numberYearStart?></a></td>
<td align="right"><a href="report_3year.php?year=<?=$year_end_value?>&caption=<?=$x?>" target="_blank"><?=$numberYearEnd?></a></td>
<td align="center"><?=$rows[$x][unit]?></td>
<td align="center"><?=numberSymbolPercen($delta)?></td>
</tr>
<? }?>
</table>
</td>
<td width="5"></td>
<td valign="top"><?
$catagory='';
$seriname='';
for($x=1;$x<=$numRows;$x++){
$year=date('Y')+543;
$data[$x]='';
for($a=($year-4);$a<=$year;$a++){
$strSQL_1_1 = "SELECT
SUM(industry_register.capital) AS numCapital,
SUM(industry_register.men) AS numMen,
COUNT(industry_register.code) AS numCode,
SUM(industry_register.fact_area) AS numFact_area
FROM industry_register
WHERE fyear='".$a."'
";
//echo $strSQL_1_1;
$rsConn_1_1 = mysql_db_query($dbname,$strSQL_1_1);
$Result_1_1 = mysql_fetch_assoc($rsConn_1_1);
$strSQL_1_2 = "SELECT
SUM(industry_register.capital) AS numCapital,
SUM(industry_register.men) AS numMen,
COUNT(industry_register.code) AS numCode,
SUM(industry_register.fact_area) AS numFact_area
FROM industry_register
WHERE fyear='".($a-1)."'
";
$rsConn_1_2 = mysql_db_query($dbname,$strSQL_1_2);
$Result_1_2 = mysql_fetch_assoc($rsConn_1_2);
//echo $Result_1_1['numCode'].' '.$Result_1_2['numCode'];
if($x==1){
$numberYearEnd=number_format($Result_1_1['numCode']);
$numberYearStart=number_format($Result_1_2['numCode']);
if($Result_1_2['numCode']==0){
$delta=0;
}else{
$delta=(($Result_1_1['numCode']-$Result_1_2['numCode'])/$Result_1_2['numCode'])*100;
}
}
else if($x==2){
$numberYearEnd=number_format(($Result_1_1['numCapital']/1000000),2);
$numberYearStart=number_format(($Result_1_2['numCapital']/1000000),2);
if($Result_1_2['numCapital']==0){
$delta=0;
}else{
$delta=(($Result_1_1['numCapital']-$Result_1_2['numCapital'])/$Result_1_2['numCapital'])*100;
}
}
else if($x==3){
$numberYearEnd=number_format($Result_1_1['numMen']);
$numberYearStart=number_format($Result_1_2['numMen']);
if($Result_1_2['numMen']==0){
$delta=0;
}else{
$delta=(($Result_1_1['numMen']-$Result_1_2['numMen'])/$Result_1_2['numMen'])*100;
}
}
else if($x==4){
$strSQL_1_3 = "SELECT wage_qnty1,wage_qnty2
FROM industry_register
WHERE fyear='".$a."'
";
$rsConn_1_3 = mysql_db_query($dbname,$strSQL_1_3);
$totalWage_qnty=0;
while($Result_1_3 = mysql_fetch_assoc($rsConn_1_3)){
if(substr($Result_1_3['wage_qnty2'],0,2)=='ลบ' && substr($Result_1_3['wage_qnty2'],strpos($Result_1_3['wage_qnty2'],'/')+1,1)=='ว'){
$totalWage_qnty+=($Result_1_3['wage_qnty1']*356);
}else if(substr($Result_1_3['wage_qnty2'],0,2)=='ลบ' && substr($Result_1_3['wage_qnty2'],strpos($Result_1_3['wage_qnty2'],'/')+1,2)=='อา'){
$totalWage_qnty+=($Result_1_3['wage_qnty1']*52);
}else if(substr($Result_1_3['wage_qnty2'],0,2)=='ลบ' && substr($Result_1_3['wage_qnty2'],strpos($Result_1_3['wage_qnty2'],'/')+1,2)=='เด'){
$totalWage_qnty+=($Result_1_3['wage_qnty1']*12);
}else if(substr($Result_1_3['wage_qnty2'],0,4)=='ลิตร' && substr($Result_1_3['wage_qnty2'],strpos($Result_1_3['wage_qnty2'],'/')+1,1)=='ว'){
$totalWage_qnty+=($Result_1_3['wage_qnty1']/1000)*356;
}else if(substr($Result_1_3['wage_qnty2'],0,4)=='ลิตร' && substr($Result_1_3['wage_qnty2'],strpos($Result_1_3['wage_qnty2'],'/')+1,2)=='อา'){
$totalWage_qnty+=($Result_1_3['wage_qnty1']/1000)*52;
}else if(substr($Result_1_3['wage_qnty2'],0,4)=='ลิตร' && substr($Result_1_3['wage_qnty2'],strpos($Result_1_3['wage_qnty2'],'/')+1,2)=='เด'){
$totalWage_qnty+=($Result_1_3['wage_qnty1']/1000)*12;
}
}
$strSQL_1_4 = "SELECT wage_qnty1,wage_qnty2
FROM industry_register
WHERE fyear='".($a-1)."'
";
$rsConn_1_4 = mysql_db_query($dbname,$strSQL_1_4);
$totalWage_qnty_1=0;
while($Result_1_4 = mysql_fetch_assoc($rsConn_1_4)){
if(substr($Result_1_4['wage_qnty2'],0,2)=='ลบ' && substr($Result_1_4['wage_qnty2'],strpos($Result_1_4['wage_qnty2'],'/')+1,1)=='ว'){
$totalWage_qnty_1+=($Result_1_4['wage_qnty1']*356);
}else if(substr($Result_1_4['wage_qnty2'],0,2)=='ลบ' && substr($Result_1_4['wage_qnty2'],strpos($Result_1_4['wage_qnty2'],'/')+1,2)=='อา'){
$totalWage_qnty_1+=($Result_1_4['wage_qnty1']*52);
}else if(substr($Result_1_4['wage_qnty2'],0,2)=='ลบ' && substr($Result_1_4['wage_qnty2'],strpos($Result_1_4['wage_qnty2'],'/')+1,2)=='เด'){
$totalWage_qnty_1+=($Result_1_4['wage_qnty1']*12);
}else if(substr($Result_1_4['wage_qnty2'],0,4)=='ลิตร' && substr($Result_1_4['wage_qnty2'],strpos($Result_1_4['wage_qnty2'],'/')+1,1)=='ว'){
$totalWage_qnty_1+=($Result_1_4['wage_qnty1']/1000)*356;
}else if(substr($Result_1_4['wage_qnty2'],0,4)=='ลิตร' && substr($Result_1_4['wage_qnty2'],strpos($Result_1_4['wage_qnty2'],'/')+1,2)=='อา'){
$totalWage_qnty_1+=($Result_1_4['wage_qnty1']/1000)*52;
}else if(substr($Result_1_4['wage_qnty2'],0,4)=='ลิตร' && substr($Result_1_4['wage_qnty2'],strpos($Result_1_4['wage_qnty2'],'/')+1,2)=='เด'){
$totalWage_qnty_1+=($Result_1_4['wage_qnty1']/1000)*12;
}
}
$numberYearEnd=number_format($totalWage_qnty,2);
$numberYearStart=number_format($totalWage_qnty_1,2);
if($totalWage_qnty_1==0){
$delta=0;
}else{
$delta=(($totalWage_qnty-$totalWage_qnty_1)/$totalWage_qnty_1)*100;
}
}
else if($x==5){
$fact1=$Result_1_1['numFact_area']/1600;
$fact2=$Result_1_2['numFact_area']/1600;
$numberYearEnd=number_format($fact1,2);
$numberYearStart=number_format($fact2,2);
if($Result_1_2['numFact_area']==0){
$delta=0;
}else{
$delta=(($fact1-$fact2)/$fact2)*100;
}
}
if($x==1){
$catagory.='พ.ศ.'.$a.';';
}
$data[$x].=number_format($delta,2).';';
//echo 'test<br>';
}
$data[$x]=substr($data[$x],0,strlen($data[$x])-1);
$seriname.=$rows[$x][caption].';';
}
$numcountData=count($data);
$data1='';
for($b=1;$b<=$numcountData;$b++){
$data1.='&data'.$b.'='.$data[$b];
}
//echo $data1;
?>
<table border="0" cellpadding="0" cellspacing="0" width="400" bgcolor="#000D70">
<tr><td>
<?
$catagory=substr($catagory,0,strlen($catagory)-1);
$seriname=substr($seriname,0,strlen($seriname)-1);
//$catagory='t1;t2;t3';
//$columntitle="รายงานข้อมูลโรงงานอุตสาหกรรมจำแนกตามจำพวก";
$columntitle='กราฟแสดงอัตราการขยายตัวโรงงานอุตสาหกรรม 5 ปีล่าสุด';
//echo $catagory;
//$graph_path = "http://202.129.35.106/graphservice/graphservice.php"; //Sapphire Graph
//$catagory = 'ระดับความรุนแรงน้อย;ระดับความรุนแรงปานกลาง;ระดับความรุนแรงมาก';
/*$w1=375;
$h1=188;*/
$w1=400;
$h1=200;
$xgraphurl = $graph_path ."?category=$catagory"."$data1"."&outputstyle=&numseries=$numcountData&seriesname=$seriname&graphtype=line&title=$columntitle&xname=&yname=&subtitle=&graphstyle=srd_allvisible_nonum.scs";
$xgraphurl_link = $graph_path ."?category=$catagory"."$data1"."&outputstyle=&numseries=$numcountData&seriesname=$seriname&graphtype=line&title=$columntitle&xname=&yname=&subtitle=&graphstyle=srd_allvisible_nonum.scs";//srd_sf_004
?>
<table width="100%" border="0">
<tr>
<td> </td>
<td align="right"><a href="<?=$xgraphurl_link?>" target="_blank"><img src="images/maximize.gif" align="absmiddle" border="0" /></a></td>
</tr>
</table>
<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="<?=$w1?>" height="<?=$h1?>" >
<param name="movie" value="<?=$xgraphurl?>">
<param name="quality" value="high">
<param name="wmode" value="transparent">
<embed src="<?=$xgraphurl?>" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="<?=$w1?>" height="<?=$h1?>" wmode="transparent"></embed>
</object>
</td></tr></table>
</td>
</tr>
</table>
</body>
</html>