MINI SHELL

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 :
Current File : /var/www/html/pathumthani_eoffice/application/ecomplain/report_print_tab4.php
<?
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('','มกราคม','กุมภาพันธ์','มีนาคม','เมษายน','พฤษภาคม','มิถุนายน','กรกฏาคม','สิงหาคม','กันยายน','ตุลาคม','พฤศจิกายน','ธันวาคม');


?>
<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 >
<?
#echo "<pre>";print_r($_POST) ; echo "<pre>";
#           convert_2mysql($xdate){ ######## 12/03/2552   ==>   2009-03-12
	if ($save_note != ""){  ### Save จาก Form
		$mysql_limitdate=  convert_2mysql($note_limitdate)  ; 
		$sql = " UPDATE   tbl_complain_approve  SET 
		note_detail='$note_detail',howto='$howto' , howto2_txt='$howto2_txt'  , howto3_txt='$howto3_txt' , note_bystaff='$note_bystaff'   
		WHERE runid ='$runid'  "; 
		$result = mysql_query($sql) ; 
		if (!($result)) {  echo " Line ". __LINE__ ."<hr> $sql   <br> ".mysql_error() ."<br> "; }  ;
	} ########################### END  ### Save จาก Form
/*note_detail
howto
howto2_txt
howto3_txt
note_bystaff*/

	$strSQL = "SELECT * FROM tbl_complain_approve  WHERE  runid ='$runid'";
	$Result = mysql_db_query($dbname,$strSQL);
	$rs = @mysql_fetch_assoc($Result);
	$complain_id=$rs[complain_id];  
	$arr_rs = $rs ; 

	$sql_Ticket = "SELECT * FROM tbl_complain Inner Join tbl_complain_approve ON tbl_complain_approve.complain_id = tbl_complain.complain_id
WHERE tbl_complain_approve.runid ='$runid'  ";
	$result_Ticket = mysql_db_query($dbname,$sql_Ticket);
	$rs_t = @mysql_fetch_assoc($result_Ticket);
	
//	echo "<pre>";print_r($rs_t);echo "</pre>";
	
?>
<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_tab4.php?<?=$_SERVER['QUERY_STRING']?>">
			    <table width="98%" border="0" cellspacing="0" cellpadding="0">
                  <tr>
                    <td colspan="3"><span class="project_input style5">เรียน&nbsp;&nbsp;ผู้ว่าราชการจังหวัด
                        <?=$provincename?>
                    </span></td>
                  </tr>
                  <tr>
                    <td width="8%">&nbsp;</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>&nbsp;</td>
                    <td colspan="2"><br>
<?  if ($arr_rs[howto] == 1 ){ $chk_str = " checked "; }else{ $chk_str = ""; } ?>
<input name="howto" type="radio" value="1" <?=$chk_str?>>


<?  if ($arr_rs[howto] == 2 ){ $chk_str = " checked "; }else{ $chk_str = ""; $arr_rs[howto2_txt]="";   } ?>
เห็นควรแจ้งผู้ร้องทราบ<br><input name="howto" type="radio" value="2"  <?=$chk_str?> >
เห็นควรแจ้ง<input name="howto2_txt" type="text" id="howto2_txt" value="<?=$arr_rs[howto2_txt]?>" size="50">
<br>

<?  if ($arr_rs[howto] == 3 ){ $chk_str = " checked "; }else{ $chk_str = ""; $arr_rs[howto3_txt]="" ;   } ?>
<input name="howto" type="radio" value="3" <?=$chk_str?> >
<input name="howto3_txt" type="text" id="howto3_txt" value="<?=$arr_rs[howto3_txt]?>" size="60">
<br>
                      <br>
                      <span class="project_input style5">
จึงเรียนมาเพื่อโปรดพิจารณา</span>
					</td>
                  </tr>
                  <tr>
                    <td>&nbsp;</td>
                    <td width="19%">&nbsp;</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>                      &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
                      <input name="save_note" type="submit" id="save_note" value="      บันทึก      ">
&nbsp;
<input type="submit" name="Submit2" value="ยกเลิกและปิดหน้านี้"> 
&nbsp; 
<input type="button" name="Button" value="เรียกดูบันทึกนำเสนอ" onClick="window.open('report_print_tab4step2.php?runid=<?=$runid?>') "></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"><?=nl2br($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">&nbsp;</TD>
						<TD align="left" valign="top">&nbsp;</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>
									<?=nl2br($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>
<?

/*
ALTER TABLE `tbl_complain_approve` ADD `note_detail` TEXT NOT NULL ,
ADD `howto` TEXT NOT NULL COMMENT '1แจ้งผู้ร้อง,2แจ้งผู้อื่น,3แจ้งอื่นๆ',
ADD `howto2_txt` VARCHAR( 250 ) NOT NULL ,
ADD `howto3_txt` VARCHAR( 250 ) NOT NULL ,
ADD `note_bystaff` VARCHAR( 250 ) NOT NULL */
?>
</BODY>
</HTML>
Anon7 - 2021