|
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");
$phpfile = "reserve_room.php" ;
##meeting_reserve
################ HARD FIX
#$_SESSION[session_staffid] = 49 ;
$user=$_SESSION[session_staffid];
################
?>
<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 "menu_bar.php";
include "../../common/tag_alt.txt";
?>
<?
$table_var1 = " <br><table width='300' border='0' cellspacing='0' cellpadding='0' align='center' ><tr>
<td width='51'><img src='../../images/alert.gif' width=31 height=32></td>
<td width='349' valign=middle align='center' > ";
$table_var2 = " </td> </tr></table> <br>";
if ($save_reserve != "" AND $editid == ""){
############################# while (list ($key, $val) = each ($_POST)) { echo " <br> $key ::::::::: $val "; }
$mysql_date = convert_2mysql($pdate) ;
$time_start = $formhh1 .":". $formmm1 ; $frm_start = $time_start ;
$time_end = $formhh2 .":". $formmm2 ; $frm_end = $time_end ;
#------------------------------------------------------------------------------------------------------------------------------------Start ตรวจสอบการจองห้องซ้ำ
$sql = " SELECT * FROM meeting_reserve WHERE
(('$frm_start' BETWEEN time_start AND time_end AND ('$frm_start' >time_end)) OR
('$frm_end' BETWEEN time_start AND time_end AND ('$frm_end' >time_start)))
AND daterent = '$mysql_date' AND roomid = '$roomid' ";
$result = mysql_query($sql) ;
if (@mysql_num_rows($result)){
$rs = @mysql_fetch_assoc($result) ;
$roomid = $frm_oldroomid ;
$echostr = "$table_var1 <b> ห้องที่เลือกในช่วงเวลา $time_start - $time_end ไม่ว่าง <br> กรุณาเลือกห้องหรือช่วงเวลาอีกครั้ง </b> $table_var2";
$echostr = str_replace( ":0 ",":00 " ,$echostr ) ;
$rs_meeting_chairman = $meeting_chairman ;
$rs_meeting_topic = $meeting_topic ;
$rs_contactpoint = $contactpoint ;
$rs_contactpointtel = $contactpointtel ;
$rs_meeting_person = $meeting_person ;
}else{
$sql = " INSERT INTO meeting_reserve ( roomid,daterent,time_start,time_end,staff_regis,contactpoint,
contactpointtel,meeting_topic,meeting_chairman,meeting_person , admin_confirm ) VALUES (
'$roomid','$mysql_date','$time_start','$time_end','$user','$contactpoint',
'$contactpointtel','$meeting_topic','$meeting_chairman' ,'$meeting_person' , 10 ) ";
$result = mysql_query($sql) ; #-------------------------------------------บันทึก
echo mysql_error() ;
$mysql_insertid = mysql_insert_id() ;
while (list ($key, $val) = each ($_POST)) { ################# เริ่มบันทึก อุปกรณ์โสต
if (eregi('frmaccid_', $key)) {
$post_runid = str_replace("frmaccid_","",$key) ;
$frm_bath1 = "frmpricebath_" . $post_runid ;eval("\$frm_bath1 = \"$frm_bath1\";"); $frm_bath = $$frm_bath1 ;
$sql0 = "REPLACE INTO meeting_reserve_access ( reserve_id,accid,costbath) VALUES ( '$mysql_insertid','$post_runid','$frm_bath') ";
mysql_query($sql0) ;
} ############# if (eregi('frmaccid_', $key)) {
} ################ END while (list ($key, $val) = each ($_POST)) {
} ############ if (mysql_num_rows($result)){
#SELECT * FROM meeting_reserve WHERE (('10:0' BETWEEN time_start AND time_end AND ('10:0' >time_end)) OR ('10:0' BETWEEN time_start AND time_end AND ('10:0' >time_start))) AND daterent = '2009-03-14' AND roomid = '3'
# xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx frmaccid_
# UPDATE meeting_reserve_access SET reserve_id='3' WHERE (runid='16')
# INSERT INTO meeting_reserve_access ( reserve_id,accid,costbath) VALUES ( '3','2','200')
#---------------------------------------------------------------------------------------------------------------------------------------END ตรวจสอบการจองห้องซ้ำ
} ############# if ($save_reserve != ""){
if ($save_reserve != "" AND $editid != ""){
$mysql_date = convert_2mysql($pdate) ;
$time_start = $formhh1 .":". $formmm1 ; $frm_start = $time_start ;
$time_end = $formhh2 .":". $formmm2 ; $frm_end = $time_end ;
if ($frm_roomid != ""){ $updateroomid = $frm_roomid ; }else{ $updateroomid = $roomid; }
$roomid = $updateroomid ;
#---------------------------------------------------------------------------------------------------------------------------------------Start ตรวจสอบการจองห้องซ้ำ
# (time_start >= '$time_start' AND time_end <= '$time_start') OR
$sql = " SELECT * FROM meeting_reserve WHERE
(('$frm_start' BETWEEN time_start AND time_end AND ('$frm_start' >time_end)) OR
('$frm_end' BETWEEN time_start AND time_end AND ('$frm_end' >time_start)))
AND daterent = '$mysql_date' AND roomid = '$roomid'
AND refid != $editid
";
$result = mysql_query($sql) ;
if (@mysql_num_rows($result)){
$rs = @mysql_fetch_assoc($result) ;
$roomid = $frm_oldroomid ;
$echostr = "$table_var1<center><b> ห้องที่เลือกในช่วงเวลา $time_start - $time_end ไม่ว่าง <br> กรุณาเลือกห้องหรือช่วงเวลาอีกครั้ง </b></center> $table_var2";
$echostr = str_replace( ":0 ",":00 " ,$echostr ) ;
}else{
$sql = " UPDATE meeting_reserve SET
roomid='$updateroomid',daterent='$mysql_date',time_start='$time_start',time_end='$time_end',staff_regis='$user',
contactpoint='$contactpoint',contactpointtel='$contactpointtel',meeting_topic='$meeting_topic',
meeting_chairman='$meeting_chairman',meeting_person='$meeting_person'
WHERE (refid='$editid') ";
$result = mysql_query($sql) ; #-------------------------------------------บันทึก
echo mysql_error() ;
$sql = " DELETE FROM meeting_reserve_access WHERE ( reserve_id='$editid') ";
$result = mysql_query($sql) ; echo mysql_error() ;
while (list ($key, $val) = each ($_POST)) { ################# เริ่มบันทึก อุปกรณ์โสต
if (eregi('frmaccid_', $key)) {
$post_runid = str_replace("frmaccid_","",$key) ;
$frm_bath1 = "frmpricebath_" . $post_runid ;eval("\$frm_bath1 = \"$frm_bath1\";"); $frm_bath = $$frm_bath1 ;
$sql0 = "REPLACE INTO meeting_reserve_access ( reserve_id,accid,costbath) VALUES ( '$editid','$post_runid','$frm_bath') ";
mysql_query($sql0) ;
} ############# if (eregi('frmaccid_', $key)) {
} ################ END while (list ($key, $val) = each ($_POST)) {
} ############ if (mysql_num_rows($result)){
#---------------------------------------------------------------------------------------------------------------------------------------END ตรวจสอบการจองห้องซ้ำ
} ########### END if ($save_reserve != "" AND $editid != ""){
?>
<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" 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
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)){
$xroomid = $rs[roomid] ;
$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><br> ========== $xroomid $xrefid $rs[meeting_topic] ";
$arr_meetingtopic[$xroomid][$xrefid] = $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)){
####################################################################
$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 rowspan="2" align="center" > </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" ;}
$xroomid = $rs[rid] ;
$xrefid = $editid ;
$arr001 = $arr_starthh[$xroomid] ;
$xroomname = $rs[rname] ;
$arr_meetingroom[$xroomid] = $xroomname ;
# echo "<br><br> ==========ห้อง $xroomid || xrefid=$xrefid || editid=$editid ";
while (list ($xrefid, $val) = @each($arr001)) { ########## หาว่าห้อง $roomid มีการประชุมกี่โมง
$val = (int)$val ;
# 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] ;
$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?>"></a>
<img src="../../images/document_add.gif" alt="จอง <?=$rs[rname]?>" width="20" height="20" border="0"> </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"]?>> <?=$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 colspan="7"><strong>สถานะการจองห้องประชุม</strong></td>
</tr>
<tr>
<td width="5%"> </td>
<td width="3%" bgcolor="#FFFFFF"> </td>
<td width="27%"> ห้องประชุมว่าง</td>
<td width="3%" bgcolor="#FFFF99"> </td>
<td width="26%"> จองห้องประชุม</td>
<td width="3%" bgcolor="#A0C779"> </td>
<td width="33%"> ผ่านยืนยันการจองโดยผู้ดูแลระบบ</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_room.php?roomid=<?=$roomid?><?=$poststr?>">
<?
if ($editid != ""){
$sql = " SELECT * FROM meeting_reserve WHERE refid = '$editid' ";
$result = mysql_query($sql) ;
while ($rs = mysql_fetch_assoc($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_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] ;
} ########## END while ($rs = mysql_fetch_assoc($result)){
} ######################### END if ($editid != ""){
echo $echostr ; $echostr ="";
?>
<table width="98%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#F5F5F5">
<tr>
<td><strong>รายละเอียดการจองห้องประชุม</strong></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 เพื่อแก้ ห้องประชุมได้
?>
<select name="frm_roomid">
<? while (list($xmid, $xmname) = each($arr_meetingroom)){
if ($roomid == $xmid ){ $str_select = " selected "; }else{ $str_select= "";}
?>
<option value="<?=$xmid?>" <?=$str_select?> ><?=$xmname?> </option>
<? } ## END while (list($xmid, $xmname) = each($arr_meetingroom)){ ?>
</select>
<?
}else{
echo $xroomname ;
?>
<a href='main.php?jump=$jump'>เปลี่ยนห้องประชุม</a>
<? } ########if ($editid != ""){ ?>
</td>
</tr>
<tr>
<td> </td>
<td align="right">วันที่ : </td>
<td>
<?
$thyy = date("Y") + 543 ;
$nowdate=date("d") ."/". date("m") ."/". $thyy ;
$jump_th = convert2th($jump) ;
?>
<INPUT name="pdate" type="text" class="input" id="pdate" style="width:120px;" value="<?=$jump_th?>" maxlength="10" readonly>
<SCRIPT language='javascript'> if (!document.layers) { document.write("<input type=button onclick='popUpCalendar(this, post.pdate, \"dd/mm/yyyy\")' value=' เลือกวัน ' class='input'>") }</SCRIPT> </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] ;
?>
<select name="formhh1">
<? for ($ii = 0; $ii < 24 ; $ii++){
#if ($nowmin==$ii){$str_select = " selected "; }else{ $str_select= "";}
if ($ii==8 and $editid =="" ){$str_select = " selected "; }else{
$str_select= ""; if ($ii==$xhh1 and $editid !="" ){$str_select = " selected "; }else{ $str_select= "";}
}##############################END if ($ii==8 and $editid =="" ){ .................
echo " <option value=$ii $str_select >$ii นาฬิกา</option> ";
} ?>
</select>
<select name="formmm1">
<? for ($ii = 0; $ii < 61 ; $ii++){
# if ($nowmin==$ii){$str_select = " selected "; }else{ $str_select= "";}
if ($ii==0 and $editid =="" ){$str_select = " selected "; }else{
$str_select= ""; if ($ii==$xmm1 and $editid !="" ){$str_select = " selected "; }else{ $str_select= "";}
}##############################END if ($ii==8 and $editid =="" ){ .................
echo " <option value=$ii $str_select >$ii นาที</option> ";
} ?>
</select>
เลิกประชุมเวลา
<select name="formhh2">
<? for ($ii = 0; $ii < 24 ; $ii++){
#if ($nowmin==$ii){$str_select = " selected "; }else{ $str_select= "";}
if ($ii==8 and $editid =="" ){$str_select = " selected "; }else{
$str_select= ""; if ($ii==$xhh2 and $editid !="" ){$str_select = " selected "; }else{ $str_select= "";}
}##############################END if ($ii==8 and $editid =="" ){ .................
echo " <option value=$ii $str_select >$ii นาฬิกา</option> ";
} ?>
</select>
<select name="formmm2">
<? for ($ii = 0; $ii < 61 ; $ii++){
# if ($nowmin==$ii){$str_select = " selected "; }else{ $str_select= "";}
if ($ii==0 and $editid =="" ){$str_select = " selected "; }else{
$str_select= ""; if ($ii==$xmm2 and $editid !="" ){$str_select = " selected "; }else{ $str_select= "";}
}##############################END if ($ii==8 and $editid =="" ){ .................
echo " <option value=$ii $str_select >$ii นาที</option> ";
} ?>
</select>
</td>
</tr>
<tr>
<td> </td>
<td align="right"> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td align="right">ประธานที่ประชุม : </td>
<td><input name="meeting_chairman" type="text" id="meeting_chairman" value="<?=$rs_meeting_chairman?>" size="80"></td>
</tr>
<tr>
<td> </td>
<td align="right">หัวข้อการประชุม : </td>
<td><input name="meeting_topic" type="text" id="meeting_topic" value="<?=$rs_meeting_topic?>" size="80"></td>
</tr>
<tr>
<td> </td>
<td align="right">ผู้ประสานงาน : </td>
<td><input name="contactpoint" type="text" id="contactpoint" value="<?=$rs_contactpoint?>" size="80"></td>
</tr>
<tr>
<td> </td>
<td align="right">เบอร์โทรผู้ประสานงาน : </td>
<td><input name="contactpointtel" type="text" id="contactpointtel" value="<?=$rs_contactpointtel?>" size="80"></td>
</tr>
<tr>
<td> </td>
<td align="right">จำนวนผู้เข้าร่วมประชุม : </td>
<td><input name="meeting_person" type="text" id="meeting_person" value="<?=$rs_meeting_person?>" size="4" maxlength="4">
คน ระบุข้อมูลเป็นตัวเลขเช่น "241" </td>
</tr>
<tr>
<td> </td>
<td align="right"> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td align="right">อุปกรณ์โสต : </td>
<td><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td width="6%" bgcolor="#EEEEEE"> </td>
<td width="71%" align="center" bgcolor="#EEEEEE"><strong>อุปกรณ์</strong></td>
<td width="23%" align="center" bgcolor="#EEEEEE"><strong>ราคาต่อหน่วย</strong></td>
</tr>
<?
############ accid accname accdetail accunit accprice
$sql1 = " select * from meeting_accessories ";
$result1 = mysql_query($sql1) ;
while ($rs1 = mysql_fetch_assoc($result1)){
?>
<tr>
<td align="center" bgcolor="#EEEEEE">
<input name="frmaccid_<?=$rs1[accid]?>" type="checkbox" id="frmaccid_<?=$rs1[accid]?>" value="checkbox"></td>
<td bgcolor="#EEEEEE"><?=$rs1[accname]?>
<input name="frmpricebath_<?=$rs1[accid]?>" type="hidden" id="frmpricebath_<?=$rs1[accid]?>" value="<?=$rs1[accprice]?>">
</td>
<td align="center" bgcolor="#EEEEEE"><?=$rs1[accprice]?> บาท </td>
</tr>
<?
}
?>
<tr>
<td bgcolor="#EEEEEE"> </td>
<td bgcolor="#EEEEEE"> </td>
<td bgcolor="#EEEEEE"> </td>
</tr>
</table></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?>"></td>
<td><input type="submit" name="save_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> </td>
</tr>
</table></td>
</tr>
</table>
<?
include "footer.php";
?>