\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>
A04 <\/td>\n\t\t\t\t\t	4X5X8 <\/td>\n\t\t\t\t\t	$1528.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/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":"20","total_discounted_price":"1528.00","deposit":"3056.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 12:10:45","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":["C212229","PERSONAL","Ms","oa30JXXnOhHE6Lkn4ROgwQ==","UrsMAvfb5x9QBcnJ8435JA==","","AMXS5cz4pviVjXldGot69g==",null,"X701NRTZid8RbfwXC69YH50fGJLJl5vQofkCDj4GRu1KNQaQBg8jhRhzO4AAOVW6","H\/4krjN5YKSEb1xbZHub3A==",null,null,"NQ9teyFrHwAiMG8eQMgZIw==","2","2021-05-08 12:10:43","2","2021-05-08 12:10:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 12:10:45","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","1",2229,"NEW","A12-CT2111407",1528,1528,3056,0,"6","6",9476,12224,9476,"2021-05-08 12:10:45","0",null,null,null,"2021-05-17","2021-11-16","6 months contract. First 3 months with 50% off(FOR NEW CUSTUMER) . Storage rental $4348 and deposit $3056 paid by BANK TRANSFER, on 8 MAY 2021. Smart card and lock provided on the same day.(FREE FACEBOOK POROMTION)","2021-05-17","20",0,null,2748,"2748.00","2","2021-05-08 12:10:43","2","2021-05-08 12:10:43","BANKIN","","","","BANKIN","","","",null,0,"088,28749","C212229","PERSONAL","Ms","oa30JXXnOhHE6Lkn4ROgwQ==","UrsMAvfb5x9QBcnJ8435JA==","","X701NRTZid8RbfwXC69YH50fGJLJl5vQofkCDj4GRu1KNQaQBg8jhRhzO4AAOVW6","AMXS5cz4pviVjXldGot69g==",null,"H\/4krjN5YKSEb1xbZHub3A==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 12:10:45","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":["11407","76 available_room_list_input","10","4","%","9.95",152.036,"2","2021-05-08 12:10:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 12:10:45","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":["11407","4","1528.0",1376,"2","2021-05-08 12:10:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 12:10:45","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-05-17","2021-11-16","4"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2021-05-08 12:10:45","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":["11407","A12-D216383","PAID",3056,0,"2021-11-16","2021-05-08 12:10:43","2021-05-08 12:10:43","2","2021-05-08 12:10:43","2","2021-05-08 12:10:43",2229]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 12:10:45","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":["11407",2229,"SETTLED","A12-I2111728","2021-05-08 12:10:43","2021-05-17","2","2021-05-08 12:10:43","2","2021-05-08 12:10:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 12:10:45","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":["11728","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2021-05-08 12:10:43","2","2021-05-08 12:10:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 12:10:45","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":["11728","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,308,"MO","1",308,"2","2021-05-08 12:10:43","2","2021-05-08 12:10:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 12:10:45","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":["11728","RENT","\u9810\u7e73\u79df\u91d1",3,1528,"MO","1",1528,"2","2021-05-08 12:10:43","2","2021-05-08 12:10:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 12:10:45","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":["11728","RENT","\u9810\u7e73\u79df\u91d1",4,1528,"MO","1",1528,"2","2021-05-08 12:10:43","2","2021-05-08 12:10:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 12:10:45","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":["11728","RENT","\u9810\u7e73\u79df\u91d1",5,1528,"MO","1",1528,"2","2021-05-08 12:10:43","2","2021-05-08 12:10:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 12:10:45","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":["11728","RENT","\u9810\u7e73\u79df\u91d1",6,1528,"MO","1",1528,"2","2021-05-08 12:10:43","2","2021-05-08 12:10:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 12:10:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6420,0,"11728"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2021-05-08 12:10:45","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":[2229,"BANKIN","","","","BANKIN","","","","PAID","P2111364","2021-05-08 12:10:43",9476,"2","2021-05-08 12:10:43","2","2021-05-08 12:10:43","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 12:10:45","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":["11364","DEPOSIT","6383","PAID","2021-05-08 12:10:43",3056,"2","2021-05-08 12:10:43","2","2021-05-08 12:10:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 12:10:45","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":["11364","INVOICE","11728","PAID","2021-05-08 12:10:43",6420,"2","2021-05-08 12:10:43","2","2021-05-08 12:10:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 12:10: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-05-08 12:10:46","OPEN_FOR_INTERNAL","2021-05-08 12:10:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 12:10: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-05-08 12:10:46","OPEN_FOR_INTERNAL","2021-05-08 12:10:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 12:36: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-05-08 12:36:00","OPEN_FOR_INTERNAL","2021-05-08 12:36:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 12:36: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-05-08 12:36:09","OPEN_FOR_INTERNAL","2021-05-08 12:36:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 12: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-05-08 12:36:11","OPEN_FOR_INTERNAL","2021-05-08 12:36:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 12:58: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-05-08 12:58:03","OPEN_FOR_INTERNAL","2021-05-08 12:58:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 12:58: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-05-08 12:58:03","OPEN_FOR_INTERNAL","2021-05-08 12:58:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 13:10: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-05-08 13:10:44","OPEN_FOR_INTERNAL","2021-05-08 13:10:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 13:10:45","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-05-08 13:10:45","OPEN_FOR_INTERNAL","2021-05-08 13:10:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 13:17: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-05-08 13:17:11","OPEN_FOR_INTERNAL","2021-05-08 13:17:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 13:17: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-05-08 13:17:14","OPEN_FOR_INTERNAL","2021-05-08 13:17:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 13:18: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-05-08 13:18:05","OPEN_FOR_INTERNAL","2021-05-08 13:18:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 13:26: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-05-08 13:26:56","OPEN_FOR_INTERNAL","2021-05-08 13:26:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 13:27: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-05-08 13:27:03","OPEN_FOR_INTERNAL","2021-05-08 13:27:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 13:27: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-05-08 13:27:24","OPEN_FOR_INTERNAL","2021-05-08 13:27:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 13:27:45","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-05-08 13:27:45","OPEN_FOR_INTERNAL","2021-05-08 13:27:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 13:27: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-05-08 13:27:49","OPEN_FOR_INTERNAL","2021-05-08 13:27:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 13:27: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-05-08 13:27:49","OPEN_FOR_INTERNAL","2021-05-08 13:27:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 13:27:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 13:27: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-05-08 13:27:52","OPEN_FOR_INTERNAL","2021-05-08 13:27:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 13:28: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-05-08 13:28:01","OPEN_FOR_INTERNAL","2021-05-08 13:28:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 13:28: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-05-08 13:28:04","OPEN_FOR_INTERNAL","2021-05-08 13:28:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 13:55: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-05-08 13:55:31","OPEN_FOR_INTERNAL","2021-05-08 13:55:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 13:55: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-05-08 13:55:34","OPEN_FOR_INTERNAL","2021-05-08 13:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 13:56: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-05-08 13:56:11","OPEN_FOR_INTERNAL","2021-05-08 13:56:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 13:58: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-05-08 13:58:33","OPEN_FOR_INTERNAL","2021-05-08 13:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14: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-05-08 14:45:27","OPEN_FOR_INTERNAL","2021-05-08 14:45:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:45: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-05-08 14:45:28","OPEN_FOR_INTERNAL","2021-05-08 14:45:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:45:28","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:45: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-05-08 14:45:30","OPEN_FOR_INTERNAL","2021-05-08 14:45:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:45: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-05-08 14:45:49","OPEN_FOR_INTERNAL","2021-05-08 14:45:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:45: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-05-08 14:45:56","OPEN_FOR_INTERNAL","2021-05-08 14:45:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:45: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-05-08 14:45:56","OPEN_FOR_INTERNAL","2021-05-08 14:45:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:45: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-05-08 14:45:58","OPEN_FOR_INTERNAL","2021-05-08 14:45:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:45: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-05-08 14:45:58","OPEN_FOR_INTERNAL","2021-05-08 14:45:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:45:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:46: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-05-08 14:46:01","OPEN_FOR_INTERNAL","2021-05-08 14:46:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:46: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-05-08 14:46:09","OPEN_FOR_INTERNAL","2021-05-08 14:46:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:46: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-05-08 14:46:14","OPEN_FOR_INTERNAL","2021-05-08 14:46:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:46:45","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-05-08 14:46:45","OPEN_FOR_INTERNAL","2021-05-08 14:46:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:46:45","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-05-08 14:46:45","OPEN_FOR_INTERNAL","2021-05-08 14:46:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:46:45","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:46: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-05-08 14:46:47","OPEN_FOR_INTERNAL","2021-05-08 14:46:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:46: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-05-08 14:46:47","OPEN_FOR_INTERNAL","2021-05-08 14:46:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:46: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-05-08 14:46:51","OPEN_FOR_INTERNAL","2021-05-08 14:46:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:47: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-05-08 14:47:04","OPEN_FOR_INTERNAL","2021-05-08 14:47:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:47: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-05-08 14:47:08","OPEN_FOR_INTERNAL","2021-05-08 14:47:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:47: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-05-08 14:47:19","OPEN_FOR_INTERNAL","2021-05-08 14:47:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:47: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-05-08 14:47:43","OPEN_FOR_INTERNAL","2021-05-08 14:47:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:47: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-05-08 14:47:54","OPEN_FOR_INTERNAL","2021-05-08 14:47:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:47: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-05-08 14:47:56","OPEN_FOR_INTERNAL","2021-05-08 14:47:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14: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-05-08 14:48:10","OPEN_FOR_INTERNAL","2021-05-08 14:48:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:48: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-05-08 14:48:12","OPEN_FOR_INTERNAL","2021-05-08 14:48:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:48:12","login_id":"2","controller":"_ajax.php","function":"update_room","input":{"post":{"room_code":"E40","room_id":"313","master_room_id":"6","room_status":"OPEN"},"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=1893&filter3=undefined","total_retail_price":"998.00","floor_plan_rent_room":[{"room_id":"4","master_room_id":"10","room_code":"A04"}],"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> A04 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \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"},"sql":"update room set status = ?, master_room_id = ?, lastupby = ?, lastupdate = ? where id = ?","parameters":["OPEN","6","2","2021-05-08 14:48:12","313"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:48:17","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-05-08 14:48:17","OPEN_FOR_INTERNAL","2021-05-08 14:48:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:48: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-05-08 14:48:19","OPEN_FOR_INTERNAL","2021-05-08 14:48:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:48: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-05-08 14:48:34","OPEN_FOR_INTERNAL","2021-05-08 14:48:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:48: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-05-08 14:48:41","OPEN_FOR_INTERNAL","2021-05-08 14:48:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:48: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-05-08 14:48:41","OPEN_FOR_INTERNAL","2021-05-08 14:48:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:48:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:57: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-05-08 14:57:54","OPEN_FOR_INTERNAL","2021-05-08 14:57:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:58: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-05-08 14:58:05","OPEN_FOR_INTERNAL","2021-05-08 14:58:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 14:58: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-05-08 14:58:18","OPEN_FOR_INTERNAL","2021-05-08 14:58:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:19: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-05-08 15:19:08","OPEN_FOR_INTERNAL","2021-05-08 15:19:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:19:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:19: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-05-08 15:19:13","OPEN_FOR_INTERNAL","2021-05-08 15:19:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:19: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-05-08 15:19:13","OPEN_FOR_INTERNAL","2021-05-08 15:19:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:19: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-05-08 15:19:16","OPEN_FOR_INTERNAL","2021-05-08 15:19:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:19: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-05-08 15:19:18","OPEN_FOR_INTERNAL","2021-05-08 15:19:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15: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-05-08 15:19:52","OPEN_FOR_INTERNAL","2021-05-08 15:19:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15: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-05-08 15:19:52","OPEN_FOR_INTERNAL","2021-05-08 15:19:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:19:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:20: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-05-08 15:20:54","OPEN_FOR_INTERNAL","2021-05-08 15:20:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:20: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-05-08 15:20:55","OPEN_FOR_INTERNAL","2021-05-08 15:20:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:20: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-05-08 15:20:58","OPEN_FOR_INTERNAL","2021-05-08 15:20:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:20: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-05-08 15:20:58","OPEN_FOR_INTERNAL","2021-05-08 15:20:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:20:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:22: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-05-08 15:22:08","OPEN_FOR_INTERNAL","2021-05-08 15:22:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:22: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-05-08 15:22:08","OPEN_FOR_INTERNAL","2021-05-08 15:22:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:22: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-05-08 15:22:10","OPEN_FOR_INTERNAL","2021-05-08 15:22:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:22: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-05-08 15:22:11","OPEN_FOR_INTERNAL","2021-05-08 15:22:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:28: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-05-08 15:28:59","OPEN_FOR_INTERNAL","2021-05-08 15:28:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:28: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-05-08 15:28:59","OPEN_FOR_INTERNAL","2021-05-08 15:28:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:28:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:29: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-05-08 15:29:02","OPEN_FOR_INTERNAL","2021-05-08 15:29:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:29: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-05-08 15:29:14","OPEN_FOR_INTERNAL","2021-05-08 15:29:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:38: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-05-08 15:38:13","OPEN_FOR_INTERNAL","2021-05-08 15:38:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:50: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-05-08 15:50:35","OPEN_FOR_INTERNAL","2021-05-08 15:50:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:50: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-05-08 15:50:49","OPEN_FOR_INTERNAL","2021-05-08 15:50:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:50: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-05-08 15:50:49","OPEN_FOR_INTERNAL","2021-05-08 15:50:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:50:50","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-05-08 15:50:50","OPEN_FOR_INTERNAL","2021-05-08 15:50:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:50:50","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-05-08 15:50:50","OPEN_FOR_INTERNAL","2021-05-08 15:50:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:50:50","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-05-08 15:50:50","OPEN_FOR_INTERNAL","2021-05-08 15:50:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:50:50","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-05-08 15:50:50","OPEN_FOR_INTERNAL","2021-05-08 15:50:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:50:50","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-05-08 15:50:50","OPEN_FOR_INTERNAL","2021-05-08 15:50:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:50:50","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-05-08 15:50:50","OPEN_FOR_INTERNAL","2021-05-08 15:50:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:50:50","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-05-08 15:50:50","OPEN_FOR_INTERNAL","2021-05-08 15:50:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:50:50","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-05-08 15:50:50","OPEN_FOR_INTERNAL","2021-05-08 15:50:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:50:50","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-05-08 15:50:50","OPEN_FOR_INTERNAL","2021-05-08 15:50:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:50:50","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-05-08 15:50:50","OPEN_FOR_INTERNAL","2021-05-08 15:50:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:50:50","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-05-08 15:50:50","OPEN_FOR_INTERNAL","2021-05-08 15:50:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:50:50","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-05-08 15:50:50","OPEN_FOR_INTERNAL","2021-05-08 15:50:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:50: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-05-08 15:50:59","OPEN_FOR_INTERNAL","2021-05-08 15:50:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:51: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-05-08 15:51:13","OPEN_FOR_INTERNAL","2021-05-08 15:51:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:51: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-05-08 15:51:14","OPEN_FOR_INTERNAL","2021-05-08 15:51:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:51: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-05-08 15:51:16","OPEN_FOR_INTERNAL","2021-05-08 15:51:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:51: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-05-08 15:51:16","OPEN_FOR_INTERNAL","2021-05-08 15:51:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:51: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-05-08 15:51:19","OPEN_FOR_INTERNAL","2021-05-08 15:51:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:51: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-05-08 15:51:28","OPEN_FOR_INTERNAL","2021-05-08 15:51:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:51: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-05-08 15:51:55","OPEN_FOR_INTERNAL","2021-05-08 15:51:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:51: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-05-08 15:51:55","OPEN_FOR_INTERNAL","2021-05-08 15:51:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:51: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-05-08 15:51:55","OPEN_FOR_INTERNAL","2021-05-08 15:51:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:51: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-05-08 15:51:55","OPEN_FOR_INTERNAL","2021-05-08 15:51:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:51: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-05-08 15:51:56","OPEN_FOR_INTERNAL","2021-05-08 15:51:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:51: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-05-08 15:51:56","OPEN_FOR_INTERNAL","2021-05-08 15:51:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:51: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-05-08 15:51:56","OPEN_FOR_INTERNAL","2021-05-08 15:51:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:51: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-05-08 15:51:56","OPEN_FOR_INTERNAL","2021-05-08 15:51:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:51: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-05-08 15:51:56","OPEN_FOR_INTERNAL","2021-05-08 15:51:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:51: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-05-08 15:51:56","OPEN_FOR_INTERNAL","2021-05-08 15:51:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:51: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-05-08 15:51:56","OPEN_FOR_INTERNAL","2021-05-08 15:51:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:51: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-05-08 15:51:56","OPEN_FOR_INTERNAL","2021-05-08 15:51:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:51: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-05-08 15:51:56","OPEN_FOR_INTERNAL","2021-05-08 15:51:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:51: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-05-08 15:51:56","OPEN_FOR_INTERNAL","2021-05-08 15:51:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:52: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-05-08 15:52:00","OPEN_FOR_INTERNAL","2021-05-08 15:52:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:52: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-05-08 15:52:00","OPEN_FOR_INTERNAL","2021-05-08 15:52:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:52: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-05-08 15:52:06","OPEN_FOR_INTERNAL","2021-05-08 15:52:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:52: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-05-08 15:52:07","OPEN_FOR_INTERNAL","2021-05-08 15:52:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:52: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-05-08 15:52:13","OPEN_FOR_INTERNAL","2021-05-08 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:52: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-05-08 15:52:19","OPEN_FOR_INTERNAL","2021-05-08 15:52:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:52: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-05-08 15:52:19","OPEN_FOR_INTERNAL","2021-05-08 15:52:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:52: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-05-08 15:52:19","OPEN_FOR_INTERNAL","2021-05-08 15:52:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:52: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-05-08 15:52:19","OPEN_FOR_INTERNAL","2021-05-08 15:52:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:52: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-05-08 15:52:19","OPEN_FOR_INTERNAL","2021-05-08 15:52:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:52: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-05-08 15:52:19","OPEN_FOR_INTERNAL","2021-05-08 15:52:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:52: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-05-08 15:52:19","OPEN_FOR_INTERNAL","2021-05-08 15:52:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:52: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-05-08 15:52:19","OPEN_FOR_INTERNAL","2021-05-08 15:52:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:52: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-05-08 15:52:20","OPEN_FOR_INTERNAL","2021-05-08 15:52:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:52: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-05-08 15:52:20","OPEN_FOR_INTERNAL","2021-05-08 15:52:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:52: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-05-08 15:52:20","OPEN_FOR_INTERNAL","2021-05-08 15:52:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:52: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-05-08 15:52:20","OPEN_FOR_INTERNAL","2021-05-08 15:52:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:52: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-05-08 15:52:20","OPEN_FOR_INTERNAL","2021-05-08 15:52:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:52: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-05-08 15:52:20","OPEN_FOR_INTERNAL","2021-05-08 15:52:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:52:50","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-05-08 15:52:50","OPEN_FOR_INTERNAL","2021-05-08 15:52:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:52: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-05-08 15:52:51","OPEN_FOR_INTERNAL","2021-05-08 15:52:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:52: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-05-08 15:52:51","OPEN_FOR_INTERNAL","2021-05-08 15:52:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:52: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-05-08 15:52:51","OPEN_FOR_INTERNAL","2021-05-08 15:52:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:52: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-05-08 15:52:52","OPEN_FOR_INTERNAL","2021-05-08 15:52:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:52: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-05-08 15:52:55","OPEN_FOR_INTERNAL","2021-05-08 15:52:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15: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-05-08 15:54:06","OPEN_FOR_INTERNAL","2021-05-08 15:54:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15: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-05-08 15:54:06","OPEN_FOR_INTERNAL","2021-05-08 15:54:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15: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-05-08 15:54:06","OPEN_FOR_INTERNAL","2021-05-08 15:54:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:54: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-05-08 15:54:27","OPEN_FOR_INTERNAL","2021-05-08 15:54:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:54:27","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","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":445,"customer_code":"C170445","identity_type":"PERSONAL","identity_id":"K738319(3)","title":"Mr","lastname":"Sin","firstname":"Dai Chuen Sunny","companyname":"","email":"sindaichuen@netvigator.com","tel":"93632429","address":"\u9999\u6e2f\u4ed4\u4e2d\u5fc3K\u5ea7\u6d77\u6676\u95a313\u6a134\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1198.0","renew_rent_month":"1","renew_warehousing_date":"2021-05-10","renew_room_key":"054,60440","renew_remark":"1 month contract. Storage rental paid by bank transfer on Apr 7,2021. Storage deposit transferred from agreement A14-CT2110786 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT2111042, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"70","order_discount":[],"order_room":[{"room_id":"722","room_code":"N39","retail_price":"1318.0","discounted_price":"1318.00","location_id":"2"}],"roughly_size":"18","total_retail_price":1318,"total_discounted_price":1318,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1318,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2021-05-10","rent_from":"2021-05-10","rent_to":"2021-06-09","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on8 MAY 2021. Storage deposit transferred from agreement A14-CT2111042 to this agreement.\r\n\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1318,"final_order_total":1318,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,60440","order_product":[],"pass":true}},"first_order_id":"4712","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\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> N39 <\/td>\r\n\t\t\t\t\t 3X6X8 <\/td>\r\n\t\t\t\t\t $1318.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","roughly_size":"18","total_discounted_price":"1318.0","deposit":"0","total_retail_price":"1318.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:54:27","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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",445,"NEW","A14-CT2111408",1318,1318,0,0,"1","1",1318,1318,1318,"2021-05-08 15:54:27","0",null,null,null,"2021-05-10","2021-06-09","1 month contract. Storage rental paid by bank transfer on8 MAY 2021. Storage deposit transferred from agreement A14-CT2111042 to this agreement.\r\n\r\n","2021-05-10","18",0,null,0,"0","2","2021-05-08 15:54:27","2","2021-05-08 15:54:27","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,60440","C170445","PERSONAL","Mr","9L2K7wn1Opvr3WQ4vJABDA==","995YTEe316mZ2NiY\/8o00g==","","mvDoTgHRyEEzx3aiSCEV4DxQZHD5YYGgvyNzPm1QCr\/nAPIFPb3QfWTpiQPnxKX2","QrHnF9IXwKZ9qN6l8eYD5g==","A+zYSJpoRkceQYWowNFQUv3ec39gnccN6z82YnuKfNw=","d5o++GGoW7Lf\/yZcJ7PGQw==",null,1,"4712"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:54:27","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":["11408","722","1318.0","1318.00","2","2021-05-08 15:54:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:54:27","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-05-10","2021-06-09","722"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2021-05-08 15:54:27","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":["11408",445,"SETTLED","A14-I2111729","2021-05-08 15:54:27","2021-05-10","2","2021-05-08 15:54:27","2","2021-05-08 15:54:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:54:27","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":["11729","RENT","\u9810\u7e73\u79df\u91d1",1,1318,"MO","1",1318,"2","2021-05-08 15:54:27","2","2021-05-08 15:54:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:54:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1318,0,"11729"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2021-05-08 15:54:27","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":[445,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P2111365","2021-05-08 15:54:27",1318,"2","2021-05-08 15:54:27","2","2021-05-08 15:54:27","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:54:27","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":["11365","DEPOSIT",null,"PAID","2021-05-08 15:54:27",0,"2","2021-05-08 15:54:27","2","2021-05-08 15:54:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:54:27","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":["11365","INVOICE","11729","PAID","2021-05-08 15:54:27",1318,"2","2021-05-08 15:54:27","2","2021-05-08 15:54:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:54: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-05-08 15:54:27","OPEN_FOR_INTERNAL","2021-05-08 15:54:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 15:54: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-05-08 15:54:27","OPEN_FOR_INTERNAL","2021-05-08 15:54:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 16:05: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-05-08 16:05:09","OPEN_FOR_INTERNAL","2021-05-08 16:05:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 16:05: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-05-08 16:05:10","OPEN_FOR_INTERNAL","2021-05-08 16:05:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 16:05: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-05-08 16:05:12","OPEN_FOR_INTERNAL","2021-05-08 16:05:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 16:05: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-05-08 16:05:12","OPEN_FOR_INTERNAL","2021-05-08 16:05:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 16:05: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-05-08 16:05:14","OPEN_FOR_INTERNAL","2021-05-08 16:05:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 16:05: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-05-08 16:05:22","OPEN_FOR_INTERNAL","2021-05-08 16:05:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 16:30: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-05-08 16:30:06","OPEN_FOR_INTERNAL","2021-05-08 16:30:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 16:30: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-05-08 16:30:54","OPEN_FOR_INTERNAL","2021-05-08 16:30:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 16:38: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-05-08 16:38:59","OPEN_FOR_INTERNAL","2021-05-08 16:38:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 16:39: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-05-08 16:39:55","OPEN_FOR_INTERNAL","2021-05-08 16:39:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 16: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-05-08 16:39:59","OPEN_FOR_INTERNAL","2021-05-08 16:39:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 16:52: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-05-08 16:52:38","OPEN_FOR_INTERNAL","2021-05-08 16:52:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:17: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-05-08 17:17:56","OPEN_FOR_INTERNAL","2021-05-08 17:17:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:18: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-05-08 17:18:06","OPEN_FOR_INTERNAL","2021-05-08 17:18:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17: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-05-08 17:33:08","OPEN_FOR_INTERNAL","2021-05-08 17:33:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17: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-05-08 17:33:08","OPEN_FOR_INTERNAL","2021-05-08 17:33:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:33:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:33: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-05-08 17:33:10","OPEN_FOR_INTERNAL","2021-05-08 17:33:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:33: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-05-08 17:33:10","OPEN_FOR_INTERNAL","2021-05-08 17:33:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:33: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-05-08 17:33:13","OPEN_FOR_INTERNAL","2021-05-08 17:33:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:33: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-05-08 17:33:22","OPEN_FOR_INTERNAL","2021-05-08 17:33:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:33: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-05-08 17:33:25","OPEN_FOR_INTERNAL","2021-05-08 17:33:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:33: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-05-08 17:33:26","OPEN_FOR_INTERNAL","2021-05-08 17:33:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:33: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-05-08 17:33:26","OPEN_FOR_INTERNAL","2021-05-08 17:33:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:33: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-05-08 17:33:26","OPEN_FOR_INTERNAL","2021-05-08 17:33:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:33: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-05-08 17:33:26","OPEN_FOR_INTERNAL","2021-05-08 17:33:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:33: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-05-08 17:33:26","OPEN_FOR_INTERNAL","2021-05-08 17:33:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:33: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-05-08 17:33:26","OPEN_FOR_INTERNAL","2021-05-08 17:33:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:33: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-05-08 17:33:26","OPEN_FOR_INTERNAL","2021-05-08 17:33:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:33: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-05-08 17:33:26","OPEN_FOR_INTERNAL","2021-05-08 17:33:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:33: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-05-08 17:33:26","OPEN_FOR_INTERNAL","2021-05-08 17:33:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:33: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-05-08 17:33:26","OPEN_FOR_INTERNAL","2021-05-08 17:33:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:33: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-05-08 17:33:26","OPEN_FOR_INTERNAL","2021-05-08 17:33:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:33: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-05-08 17:33:26","OPEN_FOR_INTERNAL","2021-05-08 17:33:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:33: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-05-08 17:33:26","OPEN_FOR_INTERNAL","2021-05-08 17:33:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:35: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-05-08 17:35:18","OPEN_FOR_INTERNAL","2021-05-08 17:35:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:35: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-05-08 17:35:19","OPEN_FOR_INTERNAL","2021-05-08 17:35:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:35: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-05-08 17:35:19","OPEN_FOR_INTERNAL","2021-05-08 17:35:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:35: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-05-08 17:35:19","OPEN_FOR_INTERNAL","2021-05-08 17:35:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:35: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-05-08 17:35:20","OPEN_FOR_INTERNAL","2021-05-08 17:35:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:35: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-05-08 17:35:20","OPEN_FOR_INTERNAL","2021-05-08 17:35:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:35: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-05-08 17:35:20","OPEN_FOR_INTERNAL","2021-05-08 17:35:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:35: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-05-08 17:35:21","OPEN_FOR_INTERNAL","2021-05-08 17:35:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:35: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-05-08 17:35:21","OPEN_FOR_INTERNAL","2021-05-08 17:35:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:35: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-05-08 17:35:28","OPEN_FOR_INTERNAL","2021-05-08 17:35:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:35: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-05-08 17:35:28","OPEN_FOR_INTERNAL","2021-05-08 17:35:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:35: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-05-08 17:35:29","OPEN_FOR_INTERNAL","2021-05-08 17:35:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:35: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-05-08 17:35:43","OPEN_FOR_INTERNAL","2021-05-08 17:35:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:35:43","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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":62,"customer_code":"C160062","identity_type":"PERSONAL","identity_id":"K228082(5)","title":"Mr","lastname":"Yuen","firstname":"Kwok On, Mark","companyname":"","email":"ym6128@yahoo.com.hk","tel":"61287967","address":"Flat 7,20\/F ,Blk E, Yue Fai Court,Aberdeen","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2021-05-14","renew_room_key":"254,19454","renew_remark":"1 month contract. Storage rental paid by bank transfer on Apr 11,2021. Total advance payment $4 transfer to the next contract. Storage deposit transferred from agreement A12-CT2110853 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT2111081, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"1","order_discount":[],"order_room":[{"room_id":"214","room_code":"D18","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2021-05-14","rent_from":"2021-05-14","rent_to":"2021-06-13","delivery_service":"0","remark":"1 month contract. Storage rental ($598+2)paid by bank transfer on MAY 7,2021. Total advance payment $6 transfer to the next contract. Storage deposit transferred from agreement A12-CT2111081 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"1","branch_id":"1","company_id":"1","room_key":"254,19454","order_product":[],"pass":true}},"first_order_id":"4763","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\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> D18 <\/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> \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","roughly_size":"12","total_discounted_price":"598.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:35:44","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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",62,"NEW","A12-CT2111409",598,598,0,0,"1","1",598,598,598,"2021-05-08 17:35:44","0",null,null,null,"2021-05-14","2021-06-13","1 month contract. Storage rental ($598+2)paid by bank transfer on MAY 7,2021. Total advance payment $6 transfer to the next contract. Storage deposit transferred from agreement A12-CT2111081 to this agreement.","2021-05-14","12",0,null,0,"0.00","2","2021-05-08 17:35:43","2","2021-05-08 17:35:43","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"254,19454","C160062","PERSONAL","Mr","Tq2aGqdc3HaJ2Dhv1kivng==","DtbrOSvE4C7BOu5x4dBFtg==","","2dywE7m0E1QsxnoSSYjXYNGzam8BrQqJlW4yfvPMcgEUuu+U\/Cd9GXzTFUxRV\/Gk","ALSdg5RJw2nKsrdRoyKl+w==","IHWbmboe0mGIN08sR8rCSx94uDCuEAuXNvmkUE\/zPAQ=","CPbHg76fKF8UJ5bblGTxzg==",null,1,"4763"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:35:44","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":["11409","214","598.0","598.00","2","2021-05-08 17:35:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:35:44","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-05-14","2021-06-13","214"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2021-05-08 17:35:44","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":["11409",62,"SETTLED","A12-I2111730","2021-05-08 17:35:43","2021-05-14","2","2021-05-08 17:35:43","2","2021-05-08 17:35:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:35:44","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":["11730","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2021-05-08 17:35:43","2","2021-05-08 17:35:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:35:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"11730"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2021-05-08 17:35:44","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":[62,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P2111366","2021-05-08 17:35:43",598,"2","2021-05-08 17:35:43","2","2021-05-08 17:35:43","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:35:44","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":["11366","DEPOSIT",null,"PAID","2021-05-08 17:35:43",0,"2","2021-05-08 17:35:43","2","2021-05-08 17:35:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:35:44","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":["11366","INVOICE","11730","PAID","2021-05-08 17:35:43",598,"2","2021-05-08 17:35:43","2","2021-05-08 17:35:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:35: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-05-08 17:35:44","OPEN_FOR_INTERNAL","2021-05-08 17:35:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:35: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-05-08 17:35:44","OPEN_FOR_INTERNAL","2021-05-08 17:35:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:12","OPEN_FOR_INTERNAL","2021-05-08 17:44:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 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-05-08 17:44:13","OPEN_FOR_INTERNAL","2021-05-08 17:44:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:15","OPEN_FOR_INTERNAL","2021-05-08 17:44:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:15","OPEN_FOR_INTERNAL","2021-05-08 17:44:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:29","OPEN_FOR_INTERNAL","2021-05-08 17:44:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:44","OPEN_FOR_INTERNAL","2021-05-08 17:44:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:46","OPEN_FOR_INTERNAL","2021-05-08 17:44:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:46","OPEN_FOR_INTERNAL","2021-05-08 17:44:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:46","OPEN_FOR_INTERNAL","2021-05-08 17:44:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:46","OPEN_FOR_INTERNAL","2021-05-08 17:44:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:46","OPEN_FOR_INTERNAL","2021-05-08 17:44:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:46","OPEN_FOR_INTERNAL","2021-05-08 17:44:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:46","OPEN_FOR_INTERNAL","2021-05-08 17:44:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:46","OPEN_FOR_INTERNAL","2021-05-08 17:44:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:46","OPEN_FOR_INTERNAL","2021-05-08 17:44:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:46","OPEN_FOR_INTERNAL","2021-05-08 17:44:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:46","OPEN_FOR_INTERNAL","2021-05-08 17:44:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:46","OPEN_FOR_INTERNAL","2021-05-08 17:44:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:46","OPEN_FOR_INTERNAL","2021-05-08 17:44:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:46","OPEN_FOR_INTERNAL","2021-05-08 17:44:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:52","OPEN_FOR_INTERNAL","2021-05-08 17:44:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:52","OPEN_FOR_INTERNAL","2021-05-08 17:44:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:52","OPEN_FOR_INTERNAL","2021-05-08 17:44:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:52","OPEN_FOR_INTERNAL","2021-05-08 17:44:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:53","OPEN_FOR_INTERNAL","2021-05-08 17:44:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:53","OPEN_FOR_INTERNAL","2021-05-08 17:44:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:53","OPEN_FOR_INTERNAL","2021-05-08 17:44:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:53","OPEN_FOR_INTERNAL","2021-05-08 17:44:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:55","OPEN_FOR_INTERNAL","2021-05-08 17:44:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:55","OPEN_FOR_INTERNAL","2021-05-08 17:44:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:55","OPEN_FOR_INTERNAL","2021-05-08 17:44:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:44: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-05-08 17:44:55","OPEN_FOR_INTERNAL","2021-05-08 17:44:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:46: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-05-08 17:46:12","OPEN_FOR_INTERNAL","2021-05-08 17:46:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:46: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-05-08 17:46:12","OPEN_FOR_INTERNAL","2021-05-08 17:46:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:46: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-05-08 17:46:12","OPEN_FOR_INTERNAL","2021-05-08 17:46:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:46: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-05-08 17:46:18","OPEN_FOR_INTERNAL","2021-05-08 17:46:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:46: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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":675,"customer_code":"C170675","identity_type":"PERSONAL","identity_id":"D219583(7)","title":"Mr","lastname":"Pun","firstname":"Wing Cheong","companyname":"","email":null,"tel":"93211435","address":"Flat 3413, Tung Ping House, Lei Tung Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"949.0","renew_rent_month":"3","renew_warehousing_date":"2021-05-01","renew_room_key":"076,29202","renew_remark":"3 months contract. Storage rental $2847 paid by bank transfer on 4 Feb 2021. Storage deposit transferred from agreement A12-CT209404 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT2110551, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"343","room_code":"F28","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":949,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2847,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2021-05-01","rent_from":"2021-05-01","rent_to":"2021-07-31","delivery_service":"0","remark":"3 months contract. Storage rental ($2847+153) paid by bank transfer on 4 Feb 2021. Total advance payment $153 transfer to the next contract. Storage deposit transferred from agreement A12-CT2110551 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2847,"final_order_total":2847,"location_id":"1","branch_id":"1","company_id":"1","room_key":"076,29202","order_product":[],"pass":true}},"first_order_id":"9404","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\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> F28 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \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","roughly_size":"12","total_discounted_price":"949.00","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:46:18","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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",675,"NEW","A12-CT2111410",998,949,0,0,"3","3",2847,2847,2847,"2021-05-08 17:46:18","0",null,null,null,"2021-05-01","2021-07-31","3 months contract. Storage rental ($2847+153) paid by bank transfer on 4 Feb 2021. Total advance payment $153 transfer to the next contract. Storage deposit transferred from agreement A12-CT2110551 to this agreement.","2021-05-01","12",0,null,0,"0.00","2","2021-05-08 17:46:18","2","2021-05-08 17:46:18","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,29202","C170675","PERSONAL","Mr","zRl2wRT0bzGoBjayPtj0bg==","\/jZHfDSzBL6DMeP8beh11g==","","rQco+JL2vKS2IoKrZwA1yaG3nzWq9+b9wc4T7W6Yt5olYDVZu54iSWq\/s0b5tugnFNud6gxx+RBPNAHg26JO7xa3o0irEl2KUDPUiuatuPs=","8b1BJH8lCd7DJqxRE314HA==",null,"Od0RWXaEAXXPAqK4kTG2DQ==",null,1,"9404"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:46:18","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":["11410","343","998.0","998.00","2","2021-05-08 17:46:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:46:18","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-05-01","2021-07-31","343"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2021-05-08 17:46:18","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":["11410",675,"SETTLED","A12-I2111731","2021-05-08 17:46:18","2021-05-01","2","2021-05-08 17:46:18","2","2021-05-08 17:46:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:46:18","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":["11731","RENT","\u9810\u7e73\u79df\u91d1",1,949,"MO","1",949,"2","2021-05-08 17:46:18","2","2021-05-08 17:46:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:46:18","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":["11731","RENT","\u9810\u7e73\u79df\u91d1",2,949,"MO","1",949,"2","2021-05-08 17:46:18","2","2021-05-08 17:46:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:46:18","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":["11731","RENT","\u9810\u7e73\u79df\u91d1",3,949,"MO","1",949,"2","2021-05-08 17:46:18","2","2021-05-08 17:46:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:46:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2847,0,"11731"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2021-05-08 17:46:18","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":[675,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P2111367","2021-05-08 17:46:18",2847,"2","2021-05-08 17:46:18","2","2021-05-08 17:46:18","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:46:18","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":["11367","DEPOSIT",null,"PAID","2021-05-08 17:46:18",0,"2","2021-05-08 17:46:18","2","2021-05-08 17:46:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:46:18","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":["11367","INVOICE","11731","PAID","2021-05-08 17:46:18",2847,"2","2021-05-08 17:46:18","2","2021-05-08 17:46:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:46: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-05-08 17:46:18","OPEN_FOR_INTERNAL","2021-05-08 17:46:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:46: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-05-08 17:46:18","OPEN_FOR_INTERNAL","2021-05-08 17:46:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:55: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-05-08 17:55:48","OPEN_FOR_INTERNAL","2021-05-08 17:55:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:55: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-05-08 17:55:48","OPEN_FOR_INTERNAL","2021-05-08 17:55:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:55:48","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:55: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-05-08 17:55:49","OPEN_FOR_INTERNAL","2021-05-08 17:55:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:55: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-05-08 17:55:49","OPEN_FOR_INTERNAL","2021-05-08 17:55:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:55: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-05-08 17:55:53","OPEN_FOR_INTERNAL","2021-05-08 17:55:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:55: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-05-08 17:55:55","OPEN_FOR_INTERNAL","2021-05-08 17:55:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:56: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-05-08 17:56:20","OPEN_FOR_INTERNAL","2021-05-08 17:56:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:56: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-05-08 17:56:21","OPEN_FOR_INTERNAL","2021-05-08 17:56:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 17:56: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-05-08 17:56:28","OPEN_FOR_INTERNAL","2021-05-08 17:56:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:00: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-05-08 18:00:37","OPEN_FOR_INTERNAL","2021-05-08 18:00:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:00: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-05-08 18:00:37","OPEN_FOR_INTERNAL","2021-05-08 18:00:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:00:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:00: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-05-08 18:00:40","OPEN_FOR_INTERNAL","2021-05-08 18:00:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:00: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-05-08 18:00:55","OPEN_FOR_INTERNAL","2021-05-08 18:00:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:07: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-05-08 18:07:16","OPEN_FOR_INTERNAL","2021-05-08 18:07:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:07: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-05-08 18:07:26","OPEN_FOR_INTERNAL","2021-05-08 18:07:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:07: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-05-08 18:07:49","OPEN_FOR_INTERNAL","2021-05-08 18:07:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:08: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-05-08 18:08:19","OPEN_FOR_INTERNAL","2021-05-08 18:08:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:08: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-05-08 18:08:26","OPEN_FOR_INTERNAL","2021-05-08 18:08:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:08: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-05-08 18:08:53","OPEN_FOR_INTERNAL","2021-05-08 18:08:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:09: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-05-08 18:09:04","OPEN_FOR_INTERNAL","2021-05-08 18:09:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:12: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-05-08 18:12:41","OPEN_FOR_INTERNAL","2021-05-08 18:12:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:12: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-05-08 18:12:52","OPEN_FOR_INTERNAL","2021-05-08 18:12:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:13: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-05-08 18:13:26","OPEN_FOR_INTERNAL","2021-05-08 18:13:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:13: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-05-08 18:13:32","OPEN_FOR_INTERNAL","2021-05-08 18:13:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:13: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-05-08 18:13:48","OPEN_FOR_INTERNAL","2021-05-08 18:13:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:13: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-05-08 18:13:56","OPEN_FOR_INTERNAL","2021-05-08 18:13:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:15: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-05-08 18:15:38","OPEN_FOR_INTERNAL","2021-05-08 18:15:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:46: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-05-08 18:46:36","OPEN_FOR_INTERNAL","2021-05-08 18:46:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:46: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-05-08 18:46:56","OPEN_FOR_INTERNAL","2021-05-08 18:46:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 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-05-08 18:46:59","OPEN_FOR_INTERNAL","2021-05-08 18:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:47: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-05-08 18:47:20","OPEN_FOR_INTERNAL","2021-05-08 18:47:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:47: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-05-08 18:47:42","OPEN_FOR_INTERNAL","2021-05-08 18:47:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:47: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-05-08 18:47:47","OPEN_FOR_INTERNAL","2021-05-08 18:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:47: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-05-08 18:47:54","OPEN_FOR_INTERNAL","2021-05-08 18:47:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:48: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-05-08 18:48:11","OPEN_FOR_INTERNAL","2021-05-08 18:48:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:48: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-05-08 18:48:27","OPEN_FOR_INTERNAL","2021-05-08 18:48:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:49: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-05-08 18:49:27","OPEN_FOR_INTERNAL","2021-05-08 18:49:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:49: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-05-08 18:49:49","OPEN_FOR_INTERNAL","2021-05-08 18:49:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:51: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-05-08 18:51:26","OPEN_FOR_INTERNAL","2021-05-08 18:51:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:51: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-05-08 18:51:34","OPEN_FOR_INTERNAL","2021-05-08 18:51:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:51:50","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-05-08 18:51:50","OPEN_FOR_INTERNAL","2021-05-08 18:51:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:52: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-05-08 18:52:00","OPEN_FOR_INTERNAL","2021-05-08 18:52:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:52: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-05-08 18:52:12","OPEN_FOR_INTERNAL","2021-05-08 18:52:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:52: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-05-08 18:52:21","OPEN_FOR_INTERNAL","2021-05-08 18:52:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:53: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-05-08 18:53:23","OPEN_FOR_INTERNAL","2021-05-08 18:53:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:53: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-05-08 18:53:46","OPEN_FOR_INTERNAL","2021-05-08 18:53:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:53: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-05-08 18:53:46","OPEN_FOR_INTERNAL","2021-05-08 18:53:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:53:50","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-05-08 18:53:50","OPEN_FOR_INTERNAL","2021-05-08 18:53:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:53: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-05-08 18:53:51","OPEN_FOR_INTERNAL","2021-05-08 18:53:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 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-05-08 18:54:12","OPEN_FOR_INTERNAL","2021-05-08 18:54:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-05-08 18:54: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-05-08 18:54:25","OPEN_FOR_INTERNAL","2021-05-08 18:54:25"]},"data_before":[],"data_after":[],"step":1} *****