|
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_vc/report/report/ |
Upload File : |
<?
include("../../inc/config_pop.inc.php");
include("../../inc/std_function.inc.php");
function debug_sql($sql){
if ($_GET[debug] == "ON") echo "$sql<BR>";
}
?>
<HTML><HEAD><TITLE>ประชากร</TITLE>
<META http-equiv=Content-Type content="text/html; charset=windows-874">
<LINK href="/favicon.ico" type=image/x-icon rel="shortcut icon">
<LINK href="../../common/style.css" rel=stylesheet>
<script src="../../common/functions.js" type="text/javascript" language="javascript"></script>
</HEAD>
<BODY bgcolor="#A3B2CC" >
<table width="91%" border="0" cellpadding="0" cellspacing="0" >
<tr>
<td valign="top" bgcolor="#A3B2CC">
<?
// include ("../../config/conndb.inc.php") ;
// include ("../../common/std_function.inc.php") ;
///==========================================================================================
$previous_url = " <div align=right> ";
$next_url = " <div align=left> ";
$sql = " SELECT Max(ccDate) AS maxYY, Min(ccDate) AS minYY FROM 4612cc63 " ;
$query_result = mysql_db_query($dbname,$sql) ;
$result = mysql_fetch_array($query_result) ;
$maxYY1 = $result[maxYY] ; $minYY1 = $result[minYY] ;
if ($year1 == "" ) { $year1 = $maxYY1 ; }
$yy_1 = $year1;
if ($maxYY1 > $year1 ){
$next_year =$year1 + 1 ; $previous_year = $year1 - 1 ;
$next_url = "<a href='?year1=" . $next_year ."&ageselect=$ageselect&agemin=$agemin&agemax=$agemax'><img src=\"../images_sys/next.jpg\" width=\"20\" height=\"20\" border=\"0\"></a> ";
}
if ($minYY1 < $year1 ){
$previous_year = $year1 - 1 ; $next_year =$year1 + 1 ;
$previous_url = "<a href='?year1=" . $previous_year ."&ageselect=$ageselect&agemin=$agemin&agemax=$agemax'><img src=\"../images_sys/back.jpg\" width=\"20\" height=\"20\" border=\"0\"> </a> ";
}
?>
<BR>
<?
//ageselect=1&agemin=%3C100&agemax=%3E100&agestep=10
if ($ageselect){
$m_fld = "0";
$f_fld = "0";
if (substr($agemin,0,2) == "<1"){
$agemin = 0;
}
if ($agemax == ">100"){
$agemax = 101;
}
for ($i=$agemin+1;$i<=$agemax+1;$i++){
$m_fld .= "+MALE_AGE$i";
$f_fld .= "+FEMALE_AGE$i";
}
$text1 = "ประชากรอายุ $_GET[agemin] ปีถึงอายุ $_GET[agemax] ปี";
}else{
$m_fld = "0";
$f_fld = "0";
for ($i=1;$i<=102;$i++){
$m_fld .= "+MALE_AGE$i";
$f_fld .= "+FEMALE_AGE$i";
}
$text1 = "ประชากรอายุน้อยกว่่า 1 ปีถึงอายุมากกว่า 100 ปี";
// $text1 = "ประชากรรวมทั้งหมด";
}
?>
<B><?=$text1?></B> (<a href="#" onclick="window.open('ageform.php?target=province_age.php&year1=<?=$year1?>&ageselect=<?=$ageselect?>&agemin=<?=$agemin?>&agemax=<?=$agemax?>','ageform','width=500,height=200');">เลือกช่วงอายุ</a>)<BR><BR>
<table border=0 width="789">
<tr valign=top><td>
<table width="400" border="0" cellpadding="2" cellspacing="1" >
<tr>
<td width=100> </td>
<td width=200><B>จำนวนประชากรชาย</B></td>
<td width=100 align=right bgcolor="#BBBBDD"><div id="div_male"></div></td>
<td><B>คน</B></td>
</tr>
<tr>
<td width=100> </td>
<td width=200><B>จำนวนประชากรหญิง</B></td>
<td width=100 align=right bgcolor="#BBBBDD"><div id="div_female"></div></td>
<td><B>คน</B></td>
</tr>
<tr>
<td width=100> </td>
<td width=200><B>จำนวนประชากรรวม</B></td>
<td width=100 align=right bgcolor="#BBBBDD"><div id="div_total"></div></td>
<td><B>คน</B></td>
</tr>
</table>
</td><td align=right>
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="189" height="120">
<param name="movie" value="logo.swf">
<param name="quality" value="high">
<embed src="logo.swf" width="189" height="120" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash"></embed>
</object>
</td></tr></table>
<BR><BR>
<table width="789" border="1" cellpadding="1" cellspacing="0" bordercolor="#000000" bgcolor="#FFFFFF">
<tr bgcolor="#A3B2CC">
<td width="46" rowspan="3" align="center" bgcolor="#A3B2CC" class="link_back">ลำดับ</td>
<td width="216" rowspan="3" align="center" bgcolor="#A3B2CC" class="link_back">จังหวัด</td>
<td height="18" colspan="3" align="center" bgcolor="#A3B2CC" class="style1"><table width="495" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="167"><?=$previous_url?></td>
<td width="229" align="center"><strong class="link_back">ปีพ.ศ.
<?=$year1?>
</strong></td>
<td width="99" align="right"><?=$next_url?></td>
</tr>
</table></td>
</tr>
<tr bgcolor="#A3B2CC">
<td height="20" colspan="3" align="center" bgcolor="#A3B2CC" class="link_back">จำนวนประชากร (คน)</td>
</tr>
<tr bgcolor="#A3B2CC">
<td width="125" height="20" align="center" bgcolor="#A3B2CC" class="link_back">ชาย</td>
<td width="125" align="center" bgcolor="#A3B2CC" class="link_back">หญิง</td>
<td width="125" align="center" bgcolor="#A3B2CC" class="link_back">รวม</td>
</tr>
<?
// if($sortname==""){ $Sortby="ASC"; $sortname="ampid";}
//จำนวนคน
$sql2 = "select ccDigi,DESC_CCAATT,($m_fld) as male,($f_fld) as female from 4612cc63 where substring(ccDigi,3,6) = '000000' and ccDate = '$year1' order by binary DESC_CCAATT ";
$query_result2 = mysql_db_query($dbname,$sql2);
//echo $sql2;
debug_sql($sql2);
// if($Sortby=="ASC"){ $Sortby="DESC"; } else{ $Sortby="ASC"; }
$i=1;
while ($result2=mysql_fetch_array($query_result2)){
// $str_a = " SELECT SUM(male_nm) AS total_male , SUM(fmale_nm) AS total_female , SUM(total_nm) AS total , SUM(fam_nm) AS total_fam FROM 4612cc63 WHERE tambon_fam_nm.yy = '$year1' AND tambon_fam_nm.tamid LIKE '$result2[ampid]%' ";
$subs = substr($result2[ccDigi],0,2) ;
$str_a = "select sum($m_fld) as male,sum($f_fld) as female from 4612cc63 where (ccDate = '$year1' ) and (ccDigi like '$subs%') and (substring(ccDigi,5,2) >= '30') ";
$query_a = mysql_db_query($dbname,$str_a) ;
$rs_a = mysql_fetch_array($query_a);
$m2 = $rs_a[male];
$f2 = $rs_a[female];
$t2 = $m2 + $f2;
debug_sql($str_a);
// $str_a = "select sum($m_fld) as male,sum($f_fld) as female from 4612cc63 where (ccDate = '$year1' ) and (ccDigi like '$subs%0000') and (ccDigi not like '%000000') ";
$str_a = "select sum($m_fld) as male,sum($f_fld) as female from 4612cc63 where (ccDate = '$year1' ) and (ccDigi like '$subs%') and (substring(ccDigi,5,2) > '00') and (substring(ccDigi,5,2) < '30')";
$query_a = mysql_db_query($dbname,$str_a) ;
$rs_a = mysql_fetch_array($query_a);
$m3 = $rs_a[male];
$f3 = $rs_a[female];
$t3 = $m3 + $f3;
debug_sql($str_a);
$m1 = $result2[male];
$f1 = $result2[female];
$t1 = $m1 + $f1;
/* $m2 = $m1 - $m3;
$f2 = $f1 - $f3;
$t2 = $m2 + $f2;
*/
$Summale+=$m1;
$Sumfmale+=$f1;
$Sumtotal+=$t1;
if ($bgcolor1 == "DDDDDD"){ $bgcolor1 = "EFEFEF" ; } else {$bgcolor1 = "DDDDDD" ;}
?>
<tr bgcolor="#<?=$bgcolor1?>">
<td align="center" bgcolor="#<?=$bgcolor1?>" class="link_back"><?=$i?></td>
<td height="20" bgcolor="#<?=$bgcolor1?>" class="link_back">
<a href='sector_age.php?pcode=<?=$subs?>&year1=<?=$year1?>&ageselect=<?=$ageselect?>&agemin=<?=$agemin?>&agemax=<?=$agemax?>'><?=$result2[DESC_CCAATT]?></a>
</td>
<td align="right" bgcolor="#<?=$bgcolor1?>" class="link_back"><? echo subval_2($m1);?> </td>
<td align="right" bgcolor="#<?=$bgcolor1?>" class="link_back"><? echo subval_2($f1);?> </td>
<td align="right" bgcolor="#<?=$bgcolor1?>" class="link_back"><? echo subval_2($t1);?> </td>
</tr>
<tr bgcolor="#<?=$bgcolor1?>">
<td align="center" bgcolor="#<?=$bgcolor1?>" class="link_back"> </td>
<td height="20" bgcolor="#<?=$bgcolor1?>" class="style1"> - ในเขตเทศบาล </td>
<td align="right" bgcolor="#<?=$bgcolor1?>"><? echo subval_2($m2);?> </td>
<td align="right" bgcolor="#<?=$bgcolor1?>"><? echo subval_2($f2);?> </td>
<td align="right" bgcolor="#<?=$bgcolor1?>"><? echo subval_2($t2);?> </td>
</tr>
<tr bgcolor="#<?=$bgcolor1?>">
<td align="center" bgcolor="#<?=$bgcolor1?>" class="link_back"> </td>
<td height="20" bgcolor="#<?=$bgcolor1?>" class="style1"> - นอกเขตเทศบาล </td>
<td align="right" bgcolor="#<?=$bgcolor1?>"><? echo subval_2($m3);?> </td>
<td align="right" bgcolor="#<?=$bgcolor1?>"><? echo subval_2($f3);?> </td>
<td align="right" bgcolor="#<?=$bgcolor1?>"><? echo subval_2($t3);?> </td>
</tr>
<?
$i++;
} // while
?>
<tr bgcolor="#A3B2CC">
<td align="right" bgcolor="#A3B2CC" class="link_back"> </td>
<td height="19" align="right" bgcolor="#A3B2CC" class="link_back">รวม</td>
<td align="right" bgcolor="#A3B2CC" class="link_back"><? echo subval_2($Summale);?> </td>
<td align="right" bgcolor="#A3B2CC" class="link_back"><? echo subval_2($Sumfmale);?> </td>
<td align="right" bgcolor="#A3B2CC" class="link_back"><? echo subval_2($Sumtotal);?> </td>
</tr>
</table>
<? //include ("../../common/footnote.inc.php")?></td>
</tr>
</table>
<SCRIPT LANGUAGE="JavaScript">
<!--
document.getElementById("div_male").innerHTML = "<B><?=subval_2($Summale)?></B>";
document.getElementById("div_female").innerHTML = "<B><?=subval_2($Sumfmale)?></B>";
document.getElementById("div_total").innerHTML = "<B><?=subval_2($Sumtotal)?></B>";
//-->
</SCRIPT>
<?include "footnote.php";?>
</BODY></HTML>