|
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/bin/ |
Upload File : |
<?
session_start();
include "../../config/config.inc.php";
include("../../common/function.php");
if(!isset($session_username)){
header("Location: ../document/login.php");
}
//insert timeQuery
//include("../../common/common_system.inc.php");
$ApplicationName="ecomplain";
//insert timeQuery
$month_arr=array('','มกราคม','กุมภาพันธ์','มีนาคม','เมษายน','พฤษภาคม','มิถุนายน','กรกฏาคม','สิงหาคม','กันยายน','ตุลาคม','พฤศจิกายน','ธันวาคม');
if($senttab != ""){ //
$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.note_detail ,
tbl_complain.note_limitdate ,
tbl_complain.note_bystaff
FROM
tbl_complain_approve
Inner Join tbl_complain ON tbl_complain_approve.complain_id = tbl_complain.complain_id WHERE tbl_complain_approve.runid='$runid'";
}else{
$strSQL = "SELECT * FROM tbl_complain WHERE complain_id ='$runid'";
}
//echo $strSQL."<br>$dbname";
$Result = mysql_db_query($dbname,$strSQL);
$rs = mysql_fetch_assoc($Result);
$complain_id=$rs[complain_id];
$arr_rs = $rs ;
?>
<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='../../common/popcalendar.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}
-->
</STYLE>
</HEAD>
<BODY >
<?
# convert_2mysql($xdate){ ######## 12/03/2552 ==> 2009-03-12
if ($save_note != ""){ ### Save จาก Form
$mysql_limitdate= convert_2mysql($note_limitdate) ;
$sql = " UPDATE tbl_complain SET note_detail='$note_detail',note_limitdate='$mysql_limitdate' , note_bystaff='$note_bystaff' WHERE complain_id ='$complain_id' ";
$result = mysql_query($sql) ;
} ########################### END ### Save จาก Form
$sql_Ticket = "SELECT * FROM tbl_complain WHERE complain_id ='$complain_id' ";
$result_Ticket = mysql_db_query($dbname,$sql_Ticket);
$rs_t = mysql_fetch_assoc($result_Ticket);
?>
<TABLE width="100%" border="0" cellspacing="0" cellpadding="0">
<TR>
<TD bgcolor="#CCCCCC"><TABLE width="100%" border="0" cellspacing="0" cellpadding="0">
<TR>
<TD colspan="2" align="left" valign="top" bgcolor="#FFFFFF"><form name="form1" method="post" action="report_print.php?<?=$_SERVER['QUERY_STRING']?>">
<table width="98%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="3"><span class="project_input style5">เรียน ผู้ว่าราชการจังหวัด
<?=$prov_name?>
</span></td>
</tr>
<tr>
<td width="8%"> </td>
<td colspan="2"><span class="project_input style5">
<textarea name="note_detail" cols="110" rows="9" id="note_detail"><?=$arr_rs[note_detail]?></textarea>
</span></td>
</tr>
<tr>
<td> </td>
<td colspan="2">รายงานภายในวันที่
<INPUT name="note_limitdate" type="text" id="note_limitdate" onFocus="blur();" value="<?=$note_limitdate?>" size="15" readonly>
<INPUT name="button2" type="button" style='font-size:11px; width:80px;' onClick="popUpCalendar(this, form1.note_limitdate, 'dd/mm/yyyy')" value='วันเดือนปี'>
<br>
<span class="project_input style5">
จึงเรียนมาเพื่อโปรดพิจารณา</span></td>
</tr>
<tr>
<td> </td>
<td width="19%"> </td>
<td width="73%"><br>
<br>
<span class="project_input style5">(.........................................)<br>
<br>
<input name="note_bystaff" type="text" id="note_bystaff" value="<?=$arr_rs[note_bystaff]?>" size="30">
</span></td>
</tr>
<tr>
<td align="center"><br> </td>
<td colspan="2"><br>
<input name="save_note" type="submit" id="save_note" value=" บันทึก ">
<input type="submit" name="Submit2" value="ยกเลิกและปิดหน้านี้">
<input type="button" name="Button" value="เรียกดูบันทึกนำเสนอ" onClick="window.open('report_print_step2.php?runid=<?=$complain_id?>') "></td>
</tr>
</table>
</form>
</TD>
</TR>
<TR>
<TD width="25%" align="left" valign="top" bgcolor="#FFFFFF"><STRONG>เรื่องร้องเรียน</STRONG></TD>
<TD width="86%" align="left" valign="top" bgcolor="#FFFFFF"><?=$rs_t[complain_detail]?>
<br></TD>
</TR>
<TR>
<TD align="left" bgcolor="#FFFFFF"><strong>Ticket_ID <br>
<nobr>(รหัสรับเรื่องร้องเรียน)</nobr></strong></TD>
<TD align="left" valign="top" bgcolor="#FFFFFF"><strong>
<?=$complain_id?>
<br>
</strong></TD>
</TR>
<TR>
<TD colspan="2" align="left" bgcolor="#FFFFFF"><STRONG><br>
ละเอียดเรื่องร้องเรียน<A href="form_manage_data.php?type_user=&complain_id=<?=$rs_t[complain_id]?>&action=EDIT&type_user=<?=$type_user?>"><br>
</A></STRONG></TD>
</TR>
<TR>
<TD colspan="2" align="left" bgcolor="#FFFFFF"><TABLE width="100%" border="0" cellspacing="1" cellpadding="3">
<TR>
<TD width="25%" align="right" valign="top"><SPAN class="link_back">เรื่องร้องเรียน : </SPAN></TD>
<TD width="75%" align="left" valign="top"><?=$rs_t[complain_detail]?></TD>
</TR>
<!--
<TR>
<TD align="right"><SPAN class="link_back">พฤติการณ์ของข้อกล่าวหา : </SPAN></TD>
<TD align="left"><?=$rs_t[complain_action]?></TD>
</TR>
-->
<TR>
<TD align="right" valign="top" bgcolor="#FFFFFF" class="link_back">ชื่อสกุล : </TD>
<TD align="left" valign="top"><?=$rs_t[public_name]?></TD>
</TR>
<TR>
<TD align="right" valign="top" bgcolor="#FFFFFF" class="link_back">อายุ : </TD>
<TD align="left" valign="top"><?=$rs_t[public_age]?></TD>
</TR>
<TR>
<TD align="right" valign="top" bgcolor="#FFFFFF" class="link_back">อาชีพ : </TD>
<TD align="left" valign="top"><?=$rs_t[public_job]?></TD>
</TR>
<TR>
<TD align="right" valign="top" bgcolor="#FFFFFF" class="link_back">ที่อยู่ : </TD>
<TD align="left" valign="top"><?=$rs_t[public_address]?></TD>
</TR>
<TR>
<TD align="right" valign="top" bgcolor="#FFFFFF" class="link_back">หมู่ที่ : </TD>
<TD align="left" valign="top"><?=$rs_t[public_moo]?></TD>
</TR>
<TR>
<TD align="right" valign="top" bgcolor="#FFFFFF" class="link_back">ตำบล : </TD>
<TD align="left" valign="top"><?=$rs_t[public_tambol]?></TD>
</TR>
<TR>
<TD align="right" valign="top" bgcolor="#FFFFFF" class="link_back">อำเภอ : </TD>
<TD align="left" valign="top"><?=$rs_t[public_amphur]?></TD>
</TR>
<TR>
<TD align="right" valign="top" bgcolor="#FFFFFF" class="link_back">จังหวัด : </TD>
<TD align="left" valign="top"><!--<?=$rs_t[public_province]?>-->
<?
$sql_type_pro = "SELECT * FROM ccaa WHERE ccDigi='$rs_t[public_province]'";
//echo $sql_type_pro;
$result_type_pro = @mysql_db_query($dbname,$sql_type_pro);
$rs_pro = @mysql_fetch_assoc($result_type_pro);
echo $rs_pro[ccName];
?> </TD>
</TR>
<TR>
<TD align="right" valign="top" bgcolor="#FFFFFF" class="link_back">รหัสไปรษณีย์ : </TD>
<TD align="left" valign="top"><?=$rs_t[public_zipcode]?></TD>
</TR>
<TR>
<TD align="right" valign="top" bgcolor="#FFFFFF" class="link_back">หมายเลขโทรศัพท์ : </TD>
<TD align="left" valign="top"><?=$rs_t[public_phone]?></TD>
</TR>
<TR>
<TD align="right" valign="top" bgcolor="#FFFFFF" class="link_back">E-mail (ถ้ามี) : </TD>
<TD align="left" valign="top"><?=$rs_t[public_email]?></TD>
</TR>
<TR>
<TD align="right" valign="top"> </TD>
<TD align="left" valign="top"> </TD>
</TR>
<TR>
<TD align="right" valign="top"><SPAN class="link_back">การดำเนินการที่ระบุ :</SPAN></TD>
<TD align="left" valign="top"><? if($rs_t[feedback]==0){ echo "ไม่ต้องการให้แจ้งการดำเนินการ";}else{ echo "ต้องการให้แจ้งการดำเนินการ";} ?></TD>
</TR>
<TR>
<TD align="right" valign="top"><SPAN class="link_back">ประเภทเรื่องร้องเรียน : </SPAN></TD>
<TD align="left" valign="top"><?
$sql_type_pro = "SELECT * FROM tbl_type_problem WHERE type_id='$rs_t[type_problem]'";
//echo $sql_type_pro;
$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="right" valign="top" bgcolor="#FFFFFF" class="link_back">ข้อกล่าวหา / ข้อร้องเรียน : </TD>
<TD align="left" valign="top"><?=$rs_t[problem_comment]?></TD>
</TR>
<TR>
<TD align="right" valign="top" bgcolor="#FFFFFF" class="link_back">การดำเนินการที่ระบุ :</TD>
<TD align="left" valign="top"><?
$sql_type_pro = "SELECT * FROM tbl_type_process WHERE type_id='$rs_t[type_process]'";
//echo $sql_type_pro;
$result_type_pro = @mysql_db_query($dbname,$sql_type_pro);
$rs_pro = @mysql_fetch_assoc($result_type_pro);
echo $rs_pro[type_process];
?>
<BR>
<?=$rs_t[process_comment]?></TD>
</TR>
<?
$sql_re = "SELECT * FROM tbl_complain WHERE public_idcard = '$rs_t[public_idcard]' AND public_idcard <> '' ORDER BY complain_id DESC";
//echo $sql_re;
$result_re = @mysql_db_query($dbname,$sql_re);
$num_re = @mysql_num_rows($result_re);
if($num_re > 1){ // กรณีเคยร้องเรียนก่อนหน้านี้
?>
<?
} // end if($num_re > 1){ // กรณีเคยร้องเรียนก่อนหน้านี้
?>
<!-- <TR>
<TD colspan="2" align="center"><? if($type_user != ""){?>
<INPUT type="button" name="btnB" value="กลับหน้าหลัก" onClick="window.close();">
<? } ?></TD>
</TR>-->
</TABLE></TD>
</TR>
</TABLE></TD>
</TR>
</TABLE>
</BODY>
</HTML>