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_a3.php
<?
#			session_start();
//			error_reporting(0);
include ("../../../config/conndb_obec.inc.php")  ;
include ("graph.inc.php")  ;
include ("./function.php")  ;

$year = ( isset($_POST['year'] ))?$_POST['year']:date("Y");
$year_th = $year + 543;
if ( $year == "all" ) $year_th = "ทุกปี";

$sql = "
SELECT
Count(ticket_id)  as count_ticket,
month(callcenter.date_create) as mm,
year(callcenter.date_create) as yy
FROM
callcenter
%s 
GROUP BY
mm ,
yy
ORDER BY mm ASC
";

if ( $year == "all" ) {
    $sql = sprintf($sql, "");
} else {
    $sql = sprintf($sql, " WHERE year(callcenter.date_create)='".$year."' ");
}
$res = mysql_query($sql);
while($o = mysql_fetch_array($res)){
    $arr[abs($o['mm'])][0] = $o['count_ticket'];
    $arr[abs($o['mm'])][1] = $o['mm'];
    $arr[abs($o['mm'])][2] = $o['yy'];
    $arr[abs($o['mm'])][3] = get_time($o['mm'], $o['yy']);
    $arr[abs($o['mm'])][4] = get_time_avg_minute($arr[abs($o['mm'])][3]); # เวลาเฉลี่ยเป็นนาที
    $arr[abs($o['mm'])][5] = get_time_avg($arr[abs($o['mm'])][3]); # เวลาเฉลี่ยเป็นนาที

    
}



function get_time($month, $year){
    global $myconnect;
    $sql = "
    SELECT
    callcenter.date_create,
    callcenter.date_rec,
    callcenter.chk_confirm
    FROM
    callcenter
    WHERE 
    callcenter.chk_confirm != '0' AND 
    year(callcenter.date_create) =  '".$year."' AND
    month(callcenter.date_create) = '".sprintf("%02d", $month)."' 
    ";

    $res = mysql_query($sql);
    $sec = 0;
    while($o=mysql_fetch_object($res)){
        $diff_time = diff_time($o->date_create, $o->date_rec);
        $sec += $diff_time['total_sec'];
    }
    return $sec;
}

function get_time_avg($total_sec){
    if($total_sec == 0 ) return 0;
    $day = intval($total_sec / 86400); 
    $remain_sec = $total_sec % 86400;

    $hour = intval($remain_sec / 3600);
    $remain_sec = $remain_sec % 3600;

    $minute = intval($remain_sec / 60);
    $remain_sec = $remain_sec % 60;

    if($day != 0) $time .= $day." วัน ";
    $time .= sprintf("%02d", $hour).":";
    $time .= sprintf("%02d", $minute).":";
    $time .= sprintf("%02d", $remain_sec);
    return $time;
}

function get_time_avg_minute($total_sec){
    if($total_sec <= 0 ) return 0;
    $minute = $total_sec / 60;
    return $minute;
}

?>
<HTML>
<HEAD>
<TITLE>รายงานแสดงสถิติเวลาในการรับปัญหาเป็นรายเดือน ประจำปี <?=$year_th;?></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;
if ( count($arr) != 0 ) {
    foreach($arr as $key){
        if ($k > 0) {
            $datalist .= ";";
            $grouplist .= ";";
        }
        $datalist .= $key[0];
        $grouplist .= getMonthTh($key[1]);

        $k++;
    }
}
$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">รายงานแสดงสถิติเวลาในการรับปัญหาเป็นรายเดือน ประจำปี <?=$year_th;?></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>
              <br>
              <?

$datalist = $grouplist = "";
$k=0;
if ( count($arr) != 0 ) {
    foreach($arr as $key){
        if ($k > 0) {
            $datalist .= ";";
            $grouplist .= ";";
        }
        $datalist .= $key[3];
        $grouplist .= getMonthTh($key[1]);

        $k++;
    }
}

$xname = "เวลาเฉลี่ย (วินาที)";
$yname = "เดือน";

$graphurl = $graph_path . "?category=$grouplist&data1=$datalist&outputstyle=&numseries=1&seriesname=&graphtype=bar&graphstyle=srd_sf_012&xname=$xname&yname=$yname";

?>
              <br>
              <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>ประจำปี 
                    <select id="select" name="year" class="gray">
                      <option>- - - เลือกปี - - -</option>
                      <option value="all"<?php echo ($year=="all")?' selected':'';?>>ทุกปี</option>
<?php
for($y=2007;$y<=2100;$y++){
    $y_th = $y + 543;
    $slt = ($y==$year)?' selected':'';
    echo "<option value=\"".$y."\"".$slt.">".$y_th."</option>";
}
?>
                    </select>
                    <input type="button" name="Button" value="แสดงรายงาน" onClick="return chkField();">
<script language="JavaScript">
function chkField(){
    if (document.form1.year.value==""){
        document.form1.year.focus();
        alert("กรุณาเลือกปี พ.ศ.");
        return false;
    } else {
        document.form1.action = "<?=$PHP_SELF;?>";
        document.form1.submit();
    }
}
</script>
                  </td>
                </tr>
              </table>
              <table width="524" bgcolor="#aaaaaa" cellspacing=1 cellpadding=2>
                <tr bgcolor="#6666FF"> 
                  <th width="41" class="report_graph_tb_head">ลำดับ</th>
                  <th width="165" bgcolor="#aaaaaa" class="report_graph_tb_head">เดือน</th>
                  <th width="82" bgcolor="#aaaaaa" class="report_graph_tb_head">จำนวนปัญหา</th>
                  <th width="127" bgcolor="#aaaaaa" class="report_graph_tb_head">ระยะเวลาเฉลี่ย</th>
                  <th width="81" bgcolor="#aaaaaa" class="report_graph_tb_head">ระยะเวลาเฉลี่ย 
                    (วินาที)</th>
                </tr>
                <?php
for($i=1;$i<=12;$i++){
    $bg_color = ($num%2)?'#F1F1F1':'FFFFFF';$num++;
    $total_problem += $arr[$i][0];
    $total_avg += $arr[$i][3];
?>
                <tr bgcolor="<?=$bg_color;?>"> 
                  <td align=center valign="top" width="41"> 
                    <?=$num;?>
                  </td>
                  <td align=left valign="top" width="165"> 
                    <?=getMonthTH($i);?>
                  </td>
                  <td align=right valign="top" width="82"> 
                    <?=number_format($arr[$i][0]);?>
                    &nbsp;&nbsp;</td>
                  <td align=right valign="top" width="127"> 
                    <?=$arr[$i][5];?>
                    <?php echo ($arr[$i][5]!="")?"":"0";?> นาที&nbsp;&nbsp;</td>
                  <td align=right valign="top" width="81"> 
                    <?=number_format($arr[$i][3]);?>
                    &nbsp;&nbsp;</td>
                </tr>
                <?php
} # end for

?>
                <tr bgcolor="#EEEEEE"> 
                  <td align=center valign="top" width="41">&nbsp;</td>
                  <td align=left valign="top" width="165"><strong>รวม</strong></td>
                  <td align=right valign="top" width="82"><strong> 
                    <?=number_format($total_problem);?>
                    &nbsp;</strong></td>
                  <td align=right valign="top" width="127"><?=get_time_avg($total_avg);?> นาที&nbsp;</td>
                  <td align=right valign="top" width="81"><strong> 
                    <?=number_format($total_avg);?>
                    &nbsp;</strong></td>
                </tr>
              </table>
            </td>
      </tr>
    </table></td>
  </tr>
</table>
<BR>
</form>
</BODY>
</HTML>

Anon7 - 2021