|
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() ;
if($_GET['status']!='executive'){
header("Content-Type: text/html; charset=windows-874");
}
set_time_limit(0) ;
include_once("../../config/config_epm.inc.php");
if($_GET['status']=='executive'){
include_once("../industry/manage_user.inc.php");
include_once("../industry/function/function.inc.php");
$graph_path = "http://202.129.35.106/graphservice/graphservice.php";
}else{
include_once("manage_user.inc.php");
include_once("function/function.inc.php");
}
#function genlink all part name.
#Create By Narong Roumsuk (Di). 2010/09/28
if($_GET['part_name']==''){
//unset($_SESSION['industry_part_name_class']);
$_SESSION['industry_part_name_class'] = array();
}
function genPart($prevPart,$namePart){
/*print"<script language='JavaScript'> alert('test') </script> ";*/
if(!$_SESSION['industry_part_name_class']){
$_SESSION['industry_part_name_class'] = array();
}
$arr=$_SESSION['industry_part_name_class'];
$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_class']=array();
$_SESSION['industry_part_name_class']=$tempArr;
}else{
$_SESSION['industry_part_name_class'][]= array(caption=>$namePart,prevpart=>$prevPart);
}
$arr=$_SESSION['industry_part_name_class'];
$numArrPart=count($arr);
$strPart='';
for($i=0;$i<$numArrPart;$i++){
$strPart.='<a href="'.iconv("UTF-8","TIS-620",$arr[$i][prevpart]).'">'.$arr[$i][caption].'</a> ==> ';
}
echo $strPart;
}#end function genlink all part name.
?>
<!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" />
<?
if($_GET['status']!='executive'){
?>
<link rel="stylesheet" href="css/template.css" type="text/css" />
<link rel="stylesheet" href="css/style.css" type="text/css" />
<title><?=$title_name?></title>
<style type="text/css">
<!--
A:link {
FONT-SIZE: 12px;color: #000000; FONT-FAMILY: Tahoma, "Microsoft Sans Serif";TEXT-DECORATION: underline;FONT-WEIGHT: bold; text-decoration:none;
}
A:visited {
FONT-SIZE: 12px; COLOR: #000000; FONT-FAMILY: Tahoma, "Microsoft Sans Serif"; TEXT-DECORATION: underline;FONT-WEIGHT: bold;text-decoration:none;
}
A:active {
FONT-SIZE: 12px; COLOR: #014d5f; FONT-FAMILY: Tahoma, "Microsoft Sans Serif"; TEXT-DECORATION: underline;FONT-WEIGHT: bold;text-decoration:none;
}
A:hover {
FONT-SIZE: 12px; COLOR: #f3960b; FONT-FAMILY: Tahoma, "Microsoft Sans Serif"; TEXT-DECORATION: underline;FONT-WEIGHT: bold;text-decoration:none;
}
.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;
text-decoration: none;
}
.bg_th1{
background-repeat:repeat-x;
background-color:#385d97;
font-weight:bold;
color:#FFFFFF;
text-align:center;
}
.style1 {
font-size: 18px;
font-weight: bold;
}
</style>
<? }?>
<style type="text/css">
.style1 {color: #FF0000}
</style>
<?php /*?><script src="common/gs_sortable.js"></script>
<link href="common/gs_sortable.css" /><?php */?>
<LINK rel="STYLESHEET" type="text/css" href="codebase/dhtmlxtabbar.css">
<SCRIPT src="codebase/dhtmlxcommon.js"></SCRIPT>
<SCRIPT src="codebase/dhtmlxtabbar.js"></SCRIPT>
<SCRIPT src="codebase/dhtmlxtabbar_start.js"></SCRIPT>
<script language=JavaScript>
function Inint_AJAX() {
try { return new ActiveXObject("Msxml2.XMLHTTP"); } catch(e) {} //IE
try { return new ActiveXObject("Microsoft.XMLHTTP"); } catch(e) {} //IE
try { return new XMLHttpRequest(); } catch(e) {} //Native Javascript
alert("XMLHttpRequest not supported");
return null;
}
function creatYear(e,num,year) {
//alert(e.id);
var req = Inint_AJAX();
var sec = document.getElementById(e.id).options[document.getElementById(e.id).options.selectedIndex].value;
var secS = document.getElementById('year_start').options[document.getElementById('year_start').options.selectedIndex].value;
var secE = document.getElementById('year_end').options[document.getElementById('year_end').options.selectedIndex].value;
if((num==2 && secS<=secE) || (num==1)){
req.onreadystatechange = function () {
if (req.readyState==4) {
if (req.status==200) {
//alert(req.responseText);
if(num==1){
document.getElementById('year_endCHK').innerHTML=req.responseText; //รับค่ากลับมา
}else if(num==2){
document.getElementById('year_startCHK').innerHTML=req.responseText; //รับค่ากลับมา
}
}
}
};
req.open("GET", "../industry/ajax_creatYear.php?varChk="+sec+"&num="+num+"&year="+year); //สร้าง connection
req.setRequestHeader("Content-Type", "application/x-www-form-urlencoded;charset=tis-620"); // set Header
req.send(null); //ส่งค่า
}
}
</script>
</head>
<body>
<?
if($_GET['show']==''){
if($_GET['status']!='executive'){
include("header.php");
}
}
/*echo '<pre>';
print_r($_SESSION['industry_part_name_class']);*/
?>
<br />
<table width="99%" border="0" align="center" cellpadding="3" cellspacing="1">
<tr>
<?
if($_GET['status']!='executive'){
?>
<td align="center"><strong style="color:#000033; font-size:16px;">รายงานอัตราการขยายตัวของอุตสาหกรรม จำแนกตามจำพวก</strong></td>
<?
}else{
?>
<td align="center"><span class="header16">รายงานอัตราการขยายตัวของอุตสาหกรรม จำแนกตามจำพวก</span></td>
<? }?>
</tr>
</table>
<br />
<?
$strGET='';
if($_GET['p']){
$strGET.='&p='.$_GET['p'];
}
if($_GET['path']){
$strGET.='&path='.$_GET['path'];
}
if($_GET['status']){
$strGET.='&status='.$_GET['status'];
}
if($_GET['year_start']){
$strGET.='&year_start='.$_GET['year_start'];
}
if($_GET['year_end']){
$strGET.='&year_end='.$_GET['year_end'];
}
?>
<form name="form1" id="form1" method="get" onsubmit="../industry/report_industry_expansion.php?row=<?=$_GET['row']?>">
<?
$sqlYear1=" SELECT industry_register.fyear
FROM industry_register
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
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')-4)+543;
}
if($_GET['year_end']){
$year_end_value=$_GET['year_end'];
}else{
$year_end_value=(date('Y')+543);
}
?>
<table width="99%" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td><strong>เลือกปี พ.ศ. </strong>
<span id="year_startCHK">
<select name="year_start" id="year_start" onchange="creatYear(this,1,<?=$resYear2['fyear']?>);">
<option value="">เลือกปี พ.ศ.</option>
<?php
for($y1=$resYear1['fyear'];$y1<=$year_end_value;$y1++){
?>
<option value="<?=$y1?>" <? if($y1==$year_start_value){ echo "selected"; } ?>>
<?=$y1?>
<?
}
?>
</select>
</span>
<strong>ถึง</strong>
<span id="year_endCHK">
<select name="year_end" id="year_end">
<option value="">เลือกปี พ.ศ.</option>
<?php
for($y1=$resYear1['fyear'];$y1<=$year_end_value;$y1++){
?>
<option value="<?=$y1?>" <? if($y1==$year_end_value){ echo "selected"; } ?>>
<?=$y1?>
<?
}
?>
</select>
</span>
<input name="row" type="hidden" id="row" size="48" value="<?=$_GET['row']?>" />
<input name="type_id" type="hidden" id="type_id" size="48" value="<?=$_GET['type_id']?>" />
<input name="p" type="hidden" id="p" size="48" value="<?=$_GET['p']?>" />
<input name="status" type="hidden" id="status" size="48" value="<?=$_GET['status']?>" />
<input name="path" type="hidden" id="path" size="48" value="<?=$_GET['path']?>" />
<input type="submit" name="Submit" value="ตกลง" />
</td>
</tr>
</table>
</form>
<?
$rowdata[1]= array(id=>"1",caption=>"จำนวนโรงงานทั้งหมด (โรง)",value=>0);
$rowdata[2]= array(id=>"2",caption=>"จำนวนโรงงาน เปิดใหม่ (โรง)",value=>0);
$rowdata[3]= array(id=>"3",caption=>"จำนวนเงินลงทุน (ล้านบาท)",value=>0);
$rowdata[4]= array(id=>"4",caption=>"จำนวนคนงาน (คน)",value=>0);
if($_GET['row']==''){
$data[1]='';
$data[2]='';
$data[3]='';
$data[4]='';
$catagory='';
$seriname='';
$numRowData=count($rowdata);
//while ( $Result_3 = mysql_fetch_assoc($rsConn_3)) {
for($y1=$year_start_value;$y1<=$year_end_value;$y1++){
$tempIndustry1_all=0;
$tempIndustry2_all=0;
$tempIndustry1=0;
$tempIndustry2=0;
$tempCapital1=0;
$tempCapital2=0;
$tempMen1=0;
$tempMen2=0;
$strSQL_class = "SELECT *
FROM industry_class
";
$rsConn_class = mysql_db_query($dbname,$strSQL_class);
while ( $Result_class = mysql_fetch_assoc($rsConn_class)) {
$sqlClass1="SELECT COUNT(code) AS ALL_INDUSTRY,
SUM(capital) AS ALL_CAPITAL,
SUM(men) AS ALL_MEN
FROM industry_register
WHERE fyear='".$y1."' and import_status!='4' and fact_class='".$Result_class['class_id']."'
";
$rsClass1=mysql_db_query($dbname,$sqlClass1);
$resClass1=mysql_fetch_assoc($rsClass1);
$sqlClass2="SELECT COUNT(code) AS ALL_INDUSTRY,
SUM(capital) AS ALL_CAPITAL,
SUM(men) AS ALL_MEN
FROM industry_register
WHERE fyear='".($y1-1)."' and import_status!='4' and fact_class='".$Result_class['class_id']."'
";
$rsClass2=mysql_db_query($dbname,$sqlClass2);
$resClass2=mysql_fetch_assoc($rsClass2);
$sqlClass1_all="SELECT COUNT(code) AS ALL_INDUSTRY
FROM industry_register
WHERE fyear<='".$y1."' and import_status!='4' and fact_class='".$Result_class['class_id']."'
";
$rsClass1_all=mysql_db_query($dbname,$sqlClass1_all);
$resClass1_all=mysql_fetch_assoc($rsClass1_all);
$sqlClass2_all="SELECT COUNT(code) AS ALL_INDUSTRY
FROM industry_register
WHERE fyear<='".($y1-1)."' and import_status!='4' and fact_class='".$Result_class['class_id']."'
";
$rsClass2_all=mysql_db_query($dbname,$sqlClass2_all);
$resClass2_all=mysql_fetch_assoc($rsClass2_all);
$tempIndustry1_all+=$resClass1_all['ALL_INDUSTRY'];
$tempIndustry2_all+=$resClass2_all['ALL_INDUSTRY'];
$tempIndustry1+=$resClass1['ALL_INDUSTRY'];
$tempIndustry2+=$resClass2['ALL_INDUSTRY'];
$tempCapital1+=$resClass1['ALL_CAPITAL'];
$tempCapital2+=$resClass2['ALL_CAPITAL'];
$tempMen1+=$resClass1['ALL_MEN'];
$tempMen2+=$resClass2['ALL_MEN'];
}
if($tempIndustry2_all==0){
$arrDelta[$y1][1]='0.00';
}else{
$arrDelta[$y1][1]=(($tempIndustry1_all-$tempIndustry2_all)/$tempIndustry2_all)*100;
}
if($tempIndustry2==0){
$arrDelta[$y1][2]='0.00';
}else{
$arrDelta[$y1][2]=(($tempIndustry1-$tempIndustry2)/$tempIndustry2)*100;
}
if($tempCapital2==0){
$arrDelta[$y1][3]='0.00';
}else{
$arrDelta[$y1][3]=(($tempCapital1-$tempCapital2)/$tempCapital2)*100;
}
if($tempMen2==0){
$arrDelta[$y1][4]='0.00';
}else{
$arrDelta[$y1][4]=(($tempMen1-$tempMen2)/$tempMen2)*100;
}
$data[1].=$arrDelta[$y1][1].';';
$data[2].=$arrDelta[$y1][2].';';
$data[3].=$arrDelta[$y1][3].';';
$data[4].=$arrDelta[$y1][4].';';
$arrData[$y1][1]=$tempIndustry1_all;
$arrData[$y1][2]=$tempIndustry1;
$arrData[$y1][3]=$tempCapital1;
$arrData[$y1][4]=$tempMen1;
$catagory.=$y1.';';
}
/*echo '<pre>';
print_r($data);*/
for($a=1;$a<=$numRowData;$a++){
$seriname.=$rowdata[$a][caption].';';
}
$data[1]=substr($data[1],0,strlen($data[1])-1);
$data[2]=substr($data[2],0,strlen($data[2])-1);
$data[3]=substr($data[3],0,strlen($data[3])-1);
$data[4]=substr($data[4],0,strlen($data[4])-1);
$catagory=substr($catagory,0,strlen($catagory)-1);
$seriname=substr($seriname,0,strlen($seriname)-1);
?>
<table width="400" border="0" cellpadding="0" cellspacing="0" align="center">
<tr><td align="center" width="400">
<DIV MODE="top" TABHEIGHT="20" align="left" OFFSET="20" MARGIN="-10" skinColors="#FFFFFF" id="a_tabbar" TABSTYLE="modern" class="dhtmlxTabBar" IMGPATH="codebase/imgs/" style="width:410px; height:254px;" >
<DIV id="a1" WIDTH="55" NAME="ทุกรายการ" style="display:none;">
<table width="400" border="0" cellpadding="0" cellspacing="0" bgcolor="#000D70" align="center">
<tr><td>
<?
$columntitle='กราฟแสดงอัตราการขยายตัวอุตสาหกรรม';
$w1=400;
$h1=200;
$xgraphurl = $graph_path ."?category=$catagory"."&data1="."$data[1]"."&data2="."$data[2]"."&data3="."$data[3]"."&data4="."$data[4]"."&outputstyle=&numseries=4&seriesname=$seriname&graphtype=line&title=$columntitle&xname=&yname=&subtitle=&graphstyle=srd_allvisible_nonum.scs";
$xgraphurl_link = $graph_path ."?category=$catagory"."&data1="."$data[1]"."&data2="."$data[2]"."&data3="."$data[3]"."&data4="."$data[4]"."&outputstyle=&numseries=4&seriesname=$seriname&graphtype=line&title=$columntitle&xname=&yname=&subtitle=&graphstyle=srd_allvisible_nonum.scs";//srd_sf_004
?>
<table width="400" border="0">
<tr>
<td> </td>
<td align="right"><a href="<?=$xgraphurl_link?>" target="_blank"><img src="../industry/images/maximize.gif" width="16" 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>
</DIV>
<DIV id="a2" WIDTH="110" NAME="จำนวนโรงงานทั้งหมด" style="display:none;">
<table border="0" cellpadding="0" cellspacing="0" width="400" bgcolor="#000D70" align="center">
<tr><td>
<?
$columntitle='กราฟแสดงอัตราการขยายตัวอุตสาหกรรมจำแนกตามจำนวนโรงงานทั้งหมด';
$w1=400;
$h1=200;
$seriname1=$rowdata[1][caption];
$xgraphurl = $graph_path ."?category=$catagory"."&data1="."$data[1]"."&outputstyle=&numseries=1&seriesname=$seriname1&graphtype=line&title=$columntitle&xname=&yname=&subtitle=&graphstyle=srd_allvisible_nonum.scs";
$xgraphurl_link = $graph_path ."?category=$catagory"."&data1="."$data[1]"."&outputstyle=&numseries=1&seriesname=$seriname1&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="../industry/images/maximize.gif" width="16" 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>
</DIV>
<DIV id="a3" WIDTH="115" NAME="จำนวนโรงงานเปิดใหม่" style="display:none;">
<table border="0" cellpadding="0" cellspacing="0" width="400" bgcolor="#000D70" align="center">
<tr><td>
<?
$columntitle='กราฟแสดงอัตราการขยายตัวอุตสาหกรรมจำแนกตามจำนวนโรงงานเปิดใหม่';
$w1=400;
$h1=200;
$seriname1=$rowdata[2][caption];
$xgraphurl = $graph_path ."?category=$catagory"."&data1="."$data[2]"."&outputstyle=&numseries=1&seriesname=$seriname1&graphtype=line&title=$columntitle&xname=&yname=&subtitle=&graphstyle=srd_allvisible_nonum_t_2.scs";
$xgraphurl_link = $graph_path ."?category=$catagory"."&data1="."$data[2]"."&outputstyle=&numseries=1&seriesname=$seriname1&graphtype=line&title=$columntitle&xname=&yname=&subtitle=&graphstyle=srd_allvisible_nonum_t_2.scs";//srd_sf_004
?>
<table width="100%" border="0">
<tr>
<td> </td>
<td align="right"><a href="<?=$xgraphurl_link?>" target="_blank"><img src="../industry/images/maximize.gif" width="16" 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>
</DIV>
<DIV id="a4" WIDTH="70" NAME="จำนวนเงินทุน" style="display:none;">
<table border="0" cellpadding="0" cellspacing="0" width="400" bgcolor="#000D70" align="center">
<tr><td>
<?
$columntitle='กราฟแสดงอัตราการขยายตัวอุตสาหกรรมจำแนกตามจำนวนเงินทุน';
$w1=400;
$h1=200;
$seriname1=$rowdata[3][caption];
$xgraphurl = $graph_path ."?category=$catagory"."&data1="."$data[3]"."&outputstyle=&numseries=1&seriesname=$seriname1&graphtype=line&title=$columntitle&xname=&yname=&subtitle=&graphstyle=srd_allvisible_nonum_t_3.scs";
$xgraphurl_link = $graph_path ."?category=$catagory"."&data1="."$data[3]"."&outputstyle=&numseries=1&seriesname=$seriname1&graphtype=line&title=$columntitle&xname=&yname=&subtitle=&graphstyle=srd_allvisible_nonum_t_3.scs";//srd_sf_004
?>
<table width="100%" border="0">
<tr>
<td> </td>
<td align="right"><a href="<?=$xgraphurl_link?>" target="_blank"><img src="../industry/images/maximize.gif" width="16" 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>
</DIV>
<DIV id="a5" WIDTH="75" NAME="จำนวนคนงาน" style="display:none;">
<table border="0" cellpadding="0" cellspacing="0" width="400" bgcolor="#000D70" align="center">
<tr><td>
<?
$columntitle='กราฟแสดงอัตราการขยายตัวอุตสาหกรรมจำแนกตามจำนวนคนงาน';
$w1=400;
$h1=200;
$seriname1=$rowdata[4][caption];
$xgraphurl = $graph_path ."?category=$catagory"."&data1="."$data[4]"."&outputstyle=&numseries=1&seriesname=$seriname1&graphtype=line&title=$columntitle&xname=&yname=&subtitle=&graphstyle=srd_allvisible_nonum_t_4.scs";
$xgraphurl_link = $graph_path ."?category=$catagory"."&data1="."$data[4]"."&outputstyle=&numseries=1&seriesname=$seriname1&graphtype=line&title=$columntitle&xname=&yname=&subtitle=&graphstyle=srd_allvisible_nonum_t_4.scs";//srd_sf_004
?>
<table width="100%" border="0">
<tr>
<td> </td>
<td align="right"><a href="<?=$xgraphurl_link?>" target="_blank"><img src="../industry/images/maximize.gif" width="16" 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>
</DIV>
</DIV>
</td></tr>
</table>
<br />
<table width="99%" border="0" bgcolor="#CCCCCC" cellpadding="3" cellspacing="1" align="center">
<tr class="bg_th">
<td align="center" width="200"></td>
<?
for($y1=$year_start_value;$y1<=$year_end_value;$y1++){
?>
<td align="center" colspan="2"><strong>ปี พ.ศ. <?=$y1?></strong></td>
<? }?>
</tr>
<?
for($a=1;$a<=$numRowData;$a++){
?>
<tr bgcolor="#FFFFFF">
<td align="left"><a href="?row=<?=$rowdata[$a][id]?><?=$strGET?>&part_name=<?=$rowdata[$a][caption]?>"><strong><?=$rowdata[$a][caption]?></strong></a></td>
<?
for($y1=$year_start_value;$y1<=$year_end_value;$y1++){
$numberTempShow='';
if($a==3){
$numberTempShow=number_format(replaceToNumber(chkMilion($arrData[$y1][$a])),2);
}else{
$numberTempShow=number_format($arrData[$y1][$a]);
}
?>
<td align="right"><? if($arrData[$y1][$a]!=0){ ?><a href="../industry/show_industry.php?year=<?=$y1?>&row=<?=$a?>" target="_blank"><? }?><?=$numberTempShow?></a></td>
<td align="center">(<?=numberSymbolPercen($arrDelta[$y1][$a])?>)%</td>
<? }?>
</tr>
<? }?>
</table>
<?
}else{
?>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="95%"></td>
<td width="5%"></td>
</tr>
<tr>
<td>
<?
genPart($_SERVER['HTTP_REFERER'],$_GET['part_name']);
?></td>
<td align="right"><?php /*?><A href="../industry/report_industry_expansion_pdf.php?row=<?=$_GET['row']?>&year_start=<?=$_GET['year_start']?>&year_end=<?=$_GET['year_end']?>&type_id=<?=$_GET['type_id']?>" target="_blank"><IMG src="img/pdf.gif" alt="ผลการค้นหา PDF" width="18" height="18" border="0" title="PDF" align="absmiddle"></A><?php */?></td>
</tr>
</table>
<?
$strSQL_3 = "SELECT *
FROM industry_class
";
$rsConn_3 = mysql_db_query($dbname,$strSQL_3);
$i=0;
while ( $Result_3 = mysql_fetch_assoc($rsConn_3)) {
$i++;
$arrDataTypeId[]=$Result_3['runid'];
$arrDataType[]=$Result_3['class_id'];
$arrDataName[]=$Result_3['class_name'];
for($y1=$year_start_value;$y1<=$year_end_value;$y1++){
if($_GET['row']=='1'){
$sqlClass1="SELECT COUNT(code) AS ALL_INDUSTRY,
SUM(capital) AS ALL_CAPITAL,
SUM(men) AS ALL_MEN,
SUM(women) AS ALL_WOMEN,
SUM(man) AS ALL_MAN
FROM industry_register
WHERE fyear<='".$y1."' and import_status!='4'
";
$sqlClass1.=" and fact_class ='".$Result_3['class_id']."' ";
//echo $sqlClass1;
$rsClass1=mysql_db_query($dbname,$sqlClass1);
$resClass1=mysql_fetch_assoc($rsClass1);
$sqlClass2="SELECT COUNT(code) AS ALL_INDUSTRY,
SUM(capital) AS ALL_CAPITAL,
SUM(men) AS ALL_MEN,
SUM(women) AS ALL_WOMEN,
SUM(man) AS ALL_MAN
FROM industry_register
WHERE fyear<='".($y1-1)."' and import_status!='4'
";
$sqlClass2.=" and fact_class ='".$Result_3['class_id']."' ";
//echo $sqlClass1;
$rsClass2=mysql_db_query($dbname,$sqlClass2);
$resClass2=mysql_fetch_assoc($rsClass2);
}else{
$sqlClass1="SELECT COUNT(code) AS ALL_INDUSTRY,
SUM(capital) AS ALL_CAPITAL,
SUM(men) AS ALL_MEN,
SUM(women) AS ALL_WOMEN,
SUM(man) AS ALL_MAN
FROM industry_register
WHERE fyear='".$y1."' and import_status!='4'
";
$sqlClass1.=" and fact_class ='".$Result_3['class_id']."' ";
//echo $sqlClass1;
$rsClass1=mysql_db_query($dbname,$sqlClass1);
$resClass1=mysql_fetch_assoc($rsClass1);
$sqlClass2="SELECT COUNT(code) AS ALL_INDUSTRY,
SUM(capital) AS ALL_CAPITAL,
SUM(men) AS ALL_MEN,
SUM(women) AS ALL_WOMEN,
SUM(man) AS ALL_MAN
FROM industry_register
WHERE fyear='".($y1-1)."' and import_status!='4'
";
$sqlClass2.=" and fact_class ='".$Result_3['class_id']."' ";
//echo $sqlClass1;
$rsClass2=mysql_db_query($dbname,$sqlClass2);
$resClass2=mysql_fetch_assoc($rsClass2);
}
if($_GET['row']=='1'){
$arrData[$Result_3['runid']][$y1]=$resClass1['ALL_INDUSTRY'];
if($resClass2['ALL_INDUSTRY']==0){
$arrDeltaData[$Result_3['runid']][$y1]='0.00';
}else{
$arrDeltaData[$Result_3['runid']][$y1]=(($resClass1['ALL_INDUSTRY']-$resClass2['ALL_INDUSTRY'])/$resClass2['ALL_INDUSTRY'])*100;
}
$totalNumDataTemp1[$y1]+=$resClass1['ALL_INDUSTRY'];
$totalNumDataTemp2[$y1]+=$resClass2['ALL_INDUSTRY'];
}else if($_GET['row']=='2'){
$arrData[$Result_3['runid']][$y1]=$resClass1['ALL_INDUSTRY'];
if($resClass2['ALL_INDUSTRY']==0){
$arrDeltaData[$Result_3['runid']][$y1]='0.00';
}else{
$arrDeltaData[$Result_3['runid']][$y1]=(($resClass1['ALL_INDUSTRY']-$resClass2['ALL_INDUSTRY'])/$resClass2['ALL_INDUSTRY'])*100;
}
$totalNumDataTemp1[$y1]+=$resClass1['ALL_INDUSTRY'];
$totalNumDataTemp2[$y1]+=$resClass2['ALL_INDUSTRY'];
}else if($_GET['row']=='3'){
$arrData[$Result_3['runid']][$y1]=$resClass1['ALL_CAPITAL'];
if($resClass2['ALL_CAPITAL']==0){
$arrDeltaData[$Result_3['runid']][$y1]='0.00';
}else{
$arrDeltaData[$Result_3['runid']][$y1]=(($resClass1['ALL_CAPITAL']-$resClass2['ALL_CAPITAL'])/$resClass2['ALL_CAPITAL'])*100;
}
$totalNumDataTemp1[$y1]+=$resClass1['ALL_CAPITAL'];
$totalNumDataTemp2[$y1]+=$resClass2['ALL_CAPITAL'];
}else if($_GET['row']=='4'){
$arrDataAM[$Result_3['runid']][$y1]=$resClass1['ALL_MEN'];
$arrDataW[$Result_3['runid']][$y1]=$resClass1['ALL_WOMEN'];
$arrDataM[$Result_3['runid']][$y1]=$resClass1['ALL_MAN'];
if($resClass2['ALL_MEN']==0){
$arrDeltaData[$Result_3['runid']][$y1]='0.00';
}else{
$arrDeltaData[$Result_3['runid']][$y1]=(($resClass1['ALL_MEN']-$resClass2['ALL_MEN'])/$resClass2['ALL_MEN'])*100;
}
$totalNumDataTemp1[$y1]+=$resClass1['ALL_MEN'];
$totalNumDataTemp2[$y1]+=$resClass2['ALL_MEN'];
$totalNumDataTempW[$y1]+=$resClass1['ALL_WOMEN'];
$totalNumDataTempM[$y1]+=$resClass1['ALL_MAN'];
}
if($totalNumDataTemp2[$y1]==0){
$totalDeltaTemp[$y1]=0;
}else{
$totalDeltaTemp[$y1]=(($totalNumDataTemp1[$y1]-$totalNumDataTemp2[$y1])/$totalNumDataTemp2[$y1])*100;
}
}
}
/*echo '<pre>';
print_r($arrDeltaData);*/
?>
<table width="99%" border="0" bgcolor="#CCCCCC" cellpadding="3" cellspacing="1" align="center">
<tr class="bg_th">
<td width="50" rowspan="2" align="center">ลำดับที่</td>
<td rowspan="2" align="center" width="220">
<?
echo 'ชื่อจำพวก';
/*if($_GET['type_id']==''){
echo 'หมวดอุตสาหกรรม';
}else{
echo 'ประเภทอุตสาหกรรม';
}*/
if($_GET['row']){
$numR=$_GET['row'];
$numStart=$_GET['row'];
}else{
$numR=count($rowdata);
$numStart=1;
}
?></td>
<td align="center" colspan="<?=(($year_end_value-$year_start_value)+1)*2?>"><strong>
<?
for($numValue=$numStart;$numValue<=$numR;$numValue++){
echo $rowdata[$numValue][caption];
}
?></strong>
</td>
</tr>
<tr class="bg_th<?=($_GET['status']=='executive')?'':'1'?>">
<?
for($y1=$year_start_value;$y1<=$year_end_value;$y1++){
?>
<td align="center" colspan="2"><strong>ปี พ.ศ. <?=$y1?></strong></td>
<? }?>
</tr>
<?
$numberType=count($arrDataTypeId);
for($i=0;$i<$numberType;$i++){
?>
<tr bgcolor="#FFFFFF" onmouseover="this.style.backgroundColor='#dbf2ae'" onmouseout="this.style.backgroundColor='#FFFFFF'">
<td align="center"><?=($i+1)?></td>
<td align="left"><strong><?=$arrDataName[$i]?></strong></td>
<?
for($y1=$year_start_value;$y1<=$year_end_value;$y1++){
$numDataTemp='';
if($_GET['row']=='1'){
$numDataTemp=number_format($arrData[$arrDataTypeId[$i]][$y1]);
$chkNumDataTemp=$arrData[$arrDataTypeId[$i]][$y1];
//$totalNumDataTemp[$y1]+=$arrData[$arrDataTypeId[$i]][$y1];
}else if($_GET['row']=='2'){
$numDataTemp=number_format($arrData[$arrDataTypeId[$i]][$y1]);
$chkNumDataTemp=$arrData[$arrDataTypeId[$i]][$y1];
//$totalNumDataTemp[$y1]+=$arrData[$arrDataTypeId[$i]][$y1];
}else if($_GET['row']=='3'){
$numDataTemp=number_format(replaceToNumber(chkMilion($arrData[$arrDataTypeId[$i]][$y1])),2);
$chkNumDataTemp=$arrData[$arrDataTypeId[$i]][$y1];
//$totalNumDataTemp[$y1]+=$arrData[$arrDataTypeId[$i]][$y1];
}else if($_GET['row']=='4'){
$numDataTemp=number_format($arrDataAM[$arrDataTypeId[$i]][$y1]).'<br>[ชาย '.number_format($arrDataM[$arrDataTypeId[$i]][$y1]).', หญิง '.number_format($arrDataW[$arrDataTypeId[$i]][$y1]).']';
$chkNumDataTemp=$arrDataAM[$arrDataTypeId[$i]][$y1];
//$totalNumDataTemp[$y1]+=$arrDataAM[$arrDataTypeId[$i]][$y1];
}
?>
<td align="right" width="110"><? if($chkNumDataTemp!=0){ ?><a href="../industry/show_industry.php?year=<?=$y1?>&row=<?=$_GET['row']?>&fact_class=<?=($arrDataType[$i]+1)?>&temp=1" target="_blank"><? }?><?=$numDataTemp?></a></td>
<td align="right" width="80">(<?=numberSymbolPercen($arrDeltaData[$arrDataTypeId[$i]][$y1])?>)%</td>
<? }?>
</tr>
<? }?>
<tr bgcolor="#DDDDDD">
<td align="right" colspan="2"><strong>รวม</strong></td>
<?
for($y1=$year_start_value;$y1<=$year_end_value;$y1++){
$numDataTemp='';
if($_GET['row']=='1'){
$numDataTemp=number_format($totalNumDataTemp1[$y1]);
$chkNumDataTemp=$totalNumDataTemp1[$y1];
//$totalNumDataTemp[$y1]+=$arrData[$arrDataTypeId[$i]][$y1];
}else if($_GET['row']=='2'){
$numDataTemp=number_format($totalNumDataTemp1[$y1]);
$chkNumDataTemp=$totalNumDataTemp1[$y1];
//$totalNumDataTemp[$y1]+=$arrData[$arrDataTypeId[$i]][$y1];
}else if($_GET['row']=='3'){
$numDataTemp=number_format(replaceToNumber(chkMilion($totalNumDataTemp1[$y1])),2);
$chkNumDataTemp=$totalNumDataTemp1[$y1];
//$totalNumDataTemp[$y1]+=$arrData[$arrDataTypeId[$i]][$y1];
}else if($_GET['row']=='4'){
$numDataTemp=number_format($totalNumDataTemp1[$y1]).'<br>[ชาย '.number_format($totalNumDataTempM[$y1]).', หญิง '.number_format($totalNumDataTempW[$y1]).']';
$chkNumDataTemp=$totalNumDataTemp1[$y1];
//$totalNumDataTemp[$y1]+=$arrDataAM[$arrDataTypeId[$i]][$y1];
}
?>
<td align="right"><? if($chkNumDataTemp!=0){ ?><a href="../industry/show_industry.php?year=<?=$y1?>&row=<?=$_GET['row']?>&fact_class=1" target="_blank"><? }?><?=$numDataTemp?></a></td>
<td align="right">(<?=numberSymbolPercen($totalDeltaTemp[$y1])?>)%</td>
<? }?>
</tr>
</table>
<table width="99%" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td width="20%" align="left"> <strong><span class="style1">***</span> หมายเหตุ:</strong></td>
<td align="right"></td>
</tr>
</table>
<table width="99%" border="0" align="center">
<tr>
<td width="50"></td>
<td valign="top">
<table width="100%" cellpadding="0" cellspacing="1" border="0">
<?
$sqlNoteClass=" SELECT * FROM industry_class ";
$rsNoteClass=mysql_db_query($dbname,$sqlNoteClass);
while($resNoteClass=mysql_fetch_assoc($rsNoteClass)){
?>
<tr>
<td align="left"><strong>"โรงงานอุตสาหกรรมจำพวกที่ <?=$resNoteClass['class_id']?>"</strong> หมายถึง <?=$resNoteClass['note']?></td>
</tr>
<? }?>
</table>
</tr>
</table>
<?
}
?>
<br />
</body>
</html>