|
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/pathumthani_drug/ |
Upload File : |
<?php
require_once("common/config.joomla.php");
$_SQL = "SELECT * FROM drug_level";
$_QUERY = mysql_query($_SQL);
$_SQL_all = "SELECT COUNT(student_id) AS c_all FROM blacklist_student WHERE drug_level != NULL or drug_level != 0";
$_QUERY_all = mysql_query($_SQL_all);
$_result_all = mysql_fetch_assoc($_QUERY_all);
while($_result = mysql_fetch_assoc($_QUERY)){
$_SQL_level = "SELECT COUNT(student_id) AS C FROM blacklist_student WHERE drug_level = '".$_result["drug_level_id"]."'";
$_QUERY_level = mysql_query($_SQL_level);
$_result_level = mysql_fetch_assoc($_QUERY_level);
$_per = ($_result_level["C"]*100)/$_result_all["c_all"];
$_category_name .= $_result["drug_level_name"].";";
$_result_sum += $_result_level["C"];
$_result_sum_per += $_per;
$data1 .= $_per.";";
}
$_category_name = substr($_category_name,0,-1);
$data1 = substr($data1,0,-1);
$catagory = $_category_name;
$title = "กราฟแสดงจำนวนผลรวมการแพร่กระจายยาเสพติดแบ่งตามระดับความรุนแรง";
$title = iconv("TIS-620","UTF-8",$title);
?>
<table border="0" cellpadding="0" cellspacing="0" width="400" bgcolor="#000D70" align="center">
<tr><td>
<?
//$columntitle='กราฟแสดงจำนวนผลรวมการแพร่กระจายยาเสพติดแบ่งตามระดับความรุนแรง';
//echo $catagory;
$graph_path = "http://202.129.35.106/graphservice/graphservice.php"; //Sapphire Graph
$w1=400;
$h1=200;
$xgraphurl = $graph_path ."?category=".$catagory.""."&data1=".$data1."&outputstyle=&numseries=1&seriesname=&graphtype=pie&title=".$title."&xname=&yname=&subtitle=&graphstyle=srd_allvisible_lg.scs";
$xgraphurl_link = $graph_path ."?category=".$catagory.""."&data1=".$data1."&outputstyle=&numseries=1&seriesname=&graphtype=pie&title=".$title."&xname=&yname=&subtitle=&graphstyle=srd_allvisible_lg.scs&xcontrol=1";//srd_sf_004
?>
<table width="100%" border="0">
<tr>
<td> </td>
<td align="right"><a href="<?=$xgraphurl_link?>" 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="<?=$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>