\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>
E10-78 <\/td>\n\t\t\t\t\t	5X6.5X6.8 <\/td>\n\t\t\t\t\t	$0.00 <\/td>\n\t\t\t\t	- <\/td>	<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"32.5","total_discounted_price":"2828.00","deposit":"5656.00","total_retail_price":"0.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:02:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","5","11","1793","NEW","E10-CT209258",0,2828,5656,0,"3","3",9898,14200,9958,"2020-10-16 17:02:22","0",null,null,null,"2020-10-20","2021-01-19","3 months contract. Special offered 50%off discount for the first 3 months. Storage rental, smart card fee and deposit total: $9958 paid by EPS on Sep 18, 2020. Smart card provided on the same day.","2020-10-20","32.5",0,null,4242,"4242.00","2","2020-10-16 17:02:22","2","2020-10-16 17:02:22","UNPAID","","","","UNPAID","","","",null,0,"190, 12193","C201793","PERSONAL","Ms","x7teZOWOIvosEJwGqpv9xQ==","cyZbjLKMtXmsqxQPpU0UpA==","","2ds42jK2PA6mD3PP6XCGTfPsasEnGPOyADStZiN4DGDs3LA+CUuXFpRzLJKwLC9MVzIHpeQOCKpP4WMGjHuELKrjotfYCQg+pokri4CIj0Y=","7t40BbD0S\/3FO49S27hA8Q==","icybCM3Hwdlbv64Awv+FjtVHWAVJwKk096VFOdcV6VY=","1po5H+PpKthFC8x858Q9Cg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:02:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["9258","1793","11","1","60.0",60,"2","2020-10-16 17:02:22","2","2020-10-16 17:02:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:02:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"9258"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-10-16 17:02:22","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":["9258","1955","0.0","0.00","2","2020-10-16 17:02:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:02:22","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":["2020-10-20","2021-01-19","1955"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-10-16 17:02:22","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":["9258","E10-D205784","NEW",5656,5656,"2021-01-19","2020-10-16 17:02:22","2020-10-16 17:02:22","2","2020-10-16 17:02:22","2","2020-10-16 17:02:22","1793"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:02:22","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":["9258","1793","NEW","E10-I209587","2020-10-16 17:02:22","2020-10-20","2","2020-10-16 17:02:22","2","2020-10-16 17:02:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:02:22","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":["9587","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-10-16 17:02:22","2","2020-10-16 17:02:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:02:22","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":["9587","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1414,"MO","1",1414,"2","2020-10-16 17:02:22","2","2020-10-16 17:02:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:02:22","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":["9587","RENT","\u9810\u7e73\u79df\u91d1",3,2828,"MO","1",2828,"2","2020-10-16 17:02:22","2","2020-10-16 17:02:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:02:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["9587","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-10-16 17:02:22","2","2020-10-16 17:02:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:02:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4302,60,"9587"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-10-16 17:02: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","2020-10-16 17:02:23","OPEN_FOR_INTERNAL","2020-10-16 17:02:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:02: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","2020-10-16 17:02:23","OPEN_FOR_INTERNAL","2020-10-16 17:02:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:02: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","2020-10-16 17:02:31","OPEN_FOR_INTERNAL","2020-10-16 17:02:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03: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","2020-10-16 17:03:26","OPEN_FOR_INTERNAL","2020-10-16 17:03:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:03:39","OPEN_FOR_INTERNAL","2020-10-16 17:03:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:03:39","OPEN_FOR_INTERNAL","2020-10-16 17:03:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:03:39","OPEN_FOR_INTERNAL","2020-10-16 17:03:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:03:39","OPEN_FOR_INTERNAL","2020-10-16 17:03:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:03:39","OPEN_FOR_INTERNAL","2020-10-16 17:03:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:03:39","OPEN_FOR_INTERNAL","2020-10-16 17:03:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:03:39","OPEN_FOR_INTERNAL","2020-10-16 17:03:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:03:39","OPEN_FOR_INTERNAL","2020-10-16 17:03:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:03:39","OPEN_FOR_INTERNAL","2020-10-16 17:03:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:03:39","OPEN_FOR_INTERNAL","2020-10-16 17:03:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:03:39","OPEN_FOR_INTERNAL","2020-10-16 17:03:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:03:39","OPEN_FOR_INTERNAL","2020-10-16 17:03:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:03:39","OPEN_FOR_INTERNAL","2020-10-16 17:03:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:03:39","OPEN_FOR_INTERNAL","2020-10-16 17:03:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:03:39","OPEN_FOR_INTERNAL","2020-10-16 17:03:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03: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","2020-10-16 17:03:42","OPEN_FOR_INTERNAL","2020-10-16 17:03:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03: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","2020-10-16 17:03:43","OPEN_FOR_INTERNAL","2020-10-16 17:03:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03: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","2020-10-16 17:03:43","OPEN_FOR_INTERNAL","2020-10-16 17:03:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03: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","2020-10-16 17:03:43","OPEN_FOR_INTERNAL","2020-10-16 17:03:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03: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","2020-10-16 17:03:44","OPEN_FOR_INTERNAL","2020-10-16 17:03:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03: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","2020-10-16 17:03:44","OPEN_FOR_INTERNAL","2020-10-16 17:03:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03: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","2020-10-16 17:03:44","OPEN_FOR_INTERNAL","2020-10-16 17:03:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03: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","2020-10-16 17:03:44","OPEN_FOR_INTERNAL","2020-10-16 17:03:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03: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","2020-10-16 17:03:45","OPEN_FOR_INTERNAL","2020-10-16 17:03:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03: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","2020-10-16 17:03:45","OPEN_FOR_INTERNAL","2020-10-16 17:03:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03: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","2020-10-16 17:03:45","OPEN_FOR_INTERNAL","2020-10-16 17:03:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03: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","2020-10-16 17:03:45","OPEN_FOR_INTERNAL","2020-10-16 17:03:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:03: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","2020-10-16 17:03:45","OPEN_FOR_INTERNAL","2020-10-16 17:03:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05:02","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:05:02","OPEN_FOR_INTERNAL","2020-10-16 17:05:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05:07","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:05:07","OPEN_FOR_INTERNAL","2020-10-16 17:05:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05: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","2020-10-16 17:05:08","OPEN_FOR_INTERNAL","2020-10-16 17:05:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05: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","2020-10-16 17:05:08","OPEN_FOR_INTERNAL","2020-10-16 17:05:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05: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","2020-10-16 17:05:08","OPEN_FOR_INTERNAL","2020-10-16 17:05:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17: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","2020-10-16 17:05:10","OPEN_FOR_INTERNAL","2020-10-16 17:05:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05: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","2020-10-16 17:05:11","OPEN_FOR_INTERNAL","2020-10-16 17:05:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05: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","2020-10-16 17:05:11","OPEN_FOR_INTERNAL","2020-10-16 17:05:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05: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","2020-10-16 17:05:11","OPEN_FOR_INTERNAL","2020-10-16 17:05:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17: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","2020-10-16 17:05:12","OPEN_FOR_INTERNAL","2020-10-16 17:05:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17: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","2020-10-16 17:05:12","OPEN_FOR_INTERNAL","2020-10-16 17:05:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17: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","2020-10-16 17:05:12","OPEN_FOR_INTERNAL","2020-10-16 17:05:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05: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","2020-10-16 17:05:15","OPEN_FOR_INTERNAL","2020-10-16 17:05:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05: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","2020-10-16 17:05:16","OPEN_FOR_INTERNAL","2020-10-16 17:05:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05: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","2020-10-16 17:05:17","OPEN_FOR_INTERNAL","2020-10-16 17:05:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05: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","2020-10-16 17:05:36","OPEN_FOR_INTERNAL","2020-10-16 17:05:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05: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","2020-10-16 17:05:36","OPEN_FOR_INTERNAL","2020-10-16 17:05:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05: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","2020-10-16 17:05:37","OPEN_FOR_INTERNAL","2020-10-16 17:05:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05: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","2020-10-16 17:05:42","OPEN_FOR_INTERNAL","2020-10-16 17:05:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05:42","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1197&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1347","master_room_id":"171","room_code":"C15-041"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":997,"customer_code":"C180997","identity_type":"PERSONAL","identity_id":"D080384(8)","title":"Mr","lastname":"Fung","firstname":"Siu Tong","companyname":"","email":"philpstfung@yahoo.com","tel":"67050870","address":"Flat D, 2\/F , Block 6 , 27 GREIG CRESCENT, NAN FUNG SUN CHUEN, QUARRY BAY, HONG KONG","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"729.0","renew_rent_month":"12","renew_warehousing_date":"2020-10-26","renew_room_key":"'0006005601","renew_remark":"12 months contract. Special offer $729\/month. Storage rental paid by Cheque on September 25 2019. Storage deposit $1796 transferred from agreement C15-CT183305 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT196023, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"167","order_discount":[],"order_room":[{"room_id":"1325","room_code":"C15-019","retail_price":"810.0","discounted_price":"810.00","location_id":"6"}],"roughly_size":"12","total_retail_price":810,"total_discounted_price":809,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":9708,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-10-26","rent_from":"2020-10-26","rent_to":"2021-10-25","delivery_service":"0","remark":"12 months contract. Storage rental paid by quick cheque deposit on 16 Oct 2020. Deposit $1796 transferred from agreement C15-CT196023 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"HSBC","cheque_num2":"801702","discount_deduct":0,"order_total":9708,"final_order_total":9708,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0006005601","order_product":[],"pass":true}},"first_order_id":"3305","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> C15-019 <\/td>\r\n\t\t\t\t\t 4X3X6.5 <\/td>\r\n\t\t\t\t\t $810.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\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":"809.00","deposit":"0.00","total_retail_price":"810.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05:42","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","3","6",997,"NEW","C15-CT209259",810,809,0,0,"12","12",9708,9708,9708,"2020-10-16 17:05:42","0",null,null,null,"2020-10-26","2021-10-25","12 months contract. Storage rental paid by quick cheque deposit on 16 Oct 2020. Deposit $1796 transferred from agreement C15-CT196023 to this agreement.","2020-10-26","12",0,null,0,"0.00","2","2020-10-16 17:05:42","2","2020-10-16 17:05:42","NO_NEED_PAID_RENEW","","","","CHEQUE","HSBC","801702","",null,0,"0006005601","C180997","PERSONAL","Mr","jFaEh2ayS4Jh9BTZRAk7LQ==","fw9NU0t2sgJqYX3ZpxPMlA==","","Tg3maKgBu7cC7MlWL4XT7Zkm0YAMwYagR3WN1gPrQ1Og7N63xBxSdqu0xDoSqYADDvYelOMCDDH\/N3MbccJcsR+EJdiS3flpX9+My5pP+Mq+q2lnoU1xmnVWsI+UKXsf","m2it95miK8v\/6CWjQE0yZw==","K1ilY1ovmPPTq1XKFMcia+x+0BLUddOfvlq0nNLd6DQ=","0a1hwlnp0Ir14B6QWiOkrQ==",null,1,"3305"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05:42","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":["9259","1325","810.0","810.00","2","2020-10-16 17:05:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05:42","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":["2020-10-26","2021-10-25","1325"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-10-16 17:05:42","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":["9259",997,"SETTLED","C15-I209588","2020-10-16 17:05:42","2020-10-26","2","2020-10-16 17:05:42","2","2020-10-16 17:05:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05:42","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":["9588","RENT","\u9810\u7e73\u79df\u91d1",1,809,"MO","1",809,"2","2020-10-16 17:05:42","2","2020-10-16 17:05:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05:42","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":["9588","RENT","\u9810\u7e73\u79df\u91d1",2,809,"MO","1",809,"2","2020-10-16 17:05:42","2","2020-10-16 17:05:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05:42","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":["9588","RENT","\u9810\u7e73\u79df\u91d1",3,809,"MO","1",809,"2","2020-10-16 17:05:42","2","2020-10-16 17:05:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05:42","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":["9588","RENT","\u9810\u7e73\u79df\u91d1",4,809,"MO","1",809,"2","2020-10-16 17:05:42","2","2020-10-16 17:05:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05:42","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":["9588","RENT","\u9810\u7e73\u79df\u91d1",5,809,"MO","1",809,"2","2020-10-16 17:05:42","2","2020-10-16 17:05:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05:42","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":["9588","RENT","\u9810\u7e73\u79df\u91d1",6,809,"MO","1",809,"2","2020-10-16 17:05:42","2","2020-10-16 17:05:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05:42","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":["9588","RENT","\u9810\u7e73\u79df\u91d1",7,809,"MO","1",809,"2","2020-10-16 17:05:42","2","2020-10-16 17:05:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05:42","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":["9588","RENT","\u9810\u7e73\u79df\u91d1",8,809,"MO","1",809,"2","2020-10-16 17:05:42","2","2020-10-16 17:05:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05:42","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":["9588","RENT","\u9810\u7e73\u79df\u91d1",9,809,"MO","1",809,"2","2020-10-16 17:05:42","2","2020-10-16 17:05:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05:42","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":["9588","RENT","\u9810\u7e73\u79df\u91d1",10,809,"MO","1",809,"2","2020-10-16 17:05:42","2","2020-10-16 17:05:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05:42","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":["9588","RENT","\u9810\u7e73\u79df\u91d1",11,809,"MO","1",809,"2","2020-10-16 17:05:42","2","2020-10-16 17:05:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05:42","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":["9588","RENT","\u9810\u7e73\u79df\u91d1",12,809,"MO","1",809,"2","2020-10-16 17:05:42","2","2020-10-16 17:05:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[9708,0,"9588"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-10-16 17:05:42","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":[997,"NO_NEED_PAID_RENEW","","","","CHEQUE","HSBC","801702","","PAID","P209228","2020-10-16 17:05:42",9708,"2","2020-10-16 17:05:42","2","2020-10-16 17:05:42","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05:42","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":["9228","DEPOSIT",null,"PAID","2020-10-16 17:05:42",0,"2","2020-10-16 17:05:42","2","2020-10-16 17:05:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05:42","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":["9228","INVOICE","9588","PAID","2020-10-16 17:05:42",9708,"2","2020-10-16 17:05:42","2","2020-10-16 17:05:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05: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","2020-10-16 17:05:42","OPEN_FOR_INTERNAL","2020-10-16 17:05:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:05: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","2020-10-16 17:05:42","OPEN_FOR_INTERNAL","2020-10-16 17:05:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:08: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","2020-10-16 17:08:54","OPEN_FOR_INTERNAL","2020-10-16 17:08:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:08:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:08: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","2020-10-16 17:08:56","OPEN_FOR_INTERNAL","2020-10-16 17:08:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:09: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","2020-10-16 17:09:02","OPEN_FOR_INTERNAL","2020-10-16 17:09:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:11: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","2020-10-16 17:11:52","OPEN_FOR_INTERNAL","2020-10-16 17:11:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:11: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","2020-10-16 17:11:53","OPEN_FOR_INTERNAL","2020-10-16 17:11:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:11: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","2020-10-16 17:11:55","OPEN_FOR_INTERNAL","2020-10-16 17:11:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:11: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","2020-10-16 17:11:56","OPEN_FOR_INTERNAL","2020-10-16 17:11:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:12:14","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:12:14","OPEN_FOR_INTERNAL","2020-10-16 17:12:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:12: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","2020-10-16 17:12:17","OPEN_FOR_INTERNAL","2020-10-16 17:12:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:12: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","2020-10-16 17:12:18","OPEN_FOR_INTERNAL","2020-10-16 17:12:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:12: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","2020-10-16 17:12:58","OPEN_FOR_INTERNAL","2020-10-16 17:12:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:12: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","2020-10-16 17:12:58","OPEN_FOR_INTERNAL","2020-10-16 17:12:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:12:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:13: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","2020-10-16 17:13:53","OPEN_FOR_INTERNAL","2020-10-16 17:13:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:13:58","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:13:58","OPEN_FOR_INTERNAL","2020-10-16 17:13:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:14:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:14:39","OPEN_FOR_INTERNAL","2020-10-16 17:14:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:19:01","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:19:01","OPEN_FOR_INTERNAL","2020-10-16 17:19:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:22: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","2020-10-16 17:22:19","OPEN_FOR_INTERNAL","2020-10-16 17:22:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:22: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","2020-10-16 17:22:19","OPEN_FOR_INTERNAL","2020-10-16 17:22:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:22:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:24: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","2020-10-16 17:24:16","OPEN_FOR_INTERNAL","2020-10-16 17:24:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:24: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","2020-10-16 17:24:23","OPEN_FOR_INTERNAL","2020-10-16 17:24:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:26: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","2020-10-16 17:26:45","OPEN_FOR_INTERNAL","2020-10-16 17:26:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:26:45","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:26: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","2020-10-16 17:26:48","OPEN_FOR_INTERNAL","2020-10-16 17:26:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:26: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","2020-10-16 17:26:59","OPEN_FOR_INTERNAL","2020-10-16 17:26:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:27: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","2020-10-16 17:27:09","OPEN_FOR_INTERNAL","2020-10-16 17:27:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:27: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","2020-10-16 17:27:16","OPEN_FOR_INTERNAL","2020-10-16 17:27:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:27: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","2020-10-16 17:27:33","OPEN_FOR_INTERNAL","2020-10-16 17:27:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:29: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","2020-10-16 17:29:50","OPEN_FOR_INTERNAL","2020-10-16 17:29:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:29:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:29: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","2020-10-16 17:29:55","OPEN_FOR_INTERNAL","2020-10-16 17:29:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17: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","2020-10-16 17:30:06","OPEN_FOR_INTERNAL","2020-10-16 17:30:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:30: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","2020-10-16 17:30:16","OPEN_FOR_INTERNAL","2020-10-16 17:30:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:30: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","2020-10-16 17:30:29","OPEN_FOR_INTERNAL","2020-10-16 17:30:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:30:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:30:39","OPEN_FOR_INTERNAL","2020-10-16 17:30:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:30: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","2020-10-16 17:30:49","OPEN_FOR_INTERNAL","2020-10-16 17:30:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:30: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","2020-10-16 17:30:55","OPEN_FOR_INTERNAL","2020-10-16 17:30:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:30: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","2020-10-16 17:30:58","OPEN_FOR_INTERNAL","2020-10-16 17:30:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:31: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","2020-10-16 17:31:04","OPEN_FOR_INTERNAL","2020-10-16 17:31:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:31: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","2020-10-16 17:31:09","OPEN_FOR_INTERNAL","2020-10-16 17:31:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:31: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","2020-10-16 17:31:13","OPEN_FOR_INTERNAL","2020-10-16 17:31:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:31: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","2020-10-16 17:31:20","OPEN_FOR_INTERNAL","2020-10-16 17:31:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:31: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","2020-10-16 17:31:24","OPEN_FOR_INTERNAL","2020-10-16 17:31:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:31: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","2020-10-16 17:31:29","OPEN_FOR_INTERNAL","2020-10-16 17:31:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:31:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:31:39","OPEN_FOR_INTERNAL","2020-10-16 17:31:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:31: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","2020-10-16 17:31:50","OPEN_FOR_INTERNAL","2020-10-16 17:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:32: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","2020-10-16 17:32:07","OPEN_FOR_INTERNAL","2020-10-16 17:32:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:32: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","2020-10-16 17:32:35","OPEN_FOR_INTERNAL","2020-10-16 17:32:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:32:35","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:32:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:32:39","OPEN_FOR_INTERNAL","2020-10-16 17:32:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:34: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","2020-10-16 17:34:06","OPEN_FOR_INTERNAL","2020-10-16 17:34:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:34: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","2020-10-16 17:34:08","OPEN_FOR_INTERNAL","2020-10-16 17:34:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:34: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","2020-10-16 17:34:10","OPEN_FOR_INTERNAL","2020-10-16 17:34:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:34: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","2020-10-16 17:34:10","OPEN_FOR_INTERNAL","2020-10-16 17:34:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:35: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","2020-10-16 17:35:40","OPEN_FOR_INTERNAL","2020-10-16 17:35:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:35: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","2020-10-16 17:35:45","OPEN_FOR_INTERNAL","2020-10-16 17:35:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:35: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","2020-10-16 17:35:45","OPEN_FOR_INTERNAL","2020-10-16 17:35:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:35: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","2020-10-16 17:35:47","OPEN_FOR_INTERNAL","2020-10-16 17:35:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:35: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","2020-10-16 17:35:49","OPEN_FOR_INTERNAL","2020-10-16 17:35:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:35: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","2020-10-16 17:35:49","OPEN_FOR_INTERNAL","2020-10-16 17:35:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:35: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","2020-10-16 17:35:49","OPEN_FOR_INTERNAL","2020-10-16 17:35:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:35: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","2020-10-16 17:35:49","OPEN_FOR_INTERNAL","2020-10-16 17:35:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:35: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","2020-10-16 17:35:51","OPEN_FOR_INTERNAL","2020-10-16 17:35:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:35: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","2020-10-16 17:35:51","OPEN_FOR_INTERNAL","2020-10-16 17:35:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:35: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","2020-10-16 17:35:53","OPEN_FOR_INTERNAL","2020-10-16 17:35:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:35: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","2020-10-16 17:35:53","OPEN_FOR_INTERNAL","2020-10-16 17:35:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:35: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","2020-10-16 17:35:53","OPEN_FOR_INTERNAL","2020-10-16 17:35:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:35: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","2020-10-16 17:35:53","OPEN_FOR_INTERNAL","2020-10-16 17:35:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:37: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","2020-10-16 17:37:48","OPEN_FOR_INTERNAL","2020-10-16 17:37:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:37: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","2020-10-16 17:37:48","OPEN_FOR_INTERNAL","2020-10-16 17:37:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:37: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","2020-10-16 17:37:48","OPEN_FOR_INTERNAL","2020-10-16 17:37:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:37: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","2020-10-16 17:37:48","OPEN_FOR_INTERNAL","2020-10-16 17:37:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:37: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","2020-10-16 17:37:49","OPEN_FOR_INTERNAL","2020-10-16 17:37:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:37: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","2020-10-16 17:37:50","OPEN_FOR_INTERNAL","2020-10-16 17:37:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:37: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","2020-10-16 17:37:50","OPEN_FOR_INTERNAL","2020-10-16 17:37:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:37: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","2020-10-16 17:37:51","OPEN_FOR_INTERNAL","2020-10-16 17:37:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:37: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","2020-10-16 17:37:56","OPEN_FOR_INTERNAL","2020-10-16 17:37:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:37:57","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:37:57","OPEN_FOR_INTERNAL","2020-10-16 17:37:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:37:57","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:37:57","OPEN_FOR_INTERNAL","2020-10-16 17:37:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:37:57","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:37:57","OPEN_FOR_INTERNAL","2020-10-16 17:37:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:37:57","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 17:37:57","OPEN_FOR_INTERNAL","2020-10-16 17:37:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:37: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","2020-10-16 17:37:58","OPEN_FOR_INTERNAL","2020-10-16 17:37:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:37: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","2020-10-16 17:37:58","OPEN_FOR_INTERNAL","2020-10-16 17:37:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:37: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","2020-10-16 17:37:58","OPEN_FOR_INTERNAL","2020-10-16 17:37:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:38: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","2020-10-16 17:38:01","OPEN_FOR_INTERNAL","2020-10-16 17:38:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:38: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","2020-10-16 17:38:06","OPEN_FOR_INTERNAL","2020-10-16 17:38:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:39: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","2020-10-16 17:39:36","OPEN_FOR_INTERNAL","2020-10-16 17:39:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:39: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","2020-10-16 17:39:36","OPEN_FOR_INTERNAL","2020-10-16 17:39:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:39: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","2020-10-16 17:39:38","OPEN_FOR_INTERNAL","2020-10-16 17:39:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:39: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","2020-10-16 17:39:38","OPEN_FOR_INTERNAL","2020-10-16 17:39:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:39: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","2020-10-16 17:39:44","OPEN_FOR_INTERNAL","2020-10-16 17:39:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:39: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","2020-10-16 17:39:45","OPEN_FOR_INTERNAL","2020-10-16 17:39:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:39: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","2020-10-16 17:39:45","OPEN_FOR_INTERNAL","2020-10-16 17:39:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:39: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","2020-10-16 17:39:46","OPEN_FOR_INTERNAL","2020-10-16 17:39:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40: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","2020-10-16 17:40:04","OPEN_FOR_INTERNAL","2020-10-16 17:40:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40: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","2020-10-16 17:40:04","OPEN_FOR_INTERNAL","2020-10-16 17:40:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40: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","2020-10-16 17:40:05","OPEN_FOR_INTERNAL","2020-10-16 17:40:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40: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","2020-10-16 17:40:05","OPEN_FOR_INTERNAL","2020-10-16 17:40:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40: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","2020-10-16 17:40:05","OPEN_FOR_INTERNAL","2020-10-16 17:40:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40: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","2020-10-16 17:40:05","OPEN_FOR_INTERNAL","2020-10-16 17:40:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40: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","2020-10-16 17:40:05","OPEN_FOR_INTERNAL","2020-10-16 17:40:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40: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","2020-10-16 17:40:06","OPEN_FOR_INTERNAL","2020-10-16 17:40:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40: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","2020-10-16 17:40:18","OPEN_FOR_INTERNAL","2020-10-16 17:40:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40: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","2020-10-16 17:40:18","OPEN_FOR_INTERNAL","2020-10-16 17:40:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40: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","2020-10-16 17:40:18","OPEN_FOR_INTERNAL","2020-10-16 17:40:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40: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","2020-10-16 17:40:29","OPEN_FOR_INTERNAL","2020-10-16 17:40:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40:29","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"2022","master_room_id":"329","room_code":"D18-60"}],"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> D18-60 <\/td>\r\n\t\t\t\t\t 8X4X6.8 <\/td>\r\n\t\t\t\t\t $0.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"K093944(7)","title":"Ms","lastname":"LEE","firstname":"Pui Yan Ida","companyname":"","email":"idalee1202@gmail.com","tel":"90917470","address":"2\/F THEDESK, 50 BONHAM STRAND, SHEUNG WAN, HONG KONG","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"2022","room_code":"D18-60","retail_price":"0.0","discounted_price":"0.00","location_id":"10"}],"roughly_size":"32","total_retail_price":0,"total_discounted_price":2408,"deposit":4816,"rent_month":"4","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"4","prepaid_amount":10716,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3732.00","warehousing_date":"2020-10-26","rent_from":"2020-10-26","rent_to":"2021-02-25","delivery_service":"0","remark":"4 months contract. First 3 months with 50% off. Storage rental and deposit paid by bank transfer on Oct 16, 2020. Smart card provided on the same day.\t\r\n","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":3732,"order_total":14508,"final_order_total":10776,"location_id":"10","branch_id":"4","company_id":"1","room_key":"","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"pass":true}},"roughly_size":"32","total_discounted_price":"2408.00","deposit":"4816.00","total_retail_price":"0.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40:31","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":["C201812","PERSONAL","Ms","sp2Tvz2Tpe80xdqmcGwD8Q==","brgGVGuPrfoSjI4k+kLGow==","","ZT1kOKqHuvBgLGyNbNxz\/A==","a+gkpuHbvqYWZO2OHOaYKzmxAQJIVtzGWiq6+XLHT7Q=","SyL7bKB2Fd6XwJ6xj0bH2C7rD11uzmrzzz6Rsrhj+C\/FdPFAG8TbFjCbMzBZOyyft1V6B4ezqA9p87hVJejKGg==","LVx6O9UBG9yjA5mOixM08A==",null,"a+gkpuHbvqYWZO2OHOaYKzmxAQJIVtzGWiq6+XLHT7Q=","YDYoll2Fr4zpPLnantnoOQ==","2","2020-10-16 17:40:29","2","2020-10-16 17:40:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40:31","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","4","10",1812,"NEW","D18-CT209260",0,2408,4816,0,"4","4",10716,14508,10776,"2020-10-16 17:40:31","0",null,null,null,"2020-10-26","2021-02-25","4 months contract. First 3 months with 50% off. Storage rental and deposit paid by bank transfer on Oct 16, 2020. Smart card provided on the same day.\t\r\n","2020-10-26","32",0,null,3732,"3732.00","2","2020-10-16 17:40:29","2","2020-10-16 17:40:29","BANKIN","","","","BANKIN","","","",null,0,"","C201812","PERSONAL","Ms","sp2Tvz2Tpe80xdqmcGwD8Q==","brgGVGuPrfoSjI4k+kLGow==","","SyL7bKB2Fd6XwJ6xj0bH2C7rD11uzmrzzz6Rsrhj+C\/FdPFAG8TbFjCbMzBZOyyft1V6B4ezqA9p87hVJejKGg==","ZT1kOKqHuvBgLGyNbNxz\/A==","a+gkpuHbvqYWZO2OHOaYKzmxAQJIVtzGWiq6+XLHT7Q=","LVx6O9UBG9yjA5mOixM08A==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["9260",1812,"11","1","60.0",60,"2","2020-10-16 17:40:29","2","2020-10-16 17:40:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"9260"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-10-16 17:40:31","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":["9260","2022","0.0","0.00","2","2020-10-16 17:40:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40:31","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":["2020-10-26","2021-02-25","2022"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-10-16 17:40:31","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":["9260","D18-D205785","PAID",4816,0,"2021-02-25","2020-10-16 17:40:29","2020-10-16 17:40:29","2","2020-10-16 17:40:29","2","2020-10-16 17:40:29",1812]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40:31","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":["9260",1812,"SETTLED","D18-I209589","2020-10-16 17:40:29","2020-10-26","2","2020-10-16 17:40:29","2","2020-10-16 17:40:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40:31","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":["9589","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-10-16 17:40:29","2","2020-10-16 17:40:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40:31","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":["9589","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1084,"MO","1",1084,"2","2020-10-16 17:40:29","2","2020-10-16 17:40:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40:31","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":["9589","RENT","\u9810\u7e73\u79df\u91d1",3,2408,"MO","1",2408,"2","2020-10-16 17:40:29","2","2020-10-16 17:40:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40:31","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":["9589","RENT","\u9810\u7e73\u79df\u91d1",4,2408,"MO","1",2408,"2","2020-10-16 17:40:29","2","2020-10-16 17:40:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["9589","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-10-16 17:40:29","2","2020-10-16 17:40:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5960,0,"9589"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-10-16 17:40:31","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":[1812,"BANKIN","","","","BANKIN","","","","PAID","P209229","2020-10-16 17:40:29",10776,"2","2020-10-16 17:40:29","2","2020-10-16 17:40:29","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40:31","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":["9229","DEPOSIT","5785","PAID","2020-10-16 17:40:29",4816,"2","2020-10-16 17:40:29","2","2020-10-16 17:40:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40:31","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":["9229","INVOICE","9589","PAID","2020-10-16 17:40:29",5960,"2","2020-10-16 17:40:29","2","2020-10-16 17:40:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40: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","2020-10-16 17:40:32","OPEN_FOR_INTERNAL","2020-10-16 17:40:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:40: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","2020-10-16 17:40:32","OPEN_FOR_INTERNAL","2020-10-16 17:40:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:42: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","2020-10-16 17:42:00","OPEN_FOR_INTERNAL","2020-10-16 17:42:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:44: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","2020-10-16 17:44:27","OPEN_FOR_INTERNAL","2020-10-16 17:44:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:55: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","2020-10-16 17:55:36","OPEN_FOR_INTERNAL","2020-10-16 17:55:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:55: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","2020-10-16 17:55:36","OPEN_FOR_INTERNAL","2020-10-16 17:55:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:55:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:55: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","2020-10-16 17:55:37","OPEN_FOR_INTERNAL","2020-10-16 17:55:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17:55: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","2020-10-16 17:55:37","OPEN_FOR_INTERNAL","2020-10-16 17:55:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 17: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","2020-10-16 17:58:05","OPEN_FOR_INTERNAL","2020-10-16 17:58:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:00: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","2020-10-16 18:00:52","OPEN_FOR_INTERNAL","2020-10-16 18:00:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:00: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","2020-10-16 18:00:56","OPEN_FOR_INTERNAL","2020-10-16 18:00:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:03: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","2020-10-16 18:03:31","OPEN_FOR_INTERNAL","2020-10-16 18:03:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:03: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","2020-10-16 18:03:34","OPEN_FOR_INTERNAL","2020-10-16 18:03:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:03: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","2020-10-16 18:03:34","OPEN_FOR_INTERNAL","2020-10-16 18:03:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:03:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 18:03:39","OPEN_FOR_INTERNAL","2020-10-16 18:03:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:03: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","2020-10-16 18:03:40","OPEN_FOR_INTERNAL","2020-10-16 18:03:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:30: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","2020-10-16 18:30:42","OPEN_FOR_INTERNAL","2020-10-16 18:30:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:30: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","2020-10-16 18:30:49","OPEN_FOR_INTERNAL","2020-10-16 18:30:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:31: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","2020-10-16 18:31:33","OPEN_FOR_INTERNAL","2020-10-16 18:31:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:31:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:31: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","2020-10-16 18:31:37","OPEN_FOR_INTERNAL","2020-10-16 18:31:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:31: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","2020-10-16 18:31:54","OPEN_FOR_INTERNAL","2020-10-16 18:31:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:32: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","2020-10-16 18:32:17","OPEN_FOR_INTERNAL","2020-10-16 18:32:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:32: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","2020-10-16 18:32:24","OPEN_FOR_INTERNAL","2020-10-16 18:32:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:32: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","2020-10-16 18:32:27","OPEN_FOR_INTERNAL","2020-10-16 18:32:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:32: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","2020-10-16 18:32:35","OPEN_FOR_INTERNAL","2020-10-16 18:32:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:34: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","2020-10-16 18:34:17","OPEN_FOR_INTERNAL","2020-10-16 18:34:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:34: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","2020-10-16 18:34:40","OPEN_FOR_INTERNAL","2020-10-16 18:34:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:34: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","2020-10-16 18:34:47","OPEN_FOR_INTERNAL","2020-10-16 18:34:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:34: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","2020-10-16 18:34:48","OPEN_FOR_INTERNAL","2020-10-16 18:34:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:34:48","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:34: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","2020-10-16 18:34:52","OPEN_FOR_INTERNAL","2020-10-16 18:34:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:34: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","2020-10-16 18:34:52","OPEN_FOR_INTERNAL","2020-10-16 18:34:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:34: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","2020-10-16 18:34:56","OPEN_FOR_INTERNAL","2020-10-16 18:34:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:34:57","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 18:34:57","OPEN_FOR_INTERNAL","2020-10-16 18:34:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:35: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","2020-10-16 18:35:01","OPEN_FOR_INTERNAL","2020-10-16 18:35:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:35: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","2020-10-16 18:35:14","OPEN_FOR_INTERNAL","2020-10-16 18:35:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:35: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","2020-10-16 18:35:15","OPEN_FOR_INTERNAL","2020-10-16 18:35:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18: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","2020-10-16 18:35:21","OPEN_FOR_INTERNAL","2020-10-16 18:35:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:35: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","2020-10-16 18:35:37","OPEN_FOR_INTERNAL","2020-10-16 18:35:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:35: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","2020-10-16 18:35:40","OPEN_FOR_INTERNAL","2020-10-16 18:35:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18: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","2020-10-16 18:35:43","OPEN_FOR_INTERNAL","2020-10-16 18:35:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18: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","2020-10-16 18:35:43","OPEN_FOR_INTERNAL","2020-10-16 18:35:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:35:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:35: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","2020-10-16 18:35:46","OPEN_FOR_INTERNAL","2020-10-16 18:35:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:35: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","2020-10-16 18:35:55","OPEN_FOR_INTERNAL","2020-10-16 18:35:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18: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","2020-10-16 18:36:09","OPEN_FOR_INTERNAL","2020-10-16 18:36:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18: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","2020-10-16 18:36:09","OPEN_FOR_INTERNAL","2020-10-16 18:36:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:36:14","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 18:36:14","OPEN_FOR_INTERNAL","2020-10-16 18:36:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:36:14","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 18:36:14","OPEN_FOR_INTERNAL","2020-10-16 18:36:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:36: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","2020-10-16 18:36:21","OPEN_FOR_INTERNAL","2020-10-16 18:36:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:36: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","2020-10-16 18:36:27","OPEN_FOR_INTERNAL","2020-10-16 18:36:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:37: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","2020-10-16 18:37:10","OPEN_FOR_INTERNAL","2020-10-16 18:37:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:37: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","2020-10-16 18:37:29","OPEN_FOR_INTERNAL","2020-10-16 18:37:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:37: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","2020-10-16 18:37:29","OPEN_FOR_INTERNAL","2020-10-16 18:37:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:37: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","2020-10-16 18:37:33","OPEN_FOR_INTERNAL","2020-10-16 18:37:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:37: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","2020-10-16 18:37:34","OPEN_FOR_INTERNAL","2020-10-16 18:37:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:37: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","2020-10-16 18:37:48","OPEN_FOR_INTERNAL","2020-10-16 18:37:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:37: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","2020-10-16 18:37:49","OPEN_FOR_INTERNAL","2020-10-16 18:37:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:37: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","2020-10-16 18:37:56","OPEN_FOR_INTERNAL","2020-10-16 18:37:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:37:57","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 18:37:57","OPEN_FOR_INTERNAL","2020-10-16 18:37:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:37: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","2020-10-16 18:37:59","OPEN_FOR_INTERNAL","2020-10-16 18:37:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:38: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","2020-10-16 18:38:03","OPEN_FOR_INTERNAL","2020-10-16 18:38:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:38: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","2020-10-16 18:38:08","OPEN_FOR_INTERNAL","2020-10-16 18:38:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:38:08","login_id":"2","controller":"_ajax.php","function":"update_room","input":{"post":{"room_code":"I05","room_id":"414","master_room_id":"29","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=2&filter2=1644&filter3=undefined","floor_plan_rent_room":[{"room_id":"1347","master_room_id":"171","room_code":"C15-041"}],"total_retail_price":"810.00"},"sql":"update room set status = ?, master_room_id = ?, lastupby = ?, lastupdate = ? where id = ?","parameters":["OPEN","29","2","2020-10-16 18:38:08","414"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:38: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","2020-10-16 18:38:10","OPEN_FOR_INTERNAL","2020-10-16 18:38:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:38:10","login_id":"2","controller":"_ajax.php","function":"update_room","input":{"post":{"room_code":"I05","room_id":"414","master_room_id":"29","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=2&filter2=1644&filter3=undefined","floor_plan_rent_room":[{"room_id":"1347","master_room_id":"171","room_code":"C15-041"}],"total_retail_price":"810.00"},"sql":"update room set status = ?, master_room_id = ?, lastupby = ?, lastupdate = ? where id = ?","parameters":["OPEN","29","2","2020-10-16 18:38:10","414"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:39: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","2020-10-16 18:39:20","OPEN_FOR_INTERNAL","2020-10-16 18:39:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:39: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","2020-10-16 18:39:32","OPEN_FOR_INTERNAL","2020-10-16 18:39:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:39: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","2020-10-16 18:39:36","OPEN_FOR_INTERNAL","2020-10-16 18:39:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:39: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","2020-10-16 18:39:38","OPEN_FOR_INTERNAL","2020-10-16 18:39:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:43: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","2020-10-16 18:43:50","OPEN_FOR_INTERNAL","2020-10-16 18:43:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:43:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:43: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","2020-10-16 18:43:55","OPEN_FOR_INTERNAL","2020-10-16 18:43:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:44: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","2020-10-16 18:44:10","OPEN_FOR_INTERNAL","2020-10-16 18:44:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:47: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","2020-10-16 18:47:02","OPEN_FOR_INTERNAL","2020-10-16 18:47:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:47: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","2020-10-16 18:47:11","OPEN_FOR_INTERNAL","2020-10-16 18:47:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:47: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","2020-10-16 18:47:32","OPEN_FOR_INTERNAL","2020-10-16 18:47:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:47: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","2020-10-16 18:47:34","OPEN_FOR_INTERNAL","2020-10-16 18:47:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:47:57","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 18:47:57","OPEN_FOR_INTERNAL","2020-10-16 18:47:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:48: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","2020-10-16 18:48:05","OPEN_FOR_INTERNAL","2020-10-16 18:48:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:48: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","2020-10-16 18:48:05","OPEN_FOR_INTERNAL","2020-10-16 18:48:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:48: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","2020-10-16 18:48:08","OPEN_FOR_INTERNAL","2020-10-16 18:48:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:48: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","2020-10-16 18:48:20","OPEN_FOR_INTERNAL","2020-10-16 18:48:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:48: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","2020-10-16 18:48:31","OPEN_FOR_INTERNAL","2020-10-16 18:48:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:48: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","2020-10-16 18:48:36","OPEN_FOR_INTERNAL","2020-10-16 18:48:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:48: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","2020-10-16 18:48:38","OPEN_FOR_INTERNAL","2020-10-16 18:48:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:48: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","2020-10-16 18:48:40","OPEN_FOR_INTERNAL","2020-10-16 18:48:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:48: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","2020-10-16 18:48:55","OPEN_FOR_INTERNAL","2020-10-16 18:48:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:48: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","2020-10-16 18:48:58","OPEN_FOR_INTERNAL","2020-10-16 18:48:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:49: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","2020-10-16 18:49:01","OPEN_FOR_INTERNAL","2020-10-16 18:49:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:49: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","2020-10-16 18:49:11","OPEN_FOR_INTERNAL","2020-10-16 18:49:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:49: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","2020-10-16 18:49:16","OPEN_FOR_INTERNAL","2020-10-16 18:49:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:49: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","2020-10-16 18:49:23","OPEN_FOR_INTERNAL","2020-10-16 18:49:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:49:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 18:49:39","OPEN_FOR_INTERNAL","2020-10-16 18:49:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:49: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","2020-10-16 18:49:45","OPEN_FOR_INTERNAL","2020-10-16 18:49:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:50: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","2020-10-16 18:50:06","OPEN_FOR_INTERNAL","2020-10-16 18:50:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:50: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","2020-10-16 18:50:11","OPEN_FOR_INTERNAL","2020-10-16 18:50:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:50: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","2020-10-16 18:50:40","OPEN_FOR_INTERNAL","2020-10-16 18:50:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:50: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","2020-10-16 18:50:45","OPEN_FOR_INTERNAL","2020-10-16 18:50:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:51: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","2020-10-16 18:51:01","OPEN_FOR_INTERNAL","2020-10-16 18:51:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:51: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","2020-10-16 18:51:04","OPEN_FOR_INTERNAL","2020-10-16 18:51:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:51: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","2020-10-16 18:51:18","OPEN_FOR_INTERNAL","2020-10-16 18:51:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:51: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","2020-10-16 18:51:22","OPEN_FOR_INTERNAL","2020-10-16 18:51:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:51: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","2020-10-16 18:51:37","OPEN_FOR_INTERNAL","2020-10-16 18:51:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:51: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","2020-10-16 18:51:40","OPEN_FOR_INTERNAL","2020-10-16 18:51:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18: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","2020-10-16 18:51:56","OPEN_FOR_INTERNAL","2020-10-16 18:51:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 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","2020-10-16 18:52:00","OPEN_FOR_INTERNAL","2020-10-16 18:52:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:52:57","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 18:52:57","OPEN_FOR_INTERNAL","2020-10-16 18:52:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:53: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","2020-10-16 18:53:16","OPEN_FOR_INTERNAL","2020-10-16 18:53:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:53: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","2020-10-16 18:53:32","OPEN_FOR_INTERNAL","2020-10-16 18:53:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:53: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","2020-10-16 18:53:48","OPEN_FOR_INTERNAL","2020-10-16 18:53:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:53: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","2020-10-16 18:53:59","OPEN_FOR_INTERNAL","2020-10-16 18:53:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:54: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","2020-10-16 18:54:05","OPEN_FOR_INTERNAL","2020-10-16 18:54:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:54:19","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 18:54:19","OPEN_FOR_INTERNAL","2020-10-16 18:54:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18: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","2020-10-16 18:54:27","OPEN_FOR_INTERNAL","2020-10-16 18:54:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:54: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","2020-10-16 18:54:30","OPEN_FOR_INTERNAL","2020-10-16 18:54:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:54: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","2020-10-16 18:54:33","OPEN_FOR_INTERNAL","2020-10-16 18:54:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:54: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","2020-10-16 18:54:37","OPEN_FOR_INTERNAL","2020-10-16 18:54:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:54: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","2020-10-16 18:54:48","OPEN_FOR_INTERNAL","2020-10-16 18:54:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:54:55","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 18:54:55","OPEN_FOR_INTERNAL","2020-10-16 18:54:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:56: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","2020-10-16 18:56:54","OPEN_FOR_INTERNAL","2020-10-16 18:56:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:57: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","2020-10-16 18:57:15","OPEN_FOR_INTERNAL","2020-10-16 18:57:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:58: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","2020-10-16 18:58:11","OPEN_FOR_INTERNAL","2020-10-16 18:58:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:59: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","2020-10-16 18:59:02","OPEN_FOR_INTERNAL","2020-10-16 18:59:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 18:59: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","2020-10-16 18:59:06","OPEN_FOR_INTERNAL","2020-10-16 18:59:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 20:08:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 20:08:39","OPEN_FOR_INTERNAL","2020-10-16 20:08:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 20:46: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","2020-10-16 20:46:06","OPEN_FOR_INTERNAL","2020-10-16 20:46:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 20:46: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","2020-10-16 20:46:06","OPEN_FOR_INTERNAL","2020-10-16 20:46:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 20:46:06","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 20:46: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","2020-10-16 20:46:10","OPEN_FOR_INTERNAL","2020-10-16 20:46:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 20:46: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","2020-10-16 20:46:10","OPEN_FOR_INTERNAL","2020-10-16 20:46:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 20:46:22","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 20:46:22","OPEN_FOR_INTERNAL","2020-10-16 20:46:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 20:46:22","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-10-16 20:46:22","OPEN_FOR_INTERNAL","2020-10-16 20:46:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 20:46:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 20:46: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","2020-10-16 20:46:26","OPEN_FOR_INTERNAL","2020-10-16 20:46:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-16 20:50: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","2020-10-16 20:50:42","OPEN_FOR_INTERNAL","2020-10-16 20:50:42"]},"data_before":[],"data_after":[],"step":1} *****