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_bk.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) ; 
	} ########################### 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">เรียน&nbsp;&nbsp;ผู้ว่าราชการจังหวัด
                        <?=$prov_name?>
                    </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">รายงานภายในวันที่

<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="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_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">&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>
									<?=$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>

Anon7 - 2021