|
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");
include("var.inc.php");
//insert timeQuery
include("../../common/common_system.inc.php");
$ApplicationName="meeting";
$strSQL="
SELECT
meeting_reserve.refid,
meeting_reserve.admin_confirm,
meeting_reserve.daterent,
meeting_reserve.time_start,
meeting_reserve.time_end,
meeting_room.rrent,
epm_staff.meeting_room_owner,
meeting_reserve.staff_regis,
concat( ((meeting_reserve.time_end - meeting_reserve.time_start)/1000) + if ( ((meeting_reserve.time_end - meeting_reserve.time_start)/1000)%10=7 ,-2 ,if( ((meeting_reserve.time_end - meeting_reserve.time_start)/1000)%10=3 ,2 ,0 ) ) )/10 as time_user,
concat( ((meeting_reserve.time_end - meeting_reserve.time_start)/1000) + if ( ((meeting_reserve.time_end - meeting_reserve.time_start)/1000)%10=7 ,-2 ,if( ((meeting_reserve.time_end - meeting_reserve.time_start)/1000)%10=3 ,2 ,0 ) ) )/10*meeting_room.rrent AS cost_request
FROM
meeting_reserve
Inner Join meeting_room ON meeting_reserve.roomid = meeting_room.rid
Inner Join epm_staff ON epm_staff.staffid = meeting_reserve.staff_regis
ORDER BY meeting_reserve.daterent ASC
";
$Result_A = @mysql_query($strSQL);
while( $Rs_A = @mysql_fetch_assoc($Result_A) ) {
if($Rs_A[meeting_room_owner] == '1' || $Rs_A[daterent] < '2010-05-01' ){
$Rs_A[cost_request] = "0";
$Rs_A[admin_confirm] = "31";
}
$strSQL="
UPDATE `meeting_reserve` SET `cost_request`='$Rs_A[cost_request]',`admin_confirm`='$Rs_A[admin_confirm]' WHERE (`refid`='$Rs_A[refid]')
";
echo $strSQL."<br>";
@mysql_query($strSQL);
}
?>