MINI SHELL

<?
//=========================================
// 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)
	##
	###################################################################
	##
	## Version :			2010008.003
	## Modified Detail:	NEW APPROVE STEP FROM PROVINCE WEBSITE
	## Modified Date :	2010-02-08 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");

$arrThaiMonth = array('','มกราคม','กุมภาพันธ์','มีนาคม','เมษายน','พฤษภาคม','มิถุนายน','กรกฏาคม','สิงหาคม','กันยายน','ตุลาคม','พฤศจิกายน','ธันวาคม');

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>
<?
$month=($month)?$month:date('m');
$year=($year)?$year:date('Y');
?>
<table width="100%" border="0" cellpadding="0" cellspacing="0" >
  <form name="formE" id="formE" action="<?=$PHP_SELF?>?id=<?=$id?>"  method="post">
  <tr valign="top">
    <td bgcolor="#FFFFFF" align="center">
	
	<table width="80%" border="0" cellspacing="1" cellpadding="3">
      <tr>
        <td colspan="2" align="left" bgcolor="#B0C6E6" class="executive_bg" ><strong>การประชุมหัวหน้าส่วนราชการจังหวัดปทุมธานี</strong> ประจำเดือน <?=$arrThaiMonth[intval($month)]?> ปี <?=$year+543?>
          <?=$Rse->subject?>        </td>
        </tr>
	</table>	
	<?
	$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 
		MONTH(meeting_date)='$month' AND YEAR(meeting_date)='$year'
		
	";  //WHERE id_sub='$id'
	if($debug=="ON"){echo "<pre>$strSQLe</pre>"; }
	$Resulte= @mysql_db_query($dbname,$strSQLe);
	$Row_number = mysql_num_rows($Resulte);
	if($Row_number>0){
	while($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="80%" border="0" cellspacing="1" cellpadding="3">
      <tr>
        <td colspan="2" align="center" bgcolor="#B0C6E6" class="go" >หัวข้อการประชุม
          <?=$Rse->subject?>        </td>
        </tr>
      <tr>
      	<td align="right" bgcolor="#B0C6E6" class="epm_button">ประธานการประชุม</td>
      	<td align="left" bgcolor="#F4F4F4"><?=$Rse->main?></td>
      	</tr>
      <tr>
        <td align="right" bgcolor="#B0C6E6" class="epm_button">เลขที่หนังสือคำสั่ง</td>
        <td align="left" bgcolor="#F4F4F4"><?=$Rse->noorder?></td>
      </tr>
       <tr>
      <td width="26%" align="right" bgcolor="#B0C6E6" class="epm_button">ลงวันที่</td>
      <td width="74%" align="left" bgcolor="#F4F4F4"><?=daythai2($Rse->date_create)?></td>
    </tr>
      <tr>
      	<td align="right" bgcolor="#B0C6E6" class="epm_button">วันที่ประชุม</td>
      	<td align="left" bgcolor="#F4F4F4"><?=daythai2(($Rse->meeting_date)?$Rse->meeting_date:"0000-00-00")?></td>
      	</tr>
      <tr>
        <td align="right" bgcolor="#B0C6E6" class="epm_button">วันสิ้นสุดการรับรองการประชุม</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")){	?>	  
		<? }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" class="epm_button">เวลาประชุม</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" class="epm_button">สถานที่ประชุม</td>
      	<td align="left" bgcolor="#F4F4F4"><?=$Rse->location?></td>
      	</tr>
      <tr>
        <td align="right" bgcolor="#B0C6E6" class="epm_button">รายละเอียด</td>
        <td align="left" bgcolor="#F4F4F4"><?=$Rse->detail?></td>
      </tr>
      <tr>
      	<td align="right" bgcolor="#B0C6E6" class="epm_button">หน่วยงานเจ้าของเรื่อง</td>
      	<td align="left" bgcolor="#F4F4F4"><?= $Rse->owner?></td>
      	</tr>
      <tr>
        <td align="right" bgcolor="#B0C6E6" class="epm_button">แนบไฟล์</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" class="epm_button">สถานะรับรองการประชุมล่าสุด</td>
        <td align="left" bgcolor="#F4F4F4">
		<!--EXSUM -->
			<?
			$result_agenda_show=on;
			if($result_agenda_show=="on"){					
			$id=$Rse->id_sub;
					$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) ;
					if(@mysql_num_rows($resultx)){
					$rsx =  mysql_fetch_assoc($resultx);			
					?>							
					<table width="400" border="0" cellpadding="1" cellspacing="1" >
					  <?
						if ($rsx[type_a] > 0){ ?>
					  <tr>
						<td align="right" bgcolor="#FFFFFF" >รับรองการประชุม : </td>
						<td bgcolor="#FFFFFF">
						<a href="confirm_history_public.php?id=<?=$id?>&comment_type=1" target="_blank">
						  <?=$rsx[type_a]?>
						  หน่วยงาน </a></td>
					  </tr>
					  <? }
							if ($rsx[type_b] > 0){ ?>
					  <tr>
						<td align="right" bgcolor="#FFFFFF">ไม่รับรองการประชุม : </td>
						<td bgcolor="#FFFFFF"><a href="confirm_history_public.php?id=<?=$id?>&comment_type=2" target="_blank">
						  <?=$rsx[type_b]?>
						  หน่วยงาน </a> </td>
					  </tr>
					  <? }?>
					</table>					
				<? }
			 }?>	
		<!--END EXSUM-->		</td>
      </tr> 
	  <? 
      } 
	if( ( ($Rse->meeting_date)<=date('Y-m-d'))&&( ($Rse->finish_date)>=date('Y-m-d') || ((!$Rse->finish_date)&&($Rse!="0000-00-00")) ) && ($Rse->close_topic=="on") ){	
	  ?>
      <tr>
        <td colspan="2" align="center" >
		<table width="240" border="0" cellspacing="3" cellpadding="1">
          <tr>
            <td width="110" align="left" valign="middle" class="epm_button" onClick="window.open('report_confirm_public.php?id_sub=<?=$id?>&mode_select=confirm','public_confirm','height=500,width=360')"><nobr><img src="images/approve.gif" width="16" height="16"> รับรองการประชุม&nbsp;&nbsp;&nbsp;&nbsp;</td>
            <td width="20">&nbsp;</td>
            <td width="110" align="left" valign="middle" class="epm_button" onClick="window.open('report_confirm_public.php?id_sub=<?=$id?>&mode_select=cancle','public_confirm','height=500,width=360')"><nobr><img src="images/notapprove.gif" width="16" height="16"> ไม่รับรองการประชุม</td>
          </tr>
        </table>
          </td>
      </tr>
	  <? }?>
      <tr>
        <td colspan="2" align="right" ><hr>&nbsp;</td>
      </tr>
	  <? }	  
	  ?></table><?
	  } else{ ?>
	<table width="80%" border="0" cellspacing="1" cellpadding="3">	  
      <tr>
        <td colspan="2" align="center" class="epm_button" > ไม่มีรายงานการประชุมประจำเดือนนี้ </td>
      </tr>	
	</table>  
	  <? }?>
    </td>
  </tr>
  </form>
  <tr valign="top">
    <td>&nbsp;</td>
  </tr>
</table>

<iframe id="fdownload" name="fdownload" width="0" height="0" scrolling="no" frameborder="0"></iframe>
</body>
</html>