|
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 : |
<?
session_start();
include("../../config/config.inc.php");
include("../../common/function.php");
$sql="select * from eoffice_config where appid='3' and modual_name='approvevisual' and varname='prosition'";
$result=mysql_query($sql);
if($result){
$row=mysql_fetch_array($result);
$prosition_name=$row['varvalue'];
}
$sql="select * from eoffice_config where appid='3' and modual_name='approvevisual' and varname='province'";
$result=mysql_query($sql);
if($result){
$row=mysql_fetch_array($result);
$province_name=$row['varvalue'];
}
$sql="select * from eoffice_config where appid='3' and modual_name='approvevisual' and varname='name'";
$result=mysql_query($sql);
if($result){
$row=mysql_fetch_array($result);
$name=$row['varvalue'];
}
$id=$_GET['index'];
$sql = " SELECT
meeting_reserve.refid,
meeting_reserve.roomid,
meeting_reserve.daterent,
meeting_reserve.time_start,
meeting_reserve.time_end,
meeting_reserve.staff_regis,
meeting_reserve.contactpoint,
meeting_reserve.contactpointtel,
meeting_reserve.meeting_topic,
meeting_reserve.meeting_chairman,
meeting_reserve.meeting_person,
meeting_reserve.admin_confirm,
meeting_reserve.cost_request,
meeting_reserve.cost_paid,
meeting_reserve.date_paid,
meeting_reserve.updatetime,
meeting_reserve.`comment`,
meeting_reserve_access.costbath AS costb,
meeting_room.rname
FROM
meeting_reserve
Left Join meeting_reserve_access ON meeting_reserve.refid = meeting_reserve_access.reserve_id
Inner Join meeting_room ON meeting_reserve.roomid = meeting_room.rid
WHERE refid = '$id'";
$result = mysql_query($sql) ;
while ($rs = mysql_fetch_assoc($result)){
$sql="Select org_staffgroup.groupname 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'];
$rs_roomid = $rs[roomid] ;
$rs_roomname = $rs[rname] ;
$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] ;
$rs_cost_acc = $rs[costb];
}
$rs_daterent=convert_mysql2th($rs_daterent );
$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) ;
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<title>µÑ駤èÒ</title>
<style type="text/css">
<!--
body {
margin-left: 10px;
margin-top: 10px;
margin-right: 10px;
margin-bottom: 10px;
}
.boxline{
border-top-width: 1px;
border-right-width: 0px;
border-bottom-width: 0px;
border-left-width: 0px;
border-top-style: solid;
border-top-color: #000;
border-right-color: #000;
border-bottom-color: #000;
border-left-color: #000;
border-right-style: none;
border-bottom-style: none;
border-left-style: none;
width: 150px;
visibility: inherit;
text-align: center;
}
.boxlineunder{
border-top-width: 0px;
border-right-width: 0px;
border-bottom-width: 1px;
border-left-width: 0px;
border-top-style: none;
border-top-color: #000;
border-right-color: #000;
border-bottom-color: #000;
border-left-color: #000;
border-right-style: none;
border-bottom-style: solid;
border-left-style: none;
}
body,td,th {
font-family: Verdana, Geneva, sans-serif;
font-size: 12px;
color: #000;
}
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
}
.buuton{
font-family: Verdana, Geneva, sans-serif;
font-size: 14px;
text-decoration: none;
height: 20px;
width: 50px;
color: #000;
}
.header{
font-family: Verdana, Geneva, sans-serif;
font-size: 16px;
font-weight: bold;
color: #006;
text-decoration: none;
}
.caption{
font-family: Verdana, Geneva, sans-serif;
font-size: 14px;
font-weight: normal;
color: #000;
}
-->
</style>
</head>
<body >
<form id="form1" name="form1" method="post" action="">
<table width="100%">
<tr>
<td width="12%"> </td>
<td width="88%"> </td>
</tr>
<tr>
<td> </td>
<td class="header">µÑ駤èÒ¢éÍÁÙÅ</td>
</tr>
<tr>
<td height="10" colspan="2"></td>
</tr>
<tr>
<td align="right" class="caption">ª×èͨѧËÇÑ´</td>
<td><input type="text" name="textfield" id="textfield" /></td>
</tr>
<tr>
<td height="10" colspan="2"></td>
</tr>
<tr>
<td align="right">µÓá˹è§</td>
<td><input type="text" name="textfield2" id="textfield2" /></td>
</tr>
<tr>
<td height="10" colspan="2"></td>
</tr>
<tr>
<td align="right">ª×èÍ</td>
<td><input type="text" name="textfield3" id="textfield3" /></td>
</tr>
<tr>
<td height="10" colspan="2"></td>
</tr>
<tr>
<td> </td>
<td><input name="button" type="submit" class="buuton" id="button" value="µ¡Å§" />
<label>
<input name="button2" type="reset" class="buuton" id="button2" value="¡àÅÔ¡" />
</label></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table>
</form>
</body >
</html>