|
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_integration/requirement/application/ecomplain/ |
Upload File : |
<?
session_start();
include "../../config/config.inc.php";
include("function/function.php");
include ("graph.inc.php");
if(!isset($session_username)){
header("Location: ../document/login.php");
}
include("header_menu.php");
include ("report_repeatdly.inc.php");
//insert timeQuery
include("../../common/common_system.inc.php");
$ApplicationName="ecomplain";
$time_start = getmicrotime();
//insert timeQuery
$month_arr=array('','มกราคม','กุมภาพันธ์','มีนาคม','เมษายน','พฤษภาคม','มิถุนายน','กรกฏาคม','สิงหาคม','กันยายน','ตุลาคม','พฤศจิกายน','ธันวาคม');
addlog("แสดงหน้ารายงานสัดส่วนการรับเรื่องราวร้องทุกข์จำแนกรายเดือน",$app_id,$act7); // add log
$displaytype=(isset($displaytype))?$displaytype:1;
$style="";
if($displaytype==1){
$Arr_report_repeated1=get_repeated1($dbname,$yy,$idcard);
}elseif($displaytype==2){
$Arr_report_repeated1=get_repeated2($dbname,$yy,$idcard);
$style="style=\"display:none\"";
}
?>
<html >
<head>
<title><?=$show_title?></title>
<META http-equiv=Content-Type content="text/html; charset=windows-874">
<link href="../../common/style.css" type="text/css" rel="stylesheet" />
<script>
function popWindow(url,w,h){
var popup = "Popup";
w = 600;
h = 500;
var newwin = window.open(url, popup,'location=0,status=no,scrollbars=auto,resizable=no,width=' + w + ',height=' + h + ',top=20');
newwin.focus();
}
</script>
<style type="text/css">
<!--
body { margin: 0px 0px; padding: 0px 0px}
a:link { color: #005CA2; text-decoration: none}
a:visited { color: #005CA2; text-decoration: none}
a:active { color: #0099FF; text-decoration: underline}
a:hover { color: #0099FF; text-decoration: underline}
-->
</style>
</head>
<body >
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0" >
<tr >
<td valign="top" background="bimg/bg1.gif" style="background-repeat: no-repeat; background-position:right bottom ">
<table width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td colspan="6" align="right"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="6%" align="center" valign="middle"><!-- เลือกปี --></td>
<td width="89%"></td>
<td width="5%" align="center"><img src="../../images/element_previous.png" width="24" height="24" alt="กลับหน้าหลัก" onClick="location.href='report_peper_repeatedly.php?displaytype=<?=$displaytype?>'" style="cursor:hand"></td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="6" align="right"><table width="470" border="0" cellspacing="1" cellpadding="3">
<tr>
<td colspan="4" align="left" bgcolor="#BDC9F9"><strong>
<?=$arrcaption[$displaytype]?>
</strong></td>
</tr>
<tr <?=$style?>>
<td align="right" bgcolor="#BDC9F9"><strong>ประเภทความต้องการ</strong></td>
<td align="left" bgcolor="#FFFFFF"><?=$Arr_report_repeated1[$idcard][s_name]?></td>
</tr>
<tr <?=$style?>>
<td align="right" bgcolor="#BDC9F9"><strong>ข้อเรียกร้อง</strong></td>
<td align="left" bgcolor="#FFFFFF"><?=$Arr_report_repeated1[$idcard][complain_detail]?></td>
</tr>
<tr>
<td width="47%" align="right" bgcolor="#BDC9F9"><strong>เลขบัตรประชาชนผู้ร้องเรียน</strong></td>
<td width="53%" align="left" bgcolor="#FFFFFF"><?=$idcard?></td>
</tr>
<tr bgcolor="<?=$bg_color?>">
<td align="right" bgcolor="#BDC9F9"><strong>จำนวนครั้ง</strong></td>
<td align="left" bgcolor="#FFFFFF"><?=$Arr_report_repeated1[$idcard][ncount]?></td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="6" align="center"> </td>
</tr>
<tr>
<td colspan="6" align="center" bgcolor="#BDC9F9"><strong>
<?=$arrcaption[$displaytype]?>
</strong></td>
</tr>
<tr>
<td width="9%" align="center" bgcolor="#BDC9F9"><strong>ลำดับ</strong></td>
<td width="20%" align="center" bgcolor="#BDC9F9"><strong>วันที่ร้องเรียน</strong></td>
<td width="32%" align="center" bgcolor="#BDC9F9"><strong>ข้อเรียกร้อง</strong></td>
<td width="19%" align="center" bgcolor="#BDC9F9"><STRONG>การดำเนินการ</STRONG></td>
<td width="20%" align="center" bgcolor="#BDC9F9"><STRONG>หมายเหตุ</STRONG></td>
</tr>
<?
$kk=0;
if($displaytype==1){
$sql="SELECT tbl_complain.complain_id,tbl_complain.complain_detail,tbl_complain.type_request,tbl_complain.keyin_time,
tbl_complain.public_idcard,tbl_type_request.s_name ,tbl_complain.problem_comment
FROM tbl_complain left Join tbl_type_request ON tbl_complain.type_request = tbl_type_request.type_id
WHERE tbl_complain.public_idcard ='$idcard' and tbl_complain.complain_detail ='".$Arr_report_repeated1[$idcard][complain_detail]."' and tbl_complain.type_problem ='".$Arr_report_repeated1[$idcard][type_problem]."' order by tbl_complain.keyin_time";
}elseif($displaytype==2){
$sql="SELECT tbl_complain.complain_id,tbl_complain.complain_detail,tbl_complain.type_request,tbl_complain.keyin_time,
tbl_complain.public_idcard,tbl_type_request.s_name ,tbl_complain.problem_comment
FROM tbl_complain left Join tbl_type_request ON tbl_complain.type_request = tbl_type_request.type_id
WHERE tbl_complain.public_idcard ='$idcard' order by tbl_complain.keyin_time";
}
$result=mysql_query($sql);
$kk=0;
while($row=mysql_fetch_array($result)){
$bg_color = ($kk%2)?'#F1F1F1':'FFFFFF';$kk++;
?>
<tr bgcolor="<?=$bg_color?>">
<td align="center"><?=$kk?></td>
<td align="center"><?
$arrstr= explode(' ', $row[keyin_time]);
$arrdate= explode('-', $arrstr[0]);
$arrtime= explode(':', $arrstr[1]);
$m=(int)$arrdate[1];
echo $arrdate[2]." ".$month_arr[$m]." ".($arrdate[0]+543)." เวลา ".(int)$arrtime[0].":".$arrtime[1]."น.";
?></td>
<td align="left"><a href="#" onClick="popWindow('report_detail.php?runid=<?=$row[complain_id]?>')"><?=$row[complain_detail]?></a></td>
<td align="left"> <?=$row[s_name]?></td>
<td align="left"><?=$row[problem_comment]?></td>
</tr>
<?
}
?>
</table>
</td>
</tr>
</table>
</body>
</html>
<?
//insert timeQuery
$time_end = getmicrotime();
writetime2db($timestart,$timeend);
//insert timeQuery
?>