MINI SHELL

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/meetingroom/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : /var/www/html/pathumthani_eoffice/application/meetingroom/main_general.php
<?
//include("chk_permission.php");
session_start();
include("../../config/config.inc.php");
include("../../common/function.php");
include("var.inc.php");
//insert timeQuery
include("../../common/common_system.inc.php"); 
$ApplicationName="metting"; 
$time_start = getmicrotime();  
//insert timeQuery
################ HARD FIX
#$_SESSION[session_staffid] = 49 ;
$user=$_SESSION[session_staffid];
################
#if ($jump != ""){$jump=$jump;}else{$jump=date("d") ."/". date("m") ."/". date("Y") ;  $jump = $jump; } 
if ($jump == ""){$jump=date("d") ."/". date("m") ."/". date("Y") ;   } 

/*  
function jump_daythai($cal_format){
	$smonth = array("","ม.ค.", "ก.พ.", "มี.ค.", "เม.ย.", "พ.ค.", "มิ.ย.", "ก.ค.", "ส.ค.", "ก.ย.", "ต.ค.", "พ.ย.", "ธ.ค.");
	$arr_day = explode("/",$cal_format) ;  
	$mm = (int)$arr_day[1] ; 
	$thyy =  (int)$arr_day[2] + 543 ; 
	$daythai = (int)$arr_day[0] ."  ".  $smonth[$mm]  ."  ".  $thyy   ;
	return $daythai ; 
} ################# function jump_daythai($cal_format){
*/

?>
<HTML>
<HEAD><TITLE>ระบบจองห้องประชุม</TITLE>
<META http-equiv="Content-Type" content="text/html; charset=windows-874">
<LINK href="../../common/style.css" rel="stylesheet" type="text/css">
<LINK href="../../common/tab_style.css" rel="stylesheet" type="text/css" />
<SCRIPT language="javascript" src="../../common/popcalendar.js"></SCRIPT>
<SCRIPT language="javascript" src="../../common/xmlhttp.js"></SCRIPT>
<SCRIPT type="text/javascript" src="../../common/tabber.js"></SCRIPT>
<STYLE type=text/css>BODY {
OVERFLOW: scroll; OVERFLOW-X: hidden
}
.DEK {
POSITION: absolute; VISIBILITY: hidden; Z-INDEX: 200
}
</STYLE> 
</HEAD>
<BODY topmargin="0">

<? 			 	
$title_label = "ระบบจองห้องประชุม";
//include "header.php";    
include "../../common/tag_alt.txt";   
//include "menu_bar.php";  
?>
    <table width="100%" height="400" border="0" cellpadding="0" cellspacing="0" bgcolor="#EEEEEE">
      <tr>
        <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td width="19%" align="center" valign="top">
<? 

$csql = " SELECT * FROM  meeting_reserve  ";			
include("_calendar.php"); 
?></td>
            <td colspan="3" valign="top">เลือกรูปแบบการแสดงผล [แบบตาราง] [<a href="reserve_list.php?jump=<?=$jump?>">แบบรายการ</a>]  <br> <br> 
<?
$sql = " SELECT   daterent, count(refid)  as countnm     FROM meeting_reserve
where  daterent  > DATE_SUB( NOW()  , INTERVAL 1  MONTH)   
AND admin_confirm < 30 
GROUP BY daterent ORDER BY  daterent  desc   "; 
$query = mysql_query($sql); 
while ($rs = mysql_fetch_assoc($query)){
	$nonm++; 
	$carendardd =convert_mysql2carendar($rs[daterent]) ;
	
	echo " <br>  $nonm) วันที่ ". convert_mysql2th($rs[daterent])  ."  จำนวนการใช้ห้องประชุมทั้งสิ้น  <a href='main.php?jump=$carendardd'>$rs[countnm]  รายการ </a>  ";
}

#main.php?jump=16/03/2009


?>	</td>
          </tr>
          <tr>
            <td colspan="4" valign="top"><?
