|
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();
include "../../config/config.inc.php";
include("function/function.php");
if(!isset($session_username)){
header("Location: ../document/login.php");
}
//insert timeQuery
include("../../common/common_system.inc.php");
$ApplicationName="ecomplain";
$time_start = getmicrotime();
//insert timeQuery
$month_arr=array('','มกราคม','กุมภาพันธ์','มีนาคม','เมษายน','พฤษภาคม','มิถุนายน','กรกฏาคม','สิงหาคม','กันยายน','ตุลาคม','พฤศจิกายน','ธันวาคม');
$strSQL = "SELECT
tbl_complain_approve.runid,
tbl_complain.complain_id,
tbl_complain.alleg_name,
tbl_complain.alleg_position,
tbl_complain.alleg_office_id,
tbl_complain.alleg_province,
tbl_complain.alleg_ministry,
tbl_complain.alleg_department,
tbl_complain.label_org,
tbl_complain.alleg_name_all,
tbl_complain.alleg_position_all,
tbl_complain.alleg_gov_all,
tbl_complain.type_problem,
tbl_complain.type_request_other,
tbl_complain.type_request,
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.type_user,
tbl_complain_approve.date_end
FROM
tbl_complain_approve
Inner Join tbl_complain ON tbl_complain_approve.complain_id = tbl_complain.complain_id WHERE tbl_complain_approve.runid='$runid'";
$Result = mysql_db_query($dbname,$strSQL);
$rs = mysql_fetch_assoc($Result);
?>
<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}
.style2 {color: #000000}
.style3 {color: #000000; text-decoration: none; font-size: 12px;}
-->
</style>
<SCRIPT LANGUAGE="JavaScript">
function CheckForm(){
var f1 = document.form;
a = Number(f1.date_late.value) ;
missinginfo = "";
missinginfo1 = "";
if (document.form.subject.value == "") {missinginfo1 += "\n- กรุณากรอก เรื่องร้องเรียน "; }
if (document.form.subject_no_in.value == "") {missinginfo1 += "\n- กรุณากรอก เลขที่หนังสือ "; }
if (document.form.date_start.value == "") {missinginfo1 += "\n- กรุณากรอก วันเริ่มต้น "; }
if (document.form.date_end.value == "") {missinginfo1 += "\n- กรุณากรอก สิ้นสุด "; }
if (document.form.date_late.value == "") {missinginfo1 += "\n- กรุณากรอก จำนวนวันที่แจ้งเตือน"; }
if (a == null || !a.toString().match(/^[-]?\d*\.?\d*$/)){ missinginfo1 += "\n- กรุณากรอก วันที่แจ้งเตือนเป็นตัวเลขเท่านั้น "; }
if (missinginfo1 != "") {
missinginfo += "ไม่สามารถบันทึกข้อมูลได้ เนื่องจาก \n";
missinginfo +="_____________________________\n";
missinginfo = missinginfo + missinginfo1 ;
missinginfo += "\n___________________________";
missinginfo += "\nกรุณาตรวจสอบ อีกครั้ง";
alert(missinginfo);
return false;
}
}
</SCRIPT>
<script language="javascript">
function popWindow(url, w, h){
var popup = "Popup";
if(w == "") w = 420;
if(h == "") h = 300;
var newwin = window.open(url, popup,'location=0,status=no,scrollbars=no,resizable=no,width=' + w + ',height=' + h + ',top=20');
newwin.focus();
}
function popWindow1(url, w, h){
var popup = "Popup";
if(w == "") w = 420;
if(h == "") h = 300;
var newwin = window.open(url, popup,'location=0,status=no,scrollbars=no,resizable=no,width=' + w + ',height=' + h + ',top=20');
newwin.focus();
}
function popWindow2(url, w, h){
var popup = "Popup";
if(w == "") w = 420;
if(h == "") h = 300;
var newwin = window.open(url, popup,'location=0,status=no,scrollbars=no,resizable=no,width=' + w + ',height=' + h + ',top=20');
newwin.focus();
}
</script>
<script language="javascript">
function clearselect()
{
document.post.salary_day.disabled=true;
document.post.salary_month.disabled=true;
document.post.salary_year.disabled=true;
document.post.label_date.disabled=true;
if (document.post.salary_day.value!="")
{
document.post.salary_day.value="";
document.post.salary_day.disabled=true;
}
if (document.post.salary_month.value!="")
{
document.post.salary_month.value="";
document.post.salary_month.disabled=true;
}
if (document.post.salary_year.value!="")
{
document.post.salary_year.value="";
document.post.salary_year.disabled=true;
}
if (document.post.label_date.value!="")
{
document.post.label_date.value="";
document.post.label_date.disabled=true;
}
}
</script>
</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" cellpadding="0" cellspacing="0">
<tr><td valign="top"></td></tr>
<tr>
<td valign="top" >
<table width="99%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td width="100%" align="left" valign="top" bgcolor="#E0E6FC"><strong>เรียน ผู้ว่าราชการจังหวัด<?=$provincename?> </strong></td>
</tr>
<tr height="100%">
<td align="left" valign="top" bgcolor="#FFFFFF" ><table width="100%" height="100%" border="0" cellpadding="2" cellspacing="1">
<tr>
<td colspan="2" align="left"><strong>รายละเอียดข้อมูลเรื่องร้องเรียน</strong></td>
</tr>
<tr>
<td width="17%" align="left">ประเภทเรื่องร้องเรียน</td>
<td width="83%" align="left"><?
$sql_type_pro = "SELECT * FROM tbl_type_problem WHERE type_id='$rs[type_problem]'";
$result_type_pro = @mysql_db_query($dbname,$sql_type_pro);
$rs_pro = @mysql_fetch_assoc($result_type_pro);
echo $rs_pro[type_problem];
?></td>
</tr>
<tr>
<td align="left"><span class="style3">เรื่องร้องเรียน</span></td>
<td align="left"><?=$rs[complain_detail]?></td>
</tr>
<tr>
<td align="left"><span class="style3">พฤติการณ์ของข้อกล่าวหา</span></td>
<td align="left"><?=$rs[complain_action]?></td>
</tr>
<tr>
<td colspan="2" align="left"><strong>ข้อมูลผู้กล่าวหา / ผู้ถูกร้องเรียน </strong></td>
</tr>
<tr>
<td align="left">ชื่อ - สกุล</td>
<td align="left"><?=$rs[alleg_name]?></td>
</tr>
<tr>
<td align="left">ตำแหน่ง</td>
<td align="left"><?=$rs[alleg_position]?></td>
</tr>
<tr>
<td align="left">ชื่อหน่วยงาน/สำนัก/กอง</td>
<td align="left"><?
$sql_org = "SELECT * FROM org_staffgroup WHERE gid='$rs[alleg_office_id]'";
$result_org = @mysql_db_query($dbname,$sql_org);
$rs_org = @mysql_fetch_assoc($result_org);
if($rs[label_org] != ""){
echo $rs[label_org];
}else{
echo $rs_org[groupname];
}
?></td>
</tr>
<tr>
<td align="left">รายชื่อผู้เกี่ยวข้อง</td>
<td align="left"><?=$rs[alleg_name_all]?></td>
</tr>
<tr>
<td colspan="2" align="left"> </td>
</tr>
</table></td>
</tr>
<? if($type_user != "gov"){?>
<? if($rs[status_show_owner] == "0"){?>
<?
} //
} // if($type_user != "gov"){
?>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
<?
//insert timeQuery
$time_end = getmicrotime();
writetime2db($timestart,$timeend);
//insert timeQuery
?>