|
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/pathumthani_drug/report/ |
Upload File : |
<?
session_start();
//header("Content-Type: text/html; charset=windows-874");
set_time_limit(0) ;
include_once("../common/config.joomla.php");
$dbname = 'pathumthani_drug';
function getMonth($d){
$month = array( "","ม.ค.","ก.พ.","มี.ค.","เม.ย.","พ.ค.","มิ.ย.", "ก.ค.","ส.ค.","ก.ย.","ต.ค.","พ.ย.","ธ.ค.");
$monthname = array( "","มกราคม","กุมภาพันธ์","มีนาคม","เมษายน","พฤษภาคม","มิถุนายน", "กรกฎาคม","สิงหาคม","กันยายน","ตุลาคม","พฤศจิกายน","ธันวาคม");
return $monthname[intval($d)];
}
?>
<style type="text/css">
<!--
body { padding:0px 0px; margin: 0px; 0px; }
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;font-size: 12px;}
-->
.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;
font-size: 12px;
}
.bg_th1{
background-repeat:repeat-x;
background-color:#355790;
font-weight:bold;
color:#FFFFFF;
text-align:center;
font-size: 12px;
}
td { font-size: 12px; }
.style1 {color: #FF0000}
</style>
<SCRIPT type="text/javascript">
function chkForm(form){
if(document.getElementById('yy_start').value == "0000"){
alert('กรุณากรอกปี');
document.getElementById('yy_start').focus();
return false;
}else if(document.getElementById('mm_start').value == "00"){
alert('กรุณากรอกเดือน');
document.getElementById('mm_start').focus();
return false;
}else if(document.getElementById('yy_end').value == "0000"){
alert('กรุณากรอกปี');
document.getElementById('yy_end').focus();
return false;
}else if(document.getElementById('mm_end').value == "00"){
alert('กรุณากรอกเดือน');
document.getElementById('mm_end').focus();
return false;
}else{
return true;
}
}
</SCRIPT>
<body>
<?
include("header.php");
if($_GET['yy_start']){
$yy_start=$_GET['yy_start'];
}else{
$yy_start=date('Y');
}
if($_GET['mm_start']){
$mm_start=$_GET['mm_start'];
}else{
$mm_start=date('M');
}
if($_GET['yy_end']){
$yy_end=$_GET['yy_end'];
}else{
$yy_end=date('Y');
}
if($_GET['mm_end']){
$mm_end=$_GET['mm_end'];
}else{
$mm_end=date('M');
}
?>
<br />
<?php
function getlink($ccDigi = ""){
$arrKey = array("Aumpur"=>4, "Tamboon"=>6);
$str = '<a href="?yy_start='.$_GET["yy_start"].'&mm_start='.$_GET["mm_start"].'&yy_end='.$_GET["yy_end"].'&mm_end='.$_GET["mm_end"].'">จังหวัด ปทุมธานี</a>';
if($ccDigi != "" && $ccDigi != 13){
foreach($arrKey as $key=>$value){
$set_ccDigi = substr($ccDigi, 0, $value);
$sql = "SELECT ccDigi,ccName,ccType FROM ccaa WHERE ccType='". $key ."' AND ccDigi like '". $set_ccDigi ."%' ";
$query = mysql_query( $sql );
$row = mysql_fetch_assoc( $query );
if($row["ccDigi"]!=""){
$str .= ' >><a href="?yy_start='.$_GET["yy_start"].'&mm_start='.$_GET["mm_start"].'&yy_end='.$_GET["yy_end"].'&mm_end='.$_GET["mm_end"].'">'.$row["ccName"].'</a>';
}
}
}
return $str;
}
if( (($_GET["ccType"] != "")?$_GET["ccType"]:"Changwat") == "Changwat" ){
$ccDigi = 13;
$ccType = "Aumpur";
$FieldRegged = "addr_amphur";
$table = "ccaa";
$tiltle_col = "อำเภอ";
}else
if( (($_GET["ccType"] != "")?$_GET["ccType"]:"Changwat") == "Aumpur" ){
//if($_SESSION['session_access_id'] <= 7 and $_SESSION['session_access_id'] != ""){
$ccDigi = substr($_GET["ccDigi"],0,4);
$ccType = "Tamboon";
$FieldRegged = "addr_tambon";
$table = "ccaa";
$tiltle_col = "ตำบล";
//}
}else
if( (($_GET["ccType"] != "")?$_GET["ccType"]:"Changwat") == "Tamboon"){
//if($_SESSION['session_access_id'] <= 7 and $_SESSION['session_access_id'] != ""){
$ccDigi = substr($_GET["ccDigi"],0,6);
$ccType = "Village";
$FieldRegged = "addr_moo";
$table = "ccaa_village";
$tiltle_col = "หมู่้บ้าน";
//}
}
$sql_tam = "SELECT ccDigi, ccName, ccType " .(($table == "ccaa_village" )?", ccMoo ":"")." FROM ".$table." WHERE ccType='". $ccType ."' AND ccDigi like '". $ccDigi ."%' ";
//echo $sql_tam;
?>
<table width="99%" border="0" align="center" cellpadding="3" cellspacing="1">
<tr>
<td align="center"><strong>รายงานข้อมูลปัญหายาเสพติดที่เกิดขึ้นในจังหวัดปทุมธานีเปรียบเทียบเป็น รายเดือน</strong> </td>
</tr>
</table>
<br />
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" align="center">
<form name="month_compare" method="get" action="" onSubmit="return chkForm(this);">
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td colspan="2" class="bg_th"><strong>เลือกแสดงการเปรียบเทียบเป็นรายเดือน</strong></td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="right"><strong><span class="style1">*</span>เลือกปี / เดือน </strong></td>
<td><select name="yy_start" id="yy_start">
<option value="0000">ปี พ.ศ.</option>
<?
$ThisYear = date("Y");
for ( $intA = $ThisYear; $intA >= $ThisYear - 10; $intA-- ) {
?>
<option value="<?=$intA?>" <? if ( $_GET["yy_start"] == $intA ) echo "selected"; ?>>
<?=$intA+543?>
</option>
<?
}
?>
</select>
<select name="mm_start" id="mm_start">
<option value="00">เดือน</option>
<?
$Month = array("", "มกราคม", "กุมภาพันธ์", "มีนาคม", "เมษายน", "พฤษภาคม", "มิถุนายน", "กรกฎาคม", "สิงหาคม", "กันยายน", "ตุลาคม", "พฤศจิกายน", "ธันวาคม");
for ( $intA = 1; $intA <=12; $intA++ ) {
?>
<option value="<?=sprintf("%02d", $intA)?>" <? if ( $_GET["mm_start"] == sprintf("%02d", $intA) ) echo "selected"; ?>>
<?=$Month[$intA]?>
</option>
<?
}
?>
</select></td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="right"><span class="style1"><strong>*</strong></span><strong>เลือกปี / เดือน </strong></td>
<td><select name="yy_end" id="yy_end">
<option value="0000">ปี พ.ศ.</option>
<?
$ThisYear = date("Y");
for ( $intA = $ThisYear; $intA >= $ThisYear - 10; $intA-- ) {
?>
<option value="<?=$intA?>" <? if ( $_GET["yy_end"] == $intA ) echo "selected"; ?>>
<?=$intA+543?>
</option>
<?
}
?>
</select>
<select name="mm_end" id="mm_end">
<option value="00">เดือน</option>
<?
$Month = array("", "มกราคม", "กุมภาพันธ์", "มีนาคม", "เมษายน", "พฤษภาคม", "มิถุนายน", "กรกฎาคม", "สิงหาคม", "กันยายน", "ตุลาคม", "พฤศจิกายน", "ธันวาคม");
for ( $intA = 1; $intA <=12; $intA++ ) {
?>
<option value="<?=sprintf("%02d", $intA)?>" <? if ( $_GET["mm_end"] == sprintf("%02d", $intA) ) echo "selected"; ?>>
<?=$Month[$intA]?>
</option>
<?
}
?>
</select></td>
</tr>
<tr bgcolor="#FFFFFF">
<td> </td>
<td><label>
<input name="submit" type="submit" id="submit" value="แสดงเปรียบเทียบ">
</label>
</td>
</tr>
</table>
</form>
</td>
<td align="center" valign="top"><table width="85%" border="0" bgcolor="#CCCCCC" cellpadding="3" cellspacing="1">
<tr class="bg_th">
<td align="center" width="200"></td>
<td align="center" width="150"><strong>
<?=getMonth($_GET["mm_start"])?><?=($_GET["yy_start"]+543)?>
</strong></td>
<td align="center" width="150"><strong>
<?=getMonth($_GET["mm_end"])?><?=($_GET["yy_end"]+543)?>
</strong></td>
<td align="center" width="100"><strong>สถานะ</strong></td>
<td align="center" width="100"><strong>ร้อยละที่เพิ่มขึ้น</strong></td>
</tr>
<?php
##### FOR SCHOOL #####################################################################
$_SQL_SCHOOL1 = "SELECT COUNT(student_id) AS ALL_SCHOOL FROM blacklist_student WHERE sdate LIKE '".$yy_start."_".$mm_start."___'";
$resultSet_school1 = mysql_db_query($dbname,$_SQL_SCHOOL1);
$_rows_school1 = mysql_fetch_assoc($resultSet_school1);
$_SQL_SCHOOL2 = "SELECT COUNT(student_id) AS ALL_SCHOOL FROM blacklist_student WHERE sdate LIKE '".$yy_end."_".$mm_end."___'";
$resultSet_school2 = mysql_db_query($dbname,$_SQL_SCHOOL2);
$_rows_school2 = mysql_fetch_assoc($resultSet_school2);
if($_rows_school1['ALL_SCHOOL']==0)
$percen_school=0;
else
$percen_school=(($_rows_school2['ALL_SCHOOL']-$_rows_school1['ALL_SCHOOL'])/$_rows_school1['ALL_SCHOOL'])*100;
if($_rows_school1['ALL_SCHOOL']<$_rows_school2['ALL_SCHOOL']){
$img_school='<img src="delta_up.png" width="14" height="14" align="top" />';
}else if($_rows_school1['ALL_SCHOOL']>$_rows_school2['ALL_SCHOOL']){
$img_school='<img src="delta_down.png" width="14" height="14" align="top" />';
}else{
$img_school='<img src="equal_symbol.png" width="14" height="14" align="top" />';
}
#### FOR SCHOOL ###########################################################################
?>
<tr bgcolor="#FFFFFF">
<td align="left"><strong>โรงเรียน</strong></td>
<td align="right"><?=number_format($_rows_school1['ALL_SCHOOL'])?></td>
<td align="right"><?=number_format($_rows_school2['ALL_SCHOOL'])?></td>
<td align="right"><?=$img_school?></td>
<td align="right"><?=number_format($percen_school,2)?>
% </td>
</tr>
<?php
##### FOR INDUSTRY #####################################################################
$_SQL_INDUSTRY1 = "SELECT COUNT(blacklist_industry.employee_id) AS ALL_INDUSTRY FROM blacklist_industry INNER JOIN check_drug ON blacklist_industry.check_drug_id = check_drug.check_drug_id WHERE check_drug.check_date LIKE '".$yy_start."_".$mm_start."___'";
$resultSet_industry1 = mysql_db_query($dbname,$_SQL_INDUSTRY1);
$_rows_industry1 = mysql_fetch_assoc($resultSet_industry1);
$_SQL_INDUSTRY2 = "SELECT COUNT(blacklist_industry.employee_id) AS ALL_INDUSTRY FROM blacklist_industry INNER JOIN check_drug ON blacklist_industry.check_drug_id = check_drug.check_drug_id WHERE check_drug.check_date LIKE '".$yy_end."_".$mm_end."___'";
$resultSet_industry2 = mysql_db_query($dbname,$_SQL_INDUSTRY2);
$_rows_industry2 = mysql_fetch_assoc($resultSet_industry2);
if($_rows_industry1['ALL_INDUSTRY']==0)
$percen_industry=0;
else
$percen_industry=(($_rows_industry2['ALL_INDUSTRY']-$_rows_industry1['ALL_INDUSTRY'])/$_rows_industry1['ALL_INDUSTRY'])*100;
if($_rows_industry1['ALL_INDUSTRY']<$_rows_industry2['ALL_INDUSTRY']){
$img_industry='<img src="delta_up.png" width="14" height="14" align="top" />';
}else if($_rows_industry1['ALL_INDUSTRY']>$_rows_industry2['ALL_INDUSTRY']){
$img_industry='<img src="delta_down.png" width="14" height="14" align="top" />';
}else{
$img_industry='<img src="equal_symbol.png" width="14" height="14" align="top" />';
}
#### FOR INDUSTRY ###########################################################################
?>
<tr bgcolor="#FFFFFF">
<td align="left"><strong>โรงงาน</strong></td>
<td align="right"><?=number_format($_rows_industry1['ALL_INDUSTRY'])?></td>
<td align="right"><?=number_format($_rows_industry2['ALL_INDUSTRY'])?></td>
<td align="right"><?=$img_industry?></td>
<td align="right"><?=number_format($percen_industry,2)?>
% </td>
</tr>
<?php
##### FOR PRISONER #####################################################################
$_SQL_PRISONER1 = "SELECT COUNT(arrest_prisoner.pri_id) AS ALL_PRISONER FROM arrest_prisoner INNER JOIN arrest_detail ON arrest_prisoner.arr_id = arrest_detail.arr_id WHERE arrest_detail.arr_date LIKE '".$yy_start."_".$mm_start."___'";
$resultSet_prisoner1 = mysql_db_query($dbname,$_SQL_PRISONER1);
$_rows_prisoner1 = mysql_fetch_assoc($resultSet_prisoner1);
$_SQL_PRISONER2 = "SELECT COUNT(arrest_prisoner.pri_id) AS ALL_PRISONER FROM arrest_prisoner INNER JOIN arrest_detail ON arrest_prisoner.arr_id = arrest_detail.arr_id WHERE arrest_detail.arr_date LIKE '".$yy_end."_".$mm_end."___'";
$resultSet_prisoner2 = mysql_db_query($dbname,$_SQL_PRISONER2);
$_rows_prisoner2 = mysql_fetch_assoc($resultSet_prisoner2);
if($_rows_prisoner1['ALL_PRISONER']==0)
$percen_prisoner=0;
else
$percen_prisoner=(($_rows_prisoner2['ALL_PRISONER']-$_rows_prisoner1['ALL_PRISONER'])/$_rows_prisoner1['ALL_PRISONER'])*100;
if($_rows_prisoner1['ALL_PRISONER']<$_rows_prisoner2['ALL_PRISONER']){
$img_prisoner='<img src="delta_up.png" width="14" height="14" align="top" />';
}else if($_rows_prisoner1['ALL_PRISONER']>$_rows_prisoner2['ALL_PRISONER']){
$img_prisoner='<img src="delta_down.png" width="14" height="14" align="top" />';
}else{
$img_prisoner='<img src="equal_symbol.png" width="14" height="14" align="top" />';
}
#### FOR PRISONER ###########################################################################
?>
<tr bgcolor="#FFFFFF">
<td align="left"><strong>ถูกจับกุม</strong></td>
<td align="right"><?=number_format($_rows_prisoner1['ALL_PRISONER'])?></td>
<td align="right"><?=number_format($_rows_prisoner2['ALL_PRISONER'])?></td>
<td align="right"><?=$img_prisoner?></td>
<td align="right"><?=number_format($percen_prisoner,2)?>
% </td>
</tr>
<?php
##### FOR CURE #####################################################################
$_SQL_CURE1 = "SELECT COUNT(cure_id) AS ALL_CURE FROM cure_personal WHERE cure_date LIKE '".$yy_start."_".$mm_start."___'";
$resultSet_cure1 = mysql_db_query($dbname,$_SQL_CURE1);
$_rows_cure1 = mysql_fetch_assoc($resultSet_cure1);
$_SQL_CURE2 = "SELECT COUNT(cure_id) AS ALL_CURE FROM cure_personal WHERE cure_date LIKE '".$yy_end."_".$mm_end."___'";
$resultSet_cure2 = mysql_db_query($dbname,$_SQL_CURE2);
$_rows_cure2 = mysql_fetch_assoc($resultSet_cure2);
if($_rows_cure1['ALL_CURE']==0)
$percen_cure=0;
else
$percen_cure=(($_rows_cure2['ALL_CURE']-$_rows_cure1['ALL_CURE'])/$_rows_cure1['ALL_CURE'])*100;
if($_rows_cure1['ALL_CURE']<$_rows_cure2['ALL_CURE']){
$img_cure='<img src="delta_up.png" width="14" height="14" align="top" />';
}else if($_rows_cure1['ALL_CURE']>$_rows_cure2['ALL_CURE']){
$img_cure='<img src="delta_down.png" width="14" height="14" align="top" />';
}else{
$img_cure='<img src="equal_symbol.png" width="14" height="14" align="top" />';
}
#### FOR CURE ###########################################################################
?>
<tr bgcolor="#FFFFFF">
<td align="left"><strong>เข้ารับการบำบัดรักษา</strong></td>
<td align="right"><?=number_format($_rows_cure1['ALL_CURE'])?></td>
<td align="right"><?=number_format($_rows_cure2['ALL_CURE'])?></td>
<td align="right"><?=$img_cure?></td>
<td align="right"><?=number_format($percen_cure,2)?>
% </td>
</tr>
</table></td>
</tr>
</table>
<script src="common/gs_sortable.js"></script>
<link href="common/gs_sortable.css" />
<table width="99%" border="0" align="center" cellpadding="3" cellspacing="1" id="my_table5">
<tr>
<td><?php echo getlink( $_GET["ccDigi"] ); ?> </td>
<td width="53%" align="right"><a href="index.php">[เลือกเปรียบเทียบเป็นรายปี]</a></td>
</tr>
</table>
<table width="99%" border="0" align="center" bgcolor="#CCCCCC" cellpadding="3" cellspacing="1" id="my_table1">
<thead>
<tr class="bg_th">
<th width="5%" rowspan="2" align="center"><strong>ลำดับที่</strong></th>
<th width="30%" rowspan="2" align="center"><font color="#FFFFFF"><strong>พื้นที่</strong></font></th>
<td colspan="4">
<div>
<?php
if(intval($_GET["mm_start"]) > 1){
?>
<span style=" float:left">
<a href="?yy_start=<?=$_GET["yy_start"]?>&mm_start=<?php echo (($_GET["mm_start"] <= 1)?$_GET["mm_start"]:($_GET["mm_start"]-1));?>&yy_end=<?=$_GET["yy_end"]?>&mm_end=<?=$_GET["mm_end"]?>"><img src="back.jpg" border="0" width="20" height="20" align="absmiddle" /></a></span>
<?php } ?>
<span style="float:center"><font color="#FFFFFF"><strong><?=getMonth($_GET["mm_start"])?> <?=($_GET["yy_start"]+543)?></strong></font></span>
<?php
if(intval($_GET["mm_start"]) < 12){
?>
<span style="float:right"><a href="?yy_start=<?=$_GET["yy_start"]?>&mm_start=<?php echo (($_GET["mm_start"] >= 12)?$_GET["mm_start"]:($_GET["mm_start"]+1));?>&yy_end=<?=$_GET["yy_end"]?>&mm_end=<?=$_GET["mm_end"]?>"><img src="next.jpg" border="0" width="20" height="20" align="absmiddle" /></a></span>
<?php } ?>
</div>
</td>
<?
//if($_GET['compair']){
?>
<td colspan="4">
<div>
<?php
if(intval($_GET["mm_end"]) > 1){
?>
<span style=" float:left"><a href="?yy_start=<?=$_GET["yy_start"]?>&mm_start=<?=$_GET["mm_start"]?>&yy_end=<?=$_GET["yy_end"]?>&mm_end=<?php echo (($_GET["mm_end"] <= 1)?$_GET["mm_end"]:($_GET["mm_end"]-1));?>"><img src="back.jpg" border="0" width="20" height="20" align="absmiddle" /></a></span>
<?php } ?>
<span style="float:center"><font color="#FFFFFF"><strong><?=getMonth($_GET["mm_end"])?> <?=($_GET["yy_end"]+543)?> </strong></font></span>
<?php
if(intval($_GET["mm_end"]) < 12){
?>
<span style="float:right"><a href="?yy_start=<?=$_GET["yy_start"]?>&mm_start=<?=$_GET["mm_start"]?>&yy_end=<?=$_GET["yy_end"]?>&mm_end=<?php echo (($_GET["mm_end"] >= 12)?$_GET["mm_end"]:($_GET["mm_end"]+1));?>"><img src="next.jpg" border="0" width="20" height="20" align="absmiddle" /></a></span>
<?php } ?>
</div>
</td>
</tr>
<tr class="bg_th1">
<th width="90" align="center"><font color="#FFFFFF"><strong>โรงเรียน</strong></font></th>
<th width="90" align="center"><font color="#FFFFFF"><strong>โรงงาน</strong></font></th>
<td width="90" align="center"><font color="#FFFFFF"><strong>ถูกจับกุม</strong></font></td>
<th width="90" align="center"><font color="#FFFFFF"><strong>เข้ารับการบำบัดรักษา</strong></font></th>
<?
//if($_GET['compair']){
?>
<th width="90" align="center"><font color="#FFFFFF"><strong>โรงเรียน</strong></font></th>
<th width="90" align="center"><font color="#FFFFFF"><strong>โรงงาน</strong></font></th>
<td width="90" align="center"><font color="#FFFFFF"><strong>ถูกจับกุม</strong></font></td>
<th width="90" align="center"><font color="#FFFFFF"><strong>เข้ารับการบำบัดรักษา</strong></font></th>
</tr>
</thead>
<tbody>
<?
$i=0;
$_sum_row = 0;
$am_tam = mysql_query($sql_tam);
$totalALL_SCHOOL_1=0;
$totalALL_INDUSTRY_1=0;
$totalALL_PRISONER_1=0;
$totalALL_CURE_1=0;
$totalALL_SCHOOL_2=0;
$totalALL_INDUSTRY_2=0;
$totalALL_PRISONER_2=0;
$totalALL_CURE_2=0;
while( $ram_tam = mysql_fetch_assoc($am_tam) ) {
$i++;
$rowNumb = ($i+($board_link_num*$page)-$board_link_num);
if($ccType == ""){
$_SQL_SCHOOL = "SELECT COUNT(student_id) AS ALL_SCHOOL FROM blacklist_student WHERE sdate LIKE '".$yy_start."_".$mm_start."___' AND addr_province like '13%'";
$_SQL_INDUSTRY = "SELECT COUNT(blacklist_industry.employee_id) AS ALL_INDUSTRY FROM blacklist_industry INNER JOIN check_drug ON blacklist_industry.check_drug_id = check_drug.check_drug_id WHERE check_drug.check_date LIKE '".$yy_start."_".$mm_start."___' AND addr_province like '13%'";
$_SQL_PRISONER = "SELECT COUNT(arrest_prisoner.pri_id) AS ALL_PRISONER FROM arrest_prisoner INNER JOIN arrest_detail ON arrest_prisoner.arr_id = arrest_detail.arr_id WHERE arrest_detail.arr_date LIKE '".$yy_start."_".$mm_start."___'";
$_SQL_CURE = "SELECT COUNT(cure_id) AS ALL_CURE FROM cure_personal WHERE cure_date LIKE '".$yy_start."_".$mm_start."___' AND addr_province like '13%'";
}
else if($ccType == "Aumpur"){
$_SQL_SCHOOL = "SELECT COUNT(student_id) AS ALL_SCHOOL FROM blacklist_student WHERE sdate LIKE '".$yy_start."_".$mm_start."___' AND addr_amphur like '".$ram_tam["ccDigi"]."%'";
$_SQL_INDUSTRY = "SELECT COUNT(blacklist_industry.employee_id) AS ALL_INDUSTRY FROM blacklist_industry INNER JOIN check_drug ON blacklist_industry.check_drug_id = check_drug.check_drug_id WHERE check_drug.check_date LIKE '".$yy_start."_".$mm_start."___' AND addr_amphur like '".$ram_tam["ccDigi"]."%'";
$_SQL_PRISONER = "SELECT COUNT(arrest_prisoner.pri_id) AS ALL_PRISONER FROM arrest_prisoner INNER JOIN arrest_detail ON arrest_prisoner.arr_id = arrest_detail.arr_id WHERE arrest_detail.arr_date LIKE '".$yy_start."_".$mm_start."___' AND arr_amphur like '".$ram_tam["ccDigi"]."%'";
$_SQL_CURE = "SELECT COUNT(cure_id) AS ALL_CURE FROM cure_personal WHERE cure_date LIKE '".$yy_start."_".$mm_start."___' AND addr_amphur like '".$ram_tam["ccDigi"]."%'";
}
else if($ccType == "Tamboon"){
$_SQL_SCHOOL = "SELECT COUNT(student_id) AS ALL_SCHOOL FROM blacklist_student WHERE sdate LIKE '".$yy_start."_".$mm_start."___' AND addr_tambon like '".$ram_tam["ccDigi"]."%'";
$_SQL_INDUSTRY = "SELECT COUNT(blacklist_industry.employee_id) AS ALL_INDUSTRY FROM blacklist_industry INNER JOIN check_drug ON blacklist_industry.check_drug_id = check_drug.check_drug_id WHERE check_drug.check_date LIKE '".$yy_start."_".$mm_start."___' AND addr_tambon like '".$ram_tam["ccDigi"]."%'";
$_SQL_PRISONER = "SELECT COUNT(arrest_prisoner.pri_id) AS ALL_PRISONER FROM arrest_prisoner INNER JOIN arrest_detail ON arrest_prisoner.arr_id = arrest_detail.arr_id WHERE arrest_detail.arr_date LIKE '".$yy_start."_".$mm_start."___' AND arr_tamboon like '".$ram_tam["ccDigi"]."%'";
$_SQL_CURE = "SELECT COUNT(cure_id) AS ALL_CURE FROM cure_personal WHERE cure_date LIKE '".$yy_start."_".$mm_start."___' AND addr_tambon like '".$ram_tam["ccDigi"]."%'";
}
else if($ccType == "Village"){
$_SQL_SCHOOL = "SELECT COUNT(student_id) AS ALL_SCHOOL FROM blacklist_student WHERE sdate LIKE '".$yy_start."_".$mm_start."___' AND addr_moo like '".$ram_tam["ccDigi"]."%'";
$_SQL_INDUSTRY = "SELECT COUNT(blacklist_industry.employee_id) AS ALL_INDUSTRY FROM blacklist_industry INNER JOIN check_drug ON blacklist_industry.check_drug_id = check_drug.check_drug_id WHERE check_drug.check_date LIKE '".$yy_start."_".$mm_start."___' AND addr_moo like '".$ram_tam["ccDigi"]."%'";
$_SQL_PRISONER = "SELECT COUNT(arrest_prisoner.pri_id) AS ALL_PRISONER FROM arrest_prisoner INNER JOIN arrest_detail ON arrest_prisoner.arr_id = arrest_detail.arr_id WHERE arrest_detail.arr_date LIKE '".$yy_start."_".$mm_start."___' AND arr_village like '".$ram_tam["ccDigi"]."%'";
$_SQL_CURE = "SELECT COUNT(cure_id) AS ALL_CURE FROM cure_personal WHERE cure_date LIKE '".$yy_start."_".$mm_start."___' AND addr_moo like '".$ram_tam["ccDigi"]."%'";
}
$_resultSet_school = mysql_db_query($dbname,$_SQL_SCHOOL);
$resTable_1 = mysql_fetch_assoc($_resultSet_school);
$_resultSet_industry = mysql_db_query($dbname,$_SQL_INDUSTRY);
$resTable_2 = mysql_fetch_assoc($_resultSet_industry);
$_resultSet_prisoner = mysql_db_query($dbname,$_SQL_PRISONER);
$resTable_3 = mysql_fetch_assoc($_resultSet_prisoner);
$_resultSet_cure = mysql_db_query($dbname,$_SQL_CURE);
$resTable_4 = mysql_fetch_assoc($_resultSet_cure);
$totalALL_SCHOOL_1+=$resTable_1['ALL_SCHOOL'];
$totalALL_INDUSTRY_1+=$resTable_2['ALL_INDUSTRY'];
$totalALL_PRISONER_1+=$resTable_3['ALL_PRISONER'];
$totalALL_CURE_1+=$resTable_4['ALL_CURE'];
?>
<tr bgcolor="#FFFFFF">
<td align="center"><?=$rowNumb?></td>
<td align="left">
<?php
if($ccType != "Village"){
if($ccType == 'Aumpur'){
$link_var = "?ccType=".$ram_tam['ccType']."&ccDigi=".$ram_tam['ccDigi']."&yy_start=".$_GET["yy_start"]."&mm_start=".$_GET["mm_start"]."&yy_end=".$_GET["yy_end"]."&mm_end=".$_GET["mm_end"];
$txt = $ram_tam['ccName'];
$target = "_self";
$access_level = 7;
//$link = checkPrivilege($link_var,$txt,$target,$access_level);
$link = "<a href='".$link_var."' target = '".$target."'>".$txt."</a>";
echo $link;
}
if($ccType == 'Tamboon'){
$link_var = "?ccType=".$ram_tam['ccType']."&ccDigi=".$ram_tam['ccDigi']."&yy_start=".$_GET["yy_start"]."&mm_start=".$_GET["mm_start"]."&yy_end=".$_GET["yy_end"]."&mm_end=".$_GET["mm_end"];
$txt = $ram_tam['ccName'];
$target = "_self";
$access_level = 7;
//$link = checkPrivilege($link_var,$txt,$target,$access_level);
$link = "<a href='".$link_var."' target = '".$target."'>".$txt."</a>";
echo $link;
}
}else{
echo "หมู่ที่ ".$ram_tam['ccMoo']." ".$ram_tam['ccName'];
}
?>
</td>
<td align="right"><?=number_format($resTable_1['ALL_SCHOOL'])?></td>
<td align="right"><?=number_format($resTable_2['ALL_INDUSTRY'])?></td>
<td align="right"><?=number_format($resTable_3['ALL_PRISONER'])?></td>
<td align="right"><?=number_format($resTable_4['ALL_CURE'])?></td>
<?
//if($_GET['compair']){
if($ccType == ""){
$_SQL_SCHOOL = "SELECT COUNT(student_id) AS ALL_SCHOOL FROM blacklist_student WHERE sdate LIKE '".$yy_end."_".$mm_end."___' AND addr_province like '13%'";
$_SQL_INDUSTRY = "SELECT COUNT(blacklist_industry.employee_id) AS ALL_INDUSTRY FROM blacklist_industry INNER JOIN check_drug ON blacklist_industry.check_drug_id = check_drug.check_drug_id WHERE check_drug.check_date LIKE '".$yy_end."_".$mm_end."___' AND addr_province like '13%'";
$_SQL_PRISONER = "SELECT COUNT(arrest_prisoner.pri_id) AS ALL_PRISONER FROM arrest_prisoner INNER JOIN arrest_detail ON arrest_prisoner.arr_id = arrest_detail.arr_id WHERE arrest_detail.arr_date LIKE '".$yy_end."_".$mm_end."___'";
$_SQL_CURE = "SELECT COUNT(cure_id) AS ALL_CURE FROM cure_personal WHERE cure_date LIKE '".$yy_end."_".$mm_end."___' AND addr_province like '13%'";
}
else if($ccType == "Aumpur"){
$_SQL_SCHOOL = "SELECT COUNT(student_id) AS ALL_SCHOOL FROM blacklist_student WHERE sdate LIKE '".$yy_end."_".$mm_end."___' AND addr_amphur like '".$ram_tam["ccDigi"]."%'";
$_SQL_INDUSTRY = "SELECT COUNT(blacklist_industry.employee_id) AS ALL_INDUSTRY FROM blacklist_industry INNER JOIN check_drug ON blacklist_industry.check_drug_id = check_drug.check_drug_id WHERE check_drug.check_date LIKE '".$yy_end."_".$mm_end."___' AND addr_amphur like '".$ram_tam["ccDigi"]."%'";
$_SQL_PRISONER = "SELECT COUNT(arrest_prisoner.pri_id) AS ALL_PRISONER FROM arrest_prisoner INNER JOIN arrest_detail ON arrest_prisoner.arr_id = arrest_detail.arr_id WHERE arrest_detail.arr_date LIKE '".$yy_end."_".$mm_end."___' AND arr_amphur like '".$ram_tam["ccDigi"]."%'";
$_SQL_CURE = "SELECT COUNT(cure_id) AS ALL_CURE FROM cure_personal WHERE cure_date LIKE '".$yy_end."_".$mm_end."___' AND addr_amphur like '".$ram_tam["ccDigi"]."%'";
}
else if($ccType == "Tamboon"){
$_SQL_SCHOOL = "SELECT COUNT(student_id) AS ALL_SCHOOL FROM blacklist_student WHERE sdate LIKE '".$yy_end."_".$mm_end."___' AND addr_tambon like '".$ram_tam["ccDigi"]."%'";
$_SQL_INDUSTRY = "SELECT COUNT(blacklist_industry.employee_id) AS ALL_INDUSTRY FROM blacklist_industry INNER JOIN check_drug ON blacklist_industry.check_drug_id = check_drug.check_drug_id WHERE check_drug.check_date LIKE '".$yy_end."_".$mm_end."___' AND addr_tambon like '".$ram_tam["ccDigi"]."%'";
$_SQL_PRISONER = "SELECT COUNT(arrest_prisoner.pri_id) AS ALL_PRISONER FROM arrest_prisoner INNER JOIN arrest_detail ON arrest_prisoner.arr_id = arrest_detail.arr_id WHERE arrest_detail.arr_date LIKE '".$yy_end."_".$mm_end."___' AND arr_tamboon like '".$ram_tam["ccDigi"]."%'";
$_SQL_CURE = "SELECT COUNT(cure_id) AS ALL_CURE FROM cure_personal WHERE cure_date LIKE '".$yy_end."_".$mm_end."___' AND addr_tambon like '".$ram_tam["ccDigi"]."%'";
}
else if($ccType == "Village"){
$_SQL_SCHOOL = "SELECT COUNT(student_id) AS ALL_SCHOOL FROM blacklist_student WHERE sdate LIKE '".$yy_end."_".$mm_end."___' AND addr_moo like '".$ram_tam["ccDigi"]."%'";
$_SQL_INDUSTRY = "SELECT COUNT(blacklist_industry.employee_id) AS ALL_INDUSTRY FROM blacklist_industry INNER JOIN check_drug ON blacklist_industry.check_drug_id = check_drug.check_drug_id WHERE check_drug.check_date LIKE '".$yy_end."_".$mm_end."___' AND addr_moo like '".$ram_tam["ccDigi"]."%'";
$_SQL_PRISONER = "SELECT COUNT(arrest_prisoner.pri_id) AS ALL_PRISONER FROM arrest_prisoner INNER JOIN arrest_detail ON arrest_prisoner.arr_id = arrest_detail.arr_id WHERE arrest_detail.arr_date LIKE '".$yy_end."_".$mm_end."___' AND arr_village like '".$ram_tam["ccDigi"]."%'";
$_SQL_CURE = "SELECT COUNT(cure_id) AS ALL_CURE FROM cure_personal WHERE cure_date LIKE '".$yy_end."_".$mm_end."___' AND addr_moo like '".$ram_tam["ccDigi"]."%'";
}
$_resultSet_school = mysql_db_query($dbname,$_SQL_SCHOOL);
$resTable_5 = mysql_fetch_assoc($_resultSet_school);
$_resultSet_industry = mysql_db_query($dbname,$_SQL_INDUSTRY);
$resTable_6 = mysql_fetch_assoc($_resultSet_industry);
$_resultSet_prisoner = mysql_db_query($dbname,$_SQL_PRISONER);
$resTable_7 = mysql_fetch_assoc($_resultSet_prisoner);
$_resultSet_cure = mysql_db_query($dbname,$_SQL_CURE);
$resTable_8 = mysql_fetch_assoc($_resultSet_cure);
$totalALL_SCHOOL_2+=$resTable_5['ALL_SCHOOL'];
$totalALL_INDUSTRY_2+=$resTable_6['ALL_INDUSTRY'];
$totalALL_PRISONER_2+=$resTable_7['ALL_PRISONER'];
$totalALL_CURE_2+=$resTable_8['ALL_CURE'];
?>
<td align="right"><?=number_format($resTable_5['ALL_SCHOOL'])?></td>
<td align="right"><?=number_format($resTable_6['ALL_INDUSTRY'])?></td>
<td align="right"><?=number_format($resTable_7['ALL_PRISONER'])?></td>
<td align="right"><?=number_format($resTable_8['ALL_CURE'])?></td>
</tr>
<? }?>
<?php
if($ccType == "Aumpur"){
if($ccType == ""){
$_SQL_SCHOOL = "SELECT COUNT(student_id) AS ALL_SCHOOL FROM blacklist_student WHERE sdate LIKE '".$yy_start."_".$mm_start."___' AND addr_province = ''";
$_SQL_INDUSTRY = "SELECT COUNT(blacklist_industry.employee_id) AS ALL_INDUSTRY FROM blacklist_industry INNER JOIN check_drug ON blacklist_industry.check_drug_id = check_drug.check_drug_id WHERE check_drug.check_date LIKE '".$yy_start."_".$mm_start."___' AND addr_province = ''";
$_SQL_PRISONER = "SELECT COUNT(arrest_prisoner.pri_id) AS ALL_PRISONER FROM arrest_prisoner INNER JOIN arrest_detail ON arrest_prisoner.arr_id = arrest_detail.arr_id WHERE arrest_detail.arr_date LIKE '".$yy_start."_".$mm_start."___'";
$_SQL_CURE = "SELECT COUNT(cure_id) AS ALL_CURE FROM cure_personal WHERE cure_date LIKE '".$yy_start."_".$mm_start."___' AND addr_province = ''";
}
else if($ccType == "Aumpur"){
$_SQL_SCHOOL = "SELECT COUNT(student_id) AS ALL_SCHOOL FROM blacklist_student WHERE sdate LIKE '".$yy_start."_".$mm_start."___' AND addr_amphur = ''";
$_SQL_INDUSTRY = "SELECT COUNT(blacklist_industry.employee_id) AS ALL_INDUSTRY FROM blacklist_industry INNER JOIN check_drug ON blacklist_industry.check_drug_id = check_drug.check_drug_id WHERE check_drug.check_date LIKE '".$yy_start."_".$mm_start."___' AND addr_amphur = ''";
$_SQL_PRISONER = "SELECT COUNT(arrest_prisoner.pri_id) AS ALL_PRISONER FROM arrest_prisoner INNER JOIN arrest_detail ON arrest_prisoner.arr_id = arrest_detail.arr_id WHERE arrest_detail.arr_date LIKE '".$yy_start."_".$mm_start."___' AND arr_amphur = ''";
$_SQL_CURE = "SELECT COUNT(cure_id) AS ALL_CURE FROM cure_personal WHERE cure_date LIKE '".$yy_start."_".$mm_start."___' AND addr_amphur = ''";
}
else if($ccType == "Tamboon"){
$_SQL_SCHOOL = "SELECT COUNT(student_id) AS ALL_SCHOOL FROM blacklist_student WHERE sdate LIKE '".$yy_start."_".$mm_start."___' AND addr_tambon = ''";
$_SQL_INDUSTRY = "SELECT COUNT(blacklist_industry.employee_id) AS ALL_INDUSTRY FROM blacklist_industry INNER JOIN check_drug ON blacklist_industry.check_drug_id = check_drug.check_drug_id WHERE check_drug.check_date LIKE '".$yy_start."_".$mm_start."___' AND addr_tambon = ''";
$_SQL_PRISONER = "SELECT COUNT(arrest_prisoner.pri_id) AS ALL_PRISONER FROM arrest_prisoner INNER JOIN arrest_detail ON arrest_prisoner.arr_id = arrest_detail.arr_id WHERE arrest_detail.arr_date LIKE '".$yy_start."_".$mm_start."___' AND arr_tamboon = ''";
$_SQL_CURE = "SELECT COUNT(cure_id) AS ALL_CURE FROM cure_personal WHERE cure_date LIKE '".$yy_start."_".$mm_start."___' AND addr_tambon = ''";
}
else if($ccType == "Village"){
$_SQL_SCHOOL = "SELECT COUNT(student_id) AS ALL_SCHOOL FROM blacklist_student WHERE sdate LIKE '".$yy_start."_".$mm_start."___' AND addr_moo = ''";
$_SQL_INDUSTRY = "SELECT COUNT(blacklist_industry.employee_id) AS ALL_INDUSTRY FROM blacklist_industry INNER JOIN check_drug ON blacklist_industry.check_drug_id = check_drug.check_drug_id WHERE check_drug.check_date LIKE '".$yy_start."_".$mm_start."___' AND addr_moo = ''";
$_SQL_PRISONER = "SELECT COUNT(arrest_prisoner.pri_id) AS ALL_PRISONER FROM arrest_prisoner INNER JOIN arrest_detail ON arrest_prisoner.arr_id = arrest_detail.arr_id WHERE arrest_detail.arr_date LIKE '".$yy_start."_".$mm_start."___' AND arr_village = ''";
$_SQL_CURE = "SELECT COUNT(cure_id) AS ALL_CURE FROM cure_personal WHERE cure_date LIKE '".$yy_start."_".$mm_start."___' AND addr_moo = ''";
}
$_resultSet_school = mysql_db_query($dbname,$_SQL_SCHOOL);
$resTable_x1 = mysql_fetch_assoc($_resultSet_school);
$_resultSet_industry = mysql_db_query($dbname,$_SQL_INDUSTRY);
$resTable_x2 = mysql_fetch_assoc($_resultSet_industry);
$_resultSet_prisoner = mysql_db_query($dbname,$_SQL_PRISONER);
$resTable_x3 = mysql_fetch_assoc($_resultSet_prisoner);
$_resultSet_cure = mysql_db_query($dbname,$_SQL_CURE);
$resTable_x4 = mysql_fetch_assoc($_resultSet_cure);
$totalALL_SCHOOL_1+=$resTable_x1['ALL_SCHOOL'];
$totalALL_INDUSTRY_1+=$resTable_x2['ALL_INDUSTRY'];
$totalALL_PRISONER_1+=$resTable_x3['ALL_PRISONER'];
$totalALL_CURE_1+=$resTable_x4['ALL_CURE'];
?>
<tr bgcolor="#FFFFFF">
<td align="center"><?=$rowNumb+1?></td>
<td><strong>ไม่ได้ระบุเขตพื้นที่</strong></td>
<td align="right"><?=number_format($resTable_x1['ALL_SCHOOL'])?></td>
<td align="right"><?=number_format($resTable_x2['ALL_INDUSTRY'])?></td>
<td align="right"><?=number_format($resTable_x3['ALL_PRISONER'])?></td>
<td align="right"><?=number_format($resTable_x4['ALL_CURE'])?></td>
<?
//if($_GET['compair']){
if($ccType == ""){
$_SQL_SCHOOL = "SELECT COUNT(student_id) AS ALL_SCHOOL FROM blacklist_student WHERE sdate LIKE '".$yy_end."_".$mm_end."___' AND addr_province = ''";
$_SQL_INDUSTRY = "SELECT COUNT(blacklist_industry.employee_id) AS ALL_INDUSTRY FROM blacklist_industry INNER JOIN check_drug ON blacklist_industry.check_drug_id = check_drug.check_drug_id WHERE check_drug.check_date LIKE '".$yy_end."_".$mm_end."___' AND addr_province = ''";
$_SQL_PRISONER = "SELECT COUNT(arrest_prisoner.pri_id) AS ALL_PRISONER FROM arrest_prisoner INNER JOIN arrest_detail ON arrest_prisoner.arr_id = arrest_detail.arr_id WHERE arrest_detail.arr_date LIKE '".$yy_end."_".$mm_end."___'";
$_SQL_CURE = "SELECT COUNT(cure_id) AS ALL_CURE FROM cure_personal WHERE cure_date LIKE '".$yy_end."_".$mm_end."___' AND addr_province = ''";
}
else if($ccType == "Aumpur"){
$_SQL_SCHOOL = "SELECT COUNT(student_id) AS ALL_SCHOOL FROM blacklist_student WHERE sdate LIKE '".$yy_end."_".$mm_end."___' AND addr_amphur = ''";
$_SQL_INDUSTRY = "SELECT COUNT(blacklist_industry.employee_id) AS ALL_INDUSTRY FROM blacklist_industry INNER JOIN check_drug ON blacklist_industry.check_drug_id = check_drug.check_drug_id WHERE check_drug.check_date LIKE '".$yy_end."_".$mm_end."___' AND addr_amphur = ''";
$_SQL_PRISONER = "SELECT COUNT(arrest_prisoner.pri_id) AS ALL_PRISONER FROM arrest_prisoner INNER JOIN arrest_detail ON arrest_prisoner.arr_id = arrest_detail.arr_id WHERE arrest_detail.arr_date LIKE '".$yy_end."_".$mm_end."___' AND arr_amphur = ''";
$_SQL_CURE = "SELECT COUNT(cure_id) AS ALL_CURE FROM cure_personal WHERE cure_date LIKE '".$yy_end."_".$mm_end."___' AND addr_amphur = ''";
}
else if($ccType == "Tamboon"){
$_SQL_SCHOOL = "SELECT COUNT(student_id) AS ALL_SCHOOL FROM blacklist_student WHERE sdate LIKE '".$yy_end."_".$mm_end."___' AND addr_tambon = ''";
$_SQL_INDUSTRY = "SELECT COUNT(blacklist_industry.employee_id) AS ALL_INDUSTRY FROM blacklist_industry INNER JOIN check_drug ON blacklist_industry.check_drug_id = check_drug.check_drug_id WHERE check_drug.check_date LIKE '".$yy_end."_".$mm_end."___' AND addr_tambon = ''";
$_SQL_PRISONER = "SELECT COUNT(arrest_prisoner.pri_id) AS ALL_PRISONER FROM arrest_prisoner INNER JOIN arrest_detail ON arrest_prisoner.arr_id = arrest_detail.arr_id WHERE arrest_detail.arr_date LIKE '".$yy_end."_".$mm_end."___' AND arr_tamboon = ''";
$_SQL_CURE = "SELECT COUNT(cure_id) AS ALL_CURE FROM cure_personal WHERE cure_date LIKE '".$yy_end."_".$mm_end."___' AND addr_tambon = ''";
}
else if($ccType == "Village"){
$_SQL_SCHOOL = "SELECT COUNT(student_id) AS ALL_SCHOOL FROM blacklist_student WHERE sdate LIKE '".$yy_end."_".$mm_end."___' AND addr_moo = ''";
$_SQL_INDUSTRY = "SELECT COUNT(blacklist_industry.employee_id) AS ALL_INDUSTRY FROM blacklist_industry INNER JOIN check_drug ON blacklist_industry.check_drug_id = check_drug.check_drug_id WHERE check_drug.check_date LIKE '".$yy_end."_".$mm_end."___' AND addr_moo = ''";
$_SQL_PRISONER = "SELECT COUNT(arrest_prisoner.pri_id) AS ALL_PRISONER FROM arrest_prisoner INNER JOIN arrest_detail ON arrest_prisoner.arr_id = arrest_detail.arr_id WHERE arrest_detail.arr_date LIKE '".$yy_end."_".$mm_end."___' AND arr_village = ''";
$_SQL_CURE = "SELECT COUNT(cure_id) AS ALL_CURE FROM cure_personal WHERE cure_date LIKE '".$yy_end."_".$mm_end."___' AND addr_moo = ''";
}
$_resultSet_school = mysql_db_query($dbname,$_SQL_SCHOOL);
$resTable_x5 = mysql_fetch_assoc($_resultSet_school);
$_resultSet_industry = mysql_db_query($dbname,$_SQL_INDUSTRY);
$resTable_x6 = mysql_fetch_assoc($_resultSet_industry);
$_resultSet_prisoner = mysql_db_query($dbname,$_SQL_PRISONER);
$resTable_x7 = mysql_fetch_assoc($_resultSet_prisoner);
$_resultSet_cure = mysql_db_query($dbname,$_SQL_CURE);
$resTable_x8 = mysql_fetch_assoc($_resultSet_cure);
$totalALL_SCHOOL_2+=$resTable_x5['ALL_SCHOOL'];
$totalALL_INDUSTRY_2+=$resTable_x6['ALL_INDUSTRY'];
$totalALL_PRISONER_2+=$resTable_x7['ALL_PRISONER'];
$totalALL_CURE_2+=$resTable_x8['ALL_CURE'];
?>
<td align="right"><?=number_format($resTable_x5['ALL_SCHOOL'])?></td>
<td align="right"><?=number_format($resTable_x6['ALL_INDUSTRY'])?></td>
<td align="right"><?=number_format($resTable_x7['ALL_PRISONER'])?></td>
<td align="right"><?=number_format($resTable_x8['ALL_CURE'])?></td>
</tr>
<?php
}
?>
</tbody>
<tfoot>
<tr bgcolor="#DDDDDD">
<td colspan="2" align="right"><strong>รวม </strong></td>
<td align="right"><strong><?=number_format($totalALL_SCHOOL_1)?></strong></td>
<td align="right"><strong><?=number_format($totalALL_INDUSTRY_1)?></strong></td>
<td align="right"><strong><?=number_format($totalALL_PRISONER_1)?></strong></td>
<td align="right"><strong><?=number_format($totalALL_CURE_1)?></strong></td>
<?
//if($_GET['compair']){
?>
<td align="right"><strong><?=number_format($totalALL_SCHOOL_2)?></strong></td>
<td align="right"><strong><?=number_format($totalALL_INDUSTRY_2)?></strong></td>
<td align="right"><strong><?=number_format($totalALL_PRISONER_2)?></strong></td>
<td align="right"><strong><?=number_format($totalALL_CURE_2)?></strong></td>
</tr>
</tfoot>
</table>
<script type="text/javascript">
<!--
var TSort_Data = new Array ('my_table1', '', 'h','g','g','g','g','g','g','g','g','g','g','g','g','g','g','g','g','g','g','g','g');
var TSort_Classes = new Array ('row1', 'row2');
tsRegister();
// -->
</script>
<br>
</body>
</html>