|
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 : /home/pathumthani_integration/requirement/images_sys/ |
Upload File : |
<?
session_start();
include "../../config/config.inc.php";
include("function/function.php");
include ("graph.inc.php");
/*if(!isset($session_username)){
header("Location: ../document/login.php");
}*/
//include("header_menu.php");
include("../../common/common_system.inc.php");
###initial variable
$attached_pic = '<img src="img/paperclip.gif"></img>';
$right_pic= '<img src="images/success.gif"></img>';
$wrong_pic= '<img src="images/alert_icon.png"></img>';
function LimitText($s,$n){
if (strlen($s) > $n){
$s = substr($s,0,$n) . "...";
}
return $s;
}
if($action == "DEL"){
// ลบรายการเรื่องร้องเรียน
$strSQL_del ="DELETE FROM tbl_complain WHERE complain_id='$del_id'";
$Result_del = mysql_db_query($dbname,$strSQL_del);
addlog("ลบเรื่องเรียน - ร้องทุกข์",$app_id,$act3,$del_id); // add log
// ลบรายการไฟล์แนบ
$sql_select = "SELECT *FROM tbl_attachfile WHERE complain_id='$del_id'";
$result_select = mysql_db_query($dbname,$sql_select);
while($rs_s = mysql_fetch_assoc($result_select)){
if($rs_s[act_file] != ""){
@unlink($rs_s[act_file]);
}
$sql_del = "DELETE FROM tbl_attachfile WHERE runno='$rs_s[nunno]'";
$result_del = mysql_db_query($dbname,$sql_del);
}
if($Result_del){
echo "
<script language=\"javascript\">
alert(\"ลบรายการเรียบร้อย\\n \");
location.href='?p=add.php';
</script>";
exit();
}
}
/*
$ApplicationName="ecomplain";
$time_start = getmicrotime();
//insert timeQuery
$month_arr=array('','มกราคม','กุมภาพันธ์','มีนาคม','เมษายน','พฤษภาคม','มิถุนายน','กรกฏาคม','สิงหาคม','กันยายน','ตุลาคม','พฤศจิกายน','ธันวาคม');
if($yy == ""){
$yy = date("Y");
}else{
$yy = $yy;
}
addlog("แสดงหน้ารายงานเรื่องที่ค้างดำเนินการจำแนกตามอำเภอ",$app_id,$act7); // add log
//$sql_re = "SELECT month( date_start ) as mm FROM tbl_complain_approve WHERE year( date_start )='$yy'";
$sql_re = "SELECT month(tbl_complain_approve.date_start ) as mm FROM tbl_complain_approve INNER JOIN tbl_complain_sent ON tbl_complain_approve.runid=tbl_complain_sent.com_app_id WHERE year(tbl_complain_approve.date_start)='$yy' AND (tbl_complain_sent.org_main=tbl_complain_sent.org_id) AND tbl_complain_sent.process_date_finish = '0000-00-00'";
//echo $sql_re;
$result_re = @mysql_db_query($dbname,$sql_re);
$num_c = @mysql_num_rows($result_re);
while($rs = @mysql_fetch_assoc($result_re)){
$Arr_report[$rs[mm]] = $Arr_report[$rs[mm]] +1;
}
$xmonth_arr = $month_arr;
for($m=1;$m<count($xmonth_arr);$m++){
if($daylist > "") $daylist .= ";";
if($data1 > "") $data1 .= ";";
$daylist .= $xmonth_arr[$m];
$data1 .= intval($Arr_report[$m]);
}
$txt_title = "สัดส่วนการรับเรื่องร้องทุกข์ที่ค้างดำเนินการจำแนกรายเดือน ปี ".($yy+543);
$graphurl = $graph_path . "?category=$daylist&data1=$data1&outputstyle=&numseries=1&seriesname=&graphtype=pie&title=$txt_title&xname=เดือน&yname=จำนวน(เรื่องร้องเรียน)&subtitle=&graphstyle=srd_sf_004.scs";
$w1 = 250;
$h1 = 150;
*/
?>
<html>
<head>
<title><?=$show_title?></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='daily_popcalendar.js'></script>
<script language='javascript' src='displayelement.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}
img{ border:none}
.style2 {color: #9B0000}
-->
</style>
<SCRIPT LANGUAGE="JavaScript">
function CheckForm(){
var f1 = document.form;
a = Number(f1.date_late.value) ;
missinginfo = "";
missinginfo1 = "";
if (document.form.subject.value == "") {missinginfo1 += "\n- กรุณากรอก เรื่องร้องเรียน "; }
if (document.form.subject_no_in.value == "") {missinginfo1 += "\n- กรุณากรอก เลขที่หนังสือ "; }
if (document.form.date_start.value == "") {missinginfo1 += "\n- กรุณากรอก วันเริ่มต้น "; }
if (document.form.date_end.value == "") {missinginfo1 += "\n- กรุณากรอก สิ้นสุด "; }
if (document.form.date_late.value == "") {missinginfo1 += "\n- กรุณากรอก จำนวนวันที่แจ้งเตือน"; }
if (a == null || !a.toString().match(/^[-]?\d*\.?\d*$/)){ missinginfo1 += "\n- กรุณากรอก วันที่แจ้งเตือนเป็นตัวเลขเท่านั้น "; }
if (missinginfo1 != "") {
missinginfo += "ไม่สามารถบันทึกข้อมูลได้ เนื่องจาก \n";
missinginfo +="_____________________________\n";
missinginfo = missinginfo + missinginfo1 ;
missinginfo += "\n___________________________";
missinginfo += "\nกรุณาตรวจสอบ อีกครั้ง";
alert(missinginfo);
return false;
}
}
</SCRIPT>
<script language="javascript">
function popWindow(url, w, h){
var popup = "Popup";
if(w == "") w = 420;
if(h == "") h = 300;
var newwin = window.open(url, popup,'location=0,status=no,scrollbars=no,resizable=no,width=' + w + ',height=' + h + ',top=20');
newwin.focus();
}
function popWindow1(url, w, h){
var popup = "Popup";
if(w == "") w = 420;
if(h == "") h = 300;
var newwin = window.open(url, popup,'location=0,status=no,scrollbars=no,resizable=no,width=' + w + ',height=' + h + ',top=20');
newwin.focus();
}
function popWindow2(url, w, h){
var popup = "Popup";
if(w == "") w = 420;
if(h == "") h = 300;
var newwin = window.open(url, popup,'location=0,status=no,scrollbars=no,resizable=no,width=' + w + ',height=' + h + ',top=20');
newwin.focus();
}
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
</script>
<script language="javascript">
function clearselect()
{
document.post.salary_day.disabled=true;
document.post.salary_month.disabled=true;
document.post.salary_year.disabled=true;
document.post.label_date.disabled=true;
if (document.post.salary_day.value!="")
{
document.post.salary_day.value="";
document.post.salary_day.disabled=true;
}
if (document.post.salary_month.value!="")
{
document.post.salary_month.value="";
document.post.salary_month.disabled=true;
}
if (document.post.salary_year.value!="")
{
document.post.salary_year.value="";
document.post.salary_year.disabled=true;
}
if (document.post.label_date.value!="")
{
document.post.label_date.value="";
document.post.label_date.disabled=true;
}
}
function processSearch()
{
var o = document.getElementById('sel_aumpur');
var o2 = document.getElementById('sel_district');
var o3 = document.getElementById('year');
var district = o.options[o.options.selectedIndex].value;
var subdistrct = o2.options[o2.options.selectedIndex].value;
var yyyy = o3.options[o3.options.selectedIndex].value;
var url="?add="+subdistrct+"&sel_year="+yyyy;
form1.action=url;
form1.submit();
}
</script>
</head>
<body >
<?php
$year = ($_POST['year']!="")?($_POST['year']-543):date("Y");
$strSQL = "SELECT * FROM tbl_complain WHERE yy='$year' ORDER BY time_add ASC";
//$strCond_sum =" AND tc.public_amphur='".$_GET['sel_aumpur']."' AND tc.public_tambol='".$_GET['sel_district']."' AND tc.yy=".$_GET['sel_year'];
//$strSQL_sum .= $strCond_sum;
//echo $strSQL_sum;
$res_sum = mysql_query($strSQL);
$all_row = mysql_num_rows($res_sum);
$tot=0;
$help_count=0;
while($rs_sum = mysql_fetch_assoc($res_sum))
{
$tot = $rs_sum['tot'];
$help_count = $rs_sum['help_count'];
}
?>
<form id="formy" name="formy" method="post" action="<?=$PHP_SELF?>?p=add.php&year=<?=$year?>">
<table width="400" border="0" align="center">
<?php /*?><tr>
<td align="right"> เลือกปีที่ต้องการเลือกดูข้อมูล</td>
<td>
<select name="year" id="year" onChange="return processSearch();">
<option> - เลือกปี - </option>
<?
$strSQL="SELECT yy FROM tbl_complain GROUP BY yy ";
$Result_YY =mysql_query("$strSQL");
if(@mysql_num_rows($Result_YY)>0){
while($row_yy = mysql_fetch_assoc($Result_YY)){
$sel = $row_yy[yy] == $year ? "selected" :"";
echo "<option value=\"".intval($row_yy[yy]+543)."\" $sel >".intval($row_yy[yy]+543)."</option>";
}
}
?>
</select></td>
</tr><?php */?>
</table>
</form>
<form name="form1" method="post" action="">
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0" >
<tr>
<td valign="top" background="bimg/bg1.gif" style="background-repeat: no-repeat; background-position:right bottom ">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" bgcolor="#FFFFFF">
<table width="99%" border="0" align="center" cellpadding="2" cellspacing="0">
<tr>
<td width="26%" valign="top" ></td>
</tr>
<tr>
<td colspan="2" align="right" valign="top" ><div align="center"><strong>ระบบบันทึกข้อมูลปัญหาและความต้องการ ปี
<?= $year+543?>
</strong></div></td>
</tr>
<tr>
<td colspan="2" align="center" valign="top" ><? include ('exsum2.php');?></td>
</tr>
<tr>
<td valign="top" align="left" ><strong>[ <a href="?p=form_manage_data.php&action=ADD&type_user=gov&senttab=0">เพิ่มข้อมูลปัญหาและความต้องการ</a> ] <img src="images/add.png" alt="เพิ่มข้อมูลปัญหาและความต้องการ" width="15" height="15" border="0" align="absmiddle" style="cursor:hand" onClick="location.href='?p=form_manage_data.php&action=ADD&type_user=gov&senttab=0'"></strong></td>
<td width="74%" align="right" valign="top">
<?php
# query for dash board
$year = ($_POST['year'] != "")?$_POST['year']-543:date("Y");
$strSQL = "SELECT * FROM tbl_complain WHERE yy='$year' ";
//echo "<br>".$strSQL;
$rsConn = mysql_db_query($dbname,$strSQL);
$all_row = mysql_num_rows($rsConn);
$board_row_per_page = 20;
$total_page = ceil($all_row/$board_row_per_page);
$page = ($_GET['page'])?$_GET['page']:1;
$page = ($page > $total_page)?$total_page:$page;
$page = ($page <= 0)?1:$page;
$limit_start = ($page==1)?0:(($page*$board_row_per_page)-$board_row_per_page);
$limit_end = $board_row_per_page;
if($View==''){
$strSQL .= " ORDER BY time_add DESC,keyin_time DESC LIMIT ".$limit_start.", ".$limit_end;
$num = $limit_start ;
}
if(isset($cols)&&isset($sort)){
$solink="&cols=$cols&sort=$sort";
}
//$text_search = ($_GET['b_search'])?"b_search=ค้นหา&letter_code_search=".$_GET['letter_code_search']."&letter_code2_search=".$_GET['letter_code2_search']."&letter_name_search=".$_GET['letter_name_search']."&letter_secname_search=".$_GET['letter_secname_search']."&LetterType_search=".$_GET['LetterType_search']."&name_search=".$_GET['name_search']."&letter_surname_search=".$_GET['letter_surname_search']."&date_order=".$_GET['date_order']."&date_order2=".$_GET['date_order2']:"";
/*$text_search = ($_GET['b_search'])?"b_search=ค้นหา&sel_aumpur=".$_GET['sel_aumpur']."&sel_year=".$_GET['sel_year']."&sel_district=".$_GET['sel_district']:"";*/
$prev_page = $page - 1; $prev_page = ($prev_page <= 1)?1:$prev_page;
$prev = "self.location='".$PHP_SELF."?p=add.php&search=$search&page=$prev_page$link$solink'";
$next_page = $page + 1; $next_page = ($next_page >= $total_page)?$total_page:$next_page;
$next = "self.location='".$PHP_SELF."?p=add.php&search=$search&page=$next_page$link$solink'";
$prev_Tenpage=$page-$board_row_per_page;$prev_Tenpage=($prev_Tenpage<= 1)?1:$prev_Tenpage;
$prevTen = "self.location='".$PHP_SELF."?p=add.php&search=$search&page=$prev_Tenpage$link$solink'";
$nextTenPage=$page+$board_row_per_page;$next_TenPage=($next_TenPage >= $total_page)?$total_page:$next_TenPage;
$nextTen = "self.location='".$PHP_SELF."?p=add.php&search=$search&page=$nextTenPage$link$solink'";
?>
<? if($View==""){$Klink="?".$text_search."&View=All"; $CSh="ข้อมูลทั้งหมด"; $Klink2="?p=add.php&View=";}else{$Klink="?".$text_search."&View=";$CSh="ข้อมูล ".$board_row_per_page." รายการล่าสุด";$Klink2="?p=add.php&View=All";}?>
ทั้งหมด <b> <font color="#CC0000">
<?=number_format($all_row);?>
</font> </b> รายการ
<? if($View==""){?>
แบ่งเป็น <b><font color="#0033CC">
<?=number_format($total_page);?>
</font></b> หน้า
<? }?>
<a href="<?=$Klink?>"><img src="img/Search-Add.gif" alt="<?=$CSh?>" width="16" height="16" border="0" /></a>
<? if($View==''){?>
<? if($page==1){?>
<img src="img/page_div_icon/xFirst.gif" />
<? }else{?>
<img src="img/page_div_icon/First.gif" align="absmiddle" border="0" width="10" height="12" onclick="<?=$prevTen;?>" onMouseOver="style.cursor='hand';"/>
<? }?>
<? if($page==1){?>
<img src="img/page_div_icon/xPrevious.gif" />
<? }else{?>
<img src="img/page_div_icon/Previous.gif" align="absmiddle" border="0" width="7" height="12" onclick="<?=$prev;?>" onMouseOver="style.cursor='hand';"/>
<? }?>
<?php
$board_link_num = $board_row_per_page;
$ii = 1;
if ( $board_link_num > $total_page ){
$loop_page = $total_page;
} else {
$bx = ceil($board_link_num / 2);
$pp = $page - $bx;
$pn = $page + $bx;
$loop_page = $pn;
$ii = $pp;
if ( $total_page <= $loop_page ) {
$loop_page = $total_page;
$ii = $loop_page - ($board_link_num -1);
}
if ( $ii < 1 ) {
$ii = 1;
$loop_page = $ii + ($board_link_num -1);
}
}
for($i=$ii;$i<=$loop_page;$i++){
if ( $i==$page || !$page ) {
$txt = "<b>$i</b>";
} else {
$txt = $i;
}
?>
<a href="<?=$PHP_SELF;?>?p=add.php&Sort=<?=$Sort;?>&search=<?=$search?>&page=<?=$i;?>">
<?=$txt;?>
</a>
<?
} # for
?>
<? if($page==$loop_page){?>
<img src="img/page_div_icon/xNext.gif" />
<? }else{?>
<img src="img/page_div_icon/Next.gif" border="0" width="7" height="12" onClick="<?=$next;?>" onMouseOver="style.cursor='hand';"/>
<? }?>
<? if($page==$loop_page){?>
<img src="img/page_div_icon/xLast.gif" />
<? }else{?>
<img src="img/page_div_icon/Last.gif" border="0" width="10" height="12" onClick="<?=$nextTen;?>" onMouseOver="style.cursor='hand';"/>
<?
}
}#End View=
?></td>
</tr>
</table></td>
</tr>
<?php
//$year=date("Y");
//$strSQL = "SELECT * FROM tbl_complain WHERE yy='$year' ORDER BY complain_id DESC";
//$strCond_sum =" AND tc.public_amphur='".$_GET['sel_aumpur']."' AND tc.public_tambol='".$_GET['sel_district']."' AND tc.yy=".$_GET['sel_year'];
//$strSQL_sum .= $strCond_sum;
//echo $strSQL_sum;
$res_sum = mysql_query($strSQL);
$all_row = mysql_num_rows($res_sum);
$tot=0;
$help_count=0;
while($rs_sum = mysql_fetch_assoc($res_sum))
{
$tot = $rs_sum['tot'];
$help_count = $rs_sum['help_count'];
}
?>
<tr >
<td align="center" >
<table width="99%" border="1" align="center" cellpadding="4" cellspacing="0" bordercolor="#636276" style="border-collapse:collapse;">
<tr class="bg_th">
<td align="center" width="31"><div align="center"><strong>ลำดับ</strong></div></td>
<td width="52" align="center" ><div align="center"><strong>อำเภอ</strong></div></td>
<td width="46" align="center"><div align="center"><strong>ตำบล</strong></div></td>
<td align="center" width="124"><div align="center"><strong>ประเภทความต้องการ</strong></div></td>
<td width="204" align="center"><div align="center"><strong>รายละเอียด</strong></div></td>
<td align="center" width="61">แหล่งข้อมูล</td>
<td align="center" width="81">หน่วยงานที่ต้อง<br>
ดำเนินงานแก้ไข</td>
<td align="center" width="63"><strong>วันที่บันทึก</strong></td>
<td align="center" width="91"><strong>วันที่บันทึกให้</br>
ความช่วยเหลือ</strong></td>
<td align="center" width="68"><strong>การให้ความ<br/>
ช่วยเหลือ</strong></td>
<td align="center" width="81"><strong>จัดการข้อมูล</strong></td>
</tr>
<?php
### initial variable
$seq = 1;
$where_cond = "WHERE 1=1 AND tc.";
//echo "<br>".$sql_select;
//echo $sql_select;
$am = mysql_query($strSQL);
$arr_percent = array();
$intA=0;
while( $ram = mysql_fetch_array($am) ) {
$intA++;
$rowNumb = ($intA+($board_link_num*$page)-$board_link_num);
?> <? if ($ram['request_level']=="3"){
// $color='#FF3366';
$style = "background: -moz-linear-gradient(left, #FF3300, #FFFFFF); background: -webkit-gradient(linear, left top, right top, from(#B50000), to(#FFFFFF)); filter: progid:DXImageTransform.Microsoft.Gradient(StartColorStr='#B50000', EndColorStr='#FFFFFF', GradientType=1);";
//$style ="background-image:url(images/type3.jpg);";
}else if ($ram['request_level']=="2"){
// $color='#FF9900';
$style = "background: -moz-linear-gradient(left, #FF9900, #FFFFFF); background: -webkit-gradient(linear, left top, right top, from(#FF9900), to(#FFFFFF)); filter: progid:DXImageTransform.Microsoft.Gradient(StartColorStr='#FF9900', EndColorStr='#FFFFFF', GradientType=1);";
//$style ="background-image:url(images/type2.jpg);";
}else{
// $color='#FFFF99';
$style = "background: -moz-linear-gradient(left, #FFFF99, #FFFFFF); background: -webkit-gradient(linear, left top, right top, from(#FFFF99), to(#FFFFFF)); filter: progid:DXImageTransform.Microsoft.Gradient(StartColorStr='#FFFF99', EndColorStr='#FFFFFF', GradientType=1);";
// $style ="background-image:url(images/type1.jpg);";
} ?>
<tr bgcolor="#ffffff">
<td align="center" style="<?=$style?>" > <div><?=number_format($rowNumb);?></div></td>
<td align="center" >
<?
if($ram[public_amphur]){
$strSQL="SELECT ccDigi,ccName,ccType FROM ccaa_pathumthani WHERE ccDigi='$ram[public_amphur]' limit 1 ";
$Result_CCAA =mysql_query("$strSQL");
if(@mysql_num_rows($Result_CCAA)>0){
$row_ccaa = mysql_fetch_assoc($Result_CCAA);
echo $row_ccaa[ccName];
}
}
?> </td>
<td align="center" >
<?
if($ram[public_tambol]){
$strSQL="SELECT ccDigi,ccName,ccType FROM ccaa_pathumthani WHERE ccDigi='$ram[public_tambol]' limit 1 ";
$Result_CCAA =mysql_query("$strSQL");
if(@mysql_num_rows($Result_CCAA)>0){
$row_ccaa = mysql_fetch_assoc($Result_CCAA);
echo $row_ccaa[ccName];
}
}
?> </td>
<?
$sql_type_pro = "SELECT * FROM tbl_type_request WHERE request_id ='$ram[type_request]'";
//echo $sql_type_pro;
$result_type_pro = @mysql_db_query($dbname,$sql_type_pro);
$rs_pro = @mysql_fetch_assoc($result_type_pro);
?>
<td><div><?=$rs_pro['type_request']?></div></td>
<td align="left"><div><A href="#" onClick="MM_openBrWindow('report_detail.php?runid=<?=$ram['complain_id']?>&type_user=pub&action=Ticket_ID','','status=yes,scrollbars=yes,resizable=yes,width=700,height=550')"><? echo LimitText($ram['complain_detail'],180)?></A></div></td>
<td align="center" ><div><?
if($ram[type_user] == "1"){
echo "<img src=\"../../images_sys/People-32.png\" width=\"16\" height=\"16\" title=\"ข้อมูลจากประชาชนบันทึก\">";
}else{
echo "<img src=\"../../images_sys/Client-32.png\" width=\"16\" height=\"13\" title='ข้อมูลจากหน่วยงานบันทึก'>";
}?></div></td>
<td align="center">
<?
$sql_main_menu= "SELECT * FROM pathumthani_integration.main_menu WHERE NID ='$ram[nid]' ";
$result_main_menu = mysql_db_query($dbname,$sql_main_menu);
$rs_main = mysql_fetch_assoc($result_main_menu);
if($ram['nid'] != "") {
echo $rs_main['NLABEL'];
} else {
echo "ไม่ระบุ";
}
?></td>
<td align="center"><?
if( ($ram['time_add']!="") && ($ram['time_add']!="0000-00-00")){
echo dateFormat($ram['time_add'],"thaidot");
} else {
echo "ไม่ระบุ";
}
?></td>
<td> <div align="center">
<?
$sql = "SELECT * FROM tbl_complain_approve WHERE complain_id ='$ram[complain_id]' ORDER BY runid DESC LIMIT 1";
//echo $sql_type_pro;
$result_type_pro = @mysql_db_query($dbname,$sql);
$rs_pro = @mysql_fetch_assoc($result_type_pro);
if( $rs_pro['date_accept'] != "0000-00-00" && $rs_pro['date_accept'] != ""){
echo dateFormat($rs_pro['date_accept'],"thaidot");
} else {
echo "ไม่ระบุ";
}
?></div></td>
<td align="center"><div>
<?
if($ram['status']=='1'){ ?>
<A href="#" onClick="MM_openBrWindow('report_detail2.php?runid=<?=$ram['complain_id']?>&type_user=pub&action=Ticket_ID','','status=yes,scrollbars=yes,resizable=yes,width=700,height=550')"><? echo "<img src=\"images/success.gif\" title=\"ให้ความช่วยเหลือแล้ว\" width=\"16\" height=\"16\" border=\"0\">"; ?></A>
<? }else{
echo "<img src=\"images/alert_icon.png\" title=\"ยังไม่ได้ให้ความช่วยเหลือ\" width=\"16\" height=\"16\" border=\"0\">";
}
?>
</div></td>
<td><div align="center">
<?php /*?><div><A href="#" onClick="MM_openBrWindow('report.php?runid=<?=$ram['complain_id']?>&type_user=pub&action=Ticket_ID','','status=yes,scrollbars=yes,resizable=yes,width=700,height=550')"><? echo "<img src=\"images/success.gif\" title=\"ให้ความช่วยเหลือแล้ว\" width=\"16\" height=\"16\" border=\"0\">"; ?></A></div><?php */?>
<?
if($ram['status']!='1'){
echo "<a href=\"?p=add_help.php&id=$ram[complain_id]\"><img src=\"images/department_add.gif\" title=\"ให้ความช่วยเหลือ\" width=\"16\" height=\"16\" border=\"0\"></a>";
} else {
echo "<a href=\"?p=add_help.php&id=$ram[complain_id]\"><img src=\"images/department_add2.gif\" title=\"ให้ความช่วยเหลือเรียบร้อย\" width=\"16\" height=\"16\" border=\"0\"></a>";
}
$link_edit = "<a href=\"?p=form_edit_data.php&action=EDIT&complain_id=$ram[complain_id]&type_user=gov&senttab=0\"><img src=\"../../images/document_edit.gif\" title=\"แก้ไขรายการ\" width=\"20\" height=\"20\" border=\"0\"></a>";
$link_del = " <a href=\"#\" ONCLICK=\"if (confirm('ต้องการลบข้อมูลนี้ใช่หรือไม่?')) location.href='?p=add.php&action=DEL&del_id=$ram[complain_id]&senttab=0'\"><img src=\"../../images/b_drop.png\" title=\"ลบรายการ\" width=\"16\" height=\"16\" border=\"0\"></a>";
echo $link_edit." ".$link_del;
?>
<?php /*?><IMG src="../../images_sys/pdf.gif" width="20" height="20" border="0" alt="แสดงรายงาน pdf" style="cursor:hand" onClick="location.href='view_pdf.php?coplain_id=<?=$rs_g[complain_id]?>'"><?php */?>
</div></td>
</tr>
<?
}
?>
</table></td>
</tr>
</table></td>
</tr>
</table>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><p><strong>หมายเหตุุ</strong></p>
<table width="777" border="0" cellpadding="0" cellspacing="2">
<tr>
<td width="17" bgcolor="#B50000"> </td>
<td width="161">:: ระดับความต้องการ มาก<span class="style2"></span></td>
<td colspan="4"> </td>
</tr>
<tr>
<td bgcolor="#FF9900"> </td>
<td>:: ระดับความต้องการ ปานกลาง</td>
<td width="17"><img src="images/alert_icon.png" border="0" align="absmiddle"></td>
<td width="200">:: ยังไม่ได้ดำเนินการช่วยเหลือ </td>
<td width="163"><img src="images/department_add.gif" height="18" border="0" align="absmiddle">::ให้ความช่วยเหลือ</td>
<td width="205"><img src="../../images_sys/useronline.gif" width="16" height="16" >ข้อมูลจากประชาชนบันทึก</td>
</tr>
<tr>
<td bgcolor="#FFFF99"> </td>
<td>:: ระดับความต้องการ น้อย</td>
<td><img src="images/success.gif" width="16" height="16" border="0" align="absmiddle"></td>
<td>:: ดำเนินการช่วยเหลือ เรียบร้อยเเล้ว </td>
<td><img src="images/department_add2.gif" width="17" height="16" border="0" align="absmiddle">::ให้ความช่วยเหลือเรียบร้อย</td>
<td> <img src="../../images_sys/person.gif" width="16" height="16" >ข้อมูลจากหน่วยงานบันทึก</td>
</tr>
</table>
<br>
<br></td>
</tr>
</table>
<?
//echo $strSQL;
//echo "<br>".$sql_district;
?>
</form>
</body>
</html>