|
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();
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");
//insert timeQuery
include("../../common/common_system.inc.php");
$ApplicationName="ecomplain";
$time_start = getmicrotime();
//insert timeQuery
$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
{
if($key_type == 1)
{
$Ticket_ID = $arr_type_problem [$_POST[selTP]];
}else
{
$key_type = $_POST[key_type];
}
}
$cond = "";
if($key_type == "")
{
$cond = " $arr_key_type[0] LIKE '%$Ticket_ID%'";
$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%'";
}
}
?>
<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 = "search.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")
// {
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>
<?
//khuan
// if($session_apppermit[5][10] == "on")
// {
// showSelectObj($arr_des_type, $key_type, "key_type", "swapTicket('spnTicket', 'spnTProblem', this, '1');" );
// }
?>
<input type="hidden" name="key_type" value="16">
<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_request,
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.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
Inner Join tbl_type_problem ON tbl_type_problem.type_id = tbl_complain.type_problem
Inner Join tbl_department ON tbl_department.id = tbl_complain.alleg_office_id
Inner Join ccaa ON tbl_complain.alleg_province = ccaa.ccDigi
Inner Join ministry_lbl ON ministry_lbl.moc_id = tbl_complain.alleg_ministry
Inner Join department_lbl ON department_lbl.dev_id = tbl_complain.alleg_department AND department_lbl.dev_id = tbl_complain.alleg_department
WHERE $cond";
//$strSQL = "SELECT * FROM tbl_complain WHERE complain_id LIKE '%$Ticket_ID%' ";
$Result = mysql_db_query($dbname,$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 = "อยู่ระหว่างดำเนินการ";
}
}
}
//=====================================================================
?>
<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"><span class="link_back">พฤติการณ์ของข้อเรียกร้อง</span></td>
<td bgcolor="#FFFFFF"><?=$rs[complain_action]?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><strong>ชื่อ - สกุล </strong></td>
<td bgcolor="#FFFFFF"><?=$rs[alleg_name]?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><strong>ตำแหน่ง</strong></td>
<td bgcolor="#FFFFFF"><?=$rs[alleg_position]?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><strong>ชื่อหน่วยงาน/สำนัก/กอง</strong></td>
<td bgcolor="#FFFFFF"><?
if($rs[label_org] != ""){
echo $rs[label_org];
}else{
echo $rs[office];
}
?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><strong>จังหวัด</strong></td>
<td bgcolor="#FFFFFF"><?
echo $rs[ccName];
?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><strong>กระทรวง</strong></td>
<td bgcolor="#FFFFFF"><?
echo $rs[min_name];
?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><strong>กรม</strong></td>
<td bgcolor="#FFFFFF"><? /*
$sql_dep = "SELECT name FROM department_lbl WHERE dev_id='$rs[alleg_department]'";
$result_dep = mysql_db_query($dbname,$sql_dep);
$rs_dep = mysql_fetch_assoc($result_dep);
echo $rs_dep[name]; */
echo $rs[dep_name];
?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><strong>รายชื่อผู้ถูกกล่าวหา</strong></td>
<td bgcolor="#FFFFFF"><?=$rs[alleg_name_all]?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><strong>ตำแหน่ง</strong></td>
<td bgcolor="#FFFFFF"><?=$rs[alleg_position_all]?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><strong>สังกัดส่วนราชการ</strong></td>
<td bgcolor="#FFFFFF"><?=$rs[alleg_gov_all]?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><strong>จังหวัด</strong></td>
<td bgcolor="#FFFFFF"><?=$rs[alleg_province_all]?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><span class="link_back">สถานะการออกนาม</span></td>
<td bgcolor="#FFFFFF"><?
if($rs[status_show_owner] == "0"){
echo "ประสงค์ออกนาม";
}else{
echo "ไม่ประสงค์ออกนาม";
}
?></td>
</tr>
<? if($rs[status_show_owner] == "0"){ // แสดงเมื่อผู้ประสงค์ออกนาม
?>
<tr>
<td bgcolor="#FFFFFF"><span class="link_back">ชื่อผู้ร้องเรียน</span></td>
<td bgcolor="#FFFFFF"><?=$rs[public_name]?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><span class="link_back">ที่อยู่</span></td>
<td bgcolor="#FFFFFF"><?=$rs[public_address]?></td>
</tr>
<? } // 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 border="0" style="border:solid thin #CCC" cellspacing="0" cellpadding="0" class="tb_dash" align="center">
<tr>
<th>ลับดับ</th><th>Ticket_ID</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]] : " ";
}
echo "<tr>";
echo "<td align=\"center\">$i</td><td><a href=\"search.php?Ticket_ID=$rs[complain_id]\">$rs[complain_id]</a></td><td>" .$show."</td>";
echo "</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"){
?>
<input type="button" name="btn2" value=" กลับ " onClick="window.location='search.php';">
<?
}
?>
</td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
<?
//insert timeQuery
$time_end = getmicrotime();
writetime2db($timestart,$timeend);
//insert timeQuery
?>