|
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'
//=
session_start();
include("../../config/config.inc.php");
include("function/function.php");
include("function.listfile.php");
$smonth_arr=array('','ม.ค.','ก.พ.','มี.ค.','เม.ย.','พ.ค.','มิ.ย.','ก.ค.','ส.ค.','ก.ย.','ต.ค.','พ.ย.','ธ.ค.');
if(!isset($session_username)){
header("Location:login.php");
}
?>
<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>
<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>
</head>
<body>
<table width="100%" border="0" cellpadding="0" cellspacing="0" style="filter:progid:DXImageTransform.Microsoft.Gradient(GradientType=0, StartColorStr='#144C85', EndColorStr='#ffffff');">
<form name="formE" method="post" action="">
<tr valign="top">
<td bgcolor="#000000">
<table width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td colspan="5" align="left" bgcolor="#B0C6E6" class="headerTB">ประวัติการรับรองการประชุม</td>
</tr>
<tr>
<td width="5%" align="right" bgcolor="#B0C6E6">ลำดับ</td>
<td width="3%" align="left" bgcolor="#B0C6E6"> </td>
<td width="33%" align="left" bgcolor="#B0C6E6">วันเวลาบันทึก</td>
<td width="35%" align="left" bgcolor="#B0C6E6">รายละเอียด</td>
<td width="24%" align="left" bgcolor="#B0C6E6">ผู้แสดงความคิดเห็น</td>
<?
if($comment_type!=""&&$comment_type!=99){
$slq_selected=" AND tbl_subject_approve.approve_type = '$comment_type' ";
}
$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' $slq_selected
order by comment_date desc ";
if($comment_type==99){
$sql = "
SELECT
99 AS approve_type,
'ไม่เรียกดูรายงานการประชุม' AS comment_detail,
org_groupmember.gid ,
org_staffgroup.groupname AS comment_org
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
Inner Join org_staffgroup ON org_groupmember.gid = org_staffgroup.gid
WHERE
permission_status.app_id = '14' AND
permission_status.pid = '100' AND
org_groupmember.gid != '$ord_id'
GROUP by org_groupmember.gid
";
}
$result=mysql_query($sql);
$i=1;
while($row=mysql_fetch_array($result)){
?>
</tr>
<tr>
<td align="right" bgcolor="#FFFFFF"><?=$i++?></td>
<td align="left" bgcolor="#FFFFFF"><?
if($row[approve_type]=="1"){
echo"<img src=\"images/approve.gif\" width=\"16\" height=\"16\" border=0 alt=\"รับรองการประชุม\"/>";
}elseif($row[approve_type]=="2"){
echo"<img src=\"images/alert.gif\" width=\"16\" height=\"16\" border=0 alt=\"แจ้งไม่รับรองการประชุม\"/>";
}elseif($row[approve_type]=="0"){
echo"<img src=\"images/info1.gif\" width=\"16\" height=\"16\" border=0 alt=\"ไม่มีการดำเนินการรับรองรายงานการประชุม\"/>";
}elseif($row[approve_type]=="99"){
echo"<img src=\"images/close.gif\" width=\"16\" height=\"16\" border=0 alt=\"ไม่เรียกดูรายงานการประชุม\"/>";
}
?></td>
<td align="left" bgcolor="#FFFFFF"><?
$arrstr=explode(" ",$row[comment_date]);
$arrdate=explode("-",$arrstr[0]);
$arrtime=explode(":",$arrstr[1]);
$m=(int)$arrdate[1];
if($row[comment_date]){echo $arrdate[2]." " .$smonth_arr[$m]. " ". ($arrdate[0]+543) ."เวลา ".($arrtime[0]*1).":".$arrtime[1]." น.";}
?></td>
<td align="left" bgcolor="#FFFFFF"><?=$row[comment_detail]?></td>
<td align="left" bgcolor="#FFFFFF"><?=($row[comment_org])?$row[comment_org]:$row[prename].$row[staffname]." ".$row[staffsurname]?></td>
</tr>
<?
}
?>
<tr>
<td colspan="5" align="center" bgcolor="#B0C6E6"><input type="button" name="button" id="button" value="ปิด" style="font-size:12px;width:70px;height:20px" onClick="window.close();"></td>
</tr>
</table></td>
</tr>
</form>
<tr valign="top">
<td> </td>
</tr>
</table>
</body>
</html>