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

if ( $_POST['date_start'] != "" ){
    $date_start = $_POST['date_start'];
    $date_to = $_POST['date_to'];
    $sql_date_start = convert_date($date_start, false);
    $sql_date_to = convert_date($date_to, false);
} else {
    $sql = "SELECT `date_rec`  FROM `callcenter` WHERE `date_rec`!='0000-00-00 00:00:00' ORDER BY `date_rec` ASC LIMIT 0,1";
    $res = mysql_query($sql);
    $obj = mysql_fetch_object($res);
    $sql_date_start = split_datetime($obj->date_rec);
    $sql_date_to = date("Y-m-d");
    $date_start = set_date(convert_date($sql_date_start,true),"/");
    $date_to = set_date(convert_date($sql_date_to,true),"/");
    
}



$sql = "
SELECT
problem_type.id,
problem_type.typename,
Count(callcenter_ptype.ticketid)
FROM
callcenter
Left Join callcenter_ptype ON callcenter.ticket_id = callcenter_ptype.ticketid
Left Join problem_type ON callcenter_ptype.typeid = problem_type.id
WHERE
callcenter.chk_confirm =  '1' AND
problem_type.typename <>  'Null' AND 
callcenter.date_rec BETWEEN '$sql_date_start' AND '$sql_date_to' 
GROUP BY
callcenter_ptype.typeid,
problem_type.id,
problem_type.typename 
ORDER BY Count(callcenter_ptype.ticketid) DESC
";

$res = mysql_query($sql);
while($o = mysql_fetch_array($res)){
    $arr[count($arr)+1][0] = $o['typename'];
    $arr[count($arr)][1] = $o[2];
    $arr[count($arr)][2] = $o['id'];
};

#print_r($arr);

?>
<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>5) { 
        $val1 += $arr[$i][1];
    } else {
        $datalist .= $arr[$i][1].";";
        $grouplist .= $arr[$i][0].";";
    }
}

$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="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td>
                    <input onFocus="blur();" readOnly name="date_start" value="<?=$date_start ?>" size="8">
                  <input class="index2"style="FONT-SIZE: 11px; WIDTH: 80px" onClick="popUpCalendar(this, form.date_start, 'dd/mm/yyyy')" type="button"value="วัน เดือน ปี" name="button">
                    ถึงวันที่ 
                    <input onFocus="blur();" readOnly name="date_to" value="<?=$date_to ?>" size="8">
                    <input class="index2"style="FONT-SIZE: 11px; WIDTH: 80px" onClick="popUpCalendar(this, form.date_to, 'dd/mm/yyyy')" type="button"value="วัน เดือน ปี" name="button2">
                    <input type="button" name="Button" value="แสดงรายงาน" onClick="return genReport();" class"index2" style="FONT-SIZE: 11px; WIDTH: 80px">
<script language="JavaScript">
function genReport(){
    document.form1.action = "<?=$PHP_SELF;?>";
    document.form1.submit();
}
</script>
                  </td>
              </tr>
            </table>
              <br>
              <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][1];
    if($num<=5){
?>
          <tr bgcolor="<?=$bg_color;?>">
            <td align=center valign="top"><?=$num;?></td>
            <td align=left valign="top"><a href="report_graph_a5.php?s=<?=$arr[$i][2];?>&date_start=<?=$date_start;?>&date_to=<?=$date_to;?>"><?=$arr[$i][0];?></td>
            <td align=right valign="top"><?=number_format($arr[$i][1]);?></a>&nbsp;&nbsp;
            </td>
          </tr>
<?php
    } else {
        $num--;
        $sum += $arr[$i][1];
    }
} # 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