|
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 : |
<?
# session_start();
// error_reporting(0);
include ("../../../config/conndb_obec.inc.php") ;
include ("graph.inc.php") ;
$monthname = array("",
"มกราคม",
"กุมภาพันธ์",
"มีนาคม",
"เมษายน",
"พฤษภาคม",
"มิถุนายน",
"กรกฎาคม",
"สิงหาคม",
"กันยายน",
"ตุลาคม",
"พฤษจิกายน",
"ธันวาคม");
if (!isset($yy)) $yy = 2550;
$n = 0;
$total = array();
$data = array();
//$data["อื่นๆ"] = 0;
//$sql="select t1.name as name,count(*) as ncount from call_datagroup t1 right join callcenter t2 on t1.gid=t2.pgroup where t2.prov_id = '$pvid' group by t1.name order by ncount desc;";
$sql = "select count(*) as ncount,plevel as name,month(date_rec) as mm from callcenter where year(date_rec) = '$yy' group by mm,plevel ;";
$result = mysql_query($sql);
while ($rs=mysql_fetch_assoc($result)){
$data[$rs[mm]][$rs[name]] = $rs[ncount];
$n++;
$total[$rs[mm]] += $rs[ncount];
}
?>
<HTML>
<HEAD>
<TITLE>รายงานสถิติของปัญหาตามระดับความยากง่าย</TITLE>
<META content="text/html; charset=windows-874" http-equiv=Content-Type>
<LINK href="../style.css" rel=stylesheet type="text/css">
<script src="../../../common/javaopenwin.js" type="text/javascript" language="javascript"> </script>
<head>
<BODY>
<?
$grouplist = "";
$k=0;
foreach ($data as $grp => $pdata){
if ($k > 0) {
$datalist_400 .= ";";
$datalist_300 .= ";";
$datalist_200 .= ";";
$datalist_100 .= ";";
$datalist_1 .= ";";
$grouplist .= ";";
}
$datalist_400 .= $pdata["400"];
$datalist_300 .= $pdata["300"];
$datalist_200 .= $pdata["200"];
$datalist_100 .= $pdata["100"];
$datalist_1 .= $pdata["1"];
$grouplist .= $monthname[intval($grp)];
$k++;
}
$graphurl = $graph_path . "?category=$grouplist&data1=$datalist_400&data2=$datalist_300&data3=$datalist_200&data4=$datalist_100&data5=$datalist_1&outputstyle=&numseries=5&seriesname=P4;P3;P2;P1;P0&graphtype=line&graphstyle=srd_sf_014";
?>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td class="fill_bg_add_new2" style="padding-top:15px"><table width="100%" border="0">
<tr valign="top">
<td colspan="2" class="report_graph_header">รายงานสถิติของปัญหาตามระดับความยากง่าย</td>
</tr>
<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 />
<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>
</CENTER>
</td>
<td>ข้อมูลสำหรับปี พ.ศ.
<select name="yy" onChange="location.href='?yy='+this.value;">
<?
$xresult = mysql_query("select distinct year(date_rec) as yy from callcenter;");
while ($xrs = mysql_fetch_assoc($xresult)){
if ($xrs[yy] == $yy) $sel="SELECTED"; else $sel="";
echo "<option value='$xrs[yy]' $sel>$xrs[yy]";
}
?>
</select>
<table width="450" bgcolor="#aaaaaa" cellspacing=1 cellpadding=2>
<tr bgcolor="#6666FF">
<th rowspan=2 class="report_graph_tb_head">ลำดับ</th>
<th rowspan=2 class="report_graph_tb_head">เดือน</th>
<th colspan=6 class="report_graph_tb_head">จำนวนปัญหา</th>
</tr>
<tr bgcolor="#6666FF">
<th class="report_graph_tb_head">P4</th>
<th class="report_graph_tb_head">P3</th>
<th class="report_graph_tb_head">P2</th>
<th class="report_graph_tb_head">P1</th>
<th class="report_graph_tb_head">P0</th>
<th class="report_graph_tb_head">รวม</th>
</tr>
<?
$k=0; $xtotal = $total400 = $total200 = $total200=$total100 = $total1 = 0;
foreach ($data as $mm => $pdata){
if ($k++ % 2) $bg="#EFEFEF"; else $bg="#FFFFFF";
$xtotal += $total[$mm];
$total400 += $pdata["400"];
$total300 += $pdata["300"];
$total200 += $pdata["200"];
$total100 += $pdata["100"];
$total1 += $pdata["1"];
?>
<tr bgcolor="<?=$bg?>">
<td align=center><?=$k?></td>
<td align=left>เดือน
<?=$monthname[intval($mm)]?></td>
<td align=right><?=number_format($pdata["400"])?>
</td>
<td align=right><?=number_format($pdata["300"])?>
</td>
<td align=right><?=number_format($pdata["200"])?>
</td>
<td align=right><?=number_format($pdata["100"])?>
</td>
<td align=right><?=number_format($pdata["1"])?>
</td>
<td align=right><?=number_format($total[$mm])?>
</td>
</tr>
<?
}//foreach
?>
<tr bgcolor="<?=$bg?>">
<td align=center> </td>
<td align=left><strong>รวม</strong></td>
<td align=right><strong>
<?=number_format($total400)?>
</strong></td>
<td align=right><strong>
<?=number_format($total300)?>
</strong></td>
<td align=right><strong>
<?=number_format($total200)?>
</strong></td>
<td align=right><strong>
<?=number_format($total100)?>
</strong></td>
<td align=right><strong>
<?=number_format($total1)?>
</strong></td>
<td align=right><strong>
<?=number_format($xtotal)?>
</strong></td>
</tr>
</table>
<br>
<table width="309" bgcolor="#AAAAAA" cellspacing=1 cellpadding=2>
<tr bgcolor="<?=$bg?>">
<td width="299" align=left bgcolor="#FFFFFF">P4: ให้คำแนะนำทางโทรศัพท์ </td>
</tr>
<tr bgcolor="<?=$bg?>">
<td align=left bgcolor="#EFEFEF">P3 : ปรับเปลี่ยนข้อความในหน้ารายงาน </td>
</tr>
<tr bgcolor="<?=$bg?>">
<td align=left bgcolor="#FFFFFF">P2 : ปรับเปลี่ยนเพิ่มช่องตารางในหน้ารายงาน </td>
</tr>
<tr bgcolor="<?=$bg?>">
<td align=left bgcolor="#EFEFEF">P1 : เพิ่มแบบฟอร์มใหม่ </td>
</tr>
<tr bgcolor="<?=$bg?>">
<td align=left bgcolor="#FFFFFF">P0 : ปัญหาเชิงนโยบาย </td>
</tr>
</table>
<p> </p></td>
</tr>
</table></td>
</tr>
</table>
<BR>
</BODY>
</HTML>