$nowdatemysql  = convert_2mysql($jump) ; 
$sql = " 
SELECT rid,refid, rname, rdetail, rfloor, rsize, rrent, meeting_reserve.daterent, meeting_reserve.time_start, 
meeting_reserve.time_end, meeting_reserve.contactpoint, meeting_reserve.contactpointtel, 
meeting_reserve.meeting_topic, meeting_reserve.meeting_chairman, meeting_reserve.meeting_person , 
admin_confirm , statusname
FROM meeting_room 
LEFT  JOIN meeting_reserve ON rid = meeting_reserve.roomid
INNER  JOIN  meeting_status ON admin_confirm = statusid 
WHERE    
meeting_reserve.daterent =  '$nowdatemysql'       "; 
$result = mysql_query($sql) ; 
while ($rs = mysql_fetch_assoc($result)){ 
	$roomid = $rs[rid] ; 
	$xroomid  =  $rs[rid] ; 
	$refid = $rs[refid] ; 
	
	$arr_timestart = explode(":" , $rs[time_start] ) ; 
	$arr_timeend = explode(":" , $rs[time_end] ) ; 
	
	$starthh = $arr_timestart[0] ; 	$startmin = $arr_timestart[1] ; 	
	$endhh = $arr_timeend[0] ; 	$endmin = $arr_timeend[1] ; 
	
	$arr_roomref[$roomid]  = $arr_roomref[$roomid] .",".  $refid ; 
	
	$arr_starthh[$roomid][$refid] =   $starthh  ; 	$arr_startmin[$roomid][$refid] =   $startmin  ; 	
	$arr_endhh[$roomid][$refid] =   $endhh  ; 	$arr_endmin[$roomid][$refid] =   $endmin  ; 
	$arr_confirm[$roomid][$refid] = $rs[admin_confirm] ; 
	$arr_meetingtopic[$xroomid][$refid] = $rs[meeting_topic] ."<br> <strong>ประธานการประชุม :</strong>". $rs[meeting_chairman] ." <br> <strong>contactpoint :</strong>". $rs[contactpoint]  ; 		
} ###### END while ($rs = mysql_fetch_assoc($result)){ 
####################################################################
$sql = " SELECT * FROM meeting_status  "; 
$result = mysql_query($sql) ; 
while ($rs = mysql_fetch_assoc($result)){ 
	$arr_colorselect[$rs[statusid]] = $rs[statuscolor] ; 
} #########  while ($rs = mysql_fetch_assoc($result)){ 
####################################################################
$sql = " SELECT  rid,rname,rdetail,rfloor,rsize,rrent   FROM  meeting_room  ";
$result = mysql_query($sql) ; 

?>
              <table width="98%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#666666">
                <tr  bgcolor="#466A8E"  class="headerTB_white" >
                  <td rowspan="2" align="center" >จองห้อง<br> 
                  ประชุม</td>
                  <td width="200" rowspan="2" align="center" bgcolor="#466A8E" ><strong>ห้องประชุม</strong></td>
                  <td colspan="10" align="center"><strong>สถานะการใช้งานห้องประชุมวันที่
                    <?=jump_daythai($jump)?>
                  </strong></td>
                </tr>
                <tr  bgcolor="#466A8E"  class="ptext_w" >
                  <td align="center"> 8.00-9.00 </td>
                  <td align="center"> 9.00-10.00 </td>
                  <td align="center"> 10.00-11.00 </td>
                  <td align="center"> 11.00-12.00 </td>
                  <td align="center"> 12.00-13.00 </td>
                  <td align="center"> 13.00-14.00 </td>
                  <td align="center"> 14.00-15.00 </td>
                  <td align="center"> 15.00-16.00</td>
                  <td align="center">16.00-17.00</td>
                  <td align="center">17.00-18.00</td>
                </tr>
