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

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

\u5009\u5eab\u7de8\u865f<\/td>\n	\u5c3a\u5bf8<\/td>\n	\u539f\u50f9(\u6708)<\/td>\n	\u512a\u60e0\u50f9(\u6708)<\/td>\n	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n	\u50f9\u683c<\/td>\n	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n	<\/td>\n <\/tr>
A16-136 <\/td>\n\t\t\t\t\t	4X4X7 <\/td>\n\t\t\t\t\t	$1290.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"16","total_discounted_price":"1162.00","deposit":"2580.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:03:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201920","PERSONAL","Mr","3WRG8xRbXxmeNhTAMFFpxw==","8BEgNhGpCR8jGkzUtrIcXg==","","51c\/\/LNOqEiBn0jVIilODA==","kK3cDjyL60VzAmLGxrImW2r9CLFi9Tqdlcy1VKn6u+0=","NrxhaFufMjYVcASse6BYhgxd4rFhPpI4UDToima+cgtwbnT2R5NkCGZKqm99omxwtaLc8TxSn1k4uhkKV\/AAZg==","TaMXGRy43zk00oLs+cz4PQ==",null,"kK3cDjyL60VzAmLGxrImW2r9CLFi9Tqdlcy1VKn6u+0=","lC\/i3UxcDRdswAeI9G5qZA==","2","2020-12-13 18:03:55","2","2020-12-13 18:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:03:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7",1920,"NEW","A16-CT209885",1290,1162,2580,0,"6","6",8001,9552,8001,"2020-12-13 18:03:57","0",null,null,null,"2020-12-24","2021-06-23","6 months contract. NEW join customer 50% off for first 3 months ($1935). Storage rental $5421 and deposit $2580 paid by eps on DEC 13, 2020. Smart card and provided on the same day.","2020-12-24","16",0,null,1551,"1551.00","2","2020-12-13 18:03:55","2","2020-12-13 18:03:55","EPS","","","","EPS","","","",null,0,"111,41131","C201920","PERSONAL","Mr","3WRG8xRbXxmeNhTAMFFpxw==","8BEgNhGpCR8jGkzUtrIcXg==","","NrxhaFufMjYVcASse6BYhgxd4rFhPpI4UDToima+cgtwbnT2R5NkCGZKqm99omxwtaLc8TxSn1k4uhkKV\/AAZg==","51c\/\/LNOqEiBn0jVIilODA==","kK3cDjyL60VzAmLGxrImW2r9CLFi9Tqdlcy1VKn6u+0=","TaMXGRy43zk00oLs+cz4PQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:03:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["9885","741 available_room_list_input","202","1627","%","10.00",129,"2","2020-12-13 18:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:03:57","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":["9885","1627","1290.0",1161,"2","2020-12-13 18:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:03:57","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-12-24","2021-06-23","1627"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-12-13 18:03:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["9885","A16-D205948","PAID",2580,0,"2021-06-23","2020-12-13 18:03:55","2020-12-13 18:03:55","2","2020-12-13 18:03:55","2","2020-12-13 18:03:55",1920]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:03:57","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":["9885",1920,"SETTLED","A16-I2010214","2020-12-13 18:03:55","2020-12-24","2","2020-12-13 18:03:55","2","2020-12-13 18:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:03:57","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":["10214","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-12-13 18:03:55","2","2020-12-13 18:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:03:57","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":["10214","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,773,"MO","1",773,"2","2020-12-13 18:03:55","2","2020-12-13 18:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:03:57","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":["10214","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-12-13 18:03:55","2","2020-12-13 18:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:03:57","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":["10214","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-12-13 18:03:55","2","2020-12-13 18:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:03:57","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":["10214","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-12-13 18:03:55","2","2020-12-13 18:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:03:57","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":["10214","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-12-13 18:03:55","2","2020-12-13 18:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:03:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5421,0,"10214"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-12-13 18:03:57","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":[1920,"EPS","","","","EPS","","","","PAID","P209850","2020-12-13 18:03:55",8001,"2","2020-12-13 18:03:55","2","2020-12-13 18:03:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:03:57","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":["9850","DEPOSIT","5948","PAID","2020-12-13 18:03:55",2580,"2","2020-12-13 18:03:55","2","2020-12-13 18:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:03:57","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":["9850","INVOICE","10214","PAID","2020-12-13 18:03:55",5421,"2","2020-12-13 18:03:55","2","2020-12-13 18:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:03: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-12-13 18:03:58","OPEN_FOR_INTERNAL","2020-12-13 18:03:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:03: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-12-13 18:03:58","OPEN_FOR_INTERNAL","2020-12-13 18:03:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:07: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-12-13 18:07:31","OPEN_FOR_INTERNAL","2020-12-13 18:07:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:07: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-12-13 18:07:31","OPEN_FOR_INTERNAL","2020-12-13 18:07:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:07:31","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:07:36","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:07:36","OPEN_FOR_INTERNAL","2020-12-13 18:07:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:07:36","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:07:36","OPEN_FOR_INTERNAL","2020-12-13 18:07:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:07: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-12-13 18:07:40","OPEN_FOR_INTERNAL","2020-12-13 18:07:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:12: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-12-13 18:12:37","OPEN_FOR_INTERNAL","2020-12-13 18:12:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:17: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-12-13 18:17:53","OPEN_FOR_INTERNAL","2020-12-13 18:17:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:17:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:22: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-12-13 18:22:36","OPEN_FOR_INTERNAL","2020-12-13 18:22:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:22: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-12-13 18:22:36","OPEN_FOR_INTERNAL","2020-12-13 18:22:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18: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-12-13 18:22:38","OPEN_FOR_INTERNAL","2020-12-13 18:22:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:22: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-12-13 18:22:41","OPEN_FOR_INTERNAL","2020-12-13 18:22:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:42:56","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:42:56","OPEN_FOR_INTERNAL","2020-12-13 18:42:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:42: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-12-13 18:42:58","OPEN_FOR_INTERNAL","2020-12-13 18:42:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:43: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-12-13 18:43:01","OPEN_FOR_INTERNAL","2020-12-13 18:43:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:43: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-12-13 18:43:26","OPEN_FOR_INTERNAL","2020-12-13 18:43:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:43: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-12-13 18:43:28","OPEN_FOR_INTERNAL","2020-12-13 18:43:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:43: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-12-13 18:43:33","OPEN_FOR_INTERNAL","2020-12-13 18:43:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:43: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-12-13 18:43:34","OPEN_FOR_INTERNAL","2020-12-13 18:43:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:43: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-12-13 18:43:35","OPEN_FOR_INTERNAL","2020-12-13 18:43:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:43: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-12-13 18:43:35","OPEN_FOR_INTERNAL","2020-12-13 18:43:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:45: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-12-13 18:45:18","OPEN_FOR_INTERNAL","2020-12-13 18:45:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:45:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:45:28","OPEN_FOR_INTERNAL","2020-12-13 18:45:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:45: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-12-13 18:45:36","OPEN_FOR_INTERNAL","2020-12-13 18:45:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:46:14","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:46:14","OPEN_FOR_INTERNAL","2020-12-13 18:46:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:46:20","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:46:20","OPEN_FOR_INTERNAL","2020-12-13 18:46:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:46:26","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:46:26","OPEN_FOR_INTERNAL","2020-12-13 18:46:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:46: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-12-13 18:46:27","OPEN_FOR_INTERNAL","2020-12-13 18:46:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:46: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-12-13 18:46:32","OPEN_FOR_INTERNAL","2020-12-13 18:46:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:46: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-12-13 18:46:33","OPEN_FOR_INTERNAL","2020-12-13 18:46:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:46: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-12-13 18:46:33","OPEN_FOR_INTERNAL","2020-12-13 18:46:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:46: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-12-13 18:46:33","OPEN_FOR_INTERNAL","2020-12-13 18:46:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:46: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-12-13 18:46:34","OPEN_FOR_INTERNAL","2020-12-13 18:46:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:46: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-12-13 18:46:44","OPEN_FOR_INTERNAL","2020-12-13 18:46:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:46: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-12-13 18:46:44","OPEN_FOR_INTERNAL","2020-12-13 18:46:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:46:45","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:46:45","OPEN_FOR_INTERNAL","2020-12-13 18:46:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:46:45","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:46:45","OPEN_FOR_INTERNAL","2020-12-13 18:46:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:46:45","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:46:45","OPEN_FOR_INTERNAL","2020-12-13 18:46:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:46:45","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:46:45","OPEN_FOR_INTERNAL","2020-12-13 18:46:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:46: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-12-13 18:46:46","OPEN_FOR_INTERNAL","2020-12-13 18:46:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:46: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-12-13 18:46:46","OPEN_FOR_INTERNAL","2020-12-13 18:46:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:47: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-12-13 18:47:15","OPEN_FOR_INTERNAL","2020-12-13 18:47:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:47: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-12-13 18:47:17","OPEN_FOR_INTERNAL","2020-12-13 18:47:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:47: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-12-13 18:47:25","OPEN_FOR_INTERNAL","2020-12-13 18:47:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:47: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-12-13 18:47:25","OPEN_FOR_INTERNAL","2020-12-13 18:47:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:47: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-12-13 18:47:29","OPEN_FOR_INTERNAL","2020-12-13 18:47:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:47:32","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:47:32","OPEN_FOR_INTERNAL","2020-12-13 18:47:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:47:32","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:47:32","OPEN_FOR_INTERNAL","2020-12-13 18:47:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:47:32","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:47:32","OPEN_FOR_INTERNAL","2020-12-13 18:47:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:47: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-12-13 18:47:33","OPEN_FOR_INTERNAL","2020-12-13 18:47:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:47: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-12-13 18:47:36","OPEN_FOR_INTERNAL","2020-12-13 18:47:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:47: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-12-13 18:47:36","OPEN_FOR_INTERNAL","2020-12-13 18:47:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:47: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-12-13 18:47:36","OPEN_FOR_INTERNAL","2020-12-13 18:47:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:47: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-12-13 18:47:37","OPEN_FOR_INTERNAL","2020-12-13 18:47:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:47: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-12-13 18:47:37","OPEN_FOR_INTERNAL","2020-12-13 18:47:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:47: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-12-13 18:47:38","OPEN_FOR_INTERNAL","2020-12-13 18:47:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:49:11","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:49:11","OPEN_FOR_INTERNAL","2020-12-13 18:49:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:49:11","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:49:11","OPEN_FOR_INTERNAL","2020-12-13 18:49:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:49: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-12-13 18:49:12","OPEN_FOR_INTERNAL","2020-12-13 18:49:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:49: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-12-13 18:49:12","OPEN_FOR_INTERNAL","2020-12-13 18:49:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:49: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-12-13 18:49:35","OPEN_FOR_INTERNAL","2020-12-13 18:49:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:49: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-12-13 18:49:35","OPEN_FOR_INTERNAL","2020-12-13 18:49:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:49: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-12-13 18:49:38","OPEN_FOR_INTERNAL","2020-12-13 18:49:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:49: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-12-13 18:49:38","OPEN_FOR_INTERNAL","2020-12-13 18:49:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:49:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:49:39","OPEN_FOR_INTERNAL","2020-12-13 18:49:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:49: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-12-13 18:49:40","OPEN_FOR_INTERNAL","2020-12-13 18:49:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:49: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-12-13 18:49:40","OPEN_FOR_INTERNAL","2020-12-13 18:49:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:49: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-12-13 18:49:40","OPEN_FOR_INTERNAL","2020-12-13 18:49:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:49: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-12-13 18:49:40","OPEN_FOR_INTERNAL","2020-12-13 18:49:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:50: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-12-13 18:50:02","OPEN_FOR_INTERNAL","2020-12-13 18:50:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:50: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-12-13 18:50:02","OPEN_FOR_INTERNAL","2020-12-13 18:50:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:50: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-12-13 18:50:02","OPEN_FOR_INTERNAL","2020-12-13 18:50:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:50: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-12-13 18:50:02","OPEN_FOR_INTERNAL","2020-12-13 18:50:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:50: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-12-13 18:50:04","OPEN_FOR_INTERNAL","2020-12-13 18:50:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18: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-12-13 18:50:38","OPEN_FOR_INTERNAL","2020-12-13 18:50:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:50: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-12-13 18:50:44","OPEN_FOR_INTERNAL","2020-12-13 18:50:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:51:18","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:51:18","OPEN_FOR_INTERNAL","2020-12-13 18:51:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:51: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-12-13 18:51:23","OPEN_FOR_INTERNAL","2020-12-13 18:51:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:51: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-12-13 18:51:23","OPEN_FOR_INTERNAL","2020-12-13 18:51:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:51:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:51:28","OPEN_FOR_INTERNAL","2020-12-13 18:51:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:51:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:51:28","OPEN_FOR_INTERNAL","2020-12-13 18:51:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:51: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-12-13 18:51:29","OPEN_FOR_INTERNAL","2020-12-13 18:51:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:51: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-12-13 18:51:29","OPEN_FOR_INTERNAL","2020-12-13 18:51:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:51: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-12-13 18:51:29","OPEN_FOR_INTERNAL","2020-12-13 18:51:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:51: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-12-13 18:51:29","OPEN_FOR_INTERNAL","2020-12-13 18:51:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:51: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-12-13 18:51:32","OPEN_FOR_INTERNAL","2020-12-13 18:51:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:51: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-12-13 18:51:32","OPEN_FOR_INTERNAL","2020-12-13 18:51:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:51: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-12-13 18:51:33","OPEN_FOR_INTERNAL","2020-12-13 18:51:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:51: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-12-13 18:51:33","OPEN_FOR_INTERNAL","2020-12-13 18:51:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:51:34","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:51:34","OPEN_FOR_INTERNAL","2020-12-13 18:51:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:51:34","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:51:34","OPEN_FOR_INTERNAL","2020-12-13 18:51:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:51: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-12-13 18:51:36","OPEN_FOR_INTERNAL","2020-12-13 18:51:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:51: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-12-13 18:51:36","OPEN_FOR_INTERNAL","2020-12-13 18:51:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:51: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-12-13 18:51:36","OPEN_FOR_INTERNAL","2020-12-13 18:51:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:51: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-12-13 18:51:39","OPEN_FOR_INTERNAL","2020-12-13 18:51:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:51: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-12-13 18:51:43","OPEN_FOR_INTERNAL","2020-12-13 18:51:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:51: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-12-13 18:51:46","OPEN_FOR_INTERNAL","2020-12-13 18:51:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:51: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-12-13 18:51:47","OPEN_FOR_INTERNAL","2020-12-13 18:51:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:51: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-12-13 18:51:47","OPEN_FOR_INTERNAL","2020-12-13 18:51:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:51: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-12-13 18:51:49","OPEN_FOR_INTERNAL","2020-12-13 18:51:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:51: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-12-13 18:51:49","OPEN_FOR_INTERNAL","2020-12-13 18:51:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18: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-12-13 18:52:31","OPEN_FOR_INTERNAL","2020-12-13 18:52:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18: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-12-13 18:52:31","OPEN_FOR_INTERNAL","2020-12-13 18:52:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18: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-12-13 18:52:31","OPEN_FOR_INTERNAL","2020-12-13 18:52:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18: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-12-13 18:52:31","OPEN_FOR_INTERNAL","2020-12-13 18:52:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:52: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-12-13 18:52:46","OPEN_FOR_INTERNAL","2020-12-13 18:52:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:52: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-12-13 18:52:48","OPEN_FOR_INTERNAL","2020-12-13 18:52:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:52:50","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:52:50","OPEN_FOR_INTERNAL","2020-12-13 18:52:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:52:50","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:52:50","OPEN_FOR_INTERNAL","2020-12-13 18:52:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:52:50","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:52:50","OPEN_FOR_INTERNAL","2020-12-13 18:52:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:52: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-12-13 18:52:56","OPEN_FOR_INTERNAL","2020-12-13 18:52:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:52: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-12-13 18:52:56","OPEN_FOR_INTERNAL","2020-12-13 18:52:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:52: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-12-13 18:52:56","OPEN_FOR_INTERNAL","2020-12-13 18:52:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:52: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-12-13 18:52:56","OPEN_FOR_INTERNAL","2020-12-13 18:52:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:52: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-12-13 18:52:56","OPEN_FOR_INTERNAL","2020-12-13 18:52:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:52: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-12-13 18:52:58","OPEN_FOR_INTERNAL","2020-12-13 18:52:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18: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-12-13 18:53:03","OPEN_FOR_INTERNAL","2020-12-13 18:53:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:04","OPEN_FOR_INTERNAL","2020-12-13 18:53:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:04","OPEN_FOR_INTERNAL","2020-12-13 18:53:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:04","OPEN_FOR_INTERNAL","2020-12-13 18:53:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:04","OPEN_FOR_INTERNAL","2020-12-13 18:53:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:04","OPEN_FOR_INTERNAL","2020-12-13 18:53:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:05","OPEN_FOR_INTERNAL","2020-12-13 18:53:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:07","OPEN_FOR_INTERNAL","2020-12-13 18:53:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:07","OPEN_FOR_INTERNAL","2020-12-13 18:53:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:07","OPEN_FOR_INTERNAL","2020-12-13 18:53:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18: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-12-13 18:53:10","OPEN_FOR_INTERNAL","2020-12-13 18:53:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18: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-12-13 18:53:10","OPEN_FOR_INTERNAL","2020-12-13 18:53:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:13","OPEN_FOR_INTERNAL","2020-12-13 18:53:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:13","OPEN_FOR_INTERNAL","2020-12-13 18:53:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18: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-12-13 18:53:14","OPEN_FOR_INTERNAL","2020-12-13 18:53:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18: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-12-13 18:53:14","OPEN_FOR_INTERNAL","2020-12-13 18:53:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18: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-12-13 18:53:14","OPEN_FOR_INTERNAL","2020-12-13 18:53:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18: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-12-13 18:53:14","OPEN_FOR_INTERNAL","2020-12-13 18:53:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:17","OPEN_FOR_INTERNAL","2020-12-13 18:53:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:17","OPEN_FOR_INTERNAL","2020-12-13 18:53:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:19","OPEN_FOR_INTERNAL","2020-12-13 18:53:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:19","OPEN_FOR_INTERNAL","2020-12-13 18:53:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:19","OPEN_FOR_INTERNAL","2020-12-13 18:53:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:20","OPEN_FOR_INTERNAL","2020-12-13 18:53:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:20","OPEN_FOR_INTERNAL","2020-12-13 18:53:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:20","OPEN_FOR_INTERNAL","2020-12-13 18:53:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:20","OPEN_FOR_INTERNAL","2020-12-13 18:53:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:22","OPEN_FOR_INTERNAL","2020-12-13 18:53:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:22","OPEN_FOR_INTERNAL","2020-12-13 18:53:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:24","OPEN_FOR_INTERNAL","2020-12-13 18:53:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:26","OPEN_FOR_INTERNAL","2020-12-13 18:53:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:28","OPEN_FOR_INTERNAL","2020-12-13 18:53:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:28","OPEN_FOR_INTERNAL","2020-12-13 18:53:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:54","OPEN_FOR_INTERNAL","2020-12-13 18:53:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:54","OPEN_FOR_INTERNAL","2020-12-13 18:53:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:55","OPEN_FOR_INTERNAL","2020-12-13 18:53:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:56","OPEN_FOR_INTERNAL","2020-12-13 18:53:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:58","OPEN_FOR_INTERNAL","2020-12-13 18:53:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:58","OPEN_FOR_INTERNAL","2020-12-13 18:53:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:53: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-12-13 18:53:58","OPEN_FOR_INTERNAL","2020-12-13 18:53:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:54: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-12-13 18:54:02","OPEN_FOR_INTERNAL","2020-12-13 18:54:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:13","OPEN_FOR_INTERNAL","2020-12-13 18:55:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18: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-12-13 18:55:20","OPEN_FOR_INTERNAL","2020-12-13 18:55:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18: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-12-13 18:55:20","OPEN_FOR_INTERNAL","2020-12-13 18:55:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18: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-12-13 18:55:20","OPEN_FOR_INTERNAL","2020-12-13 18:55:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:26","OPEN_FOR_INTERNAL","2020-12-13 18:55:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:26","OPEN_FOR_INTERNAL","2020-12-13 18:55:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:26","OPEN_FOR_INTERNAL","2020-12-13 18:55:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:26","OPEN_FOR_INTERNAL","2020-12-13 18:55:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:27","OPEN_FOR_INTERNAL","2020-12-13 18:55:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:28","OPEN_FOR_INTERNAL","2020-12-13 18:55:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:28","OPEN_FOR_INTERNAL","2020-12-13 18:55:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:28","OPEN_FOR_INTERNAL","2020-12-13 18:55:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:29","OPEN_FOR_INTERNAL","2020-12-13 18:55:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:29","OPEN_FOR_INTERNAL","2020-12-13 18:55:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:29","OPEN_FOR_INTERNAL","2020-12-13 18:55:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55:31","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:55:31","OPEN_FOR_INTERNAL","2020-12-13 18:55:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55:31","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:55:31","OPEN_FOR_INTERNAL","2020-12-13 18:55:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55:31","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:55:31","OPEN_FOR_INTERNAL","2020-12-13 18:55:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:32","OPEN_FOR_INTERNAL","2020-12-13 18:55:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:32","OPEN_FOR_INTERNAL","2020-12-13 18:55:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55:34","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:55:34","OPEN_FOR_INTERNAL","2020-12-13 18:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55:34","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:55:34","OPEN_FOR_INTERNAL","2020-12-13 18:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:35","OPEN_FOR_INTERNAL","2020-12-13 18:55:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:35","OPEN_FOR_INTERNAL","2020-12-13 18:55:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:35","OPEN_FOR_INTERNAL","2020-12-13 18:55:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:35","OPEN_FOR_INTERNAL","2020-12-13 18:55:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55:37","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:55:37","OPEN_FOR_INTERNAL","2020-12-13 18:55:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55:37","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:55:37","OPEN_FOR_INTERNAL","2020-12-13 18:55:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:38","OPEN_FOR_INTERNAL","2020-12-13 18:55:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:38","OPEN_FOR_INTERNAL","2020-12-13 18:55:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:39","OPEN_FOR_INTERNAL","2020-12-13 18:55:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:39","OPEN_FOR_INTERNAL","2020-12-13 18:55:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:39","OPEN_FOR_INTERNAL","2020-12-13 18:55:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:39","OPEN_FOR_INTERNAL","2020-12-13 18:55:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:39","OPEN_FOR_INTERNAL","2020-12-13 18:55:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:41","OPEN_FOR_INTERNAL","2020-12-13 18:55:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:41","OPEN_FOR_INTERNAL","2020-12-13 18:55:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:43","OPEN_FOR_INTERNAL","2020-12-13 18:55:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:45","OPEN_FOR_INTERNAL","2020-12-13 18:55:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:47","OPEN_FOR_INTERNAL","2020-12-13 18:55:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:55: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-12-13 18:55:47","OPEN_FOR_INTERNAL","2020-12-13 18:55:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:56:31","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:56:31","OPEN_FOR_INTERNAL","2020-12-13 18:56:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:56:31","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-12-13 18:56:31","OPEN_FOR_INTERNAL","2020-12-13 18:56:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:56: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-12-13 18:56:32","OPEN_FOR_INTERNAL","2020-12-13 18:56:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:56: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-12-13 18:56:32","OPEN_FOR_INTERNAL","2020-12-13 18:56:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:56: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-12-13 18:56:51","OPEN_FOR_INTERNAL","2020-12-13 18:56:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:56: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-12-13 18:56:51","OPEN_FOR_INTERNAL","2020-12-13 18:56:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:56: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-12-13 18:56:51","OPEN_FOR_INTERNAL","2020-12-13 18:56:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:56: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-12-13 18:56:59","OPEN_FOR_INTERNAL","2020-12-13 18:56:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:56: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-12-13 18:56:59","OPEN_FOR_INTERNAL","2020-12-13 18:56:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:56: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-12-13 18:56:59","OPEN_FOR_INTERNAL","2020-12-13 18:56:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:57: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-12-13 18:57:20","OPEN_FOR_INTERNAL","2020-12-13 18:57:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:57: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-12-13 18:57:20","OPEN_FOR_INTERNAL","2020-12-13 18:57:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:57: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-12-13 18:57:21","OPEN_FOR_INTERNAL","2020-12-13 18:57:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:57: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-12-13 18:57:25","OPEN_FOR_INTERNAL","2020-12-13 18:57:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:57: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-12-13 18:57:26","OPEN_FOR_INTERNAL","2020-12-13 18:57:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:57: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-12-13 18:57:26","OPEN_FOR_INTERNAL","2020-12-13 18:57:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:57: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-12-13 18:57:38","OPEN_FOR_INTERNAL","2020-12-13 18:57:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:57: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-12-13 18:57:38","OPEN_FOR_INTERNAL","2020-12-13 18:57:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:57: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-12-13 18:57:38","OPEN_FOR_INTERNAL","2020-12-13 18:57:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:57: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-12-13 18:57:40","OPEN_FOR_INTERNAL","2020-12-13 18:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:57: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-12-13 18:57:40","OPEN_FOR_INTERNAL","2020-12-13 18:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:57: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-12-13 18:57:40","OPEN_FOR_INTERNAL","2020-12-13 18:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:57: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-12-13 18:57:40","OPEN_FOR_INTERNAL","2020-12-13 18:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:57: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-12-13 18:57:41","OPEN_FOR_INTERNAL","2020-12-13 18:57:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:57: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-12-13 18:57:41","OPEN_FOR_INTERNAL","2020-12-13 18:57:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:57: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-12-13 18:57:41","OPEN_FOR_INTERNAL","2020-12-13 18:57:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:57: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-12-13 18:57:44","OPEN_FOR_INTERNAL","2020-12-13 18:57:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:57: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-12-13 18:57:44","OPEN_FOR_INTERNAL","2020-12-13 18:57:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:57: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-12-13 18:57:44","OPEN_FOR_INTERNAL","2020-12-13 18:57:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:57: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-12-13 18:57:44","OPEN_FOR_INTERNAL","2020-12-13 18:57:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:57: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-12-13 18:57:56","OPEN_FOR_INTERNAL","2020-12-13 18:57:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:57: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-12-13 18:57:57","OPEN_FOR_INTERNAL","2020-12-13 18:57:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:57: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-12-13 18:57:57","OPEN_FOR_INTERNAL","2020-12-13 18:57:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58: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-12-13 18:58:00","OPEN_FOR_INTERNAL","2020-12-13 18:58:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58: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-12-13 18:58:00","OPEN_FOR_INTERNAL","2020-12-13 18:58:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58: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-12-13 18:58:00","OPEN_FOR_INTERNAL","2020-12-13 18:58:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58: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-12-13 18:58:01","OPEN_FOR_INTERNAL","2020-12-13 18:58:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58: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-12-13 18:58:01","OPEN_FOR_INTERNAL","2020-12-13 18:58:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58: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-12-13 18:58:02","OPEN_FOR_INTERNAL","2020-12-13 18:58:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58: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-12-13 18:58:07","OPEN_FOR_INTERNAL","2020-12-13 18:58:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58: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-12-13 18:58:07","OPEN_FOR_INTERNAL","2020-12-13 18:58:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58: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-12-13 18:58:07","OPEN_FOR_INTERNAL","2020-12-13 18:58:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58: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-12-13 18:58:08","OPEN_FOR_INTERNAL","2020-12-13 18:58:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58: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-12-13 18:58:08","OPEN_FOR_INTERNAL","2020-12-13 18:58:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58: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-12-13 18:58:20","OPEN_FOR_INTERNAL","2020-12-13 18:58:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58: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-12-13 18:58:20","OPEN_FOR_INTERNAL","2020-12-13 18:58:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58: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-12-13 18:58:20","OPEN_FOR_INTERNAL","2020-12-13 18:58:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58: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-12-13 18:58:35","OPEN_FOR_INTERNAL","2020-12-13 18:58:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58:35","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"H034777(O)","title":"Mr","lastname":"SUN","firstname":"CHI LAI","companyname":"","email":"","tel":"51848646","address":"FLAT A, 12\/F, SOUTH HORIZON, APLEICHAN, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"470 available_room_list_input","master_room_id":"34","discount_type":"%","price":"998.00","disocunted_price":"998.00","discount":"4.91","monthly_deduct":49.0018,"room_id":"730","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"730","room_code":"O06","retail_price":"998.0","discounted_price":949,"location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":949,"deposit":1996,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3493,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1350.00","warehousing_date":"2020-12-24","rent_from":"2020-12-24","rent_to":"2021-03-23","delivery_service":"0","remark":"3 months contract. NEW join customer 50% off for first 3 months ($1497). Storage rental $1497 and deposit $1996 paid by CASH on DEC 13, 2020. Smart card provided on the same day.","paymethod":"CASH","paymethod2":"CASH","discount_deduct":1350,"order_total":4843,"final_order_total":3493,"location_id":"2","branch_id":"1","company_id":"1","room_key":"133,59530","order_product":[],"pass":true}},"selected_room_tr":"\n	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n	\n \n\n \n \n \n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> O06 <\/td>\n\t\t\t\t\t 4X3X8 <\/td>\n\t\t\t\t\t $998.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"12","total_discounted_price":"949.00","deposit":"1996.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201921","PERSONAL","Mr","KUZsP\/f+uPmK+LPgSYMj2A==","KQFRNa2i9\/MYxWP9oxfpBQ==","","5Q0o4baetlnQa6KLTrFjpw==",null,"NOSkzjAW8E43YhpUVCSLi6lN8qVs0GWAUFNXKnuUf51PbASUnYQAhmUKSvsZK3D8","fBo\/hU18I7ezZIYmAD0XIQ==",null,null,"CHR8ngit7B\/oumJBAFUG9Q==","2","2020-12-13 18:58:35","2","2020-12-13 18:58:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2",1921,"NEW","A14-CT209886",998,949,1996,0,"3","3",3493,4843,3493,"2020-12-13 18:58:36","0",null,null,null,"2020-12-24","2021-03-23","3 months contract. NEW join customer 50% off for first 3 months ($1497). Storage rental $1497 and deposit $1996 paid by CASH on DEC 13, 2020. Smart card provided on the same day.","2020-12-24","12",0,null,1350,"1350.00","2","2020-12-13 18:58:35","2","2020-12-13 18:58:35","CASH","","","","CASH","","","",null,0,"133,59530","C201921","PERSONAL","Mr","KUZsP\/f+uPmK+LPgSYMj2A==","KQFRNa2i9\/MYxWP9oxfpBQ==","","NOSkzjAW8E43YhpUVCSLi6lN8qVs0GWAUFNXKnuUf51PbASUnYQAhmUKSvsZK3D8","5Q0o4baetlnQa6KLTrFjpw==",null,"fBo\/hU18I7ezZIYmAD0XIQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["9886","470 available_room_list_input","34","730","%","4.91",49.0018,"2","2020-12-13 18:58:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["9886","730","998.0",949,"2","2020-12-13 18:58:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-12-24","2021-03-23","730"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-12-13 18:58:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["9886","A14-D205949","PAID",1996,0,"2021-03-23","2020-12-13 18:58:35","2020-12-13 18:58:35","2","2020-12-13 18:58:35","2","2020-12-13 18:58:35",1921]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["9886",1921,"SETTLED","A14-I2010215","2020-12-13 18:58:35","2020-12-24","2","2020-12-13 18:58:35","2","2020-12-13 18:58:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10215","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-12-13 18:58:35","2","2020-12-13 18:58:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10215","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,548,"MO","1",548,"2","2020-12-13 18:58:35","2","2020-12-13 18:58:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10215","RENT","\u9810\u7e73\u79df\u91d1",3,949,"MO","1",949,"2","2020-12-13 18:58:35","2","2020-12-13 18:58:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1497,0,"10215"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-12-13 18:58:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1921,"CASH","","","","CASH","","","","PAID","P209851","2020-12-13 18:58:35",3493,"2","2020-12-13 18:58:35","2","2020-12-13 18:58:35","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["9851","DEPOSIT","5949","PAID","2020-12-13 18:58:35",1996,"2","2020-12-13 18:58:35","2","2020-12-13 18:58:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["9851","INVOICE","10215","PAID","2020-12-13 18:58:35",1497,"2","2020-12-13 18:58:35","2","2020-12-13 18:58:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58: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-12-13 18:58:36","OPEN_FOR_INTERNAL","2020-12-13 18:58:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 18:58: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-12-13 18:58:37","OPEN_FOR_INTERNAL","2020-12-13 18:58:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 20:04: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-12-13 20:04:45","OPEN_FOR_INTERNAL","2020-12-13 20:04:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-13 20:04: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-12-13 20:04:45","OPEN_FOR_INTERNAL","2020-12-13 20:04:45"]},"data_before":[],"data_after":[],"step":1} *****