|
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_eoffice/application/ecomplain/ |
Upload File : |
<?
session_start();
//echo "<pre>";
//print_r($_SESSION);
if($type_user == "gov"){
if(!isset($session_username)){
header("Location: ../document/login.php");
}
include("header_menu.php");
}
include "../../config/config.inc.php";
include("function/function.php");
$month_arr=array('','มกราคม','กุมภาพันธ์','มีนาคม','เมษายน','พฤษภาคม','มิถุนายน','กรกฏาคม','สิงหาคม','กันยายน','ตุลาคม','พฤศจิกายน','ธันวาคม');
//====================================================================================================
// Function
//====================================================================================================
function showSelectObj($arr, $selected, $name, $onchange)
{
if($selected == "")
{
$selected = "0";
}
echo "<select size=\"1\" name=\"$name\" onChange=\"$onchange\">";
foreach($arr as $key => $text)
{
$str = "";
if($selected == $key)
{
$str = "selected";
}
echo "<option value=\"$key\" $str>$text</option>";
}
echo "</select>";
}
function selectAll_typeProblem()
{
$sql = "SELECT *
FROM
tbl_type_problem ";
$qr = @mysql_query($sql);
$arr = array();
$i = 0;
while($rs = @mysql_fetch_assoc($qr))
{
$arr[$i] = $rs[type_problem];
$i++;
}
return $arr;
}
//====================================================================================================
// Variable
//====================================================================================================
$arr_des_type = array(
"0"=>"Ticket_ID ",
"1"=>"ประเภทเรื่องร้องเรียน",
"2"=>"เรื่องร้องเรียน",
"3"=>"พฤติการณ์ของข้อกล่าวหา",
"4"=>"ชื่อ - สกุล ",
"5"=>"ตำแหน่ง",
"6"=>"ชื่อหน่วยงาน/สำนัก/กอง",
"7"=>"จังหวัด",
"8"=>"กระทรวง",
"9"=>"กรม",
"10"=>"รายชื่อผู้ถูกกล่าวหา",
"11"=>"ตำแหน่ง",
"12"=>"สังกัดส่วนราชการ",
"13"=>"จังหวัด",
"14"=>"ชื่อผู้ร้องเรียน",
"15"=>"ที่อยู่ผู้ร้องเรียน",
"16"=>"เลขบัตรประชาชน");
$arr_key_type = array(
"0"=>"tbl_complain.complain_id",
"1"=>"tbl_type_problem.type_problem",
"2"=> "tbl_complain.complain_detail",
"3"=>"tbl_complain.complain_action",
"4"=>"tbl_complain.alleg_name",
"5"=>"tbl_complain.alleg_position",
"6"=>"tbl_complain.label_org",
"7"=>"ccaa.ccName",
"8"=>"ministry_lbl.name",
"9"=>"department_lbl.name",
"10"=> "tbl_complain.alleg_name_all",
"11"=>"tbl_complain.alleg_position_all",
"12"=> "tbl_complain.alleg_gov_all",
"13"=> "tbl_complain.alleg_province_all",
"14"=>"tbl_complain.public_name",
"15"=>"tbl_complain.public_address" ,
"16"=>"tbl_complain.public_idcard"
);
$arr_lbl_type = array(
"0"=>"complain_id",
"1"=>"type_problem",
"2"=> "complain_detail",
"3"=>"complain_action",
"4"=>"alleg_name",
"5"=>"alleg_position",
"6"=>"label_org",
"7"=>"ccName",
"8"=>"min_name",
"9"=>"dep_name",
"10"=> "alleg_name_all",
"11"=>"alleg_position_all",
"12"=> "alleg_gov_all",
"13"=> "alleg_province_all",
"14"=>"public_name",
"15"=>"public_address",
"16"=>"public_idcard"
);
$arr_type_problem = selectAll_typeProblem();
?><html>
<head>
<title><?=$show_title_comp?></title>
<META http-equiv=Content-Type content="text/html; charset=windows-874">
<link href="../../common/style.css" type="text/css" rel="stylesheet" />
<script language='javascript' src='daily_popcalendar.js'></script>
<script language='javascript' src='displayelement.js'></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}
.tb_dash th
{
border:solid thin #666;
background:#BDC9F9;
padding: 5px 5px 5px 5px;
}
.tb_dash td
{
border: solid 1px #666;
padding: 3px 3px 3px 3px;
}
-->
</style>
<script language="javascript">
function CheckForm(){
if(document.form1.Ticket_ID.value == ""){
alert("กรุณาระบุ รหัส Ticket_ID");
document.form.Ticket_ID.focus();
return false;
}else{
return true;
}
}
function swapTicket(spn1, spn2, sel, selValue)
{
var s1 = document.getElementById(spn1);
var s2 = document.getElementById(spn2);
//alert(sel.selectedIndex + " " + selValue);
if(sel.options[sel.selectedIndex].value == selValue)
{
s2.style.display = "";
s1.style.display = "none";
}else
{
s2.style.display = "none";
s1.style.display = "";
}
}
</script>
</head>
<body>
<?
if($_GET){
$action = "show_search";
$Ticket_ID = $_GET[Ticket_ID];
$key_type = $_GET[key_type];
}else{
$key_search=$key_type;
if($key_type == 1) {
$Ticket_ID = $arr_type_problem [$_POST[selTP]];
}else {
$key_type = $_POST[key_type];
} ######## END if($key_type == 1) {
} ######## END if($_GET){
$cond = "";
if($key_type == ""){
if($_SESSION[session_staffid] !=""){
$cond = " $arr_key_type[0] LIKE '%$Ticket_ID%'";
}else{
$cond = " $arr_key_type[0] LIKE '$Ticket_ID'";
} #################### END if($_SESSION[session_staffid] !=""){
$key_type = 0;
}else{
if($key_type == "6") {
$cond = " $arr_key_type[6] LIKE '%$Ticket_ID%' OR tbl_department.office LIKE '%$Ticket_ID%'";
}else {
$cond = " $arr_key_type[$key_type] LIKE '%$Ticket_ID%'";
} ######### END if($key_type == "6") {
} ######### END if($key_type == ""){
?>
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0" style="filter:progid:DXImageTransform.Microsoft.Gradient(GradientType=0, StartColorStr='#144C85', EndColorStr='#ffffff');">
<tr>
<td valign="top" background="bimg/bg1.gif" style="background-repeat: no-repeat; background-position:right bottom "><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr><td valign="top"></td></tr>
<tr>
<td align="center" valign="top" ><form action = "check_ticket_id.php" method ="post" enctype="multipart/form-data" name="form1" >
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#000000"><table width="100%" border="0" cellspacing="1" cellpadding="4">
<tr>
<td colspan="2" bgcolor="#BDC9F9"><strong>ตรวจสอบสถานะเรื่องร้องเรียน</strong></td>
</tr>
<tr>
<td width="24%" bgcolor="#FFFFFF">
<?
// if($session_apppermit[5][10] == "on")
if($_SESSION[session_staffid]!="")
{
echo "ค้นหาจาก";
}else
{
echo "รหัส Ticket_ID";
}
?> </td>
<td width="76%" bgcolor="#FFFFFF"><strong>
<span id="spnTicket" <? echo ($key_type != 1)?"" : "style=\"display:none\"" ?>>
<input name="Ticket_ID" type="text" id="Ticket_ID" size="25" value="<?= ($key_type != 1)?$Ticket_ID : "";?>"> </span>
<span id="spnTProblem" <? echo ($key_type == 1)?"" : "style=\"display:none\"" ?>>
<? echo showSelectObj($arr_type_problem, $_POST[selTP], "selTP","" ); ?></span>
<label>
<input type="submit" name="Submit" value="ค้นหา">
<input type="reset" name="btnReset" value="ล้างค่า" >
</label>
</strong><br>
<?
// if($session_apppermit[5][10] == "on")
if($_SESSION[session_staffid]!="")
{
showSelectObj($arr_des_type, $key_type, "key_type", "swapTicket('spnTicket', 'spnTProblem', this, '1');" );
}
?>
<input type="hidden" name="action" value="show_search"> </td>
</tr>
<?
if($action == "show_search"){
addlog("ค้นหาเรื่องราวร้องทุกข์",$app_id,$act8); // add log
$strSQL = "SELECT
tbl_complain.complain_id,
tbl_complain.alleg_name,
tbl_complain.alleg_position,
tbl_complain.label_org,
tbl_complain.alleg_name_all,
tbl_complain.alleg_position_all,
tbl_complain.alleg_gov_all,
tbl_complain.alleg_province_all,
tbl_complain.complain_detail,
tbl_complain.complain_action,
tbl_complain.act_start_date,
tbl_complain.act_end_date,
tbl_complain.accept_date,
tbl_complain.public_name,
tbl_complain.public_address,
tbl_complain.public_idcard,
tbl_complain.date_complate,
tbl_complain.date_late,
tbl_complain.status_approve,
tbl_complain.public_writen,
tbl_complain.public_age,
tbl_complain.public_job,
tbl_complain.public_moo,
tbl_complain.public_tambol,
tbl_complain.public_amphur,
tbl_complain.public_province,
tbl_complain.public_zipcode,
tbl_complain.public_phone,
tbl_complain.public_email,
tbl_complain.problem_comment,
tbl_complain.type_process,
tbl_complain.process_comment,
tbl_complain.keyin_time,
tbl_complain.feedback,
tbl_department.office as office,
tbl_type_problem.type_problem as type_problem,
ccaa.ccName as ccName,
ministry_lbl.name as min_name,
department_lbl.name as dep_name,
tbl_complain.process_date_finish,
tbl_complain.type_user,
tbl_complain.status_show_owner,
tbl_complain.complain_num,
tbl_complain.yy,
tbl_complain.org_code,
tbl_complain.org_name,
tbl_complain.report_date,
tbl_complain.act_start_date,
tbl_complain.type_request,
tbl_complain.type_request_other,
tbl_complain.alleg_office_id,
tbl_complain.alleg_province,
tbl_complain.alleg_ministry,
tbl_complain.alleg_department,
tbl_complain.note_date,
tbl_complain.process_c1,
tbl_complain.process_c1_1,
tbl_complain.process_c1_2,
tbl_complain.process_c2,
tbl_complain.process_c3_other,
tbl_complain.person_id,
tbl_complain.note
FROM
tbl_complain
left Join tbl_type_problem ON tbl_type_problem.type_id = tbl_complain.type_problem
left Join tbl_department ON tbl_department.id = tbl_complain.alleg_office_id
left Join ccaa ON tbl_complain.alleg_province = ccaa.ccDigi
left Join ministry_lbl ON ministry_lbl.moc_id = tbl_complain.alleg_ministry
left Join department_lbl ON department_lbl.dev_id = tbl_complain.alleg_department AND department_lbl.dev_id = tbl_complain.alleg_department
WHERE $cond";
//echo $strSQL;
//$strSQL = "SELECT * FROM tbl_complain WHERE complain_id LIKE '%$Ticket_ID%' ";
$Result = mysql_db_query($dbname,$strSQL);
#echo " <hr>บรรทัดที่ " . __LINE__ ."================ $strSQL ";
$num_r = mysql_num_rows($Result);
$rs = mysql_fetch_assoc($Result);
if($num_r ==1)
{
//================================================================
$tid = $rs[complain_id];
if($tid != ""){
$sql_search = "SELECT
tbl_complain_approve.subject,
tbl_complain_sent.runid,
tbl_complain_sent.com_app_id,
tbl_complain_sent.owner_id,
tbl_complain_sent.org_id,
tbl_complain_sent.process_c1,
tbl_complain_sent.process_c1_1,
tbl_complain_sent.process_c1_2,
tbl_complain_sent.process_c2,
tbl_complain_sent.process_c3_other,
tbl_complain_sent.process_date_finish,
tbl_complain_sent.note,
tbl_complain_sent.attach_file_complate,
tbl_complain_sent.org_main,
tbl_complain_approve.complain_id
FROM
tbl_complain_approve
Inner Join tbl_complain_sent ON tbl_complain_approve.runid = tbl_complain_sent.com_app_id
WHERE
tbl_complain_approve.complain_id LIKE '%$tid%' ";
$result_search = @mysql_db_query($dbname,$sql_search);
$num_ch = @mysql_num_rows($result_search);
$rs_c = mysql_fetch_assoc($result_search);
if($rs_c[subject] != ""){
$txt_subject = $rs_c[subject];
}else{
$txt_subject = " - ";
}
if($num_ch < 1){
$sql_ch1 = "SELECT COUNT(*) AS num1 FROM tbl_complain WHERE complain_id='$Ticket_ID'";
$result_ch1 = mysql_db_query($dbname,$sql_ch1);
$rs_1 = mysql_fetch_assoc($result_ch1);
if($rs_1[num1] > 0){
$show_s = "อยู่ระหว่างพิจารณาเรื่องร้องเรียน";
}else{
$show_s = "ไม่พบเรื่องร้องเรียนในระบบ";
}
}else{
if($rs_c[process_date_finish] != "0000-00-00" and $rs_c[process_c1_2] == "c1_2"){
$show_s = "ดำเนินการเสร็จเรียบร้อยแล้ว";
}else{
$show_s = "อยู่ระหว่างดำเนินการ";
}
}
}
//=====================================================================
$arr_feedback = array("0"=>"ไม่ต้องการให้แจ้งการดำเนินการ","1"=>"ต้องการให้แจ้งการดำเนินการ");
$sql_Ticket = "SELECT * FROM tbl_complain WHERE complain_id ='$tid' ";
$result_Ticket = mysql_db_query($dbname,$sql_Ticket);
$rs_t = mysql_fetch_assoc($result_Ticket);
$sql_print = "SELECT * FROM tbl_complain_print WHERE complain_id='$tid'";
$result_print = mysql_db_query($dbname,$sql_print);
$rs_p = mysql_fetch_assoc($result_print);
## เรื่องร้องเรียน
if($rs_p[complain_detail] != ""){
$txt_complain_detail = $rs_p[complain_detail];
}else{
$txt_complain_detail = $rs_t[complain_detail];
}
## ชื่อ - นามสกุล
if($rs_p[public_name] != ""){
$txt_public_name = $rs_p[public_name];
}else{
$txt_public_name = $rs_t[public_name];
}
## อายุ
if($rs_p[public_age] != ""){
$txt_public_age = $rs_p[public_age];
}else{
$txt_public_age = $rs_t[public_age];
}
## อาชีพ
if($rs_p[public_job] != ""){
$txt_public_job = $rs_p[public_job];
}else{
$txt_public_job = $rs_t[public_job];
}
## ที่อยู่
if($rs_p[public_address] != ""){
$txt_public_address = $rs_p[public_address];
}else{
$sql_type_pro = "SELECT * FROM ccaa WHERE ccDigi='$rs_t[public_province]'";
$result_type_pro = @mysql_db_query($dbname,$sql_type_pro);
$rs_pro = @mysql_fetch_assoc($result_type_pro);
if($rs_pro[ccName] != ""){
$txt_province = " จังหวัด$rs_pro[ccName]";
}else{
$txt_province = "";
}
if($rs_t[public_amphur] != ""){
$txt_amphur = " อำเภอ$rs_t[public_amphur] ";
}else{
$txt_amphur = "";
}
if($rs_t[public_tambol] != ""){
$txt_tambol = " ตำบล$rs_t[public_tambol]";
}else{
$txt_tambol = "";
}
if($rs_t[public_moo] != ""){
$txt_moo = " หมู่ที่$rs_t[public_moo]";
}else{
$txt_moo = "";
}
$txt_public_address = "$rs_t[public_address] $txt_moo $txt_tambol $txt_amphur $txt_province $rs_t[public_zipcode]";
}
## หมายเลขโทรศัพท์
if($rs_p[public_phone] != ""){
$txt_public_phone = $rs_p[public_phone];
}else{
$txt_public_phone = $rs_t[public_phone];
}
### E-mail
if($rs_p[public_email] != ""){
$txt_public_email = $rs_p[public_email];
}else{
$txt_public_email = $rs_t[public_email];
}
## การดำเนินการที่ระบุ
if($rs_p[feedback] != ""){
$txt_feedback = $rs_p[feedback];
}else{
$txt_feedback = $arr_feedback[$rs_t[feedback]];
}
##ประเภทเรื่องร้องเรียน
if($rs_p[type_problem] != ""){
$txt_type_problem = $rs_p[type_problem];
}else{
$sql_type_pro = "SELECT * FROM tbl_type_problem WHERE type_id='$rs_t[type_problem]'";
$result_type_pro = @mysql_db_query($dbname,$sql_type_pro);
$rs_pro = @mysql_fetch_assoc($result_type_pro);
$txt_type_problem = $rs_pro[type_problem];
}
## ข้อกล่าวหา / ข้อร้องเรียน
if($rs_p[problem_comment] != ""){
$txt_problem_comment = $rs_p[problem_comment];
}else{
$txt_problem_comment = $rs_t[problem_comment];
}
### การดำเนินการที่ระบ
if($rs_p[type_process] != ""){
$txt_type_process = $rs_p[type_process];
}else{
$sql_type_pro = "SELECT * FROM tbl_type_process WHERE type_id='$rs_t[type_process]'";
$result_type_pro = @mysql_db_query($dbname,$sql_type_pro);
$rs_pro = @mysql_fetch_assoc($result_type_pro);
$txt_type_process = "$rs_pro[type_process] $rs_t[process_comment]";
}
?>
<tr>
<td bgcolor="#FFFFFF"><strong>รหัส Ticket_ID </strong></td>
<td bgcolor="#FFFFFF"><?=$rs[complain_id]?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><span class="link_back">ประเภทเรื่องร้องเรียน</span></td>
<td bgcolor="#FFFFFF"><?
echo $rs[type_problem];
?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><span class="link_back">เรื่องร้องเรียน</span></td>
<td bgcolor="#FFFFFF"><?=$rs[complain_detail]?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><strong>ชื่อ - สกุล </strong></td>
<td bgcolor="#FFFFFF"><?=$rs[public_name]?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><span class="link_back">อายุ</span></td>
<td bgcolor="#FFFFFF"><?=$txt_public_age?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><span class="link_back">อาชีพ</span></td>
<td bgcolor="#FFFFFF"><?=$txt_public_job?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><span class="link_back">ที่อยู่</span></td>
<td bgcolor="#FFFFFF"><?=$txt_public_address?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><span class="link_back">หมายเลขโทรศัพท</span></td>
<td bgcolor="#FFFFFF"><?=$txt_public_phone?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><span class="link_back">E-mail (ถ้ามี)</span></td>
<td bgcolor="#FFFFFF"><?=$txt_public_email?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><span class="link_back">การดำเนินการที่ระบุ</span></td>
<td bgcolor="#FFFFFF"><? echo "$txt_feedback"; ?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><span class="link_back">ข้อกล่าวหา / ข้อร้องเรียน </span></td>
<td bgcolor="#FFFFFF"><?=$txt_problem_comment?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><span class="link_back">การดำเนินงาน</span></td>
<td bgcolor="#FFFFFF"><?=$txt_type_process?></td>
</tr>
<? if($rs[status_show_owner] == "0"){ // แสดงเมื่อผู้ประสงค์ออกนาม
?>
<? } // end แสดงเมื่อผู้ประสงค์ออกนาม?>
<tr>
<td bgcolor="#FFFFFF"><strong>สถานะเรื่องร้องเรียน</strong></td>
<td bgcolor="#FFFFFF"><?=$show_s;?></td>
</tr>
<?
}else if($num_r > 1){
if($key_type == 0)
{
$topic_show = $arr_des_type[2];
$index_show = 2;
}else
{
$topic_show = $arr_des_type[$key_type];
$index_show = $key_type;
}
?>
<tr>
<td colspan="2" bgcolor="#FFFFFF">
<table width="650" border="0" align="center" cellpadding="0" cellspacing="1">
<tr bgcolor="#BDC9F9" >
<th height="27" >ลำดับ</th>
<th>Ticket_ID</th>
<th>วัน/เดือน/ปี ที่ร้องเรียน</th>
<th><? echo $topic_show ?></th>
</tr>
<?
$i = 1;
do {
if($index_show == 6){
$show = ($rs[label_org]!= "")?$rs[label_org]:$rs[office];
}else{
$show = ($rs[$arr_lbl_type[$index_show]] != "")?$rs[$arr_lbl_type[$index_show]] : " ";
}
/* if($rs[report_date] !="0000-00-00"||$rs[act_start_date] !=""){ # if($rs[accept_date] !="0000-00-00" and $rs[accept_date] !=""){ ## 2009-10-21
$datearr=explode("-",$rs[accept_date]);
$xdate=$datearr[2]."-".$datearr[1]."-".($datearr[0]+543);
}else{
$xdate="";
} ################### END if($rs[accept_date] !="0000-00-00" and $rs[accept_date] !=""){ */
####### if($rs[report_date] !="0000-00-00"||$rs[act_start_date]!=""){
$smonth = array("","ม.ค.", "ก.พ.", "มี.ค.", "เม.ย.", "พ.ค.", "มิ.ย.", "ก.ค.", "ส.ค.", "ก.ย.", "ต.ค.", "พ.ย.", "ธ.ค.");
if( substr($rs[report_date],0,4) == "0000" ){
$rs_complainid = $rs[complain_id] ;
$yy1 = "25". substr($rs_complainid,0,2) ;
$mm1 = (int)substr($rs_complainid ,2,2) ;
$dd1 = substr($rs_complainid ,4,2) ;
$xdate = $dd1 ." ". $smonth[$mm1] ." ". $yy1 ;
}else{
$xdate=" $rs[report_date] ";
} ############# END if($rs[report_date] !="0000-00-00"||$rs[act_start_date]!=""){
$bg_color = ($i%2)?'#F1F1F1':'FFFFFF';$i++;
?>
<tr align=center bgcolor="<?=$bg_color?>" >
<td height="24" ><?=$i?></td>
<td><a href="check_ticket_id.php?Ticket_ID=<?=$rs[complain_id]?>&key_search=<?=$key_type?>"><?=$rs[complain_id]?></a></td>
<td><?=$xdate?> </td>
<td align=left><?=$show?></td>
</tr>
<?
$i++;
}
while($rs = mysql_fetch_assoc($Result))
?>
</table> </td>
</tr>
<?
}else {
?>
<tr>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF">ไม่พบเรื่องรายการที่ระบุ</td>
</tr>
<?
} // end if($num_r > 0){
} // end if($action == "show_search"){
?>
</table></td>
</tr>
</table>
</form> </td>
</tr>
<tr>
<td align="center"><input type="button" name="btn" value="ปิดหน้าต่าง" onClick="window.close();"><?
if($action == "show_search"){
?>
<!--------- ------------>
<?
if ($session_username != ""){
?>
<input type="button" name="btn2" value=" กลับ " onClick="window.location='check_ticket_id.php?key_type=<?=$key_search?>';">
<?
} ######################### END if ($_SESSION[staffid] != ""){
?>
<?
}
?></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>