|
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/drug/ |
Upload File : |
<?
include("connect.php");
$graph_url = "202.129.35.106";
if($Submit==""){
$Dstart="01";
$Mstart=date("m")-1;
$Ystart=date("Y");
$Dend=date("d");
$Mend=date("m");
$Yend=date("Y");
$yys = "2009";
$yye = "2010";
}
//print_r($_POST);
if($_POST['Submit']==""){
$Submit="submit";
$yys = date("Y")-1;
$yye = date("Y");
$startdate = $yys;
$enddate = $yye;
$day1 = $yys+543;
$day2 = $yye+543;
$typeshow="selectyear";
}
$arrdate = array();
$arrdate['01'] = "ม.ค.";
$arrdate['02'] = "ก.พ..";
$arrdate['03'] = "มี.ค.";
$arrdate['04'] = "เม.ย.";
$arrdate['05'] = "พ.ค.";
$arrdate['06'] = "มิ.ย.";
$arrdate['07'] = "ก.ค.";
$arrdate['08'] = "ส.ค.";
$arrdate['09'] = "ก.ย.";
$arrdate['10'] = "ต.ค.";
$arrdate['11'] = "พ.ย.";
$arrdate['12'] = "ธ.ค.";
if($Submit!=""){
if($typeshow=="selectmonth"){
$startdate = $Ystart.'-'.$Mstart;
$enddate = $Yend.'-'.$Mend;
$day1= $arrdate[$Mstart].' '.($Ystart+543);
$day2= $arrdate[$Mend].' '.($Yend+543);
}else{
$startdate = $yys;
$enddate = $yye;
$day1 = $yys+543;
$day2 = $yye+543;
}
$get = mysql_query("SELECT * FROM drug_type ORDER BY drug_name ASC");
$i=0;
while ( $row = mysql_fetch_array($get) ){
$num1 = mysql_num_rows(mysql_query("SELECT * FROM arrest_detail WHERE arr_date LIKE '$startdate%' AND drug_id='$row[drug_id]' "));
$num2 = mysql_num_rows(mysql_query("SELECT * FROM arrest_detail WHERE arr_date LIKE '$enddate%' AND drug_id='$row[drug_id]' "));
if($num1>0 or $num2>0){
$i++;
if($i>1){
$category .= ';'.$row['drug_name'].'';
$data1 .= ';'.$num1.'';
$data2 .= ';'.$num2.'';
}else{
$category .= $row['drug_name'].'';
$data1 .= $num1.'';
$data2 .= $num2.'';
}
}
}
}
?>
<!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=windows-874" />
<title>Untitled Document</title>
<link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>
<p> </p>
<table width="95%" border="0" align="center">
<tr>
<td width="*" valign="bottom">
<form id="form1" name="form1" method="post" action="">
<table width="100%" border="0" cellpadding="1" cellspacing="1" bgcolor="#999999">
<tr>
<td background="../images/head2.png"><strong>เลือกช่วงเวลาการเปรียบเทียบ</strong></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><table width="100%" border="0" align="center" cellpadding="2" cellspacing="2">
<tr>
<td width="5%" height="40" align="center" valign="top"><input name="typeshow" type="radio" value="selectmonth" <? if($typeshow!="selectyear"){ echo "checked"; } ?>/></td>
<td width="25%" valign="top"><strong>รายเดือน</strong></td>
<td width="70%" valign="top"><font color="#333333">
<select name="Mstart" id="select2" >
<option value="00" >เดือน</option>
<?
$Month = array("", "ม.ค.", "ก.พ.", "มี.ค.", "เม.ย.", "พ.ค.", "มิ.ย.", "ก.ค.", "ส.ค.", "ก.ย.", "ต.ค.", "พ.ย.", "ธ.ค.");
for ( $intA = 1; $intA <=12; $intA++ ) {
?>
<option value="<?=sprintf("%02d", $intA)?>" <?php if($Mstart==sprintf("%02d", $intA))echo "selected";?>>
<?=$Month[$intA]?>
</option>
<?
}
?>
</select>
<select name="Ystart" id="select3" >
<option value="00" >ปี</option>
<?
$ThisYear = date("Y");
for ( $intA = $ThisYear; $intA >= $ThisYear - 100; $intA-- ) {
?>
<option value="<?=$intA?>" <?php if($Ystart==$intA)echo "selected"; ?>>
<?=$intA+543?>
</option>
<?
}
?>
</select>
<strong>และ</strong>
<select name="Mend" id="select5" >
<option value="00" >เดือน</option>
<?
$Month = array("", "ม.ค.", "ก.พ.", "มี.ค.", "เม.ย.", "พ.ค.", "มิ.ย.", "ก.ค.", "ส.ค.", "ก.ย.", "ต.ค.", "พ.ย.", "ธ.ค.");
for ( $intA = 1; $intA <=12; $intA++ ) {
?>
<option value="<?=sprintf("%02d", $intA)?>" <?php if($Mend==sprintf("%02d", $intA))echo "selected";?>>
<?=$Month[$intA]?>
</option>
<?
}
?>
</select>
<select name="Yend" id="select6" >
<option value="00" >ปี</option>
<?
$ThisYear = date("Y");
for ( $intA = $ThisYear; $intA >= $ThisYear - 100; $intA-- ) {
?>
<option value="<?=$intA?>" <?php if($Yend==$intA)echo "selected"; ?>>
<?=$intA+543?>
</option>
<?
}
?>
</select>
</font></td>
</tr>
<tr>
<td height="36" align="center" valign="top"><input type="radio" value="selectyear" name="typeshow" <? if($typeshow=="selectyear"){ echo "checked"; } ?>/></td>
<td valign="top"><strong>รายปี</strong></td>
<td valign="top"><font color="#333333">
<select name="yys" id="Ystart" >
<option value="00" >ปี</option>
<?
$ThisYear = date("Y");
for ( $intA = $ThisYear; $intA >= $ThisYear - 100; $intA-- ) {
?>
<option value="<?=$intA?>" <?php if($yys==$intA)echo "selected"; ?>>
<?=$intA+543?>
</option>
<?
}
?>
</select>
</font><strong>และ</strong><font color="#333333">
<select name="yye" id="Yend" >
<option value="00" >ปี</option>
<?
$ThisYear = date("Y");
for ( $intA = $ThisYear; $intA >= $ThisYear - 100; $intA-- ) {
?>
<option value="<?=$intA?>" <?php if($yye==$intA)echo "selected"; ?>>
<?=$intA+543?>
</option>
<?
}
?>
</select>
</font></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><input type="submit" name="Submit" value="เปรียบเทียบ" /></td>
</tr>
</table></td>
</tr>
</table>
</form>
</td>
<td width="400" align="center">
<?
if($Submit!=""){
?>
<table border="0" cellpadding="0" cellspacing="0" width="400" bgcolor="#000D70">
<tr><td>
<table width="100%" border="0">
<tr>
<td class="whitetext" align="left">กราฟแสดงการเปรียบเทียบจุดจับกุม ตามประเภทยาเสพติด</td>
<td align="right"><a href="http://<?=$graph_url?>/graphservice/graphservice.php?category=<?=$category?>&data1=<?=$data1?>&data2=<?=$data2?>&outputstyle=&numseries=2&seriesname=<?=$day1?>;<?=$day2?>&graphtype=line&title=กราฟแสดงการเปรียบเทียบจุดจับกุม ตามประเภทยาเสพติด&xname=&yname=&subtitle=&graphstyle=srd_allvisible_lg.scs" target="_blank"><img src="../images/maximize.gif" align="absmiddle" border="0" /></a></td>
</tr>
</table>
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="400" height="196">
<param name="movie" value="http://<?=$graph_url?>/graphservice/graphservice.php?category=<?=$category?>&data1=<?=$data1?>&data2=<?=$data2?>&outputstyle=&numseries=2&seriesname=<?=$day1?>;<?=$day2?>&graphtype=line&title=&xname=&yname=&subtitle=&graphstyle=srd_allvisible_lg.scs">
<param name="quality" value="high">
<param name="wmode" value="transparent">
<embed src="http://<?=$graph_url?>/graphservice/graphservice.php?category=<?=$category?>&data1=<?=$data1?>&data2=<?=$data2?>&outputstyle=&numseries=2&seriesname=<?=$day1?>;<?=$day2?>&graphtype=line&title=&xname=&yname=&subtitle=&graphstyle=srd_allvisible_lg.scs" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" wmode="transparent" width="400" height="196">
</object>
</td>
</tr>
</table>
<?
}
?>
</td>
</tr>
<?
if($Submit!=""){
?>
<tr>
<td colspan="2"><p> </p>
<table width="100%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#666666">
<tr >
<td width="5%" rowspan="2" align="center" background="../images/head2.png"><strong>ลำดับ</strong></td>
<td width="49%" rowspan="2" align="center" background="../images/head2.png"><span class="indexbold">ประเภท</span></td>
<td colspan="3" align="center" background="../images/head2.png"><span class="indexbold">รายการเปรียบเทียบ (ราย)</span></td>
</tr>
<tr >
<td width="16%" align="center" background="../images/head2.png"><span class="indexbold">
<?=$day1?>
</span></td>
<td width="19%" align="center"background="../images/head2.png"><span class="indexbold">
<?=$day2?>
</span></td>
<td width="11%" align="center"background="../images/head2.png"><strong>ผลการเปรียบเทียบ</strong></td>
</tr>
<?
$get = mysql_query("SELECT * FROM drug_type ORDER BY drug_name ASC");
$h=0;
while ( $row = mysql_fetch_array($get) ){
if($bg=="CCCCCC"){ $bg="FFFFFF"; }else{ $bg="CCCCCC"; }
$h++;
?>
<tr>
<td bgcolor="#<?=$bg?>" align="center"><?=$h?></td>
<td bgcolor="#<?=$bg?>"><?=$row['drug_name']?></td>
<td align="right" bgcolor="#<?=$bg?>">
<?
$num1 = mysql_num_rows(mysql_query("SELECT * FROM arrest_detail WHERE arr_date LIKE '$startdate%' AND drug_id='$row[drug_id]' "));
$num1_total = $num1_total + $num1;
echo number_format($num1);
?>
</td>
<td align="right" bgcolor="#<?=$bg?>"><?
$num2 = mysql_num_rows(mysql_query("SELECT * FROM arrest_detail WHERE arr_date LIKE '$enddate%' AND drug_id='$row[drug_id]' "));
$num2_total = $num2_total + $num2;
echo number_format($num2);
?></td>
<td align="right" bgcolor="#<?=$bg?>">
<?
if($num1>$num2){ echo"<img src='watchlist_down.gif' title='ลดลง'>"; }
else if($num1==$num2){ echo ""; }
else{ echo "<img src='watchlist_up.gif' title='เพิ่มขึ้น'>"; }
?>
</td>
</tr>
<?
}
?>
<tr>
<td bgcolor="#FFFFFF" align="center"> </td>
<td bgcolor="#FFFFFF" align="center"><strong>ผลการเปรียบเทียบ <strong>ระหว่าง <?=$day1?> กับ <?=$day2?> </strong></strong></td>
<td align="right" bgcolor="#FFFFFF">
<?=$num1_total?>
</td>
<td align="right" bgcolor="#FFFFFF"><?=$num2_total?></td>
<td align="right" bgcolor="#FFFFFF"><? if($num1_total>$num2_total){ echo"<img src='watchlist_down.gif' title='ลดลง'>"; }else if($num1_total==$num2_total){ echo "<font color=gray>เท่าเดิม</font>"; }else{ echo "<img src='watchlist_up.gif' title='เพิ่มขึ้น'>"; }?></td>
</tr>
</table>
<p> </p></td>
</tr>
<?
}
?>
</table>
<p> </p>
</body>
</html>