\n \n \n\t\t\t\t\t

\u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n

\u5009\u5eab\u7de8\u865f<\/td>\n	\u5c3a\u5bf8<\/td>\n	\u539f\u50f9(\u6708)<\/td>\n	\u512a\u60e0\u50f9(\u6708)<\/td>\n	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n	\u50f9\u683c<\/td>\n	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n	<\/td>\n <\/tr>
WC-11 <\/td>\n\t\t\t\t\t	2.5X2.5X4 <\/td>\n\t\t\t\t\t	$798.00 <\/td>\n\t\t\t\t	- <\/td>	<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"6.25","total_discounted_price":"758.00","deposit":"1596.00","total_retail_price":"798.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 16:59:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","8","2080","NEW","WC-CT2110682",798,758,1596,0,"3","3",3870,3870,3870,"2021-02-26 16:59:52","0",null,null,null,"2021-04-02","2021-07-01","3 months contract. Storage rental(2274) and deposit($1596) paid by EPS on Feb 26,2021. ","2021-04-02","6.25",0,null,0,"0.00","2","2021-02-26 16:59:52","2","2021-02-26 16:59:52","EPS","","","","EPS","","","",null,0,"","C212080","PERSONAL","Mr","KbIuW2LF7pbcg2iC7q6HNnViY0F6hKaOwivsKHNiYaE=","20knVHhKlM9kB5wugwP3yQ==","","xSZQE\/iF03vvaSD5vA4kJp+qKfey9wpWQRaiiWfq05Uos9kI4zbxpaFf\/uE\/iwbI19+bWsXGb0PJDXAlnTgCNA==","geD6QdOay\/mX9uQJFxfopg==",null,"6P6K7LPcmfBS+5V7T340mQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 16:59:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["10682","1758","798.0","798.00","2","2021-02-26 16:59:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 16:59:52","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2021-04-02","2021-07-01","1758"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2021-02-26 16:59:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["10682","WC-D216174","PAID",1596,0,"2021-07-01","2021-02-26 16:59:52","2021-02-26 16:59:52","2","2021-02-26 16:59:52","2","2021-02-26 16:59:52","2080"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 16:59:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10682","2080","SETTLED","WC-I2111011","2021-02-26 16:59:52","2021-04-02","2","2021-02-26 16:59:52","2","2021-02-26 16:59:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 16:59:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11011","RENT","\u9810\u7e73\u79df\u91d1",1,758,"MO","1",758,"2","2021-02-26 16:59:52","2","2021-02-26 16:59:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 16:59:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11011","RENT","\u9810\u7e73\u79df\u91d1",2,758,"MO","1",758,"2","2021-02-26 16:59:52","2","2021-02-26 16:59:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 16:59:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11011","RENT","\u9810\u7e73\u79df\u91d1",3,758,"MO","1",758,"2","2021-02-26 16:59:52","2","2021-02-26 16:59:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 16:59:52","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2274,0,"11011"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2021-02-26 16:59:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["2080","EPS","","","","EPS","","","","PAID","P2110645","2021-02-26 16:59:52",3870,"2","2021-02-26 16:59:52","2","2021-02-26 16:59:52","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 16:59:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10645","DEPOSIT","6174","PAID","2021-02-26 16:59:52",1596,"2","2021-02-26 16:59:52","2","2021-02-26 16:59:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 16:59:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10645","INVOICE","11011","PAID","2021-02-26 16:59:52",2274,"2","2021-02-26 16:59:52","2","2021-02-26 16:59:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 16:59:53","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 16:59:53","OPEN_FOR_INTERNAL","2021-02-26 16:59:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 16:59:53","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 16:59:53","OPEN_FOR_INTERNAL","2021-02-26 16:59:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:09:41","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:09:41","OPEN_FOR_INTERNAL","2021-02-26 17:09:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:09:48","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:09:48","OPEN_FOR_INTERNAL","2021-02-26 17:09:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:09:48","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:09:48","OPEN_FOR_INTERNAL","2021-02-26 17:09:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:09:51","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:09:51","OPEN_FOR_INTERNAL","2021-02-26 17:09:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:09:52","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:09:52","OPEN_FOR_INTERNAL","2021-02-26 17:09:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:09:59","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:09:59","OPEN_FOR_INTERNAL","2021-02-26 17:09:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:09:59","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:09:59","OPEN_FOR_INTERNAL","2021-02-26 17:09:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:10:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:10:08","OPEN_FOR_INTERNAL","2021-02-26 17:10:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:10:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:10:10","OPEN_FOR_INTERNAL","2021-02-26 17:10:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:10:12","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:10:12","OPEN_FOR_INTERNAL","2021-02-26 17:10:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:10:14","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:10:14","OPEN_FOR_INTERNAL","2021-02-26 17:10:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:10:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:10:15","OPEN_FOR_INTERNAL","2021-02-26 17:10:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:10:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:10:15","OPEN_FOR_INTERNAL","2021-02-26 17:10:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:10:56","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:10:56","OPEN_FOR_INTERNAL","2021-02-26 17:10:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:11:01","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:11:01","OPEN_FOR_INTERNAL","2021-02-26 17:11:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:11:01","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:11:01","OPEN_FOR_INTERNAL","2021-02-26 17:11:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:11:04","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:11:04","OPEN_FOR_INTERNAL","2021-02-26 17:11:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:11:05","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:11:05","OPEN_FOR_INTERNAL","2021-02-26 17:11:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:11:05","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:11:05","OPEN_FOR_INTERNAL","2021-02-26 17:11:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:11:05","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:11:05","OPEN_FOR_INTERNAL","2021-02-26 17:11:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:11:06","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:11:06","OPEN_FOR_INTERNAL","2021-02-26 17:11:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:11:07","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:11:07","OPEN_FOR_INTERNAL","2021-02-26 17:11:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:11:07","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:11:07","OPEN_FOR_INTERNAL","2021-02-26 17:11:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:11:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:11:08","OPEN_FOR_INTERNAL","2021-02-26 17:11:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:11:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:11:08","OPEN_FOR_INTERNAL","2021-02-26 17:11:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:11:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:11:08","OPEN_FOR_INTERNAL","2021-02-26 17:11:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:11:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:11:08","OPEN_FOR_INTERNAL","2021-02-26 17:11:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:11:14","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:11:14","OPEN_FOR_INTERNAL","2021-02-26 17:11:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:11:20","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:11:20","OPEN_FOR_INTERNAL","2021-02-26 17:11:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:12:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:12:13","OPEN_FOR_INTERNAL","2021-02-26 17:12:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:12:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:12:13","OPEN_FOR_INTERNAL","2021-02-26 17:12:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:12:14","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:12:14","OPEN_FOR_INTERNAL","2021-02-26 17:12:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:12:14","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:12:14","OPEN_FOR_INTERNAL","2021-02-26 17:12:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:12:21","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:12:21","OPEN_FOR_INTERNAL","2021-02-26 17:12:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:12:21","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:12:21","OPEN_FOR_INTERNAL","2021-02-26 17:12:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:12:21","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:12:21","OPEN_FOR_INTERNAL","2021-02-26 17:12:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:12:22","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:12:22","OPEN_FOR_INTERNAL","2021-02-26 17:12:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:12:22","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:12:22","OPEN_FOR_INTERNAL","2021-02-26 17:12:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:12:22","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:12:22","OPEN_FOR_INTERNAL","2021-02-26 17:12:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:12:23","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:12:23","OPEN_FOR_INTERNAL","2021-02-26 17:12:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:12:26","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:12:26","OPEN_FOR_INTERNAL","2021-02-26 17:12:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:05","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:13:05","OPEN_FOR_INTERNAL","2021-02-26 17:13:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:06","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:13:06","OPEN_FOR_INTERNAL","2021-02-26 17:13:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:06","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:13:06","OPEN_FOR_INTERNAL","2021-02-26 17:13:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:06","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:13:06","OPEN_FOR_INTERNAL","2021-02-26 17:13:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:07","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:13:07","OPEN_FOR_INTERNAL","2021-02-26 17:13:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:13:08","OPEN_FOR_INTERNAL","2021-02-26 17:13:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:13:08","OPEN_FOR_INTERNAL","2021-02-26 17:13:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:13:08","OPEN_FOR_INTERNAL","2021-02-26 17:13:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:13:08","OPEN_FOR_INTERNAL","2021-02-26 17:13:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:13:08","OPEN_FOR_INTERNAL","2021-02-26 17:13:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:13:09","OPEN_FOR_INTERNAL","2021-02-26 17:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:13:15","OPEN_FOR_INTERNAL","2021-02-26 17:13:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:13:15","OPEN_FOR_INTERNAL","2021-02-26 17:13:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:13:15","OPEN_FOR_INTERNAL","2021-02-26 17:13:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:18","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:13:18","OPEN_FOR_INTERNAL","2021-02-26 17:13:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:18","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1821&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"604","master_room_id":"28","room_code":"M15"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> M15 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"G097616(3)","title":"Mr","lastname":"CHIK","firstname":"Tang Kin","companyname":"","email":"","tel":"94968031","address":"Aberdeen, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"604","room_code":"M15","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":1196,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":4424,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2021-03-03","rent_from":"2021-03-03","rent_to":"2021-09-02","delivery_service":"0","remark":"6 months contract. Storage rental $3228 and deposit $1196 paid by EPS on FEB 26, 2021. Smart card and lock provided on the same day.\r\n","paymethod":"EPS","paymethod2":"EPS","discount_deduct":0,"order_total":4424,"final_order_total":4424,"location_id":"2","branch_id":"1","company_id":"1","room_key":"189,50444","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"538.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C212081","PERSONAL","Mr","Rg4FhcTI1LxFqVbzYcqYyg==","eoLRwyS7oiHWbFtgplSgTg==","","8uvtNYZSBH1LjGnKV2przw==",null,"35SNWI\/2m\/cw2EOiTw2+TSr0bSvQR2jP7YMw8UeHhBY=","vRbwprdXzYUoAjoKWzgLdw==",null,null,"waKxffYMVXo\/XQXahPWdRg==","2","2021-02-26 17:13:18","2","2021-02-26 17:13:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2",2081,"NEW","A14-CT2110683",598,538,1196,0,"6","6",4424,4424,4424,"2021-02-26 17:13:20","0",null,null,null,"2021-03-03","2021-09-02","6 months contract. Storage rental $3228 and deposit $1196 paid by EPS on FEB 26, 2021. Smart card and lock provided on the same day.\r\n","2021-03-03","12",0,null,0,"0","2","2021-02-26 17:13:18","2","2021-02-26 17:13:18","EPS","","","","EPS","","","",null,0,"189,50444","C212081","PERSONAL","Mr","Rg4FhcTI1LxFqVbzYcqYyg==","eoLRwyS7oiHWbFtgplSgTg==","","35SNWI\/2m\/cw2EOiTw2+TSr0bSvQR2jP7YMw8UeHhBY=","8uvtNYZSBH1LjGnKV2przw==",null,"vRbwprdXzYUoAjoKWzgLdw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["10683","604","598.0","598.00","2","2021-02-26 17:13:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2021-03-03","2021-09-02","604"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2021-02-26 17:13:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["10683","A14-D216175","PAID",1196,0,"2021-09-02","2021-02-26 17:13:18","2021-02-26 17:13:18","2","2021-02-26 17:13:18","2","2021-02-26 17:13:18",2081]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10683",2081,"SETTLED","A14-I2111012","2021-02-26 17:13:18","2021-03-03","2","2021-02-26 17:13:18","2","2021-02-26 17:13:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11012","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2021-02-26 17:13:18","2","2021-02-26 17:13:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11012","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2021-02-26 17:13:18","2","2021-02-26 17:13:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11012","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2021-02-26 17:13:18","2","2021-02-26 17:13:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11012","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2021-02-26 17:13:18","2","2021-02-26 17:13:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11012","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2021-02-26 17:13:18","2","2021-02-26 17:13:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11012","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2021-02-26 17:13:18","2","2021-02-26 17:13:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"11012"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2021-02-26 17:13:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[2081,"EPS","","","","EPS","","","","PAID","P2110646","2021-02-26 17:13:18",4424,"2","2021-02-26 17:13:18","2","2021-02-26 17:13:18","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10646","DEPOSIT","6175","PAID","2021-02-26 17:13:18",1196,"2","2021-02-26 17:13:18","2","2021-02-26 17:13:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10646","INVOICE","11012","PAID","2021-02-26 17:13:18",3228,"2","2021-02-26 17:13:18","2","2021-02-26 17:13:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:20","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:13:20","OPEN_FOR_INTERNAL","2021-02-26 17:13:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:13:21","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:13:21","OPEN_FOR_INTERNAL","2021-02-26 17:13:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:18:47","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:18:47","OPEN_FOR_INTERNAL","2021-02-26 17:18:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:18:51","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:18:51","OPEN_FOR_INTERNAL","2021-02-26 17:18:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:18:51","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:18:51","OPEN_FOR_INTERNAL","2021-02-26 17:18:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:18:54","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:18:54","OPEN_FOR_INTERNAL","2021-02-26 17:18:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:18:54","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:18:54","OPEN_FOR_INTERNAL","2021-02-26 17:18:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:19:01","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:19:01","OPEN_FOR_INTERNAL","2021-02-26 17:19:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:19:02","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:19:02","OPEN_FOR_INTERNAL","2021-02-26 17:19:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:19:52","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:19:52","OPEN_FOR_INTERNAL","2021-02-26 17:19:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:19:55","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:19:55","OPEN_FOR_INTERNAL","2021-02-26 17:19:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:20:01","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:20:01","OPEN_FOR_INTERNAL","2021-02-26 17:20:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:21:51","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:21:51","OPEN_FOR_INTERNAL","2021-02-26 17:21:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:38:18","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:38:18","OPEN_FOR_INTERNAL","2021-02-26 17:38:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:38:18","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:38:18","OPEN_FOR_INTERNAL","2021-02-26 17:38:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:38:18","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:38:20","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:38:20","OPEN_FOR_INTERNAL","2021-02-26 17:38:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:38:20","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:38:20","OPEN_FOR_INTERNAL","2021-02-26 17:38:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:38:23","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:38:23","OPEN_FOR_INTERNAL","2021-02-26 17:38:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:38:23","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:38:23","OPEN_FOR_INTERNAL","2021-02-26 17:38:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:42:56","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:42:56","OPEN_FOR_INTERNAL","2021-02-26 17:42:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:43:19","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:43:19","OPEN_FOR_INTERNAL","2021-02-26 17:43:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:44:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:44:13","OPEN_FOR_INTERNAL","2021-02-26 17:44:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:45:41","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:45:41","OPEN_FOR_INTERNAL","2021-02-26 17:45:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:45:46","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:45:46","OPEN_FOR_INTERNAL","2021-02-26 17:45:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:45:51","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:45:51","OPEN_FOR_INTERNAL","2021-02-26 17:45:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:46:23","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:46:23","OPEN_FOR_INTERNAL","2021-02-26 17:46:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:46:25","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:46:25","OPEN_FOR_INTERNAL","2021-02-26 17:46:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:52:49","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:52:49","OPEN_FOR_INTERNAL","2021-02-26 17:52:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:54:55","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:54:55","OPEN_FOR_INTERNAL","2021-02-26 17:54:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:55:59","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:55:59","OPEN_FOR_INTERNAL","2021-02-26 17:55:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:55:59","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:55:59","OPEN_FOR_INTERNAL","2021-02-26 17:55:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:55:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:56:03","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:56:03","OPEN_FOR_INTERNAL","2021-02-26 17:56:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:56:03","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:56:03","OPEN_FOR_INTERNAL","2021-02-26 17:56:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:56:03","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:56:03","OPEN_FOR_INTERNAL","2021-02-26 17:56:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:56:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:56:08","OPEN_FOR_INTERNAL","2021-02-26 17:56:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:56:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:56:10","OPEN_FOR_INTERNAL","2021-02-26 17:56:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:56:31","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:56:31","OPEN_FOR_INTERNAL","2021-02-26 17:56:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:56:46","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:56:46","OPEN_FOR_INTERNAL","2021-02-26 17:56:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:56:49","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:56:49","OPEN_FOR_INTERNAL","2021-02-26 17:56:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:57:11","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:57:11","OPEN_FOR_INTERNAL","2021-02-26 17:57:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:57:19","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:57:19","OPEN_FOR_INTERNAL","2021-02-26 17:57:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:57:24","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:57:24","OPEN_FOR_INTERNAL","2021-02-26 17:57:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:57:34","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:57:34","OPEN_FOR_INTERNAL","2021-02-26 17:57:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:58:06","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:58:06","OPEN_FOR_INTERNAL","2021-02-26 17:58:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:58:22","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 17:58:22","OPEN_FOR_INTERNAL","2021-02-26 17:58:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 17:58:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:00:42","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:00:42","OPEN_FOR_INTERNAL","2021-02-26 18:00:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:04:59","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:04:59","OPEN_FOR_INTERNAL","2021-02-26 18:04:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:04:59","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:04:59","OPEN_FOR_INTERNAL","2021-02-26 18:04:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:04:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:05:02","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:05:02","OPEN_FOR_INTERNAL","2021-02-26 18:05:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:05:02","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:05:02","OPEN_FOR_INTERNAL","2021-02-26 18:05:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:05:06","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:05:06","OPEN_FOR_INTERNAL","2021-02-26 18:05:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:05:07","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:05:07","OPEN_FOR_INTERNAL","2021-02-26 18:05:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:05:23","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:05:23","OPEN_FOR_INTERNAL","2021-02-26 18:05:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:13:58","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:13:58","OPEN_FOR_INTERNAL","2021-02-26 18:13:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:14:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:14:27","OPEN_FOR_INTERNAL","2021-02-26 18:14:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:15:53","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:15:53","OPEN_FOR_INTERNAL","2021-02-26 18:15:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:16:16","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:16:16","OPEN_FOR_INTERNAL","2021-02-26 18:16:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:16:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:16:38","OPEN_FOR_INTERNAL","2021-02-26 18:16:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:17:20","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:17:20","OPEN_FOR_INTERNAL","2021-02-26 18:17:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:19:32","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:19:32","OPEN_FOR_INTERNAL","2021-02-26 18:19:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:21:20","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:21:20","OPEN_FOR_INTERNAL","2021-02-26 18:21:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:22:26","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:22:26","OPEN_FOR_INTERNAL","2021-02-26 18:22:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:23:04","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:23:04","OPEN_FOR_INTERNAL","2021-02-26 18:23:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:24:42","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:24:42","OPEN_FOR_INTERNAL","2021-02-26 18:24:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:25:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:25:10","OPEN_FOR_INTERNAL","2021-02-26 18:25:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:33:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:33:08","OPEN_FOR_INTERNAL","2021-02-26 18:33:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:35:59","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:35:59","OPEN_FOR_INTERNAL","2021-02-26 18:35:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:36:11","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:36:11","OPEN_FOR_INTERNAL","2021-02-26 18:36:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:36:14","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:36:14","OPEN_FOR_INTERNAL","2021-02-26 18:36:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:36:29","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:36:29","OPEN_FOR_INTERNAL","2021-02-26 18:36:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:36:31","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:36:31","OPEN_FOR_INTERNAL","2021-02-26 18:36:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:36:31","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:36:31","OPEN_FOR_INTERNAL","2021-02-26 18:36:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:38:57","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:38:57","OPEN_FOR_INTERNAL","2021-02-26 18:38:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:02","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:02","OPEN_FOR_INTERNAL","2021-02-26 18:39:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:02","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:02","OPEN_FOR_INTERNAL","2021-02-26 18:39:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:10","OPEN_FOR_INTERNAL","2021-02-26 18:39:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:11","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:11","OPEN_FOR_INTERNAL","2021-02-26 18:39:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:11","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:11","OPEN_FOR_INTERNAL","2021-02-26 18:39:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:11","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:11","OPEN_FOR_INTERNAL","2021-02-26 18:39:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:12","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:12","OPEN_FOR_INTERNAL","2021-02-26 18:39:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:14","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:14","OPEN_FOR_INTERNAL","2021-02-26 18:39:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:14","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:14","OPEN_FOR_INTERNAL","2021-02-26 18:39:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:14","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:14","OPEN_FOR_INTERNAL","2021-02-26 18:39:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:14","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:14","OPEN_FOR_INTERNAL","2021-02-26 18:39:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:14","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:14","OPEN_FOR_INTERNAL","2021-02-26 18:39:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:14","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:14","OPEN_FOR_INTERNAL","2021-02-26 18:39:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:21","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:21","OPEN_FOR_INTERNAL","2021-02-26 18:39:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:22","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:22","OPEN_FOR_INTERNAL","2021-02-26 18:39:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:22","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:22","OPEN_FOR_INTERNAL","2021-02-26 18:39:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:23","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:22","OPEN_FOR_INTERNAL","2021-02-26 18:39:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:23","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:23","OPEN_FOR_INTERNAL","2021-02-26 18:39:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:23","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:23","OPEN_FOR_INTERNAL","2021-02-26 18:39:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:24","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:24","OPEN_FOR_INTERNAL","2021-02-26 18:39:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:25","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:25","OPEN_FOR_INTERNAL","2021-02-26 18:39:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:25","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:25","OPEN_FOR_INTERNAL","2021-02-26 18:39:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:26","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:26","OPEN_FOR_INTERNAL","2021-02-26 18:39:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:26","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:26","OPEN_FOR_INTERNAL","2021-02-26 18:39:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:26","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:26","OPEN_FOR_INTERNAL","2021-02-26 18:39:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:26","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:26","OPEN_FOR_INTERNAL","2021-02-26 18:39:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:26","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:26","OPEN_FOR_INTERNAL","2021-02-26 18:39:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:27","OPEN_FOR_INTERNAL","2021-02-26 18:39:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:29","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:28","OPEN_FOR_INTERNAL","2021-02-26 18:39:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:30","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:30","OPEN_FOR_INTERNAL","2021-02-26 18:39:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:31","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:31","OPEN_FOR_INTERNAL","2021-02-26 18:39:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:57","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:57","OPEN_FOR_INTERNAL","2021-02-26 18:39:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:58","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:58","OPEN_FOR_INTERNAL","2021-02-26 18:39:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:59","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:59","OPEN_FOR_INTERNAL","2021-02-26 18:39:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:59","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:59","OPEN_FOR_INTERNAL","2021-02-26 18:39:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:39:59","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:39:59","OPEN_FOR_INTERNAL","2021-02-26 18:39:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:40:00","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:40:00","OPEN_FOR_INTERNAL","2021-02-26 18:40:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:40:00","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:40:00","OPEN_FOR_INTERNAL","2021-02-26 18:40:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:40:01","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:40:01","OPEN_FOR_INTERNAL","2021-02-26 18:40:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:40:01","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:40:01","OPEN_FOR_INTERNAL","2021-02-26 18:40:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:40:01","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:40:01","OPEN_FOR_INTERNAL","2021-02-26 18:40:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:40:02","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:40:02","OPEN_FOR_INTERNAL","2021-02-26 18:40:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:11","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:41:11","OPEN_FOR_INTERNAL","2021-02-26 18:41:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:11","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:41:11","OPEN_FOR_INTERNAL","2021-02-26 18:41:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:12","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:41:12","OPEN_FOR_INTERNAL","2021-02-26 18:41:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:12","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:41:12","OPEN_FOR_INTERNAL","2021-02-26 18:41:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:41:27","OPEN_FOR_INTERNAL","2021-02-26 18:41:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:41:27","OPEN_FOR_INTERNAL","2021-02-26 18:41:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:41:27","OPEN_FOR_INTERNAL","2021-02-26 18:41:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:41:27","OPEN_FOR_INTERNAL","2021-02-26 18:41:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:41:28","OPEN_FOR_INTERNAL","2021-02-26 18:41:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:41:28","OPEN_FOR_INTERNAL","2021-02-26 18:41:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:41:28","OPEN_FOR_INTERNAL","2021-02-26 18:41:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:29","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:41:29","OPEN_FOR_INTERNAL","2021-02-26 18:41:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:30","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:41:30","OPEN_FOR_INTERNAL","2021-02-26 18:41:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:30","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:41:30","OPEN_FOR_INTERNAL","2021-02-26 18:41:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:30","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:41:30","OPEN_FOR_INTERNAL","2021-02-26 18:41:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:34","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:41:34","OPEN_FOR_INTERNAL","2021-02-26 18:41:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:34","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1821&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1564","master_room_id":"199","room_code":"A16-073"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A16-073(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X2.5X7 <\/td>\r\n\t\t\t\t\t $1058.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"E804838(3)","title":"Mr","lastname":"LAU","firstname":"Se On","companyname":"","email":"","tel":"92746095","address":"Flat 5 C, Comfort Centre, #108 Aberdeen Old Main Street, Southern, Hong Kong island ","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1564","room_code":"A16-073(\u670d\u88dd\u5009)","retail_price":"1058.0","discounted_price":"1058.00","location_id":"7"}],"roughly_size":"10","total_retail_price":1058,"total_discounted_price":900,"deposit":1800,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3150,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1350.00","warehousing_date":"2021-02-28","rent_from":"2021-02-28","rent_to":"2021-05-27","delivery_service":"0","remark":"3 months contract. First 3 months with 50% off. Storage rental $1350 and deposit $1800 paid by CASH on FEB 26, 2021. Smart card and lock provided on the same day.\r\n","paymethod":"CASH","paymethod2":"CASH","discount_deduct":1350,"order_total":4500,"final_order_total":3150,"location_id":"7","branch_id":"1","company_id":"1","room_key":"190,40494","order_product":[],"pass":true}},"roughly_size":"10","total_discounted_price":"900.00","deposit":"1800.00","total_retail_price":"1058.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C212082","PERSONAL","Mr","peurKsAWU6ly7fmA1pqIMw==","DQ14OHmVeYuzJuBkd+kFHg==","","6nX2HYHZDHSYuhXC47DRuQ==",null,"vDwPZleYuYb85QdinsTiI67nY2qmKgHY\/ihAY7OZNd8znKdSSP7V9hBwp9TEWxI5ILqOGedyK5b89567VCxHAoEuUT0PQTacDdEjT77HG7rJeiBH2tQ\/XXQj+TlQjxwq","4m2ff4Ivjq70rx7Oybu2mw==",null,null,"fDZSfaN5cquLj7nStqb2sQ==","2","2021-02-26 18:41:34","2","2021-02-26 18:41:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7",2082,"NEW","A16-CT2110684",1058,900,1800,0,"3","3",3150,4500,3150,"2021-02-26 18:41:36","0",null,null,null,"2021-02-28","2021-05-27","3 months contract. First 3 months with 50% off. Storage rental $1350 and deposit $1800 paid by CASH on FEB 26, 2021. Smart card and lock provided on the same day.\r\n","2021-02-28","10",0,null,1350,"1350.00","2","2021-02-26 18:41:34","2","2021-02-26 18:41:34","CASH","","","","CASH","","","",null,0,"190,40494","C212082","PERSONAL","Mr","peurKsAWU6ly7fmA1pqIMw==","DQ14OHmVeYuzJuBkd+kFHg==","","vDwPZleYuYb85QdinsTiI67nY2qmKgHY\/ihAY7OZNd8znKdSSP7V9hBwp9TEWxI5ILqOGedyK5b89567VCxHAoEuUT0PQTacDdEjT77HG7rJeiBH2tQ\/XXQj+TlQjxwq","6nX2HYHZDHSYuhXC47DRuQ==",null,"4m2ff4Ivjq70rx7Oybu2mw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["10684","1564","1058.0","1058.00","2","2021-02-26 18:41:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2021-02-28","2021-05-27","1564"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2021-02-26 18:41:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["10684","A16-D216176","PAID",1800,0,"2021-05-27","2021-02-26 18:41:34","2021-02-26 18:41:34","2","2021-02-26 18:41:34","2","2021-02-26 18:41:34",2082]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10684",2082,"SETTLED","A16-I2111013","2021-02-26 18:41:34","2021-02-28","2","2021-02-26 18:41:34","2","2021-02-26 18:41:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11013","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2021-02-26 18:41:34","2","2021-02-26 18:41:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11013","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,450,"MO","1",450,"2","2021-02-26 18:41:34","2","2021-02-26 18:41:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11013","RENT","\u9810\u7e73\u79df\u91d1",3,900,"MO","1",900,"2","2021-02-26 18:41:34","2","2021-02-26 18:41:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1350,0,"11013"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2021-02-26 18:41:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[2082,"CASH","","","","CASH","","","","PAID","P2110647","2021-02-26 18:41:34",3150,"2","2021-02-26 18:41:34","2","2021-02-26 18:41:34","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10647","DEPOSIT","6176","PAID","2021-02-26 18:41:34",1800,"2","2021-02-26 18:41:34","2","2021-02-26 18:41:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10647","INVOICE","11013","PAID","2021-02-26 18:41:34",1350,"2","2021-02-26 18:41:34","2","2021-02-26 18:41:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:36","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:41:36","OPEN_FOR_INTERNAL","2021-02-26 18:41:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:41:37","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:41:37","OPEN_FOR_INTERNAL","2021-02-26 18:41:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:45:03","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:45:03","OPEN_FOR_INTERNAL","2021-02-26 18:45:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:45:06","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:45:06","OPEN_FOR_INTERNAL","2021-02-26 18:45:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:45:07","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:45:07","OPEN_FOR_INTERNAL","2021-02-26 18:45:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:45:11","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:45:11","OPEN_FOR_INTERNAL","2021-02-26 18:45:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:45:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:45:13","OPEN_FOR_INTERNAL","2021-02-26 18:45:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:45:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:45:13","OPEN_FOR_INTERNAL","2021-02-26 18:45:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:45:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:45:27","OPEN_FOR_INTERNAL","2021-02-26 18:45:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:45:42","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:45:42","OPEN_FOR_INTERNAL","2021-02-26 18:45:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:46:19","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:46:19","OPEN_FOR_INTERNAL","2021-02-26 18:46:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:46:20","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:46:20","OPEN_FOR_INTERNAL","2021-02-26 18:46:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:46:22","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:46:22","OPEN_FOR_INTERNAL","2021-02-26 18:46:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:46:48","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:46:48","OPEN_FOR_INTERNAL","2021-02-26 18:46:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:46:59","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:46:59","OPEN_FOR_INTERNAL","2021-02-26 18:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:47:18","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:47:18","OPEN_FOR_INTERNAL","2021-02-26 18:47:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:48:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:48:10","OPEN_FOR_INTERNAL","2021-02-26 18:48:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:54:06","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:54:06","OPEN_FOR_INTERNAL","2021-02-26 18:54:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:54:06","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:54:06","OPEN_FOR_INTERNAL","2021-02-26 18:54:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:54:06","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:54:12","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:54:12","OPEN_FOR_INTERNAL","2021-02-26 18:54:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:54:14","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:54:14","OPEN_FOR_INTERNAL","2021-02-26 18:54:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:54:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:54:15","OPEN_FOR_INTERNAL","2021-02-26 18:54:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:54:18","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:54:18","OPEN_FOR_INTERNAL","2021-02-26 18:54:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:54:19","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:54:19","OPEN_FOR_INTERNAL","2021-02-26 18:54:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:54:44","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:54:44","OPEN_FOR_INTERNAL","2021-02-26 18:54:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:54:54","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:54:54","OPEN_FOR_INTERNAL","2021-02-26 18:54:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 18:55:01","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 18:55:01","OPEN_FOR_INTERNAL","2021-02-26 18:55:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:04:26","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:04:26","OPEN_FOR_INTERNAL","2021-02-26 19:04:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:04:30","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:04:30","OPEN_FOR_INTERNAL","2021-02-26 19:04:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:04:30","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:04:30","OPEN_FOR_INTERNAL","2021-02-26 19:04:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:06:34","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:06:34","OPEN_FOR_INTERNAL","2021-02-26 19:06:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:06:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:06:39","OPEN_FOR_INTERNAL","2021-02-26 19:06:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:06:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:06:39","OPEN_FOR_INTERNAL","2021-02-26 19:06:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:06:47","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:06:47","OPEN_FOR_INTERNAL","2021-02-26 19:06:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:06:49","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:06:49","OPEN_FOR_INTERNAL","2021-02-26 19:06:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:06:49","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:06:49","OPEN_FOR_INTERNAL","2021-02-26 19:06:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:06:49","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:06:49","OPEN_FOR_INTERNAL","2021-02-26 19:06:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:06:49","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:06:49","OPEN_FOR_INTERNAL","2021-02-26 19:06:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:06:51","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:06:51","OPEN_FOR_INTERNAL","2021-02-26 19:06:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:07:32","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:07:32","OPEN_FOR_INTERNAL","2021-02-26 19:07:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:07:35","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:07:35","OPEN_FOR_INTERNAL","2021-02-26 19:07:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:07:35","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:07:35","OPEN_FOR_INTERNAL","2021-02-26 19:07:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:07:36","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:07:36","OPEN_FOR_INTERNAL","2021-02-26 19:07:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:07:42","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:07:42","OPEN_FOR_INTERNAL","2021-02-26 19:07:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:07:42","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:07:42","OPEN_FOR_INTERNAL","2021-02-26 19:07:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:07:43","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:07:43","OPEN_FOR_INTERNAL","2021-02-26 19:07:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:07:43","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:07:43","OPEN_FOR_INTERNAL","2021-02-26 19:07:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:07:43","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:07:43","OPEN_FOR_INTERNAL","2021-02-26 19:07:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:07:43","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:07:43","OPEN_FOR_INTERNAL","2021-02-26 19:07:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:07:58","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:07:58","OPEN_FOR_INTERNAL","2021-02-26 19:07:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:07:58","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:07:58","OPEN_FOR_INTERNAL","2021-02-26 19:07:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:07:58","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:07:58","OPEN_FOR_INTERNAL","2021-02-26 19:07:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:07:58","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:07:58","OPEN_FOR_INTERNAL","2021-02-26 19:07:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:07:59","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:07:59","OPEN_FOR_INTERNAL","2021-02-26 19:07:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:08:00","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:08:00","OPEN_FOR_INTERNAL","2021-02-26 19:08:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:08:00","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:08:00","OPEN_FOR_INTERNAL","2021-02-26 19:08:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:08:00","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:08:00","OPEN_FOR_INTERNAL","2021-02-26 19:08:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:08:35","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:08:35","OPEN_FOR_INTERNAL","2021-02-26 19:08:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:08:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:08:38","OPEN_FOR_INTERNAL","2021-02-26 19:08:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:09:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:09:09","OPEN_FOR_INTERNAL","2021-02-26 19:09:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:09:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:09:10","OPEN_FOR_INTERNAL","2021-02-26 19:09:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:09:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:09:28","OPEN_FOR_INTERNAL","2021-02-26 19:09:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:09:29","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:09:29","OPEN_FOR_INTERNAL","2021-02-26 19:09:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:09:29","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:09:29","OPEN_FOR_INTERNAL","2021-02-26 19:09:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:09:29","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:09:29","OPEN_FOR_INTERNAL","2021-02-26 19:09:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:09:30","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:09:30","OPEN_FOR_INTERNAL","2021-02-26 19:09:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:09:31","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:09:31","OPEN_FOR_INTERNAL","2021-02-26 19:09:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:09:32","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:09:32","OPEN_FOR_INTERNAL","2021-02-26 19:09:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:09:33","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:09:33","OPEN_FOR_INTERNAL","2021-02-26 19:09:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:09:33","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:09:33","OPEN_FOR_INTERNAL","2021-02-26 19:09:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:09:33","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:09:33","OPEN_FOR_INTERNAL","2021-02-26 19:09:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:09:34","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:09:34","OPEN_FOR_INTERNAL","2021-02-26 19:09:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:13:03","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:13:03","OPEN_FOR_INTERNAL","2021-02-26 19:13:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:13:03","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:13:03","OPEN_FOR_INTERNAL","2021-02-26 19:13:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:13:04","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:13:04","OPEN_FOR_INTERNAL","2021-02-26 19:13:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:13:04","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:13:04","OPEN_FOR_INTERNAL","2021-02-26 19:13:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:13:19","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:13:19","OPEN_FOR_INTERNAL","2021-02-26 19:13:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:13:19","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:13:19","OPEN_FOR_INTERNAL","2021-02-26 19:13:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:13:19","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:13:19","OPEN_FOR_INTERNAL","2021-02-26 19:13:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:13:19","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:13:19","OPEN_FOR_INTERNAL","2021-02-26 19:13:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:13:19","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:13:19","OPEN_FOR_INTERNAL","2021-02-26 19:13:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:13:20","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:13:20","OPEN_FOR_INTERNAL","2021-02-26 19:13:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:13:20","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:13:20","OPEN_FOR_INTERNAL","2021-02-26 19:13:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:13:20","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:13:20","OPEN_FOR_INTERNAL","2021-02-26 19:13:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:05","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:14:05","OPEN_FOR_INTERNAL","2021-02-26 19:14:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:05","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:14:05","OPEN_FOR_INTERNAL","2021-02-26 19:14:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:06","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:14:06","OPEN_FOR_INTERNAL","2021-02-26 19:14:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:14:38","OPEN_FOR_INTERNAL","2021-02-26 19:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:38","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=5&filter2=2021-02-26&filter3=2021-02-27","floor_plan_rent_room":[{"room_id":"1900","master_room_id":"293","room_code":"E10-04"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> E10-04 <\/td>\r\n\t\t\t\t\t 4X3X6.8 <\/td>\r\n\t\t\t\t\t $1288.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"K490016(2)","title":"Ms","lastname":"Mok","firstname":"Fun Fong","companyname":"","email":"","tel":"90389118","address":"RM 908,Blk A, Perfect Mount Gardens, 1 Po Man Street, SKW, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"928","master_room_id":"293","discount_type":"%","price":"1288.00","disocunted_price":"1159.20","discount":"10.00","monthly_deduct":128.8,"room_id":"1900","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1900","room_code":"E10-04","retail_price":"1288.0","discounted_price":1159.2,"location_id":"11"}],"roughly_size":"12","total_retail_price":1288,"total_discounted_price":1160,"deposit":2576,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":14948,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1548.00","warehousing_date":"2021-03-15","rent_from":"2021-03-15","rent_to":"2022-03-14","delivery_service":"0","remark":"12 months contract. First 3 months with 50% off. Storage Rental ($12372)and deposit($2576) paid on 26 Feb 2021 by EPS. Smart card provided on the same day(Facebook Promotion).\t","paymethod":"EPS","paymethod2":"EPS","discount_deduct":1548,"order_total":16496,"final_order_total":14948,"location_id":"11","branch_id":"5","company_id":"1","room_key":"055,31271","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"1160.00","deposit":"2576.00","total_retail_price":"1288.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C212083","PERSONAL","Ms","u7pkJ2vyZ5K+bsajnUtjIw==","ELGiy8l3QksCSVYDm2XBjg==","","DkAMkmSgBJLQXsltjU0wnA==",null,"Iwnz7ymrb712XRji0ayzgGBxS2uFQwgid6T1zM7xkI65s+st22NBtqF8af1HJ2k1bCi72k\/c6eXfFUrCf2wIfA==","Teb5CodmMEFzCzraXgQB\/A==",null,null,"PVlJZkiQ6JBxhiVpTGCbZw==","2","2021-02-26 19:14:38","2","2021-02-26 19:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","5","11",2083,"NEW","E10-CT2110685",1288,1160,2576,0,"12","12",14948,16496,14948,"2021-02-26 19:14:40","0",null,null,null,"2021-03-15","2022-03-14","12 months contract. First 3 months with 50% off. Storage Rental ($12372)and deposit($2576) paid on 26 Feb 2021 by EPS. Smart card provided on the same day(Facebook Promotion).\t","2021-03-15","12",0,null,1548,"1548.00","2","2021-02-26 19:14:38","2","2021-02-26 19:14:38","EPS","","","","EPS","","","",null,0,"055,31271","C212083","PERSONAL","Ms","u7pkJ2vyZ5K+bsajnUtjIw==","ELGiy8l3QksCSVYDm2XBjg==","","Iwnz7ymrb712XRji0ayzgGBxS2uFQwgid6T1zM7xkI65s+st22NBtqF8af1HJ2k1bCi72k\/c6eXfFUrCf2wIfA==","DkAMkmSgBJLQXsltjU0wnA==",null,"Teb5CodmMEFzCzraXgQB\/A==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["10685","928","293","1900","%","10.00",128.8,"2","2021-02-26 19:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["10685","1900","1288.0",1159.2,"2","2021-02-26 19:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2021-03-15","2022-03-14","1900"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2021-02-26 19:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["10685","E10-D216177","PAID",2576,0,"2022-03-14","2021-02-26 19:14:38","2021-02-26 19:14:38","2","2021-02-26 19:14:38","2","2021-02-26 19:14:38",2083]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10685",2083,"SETTLED","E10-I2111014","2021-02-26 19:14:38","2021-03-15","2","2021-02-26 19:14:38","2","2021-02-26 19:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11014","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2021-02-26 19:14:38","2","2021-02-26 19:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11014","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,772,"MO","1",772,"2","2021-02-26 19:14:38","2","2021-02-26 19:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11014","RENT","\u9810\u7e73\u79df\u91d1",3,1160,"MO","1",1160,"2","2021-02-26 19:14:38","2","2021-02-26 19:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11014","RENT","\u9810\u7e73\u79df\u91d1",4,1160,"MO","1",1160,"2","2021-02-26 19:14:38","2","2021-02-26 19:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11014","RENT","\u9810\u7e73\u79df\u91d1",5,1160,"MO","1",1160,"2","2021-02-26 19:14:38","2","2021-02-26 19:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11014","RENT","\u9810\u7e73\u79df\u91d1",6,1160,"MO","1",1160,"2","2021-02-26 19:14:38","2","2021-02-26 19:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11014","RENT","\u9810\u7e73\u79df\u91d1",7,1160,"MO","1",1160,"2","2021-02-26 19:14:38","2","2021-02-26 19:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11014","RENT","\u9810\u7e73\u79df\u91d1",8,1160,"MO","1",1160,"2","2021-02-26 19:14:38","2","2021-02-26 19:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11014","RENT","\u9810\u7e73\u79df\u91d1",9,1160,"MO","1",1160,"2","2021-02-26 19:14:38","2","2021-02-26 19:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11014","RENT","\u9810\u7e73\u79df\u91d1",10,1160,"MO","1",1160,"2","2021-02-26 19:14:38","2","2021-02-26 19:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11014","RENT","\u9810\u7e73\u79df\u91d1",11,1160,"MO","1",1160,"2","2021-02-26 19:14:38","2","2021-02-26 19:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11014","RENT","\u9810\u7e73\u79df\u91d1",12,1160,"MO","1",1160,"2","2021-02-26 19:14:38","2","2021-02-26 19:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[12372,0,"11014"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2021-02-26 19:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[2083,"EPS","","","","EPS","","","","PAID","P2110648","2021-02-26 19:14:38",14948,"2","2021-02-26 19:14:38","2","2021-02-26 19:14:38","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10648","DEPOSIT","6177","PAID","2021-02-26 19:14:38",2576,"2","2021-02-26 19:14:38","2","2021-02-26 19:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10648","INVOICE","11014","PAID","2021-02-26 19:14:38",12372,"2","2021-02-26 19:14:38","2","2021-02-26 19:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:40","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:14:40","OPEN_FOR_INTERNAL","2021-02-26 19:14:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:14:40","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:14:40","OPEN_FOR_INTERNAL","2021-02-26 19:14:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:18:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:18:09","OPEN_FOR_INTERNAL","2021-02-26 19:18:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:18:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:18:13","OPEN_FOR_INTERNAL","2021-02-26 19:18:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:18:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:18:13","OPEN_FOR_INTERNAL","2021-02-26 19:18:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:18:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:18:15","OPEN_FOR_INTERNAL","2021-02-26 19:18:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:19:24","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:19:24","OPEN_FOR_INTERNAL","2021-02-26 19:19:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:19:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:19:39","OPEN_FOR_INTERNAL","2021-02-26 19:19:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:19:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:19:39","OPEN_FOR_INTERNAL","2021-02-26 19:19:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:19:42","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:19:42","OPEN_FOR_INTERNAL","2021-02-26 19:19:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:19:42","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:19:42","OPEN_FOR_INTERNAL","2021-02-26 19:19:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:22:47","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:22:47","OPEN_FOR_INTERNAL","2021-02-26 19:22:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:23:54","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:23:54","OPEN_FOR_INTERNAL","2021-02-26 19:23:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:42:31","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:42:31","OPEN_FOR_INTERNAL","2021-02-26 19:42:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:42:31","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:42:31","OPEN_FOR_INTERNAL","2021-02-26 19:42:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:42:31","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:42:34","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:42:34","OPEN_FOR_INTERNAL","2021-02-26 19:42:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:42:34","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:42:34","OPEN_FOR_INTERNAL","2021-02-26 19:42:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:42:36","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:42:36","OPEN_FOR_INTERNAL","2021-02-26 19:42:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:42:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:42:38","OPEN_FOR_INTERNAL","2021-02-26 19:42:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:42:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:42:39","OPEN_FOR_INTERNAL","2021-02-26 19:42:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:44:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:44:38","OPEN_FOR_INTERNAL","2021-02-26 19:44:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:44:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:44:38","OPEN_FOR_INTERNAL","2021-02-26 19:44:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:44:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:44:40","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:44:40","OPEN_FOR_INTERNAL","2021-02-26 19:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:44:40","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:44:40","OPEN_FOR_INTERNAL","2021-02-26 19:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:44:42","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:44:42","OPEN_FOR_INTERNAL","2021-02-26 19:44:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:44:42","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:44:42","OPEN_FOR_INTERNAL","2021-02-26 19:44:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:44:51","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:44:51","OPEN_FOR_INTERNAL","2021-02-26 19:44:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:44:54","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:44:54","OPEN_FOR_INTERNAL","2021-02-26 19:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:44:56","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:44:56","OPEN_FOR_INTERNAL","2021-02-26 19:44:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:45:00","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:45:00","OPEN_FOR_INTERNAL","2021-02-26 19:45:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:45:02","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:45:02","OPEN_FOR_INTERNAL","2021-02-26 19:45:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:45:02","login_id":"2","controller":"_ajax.php","function":"update_room","input":{"post":{"room_code":"WC-09","room_id":"1760","master_room_id":"232","room_status":"ENDING"},"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc"},"sql":"update room set status = ?, master_room_id = ?, lastupby = ?, lastupdate = ? where id = ?","parameters":["ENDING","232","2","2021-02-26 19:45:02","1760"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:45:05","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:45:05","OPEN_FOR_INTERNAL","2021-02-26 19:45:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-02-26 19:45:06","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-02-26 19:45:06","OPEN_FOR_INTERNAL","2021-02-26 19:45:06"]},"data_before":[],"data_after":[],"step":1} *****