{"created_at":"2020-11-22 10:17: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-11-22 10:17:45","OPEN_FOR_INTERNAL","2020-11-22 10:17:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:17: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-11-22 10:17:45","OPEN_FOR_INTERNAL","2020-11-22 10:17:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:17:45","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:17: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-11-22 10:17:51","OPEN_FOR_INTERNAL","2020-11-22 10:17:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:17: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-11-22 10:17:52","OPEN_FOR_INTERNAL","2020-11-22 10:17:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:17:56","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 10:17:56","OPEN_FOR_INTERNAL","2020-11-22 10:17:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:17: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-11-22 10:17:59","OPEN_FOR_INTERNAL","2020-11-22 10:17:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:18: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-11-22 10:18:02","OPEN_FOR_INTERNAL","2020-11-22 10:18:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:18: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-11-22 10:18:04","OPEN_FOR_INTERNAL","2020-11-22 10:18:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:18: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-11-22 10:18:11","OPEN_FOR_INTERNAL","2020-11-22 10:18:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:18:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 10:18:15","OPEN_FOR_INTERNAL","2020-11-22 10:18:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:18:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 10:18:15","OPEN_FOR_INTERNAL","2020-11-22 10:18:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:18:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 10:18:15","OPEN_FOR_INTERNAL","2020-11-22 10:18:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:18:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 10:18:15","OPEN_FOR_INTERNAL","2020-11-22 10:18:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:18:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 10:18:15","OPEN_FOR_INTERNAL","2020-11-22 10:18:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:18:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 10:18:15","OPEN_FOR_INTERNAL","2020-11-22 10:18:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:18:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 10:18:15","OPEN_FOR_INTERNAL","2020-11-22 10:18:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:18:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 10:18:15","OPEN_FOR_INTERNAL","2020-11-22 10:18:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:18:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 10:18:15","OPEN_FOR_INTERNAL","2020-11-22 10:18:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:18:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 10:18:15","OPEN_FOR_INTERNAL","2020-11-22 10:18:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:18:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 10:18:15","OPEN_FOR_INTERNAL","2020-11-22 10:18:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:18:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 10:18:15","OPEN_FOR_INTERNAL","2020-11-22 10:18:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:18:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 10:18:15","OPEN_FOR_INTERNAL","2020-11-22 10:18:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:18: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-11-22 10:18:15","OPEN_FOR_INTERNAL","2020-11-22 10:18:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:18: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-11-22 10:18:24","OPEN_FOR_INTERNAL","2020-11-22 10:18:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:18:25","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 10:18:25","OPEN_FOR_INTERNAL","2020-11-22 10:18:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:18: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-11-22 10:18:26","OPEN_FOR_INTERNAL","2020-11-22 10:18:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:18: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-11-22 10:18:27","OPEN_FOR_INTERNAL","2020-11-22 10:18:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:18: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-11-22 10:18:29","OPEN_FOR_INTERNAL","2020-11-22 10:18:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:18: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-11-22 10:18:30","OPEN_FOR_INTERNAL","2020-11-22 10:18:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:19: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-11-22 10:19:12","OPEN_FOR_INTERNAL","2020-11-22 10:19:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:19: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-11-22 10:19:12","OPEN_FOR_INTERNAL","2020-11-22 10:19:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:19:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 10:19:13","OPEN_FOR_INTERNAL","2020-11-22 10:19:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:19:18","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 10:19:18","OPEN_FOR_INTERNAL","2020-11-22 10:19:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:19:18","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":616,"customer_code":"C170616","identity_type":"PERSONAL","identity_id":"Z103280(2)","title":"Ms","lastname":"Yiu","firstname":"Kit Ling","companyname":"","email":"jessieyiu@hotmail.com","tel":"96981481","address":"Room 3611, Tung On House, Lei Tung Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-11-18","renew_room_key":"054,29997","renew_remark":"1 months contract. Storage rental $598 paid by bank transfer on 9 Oct 2020. Storage deposit transferred from agreement A14-CT208964 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT209183, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"686","room_code":"N03","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-11-18","rent_from":"2020-11-18","rent_to":"2020-12-17","delivery_service":"0","remark":"1 months contract. Storage rental $598 paid by bank transfer on 21 NOV 2020. Storage deposit transferred from agreement A14-CT209183 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,29997","order_product":[],"pass":true}},"first_order_id":"4846","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>
N03 <\/td>\r\n\t\t\t\t\t	4X3X4 <\/td>\r\n\t\t\t\t\t	$598.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:19:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",616,"NEW","A14-CT209645",598,598,0,0,"1","1",598,598,598,"2020-11-22 10:19:19","0",null,null,null,"2020-11-18","2020-12-17","1 months contract. Storage rental $598 paid by bank transfer on 21 NOV 2020. Storage deposit transferred from agreement A14-CT209183 to this agreement. \r\n","2020-11-18","12",0,null,0,"0.00","2","2020-11-22 10:19:18","2","2020-11-22 10:19:18","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,29997","C170616","PERSONAL","Ms","p8\/VerPta7kqG1jT7vONTw==","izJVo3RcQVJ02PBMypGKnQ==","","ENXImS4KdDZt3vDBAvbUseTFoyYV41Dwmv5vVbvIdZhZx8O1O37lzRS04mcx6FS\/yI73wDF8ltcsMz9AVNZttg==","a4NDOVya9cf76uWohlEcuA==","6FqTwPEFt8u2TYXg83c9argn0qm0Ubm3\/Tw0rg\/hkrw=","9XfgXEI68THR3GL9uXD8Pg==",null,1,"4846"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:19:19","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":["9645","686","598.0","598.00","2","2020-11-22 10:19:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:19:19","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-11-18","2020-12-17","686"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-11-22 10:19:19","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":["9645",616,"SETTLED","A14-I209974","2020-11-22 10:19:18","2020-11-18","2","2020-11-22 10:19:18","2","2020-11-22 10:19:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:19:19","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":["9974","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-11-22 10:19:18","2","2020-11-22 10:19:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:19:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"9974"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-11-22 10:19:19","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":[616,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P209613","2020-11-22 10:19:18",598,"2","2020-11-22 10:19:18","2","2020-11-22 10:19:18","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:19:19","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":["9613","DEPOSIT",null,"PAID","2020-11-22 10:19:18",0,"2","2020-11-22 10:19:18","2","2020-11-22 10:19:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:19:19","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":["9613","INVOICE","9974","PAID","2020-11-22 10:19:18",598,"2","2020-11-22 10:19:18","2","2020-11-22 10:19:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:19: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-11-22 10:19:19","OPEN_FOR_INTERNAL","2020-11-22 10:19:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:19: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-11-22 10:19:19","OPEN_FOR_INTERNAL","2020-11-22 10:19:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:19:52","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 10:19:52","OPEN_FOR_INTERNAL","2020-11-22 10:19:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:19:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:18","OPEN_FOR_INTERNAL","2020-11-22 10:20:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:18","OPEN_FOR_INTERNAL","2020-11-22 10:20:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:21","OPEN_FOR_INTERNAL","2020-11-22 10:20:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:24","OPEN_FOR_INTERNAL","2020-11-22 10:20:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:26","OPEN_FOR_INTERNAL","2020-11-22 10:20:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:29","OPEN_FOR_INTERNAL","2020-11-22 10:20:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:31","OPEN_FOR_INTERNAL","2020-11-22 10:20:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:37","OPEN_FOR_INTERNAL","2020-11-22 10:20:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:39","OPEN_FOR_INTERNAL","2020-11-22 10:20:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:40","OPEN_FOR_INTERNAL","2020-11-22 10:20:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:40","OPEN_FOR_INTERNAL","2020-11-22 10:20:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:40","OPEN_FOR_INTERNAL","2020-11-22 10:20:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:40","OPEN_FOR_INTERNAL","2020-11-22 10:20:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:40","OPEN_FOR_INTERNAL","2020-11-22 10:20:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:40","OPEN_FOR_INTERNAL","2020-11-22 10:20:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:40","OPEN_FOR_INTERNAL","2020-11-22 10:20:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:40","OPEN_FOR_INTERNAL","2020-11-22 10:20:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:40","OPEN_FOR_INTERNAL","2020-11-22 10:20:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:40","OPEN_FOR_INTERNAL","2020-11-22 10:20:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:40","OPEN_FOR_INTERNAL","2020-11-22 10:20:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:40","OPEN_FOR_INTERNAL","2020-11-22 10:20:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:49","OPEN_FOR_INTERNAL","2020-11-22 10:20:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:50","OPEN_FOR_INTERNAL","2020-11-22 10:20:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:51","OPEN_FOR_INTERNAL","2020-11-22 10:20:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:52","OPEN_FOR_INTERNAL","2020-11-22 10:20:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:52","OPEN_FOR_INTERNAL","2020-11-22 10:20:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20:55","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 10:20:55","OPEN_FOR_INTERNAL","2020-11-22 10:20:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:20: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-11-22 10:20:56","OPEN_FOR_INTERNAL","2020-11-22 10:20:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:21: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-11-22 10:21:37","OPEN_FOR_INTERNAL","2020-11-22 10:21:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:21: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-11-22 10:21:37","OPEN_FOR_INTERNAL","2020-11-22 10:21:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:21: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-11-22 10:21:37","OPEN_FOR_INTERNAL","2020-11-22 10:21:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:21: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-11-22 10:21:44","OPEN_FOR_INTERNAL","2020-11-22 10:21:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:21:44","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1564,"customer_code":"C201564","identity_type":"PERSONAL","identity_id":"D231595(6)","title":"Ms","lastname":"LIU","firstname":"Pui Yee","companyname":"","email":"tammgliu888@yahoo.com","tel":"94016895","address":"Flat 914, Wah Kin House, Wah Fu Est, Pok Fu Lam, South District.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1286.0","renew_rent_month":"1","renew_warehousing_date":"2020-11-20","renew_room_key":"190,26664","renew_remark":"1 month contract. Storage rental paid by bank transfer on Oct 19, 2020. Storage deposit $2572 transferred from agreement A12-CT208987, to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT209291, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"61","room_code":"B09","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1286,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1286,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-11-20","rent_from":"2020-11-20","rent_to":"2020-12-19","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on NOV 21, 2020. Storage deposit $2572 transferred from agreement A12-CT209291, to this agreement.\r\n\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1286,"final_order_total":1286,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190,26664","order_product":[],"pass":true}},"first_order_id":"7668","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> B09 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1286.00","deposit":"0.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:21:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",1564,"NEW","A12-CT209646",1528,1286,0,0,"1","1",1286,1286,1286,"2020-11-22 10:21:44","0",null,null,null,"2020-11-20","2020-12-19","1 month contract. Storage rental paid by bank transfer on NOV 21, 2020. Storage deposit $2572 transferred from agreement A12-CT209291, to this agreement.\r\n\r\n","2020-11-20","20",0,null,0,"0.00","2","2020-11-22 10:21:44","2","2020-11-22 10:21:44","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190,26664","C201564","PERSONAL","Ms","pW1T\/bCpncDmYxmrSj5N3Q==","wtXe3F1rqyx\/NkkNOLs7pg==","","BgslglUH0r+MGDNMVR4ODLjLIekcdNYutpHNMKcJTdrat5CTYwp+Fhe5w6yhrvR0cHFxKswLh535kpcAoSEfSvDIf7aqVNHnYcIjpS7j\/kY=","5MBoUUrP0SuSZ8JjZjyPvw==","VpKfghnYmCAk6qGCqxoxbQJSaV0E+kVERKvj9qrtcLU=","5e+N+acflaaaW7mYFvh\/JQ==",null,1,"7668"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:21:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["9646","61","1528.0","1528.00","2","2020-11-22 10:21:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:21:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-11-20","2020-12-19","61"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-11-22 10:21:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["9646",1564,"SETTLED","A12-I209975","2020-11-22 10:21:44","2020-11-20","2","2020-11-22 10:21:44","2","2020-11-22 10:21:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:21:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["9975","RENT","\u9810\u7e73\u79df\u91d1",1,1286,"MO","1",1286,"2","2020-11-22 10:21:44","2","2020-11-22 10:21:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:21:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1286,0,"9975"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-11-22 10:21:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1564,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P209614","2020-11-22 10:21:44",1286,"2","2020-11-22 10:21:44","2","2020-11-22 10:21:44","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:21:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["9614","DEPOSIT",null,"PAID","2020-11-22 10:21:44",0,"2","2020-11-22 10:21:44","2","2020-11-22 10:21:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:21:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["9614","INVOICE","9975","PAID","2020-11-22 10:21:44",1286,"2","2020-11-22 10:21:44","2","2020-11-22 10:21:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:21: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-11-22 10:21:46","OPEN_FOR_INTERNAL","2020-11-22 10:21:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:21: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-11-22 10:21:48","OPEN_FOR_INTERNAL","2020-11-22 10:21:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:39:55","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 10:39:55","OPEN_FOR_INTERNAL","2020-11-22 10:39:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:39:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:40:02","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 10:40:02","OPEN_FOR_INTERNAL","2020-11-22 10:40:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:40:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:42: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-11-22 10:42:35","OPEN_FOR_INTERNAL","2020-11-22 10:42:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:42:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 10:42:38","OPEN_FOR_INTERNAL","2020-11-22 10:42:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:42: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-11-22 10:42:44","OPEN_FOR_INTERNAL","2020-11-22 10:42:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:42: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-11-22 10:42:47","OPEN_FOR_INTERNAL","2020-11-22 10:42:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:42: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-11-22 10:42:51","OPEN_FOR_INTERNAL","2020-11-22 10:42:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:42: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-11-22 10:42:53","OPEN_FOR_INTERNAL","2020-11-22 10:42:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:42: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-11-22 10:42:53","OPEN_FOR_INTERNAL","2020-11-22 10:42:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 10:43: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-11-22 10:43:02","OPEN_FOR_INTERNAL","2020-11-22 10:43:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:05: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-11-22 11:05:20","OPEN_FOR_INTERNAL","2020-11-22 11:05:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:05:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:05:25","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 11:05:25","OPEN_FOR_INTERNAL","2020-11-22 11:05:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:05:25","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 11:05:25","OPEN_FOR_INTERNAL","2020-11-22 11:05:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:05: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-11-22 11:05:33","OPEN_FOR_INTERNAL","2020-11-22 11:05:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:05: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-11-22 11:05:34","OPEN_FOR_INTERNAL","2020-11-22 11:05:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11: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-11-22 11:05:36","OPEN_FOR_INTERNAL","2020-11-22 11:05:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:05:41","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 11:05:41","OPEN_FOR_INTERNAL","2020-11-22 11:05:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11: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-11-22 11:05:42","OPEN_FOR_INTERNAL","2020-11-22 11:05:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:05: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-11-22 11:05:44","OPEN_FOR_INTERNAL","2020-11-22 11:05:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:05: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-11-22 11:05:45","OPEN_FOR_INTERNAL","2020-11-22 11:05:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:05: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-11-22 11:05:52","OPEN_FOR_INTERNAL","2020-11-22 11:05:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06: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-11-22 11:06:08","OPEN_FOR_INTERNAL","2020-11-22 11:06:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06: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-11-22 11:06:08","OPEN_FOR_INTERNAL","2020-11-22 11:06:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06: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-11-22 11:06:09","OPEN_FOR_INTERNAL","2020-11-22 11:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06: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-11-22 11:06:09","OPEN_FOR_INTERNAL","2020-11-22 11:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06: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-11-22 11:06:09","OPEN_FOR_INTERNAL","2020-11-22 11:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06: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-11-22 11:06:09","OPEN_FOR_INTERNAL","2020-11-22 11:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06: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-11-22 11:06:09","OPEN_FOR_INTERNAL","2020-11-22 11:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06: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-11-22 11:06:09","OPEN_FOR_INTERNAL","2020-11-22 11:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06: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-11-22 11:06:09","OPEN_FOR_INTERNAL","2020-11-22 11:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06: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-11-22 11:06:09","OPEN_FOR_INTERNAL","2020-11-22 11:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06: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-11-22 11:06:09","OPEN_FOR_INTERNAL","2020-11-22 11:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06: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-11-22 11:06:09","OPEN_FOR_INTERNAL","2020-11-22 11:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06: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-11-22 11:06:09","OPEN_FOR_INTERNAL","2020-11-22 11:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06: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-11-22 11:06:09","OPEN_FOR_INTERNAL","2020-11-22 11:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06: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-11-22 11:06:09","OPEN_FOR_INTERNAL","2020-11-22 11:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06: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-11-22 11:06:45","OPEN_FOR_INTERNAL","2020-11-22 11:06:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06: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-11-22 11:06:45","OPEN_FOR_INTERNAL","2020-11-22 11:06:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06: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-11-22 11:06:45","OPEN_FOR_INTERNAL","2020-11-22 11:06:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06: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-11-22 11:06:45","OPEN_FOR_INTERNAL","2020-11-22 11:06:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06: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-11-22 11:06:46","OPEN_FOR_INTERNAL","2020-11-22 11:06:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06: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-11-22 11:06:46","OPEN_FOR_INTERNAL","2020-11-22 11:06:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06: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-11-22 11:06:46","OPEN_FOR_INTERNAL","2020-11-22 11:06:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06:49","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 11:06:49","OPEN_FOR_INTERNAL","2020-11-22 11:06:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06: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-11-22 11:06:50","OPEN_FOR_INTERNAL","2020-11-22 11:06:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06: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-11-22 11:06:50","OPEN_FOR_INTERNAL","2020-11-22 11:06:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06:51","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 11:06:51","OPEN_FOR_INTERNAL","2020-11-22 11:06:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:06: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-11-22 11:06:54","OPEN_FOR_INTERNAL","2020-11-22 11:06:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:08: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-11-22 11:08:23","OPEN_FOR_INTERNAL","2020-11-22 11:08:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:08: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-11-22 11:08:23","OPEN_FOR_INTERNAL","2020-11-22 11:08:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:08: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-11-22 11:08:27","OPEN_FOR_INTERNAL","2020-11-22 11:08:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:08: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-11-22 11:08:27","OPEN_FOR_INTERNAL","2020-11-22 11:08:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:08: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-11-22 11:08:27","OPEN_FOR_INTERNAL","2020-11-22 11:08:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:08:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 11:08:38","OPEN_FOR_INTERNAL","2020-11-22 11:08:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:08:38","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1714,"customer_code":"C201714","identity_type":"PERSONAL","identity_id":"D700056(2)","title":"Ms","lastname":"LEUNG","firstname":"Yuk Mui Gloria","companyname":"","email":null,"tel":"90274288","address":"Shop 18, 1\/F, AC2 Aberdeen, Hong Kong ","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2888.0","renew_rent_month":"3","renew_warehousing_date":"2020-11-22","renew_room_key":"191,05273","renew_remark":"3 months contract. The first 3 months will be 50% off. Storage rental and deposit paid by cheque on Aug 15, 2020. Smart card given on the same day. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT208694, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $5776.0","renew_master_room_id":"58","order_discount":[],"order_room":[{"room_id":"425","room_code":"J07","retail_price":"2888.0","discounted_price":"2888.00","location_id":"2"}],"roughly_size":"40","total_retail_price":2888,"total_discounted_price":2888,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2888,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-11-22","rent_from":"2020-11-22","rent_to":"2020-12-21","delivery_service":"0","remark":"1 months contract.Storage rental and deposit paid by bank transfer on NOV 22, 2020. Storage deposit transferred from agreement A14-CT208694 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2888,"final_order_total":2888,"location_id":"2","branch_id":"1","company_id":"1","room_key":"191,05273","order_product":[],"pass":true}},"first_order_id":8694,"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> J07 <\/td>\r\n\t\t\t\t\t 5X8X8 <\/td>\r\n\t\t\t\t\t $2888.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"40","total_discounted_price":"2888.00","deposit":"0.00","total_retail_price":"2888.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:08:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",1714,"NEW","A14-CT209647",2888,2888,0,0,"1","1",2888,2888,2888,"2020-11-22 11:08:38","0",null,null,null,"2020-11-22","2020-12-21","1 months contract.Storage rental and deposit paid by bank transfer on NOV 22, 2020. Storage deposit transferred from agreement A14-CT208694 to this agreement.\r\n","2020-11-22","40",0,null,0,"0.00","2","2020-11-22 11:08:38","2","2020-11-22 11:08:38","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"191,05273","C201714","PERSONAL","Ms","7LNF5\/yqWr1NhniWaJIxKA==","yXKc2lCF323ApRADrjNaSg==","","aX8xi+HlpLRmY4mez87PH2nOTIISJVgqEhwQbE8Y\/Edjz7YgogeCvAYwrN0iE5C4","ONSeAfbRppxFkmb6MUaVkg==",null,"2suIkuTmw\/VjE5ZvSjIzAw==",null,1,8694]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:08:38","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":["9647","425","2888.0","2888.00","2","2020-11-22 11:08:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:08:38","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-11-22","2020-12-21","425"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-11-22 11:08:38","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":["9647",1714,"SETTLED","A14-I209976","2020-11-22 11:08:38","2020-11-22","2","2020-11-22 11:08:38","2","2020-11-22 11:08:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:08:38","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":["9976","RENT","\u9810\u7e73\u79df\u91d1",1,2888,"MO","1",2888,"2","2020-11-22 11:08:38","2","2020-11-22 11:08:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:08:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2888,0,"9976"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-11-22 11:08:38","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":[1714,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P209615","2020-11-22 11:08:38",2888,"2","2020-11-22 11:08:38","2","2020-11-22 11:08:38","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:08:38","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":["9615","DEPOSIT",null,"PAID","2020-11-22 11:08:38",0,"2","2020-11-22 11:08:38","2","2020-11-22 11:08:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:08:38","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":["9615","INVOICE","9976","PAID","2020-11-22 11:08:38",2888,"2","2020-11-22 11:08:38","2","2020-11-22 11:08:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11: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-11-22 11:08:39","OPEN_FOR_INTERNAL","2020-11-22 11:08:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:08: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-11-22 11:08:43","OPEN_FOR_INTERNAL","2020-11-22 11:08:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:34: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-11-22 11:34:05","OPEN_FOR_INTERNAL","2020-11-22 11:34:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:34:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:34: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-11-22 11:34:13","OPEN_FOR_INTERNAL","2020-11-22 11:34:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:34: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-11-22 11:34:14","OPEN_FOR_INTERNAL","2020-11-22 11:34:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:35: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-11-22 11:35:04","OPEN_FOR_INTERNAL","2020-11-22 11:35:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:35:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:35: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-11-22 11:35:08","OPEN_FOR_INTERNAL","2020-11-22 11:35:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:35: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-11-22 11:35:09","OPEN_FOR_INTERNAL","2020-11-22 11:35:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:35: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-11-22 11:35:12","OPEN_FOR_INTERNAL","2020-11-22 11:35:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:35: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-11-22 11:35:13","OPEN_FOR_INTERNAL","2020-11-22 11:35:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11: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-11-22 11:35:14","OPEN_FOR_INTERNAL","2020-11-22 11:35:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:35: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-11-22 11:35:16","OPEN_FOR_INTERNAL","2020-11-22 11:35:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:35:18","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 11:35:18","OPEN_FOR_INTERNAL","2020-11-22 11:35:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:35: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-11-22 11:35:33","OPEN_FOR_INTERNAL","2020-11-22 11:35:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:43: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-11-22 11:43:52","OPEN_FOR_INTERNAL","2020-11-22 11:43:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:43:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11: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-11-22 11:43:55","OPEN_FOR_INTERNAL","2020-11-22 11:43:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:44: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-11-22 11:44:20","OPEN_FOR_INTERNAL","2020-11-22 11:44:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:44: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-11-22 11:44:32","OPEN_FOR_INTERNAL","2020-11-22 11:44:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:45: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-11-22 11:45:35","OPEN_FOR_INTERNAL","2020-11-22 11:45:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11: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-11-22 11:46:22","OPEN_FOR_INTERNAL","2020-11-22 11:46:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 11:46:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 11:46:28","OPEN_FOR_INTERNAL","2020-11-22 11:46:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:03: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-11-22 12:03:02","OPEN_FOR_INTERNAL","2020-11-22 12:03:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:03:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:03: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-11-22 12:03:05","OPEN_FOR_INTERNAL","2020-11-22 12:03:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:03: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-11-22 12:03:14","OPEN_FOR_INTERNAL","2020-11-22 12:03:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:04: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-11-22 12:04:57","OPEN_FOR_INTERNAL","2020-11-22 12:04:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12: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-11-22 12:05:16","OPEN_FOR_INTERNAL","2020-11-22 12:05:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:05: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-11-22 12:05:19","OPEN_FOR_INTERNAL","2020-11-22 12:05:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:05: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-11-22 12:05:38","OPEN_FOR_INTERNAL","2020-11-22 12:05:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12: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-11-22 12:05:42","OPEN_FOR_INTERNAL","2020-11-22 12:05:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:06: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-11-22 12:06:29","OPEN_FOR_INTERNAL","2020-11-22 12:06:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:08: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-11-22 12:08:18","OPEN_FOR_INTERNAL","2020-11-22 12:08:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:14: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-11-22 12:14:22","OPEN_FOR_INTERNAL","2020-11-22 12:14:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:15: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-11-22 12:15:42","OPEN_FOR_INTERNAL","2020-11-22 12:15:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:18: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-11-22 12:18:03","OPEN_FOR_INTERNAL","2020-11-22 12:18:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:19: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-11-22 12:19:36","OPEN_FOR_INTERNAL","2020-11-22 12:19:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:20: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-11-22 12:20:44","OPEN_FOR_INTERNAL","2020-11-22 12:20:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:21: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-11-22 12:21:36","OPEN_FOR_INTERNAL","2020-11-22 12:21:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:22: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-11-22 12:22:42","OPEN_FOR_INTERNAL","2020-11-22 12:22:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:22:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:23: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-11-22 12:23:03","OPEN_FOR_INTERNAL","2020-11-22 12:23:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:23:04","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 12:23:04","OPEN_FOR_INTERNAL","2020-11-22 12:23:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:23:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:23:04","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 12:23:04","OPEN_FOR_INTERNAL","2020-11-22 12:23:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:23:04","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 12:23:04","OPEN_FOR_INTERNAL","2020-11-22 12:23:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:23: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-11-22 12:23:09","OPEN_FOR_INTERNAL","2020-11-22 12:23:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:23: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-11-22 12:23:10","OPEN_FOR_INTERNAL","2020-11-22 12:23:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:25: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-11-22 12:25:03","OPEN_FOR_INTERNAL","2020-11-22 12:25:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:29: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-11-22 12:29:29","OPEN_FOR_INTERNAL","2020-11-22 12:29:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:32: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-11-22 12:32:52","OPEN_FOR_INTERNAL","2020-11-22 12:32:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:32: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-11-22 12:32:52","OPEN_FOR_INTERNAL","2020-11-22 12:32:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:32:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:33: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-11-22 12:33:12","OPEN_FOR_INTERNAL","2020-11-22 12:33:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:35:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 12:35:28","OPEN_FOR_INTERNAL","2020-11-22 12:35:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:37: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-11-22 12:37:04","OPEN_FOR_INTERNAL","2020-11-22 12:37:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:37: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-11-22 12:37:04","OPEN_FOR_INTERNAL","2020-11-22 12:37:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:37:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:37: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-11-22 12:37:08","OPEN_FOR_INTERNAL","2020-11-22 12:37:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:37: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-11-22 12:37:08","OPEN_FOR_INTERNAL","2020-11-22 12:37:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:37: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-11-22 12:37:12","OPEN_FOR_INTERNAL","2020-11-22 12:37:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:37: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-11-22 12:37:13","OPEN_FOR_INTERNAL","2020-11-22 12:37:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:40:01","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 12:40:01","OPEN_FOR_INTERNAL","2020-11-22 12:40:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:40:01","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:40: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-11-22 12:40:08","OPEN_FOR_INTERNAL","2020-11-22 12:40:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:40: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-11-22 12:40:09","OPEN_FOR_INTERNAL","2020-11-22 12:40:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:40: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-11-22 12:40:40","OPEN_FOR_INTERNAL","2020-11-22 12:40:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:40: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-11-22 12:40:45","OPEN_FOR_INTERNAL","2020-11-22 12:40:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:40: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-11-22 12:40:48","OPEN_FOR_INTERNAL","2020-11-22 12:40:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:40: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-11-22 12:40:51","OPEN_FOR_INTERNAL","2020-11-22 12:40:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:46: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-11-22 12:46:31","OPEN_FOR_INTERNAL","2020-11-22 12:46:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:46: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-11-22 12:46:37","OPEN_FOR_INTERNAL","2020-11-22 12:46:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:50: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-11-22 12:50:38","OPEN_FOR_INTERNAL","2020-11-22 12:50:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:52: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-11-22 12:52:31","OPEN_FOR_INTERNAL","2020-11-22 12:52:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:52: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-11-22 12:52:33","OPEN_FOR_INTERNAL","2020-11-22 12:52:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:52:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:52: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-11-22 12:52:47","OPEN_FOR_INTERNAL","2020-11-22 12:52:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:52: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-11-22 12:52:53","OPEN_FOR_INTERNAL","2020-11-22 12:52:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:52:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:52:55","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 12:52:55","OPEN_FOR_INTERNAL","2020-11-22 12:52:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:52:55","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 12:52:55","OPEN_FOR_INTERNAL","2020-11-22 12:52:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:53: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-11-22 12:53:00","OPEN_FOR_INTERNAL","2020-11-22 12:53:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:53: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-11-22 12:53:02","OPEN_FOR_INTERNAL","2020-11-22 12:53:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:53: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-11-22 12:53:03","OPEN_FOR_INTERNAL","2020-11-22 12:53:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:53: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-11-22 12:53:06","OPEN_FOR_INTERNAL","2020-11-22 12:53:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:53: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-11-22 12:53:08","OPEN_FOR_INTERNAL","2020-11-22 12:53:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:53: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-11-22 12:53:08","OPEN_FOR_INTERNAL","2020-11-22 12:53:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:53: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-11-22 12:53:10","OPEN_FOR_INTERNAL","2020-11-22 12:53:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:53: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-11-22 12:53:14","OPEN_FOR_INTERNAL","2020-11-22 12:53:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:54: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-11-22 12:54:17","OPEN_FOR_INTERNAL","2020-11-22 12:54:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:54: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-11-22 12:54:40","OPEN_FOR_INTERNAL","2020-11-22 12:54:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:55: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-11-22 12:55:09","OPEN_FOR_INTERNAL","2020-11-22 12:55:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 12:55: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-11-22 12:55:22","OPEN_FOR_INTERNAL","2020-11-22 12:55:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:03: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-11-22 13:03:27","OPEN_FOR_INTERNAL","2020-11-22 13:03:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:04: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-11-22 13:04:54","OPEN_FOR_INTERNAL","2020-11-22 13:04:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:10: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-11-22 13:10:20","OPEN_FOR_INTERNAL","2020-11-22 13:10:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:10: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-11-22 13:10:20","OPEN_FOR_INTERNAL","2020-11-22 13:10:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:10:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:10: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-11-22 13:10:31","OPEN_FOR_INTERNAL","2020-11-22 13:10:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:10: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-11-22 13:10:57","OPEN_FOR_INTERNAL","2020-11-22 13:10:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:11: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-11-22 13:11:46","OPEN_FOR_INTERNAL","2020-11-22 13:11:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:18: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-11-22 13:18:02","OPEN_FOR_INTERNAL","2020-11-22 13:18:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:19: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-11-22 13:19:17","OPEN_FOR_INTERNAL","2020-11-22 13:19:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:19:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:19: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-11-22 13:19:19","OPEN_FOR_INTERNAL","2020-11-22 13:19:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:19: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-11-22 13:19:19","OPEN_FOR_INTERNAL","2020-11-22 13:19:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:19:24","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 13:19:24","OPEN_FOR_INTERNAL","2020-11-22 13:19:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:19:25","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 13:19:25","OPEN_FOR_INTERNAL","2020-11-22 13:19:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:19:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 13:19:28","OPEN_FOR_INTERNAL","2020-11-22 13:19:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:19: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-11-22 13:19:30","OPEN_FOR_INTERNAL","2020-11-22 13:19:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:19:32","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 13:19:32","OPEN_FOR_INTERNAL","2020-11-22 13:19:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:20: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-11-22 13:20:13","OPEN_FOR_INTERNAL","2020-11-22 13:20:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:21: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-11-22 13:21:01","OPEN_FOR_INTERNAL","2020-11-22 13:21:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:21: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-11-22 13:21:53","OPEN_FOR_INTERNAL","2020-11-22 13:21:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:26: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-11-22 13:26:47","OPEN_FOR_INTERNAL","2020-11-22 13:26:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:26: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-11-22 13:26:49","OPEN_FOR_INTERNAL","2020-11-22 13:26:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:27: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-11-22 13:27:15","OPEN_FOR_INTERNAL","2020-11-22 13:27:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:27: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-11-22 13:27:40","OPEN_FOR_INTERNAL","2020-11-22 13:27:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:28: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-11-22 13:28:02","OPEN_FOR_INTERNAL","2020-11-22 13:28:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:30: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-11-22 13:30:36","OPEN_FOR_INTERNAL","2020-11-22 13:30:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:52: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-11-22 13:52:27","OPEN_FOR_INTERNAL","2020-11-22 13:52:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:53: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-11-22 13:53:40","OPEN_FOR_INTERNAL","2020-11-22 13:53:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:54:06","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 13:54:06","OPEN_FOR_INTERNAL","2020-11-22 13:54:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:54:18","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 13:54:18","OPEN_FOR_INTERNAL","2020-11-22 13:54:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:54: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-11-22 13:54:52","OPEN_FOR_INTERNAL","2020-11-22 13:54:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:55:01","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 13:55:01","OPEN_FOR_INTERNAL","2020-11-22 13:55:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:55: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-11-22 13:55:03","OPEN_FOR_INTERNAL","2020-11-22 13:55:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:55: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-11-22 13:55:08","OPEN_FOR_INTERNAL","2020-11-22 13:55:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:55: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-11-22 13:55:12","OPEN_FOR_INTERNAL","2020-11-22 13:55:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:55: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-11-22 13:55:14","OPEN_FOR_INTERNAL","2020-11-22 13:55:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:55: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-11-22 13:55:18","OPEN_FOR_INTERNAL","2020-11-22 13:55:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:55: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-11-22 13:55:20","OPEN_FOR_INTERNAL","2020-11-22 13:55:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:58: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-11-22 13:58:12","OPEN_FOR_INTERNAL","2020-11-22 13:58:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:59: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-11-22 13:59:08","OPEN_FOR_INTERNAL","2020-11-22 13:59:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 13:59: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-11-22 13:59:15","OPEN_FOR_INTERNAL","2020-11-22 13:59:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:00: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-11-22 14:00:10","OPEN_FOR_INTERNAL","2020-11-22 14:00:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:00:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:00: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-11-22 14:00:13","OPEN_FOR_INTERNAL","2020-11-22 14:00:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:00: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-11-22 14:00:13","OPEN_FOR_INTERNAL","2020-11-22 14:00:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:00: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-11-22 14:00:17","OPEN_FOR_INTERNAL","2020-11-22 14:00:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:00: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-11-22 14:00:18","OPEN_FOR_INTERNAL","2020-11-22 14:00:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:00: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-11-22 14:00:20","OPEN_FOR_INTERNAL","2020-11-22 14:00:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:00:25","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 14:00:25","OPEN_FOR_INTERNAL","2020-11-22 14:00:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:00:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 14:00:28","OPEN_FOR_INTERNAL","2020-11-22 14:00:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:04: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-11-22 14:04:23","OPEN_FOR_INTERNAL","2020-11-22 14:04:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:06: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-11-22 14:06:59","OPEN_FOR_INTERNAL","2020-11-22 14:06:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:07:26","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 14:07:26","OPEN_FOR_INTERNAL","2020-11-22 14:07:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:07: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-11-22 14:07:37","OPEN_FOR_INTERNAL","2020-11-22 14:07:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:13: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-11-22 14:13:30","OPEN_FOR_INTERNAL","2020-11-22 14:13:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:13:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:13: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-11-22 14:13:37","OPEN_FOR_INTERNAL","2020-11-22 14:13:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:13: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-11-22 14:13:38","OPEN_FOR_INTERNAL","2020-11-22 14:13:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:13: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-11-22 14:13:54","OPEN_FOR_INTERNAL","2020-11-22 14:13:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:13:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:14: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-11-22 14:14:24","OPEN_FOR_INTERNAL","2020-11-22 14:14:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:14: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-11-22 14:14:51","OPEN_FOR_INTERNAL","2020-11-22 14:14:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:16: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-11-22 14:16:59","OPEN_FOR_INTERNAL","2020-11-22 14:16:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:17: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-11-22 14:17:00","OPEN_FOR_INTERNAL","2020-11-22 14:17:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:17: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-11-22 14:17:03","OPEN_FOR_INTERNAL","2020-11-22 14:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:17: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-11-22 14:17:05","OPEN_FOR_INTERNAL","2020-11-22 14:17:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:17:11","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 14:17:11","OPEN_FOR_INTERNAL","2020-11-22 14:17:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:17: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-11-22 14:17:16","OPEN_FOR_INTERNAL","2020-11-22 14:17:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:17: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-11-22 14:17:19","OPEN_FOR_INTERNAL","2020-11-22 14:17:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:17: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-11-22 14:17:21","OPEN_FOR_INTERNAL","2020-11-22 14:17:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:17: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-11-22 14:17:23","OPEN_FOR_INTERNAL","2020-11-22 14:17:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:17:25","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 14:17:25","OPEN_FOR_INTERNAL","2020-11-22 14:17:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:17: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-11-22 14:17:32","OPEN_FOR_INTERNAL","2020-11-22 14:17:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:18: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-11-22 14:18:21","OPEN_FOR_INTERNAL","2020-11-22 14:18:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:18:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:18: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-11-22 14:18:24","OPEN_FOR_INTERNAL","2020-11-22 14:18:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:18: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-11-22 14:18:35","OPEN_FOR_INTERNAL","2020-11-22 14:18:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:19: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-11-22 14:19:56","OPEN_FOR_INTERNAL","2020-11-22 14:19:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:20: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-11-22 14:20:11","OPEN_FOR_INTERNAL","2020-11-22 14:20:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:20: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-11-22 14:20:51","OPEN_FOR_INTERNAL","2020-11-22 14:20:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:21: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-11-22 14:21:58","OPEN_FOR_INTERNAL","2020-11-22 14:21:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:22: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-11-22 14:22:49","OPEN_FOR_INTERNAL","2020-11-22 14:22:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:26: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-11-22 14:26:02","OPEN_FOR_INTERNAL","2020-11-22 14:26:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:28: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-11-22 14:28:21","OPEN_FOR_INTERNAL","2020-11-22 14:28:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 14:28: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-11-22 14:28:44","OPEN_FOR_INTERNAL","2020-11-22 14:28:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:17: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-11-22 15:17:27","OPEN_FOR_INTERNAL","2020-11-22 15:17:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:17: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-11-22 15:17:34","OPEN_FOR_INTERNAL","2020-11-22 15:17:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:17: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-11-22 15:17:44","OPEN_FOR_INTERNAL","2020-11-22 15:17:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:17: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-11-22 15:17:46","OPEN_FOR_INTERNAL","2020-11-22 15:17:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:17: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-11-22 15:17:49","OPEN_FOR_INTERNAL","2020-11-22 15:17:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:18: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-11-22 15:18:16","OPEN_FOR_INTERNAL","2020-11-22 15:18:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:18: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-11-22 15:18:21","OPEN_FOR_INTERNAL","2020-11-22 15:18:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:18: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-11-22 15:18:40","OPEN_FOR_INTERNAL","2020-11-22 15:18:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:18:47","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 15:18:47","OPEN_FOR_INTERNAL","2020-11-22 15:18:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:18:47","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 15:18:47","OPEN_FOR_INTERNAL","2020-11-22 15:18:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:18: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-11-22 15:18:50","OPEN_FOR_INTERNAL","2020-11-22 15:18:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:18:51","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 15:18:51","OPEN_FOR_INTERNAL","2020-11-22 15:18:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:19:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 15:19:08","OPEN_FOR_INTERNAL","2020-11-22 15:19:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:20: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-11-22 15:20:13","OPEN_FOR_INTERNAL","2020-11-22 15:20:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:20: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-11-22 15:20:42","OPEN_FOR_INTERNAL","2020-11-22 15:20:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:21: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-11-22 15:21:09","OPEN_FOR_INTERNAL","2020-11-22 15:21:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:21: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-11-22 15:21:54","OPEN_FOR_INTERNAL","2020-11-22 15:21:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:22: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-11-22 15:22:38","OPEN_FOR_INTERNAL","2020-11-22 15:22:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:23: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-11-22 15:23:16","OPEN_FOR_INTERNAL","2020-11-22 15:23:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:25: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-11-22 15:25:45","OPEN_FOR_INTERNAL","2020-11-22 15:25:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:27: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-11-22 15:27:06","OPEN_FOR_INTERNAL","2020-11-22 15:27:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:30:41","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 15:30:41","OPEN_FOR_INTERNAL","2020-11-22 15:30:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:30:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:30: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-11-22 15:30:46","OPEN_FOR_INTERNAL","2020-11-22 15:30:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:30: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-11-22 15:30:46","OPEN_FOR_INTERNAL","2020-11-22 15:30:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15: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-11-22 15:30:49","OPEN_FOR_INTERNAL","2020-11-22 15:30:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:30: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-11-22 15:30:50","OPEN_FOR_INTERNAL","2020-11-22 15:30:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:30: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-11-22 15:30:52","OPEN_FOR_INTERNAL","2020-11-22 15:30:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:30: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-11-22 15:30:53","OPEN_FOR_INTERNAL","2020-11-22 15:30:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15: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-11-22 15:30:55","OPEN_FOR_INTERNAL","2020-11-22 15:30:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:30: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-11-22 15:30:57","OPEN_FOR_INTERNAL","2020-11-22 15:30:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15: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-11-22 15:31:37","OPEN_FOR_INTERNAL","2020-11-22 15:31:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:31: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-11-22 15:31:44","OPEN_FOR_INTERNAL","2020-11-22 15:31:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:31:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:31: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-11-22 15:31:45","OPEN_FOR_INTERNAL","2020-11-22 15:31:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:31: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-11-22 15:31:47","OPEN_FOR_INTERNAL","2020-11-22 15:31:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:31: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-11-22 15:31:51","OPEN_FOR_INTERNAL","2020-11-22 15:31:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:31: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-11-22 15:31:53","OPEN_FOR_INTERNAL","2020-11-22 15:31:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:32: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-11-22 15:32:01","OPEN_FOR_INTERNAL","2020-11-22 15:32:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15: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-11-22 15:32:07","OPEN_FOR_INTERNAL","2020-11-22 15:32:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:41: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-11-22 15:41:02","OPEN_FOR_INTERNAL","2020-11-22 15:41:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:45: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-11-22 15:45:17","OPEN_FOR_INTERNAL","2020-11-22 15:45:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:49: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-11-22 15:49:02","OPEN_FOR_INTERNAL","2020-11-22 15:49:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15:50: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-11-22 15:50:30","OPEN_FOR_INTERNAL","2020-11-22 15:50:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 15: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-11-22 15:51:01","OPEN_FOR_INTERNAL","2020-11-22 15:51:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 17:19: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-11-22 17:19:07","OPEN_FOR_INTERNAL","2020-11-22 17:19:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 17:19: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-11-22 17:19:30","OPEN_FOR_INTERNAL","2020-11-22 17:19:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 17:19:42","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-22 17:19:42","OPEN_FOR_INTERNAL","2020-11-22 17:19:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-22 17:23: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-11-22 17:23:51","OPEN_FOR_INTERNAL","2020-11-22 17:23:51"]},"data_before":[],"data_after":[],"step":1} *****