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_dir [ Writeable ] document_root [ Writeable ]

 

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

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) ; 
		
		###  บันทึกข้อมูล ลงในตาราง temp เพื่อแก้ไขข้อความเพื่อเสนอผู้ว่า
		$sql_c = "SELECT COUNT(*) AS num1 FROM tbl_complain_print WHERE complain_id='$complain_id'  ";
		$result_c = mysql_db_query($dbname,$sql_c);
		$rs_c = mysql_fetch_assoc($result_c);
			if($rs_c[num1] > 0){
				$sql_temp = "UPDATE tbl_complain_print SET  note_detail='$note_detail',note_limitdate='$mysql_limitdate', note_bystaff='$note_bystaff',complain_detail='$complain_detail',public_name='$public_name',public_age='$public_age',public_job='$public_job', public_address='$public_address',public_phone='$public_phone',public_email='$public_email',feedback='$feedback', type_problem='$type_problem', problem_comment='$problem_comment',type_process='$type_process' WHERE complain_id='$complain_id' ";
			}else{
				$sql_temp = "INSERT INTO tbl_complain_print SET  complain_id='$complain_id',yy='$yy', note_detail='$note_detail',note_limitdate='$mysql_limitdate', note_bystaff='$note_bystaff',complain_detail='$complain_detail',public_name='$public_name',public_age='$public_age',public_job='$public_job', public_address='$public_address',public_phone='$public_phone',public_email='$public_email',feedback='$feedback', type_problem='$type_problem', problem_comment='$problem_comment',type_process='$type_process' ";
			}
			//echo $sql_temp;
			mysql_db_query($dbname,$sql_temp);
	} ########################### END  ### Save จาก Form
	
	
	$arr_feedback = array("0"=>"ไม่ต้องการให้แจ้งการดำเนินการ","1"=>"ต้องการให้แจ้งการดำเนินการ");
	
	$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);
	
	
	$sql_print = "SELECT * FROM tbl_complain_print WHERE complain_id='$complain_id'";
	$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]";

			}
?>
<TABLE width="100%" border="0" cellspacing="0" cellpadding="0">
	<TR>
		<TD bgcolor="#CCCCCC"><TABLE width="100%" border="0" cellspacing="0" cellpadding="0">
			
			<TR>
			  <TD width="111%" 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="3">
                  <tr>
                    <td align="center"><STRONG>เรื่องร้องเรียน</STRONG></td>
                    <td colspan="2"><label>
                      <textarea name="complain_detail" cols="110" rows="9"><?=$txt_complain_detail;?></textarea>
                    </label></td>
                  </tr>
                  <tr>
                    <td align="center"><strong>Ticket_ID <br>
                        <nobr>(รหัสรับเรื่องร้องเรียน)</nobr></strong></td>
                    <td colspan="2"><strong>
                      <?=$complain_id?>
                    </strong></td>
                  </tr>
                  <tr>
                    <td colspan="3" align="left"><STRONG>ละเอียดเรื่องร้องเรียน</STRONG></td>
                  </tr>
                  <tr>
                    <td align="right"><span class="link_back">ชื่อสกุล : </span></td>
                    <td colspan="2"><label>
                      <input name="public_name" type="text" id="public_name" size="30" value="<?=$txt_public_name?>">
                    </label></td>
                  </tr>
                  <tr>
                    <td align="right"><span class="link_back">อายุ : </span></td>
                    <td colspan="2"><label>
                      <input name="public_age" type="text" id="public_age" size="10" value="<?=$txt_public_age?>">
                    </label></td>
                  </tr>
                  <tr>
                    <td align="right"><span class="link_back">อาชีพ :</span></td>
                    <td colspan="2"><input name="public_job" type="text" id="public_job" size="30" value="<?=$txt_public_job?>"></td>
                  </tr>
                  <tr>
                    <td align="right"><span class="link_back">ที่อยู่ : </span></td>
                    <td colspan="2"><label>
                      <textarea name="public_address" cols="70" rows="3" id="public_address"><?=$txt_public_address?></textarea>
                    </label></td>
                  </tr>
                  <tr>
                    <td align="right"><span class="link_back">หมายเลขโทรศัพท์ : </span></td>
                    <td colspan="2"><input name="public_phone" type="text" id="public_phone" size="30" value="<?=$txt_public_phone?>"></td>
                  </tr>
                  <tr>
                    <td align="right"><span class="link_back">E-mail (ถ้ามี) :</span></td>
                    <td colspan="2"><input name="public_email" type="text" id="public_email" size="30" value="<?=$txt_public_email?>"></td>
                  </tr>
                  <tr>
                    <td align="right"><span class="link_back">การดำเนินการที่ระบุ :</span></td>
                    <td colspan="2"><input name="feedback" type="text" id="feedback" size="30" value="<?=$txt_feedback?>">					</td>
                  </tr>
                  <tr>
                    <td align="right"><span class="link_back">ประเภทเรื่องร้องเรียน :</span></td>
                    <td colspan="2"><input name="type_problem" type="text" id="type_problem" size="30" value="<?=$txt_type_problem?>"></td>
                  </tr>
                  <tr>
                    <td align="right"><span class="link_back">ข้อกล่าวหา / ข้อร้องเรียน :</span></td>
                    <td colspan="2"><input name="problem_comment" type="text" id="problem_comment" size="30" value="<?=$txt_problem_comment?>"></td>
                  </tr>
                  <tr>
                    <td align="right"><span class="link_back">การดำเนินงานุ :</span></td>
                    <td colspan="2">
                      <label>
                      <textarea name="type_process" cols="70" rows="3"><?=$txt_type_process?></textarea>
                    </label></td>
                  </tr>

                  <tr>
                    <td colspan="3">&nbsp;</td>
                  </tr>
                  <tr>
                    <td colspan="3">&nbsp;</td>
                  </tr>
                  <tr>
                    <td colspan="3"><span class="style5 project_input"><strong>เรียน&nbsp;&nbsp;ผู้ว่าราชการจังหวัด
                        <?=$prov_name?>
                    </strong></span></td>
                  </tr>
                  <tr>
                    <td width="17%">&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">&nbsp;</td>
                  </tr>
                  <tr>
                    <td>&nbsp;</td>
                    <td colspan="2">&nbsp;</td>
                  </tr>
                  <tr>
                    <td>&nbsp;</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>&nbsp;</td>
                    <td width="12%">&nbsp;</td>
                    <td width="71%"><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="right">&nbsp;</td>
                    <td colspan="2">&nbsp;</td>
                  </tr>
                  <tr>
                    <td align="center"><br>  </td>
                    <td colspan="2"><br>                      &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
					<input type="hidden" name="yy" value="<?=$rs_t[yy]?>">
                      <input name="save_note" type="submit" id="save_note" value="      บันทึก      ">
&nbsp;
<input type="button"  name="btnC" value="ยกเลิกและปิดหน้านี้" onClick="window.close()">
&nbsp; 
<input type="button" name="Button" value="เรียกดูบันทึกนำเสนอ" onClick="window.open('report_print_step2.php?runid=<?=$complain_id?>') "></td>
                  </tr>
                  <tr>
                    <td align="center">&nbsp;</td>
                    <td colspan="2">&nbsp;</td>
                  </tr>				  		  
                </table>
                            </form>			  </TD>
		  </TR>
			
			
			
			<TR>
				<TD colspan="2" align="left" bgcolor="#FFFFFF">&nbsp;</TD>
			</TR>
		</TABLE></TD>
	</TR>
</TABLE>
</BODY>
</HTML>

Anon7 - 2021