|
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/ |
Upload File : |
<?
session_start();
include "../../config/config.inc.php";
include("function/function.php");
$senttab = 4; // ฟิกค่า tab
function LimitText($s,$n){
if (strlen($s) > $n){
$s = substr($s,0,$n) . "...";
}
return $s;
}
if(!isset($session_username)){
header("Location: ../document/login.php");
}
//insert timeQuery
include("../../common/common_system.inc.php");
$ApplicationName="ecomplain";
$time_start = getmicrotime();
//insert timeQuery
$app_id = "5"; // $app_id == 5 คือ ระบบติดตามความต้องการ
$app10 = "10"; // สิทธิ admin
$app100 = "100"; // บันทึกความต้องการ
$app200 = "200"; // ตรวจสอบความต้องการที่ได้รับจากประชาชน
$app300 = "300";// กำหนดหน่วยงานดำเนินการในแต่ละความต้องการ
$app400 = "400"; // ปรับปรุงความก้าวหน้า / สถานะของการตรวจสอบ แก้ไขตามข้อร้องเรียน
$app500 = "500"; // สิทธิสามารถเข้าดูรายงานความต้องการได้
//echo "app_id = = $app_id<br> app10 == $app10";
//echo "sess == ".$session_apppermit[$app_id][$app10];
$month_arr=array('','มกราคม','กุมภาพันธ์','มีนาคม','เมษายน','พฤษภาคม','มิถุนายน','กรกฏาคม','สิงหาคม','กันยายน','ตุลาคม','พฤศจิกายน','ธันวาคม');
if($action == "save_late"){
// update รายการทั้งหมด
$strSQL_sl = "UPDATE tbl_complain_approve SET date_late='$save_date_late'";
$Result_sl = mysql_db_query($dbname,$strSQL_sl);
echo "
<script language=\"javascript\">
location.href='report_index_admin.php?action=report_group&num=bt&senttab=4';
</script>
";
exit();
}
?>
<HTML>
<HEAD>
<TITLE><?=$show_title?></TITLE>
<META http-equiv="Content-Type" content="text/html; charset=windows-874">
<LINK href="../../common/style.css" rel=stylesheet>
<SCRIPT language='javascript' src='daily_popcalendar.js'></SCRIPT>
<SCRIPT language='javascript' src='displayelement.js'></SCRIPT>
<SCRIPT language='javascript' src='sorttable.js'></SCRIPT>
<SCRIPT type="text/javascript" src="tabber.js"></SCRIPT>
<STYLE type="text/css">
<!--
.header1 { font-family:"MS Sans Serif", Tahoma, Arial;
font-size:1em;
font-weight:bold;
color: #FFFFFF;
}
.main { font-family:"MS Sans Serif", Tahoma, Arial;
font-size:0.8em;
color:#FF0000;
font-weight:bold;
}
.normal { font-family:"MS Sans Serif", Tahoma, Arial;
font-size:0.8em;
}
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
.style5 {
font-size: 14px;
font-weight: bold;
}
-->
</STYLE>
<SCRIPT LANGUAGE="JavaScript">
document.write('<style type="text/css">.tabber{display:none;}<\/style>');
var tabberOptions = {
'onClick': function(argsObj) {
var t = argsObj.tabber; /* Tabber object */
var id = t.id; /* ID of the main tabber DIV */
var i = argsObj.index; /* Which tab was clicked (0 is the first tab) */
var e = argsObj.event; /* Event object */
if (id == 'tab2') {
// var lin = document.location.href="?senttab="+i ;
}
},
/* Optional: set an ID for each tab navigation link */
'addLinkId': true
};
function CheckForm(){
var f1 = document.form;
a = Number(f1.save_date_late.value) ;
missinginfo = "";
missinginfo1 = "";
if (document.form.save_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;
}
}
function popWindow(url, w, h){
var popup = "Popup";
if(w == "") w = 640;
if(h == "") h = 480;
var newwin = window.open(url, popup,'location=0,status=no,scrollbars=yes,resizable=no,width=' + w + ',height=' + h + ',top=20');
newwin.focus();
}
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
</SCRIPT>
</HEAD>
<BODY >
<? include("header_menu.php"); ?>
<TABLE width="100%" border="0" cellpadding="0" cellspacing="0" >
<TR>
<TD align="center" valign="top">
<TABLE width="550" border="0" cellspacing="1" cellpadding="1">
<TR>
<TD bgcolor="#000000">
<TABLE width="100%" border="0" cellpadding="3" cellspacing="0">
<TR>
<TD align="center" bgcolor="#BDC9F9"><SPAN class="style5">ตรวจสอบการติดตามงาน</SPAN></TD>
</TR>
<TR>
<TD align="center" bgcolor="#FFFFFF">
<FORM name="form" method="post" action="?" onSubmit="return CheckForm();">
<TABLE width="100%" border="0" cellspacing="0" cellpadding="0">
<?
$strSQL_keylate = "SELECT max(date_late) as late_max FROM tbl_complain_approve ";
$Result_keylate = mysql_db_query($dbname,$strSQL_keylate);
$rs = mysql_fetch_assoc($Result_keylate);
?>
<TR>
<TD width="40%" align="right" bgcolor="#FFFFFF">ระบุวันแจ้งเตือนก่อนดำเนินการเสร็จ</TD>
<TD width="24%" align="center" bgcolor="#FFFFFF"><LABEL>
<INPUT name="save_date_late" type="text" class="main" value="<?=$rs[late_max]?>" size="5">
วัน
</LABEL></TD>
<TD width="36%" align="left" bgcolor="#FFFFFF"><LABEL>
<INPUT type="hidden" name="action" value="save_late">
<INPUT type="submit" name="Submit2" value="บันทึกจำนวนวันแจ้งเตือน" >
</LABEL></TD>
</TR>
</TABLE>
</FORM>
</TD>
</TR>
<TR>
<TD align="right" bgcolor="#FFFFFF">
<FORM name="form2" method="post" action="">
<TABLE width="100%" border="0" cellspacing="0" cellpadding="2">
<?
$strSQL = "SELECT * FROM tbl_complain_approve ";
$Result = @mysql_db_query($dbname,$strSQL);
$num_all = @mysql_num_rows($Result);
?>
<TR>
<TD width="33" align="center" bgcolor="#FFFFFF"><IMG src="../../images/view_backup.gif" width="16" height="16"></TD>
<TD width="138" align="left" bgcolor="#FFFFFF">จำนวนเรื่องทั้งหมด</TD>
<TD colspan="2" align="center" bgcolor="#FFFFFF"> <A href="?action=report_group&num=all"><?=$num_all?></A></TD>
<TD width="135" align="center" bgcolor="#FFFFFF">รายการ</TD>
</TR>
<?
$c_md = date("m-d");
$c_y = date("Y")+543;
$c_date = $c_y."-".$c_md;
$strSQL1 = "SELECT
tbl_complain_approve.runid,
tbl_complain_approve.complain_id,
tbl_complain_approve.org_code,
tbl_complain_approve.subject,
tbl_complain_approve.subject_no_in,
tbl_complain_approve.subject_no_out,
tbl_complain_approve.subject_form,
tbl_complain_approve.person_res,
tbl_complain_approve.depart,
tbl_complain_approve.status_ceo,
tbl_complain_approve.date_ceosing,
tbl_complain_approve.date_start,
tbl_complain_approve.date_end,
tbl_complain_approve.date_late,
tbl_complain_approve.date_complate,
tbl_complain_approve.detail,
tbl_complain_approve.attach_sb_in,
tbl_complain_approve.attach_sb_out,
tbl_complain_approve.attach_date_comp,
tbl_complain_approve.type_problem,
tbl_complain_approve.office_id,
tbl_complain_approve.accept_date,
tbl_complain_approve.ministry,
tbl_complain_approve.department,
tbl_complain_approve.owner_id
FROM
tbl_complain_approve
Inner Join tbl_complain_sent ON tbl_complain_approve.runid = tbl_complain_sent.com_app_id
WHERE tbl_complain_approve.date_complate = '0000-00-00' or tbl_complain_approve.date_complate IS NULL
GROUP BY
tbl_complain_sent.com_app_id";
$Result1 = mysql_db_query($dbname,$strSQL1);
$n=0;
$num_late = 0;
$date_start_c = date("Y-m-d");
$type_time = "d";
while($rs1 = mysql_fetch_assoc($Result1)){
$check_status = Check_subject_count($date_start_c,$rs1[date_end],$type_time);
if($check_status <= $rs1[date_late]){
$num_late++;
}
}
?>
<TR>
<TD align="center" bgcolor="#FFFFFF"><IMG src="../../images/view_backup.gif" width="16" height="16"></TD>
<TD align="left" bgcolor="#FFFFFF">จำนวนเรื่องที่อยู่ระหว่างดำเนินการ</TD>
<TD colspan="2" align="center" bgcolor="#FFFFFF"><? if($num_late < 1){ echo $num_late ; }else{?><A href="?action=report_group&num=late"><?=$num_late?></A><? }?></TD>
<TD align="center" bgcolor="#FFFFFF">รายการ</TD>
</TR>
<?
$strSQL3 = "SELECT COUNT(*) AS num_comp FROM tbl_complain_approve WHERE date_complate <> '0000-00-00' AND date_complate IS NOT NULL ";
$Result3 = mysql_db_query($dbname,$strSQL3);
$rs3 = mysql_fetch_assoc($Result3);
?>
<TR>
<TD align="center" bgcolor="#FFFFFF"><IMG src="../../images/view_backup.gif" width="16" height="16"></TD>
<TD align="left" bgcolor="#FFFFFF">จำนวนเรื่องที่สำเร็จ</TD>
<TD colspan="2" align="center" bgcolor="#FFFFFF">
<?
if($rs3[num_comp] > 0){
?>
<A href="?action=report_group&num=comp">
<?=$rs3[num_comp]?>
</A>
<?
}else{
echo $rs3[num_comp];
}
?> </TD>
<TD align="center" bgcolor="#FFFFFF">รายการ</TD>
</TR>
<TR>
<TD align="center" bgcolor="#FFFFFF"> </TD>
<TD align="left" bgcolor="#FFFFFF"> </TD>
<TD colspan="2" align="center" bgcolor="#FFFFFF"> </TD>
<TD align="center" bgcolor="#FFFFFF"> </TD>
</TR>
<TR>
<TD rowspan="2" align="center" valign="middle" bgcolor="#FFFFFF"><IMG src="../../images/view_backup.gif" width="16" height="16"></TD>
<TD rowspan="2" align="left" bgcolor="#FFFFFF">แสดงรายงานตามช่วงเวลา </TD>
<TD width="211" align="left" bgcolor="#FFFFFF"><INPUT name="date_s" type="text" onFocus="blur();" value="<?=$date_s?>" size="15" readonly>
<INPUT name="button2" type="button" style='font-size:11px; width:80px;' onClick="popUpCalendar(this, form.date_s, 'dd/mm/yyyy')" value='วันเดือนปี'>
</TD>
<TD width="23" rowspan="2" align="left" valign="middle" bgcolor="#FFFFFF">ถึง </TD>
<TD rowspan="2" align="center" valign="middle" bgcolor="#FFFFFF"><LABEL>
<INPUT type="submit" name="Submit" value="แสดงรายการ">
<INPUT type="hidden" name="action" value="report_group">
<INPUT type="hidden" name="num" value="bt">
</LABEL></TD>
</TR>
<TR>
<TD align="left" bgcolor="#FFFFFF"><INPUT name="date_e" type="text" onFocus="blur();" value="<?=$date_e?>" size="15" readonly>
<INPUT name="button" type="button" style='font-size:11px; width:80px;' onClick="popUpCalendar(this, form.date_e, 'dd/mm/yyyy')" value='วันเดือนปี'></TD>
</TR>
<TR>
<TD colspan="5" align="center" valign="middle" bgcolor="#FFFFFF">
<? // if(Check_menu($session_status_pri)){?>
<TABLE width="100%" border="0" cellspacing="0" cellpadding="3">
<TR>
<TD colspan="2" align="center" bgcolor="#FFFFFF"> </TD>
</TR>
<TR>
<TD colspan="2" align="center" bgcolor="#FFFFFF"><A href="report_main.php" target="_self">รายงานสถิติความต้องการ</A></TD>
</TR>
<TR>
<TD width="6%" align="center" bgcolor="#FFFFFF"> </TD>
<TD width="94%" bgcolor="#FFFFFF"> </TD>
</TR>
</TABLE>
<?
//}
?> </TD>
</TR>
</TABLE>
</FORM>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
<TR valign="top">
<TD> </TD>
</TR>
<TR valign="top">
<TD>
<?
if($action == "report_group"){
if($num == "bt"){
if($date_s != "" and $date_e != ""){
$arr_ds = explode("/",$date_s);
$where_date_s = ($arr_ds[2]-543)."-".$arr_ds[1]."-".$arr_ds[0];
$arr_de = explode("/",$date_e);
$where_date_e = ($arr_de[2]-543)."-".$arr_de[1]."-".$arr_de[0];
$strSQL_group = "SELECT
tbl_complain.type_request,
tbl_complain.type_request_other,
tbl_complain.public_name,
tbl_complain.status_show_owner,
tbl_complain_approve.subject,
tbl_complain_approve.runid,
tbl_complain_approve.subject_no_in,
tbl_complain_approve.subject_no_out,
tbl_complain_approve.attach_sb_in,
tbl_complain_approve.attach_sb_out,
tbl_complain_approve.attach_date_comp,
tbl_complain_approve.type_problem,
tbl_complain_approve.office_id,
tbl_complain_sent.org_id,
tbl_complain_sent.org_main,
tbl_complain_approve.date_start,
tbl_complain_approve.date_end,
tbl_complain_approve.date_late,
tbl_complain_approve.date_complate,
tbl_complain_sent.owner_id
FROM
tbl_complain
Inner Join tbl_complain_approve ON tbl_complain.complain_id = tbl_complain_approve.complain_id
Inner Join tbl_complain_sent ON tbl_complain_approve.runid = tbl_complain_sent.com_app_id
WHERE tbl_complain_approve.date_start >= '$where_date_s' AND tbl_complain_approve.date_end <= '$where_date_e'
GROUP BY
tbl_complain_sent.com_app_id ORDER BY tbl_complain_approve.runid DESC ";
}else{
$strSQL_group = "SELECT
tbl_complain.type_request,
tbl_complain.type_request_other,
tbl_complain.public_name,
tbl_complain.status_show_owner,
tbl_complain_approve.subject,
tbl_complain_approve.runid,
tbl_complain_approve.subject_no_in,
tbl_complain_approve.subject_no_out,
tbl_complain_approve.attach_sb_in,
tbl_complain_approve.attach_sb_out,
tbl_complain_approve.attach_date_comp,
tbl_complain_approve.type_problem,
tbl_complain_approve.office_id,
tbl_complain_sent.org_id,
tbl_complain_sent.org_main,
tbl_complain_approve.date_start,
tbl_complain_approve.date_end,
tbl_complain_approve.date_late,
tbl_complain_approve.date_complate,
tbl_complain_sent.owner_id
FROM
tbl_complain
Inner Join tbl_complain_approve ON tbl_complain.complain_id = tbl_complain_approve.complain_id
Inner Join tbl_complain_sent ON tbl_complain_approve.runid = tbl_complain_sent.com_app_id
GROUP BY
tbl_complain_sent.com_app_id ORDER BY tbl_complain_approve.runid DESC ";
}
}else if($num == "all"){
$strSQL_group = "SELECT
tbl_complain.type_request,
tbl_complain.type_request_other,
tbl_complain.public_name,
tbl_complain.status_show_owner,
tbl_complain_approve.subject,
tbl_complain_approve.runid,
tbl_complain_approve.subject_no_in,
tbl_complain_approve.subject_no_out,
tbl_complain_approve.attach_sb_in,
tbl_complain_approve.attach_sb_out,
tbl_complain_approve.attach_date_comp,
tbl_complain_approve.type_problem,
tbl_complain_approve.office_id,
tbl_complain_sent.org_id,
tbl_complain_sent.org_main,
tbl_complain_approve.date_start,
tbl_complain_approve.date_end,
tbl_complain_approve.date_late,
tbl_complain_approve.date_complate,
tbl_complain_sent.owner_id
FROM
tbl_complain
Inner Join tbl_complain_approve ON tbl_complain.complain_id = tbl_complain_approve.complain_id
Inner Join tbl_complain_sent ON tbl_complain_approve.runid = tbl_complain_sent.com_app_id
GROUP BY
tbl_complain_sent.com_app_id ORDER BY tbl_complain_approve.runid DESC ";
}else if($num == "comp"){
$strSQL_group = "SELECT
tbl_complain.type_request,
tbl_complain.type_request_other,
tbl_complain.public_name,
tbl_complain.status_show_owner,
tbl_complain_approve.subject,
tbl_complain_approve.runid,
tbl_complain_approve.subject_no_in,
tbl_complain_approve.subject_no_out,
tbl_complain_approve.attach_sb_in,
tbl_complain_approve.attach_sb_out,
tbl_complain_approve.attach_date_comp,
tbl_complain_approve.type_problem,
tbl_complain_approve.office_id,
tbl_complain_sent.org_id,
tbl_complain_sent.org_main,
tbl_complain_approve.date_start,
tbl_complain_approve.date_end,
tbl_complain_approve.date_late,
tbl_complain_approve.date_complate,
tbl_complain_sent.owner_id
FROM
tbl_complain
Inner Join tbl_complain_approve ON tbl_complain.complain_id = tbl_complain_approve.complain_id
Inner Join tbl_complain_sent ON tbl_complain_approve.runid = tbl_complain_sent.com_app_id
WHERE tbl_complain_approve.date_complate <> '0000-00-00' AND tbl_complain_approve.date_complate IS NOT NULL
GROUP BY
tbl_complain_sent.com_app_id ORDER BY tbl_complain_approve.runid DESC ";
}else if($num == "late"){
$strSQL_group = "SELECT
tbl_complain.type_request,
tbl_complain.type_request_other,
tbl_complain.public_name,
tbl_complain.status_show_owner,
tbl_complain_approve.subject,
tbl_complain_approve.runid,
tbl_complain_approve.subject_no_in,
tbl_complain_approve.subject_no_out,
tbl_complain_approve.attach_sb_in,
tbl_complain_approve.attach_sb_out,
tbl_complain_approve.attach_date_comp,
tbl_complain_approve.type_problem,
tbl_complain_approve.office_id,
tbl_complain_sent.org_id,
tbl_complain_sent.org_main,
tbl_complain_approve.date_start,
tbl_complain_approve.date_end,
tbl_complain_approve.date_late,
tbl_complain_approve.date_complate,
tbl_complain_sent.owner_id
FROM
tbl_complain
Inner Join tbl_complain_approve ON tbl_complain.complain_id = tbl_complain_approve.complain_id
Inner Join tbl_complain_sent ON tbl_complain_approve.runid = tbl_complain_sent.com_app_id
WHERE tbl_complain_approve.date_complate = '0000-00-00' AND tbl_complain_approve.date_complate IS NULL
GROUP BY
tbl_complain_sent.com_app_id ORDER BY tbl_complain_approve.runid DESC ";
}else{
$strSQL_group = "SELECT
tbl_complain.type_request,
tbl_complain.type_request_other,
tbl_complain.public_name,
tbl_complain.status_show_owner,
tbl_complain_approve.subject,
tbl_complain_approve.runid,
tbl_complain_approve.subject_no_in,
tbl_complain_approve.subject_no_out,
tbl_complain_approve.attach_sb_in,
tbl_complain_approve.attach_sb_out,
tbl_complain_approve.attach_date_comp,
tbl_complain_approve.type_problem,
tbl_complain_approve.office_id,
tbl_complain_sent.org_id,
tbl_complain_sent.org_main,
tbl_complain_approve.date_start,
tbl_complain_approve.date_end,
tbl_complain_approve.date_late,
tbl_complain_approve.date_complate,
tbl_complain_sent.owner_id
FROM
tbl_complain
Inner Join tbl_complain_approve ON tbl_complain.complain_id = tbl_complain_approve.complain_id
Inner Join tbl_complain_sent ON tbl_complain_approve.runid = tbl_complain_sent.com_app_id
GROUP BY
tbl_complain_sent.com_app_id ORDER BY tbl_complain_approve.runid DESC ";
}
//echo $strSQL_group;
?>
<TABLE width="100%" border="0" cellspacing="0" cellpadding="0">
<TR>
<TD align="left">
<TABLE width="99%" border="0" cellpadding="3" cellspacing="1" bgcolor="#666666" class="sortable" id="table0">
<TR onMouseOver="this.style.cursor='hand'; this.style.background='#EFEFEF';" onMouseOut="this.style.cursor='point'; this.style.background='#FFFFFF';">
<TD width="4%" align="center" bgcolor="#BDC9F9"><STRONG>ลำดับ</STRONG></TD>
<TD width="14%" align="center" bgcolor="#BDC9F9"><STRONG>ชื่อเรื่อง</STRONG></TD>
<TD width="12%" align="center" bgcolor="#BDC9F9"><STRONG>ไฟล์แนบหนังสือเข้า</STRONG></TD>
<TD width="12%" align="center" bgcolor="#BDC9F9"><STRONG>เลขที่หนังสือออก</STRONG></TD>
<TD width="12%" align="center" bgcolor="#BDC9F9"><STRONG>หน่วยงานรับเรื่อง</STRONG></TD>
<TD width="14%" align="center" bgcolor="#BDC9F9"><STRONG>หน่วยงานดำเนินการ</STRONG></TD>
<TD width="15%" align="center" bgcolor="#BDC9F9"><STRONG>หน่วยงานเจ้าภาพ</STRONG></TD>
<TD width="12%" align="center" bgcolor="#BDC9F9"><STRONG>การดำเนินการ</STRONG></TD>
<TD width="5%" align="center" bgcolor="#BDC9F9"><STRONG>สถานะ</STRONG></TD>
</TR>
<?
$Result_group = mysql_db_query($dbname,$strSQL_group);
$kk = 0;
while($Rs_g = mysql_fetch_assoc($Result_group)){
$bg_color = ($i%2)?'#F1F1F1':'FFFFFF';$kk++;
$date_start_c = date("Y-m-d");
$type_time = "d";
$check_status = Check_subject_late($date_start_c,$Rs_g[date_end],$type_time,$Rs_g[runid]);
//echo $check_status;
if(($Rs_g[date_complate] == "0000-00-00" OR $Rs_g[date_complate] == NULL)){ $img = "<img src=\"../../images/notapprove.gif\" width=\"16\" height=\"16\" border=\"0\" alt='ยังไม่ดำเนินการ'>";}else if($Rs_g[date_complate] != "0000-00-00" and $Rs_g[date_complate] != NULL){ $img = "<img src=\"../../images/approve20.png\" width=\"16\" height=\"16\" border=\"0\" alt='ดำเนินการเรียบร้อยแล้ว'>";}else{ $img = "<img src=\"../../images/alert.gif\" width=\"16\" height=\"16\" border=\"0\" alt='อยู่ระหว่างการดำเนินการ'>";}
//echo $check_status;
//echo $Rs_g[date_complate];
?>
<TR bgcolor="<? if(($check_status == 1) and ($Rs_g[date_complate] =="0000-00-00" or $Rs_g[date_complate] == NULL)){ echo"#FFF4B9";}else{ echo $bg_color;}?>">
<TD align="center"><?=$kk?></TD>
<TD align="left"><A href="report_detail_admin.php?runid=<?=$Rs_g[runid]?>" target="_blank" ><? echo LimitText($Rs_g[subject],30);?></A></TD>
<TD align="left"><?=$Rs_g[subject_no_in]?><? if($Rs_g[attach_sb_in] != "" or $Rs_g[attach_sb_in] != NULL ){ echo "<a href='$Rs_g[attach_sb_in]' target='_blank'><img src=\"../../images/attach16.gif\" width=\"16\" height=\"16\" border=\"0\">เรียกดู</a>";}?></TD>
<TD align="left"><?=$Rs_g[subject_no_out]?>
<? if($Rs_g[attach_sb_out] != "" or $Rs_g[attach_sb_out] != NULL ){ echo "<a href='$Rs_g[attach_sb_out]' target='_blank'><img src=\"../../images/attach16.gif\" width=\"16\" height=\"16\" border=\"0\"></a>";}?></TD>
<TD align="left">
<?
$sql_owner = "SELECT
org_staffgroup.groupname
FROM
epm_staff
Inner Join org_groupmember ON epm_staff.staffid = org_groupmember.staffid
Inner Join org_staffgroup ON org_groupmember.gid = org_staffgroup.gid
WHERE
epm_staff.staffid = '$Rs_g[owner_id]'";
$result_owner = mysql_db_query($dbname,$sql_owner);
$rs_o = mysql_fetch_assoc($result_owner);
echo $rs_o[groupname];
?>
</TD>
<TD align="left"><?
$sql_org1 = "SELECT
org_staffgroup.groupname
FROM
tbl_complain_sent
Inner Join org_staffgroup ON tbl_complain_sent.org_id = org_staffgroup.gid WHERE com_app_id='$Rs_g[runid]'";
//echo $sql_org1;
$result_org1 = mysql_db_query($dbname,$sql_org1);
$nn = 0;
while($rs_o1 = mysql_fetch_assoc($result_org1)){
$nn++;
// if($xtxt_org1 > ""){$xtxt_org1 .= ",";}
// $xtxt_org1 .= $rs_o1[groupname] ;
if($nn > 1){
if($rs_o1[groupname] > ""){
echo ",";
}
} // end if($nn > 1){
echo $rs_o1[groupname];
}
//echo "$xtxt_org1";
?></TD>
<TD align="left">
<?
$sql_org2 = "SELECT
org_staffgroup.groupname
FROM
tbl_complain_sent
Inner Join org_staffgroup ON tbl_complain_sent.org_main = org_staffgroup.gid WHERE com_app_id='$Rs_g[runid]' GROUP BY tbl_complain_sent.org_main";
$result_org2 = mysql_db_query($dbname,$sql_org2);
$rs_o2 = mysql_fetch_assoc($result_org2);
echo $rs_o2[groupname];
?>
</TD>
<TD align="center"><IMG src="../../images/worker.png" width="20" height="20" border="0" alt="คลิ๊กเพื่อดูการดำเนินการของความต้องการ" style="cursor:hand" onClick="MM_openBrWindow('popup_process.php?runid=<?=$Rs_g[runid]?>','','width=700,height=500,scrollbars=Yes,resizable=Yes,status=Yes')"></TD>
<TD align="center"><?=$img?></TD>
</TR>
<?
}
?>
</TABLE>
</TD>
</TR>
</TABLE>
<?
}
?>
</TD>
</TR>
<TR>
<TD> </TD>
</TR>
</TABLE>
</BODY>
</HTML>
<?
//insert timeQuery
$time_end = getmicrotime();
writetime2db($timestart,$timeend);
//insert timeQuery
?>