|
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 : |
<?
//include("chk_permission.php");
session_start();
include("../../config/config.inc.php");
include("../../common/function.php");
include("var.inc.php");
$phpfile = "reserve_room.php" ;
//insert timeQuery
include("../../common/common_system.inc.php");
$ApplicationName="metting";
$time_start = getmicrotime();
//insert timeQuery
##meeting_reserve
################ HARD FIX
#$_SESSION[session_staffid] = 49 ;
$user=$_SESSION[session_staffid];
################
function toStaffName($staffid) {
$sqlx = "SELECT staffname FROM epm_staff WHERE staffid='$staffid'";
$qx = mysql_query($sqlx) or die(mysql_error());
$rx = mysql_fetch_assoc($qx);
return $rx[staffname];
}
?>
<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>
<script language="javascript" >
function filterNumber(evt, txtbox, dec, notation)
{
var charCode = (evt.which) ? evt.which : event.keyCode;
var value = txtbox.value;
var arr_v = value.split(".");
if (charCode > 31 && (charCode < 46|| charCode > 57) || charCode == 47)
{
return false;
}else
{
if(charCode == 46 )
{
if(value.length == 0)
{ return false;}
else if(arr_v.length > 1 )
{ return false;}
}
if(value.length >= dec && (charCode > 47&& charCode <58))
{
if(arr_v.length == 1)
{ return false; }
}
if (arr_v.length == 2)
{
if(arr_v[1].length >= notation )
{ return false; }
}
}
return true;
}
function changeCost(rdoType)
{
var value = rdoType.value;
document.getElementById("hidTypeRent").value = value;
if(value == 1)
{
document.getElementById("txtCost").value = document.getElementById("hidRent1").value;
}else
{
document.getElementById("txtCost").value = document.getElementById("hidRent2").value;
}
}
function getTypeCost(ddlConf)
{
var value = ddlConf.options[ddlConf.selectedIndex].value;
//if(value == 20 || value == 31)
if( value == 31)
{
var hRent1 = document.getElementById("hidRent1").value;
var hRent2 = document.getElementById("hidRent2").value;
var hTypeRent = document.getElementById("hidTypeRent").value;
var chk1 = "";
var chk2 = "";
var txtValue = 0;
if(hTypeRent ==1)
{
chk1 = "checked";
txtValue = hRent1;
}else if(hTypeRent ==0)
{
chk2 = "checked";
txtValue = hRent2;
}
//document.getElementById("divTypeCost").innerHTML =
"<input type='radio' name='rdoCost' id='rdoCost' value='1' onClick='changeCost(this)'"+ chk1+ " />ค่าเช่าต่อวัน " +
"<input type='radio' name='rdoCost' id='rdoCost' value='0' onClick='changeCost(this)'"+ chk2+" / >ค่าเช่าต่อชั่วโมง ";
//document.getElementById("divCost").innerHTML = '<input type="text" name="txtCost" id="txtCost" value="'+txtValue+'" onKeyPress="return filterNumber(event, this ,12,2);" >';
<?
$sql_back = "Select billCost FROM meeting_reserve WHERE refid='$editid' limit 1";
$result_sel = mysql_query($sql_back );
$rs_show = mysql_fetch_assoc($result_sel);
?>
document.getElementById("divCost").innerHTML = ' เลขที่ใบเสร็จ <input type="text" name="billCost" id="billCost" value="<?=$rs_show[billCost]?>" ><input type="hidden" name="txtCost" id="txtCost" value="'+document.getElementById("payment_money").value+'" ><br>';
document.getElementById("divTypeCost").innerHTML = "";
}else if(value==30 || value==21){
document.getElementById('divTypeCost').innerHTML=" สาเหตุการยกเลิกประชุม<br /> <textarea name=\"can_comment\" style=\"width:400px;height:100px;\"></textarea>";
document.getElementById("divCost").innerHTML = "";
}else{
document.getElementById("divTypeCost").innerHTML = "";
document.getElementById("divCost").innerHTML = "";
}
}
</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 "menu_bar.php";
include "../../common/tag_alt.txt";
?>
<?
if ($approve_reserve != ""){
/* while (list ($key, $val) = each ($_POST)) {
echo " <br> $key ______ $val " ;
} ############## */
$can_comment="<pre>".$_POST['can_comment']."</pre>";
if($can_comment!=""){
$sql_comment=",comment='".trim($can_comment)."'";
}
$str_source = $frm_roomstatus ? " admin_confirm='$frm_roomstatus', " : ""; //cost_request = '$txtCost' ,
$sql = " UPDATE meeting_reserve SET
$str_source
billCost = '$billCost' $sql_comment
WHERE refid = '$editid' ";
$result = mysql_query($sql) ;
if($frm_roomstatus=="21" || $frm_roomstatus=="30"){//ยื่นความจำนงยกเลิกการจองห้องประชุม หรือ ADMIN ยกเลิิก
$sql_back = "Select * FROM meeting_reserve_backup WHERE refid='$editid'";
$result_back = mysql_query($sql_back);
$rownum=mysql_num_rows($result_back);
if($rownum==0){
$sql_back_insert= "insert into meeting_reserve_backup (select *,'0','0' FROM meeting_reserve WHERE refid='$editid' ) ";
$result_back = mysql_query($sql_back_insert);
}
$sql_back = "delete FROM meeting_reserve WHERE refid='$editid'";
$result_back = mysql_query($sql_back );
}
$sql_ch = "SELECT * FROM meeting_reserve WHERE refid='$editid'";
$result_ch = mysql_query($sql_ch);
$rs_ch = mysql_fetch_assoc($result_ch);
if($frm_roomstatus == "10"){
addlog("ยื่นความจำนงการจองห้องประชุม $rs_ch[meeting_topic]",$m_id,$logid12,$editid);
}else if($frm_roomstatus == "20"){
addlog("ตอบรับการจองห้องประชุม $rs_ch[meeting_topic]",$m_id,$logid10,$editid);
}else if($frm_roomstatus == "30"){
addlog("ยกเลิกการจองห้องประชุม $rs_ch[meeting_topic]",$m_id,$logid10,$editid);
}else if($frm_roomstatus == "21"){
addlog("ยื่นความจำนงยกเลิกการจองห้องประชุม $rs_ch[meeting_topic]",$m_id,$logid10,$editid);
}
if( mysql_error()==""){
echo " <script> window.location='main.php?jump=$jump' </script>";
}
} #################### END if ($approve_reserve != ""){
?>
<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">
<p>
<?
$csql = " SELECT * FROM meeting_reserve ";
include("_calendar.php");
?>
</p>
<p><TABLE width="98%" border="0" cellpadding="2" cellspacing="0">
<TR>
<TD>
<?
$rs_roomsize=0;
$sql = " SELECT rid,rname,rdetail,rfloor,rsize,rrent,rper FROM
meeting_reserve
Inner Join meeting_room ON meeting_reserve.roomid = meeting_room.rid
WHERE refid = '$editid'";
$result = mysql_query($sql) ;
$rs = mysql_fetch_assoc($result);
$rs_roomname = $rs[rname] ;
$rs_roomsize = $rs[rsize] ;
$rs_roomrfloor = $rs[rfloor] ;
$rs_roomrrent = $rs[rrent] ;
$rs_roomrper = $rs[rper] ;
?>
ชื่อห้อง : <?=$rs_roomname?><BR/>
ชั้น :
<?=$rs_roomrfloor;?>
<BR/>
ขนาดความจุห้อง :
<?=$rs_roomsize?>
<BR/>
ค่าเช่าห้อง :
<?=$rs_roomrrent?>
บาท/<? if($rs_roomrper==0){echo"ชั่วโมง";}elseif($rs_roomrper==1){echo"วัน";}?>
<br><br>อุปกรณ์โสดมาตราฐานประจำห้อง :<br>
<?
$sql = " SELECT * FROM meeting_room_accessories WHERE rid='$roomid' ";
$result = mysql_query($sql) ;
$nrows = mysql_num_rows($result);
if ($nrows) {
while ($rs_room= mysql_fetch_assoc($result)){
$nonm++;
echo "<li> $rs_room[accname] </li>";
}
}
?>
</TD>
</TR>
</TABLE></p></td>
<td colspan="3" rowspan="2" valign="top">
<?
$nowdatemysql = convert_2mysql($jump) ;
$roomstr =""; if ($roomid != "" and $editid == ""){ $roomstr = " AND rid = '$roomid' "; }
$sql = "
SELECT rid, roomid , 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,staff_regis , meeting_reserve.cost_request
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'
$roomstr
";
$result = mysql_query($sql) ;
while ($rs = mysql_fetch_assoc($result)){
$sql="Select org_staffgroup.groupname ,org_groupmember.gid FROM org_groupmember Inner Join epm_staff ON org_groupmember.staffid = epm_staff.staffid Inner Join org_staffgroup ON org_staffgroup.gid = org_groupmember.gid where epm_staff.staffid = $rs[staff_regis]";
$my_query=mysql_query($sql);
$xrow=@mysql_fetch_array($my_query);
$groupname= $xrow['groupname'];
$xroomid = $rs[roomid] ;
$groupid[$xroomid]=$xrow['gid'];
$xrefid = $rs[refid] ;
$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[$xroomid] = $arr_roomref[$xroomid] .",". $xrefid ;
$arr_starthh[$xroomid][$xrefid] = $starthh ; $arr_startmin[$xroomid][$xrefid] = $startmin ;
$arr_endhh[$xroomid][$xrefid] = $endhh ; $arr_endmin[$xroomid][$xrefid] = $endmin ;
$arr_confirm[$xroomid][$xrefid] = $rs[admin_confirm] ;
# echo " <br> ====================== ห้อง $xroomid || xref = $xrefid || ref= $refid ";
//$arr_meetingtopic[$xroomid][$refid] = $rs[meeting_topic] ."<br> <strong>ประธานการประชุม :</strong>". $rs[meeting_chairman] ." <br> <strong>contactpoint :</strong>". $rs[contactpoint] ;
// if($_SESSION[session_staffid]==""){
// $arr_meetingtopic[$xroomid][$refid] = "<strong>หน่วยงาน :</strong>".$groupname."<br /><strong>หัวข้อ :</strong>".$rs[meeting_topic] ."<br> <strong>ประธานการประชุม :</strong>". $rs[meeting_chairman];
// }else{
$num_text ="";
$num_text = number_format($rs[cost_request],2);
$arr_meetingtopic[$xroomid][$refid] = "<strong>หน่วยงาน :</strong>".$groupname."<br /><strong>หัวข้อ :</strong>".$rs[meeting_topic] ."<br> <strong>ประธานการประชุม :</strong>". $rs[meeting_chairman] ."<br> <strong>ค่าธรรมเนียม :</strong> $num_text <br> <strong>ผู้ประสานงาน :</strong>". $rs[contactpoint] ." <br /><strong>โทรศัพท์ :</strong>".$rs[contactpointtel];
// }
} ###### 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)){
####################################################################
$roomstr =""; if ($roomid != "" and $editid == ""){ $roomstr = " WHERE rid = $roomid "; }
$sql = " SELECT rid,rname,rdetail,rfloor,rsize,rrent FROM meeting_room $roomstr ";
$result = mysql_query($sql) ;
?>
เลือกรูปแบบการแสดงผล [แบบตาราง] [<a href="reserve_list.php?jump=<?=$jump?>">แบบรายการ</a>]
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#666666">
<tr bgcolor="#466A8E" class="headerTB_white" >
<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" ;}
$xroomid = $rs[rid] ;
$arr001 = $arr_starthh[$xroomid] ;
$xroomname = $rs[rname] ;
$arr_meetingroom[$xroomid] = $xroomname ;
while (list ($xrefid, $val) = @each($arr001)) { ########## หาว่าห้อง $roomid มีการประชุมกี่โมง
# echo " ============= ห้อง $roomid ลำดับ(key) $xrefid, เวลา $val <br> ";
$admin_confirm = $arr_confirm[$xroomid][$xrefid] ;
$xtimestart = (int)$arr_starthh[$xroomid][$xrefid] ;
$xtimeend = (int)$arr_endhh[$xroomid][$xrefid] ;
$topicxx = $arr_meetingtopic[$xroomid][$xrefid] ; ########### ตั้งค่าสำหรับ popup
for ($ii = $xtimestart ; $ii < $xtimeend ; $ii++){ ########## Start ทราบเวลาเิริ่มและเวลาจบ วนหาเวลาตรงกลาง
$colorselect = $arr_colorselect[$admin_confirm] ;
// $onclick = ($admin_confirm == 10 && $session_apppermit[$m_id ][10] == "on")?
$onclick = ( $session_apppermit[$m_id ][10] == "on" || $groupid[$xroomid]==$_SESSION[session_org])?
"onclick =\"javascript:window.open('?roomid=&jump=$jump&editid=$xrefid' , '_self')\" style='cursor:hand'" : "" ;
$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')\"; $onclick " ; ## สำหรับ popup
}######END for ########## END ทราบเวลาเิริ่มและเวลาจบ วนหาเวลาตรงกลาง
}################## END while (list ($name, $val) = each($arr001)) {
?>
<tr bgcolor="#FFFFFF" align="center" >
<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"]?>> <?=$arrval[$xroomid]["8"]?></td>
<td <?=$bgcolor_c9?> <?=$arralt[$xroomid]["9"]?>> <?=$arrval[$xroomid]["9"]?></td>
<td <?=$bgcolor_c10?> <?=$arralt[$xroomid]["10"]?> > <?=$arrval[$xroomid]["10"]?></td>
<td <?=$bgcolor_c11?> <?=$arralt[$xroomid]["11"]?> > <?=$arrval[$xroomid]["11"]?></td>
<td <?=$bgcolor_c12?> <?=$arralt[$xroomid]["12"]?> > <?=$arrval[$xroomid]["12"]?></td>
<td <?=$bgcolor_c13?> <?=$arralt[$xroomid]["13"]?> > <?=$arrval[$xroomid]["13"]?></td>
<td <?=$bgcolor_c14?> <?=$arralt[$xroomid]["14"]?> > <?=$arrval[$xroomid]["14"]?></td>
<td <?=$bgcolor_c15?> <?=$arralt[$xroomid]["15"]?> > <?=$arrval[$xroomid]["15"]?></td>
<td <?=$bgcolor_c16?> <?=$arralt[$xroomid]["16"]?> > <?=$arrval[$xroomid]["16"]?></td>
<td <?=$bgcolor_c17?> <?=$arralt[$xroomid]["17"]?> > <?=$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="17%"><strong>สถานะการจองห้องประชุม</strong></td>
<td width="3%" bgcolor="#FFFFFF"> </td>
<td width="17%">ห้องประชุมว่าง</td>
<td width="3%" bgcolor="#FFFF99"> </td>
<td width="17%">จองห้องประชุม</td>
<td width="3%" bgcolor="#A0C779"> </td>
<td width="17%">ผ่านยืนยันการจองโดยผู้ดูแลระบบ</td>
<td width="3%" bgcolor="#0D98CC"> </td>
<td width="17%">ชำระค่าธรรมเนียมแล้ว</td>
</tr>
</table>
<?
################################# jump=13/03/2009&editid=1
if ($editid != ""){
$poststr = "&jump=". $jump ."&editid=". $editid ;
}else{
$poststr = "";
} ########## END if ($editid != ""){
?>
<form name="post" method="post" action="reserve_confirm.php?roomid=<?=$roomid?><?=$poststr?>">
<?
if ($editid != ""){
$sql = " SELECT meeting_reserve.*,meeting_reserve_access.costbath as costb , org_staffgroup.groupname
FROM meeting_reserve LEFT JOIN meeting_reserve_access ON meeting_reserve.refid = meeting_reserve_access.reserve_id
Inner Join org_groupmember ON meeting_reserve.staff_regis = org_groupmember.staffid
Inner Join org_staffgroup ON org_groupmember.gid = org_staffgroup.gid
WHERE refid = '$editid' ";
$result = mysql_query($sql) ;
while ($rs = mysql_fetch_array($result)){
$rs_refid = $rs[refid] ;
$rs_roomid = $rs[roomid] ;
$rs_daterent = $rs[daterent] ;
$rs_time_start = $rs[time_start] ;
$rs_time_end = $rs[time_end] ;
$rs_staff_regis = $rs[staff_regis] ;
$rs_groupname = $rs[groupname] ;
$rs_contactpoint = $rs[contactpoint] ;
$rs_contactpointtel = $rs[contactpointtel] ;
$rs_meeting_topic = $rs[meeting_topic] ;
$rs_meeting_chairman = $rs[meeting_chairman] ;
$rs_meeting_person = $rs[meeting_person] ;
$rs_admin_confirm = $rs[admin_confirm] ;
$rs_cost_request = $rs[cost_request] ;
$rs_cost_acc = $rs[costb];
$rs_billCost = $rs[billCost];
# $rs_confirmstatusid = $rs[admin_confirm] ;
} ########## END while ($rs = mysql_fetch_assoc($result)){
$str_cost = "SELECT
meeting_room.rper,
meeting_room.rrent
FROM
meeting_room
WHERE
meeting_room.rid = '$rs_roomid'";
$qr_cost = mysql_query($str_cost) ;
$rs_cost = mysql_fetch_assoc($qr_cost);
$type_rent = $rs_cost[rper];
$arr_xstart = @explode(":" , $rs_time_start ) ;
$arr_xend = @explode(":" , $rs_time_end ) ;
$formhh1 = (int)$arr_xstart[0] ; $formmm1 = (int)$arr_xstart[1] ;
$formhh2 = (int)$arr_xend[0] ; $formmm2 = (int)$arr_xend[1] ;
$time_m = (($formhh2-$formhh1) * 60) + ($formmm2 - $formmm1);
if($type_rent == 1)
{
$rent1= $rs_cost[rrent];
$rent2= ($rs_cost[rrent] /(8*60))* ($time_m);
}else if($type_rent == 0)
{
$rent1= $rs_cost[rrent]*8;
$rent2 = ($rs_cost[rrent]/60)*$time_m;
}
$rent1 = (int)$rent1+ (int)$rs_cost_acc ;
$rent2 = (int)$rent2+ (int)$rs_cost_acc ;
} ######################### END if ($editid != ""){
echo $echostr ; $echostr ="";
?>
<table width="98%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#F5F5F5">
<tr>
<td><table width="100%">
<tr>
<td><strong>รายละเอียดการจองห้องประชุม</strong></td>
<td align="right">
<? if ($editid != ""){
$sql="select * from eoffice_config where appid='3' and modual_name='approvevisual' and varname='showmenu'";
$result=mysql_query($sql);
if($result){
$row=mysql_fetch_array($result);
$showmenu=$row['varvalue'];
}
if($showmenu=="on"&&$session_apppermit[3][10]){
echo"<a href=\"print_report.php?index=$editid\" target=\"_blank\"> พิมพ์บันทึกข้อความนำเสนอ </a>";
}
}?>
</td>
</tr>
<tr>
<td colspan="2" align="right">
<?
if($rs_staff_regis==$_SESSION[session_staffid]||$_SESSION[session_apppermit][3][10]=="on"){
echo "<a href=reserve_room.php?roomid=$rs_roomid&jump=$jump&editid=$rs_refid>
<img src='../../images/b_edit.png' width='16' height='16' border='0' alt='แก้ไขข้อมูล'></a> ";
}
echo $rrr[statusname];
?>
</td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#EEEEEE">
<tr>
<td width="4%" > </td>
<td width="19%" align="right">ห้อง : </td>
<td>
<? ############ roomid
if ($editid != ""){ ########if ($editid != ""){ เปิด List box เพื่อแก้ ห้องประชุมได้
//while (list($xmid, $xmname) = each($arr_meetingroom)){
// if ($roomid == $xmid ){ $str_select = " selected "; }else{ continue ;}
// echo $xmname;
//} ## END while (list($xmid, $xmname) = each($arr_meetingroom)){
echo $arr_meetingroom[$rs_roomid];
}else{
echo $xroomname ;
} ########if ($editid != ""){
?> <input type="hidden" id="hidRent1" name="hidRent1" value="<? echo $rent1 ?>">
<input type="hidden" id="hidRent2" name="hidRent2" value="<? echo $rent2 ?>">
<input type="hidden" id="hidTypeRent" name="hidTypeRent" value="<? echo $type_rent ?>">
</td>
</tr>
<tr>
<td> </td>
<td align="right">วันที่ : </td>
<td>
<?
$thyy = date("Y") + 543 ;
$nowdate=date("d") ."/". date("m") ."/". $thyy ;
$jump_th = convert2th($jump) ;
?>
<?=jump_daythai($jump)?> </td>
</tr>
<tr>
<td> </td>
<td align="right">เริ่มประชุมเวลา :</td>
<td width="77%"><?
$nowhh = date("G") ;
$nowmin = date("i") ;
$arr_xstart = @explode(":" , $rs_time_start ) ;
$arr_xend = @explode(":" , $rs_time_end ) ;
$xhh1 = (int)$arr_xstart[0] ; $xmm1 = (int)$arr_xstart[1] ;
$xhh2 = (int)$arr_xend[0] ; $xmm2 = (int)$arr_xend[1] ;
?> <?
$str_timestart = $xhh1 .":". $xmm1 ." " ; $str_timestart = str_replace(":0 ",":00",$str_timestart) ;
$str_timeend = $xhh2 .":". $xmm2 ." " ;$str_timeend = str_replace(":0 ",":00",$str_timeend) ;
echo " $str_timestart เลิกประชุมเวลา $str_timeend";
?> </td>
</tr>
<tr>
<td> </td>
<td align="right"> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td align="right">ประธานที่ประชุม : </td>
<td> <?=$rs_meeting_chairman?></td>
</tr>
<tr>
<td> </td>
<td align="right">หัวข้อการประชุม : </td>
<td> <?=$rs_meeting_topic?></td>
</tr>
<tr>
<td> </td>
<td align="right">ผู้ประสานงาน : </td>
<td> <?=$rs_contactpoint?> <?=$rs_groupname?" ( $rs_groupname ) ":""?></td>
</tr>
<tr>
<td> </td>
<td align="right">เบอร์โทรผู้ประสานงาน : </td>
<td> <?=$rs_contactpointtel?></td>
</tr>
<tr>
<td> </td>
<td align="right">จำนวนผู้เข้าร่วมประชุม : </td>
<td> <?=$rs_meeting_person?>
คน </td>
</tr>
<tr>
<td> </td>
<td align="right" valign="top"> อัตราค่าธรรมเนียม : </td>
<td><span id="money_payment" style="display:block"></span></td>
</tr>
<TR>
<TD> </TD>
<TD align="right">ชำระค่าธรรมเนียม ภายในวันที่ :</TD>
<TD>
<?
$jump_arr = explode("/",$jump);
$jump_sql_format = $jump_arr[2]."-".$jump_arr[1]."-".$jump_arr[0];
$mktime_jump = strtotime($jump_sql_format) - (24*3600) ;
$jump_yesterday = date("d/m/", $mktime_jump);
$jump_yesterday .= intval(date("Y", $mktime_jump-(24*3600))) ;
$rs_date_payment_limit = $rs_date_payment_limit ? $rs_date_payment_limit : $jump_yesterday ;
?>
<?=jump_daythai($rs_date_payment_limit)?>
<input type="hidden" name="txtCost" id="txtCost" value="" >
<input type="hidden" name="NoCost" id="NoCost" value="" ></TD>
</TR>
<?
if($rs_admin_confirm == 31 && $rs_cost_request > 0 ){
?>
<tr>
<td> </td>
<td align="right">เลขที่ใบเสร็จ :</td>
<td><?=$rs_billCost?></td>
</tr>
<?
}
$sql1 = " select * from meeting_accessories ";
$result1 = mysql_query($sql1) ;
if(@mysql_num_rows($result1) > 0){
?>
<tr>
<td> </td>
<td align="right" valign="top">อุปกรณ์โสต :</td>
<td>
<?
$sql = " SELECT meeting_reserve_access.reserve_id, meeting_reserve_access.reserve_id, meeting_reserve_access.accid, meeting_reserve_access.costbath, meeting_accessories.accname FROM meeting_reserve_access Inner Join meeting_accessories ON meeting_reserve_access.accid = meeting_accessories.accid WHERE reserve_id = '$editid' ";
$result = @mysql_query($sql) ;
while ($rs = @mysql_fetch_assoc($result)){
echo " $rs[accname] <br> " ;
}
?> </td>
</tr>
<? }?>
<tr>
<td> </td>
<td align="right"> </td>
<td>
<? ############ roomid
/*
statusid
statusname
statuscolor
statusimg
*/
//echo "<pre>"; print_r($_SESSION); echo "</pre>";
$code_status = $session_apppermit[3][100] ? "Where statusid in (20,30,31)" : "Where statusid in (10,21)" ;
$sql = " SELECT * FROM meeting_status $code_status order by statusid " ;
$result = mysql_query($sql) ;
$jump_arr = explode("/",$jump);
$jump_new = $jump_arr[2] ."-". $jump_arr[1] ."-". $jump_arr[0];
if( ( ( $session_apppermit[3][100] ) || ($jump_new >= date("Y-m-d") && $session_staffid==$rs_staff_regis ) ) && (($rs_admin_confirm != "31") || ($rs_admin_confirm == "31" && $rs_cost_request == 0 )) ){
?>
<select name="frm_roomstatus" onChange="javascript:getTypeCost(this);">
<option value='' > - ตัวเลือกดำเนินการ -</option>
<?
#while (list($xmid, $xmname) = each($arr_meetingroom))
while ($rs = mysql_fetch_assoc($result)){
if ($rs[statusid] == $rs_admin_confirm ){ $str_select = " selected "; }else{ $str_select= "";}
if($rs[statusid]=='21' && $jump_new <= date("Y-m-d")) {
if( $rs_admin_confirm == "10" || $rs_admin_confirm == "20" || $rs_admin_confirm == "21" ){
echo " <option value='$rs[statusid]' $str_select > $rs[statusname]</option>";
}
}else{
if( ( $rs_admin_confirm > 10 && $rs[statusid] > 10 ) || $rs_admin_confirm == 10){
if( ($rs[statusid] == 21 ||$rs[statusid] == 20 || $rs[statusid] == 30 ) && $jump_new <= date("Y-m-d") ){
}else{
echo " <option value='$rs[statusid]' $str_select > $rs[statusname]</option>";
}
}
}
}
?>
</select>
<? }?>
<!--
<input type="button" name="cancelapprove" value="แจ้งยกเลิกการจอง" >
<input type="button" name="cancelapprove2" value="ตอบรับแจ้งยกเลิกการจอง" >
-->
</td>
</tr>
<!-- <tr>
<td> </td>
<td align="right" > </td>
<td><div id="divTypeCost"></div></td>
</tr>-->
<tr>
<td> </td>
<td align="right"> </td>
<td><div id="divCost"></div></td>
</tr>
<tr>
<td> </td>
<td align="right" > </td>
<td><div id="divTypeCost"></div></td>
</tr>
<tr>
<td> </td>
<td align="right" > </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>
<input name="roomid" type="hidden" id="roomid" value="<?=$roomid?>">
<input name="jump" type="hidden" id="jumpdate" value="<?=$jump?>">
<input name="editid" type="hidden" id="editid" value="<?=$editid?>">
<input name="frm_oldroomid" type="hidden" id="frm_oldroomid" value="<?=$roomid?>">
<?
$arr_xstart = @explode(":" , $rs_time_start ) ;
$arr_xend = @explode(":" , $rs_time_end ) ;
?>
<input name="formhh1" type="hidden" id="formhh1" value="<?=$arr_xstart[0]?>">
<input name="formmm1" type="hidden" id="formmm1" value="<?=$arr_xstart[1]?>">
<input name="formhh2" type="hidden" id="formhh2" value="<?=$arr_xend[0]?>">
<input name="formmm2" type="hidden" id="formmm2" value="<?=$arr_xend[1]?>">
<input name="payment_money" type="hidden" id="payment_money" value="">
<script language="javascript">
function addCommas(nStr)
{
nStr += '';
x = nStr.split('.');
x1 = x[0];
x2 = x.length > 1 ? '.' + x[1] : '';
var rgx = /(\d+)(\d{3})/;
while (rgx.test(x1)) {
x1 = x1.replace(rgx, '$1' + ',' + '$2');
}
return x1 + x2;
}
function room_bill(){
<?
$sql = " SELECT meeting_room_owner FROM epm_staff where staffid ='$rs_staff_regis' limit 1";
$query = mysql_query($sql) ;
$row_result = @mysql_fetch_assoc($query) ;
if($row_result[meeting_room_owner]){
?>
document.getElementById('money_payment').innerHTML = "งดค่าธรรมเนียมเนื่องจากเป็นหน่วยงานเจ้าของสถานที่" ;
<?
}else{
?>
if( parseFloat(document.getElementById('formhh1').value) < 10 ){
hour_st = document.getElementById('formhh1').value.substring(1);
}else{
hour_st = parseFloat(document.getElementById('formhh1').value) ;
}
if( parseFloat(document.getElementById('formhh2').value) < 10 ){
hour_en = document.getElementById('formhh2').value.substring(1);
}else{
hour_en = parseFloat(document.getElementById('formhh2').value) ;
}
if(hour_st > hour_en){
alert("เวลาเลิกประชุม ควรมากกว่า เวลา เริ่มประชุม!");
return false;;
}
minute_st = parseFloat(document.getElementById('formmm1').value/ 60) ;
minute_en = parseFloat(document.getElementById('formmm2').value/ 60) ;
var room_pay = <?=$rs_roomrrent?>;
def_hour = parseFloat(hour_en) + parseFloat(minute_en) - parseFloat(hour_st) - parseFloat(minute_st);
pay_money = room_pay * def_hour ;
//alert( pay_money + " บาท");
pay_money2 = addCommas(pay_money.toFixed(2));
document.getElementById('money_payment').innerHTML = pay_money2 + " บาท" ;
document.getElementById('txtCost').value = pay_money ;
<? } ?>
}
room_bill();
getTypeCost(document.getElementById('frm_roomstatus'));
</script>
</td>
<td><input name="approve_reserve" type="submit" id="approve_reserve" value="บันทึก"> <input type="button" name="Submit2" value="กลับหน้าหลัก" onClick="window.location='main.php' " ></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table></td>
</tr>
</table>
</form>
</td>
</tr>
<tr>
<td align="left" valign="top">
</td>
</tr>
</table></td>
</tr>
</table>
<?
include "footer.php";
//insert timeQuery
$time_end = getmicrotime();
writetime2db($timestart,$timeend);
//insert timeQuery
?>