<?
while ($rs= mysql_fetch_assoc($result)){ 
	$nonm++; 	
	if ($bgcolor1 == "DDDDDD"){  $bgcolor1 = "EFEFEF"  ; } else {$bgcolor1 = "DDDDDD" ;}
	$roomid = $rs[rid] ; 	
	$xroomid = $rs[rid] ; 		
	$arr001 = $arr_starthh[$roomid] ; 
	$xroomname = $rs[rname] ; 	
	
	while (list ($xrefid, $val) = @each($arr001)) {   ########## หาว่าห้อง   $roomid มีการประชุมกี่โมง 
#		echo " ============= ห้อง $roomid  ลำดับ(key) $xrefid,  เวลา $val  <br> ";  
		$admin_confirm = $arr_confirm[$roomid][$xrefid] ; 
		$xtimestart =  (int)$arr_starthh[$roomid][$xrefid] ; 
		$xtimeend =  (int)$arr_endhh[$roomid][$xrefid] ; 
		$topicxx = $arr_meetingtopic[$xroomid][$xrefid]  ;  ########### ตั้งค่าสำหรับ popup		
		 for ($ii = $xtimestart ; $ii < $xtimeend ; $ii++){ ########## Start ทราบเวลาเิริ่มและเวลาจบ วนหาเวลาตรงกลาง
			$colorselect = $arr_colorselect[$admin_confirm] ; 

			$varbgtmp = "bgcolor_c" . $ii ;  $$varbgtmp = "bgcolor='$colorselect'" ;  ##### กำหนดสีให้ตัวแปร
			eval("\$varbgtmp  = \"$varbgtmp\";"); $varbg  = $$varbgtmp  ; 
			
			if ($editid ==  $xrefid ){ $arrval[$xroomid]["$ii"] = "||||||||";  } 
			$arralt[$xroomid]["$ii"] =  "onmouseout=kill() onmouseover=\"popup('  $topicxx ','white')\";  " ; ## สำหรับ popup			
		 } ###### END for  ########## END  ทราบเวลาเิริ่มและเวลาจบ วนหาเวลาตรงกลาง
	} ################## END while (list ($name, $val) = each($arr001)) { 

?>
                <tr  bgcolor="#FFFFFF"  align="center" >
                  <td height="25" bgcolor="#FFFFFF"><a href="reserve_room.php?roomid=<?=$rs[rid]?>&jump=<?=$jump?>"> <img src="../../images/document_add.gif" alt="จอง <?=$rs[rname]?>" width="20" height="20" border="0"></a> </td>
                  <td height="25" align="left" bgcolor="#FFFFFF"><a href="room_detail.php?roomid=<?=$rs[rid]?>" target="_blank"  > </a>
                      <?=$rs[rname]?></td>
    <td <?=$bgcolor_c8?>  <?=$arralt[$xroomid]["8"]?>>&nbsp;<?=$arrval[$xroomid]["8"]?></td>
    <td <?=$bgcolor_c9?>  <?=$arralt[$xroomid]["9"]?>>&nbsp;<?=$arrval[$xroomid]["9"]?></td>
    <td <?=$bgcolor_c10?>  <?=$arralt[$xroomid]["10"]?> >&nbsp;<?=$arrval[$xroomid]["10"]?></td>
    <td <?=$bgcolor_c11?>  <?=$arralt[$xroomid]["11"]?> >&nbsp;<?=$arrval[$xroomid]["11"]?></td>
    <td <?=$bgcolor_c12?>  <?=$arralt[$xroomid]["12"]?> >&nbsp;<?=$arrval[$xroomid]["12"]?></td>
    <td <?=$bgcolor_c13?>  <?=$arralt[$xroomid]["13"]?> >&nbsp;<?=$arrval[$xroomid]["13"]?></td>
    <td <?=$bgcolor_c14?>  <?=$arralt[$xroomid]["14"]?> >&nbsp;<?=$arrval[$xroomid]["14"]?></td>
    <td <?=$bgcolor_c15?>  <?=$arralt[$xroomid]["15"]?> >&nbsp;<?=$arrval[$xroomid]["15"]?></td>
    <td <?=$bgcolor_c16?>  <?=$arralt[$xroomid]["16"]?> >&nbsp;<?=$arrval[$xroomid]["16"]?></td>
    <td <?=$bgcolor_c17?>  <?=$arralt[$xroomid]["17"]?> >&nbsp;<?=$arrval[$xroomid]["17"]?></td>
                </tr>
                <?
 for ($ii = 1 ; $ii < 24 ; $ii++){
	$varbgtmp = "bgcolor_c" . $ii  ;
	$$varbgtmp = "" ;
 }
					
}  ################## END while ($rs= mysql_fetch_assoc($result)){ 
?>
              </table>
              <br>
              <table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
                <tr>
                  <td width="21%"><strong>สถานะการจองห้องประชุม</strong></td>
                  <td width="3%" bgcolor="#FFFFFF">&nbsp;</td>
                  <td width="19%">ห้องประชุมว่าง</td>
                  <td width="3%" bgcolor="#FFFF99">&nbsp;</td>
                  <td width="23%">จองห้องประชุม</td>
                  <td width="3%" bgcolor="#A0C779">&nbsp;</td>
                  <td width="28%">ผ่านยืนยันการจองโดยผู้ดูแลระบบ</td>
                </tr>
              </table>
            </td>
          </tr>
        </table></td>
      </tr>
</table>
<?
//insert timeQuery
 $time_end = getmicrotime();
  writetime2db($timestart,$timeend);
//insert timeQuery
?>

Anon7 - 2021