|
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 : /var/www/html/pathumthani_integration/requirement/application/people/ |
Upload File : |
<?
//session_start();
if($_GET['status']=='executive'){
include_once("../../../requirement/config/config.inc.php");
// include_once("../../../requirement/application/people/function/function.php");
// include_once("../../../requirement/application/people/graph.inc.php");
//include("../../../requirement/common/common_system.inc.php");
//$ApplicationName="ecomplain";
//$time_start = getmicrotime();
$part_folder = "http://123.242.173.131/pathumthani_integration/requirement/application/people/";
echo "<script>window.location='".$part_folder."report_problemandrequest.php';</script>";
exit();
}else{
include "../../config/config.inc.php";
//include("header_menu.php");
//insert timeQuery
}
?>
<?
$strSQLYear2 = "SELECT yy
FROM tbl_complain
WHERE yy <> '' AND yy <> '0000' AND yy > '1900'
GROUP BY yy
ORDER BY yy DESC
";
$rsConnYear2 = mysql_db_query($dbname,$strSQLYear2);
//$ResultYear2 = mysql_fetch_assoc($rsConnYear2);
$strSQLYear1 = "SELECT yy
FROM tbl_complain
WHERE yy <> '' AND yy <> '0000' AND yy > '1900'
GROUP BY yy
ORDER BY yy ASC
";
$rsConnYear1 = mysql_db_query($dbname,$strSQLYear1);
$ResultYear2 = mysql_fetch_assoc($rsConnYear2);
$ResultYear1 = mysql_fetch_assoc($rsConnYear1);
if($_POST['Submit']){
$year1=$_POST['year1'];
$year2=$_POST['year2'];
}else{
$year1=$ResultYear1['yy'];
$year2=$ResultYear2['yy'];
}
//echo $year1.'<p/>';
//echo $year2;
/*$strSQLYear2 = "SELECT yy
FROM tbl_complain
WHERE yy <> '' AND yy <> '0000' AND yy > '1900'
GROUP BY yy
ORDER BY yy ASC
";
$rsConnYear2 = mysql_db_query($dbname,$strSQLYear2);
$ResultYear2 = mysql_fetch_assoc($rsConnYear2);*/
//function กำหนดสีค่าเป็นบวกสีแดง ติดลบสีเขียว
function numberSymbolPercen_in($num){
if($num>=0){
$temp='<font color="#FF0000">+'.number_format($num,2).'</font>';
}else{
$temp='<font color="#02b702">'.number_format($num,2).'</font>';
}
return $temp;
}
?>
<html>
<head>
<title><?=$show_title?></title>
<META http-equiv=Content-Type content="text/html; charset=windows-874">
<link href="../../common/style.css" type="text/css" rel="stylesheet" />
<script language='javascript' src='daily_popcalendar.js'></script>
<script language='javascript' src='displayelement.js'></script>
<style type="text/css">
<!--
body { margin: 0px 0px; padding: 0px 0px}
a:link { color: #005CA2; text-decoration: none}
a:visited { color: #005CA2; text-decoration: none}
a:active { color: #0099FF; text-decoration: underline}
a:hover { color: #0099FF; text-decoration: underline}
-->
</style>
<script language="javascript">
function check_duooyear(year1,year2){
//alert(year1.value +" "+year2.value);
for (var i=0, select; select = year2[i]; i++) {
option2 = year2.options[i];
if( option2.value < year1.value ){
option2.disabled = true;
option2.style.color = "graytext";
}else{
option2.disabled = false;
option2.style.color = "menutext";
if( option2.value == year1.value && year2.value < year1.value){
option2.selected = true ;
}
}
}
}
</script>
</head>
<body >
<br/>
<center><strong style="font-size:16px;">ข้อมูลรายการเปรียบเทียบปัญหาและความต้องการจำแนกตามพื้นที่</strong></center>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="50%" align="center" valign="top" ><? include ("exsumary.php") ?></td>
<td width="50%" align="center" valign="top" >
<?php
if($_GET['level']==''){
$level="";
}else{
$level="and request_level='".$_GET['level']."' ";
}
$strSQL_22 = "SELECT *
FROM ccaa_pathumthani
WHERE ccaa_pathumthani.ccType = 'Aumpur'
";
$rsConn_22 = mysql_db_query($dbname,$strSQL_22);
$i=0;
while ( $Result_22 = mysql_fetch_assoc($rsConn_22)) {
$i++;
/*if($_GET['amphur']==''){
$amphur="and public_amphur='".$Result_2['ccDigi']."' ";
}else{
$amphur="ตำบล";
}*/
$strSQL_11 = "SELECT
distinct (select Count(tbl_complain.complain_id) from tbl_complain where yy='".$year1."' ".$level." and public_amphur='".$Result_22['ccDigi']."') as YEAR1,
(select Count(tbl_complain.complain_id) from tbl_complain where yy='".$year2."' ".$level." and public_amphur='".$Result_22['ccDigi']."') as YEAR2
FROM tbl_complain
";
//echo $strSQL_1.'<p/>';
$rsConn_11 = mysql_db_query($dbname,$strSQL_11);
$rs11 = mysql_fetch_assoc($rsConn_11);
$totalYear1+=$rs11['YEAR1'];
$totalYear2+=$rs11['YEAR2'];
$data1.=($rs11['YEAR1']).';';
$data2.=($rs11['YEAR2']).';';
$catagory.=$Result_22['ccName'].';';
} //echo $data1;
$data1=substr($data1,0,strlen($data1)-1);
$data2=substr($data2,0,strlen($data2)-1);
$catagory=substr($catagory,0,strlen($catagory)-1);
$seriesname=($year1+543).';'.($year2+543);
//$catagory="บุกรุก/บุกเบิก;เช่าที่ดิน;ที่ดินของตนเอง;เช่าซื้อสหกรณ์;อื่นๆ";
$graph_path = "http://202.129.35.106/graphservice/graphservice.php"; //Sapphire Graph
$w1=400;
$h1=200;
$columntitle="กราฟแสดงการเปรียบปัญหาและความต้องการจำแนกตามประเภทปัญหา ";
$xgraphurl = $graph_path ."?category=$catagory"."&data1="."$data1"."&data2="."$data2"."&outputstyle=&numseries=2&seriesname=$seriesname&graphtype=bar&title=$columntitle&xname=&yname=&subtitle=&graphstyle=srd_allvisible_lg.scs";
//echo $xgraphurl;
$xgraphurl_link = $graph_path ."?category=$catagory"."&data1="."$data1"."&data2="."$data2"."&outputstyle=&numseries=2&seriesname=$seriesname&graphtype=bar&title=$columntitle&xname=&yname=&subtitle=&graphstyle=srd_allvisible_lg.scs";//srd_sf_004
?>
<table width="400" align="center" border="0" bgcolor="#000D70">
<tr>
<td align="right"><a href="<?=$xgraphurl_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="<?=$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>
<br>
<form id="form1" name="form1" method="post" action="">
<table width="99%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="30%"> <div align="left">
<?
if($_GET['amphur'] != '')
{
$sql_aumphur = "select ccDigi,ccName from ccaa_pathumthani cp where cp.ccDigi = '".$_GET['amphur']."'";
$res_aumphur = mysql_query($sql_aumphur);
$rs_aumphur = mysql_fetch_assoc($res_aumphur);
//echo $sql_aumphur."<br>";
echo "<a href=\"?p=report_problemandrequest.php&sel_year=".$sel_year."\"><< อำเภอ ".$rs_aumphur['ccName']." </a>";
}
?>
</div></td>
<td width="70%" align="right">ปี
<select name="year1" id="year1" onchange="check_duooyear(this,document.getElementById('year2'))">
<option value="" disabled> ปี พ.ศ.</option>
<?
$strSQLYear = "SELECT yy
FROM tbl_complain
WHERE yy <> '' AND yy <> '0000' AND yy > '1900'
GROUP BY yy
";
$rsConnYear = mysql_query($strSQLYear);
while ( $ResultYear = mysql_fetch_object($rsConnYear) ) {
$slted =($_POST['year1']==$ResultYear->yy || ($ResultYear1['yy']==$ResultYear->yy && $_POST['year1']==''))?"SELECTED":"";
echo "<option value=\"".$ResultYear->yy."\" $slted>".(($ResultYear->yy)+543)."</option>\n";
}
?>
</select>
ปี
<select name="year2" id="year2" onchange="check_duooyear(document.getElementById('year1'),this)">
<option value="" disabled> ปี พ.ศ.</option>
<?
//onChange="window.location='bargraph_level_year.php?year_end='+this.options[this.selectedIndex].value"
$strSQLYear = "SELECT yy
FROM tbl_complain
WHERE yy <> '' AND yy <> '0000' AND yy > '1900'
GROUP BY yy
";
$rsConnYear = mysql_query($strSQLYear);
while ( $ResultYear = mysql_fetch_object($rsConnYear) ) {
$slted =($_POST['year2']==$ResultYear->yy || ($ResultYear2['yy']==$ResultYear->yy && $_POST['year2']==''))?"SELECTED":"";
echo "<option value=\"".$ResultYear->yy."\" $slted>".(($ResultYear->yy)+543)."</option>\n";
}
?>
</select>
<input type="submit" name="Submit" value=" เลือก " />
<script language="javascript">
check_duooyear(document.getElementById('year1'),document.getElementById('year2'))
</script>
</td>
</tr>
</table>
</form>
<?
//echo substr ( "bamboolabcode",0, 4 );
if($_GET['amphur']==''){
?>
<table width="99%" border="1" align="center" cellpadding="4" cellspacing="0" style="border-collapse:collapse;">
<tr >
<td colspan="5" align="center" class="bg_th"><strong>รายงานเปรียบปัญหาและความต้องการจำแนกตามพื้นที่</strong></td>
</tr>
<tr >
<td width="8%" align="center" class="bg_th"><strong>ลำดับที่</strong></td>
<td align="center" class="bg_th"><strong>อำเภอ</strong></td>
<td width="20%" align="center" class="bg_th"><strong>พ.ศ.
<?=$year1+543?></strong></td>
<td width="20%" align="center" class="bg_th"><strong>พ.ศ.
<?=$year2+543?></strong></td>
<td width="15%" align="center" class="bg_th"><strong>ร้อยละ</strong></td>
</tr>
<?
if($_GET['level']==''){
$level="";
}else{
$level="and request_level='".$_GET['level']."' ";
}
$strSQL_2 = "SELECT *
FROM ccaa_pathumthani
WHERE ccaa_pathumthani.ccType = 'Aumpur'
";
$rsConn_2 = mysql_db_query($dbname,$strSQL_2);
$i=0;
$totalYear1 = "";
$totalYear2 = "";
while ( $Result_2 = mysql_fetch_assoc($rsConn_2)) {
$i++;
/*if($_GET['amphur']==''){
$amphur="and public_amphur='".$Result_2['ccDigi']."' ";
}else{
$amphur="ตำบล";
}*/
$strSQL_1 = "SELECT
distinct (select Count(tbl_complain.complain_id) from tbl_complain where yy='".$year1."' ".$level." and public_amphur='".$Result_2['ccDigi']."') as YEAR1,
(select Count(tbl_complain.complain_id) from tbl_complain where yy='".$year2."' ".$level." and public_amphur='".$Result_2['ccDigi']."') as YEAR2
FROM tbl_complain
";
//echo $strSQL_1.'<p/>';
$rsConn_1 = mysql_db_query($dbname,$strSQL_1);
$rs1 = mysql_fetch_assoc($rsConn_1);
?>
<tr bgcolor="#FFFFFF">
<td align="center"><?=$i?></td>
<td><a href="?p=report_problemandrequest.php&hur=<?=$Result_2['ccDigi']?>"><?=$Result_2['ccName']?></a></td>
<td align="center">
<?
if($rs1['YEAR1'] != 0){
?>
<a href="complain_detail.php?sel_aumpur=<?=$Result_2['ccDigi']?>&sel_year=<?=$year1?>" target="_blank">
<? }?>
<?=number_format($rs1['YEAR1'])?></a></td>
<td align="center">
<?
if($rs1['YEAR2'] != 0){
?>
<a href="complain_detail.php?sel_aumpur=<?=$Result_2['ccDigi']?>&sel_year=<?=$year2?>" target="_blank">
<? }?>
<?=number_format($rs1['YEAR2'])?></a></td>
<?
$totalYear1+=$rs1['YEAR1'];
$totalYear2+=$rs1['YEAR2'];
// if(($rs1['YEAR1']+$rs1['YEAR2']) == 0){
// $percen=0;
// }else{
// $percen=(abs($rs1['YEAR1']-$rs1['YEAR2'])*100)/($rs1['YEAR1']+$rs1['YEAR2']);
// }
$percen = $rs1['YEAR1']!=0?($rs1['YEAR2']-$rs1['YEAR1'])*100/$rs1['YEAR1']:"0";
$percen = $rs1['YEAR1'] == 0 && $rs1['YEAR2'] > 0 ? "100" : $percen ;
?>
<td align="center" ><?=numberSymbolPercen_in(number_format($percen,2))?></td>
</tr>
<?
}
?>
<tr bgcolor="#FFFFFF">
<td> </td>
<td><strong>รวม</strong></td>
<td align="center">
<?
if($totalYear1 != 0){
?>
<a href="complain_detail.php?sel_year=<?=$year1?>" target="_blank">
<? }?>
<?=number_format($totalYear1)?></a></td>
<td align="center">
<?
if($totalYear2 != 0){
?>
<a href="complain_detail.php?sel_year=<?=$year2?>" target="_blank">
<? }?>
<?=number_format($totalYear2)?></a></td>
<?
//$percenALL=($totalYear2-$totalYear1)*100/$totalYear1;
//$percen=$totalYear1!=0? (totalYear2)*100/$totalYear1 : ($totalYear2>0? "100": "0");
$percen=$totalYear1!=0?($totalYear2-$totalYear1)*100/$totalYear1:"0";
$percen = $totalYear1 ==0 && $totalYear2 > 0 ? "100" : $percen ;
?>
<td align="center">
<?=numberSymbolPercen_in(number_format($percen,2))?>
</td>
</tr>
</table>
<?
}
else{
?>
<table width="99%" border="1" align="center" cellpadding="4" cellspacing="0" bordercolor="#636276" style="border-collapse:collapse;">
<tr bgcolor="#BDC9F9">
<td colspan="5" align="center" class="bg_th"><strong>รายงานเปรียบปัญหาและความต้องการจำแนกตามพื้นที่</strong></td>
</tr>
<tr bgcolor="#BDC9F9">
<td width="8%" align="center" class="bg_th"><strong>ลำดับที่</strong></td>
<td align="center" class="bg_th"><strong>ตำบล</strong></td>
<td width="20%" align="center" class="bg_th"><strong>พ.ศ. <?=$year1+543?></strong></td>
<td width="20%" align="center" class="bg_th"><strong>พ.ศ. <?=$year2+543?></strong></td>
<td width="15%" align="center" class="bg_th"><strong>ร้อยละ</strong></td>
</tr>
<?
if($_GET['level']==''){
$level="";
}else{
$level="and request_level='".$_GET['level']."' ";
}
$tamDigi=substr ( $_GET['amphur'],0, 4 );
$strSQL_3 = "SELECT *
FROM ccaa_pathumthani
WHERE ccaa_pathumthani.ccDigi LIKE '".$tamDigi."%' and ccaa_pathumthani.ccType='Tamboon'
";
$rsConn_3 = mysql_db_query($dbname,$strSQL_3);
//echo $strSQL_3;
$i=0;
$totalYear1 = "";
$totalYear2 = "";
while ( $Result_3 = mysql_fetch_assoc($rsConn_3)) {
$i++;
/*if($_GET['amphur']==''){
$amphur="and public_amphur='".$Result_2['ccDigi']."' ";
}else{
$amphur="ตำบล";
}*/
$strSQL_2 = "SELECT
distinct (select Count(tbl_complain.complain_id) from tbl_complain where yy='".$year1."' ".$level." and public_tambol='".$Result_3['ccDigi']."') as YEAR1,
(select Count(tbl_complain.complain_id) from tbl_complain where yy='".$year2."' ".$level." and public_tambol='".$Result_3['ccDigi']."') as YEAR2
FROM tbl_complain
";
$rsConn_2 = mysql_db_query($dbname,$strSQL_2);
$rs2 = mysql_fetch_assoc($rsConn_2);
//echo $strSQL_2.'<p/>';
?>
<tr bgcolor="#FFFFFF">
<td align="center"><?=$i?></td>
<td><?=$Result_3['ccName']?></td>
<td align="center">
<?
if($rs2['YEAR1'] != 0){
?>
<a href="complain_detail.php?sel_district=<?=$Result_3['ccDigi']?>&sel_year=<?=$year1?>" target="_blank">
<? }?>
<?=number_format($rs2['YEAR1'])?></a></td>
<td align="center">
<?
if($rs2['YEAR2'] != 0){
?>
<a href="complain_detail.php?sel_district=<?=$Result_3['ccDigi']?>&sel_year=<?=$year2?>" target="_blank">
<? }?>
<?=number_format($rs2['YEAR2'])?></a></td>
<?
$totalYear1+=$rs2['YEAR1'];
$totalYear2+=$rs2['YEAR2'];
// if(($rs2['YEAR1']+$rs2['YEAR2']) == 0){
// $percen=0;
// }else{
// $percen=$rs2['YEAR1']!=0?($rs2['YEAR1']-$rs2['YEAR2'])*100/$rs2['YEAR1']:"0";
// }
$percen = $rs2['YEAR1']!=0?($rs2['YEAR2']-$rs2['YEAR1'])*100/$rs2['YEAR1'] : "0";
$percen = $rs2['YEAR1']==0 && $rs2['YEAR2'] > 0 ? "100" : $percen ;
?>
<td align="center" ><?=numberSymbolPercen_in(number_format($percen,2))?></td>
</tr>
<?
}
?>
<tr bgcolor="#FFFFFF">
<td></td>
<td><strong>รวม</strong></td>
<td align="center">
<?
if($totalYear1 != 0){
?>
<a href="complain_detail.php?sel_aumpur=<?=$_GET['amphur']?>&sel_year=<?=$year1?>" target="_blank">
<? }?>
<?=number_format($totalYear1)?></a></td>
<td align="center">
<?
if($totalYear2 != 0){
?>
<a href="complain_detail.php?sel_aumpur=<?=$_GET['amphur']?>&sel_year=<?=$year2?>" target="_blank">
<? }?>
<?=number_format($totalYear2)?></a></td>
<?
//$percenALL=($totalYear2-$totalYear1)*100/$totalYear1;
//$percen=$totalYear1!=0? (totalYear2)*100/$totalYear1 : ($totalYear2>0? "100": "0");
$percen=$totalYear1!=0?($totalYear2)-$totalYear1*100/$totalYear1:"0";
$percen = $totalYear1==0 && $totalYear2 > 0 ? "100" : $percen ;
?>
<td align="center"><?=numberSymbolPercen_in(number_format($percen,2))?></td>
</tr>
</table>
<?
}
?>
<br>
<br>
</body>
</html>
<?
//insert timeQuery
//$time_end = getmicrotime();
//writetime2db($timestart,$time_end);
//insert timeQuery
?>