|
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/agenda/ |
Upload File : |
<?
//=========================================
// Select document type where status is '1'
// @author Kridsada Satakarn
// @date 2009/06/20
// @return a array of list document type where status is '1'
//=
###################################################################
## AGENDA MAIN PAGE : E-OFFICE PATHUMTHANI
###################################################################
## Version : 20090620.001 (Created/Modified; Date.RunNumber)
## Created Date : 2009-06-20 hh:mm
## Created By : Kridsada Satakarn (JENG)
## E-mail :
## Tel. :
## Company : Sappire Research and Development Co.,Ltd. (C)All Right Reserved
###################################################################
##
## Version : 20091110.002
## Modified Detail: MODIFY DASH BOARD , CONVERT DATE THAI -> ENG
## Modified Date : 2009-11-10 13:00
## Modified By : Mr.PUDIS PROMSRI (PAAK)
##
###################################################################
session_start();
include("../../config/config.inc.php");
//include("function/function.php");
include("../../common/function.php");
include("function.listfile.php");
if(!isset($session_username)){
header("Location:login.php");
}
$sql="select varvalue from eoffice_config where appid='14' and modual_name='meeting_report' and varname='approve' " ;
//echo $sql;
$result =mysql_db_query($dbname,$sql);
$row=mysql_fetch_array($result );
$approveshow=$row[varvalue];
$sql="select * from eoffice_config where appid='14' " ;
//echo $sql;
$result =mysql_db_query($dbname,$sql);
while($rows=mysql_fetch_assoc($result )){
$app_config[$rows[modual_name]]=$rows[varvalue];
}
function selectFiles($sub_id, $id_type)
{
$path = "attach_file/agenda/";
$add_cond = "";
if($id_type >= 0)
{
$add_cond = " AND id_type = ". $id_type;
}
$arr = array();
$sql = "SELECT
tbl_attach_file.attach_file,
tbl_attach_file.run_id,
tbl_attach_file.comment
FROM
tbl_attach_file
WHERE
tbl_attach_file.id_attach_file = '$sub_id' $add_cond order by run_id ASC";
$query = mysql_query($sql);
# echo $sql ;
if($rs = mysql_fetch_array($query))
{
# $arrfile= trim($rs[attach_file]) ;
$arrfile= ($rs[attach_file]) ;
$pathx = $path . $arrfile ;
# $arrcomment=( $rs[comment]=="")?$arrfile:$rs[comment];
if ($rs[comment]=="" ){ $arrcomment=$arrfile ; } else { $arrcomment=$rs[comment] ; }
return "<a href=\"download.php?path=$pathx&filename=$arrfile\" target='fdownload' >".$arrcomment."</a>";
}else{
return "-";
}
}
//========================================
//===========================================
/**
* Recursively delete a directory
*
* @param string $dir Directory name
* @param boolean $deleteRootToo Delete specified top-level directory as well
*/
function delDIR($dir, $deleteRootToo)
{
if(!$dh = @opendir($dir))
{
return;
}
while (false !== ($obj = readdir($dh)))
{
if($obj == '.' || $obj == '..')
{
continue;
}
if (!@unlink($dir . '/' . $obj))
{
delDIR($dir.'/'.$obj, true);
}
}
closedir($dh);
if ($deleteRootToo)
{
@rmdir($dir);
}
return;
}
//===========================================
// Variable
//===========================================
/*function selectDocType()
{
$arr = array();
$sql = "SELECT
tbl_main_menu.id_menu,
tbl_main_menu.name_menu
FROM
tbl_main_menu
WHERE
tbl_main_menu.status_menu = '1'
ORDER BY tbl_main_menu.id_menu ASC";
$query = mysql_query($sql);
while($rs = mysql_fetch_assoc($query))
{
$arr[$rs[id_menu]] = $rs[name_menu];
}
return $arr;
}*/
$docType = selectDocType();
$month_arr=array('','มกราคม','กุมภาพันธ์','มีนาคม','เมษายน','พฤษภาคม','มิถุนายน','กรกฏาคม','สิงหาคม','กันยายน','ตุลาคม','พฤศจิกายน','ธันวาคม');
$smonth_arr=array('','ม.ค.','ก.พ.','มี.ค.','เม.ย.','พ.ค.','มิ.ย.','ก.ค.','ส.ค.','ก.ย.','ต.ค.','พ.ค.','ธ.ค.');
$folder = "attach_file/";
$path_temp = "attach_file/agenda/";
//===================================================================================================
if($_POST)
{
$time_start = $_POST[formhh1]. ":" . $_POST[formmm1]. ":00";
$time_end = $_POST[formhh2]. ":" . $_POST[formmm2]. ":00";
$conf=$_POST[conf];
$finish_date=swapdate($finish_date);
$date_create=swapdate($date_create);
$meeting_date=swapdate($meeting_date);
if($_POST[hAction] == "ADD")
{
$strSQL_in = "
INSERT INTO tbl_subject (
subject,
main,
noorder,
date_create,
meeting_date,
time_start,
time_end,
location,
detail,
status_sub,
org_owner,
org_phone ,
finish_date
)VALUES(
'$subject',
'$chair_main',
'$noorder',
'$date_create',
'$meeting_date',
'$time_start',
'$time_end',
'$location',
'$detail',
'$status',
'$org_owner',
'$org_phone',
'$finish_date'
)";
//echo "<pre>$strSQL_in</pre>";die;
$Result_in = mysql_db_query($dbname,$strSQL_in);
$last = mysql_insert_id();
if($conf){
$sql="Update tbl_subject set confirm='$xtype', confirmby='$_SESSION[session_staffid]' where id_sub='$last'";
mysql_query($sql);
$sql="insert into tbl_subject_approve(id_subject,approve_type,comment_detail,comment_by,comment_date) values('$last','$conf','','$_SESSION[session_staffid]',NOW())";
mysql_query($sql);
}
$rs = true;
$arr_tempfile = $_POST[tempfile];
if($_POST[tempfile]){
foreach($arr_tempfile as $key=>$values)
{
$arr_file= explode(":",$values);
$sql = "INSERT INTO tbl_attach_file(id_attach_file, id_type, attach_file, status_file,comment) VALUES ('$last', '$arr_file[0]', '$arr_file[1]', 'Y','$arr_file[2]')";
$rs = mysql_db_query($dbname,$sql);
}
}
if($Result_in && $rs)
{
echo "
<script language=\"javascript\">
location.href='report_index.php?action=Sreport&id_menu=$id_menu&name_menu=$name_menu';
</script>
";
exit();
}else{
}
echo "
<script language=\"javascript\">
location.href='report_index.php?action=Sreport&id_menu=$id_menu&name_menu=$name_menu';
</script>
";
exit();
}else if($_POST[hAction] == "EDIT")
{
$strSQL_update = "UPDATE tbl_subject SET subject='$subject', main='$chair_main', noorder='$noorder', date_create='$date_create', meeting_date='$meeting_date', time_start='$time_start' , time_end='$time_end', location='$location', detail='$detail', status_sub=$status, org_owner='$org_owner', org_phone='$org_phone',confirm='$conf' ,finish_date='$finish_date' WHERE id_sub='$id_up'";
$Result_update = mysql_db_query($dbname,$strSQL_update);
if($Result_update)
{
echo "
<script language=\"javascript\">
location.href='report_index.php?action=Sreport&id_menu=$id_menu&name_menu=$name_menu&page=$page';
</script>
";
exit();
}
}
}
//------------------ลบรายการ -----------------
if($action == "DEL_DATA"){
// ลบไฟล์
delDIR("$folder$id", true);
//ลบข้อมุลในตารางไฟล์แนบ
$strSQL2 = "DELETE FROM tbl_attach_file WHERE id_attach_file='$id'";
$Result2 = mysql_db_query($dbname,$strSQL2);
// ลบรายการ subject
$strSQL3 = "DELETE FROM tbl_subject WHERE id_sub='$id'";
$Result3 = mysql_db_query($dbname,$strSQL3);
if($Result3){
echo "
<script language=\"javascript\">
location.href='report_index.php?action=Sreport&id_menu=$id_menu&name_menu=$name_menu';
</script>
";
exit();
}
}
?>
<html>
<head>
<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 language='javascript' src='jquery.js'></script>
<script language="javascript">
var approveshow='<?=$approveshow?>';
function confirmdel(){
if(!confirm('ต้องการลบข้อมูลหรือไม่')){ return false}
}
function genXHR()
{
var xmlHttp=null;
try{
// Firefox, Opera 8.0+, Safari
xmlHttp=new XMLHttpRequest();
}catch (e){
// Internet Explorer
try{
xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
}catch (e){
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttp;
}
function showLoading()
{
var div = document.getElementById("divUpload");
div.innerHTML = "<img src=\"images/indicator.gif\" border=\"0\" > กำลังอัพโหลดไฟล์";
}
function findIndex(arr, str)
{
var index = -1;
if(arr.length > 0)
{
for(i = 0; i < arr.length ; i++)
{
if(arr[i] == str)
{
index = i;
}
}
}
return index;
}
function getSelTxt(sel, val)
{
var str = "";
for(var i=0; i < sel.length ; i++)
{
if(sel.options[i].value == val)
{
str = sel.options[i].text;
break;
}
}
return str;
}
function delFile(action, filename, timestamp, rid, id_sub)
{
if(!confirm('ต้องการลบรูปหรือไม่')){ return false}
var hLF = document.getElementById("hListFiles");
var hDT = document.getElementById("hDocType");
var hTS = document.getElementById("hTimeStamp");
var divList = document.getElementById("divListFiles");
var selDocType = window.frames['uploadtarget'].document.getElementById('selDocType');
j=genXHR();
j.onreadystatechange=function()
{
if (j.readyState==4 || j.readyState=="complete")
{
var result = j.responseText;
if(result != "")
{
if(action == "DEL_TEMP")
{
var path_temp = "attach_file/temp/";
var arr_lf = hLF.value.split(";");
var arr_ts = hTS.value.split(";");
var arr_dt = hDT.value.split(";");
var index = findIndex(arr_lf, result);
arr_lf.splice(index, 1);
arr_ts.splice(index, 1);
arr_dt.splice(index, 1);
divList.innerHTML = "";
var show = "";
var doc_type = "";
for(var i = 0; i< arr_lf.length-1 ; i++)// length - 1 เพราะว่า hLF.value มี ; อยู่สุดท้ายอีกหนึ่งตัว
{
doc_type = getSelTxt(selDocType, arr_dt[i]);
str_add = "<a href=\"download.php?path=" +path_temp + arr_ts[i] + arr_lf[i] + "&filename=" + arr_lf[i] +"\" target='fdownload' >" + arr_lf[i]+"</a><a href=\"#\" onclick=\"delFile('DEL_TEMP', '" + arr_lf[i] +"', '" + arr_ts[i] + "', '-1', '-1')\" ><img src=\"images/delete.gif\" width=\"15\" height=\"15\" alt=\"ลบไฟล์\" border=\"0\" > </a><BR><!--t" + arr_dt[i] + "-->";
if(show.search("<!--t" + arr_dt[i] + "-->") != -1)
{
show = show.replace("<!--t" + arr_dt[i] + "-->" , str_add);
}else
{
show += "<b>" + doc_type + "</b><BR>" + str_add;
}
}
divList.innerHTML = show;
hLF.value = arr_lf.join(";");
hTS.value = arr_ts.join(";");
hDT.value = arr_dt.join(";");
}else if(action == "DEL")
{
upListFile("del",'', '', rid, id_sub,id_sub, rid )
}
}
}
}
j.open("GET","ajax_delfile.php?action=" + action + "&filename=" + filename + "×tamp=" + timestamp + "&rid=" + rid + "&id_sub=" + id_sub);
j.send(null);
}
function upListFile(action,filename, path, id_sub, id_type,filenameorg, rid )
{
$('#divUpload').empty();
if(action=="add"){
str ="<div id=\"sub_"+id_sub+"\"><a href=\"download.php?path="+path+"&filename="+filename+"\" target=\"fdownload\" >"+filenameorg+"</a>\n";
str +="<a href=\"#\"onclick=\"delFile('DEL', '"+filename+"','' , '"+id_sub+"' ,'"+ id_type+"')\"><img src=\"images/delete.gif\"width=\"15\" height=\"15\" alt=\"ลบไฟล์\" border=\"0\"></a></div>\n";
str +="<input name=\"tempfile[]\" type=\"hidden\" value=\""+id_type+":"+filename+":"+filenameorg+"\" />";
$('#mode_'+id_type).append(str)
if(id_type==3&&approveshow=="on"){
strbut="<input name=\"confirm\" type=\"button\" onclick =\"formE.conf.value=1\" value=\"รับรองการประชุม\" style=\"font-size:12px;width:150px;height:20px\"/>";
$('#button').empty().append(strbut) ;
}
}else if(action=="del"){
$('#sub_'+id_sub).remove()
var d=document.getElementById('mode_'+id_type).getElementsByTagName('div')
if(id_type==3)
{
if(!d){
$('#conf').val(0);
$('#button').empty();
}else{
if(d.length==0){
$('#conf').val(0);
$('#button').empty();
}
}
}
}
}
</script>
<style type="text/css">
.page {
font : 9px tahoma;
font-weight : bold;
color : #0280D5;
padding : 1px 3px 1px 3px;
}
.pagelink {
font : 9px tahoma;
font-weight : bold;
color : #000000;
text-decoration : underline;
padding : 1px 3px 1px 3px;
}
.go {
BORDER: #59990e 1px solid;
PADDING-RIGHT: 0.38em;
PADDING-LEFT: 0.38em;
FONT-WEIGHT: bold;
FONT-SIZE: 105%;
BACKGROUND: url(../hr3/hr_report/images/hdr_bg.png) #6eab26 repeat-x 0px -90px;
FLOAT: left;
PADDING-BOTTOM: 0px;
COLOR: #fff;
MARGIN-RIGHT: 0.38em;
PADDING-TOP: 0px;
HEIGHT: 1.77em
}
#bf .go {
FLOAT: none
}
.go:hover {
BORDER: #3f8e00 1px solid;
BACKGROUND: url(../hr3/hr_report/images/hdr_bg.png) #63a218 repeat-x 0px -170px;
}
.q {
BORDER-RIGHT: #5595CC 1px solid;
PADDING-RIGHT: 0.7em;
BORDER-TOP: #5595CC 1px solid;
PADDING-LEFT: 0.7em;
FONT-WEIGHT: normal; FONT-SIZE: 105%;
FLOAT: left;
PADDING-BOTTOM: 0px;
MARGIN: 0px 0.38em 0px 0px;
BORDER-LEFT: #5595CC 1px solid;
WIDTH: 300px;
PADDING-TOP: 0.29em;
BORDER-BOTTOM: #5595CC 1px solid;
HEIGHT: 1.39em
}
.tabberlive .tabbertab {
background-color:#FFFFFF;
height:200px;
}
</style>
<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;
}
.style1 {color: #FF0000}
-->
</style>
<script language="javascript">
function popWindow(url, w, h){
var popup = "Popup";
if(w == "") w = 550;
if(h == "") h = 450;
var newwin = window.open(url, popup,'location=0,status=no,scrollbars=no,resizable=yes,width=' + w + ',height=' + h + ',top=20');
newwin.focus();
}
</script>
</head>
<body>
<? include("header_menu.php"); ?>
<table width="100%" border="0" cellpadding="0" cellspacing="0" style="filter:progid:DXImageTransform.Microsoft.Gradient(GradientType=0, StartColorStr='#144C85', EndColorStr='#ffffff');">
<tr>
<td align="center" valign="top" bgcolor="#999999">
<?
if($action == "Sreport"){
//---------------------------------start function ---------------------------------------------
function devidepage($total, $kwd , $sqlencode ){
$per_page = 11;
$page_all = $total;
global $page,$id_menu,$name_menu;
if($total >= 1){
$table = "<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">";
$table = $table."<tr align=\"right\">";
$table = $table."<td width=\"80%\" align=\"left\" height=\"30\"> ";
if($page_all <= $per_page){
$min = 1;
$max = $page_all;
} elseif($page_all > $per_page && ($page - 5) >= 2 ) {
$min = $page - 5;
$max = (($page + 5) > $page_all) ? $page_all : $page + 5;
} else {
$min = 1;
$max = $per_page;
}
if($min >= 4){
$table .= "<a href=\"?action=Sreport&id_menu=$id_menu&name_menu=$name_menu&page=1&displaytype=people".$kwd."\"><u><font color=\"black\">หน้าแรก</font></u></a> ";
}
for($i=$min;$i<=$max;$i++){
$i = str_pad($i, 2, "0", STR_PAD_LEFT);
if($i != $page){
$table .= "<a href=\"?action=Sreport&id_menu=$id_menu&name_menu=$name_menu&page=".$i."&displaytype=people". $kwd."\"><span class=\"pagelink\">".$i."</span></a>";
} else {
$table .= "<span class=\"page\">".$i."</span>";
}
}
if(($page + 5) <= $page_all){
$table .= " <a href=\"?action=Sreport&id_menu=$id_menu&name_menu=$name_menu&page=".$page_all."&displaytype=people". $kwd."\"><u><font color=\"black\">หน้าสุดท้าย</font></u></a>";
}
if($page_all > 1){
$table .= " <a href=\"?action=Sreport&id_menu=$id_menu&name_menu=$name_menu&page=".($page_all+1)."&displaytype=people". $kwd."\"><u><font color=\"black\">แสดงทั้งหมด</font></u></a>";
}
# $table .= " <a href=\"search_excel.php?page=$sqlencode\"><u><font color=\"black\">ส่งออกรูปแบบ MS Excel </font></u></a>";
unset($max,$i,$min);
$table = $table."</td>";
$table = $table."<td width=\"20%\">จำนวนทั้งหมด <b>".number_format($page_all, 0, "", ",")."</b> หน้า </td>";
$table = $table."</tr>";
$table = $table."</table>";
}
return $table;
}
//--------------------------------------end function -----------------------------------------
//--------------------------แบ่งหน้า----------------
$page = (!isset($page) || $page <= 0) ? 1 : $page ;
$e = (!isset($e) || $e == 0) ? 20 : $e ;
$i = (!isset($page) || ($page == 1)) ? 0 : ($page - 1) * $e ;
$strSQL = "SELECT * FROM tbl_subject WHERE id_menu='$id_menu'";
$Result = mysql_db_query($dbname,$strSQL);
$all= @mysql_num_rows($Result);
$allpage = ceil($all / $e);
$sumpage = (($i + $e) >= $all) ? $all : ($i + $e) ;
$xpage=$allpage +1;
if($page <= $allpage){
$strSQL1 = "SELECT tbl_subject.*, org_staffgroup.groupname as owner FROM tbl_subject LEFT JOIN org_staffgroup ON tbl_subject.org_owner = org_staffgroup.gid ORDER BY meeting_date DESC , date_create DESC LIMIT $i, $e";
}else if($page == $xpage){
$strSQL1 = "SELECT tbl_subject.*, org_staffgroup.groupname as owner FROM tbl_subject LEFT JOIN org_staffgroup ON tbl_subject.org_owner = org_staffgroup.gid ORDER BY meeting_date DESC , date_create DESC";
}else{
$strSQL1 = "SELECT tbl_subject.*, org_staffgroup.groupname as owner FROM tbl_subject LEFT JOIN org_staffgroup ON tbl_subject.org_owner = org_staffgroup.gid ORDER BY meeting_date DESC , date_create DESC LIMIT $i, $e";
}
$Result1 = mysql_db_query($dbname,$strSQL1);
#echo " $strSQL1 ";
$search_sql = $strSQL1 ;
$num_row = mysql_num_rows($Result1);
$i=0;
while($Rs1= mysql_fetch_assoc($Result1))
{
$show_update[$i] = $Rs1[update_sign];
$show_now[$i] = $Rs1[now_sign];
$show_id[$i] = $Rs1[id_sub];
$show_subject[$i] = $Rs1[subject];
$show_main[$i] = $Rs1[main];
if($Rs1[meeting_date]!="0000-00-00"){
$datearr=explode("-",$Rs1[meeting_date]);
$date =($datearr[2]*1)." ". $smonth_arr[$datearr[1]+0]." ".$datearr[0];
}
else{
$date="";
}
$array_meeting_date[$i][date_create]=$Rs1[date_create];
$array_meeting_date[$i][meeting_date]=$Rs1[meeting_date];
$array_meeting_date[$i][finish_date]=$Rs1[finish_date];
$show_meeting_date[$i] = $date;
$t1_arr=explode(":",$Rs1[time_start]);
$t1=($t1_arr[0]+0).":".$t1_arr[1] ." น. ";
if($Rs1[time_end]!=$Rs1[time_end]){
$t1_arr=explode(":",$Rs1[time_end]);
$t1.=" - ".($t1_arr[0]+0).":".$t1_arr[1] ." น. ";
}
$show_time[$i] = $t1;
$show_location[$i] = $Rs1[location];
$show_owner[$i] = $Rs1[owner];
$sql = "SELECT
tbl_attach_file.id_type, Count(tbl_attach_file.id_type) as num
FROM
tbl_attach_file
WHERE
tbl_attach_file.id_attach_file = '$Rs1[id_sub]'
GROUP BY
tbl_attach_file.id_type";
$qr = mysql_query($sql);
$arr_temp = array();
while($rs = mysql_fetch_assoc($qr)){
$arr_temp[$rs[id_type]] = $rs[num];
}
$show_doc[$i] = $arr_temp;
$i++;
}
//==========================================================
// Create report table
//==========================================================
$rowspan = 2;
$colspan = count($docType);
?>
<table width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td width="5%" rowspan="2" align="center" bgcolor="#B0C6E6">ลำดับ</td>
<td width="15%" rowspan="2" align="center" bgcolor="#B0C6E6">ชื่อการประชุม</td>
<td width="8%" rowspan="2" align="center" bgcolor="#B0C6E6">ประธานการประชุม</td>
<td width="8%" rowspan="2" align="center" bgcolor="#B0C6E6">วันที่ประชุม</td>
<td width="4%" rowspan="2" align="center" bgcolor="#B0C6E6">เวลา</td>
<td width="9%" rowspan="2" align="center" bgcolor="#B0C6E6">สถานที่</td>
<td width="9%" rowspan="2" align="center" bgcolor="#B0C6E6">หน่วยงานเจ้าของเรื่อง</td>
<td colspan="3" align="center" bgcolor="#B0C6E6">เอกสารประกอบการประชุม</td>
<!--<td width="3%" rowspan="2" align="center" bgcolor="#B0C6E6"> </td> -->
<td width="16%" rowspan="2" align="center" bgcolor="#B0C6E6">สถานะ</td>
<td width="3%" rowspan="2" align="center" bgcolor="#B0C6E6">
<? if($_SESSION['session_apppermit'][14][10]=="on" ){
echo'<input type="button" name="btnADD" value=" เพิ่ม " onClick="location.href=\'report_index.php?action=FORM_ADD\'">'; } ?> </td>
</tr>
<tr>
<?
foreach($docType as $key => $value)
{
echo '<td align="center" bgcolor="#B0C6E6">'.$value.'</td>';
}
echo '</tr>';
$n=0;
for($j=0;$j<count($show_subject);$j++){
$id=$show_id[$j];
$sql="
SELECT
tbl_subject_approve.comment_date
FROM tbl_subject_approve
Inner Join epm_staff ON tbl_subject_approve.comment_by = epm_staff.staffid
WHERE tbl_subject_approve.id_subject='$id'
order by comment_date desc limit 1";
$qr = mysql_query($sql);
if(@mysql_num_rows($qr)>0){
$rs_qr = mysql_fetch_assoc($qr);
$d=explode("-",$rs_qr[comment_date]);
$mkremain=( ( mktime(12, 0, 0, date("m"), date("d"), date("Y")))-(mktime(12, 0, 0, $d[1], $d[2], $d[0])) )/(24*60*60);
$update_time= intval($mkremain)." day";
}
$bg_color = ($n%2)?'#F1F1F1':'FFFFFF';$n++;
$order = ($page == $allpage+1)? $n :((($page-1) * $e) + $n);
$status_update=($app_config[update_sign])?$app_config[update_sign]:$show_update[$j];
$status_new=($app_config[new_sign])?$app_config[new_sign]:$show_new[$j];
$d=explode("-",$array_meeting_date[$j][date_create]);
$mkremain=( (mktime(12, 0, 0, date("m"), date("d"), date("Y")))-(mktime(12, 0, 0, $d[1], $d[2], $d[0])))/(24*60*60);
//$mkremain=mktime(12, 0, 0, date("m"), date("d"), date("Y"))/(24*60*60);
$age_time= intval($mkremain)." day";
//echo $status_new.">".$age_time." ". $update_time;
if(intval($status_new)>$age_time){
$image_status="<img src='images/new2.gif' border=0>";
}elseif(intval($status_update)>$update_time) {
$image_status="<img src='images/update.gif' border=0>";
}else{
$image_status="";
}
?>
<tr bgcolor="<?=$bg_color?>">
<td align="center"><?=$order?></td>
<td align="left"><a href="report_index_detail.php?id=<?=$show_id[$j]?>" target="_blank" title=" รายละเอียดการประชุม"><?=$show_subject[$j]?></a> <?=$image_status?></td>
<td align="left"><?=$show_main[$j]?></td>
<td align="center"><nobr><?=daythai2($array_meeting_date[$j][meeting_date])?></td>
<td align="center"><nobr><?=$show_time[$j]?></td>
<td align="left"><?=$show_location[$j]?></td>
<td align="left"><?=$show_owner[$j]?></td>
<?
$arr_temp = $show_doc[$j];
foreach($docType as $key => $value){
if($arr_temp[$key]!==""){
$num_doc = ($arr_temp[$key] > 1)? "<a href=\"#\" onClick=\"popWindow('pop_file.php?idsub=".$show_id[$j]. "&id_type=".$key . "' , '300' , '" . (30*($arr_temp[$key])) . "')\">". $arr_temp[$key]. "รายการ</a>" :selectFiles($show_id[$j],$key);
}else{
$num_doc = "-";
}
echo '<td align="center">'.$num_doc.'</td>';
}
$id=$show_id[$j];
$sql="
SELECT
tbl_subject_approve.id_no,
tbl_subject_approve.id_subject,
tbl_subject_approve.approve_type,
tbl_subject_approve.comment_detail,
tbl_subject_approve.comment_by,
tbl_subject_approve.comment_date,
epm_staff.prename,
epm_staff.staffsurname,
epm_staff.staffname
FROM tbl_subject_approve
Inner Join epm_staff ON tbl_subject_approve.comment_by = epm_staff.staffid
WHERE tbl_subject_approve.id_subject='$id'
order by comment_date desc limit 1";
$qr = mysql_query($sql);
if(@mysql_num_rows($qr)>0){
$rs_qr = mysql_fetch_assoc($qr);
$talk="ล่าสุดเมื่อ <b>".substr($rs_qr[comment_date],0,10)."</b> โดย ";
$talk.="<a href='confirm_history.php?id=".$id."' target='_blank'>";
$talk.="<b><font color='#666666'>".$rs_qr[staffname]."</font></b><font color='#999999'> ";
$talk.=(strlen($rs_qr[comment_detail])>20)?substr($rs_qr[comment_detail],0,20)."...":$rs_qr[comment_detail];
$talk.="</a></font>";
}else{
$talk="<b><font color='#666666'>ใหม่ </font></b>";
}
?>
<!--<td align="left"><?=$topic_status[close_topic]?></td> -->
<td align="left"><?=$talk?></td>
<?
echo '<td align="center">';
# if($_SESSION['session_apppermit'][14][10]=="on"||$_SESSION['session_apppermit'][14][100] ){
if($_SESSION['session_apppermit'][14][10]=="on" ){
echo '<a href="report_index.php?action=FORM_EDIT&id='.$show_id[$j].'"><img src="images/edit_project.gif" alt="แก้ไขรายการ" width="20" height="20" border="0" ></a>
<a href="report_index.php?action=DEL_DATA&id='.$show_id[$j].'" onclick=" return confirmdel()"><img src="images/unapprove.png" alt="ลบรายการ" border="0"></a>';
}
echo "</td>";
?>
</tr><? } ?>
</table>
<tr>
<td bgcolor="#FFFFFF">
<? $sqlencode = urlencode($search_sql) ; ?>
<?=devidepage($allpage, $keyword ,$sqlencode )?> </td>
</tr>
</table>
<?
}
//===========================================================
// End Sreport
//===========================================================
?> </td>
</tr>
<form name="formE" method="post" action="">
<input type="hidden" name="page" value="<?=$page?>">
<tr valign="top">
<td bgcolor="#999999">
<?
if($action == "FORM_EDIT" || $action == "FORM_ADD")
{
if($action == "FORM_EDIT")
{
$hAction = "EDIT";
}else if($action == "FORM_ADD")
{
$hAction = "ADD";
}
$id=$_GET['id'];
$strSQLe = "SELECT tbl_subject.*,org_staffgroup.gid as owner_id,org_staffgroup.groupname as owner
FROM tbl_subject LEFT JOIN org_staffgroup ON tbl_subject.org_owner = org_staffgroup.gid WHERE id_sub='$id'";
$Resulte= mysql_db_query($dbname,$strSQLe);
$Rse = mysql_fetch_object($Resulte);
$date_create = ($Rse->date_create != "0000-00-00")?$Rse->date_create : "";
$meeting_date = ($Rse->meeting_date != "0000-00-00")?$Rse->meeting_date : "";
$finish_date = ($Rse->finish_date != "0000-00-00")?$Rse->finish_date : "";
?>
<table width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td colspan="2" align="left" bgcolor="#B0C6E6"><strong>
<input type="hidden" name="conf" id="conf" value="0">
</strong></td>
</tr>
<tr>
<td width="26%" align="right" bgcolor="#B0C6E6">หัวข้อการประชุม</td>
<td width="74%" align="left" bgcolor="#F4F4F4"><label>
<input type="text" name="subject" size="30" value="<?=$Rse->subject?>">
</label></td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6">ประธานการประชุม</td>
<td align="left" bgcolor="#F4F4F4"><input type="text" name="chair_main" size="30" value="<?=$Rse->main?>"></td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6">เลขที่หนังสือคำสั่ง</td>
<td align="left" bgcolor="#F4F4F4"><label>
<input name="noorder" type="text" size="30" value="<?=$Rse->noorder?>">
</label></td>
</tr>
<tr>
<td width="26%" align="right" bgcolor="#B0C6E6">ลงวันที่</td>
<td width="74%" align="left" bgcolor="#F4F4F4"><input name="date_create" type="text" onFocus="blur();" value="<?=($date_create)?swapdate($date_create):"";?>" size="15" readonly>
<input name="button22" type="button" class="index2" style='font-size:11px; width:80px;' onClick="popUpCalendar(this, formE.date_create, 'dd/mm/yyyy')" value='วันเดือนปี'></td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6">วันที่ประชุม</td>
<td align="left" bgcolor="#F4F4F4"><input name="meeting_date" type="text" onFocus="blur();" value="<?=($meeting_date)?swapdate($meeting_date):""?>" size="15" readonly>
<input name="button" type="button" class="index2" style='font-size:11px; width:80px;' onClick="popUpCalendar(this, formE.meeting_date, 'dd/mm/yyyy')" value='วันเดือนปี'></td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6">วันสิ้นสุดการรับรองการประชุม</td>
<td align="left" bgcolor="#F4F4F4"><input name="finish_date" type="text" onFocus="blur();" value="<?=($finish_dat)?swapdate($finish_date):""?>" size="15" readonly>
<input name="button" type="button" class="index2" style='font-size:11px; width:80px;' onClick="popUpCalendar(this, formE.finish_date, 'dd/mm/yyyy')" value='วันเดือนปี'></td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6">เวลาประชุม</td>
<td align="left" bgcolor="#F4F4F4"><?
$arr_xstart = @explode(":" , $Rse->time_start) ;
$arr_xend = @explode(":" , $Rse->time_end) ;
$xhh1 = (int)$arr_xstart[0] ; $xmm1 = (int)$arr_xstart[1] ;
$xhh2 = (int)$arr_xend[0] ; $xmm2 = (int)$arr_xend[1] ;
?>
<SELECT name="formhh1">
<? for ($ii = 8; $ii <= 16 ; $ii++){
if ($ii < 10 ){ $ii2 = "0". $ii ; }else{ $ii2 = $ii ; }
$str_select = ($xhh1 == $ii)? "selected" : "";
echo " <option value=\"$ii2\" $str_select >$ii2</option> ";
} ?>
</SELECT>
<SELECT name="formmm1">
<? for ($ii = 0; $ii < 56 ; $ii = $ii + 5){
if ($ii < 10 ){ $ii2 = "0". $ii ; }else{ $ii2 = $ii ; }
$str_select = ($xmm1 == $ii)? "selected" : "";
echo " <option value=\"$ii2\" $str_select >$ii2</option> ";
} ?>
</SELECT>
น. ถึง
<SELECT name="formhh2">
<? for ($ii = 8; $ii <= 16 ; $ii++){
if ($ii < 10 ){ $ii2 = "0". $ii ; }else{ $ii2 = $ii ; }
$str_select = ($xhh2 == $ii)? "selected" : "";
echo " <option value=\"$ii2\" $str_select >$ii2</option> ";
} ?>
</SELECT>
<SELECT name="formmm2">
<? for ($ii = 0; $ii < 60 ; $ii = $ii + 5 ){
if ($ii < 10 ){ $ii2 = "0". $ii ; }else{ $ii2 = $ii ; }
$str_select = ($xmm2 == $ii)? "selected" : "";
echo " <option value=\"$ii2\" $str_select >$ii2</option> ";
} ?>
</SELECT>
น.</td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6">สถานที่ประชุม</td>
<td align="left" bgcolor="#F4F4F4"><input name="location" type="text" value="<?=$Rse->location?>" size="15" ></td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6">รายละเอียด</td>
<td align="left" bgcolor="#F4F4F4"><label>
<textarea name="detail" cols="50" rows="3"><?=$Rse->detail?></textarea>
</label></td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6">สถานะการแสดงผล</td>
<td align="left" bgcolor="#F4F4F4"><label>
<?
$chk1 = ($Rse->status_sub == '1')? "checked" : "";
$chk2 = ($Rse->status_sub == '0')? "checked" : "";
?>
<input name="status" type="radio" value="1" checked <? echo $chk1?>>
แสดงผล
<input name="status" type="radio" value="0" <? echo $chk2?>>
ไม่แสดงผล</label></td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6">หน่วยงานเจ้าของเรื่อง</td>
<td align="left" bgcolor="#F4F4F4"><input type="text" name="txtowner" value="<?= ($action == "FORM_ADD")?$_SESSION[session_orgname] :$Rse->owner?>" readonly ><input type="hidden" name="org_owner" value="<?= ($action == "FORM_ADD")? $_SESSION[session_org]:$Rse->owner_id?>" ></td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6">หมายเลขโทรศัพท์</td>
<td align="left" bgcolor="#F4F4F4"><input type="text" name="org_phone" value="<?=$Rse->org_phone?>"></td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6">แนบไฟล์</td>
<td align="left" bgcolor="#F4F4F4">
<iframe id="uploadtarget" name="uploadtarget" src="upload_form.php?action=<?=$hAction?>&id_sub=<?= $id?>" width="320" height="50px" frameborder="0" scrolling="no" marginheight="0" marginwidth="0"></iframe>
<iframe id="fdownload" name="fdownload" width="0" height="0" scrolling="no" frameborder="0"></iframe>
** สามารถแนบได้สูงสุด 8 MB เท่านั้น </td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6"> </td>
<td align="left" bgcolor="#F4F4F4">
<div id="divListFiles">
<?
echo showListFile($Rse->id_sub,$approveshow);
?>
</div>
<div id="divUpload"></div>
<input type="hidden" name="hAct" id="hAct" value"<?= $hAction?>">
<input type="hidden" name="hIdSub" value="<?=$Rse->id_sub?>"> </td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6"> </td>
<td align="left" bgcolor="#F4F4F4">
<input type="hidden" name="hAction" value="<?= $hAction?>">
<input type="hidden" name="id_up" value="<?=$Rse->id_sub?>">
<input type="submit" name="Submit2" value="ตกลง">
<input type="reset" name="reste2" value="ล้างข้อมูล">
<input type="button" name="btnBack" value="ย้อนกลับ" onClick="document.location.href='report_index.php?action=Sreport'"> </td>
</tr>
</table>
<?
}
?>
</td>
</tr>
</form>
<tr valign="top">
<td> </td>
</tr>
</table>
<iframe id="fdownload" name="fdownload" width="0" height="0" scrolling="no" frameborder="0"></iframe>
</body>
</html>