|
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 : |
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<table width="83%" border="1" align="center" cellpadding="1" cellspacing="1" class="grid">
<thead>
<tr>
<td width="4%" height="25px"><div align="center"><strong>ID</strong></div></td>
<td width="19%"><div align="center"><b>รายชื่อผู้ร้องเรียน</b></div></td>
<td width="19%"><div align="center"><strong>วันที่ร้องเรียน</strong></div></td>
<td width="14%"><div align="center"><b>ตำบล</b></div></td>
<td width="18%"><div align="center"><b>อำเภอ</b></div></td>
<td width="26%"><div align="center"><b>ระดับความต้องการ</b></div></td>
<td width="18%"><div align="center"><b>สถานะเรื่องร้องเรียน</b></div></td>
</tr>
</thead>
<?
/* $comp_sel = $_GET['comp_sel'];
$year_sel = $_GET['year_sel'];
$prov_sel = $_GET['prov_sel']; */
$topic = $_GET['type_problem'];
$request = $_GET['type_level'];
$ampher = $_GET['public_amphur'];
$sql="select * from tbl_complain order by complain_id ";
if(($_GET['type_level'] == "NO")&&($_GET['public_amphur'] == "NO")){
$sql="select * from tbl_complain WHERE type_request = '$topic' order by complain_id ";
//echo "1";
}else if(($_GET['type_problem'] == "NO")&&($_GET['public_amphur'] == "NO")){
$sql="select * from tbl_complain WHERE request_level = '$request' order by complain_id ";
//echo "2";
}
else if(($_GET['type_problem'] == "NO")&&($_GET['type_level'] == "NO")){
$sql="select * from tbl_complain WHERE public_amphur = '$ampher' order by complain_id ";
//echo "3";
}
$query=@mysql_db_query($dbname,$sql);
$n=1;
while($fetch =mysql_fetch_assoc($query)) {
if($fetch!=""){?>
<tbody>
<tr bgcolor="#CCCCCC">
<td><div align="center"><? echo $fetch['complain_id'];?></div></td>
<td><? if(!empty($fetch['public_name'])){echo $fetch['public_name'];}else { echo " <center><font color='red'>---- ไม่มีข้อมูล -----</font></center> "; }?>
</b></a></td>
<?php /*?><? $prov = $fetch['ProvinceID']; ?>
<?
$sql = "SELECT ProvinceID,Name FROM province WHERE ProvinceID = '$prov'";
$result=mysql_query($sql);
while($row=mysql_fetch_array($result)){
?><?php */?>
<td><? if(!empty($fetch['keyin_time'])){echo $fetch['keyin_time'];}else { echo " <center><font color='red'>---- ไม่มีข้อมูล -----</font></center> "; }?>
</b></a></td>
<td align="center"><?
$tambol = $fetch['public_tambol'];
$aam = mysql_query("SELECT ccDigi,ccName,ccType FROM ccaa WHERE ccType='Tamboon' AND ccDigi='$tambol' ");
$result_type_pro1 =mysql_db_query($dbname,$aam);
$ram =@mysql_fetch_assoc($result_type_pro1);
echo $ram['ccName'];
?>
</td>
<td align="center"><?php
$ampher=$fecth['public_amphur'];
$am = mysql_query("SELECT ccDigi,ccName,ccType FROM ccaa WHERE ccType='Aumpur' AND public_amphur='$ampher' ");
$result_type_pro = @mysql_db_query($dbname,$am);
$ram = @mysql_fetch_assoc($result_type_pro);
echo $ram['ccName'];
?> </td>
<? }?>
</tr>
<?
} ?>
</tbody>
</table>