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

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

\u5009\u5eab\u7de8\u865f<\/td>\n	\u5c3a\u5bf8<\/td>\n	\u539f\u50f9(\u6708)<\/td>\n	\u512a\u60e0\u50f9(\u6708)<\/td>\n	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n	\u50f9\u683c<\/td>\n	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n	<\/td>\n <\/tr>
E10-38 <\/td>\n\t\t\t\t\t	4X3X6.8 <\/td>\n\t\t\t\t\t	$1288.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\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\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>
E10-37 <\/td>\n\t\t\t\t\t	4X3X6.8 <\/td>\n\t\t\t\t\t	$1288.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\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\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>
E10-31 <\/td>\n\t\t\t\t\t	4X5X6.8 <\/td>\n\t\t\t\t\t	$1888.00 <\/td>\n\t\t\t\t	- <\/td>	\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>
E10-30 <\/td>\n\t\t\t\t\t	4X5X6.8 <\/td>\n\t\t\t\t\t	$1888.00 <\/td>\n\t\t\t\t	- <\/td>	\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>
E10-52 <\/td>\n\t\t\t\t\t	4X3X6.8 <\/td>\n\t\t\t\t\t	$1288.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\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\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>
E10-51 <\/td>\n\t\t\t\t\t	4X3X6.8 <\/td>\n\t\t\t\t\t	$1288.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\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\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>
E10-50 <\/td>\n\t\t\t\t\t	4X3X6.8 <\/td>\n\t\t\t\t\t	$1288.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\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\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":"100","total_discounted_price":"9682.00","deposit":"19364.00","total_retail_price":"10216.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201853","PERSONAL","Ms","l9IAr0m8xUdfIpQIIlMWgg==","vCxOlXQuvOQaoL822H2o\/Q==","","\/9PlalmRbK4lMs3kihuZMA==",null,"NrGIr3MH1oBPGByBL7L07SAvCXy3EMupmXfYZFFtB\/s=","ELwE5TfwvfooP4VxRO+7XQ==",null,null,"uEa3NoBWthOJredYWaMMZw==","2","2020-11-11 17:07:19","2","2020-11-11 17:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","5","11",1853,"NEW","E10-CT209538",10216,9682,19364,0,"13","13",112340,145230,112340,"2020-11-11 17:07:21","0",null,null,null,"2020-12-01","2021-12-31","13 months contract. Special offer 50% off in the first 3 months and 13th month free. First 3 months rental $14523 and deposit $19364 paid by cheque on 10 Nov 2020 (ttl: $32387 with $1500 down payment paid in cash on 10 Oct 2020). Remaining balance will be paid by cheque monthly in $8717. Customer ONLY enjoy the 13th month free when the 4th-12th months rental are paid.\r\n\r\n1st-3rd month & deposit paid by cheque $32387 on 10 Nov 2020","2020-12-01","100",0,null,32890,"32890.00","2","2020-11-11 17:07:19","2","2020-11-11 17:07:19","CHEQUE","","","","CHEQUE","","","",null,0,"190,40495 + 190,37033","C201853","PERSONAL","Ms","l9IAr0m8xUdfIpQIIlMWgg==","vCxOlXQuvOQaoL822H2o\/Q==","","NrGIr3MH1oBPGByBL7L07SAvCXy3EMupmXfYZFFtB\/s=","\/9PlalmRbK4lMs3kihuZMA==",null,"ELwE5TfwvfooP4VxRO+7XQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","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":["9538","1905","1288.0","1288.00","2","2020-11-11 17:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","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-01","2021-12-31","1905"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-11-11 17:07:21","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":["9538","1904","1288.0","1288.00","2","2020-11-11 17:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","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-01","2021-12-31","1904"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-11-11 17:07:21","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":["9538","1934","1888.0","1888.00","2","2020-11-11 17:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","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-01","2021-12-31","1934"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-11-11 17:07:21","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":["9538","1933","1888.0","1888.00","2","2020-11-11 17:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","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-01","2021-12-31","1933"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-11-11 17:07:21","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":["9538","1910","1288.0","1288.00","2","2020-11-11 17:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","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-01","2021-12-31","1910"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-11-11 17:07:21","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":["9538","1909","1288.0","1288.00","2","2020-11-11 17:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","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-01","2021-12-31","1909"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-11-11 17:07:21","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":["9538","1908","1288.0","1288.00","2","2020-11-11 17:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","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-01","2021-12-31","1908"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-11-11 17:07:21","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":["9538","E10-D205859","PAID",19364,0,"2021-12-31","2020-11-11 17:07:19","2020-11-11 17:07:19","2","2020-11-11 17:07:19","2","2020-11-11 17:07:19",1853]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","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":["9538",1853,"SETTLED","E10-I209867","2020-11-11 17:07:19","2020-12-01","2","2020-11-11 17:07:19","2","2020-11-11 17:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","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":["9867","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-11-11 17:07:19","2","2020-11-11 17:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","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":["9867","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-11-11 17:07:19","2","2020-11-11 17:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","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":["9867","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,0,"MO","1",0,"2","2020-11-11 17:07:19","2","2020-11-11 17:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","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":["9867","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",4,5838,"MO","1",5838,"2","2020-11-11 17:07:19","2","2020-11-11 17:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","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":["9867","RENT","\u9810\u7e73\u79df\u91d1",5,9682,"MO","1",9682,"2","2020-11-11 17:07:19","2","2020-11-11 17:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","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":["9867","RENT","\u9810\u7e73\u79df\u91d1",6,9682,"MO","1",9682,"2","2020-11-11 17:07:19","2","2020-11-11 17:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","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":["9867","RENT","\u9810\u7e73\u79df\u91d1",7,9682,"MO","1",9682,"2","2020-11-11 17:07:19","2","2020-11-11 17:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","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":["9867","RENT","\u9810\u7e73\u79df\u91d1",8,9682,"MO","1",9682,"2","2020-11-11 17:07:19","2","2020-11-11 17:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","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":["9867","RENT","\u9810\u7e73\u79df\u91d1",9,9682,"MO","1",9682,"2","2020-11-11 17:07:19","2","2020-11-11 17:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","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":["9867","RENT","\u9810\u7e73\u79df\u91d1",10,9682,"MO","1",9682,"2","2020-11-11 17:07:19","2","2020-11-11 17:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","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":["9867","RENT","\u9810\u7e73\u79df\u91d1",11,9682,"MO","1",9682,"2","2020-11-11 17:07:19","2","2020-11-11 17:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","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":["9867","RENT","\u9810\u7e73\u79df\u91d1",12,9682,"MO","1",9682,"2","2020-11-11 17:07:19","2","2020-11-11 17:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","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":["9867","RENT","\u9810\u7e73\u79df\u91d1",13,9682,"MO","1",9682,"2","2020-11-11 17:07:19","2","2020-11-11 17:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[92976,0,"9867"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-11-11 17:07:21","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":[1853,"CHEQUE","","","","CHEQUE","","","","PAID","P209506","2020-11-11 17:07:19",112340,"2","2020-11-11 17:07:19","2","2020-11-11 17:07:19","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","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":["9506","DEPOSIT","5859","PAID","2020-11-11 17:07:19",19364,"2","2020-11-11 17:07:19","2","2020-11-11 17:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","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":["9506","INVOICE","9867","PAID","2020-11-11 17:07:19",92976,"2","2020-11-11 17:07:19","2","2020-11-11 17:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:07:21","OPEN_FOR_INTERNAL","2020-11-11 17:07:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:07:21","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:07:21","OPEN_FOR_INTERNAL","2020-11-11 17:07:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:12:55","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:12:55","OPEN_FOR_INTERNAL","2020-11-11 17:12:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:14:17","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:14:17","OPEN_FOR_INTERNAL","2020-11-11 17:14:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:14:17","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:14:17","OPEN_FOR_INTERNAL","2020-11-11 17:14:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:14:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:14:21","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:14:21","OPEN_FOR_INTERNAL","2020-11-11 17:14:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:14:35","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:14:35","OPEN_FOR_INTERNAL","2020-11-11 17:14:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:14:41","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:14:41","OPEN_FOR_INTERNAL","2020-11-11 17:14:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:23:36","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:23:36","OPEN_FOR_INTERNAL","2020-11-11 17:23:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:23:41","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:23:41","OPEN_FOR_INTERNAL","2020-11-11 17:23:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:23:41","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:23:41","OPEN_FOR_INTERNAL","2020-11-11 17:23:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:23:42","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:23:42","OPEN_FOR_INTERNAL","2020-11-11 17:23:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:23:43","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:23:43","OPEN_FOR_INTERNAL","2020-11-11 17:23:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:23:45","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:23:45","OPEN_FOR_INTERNAL","2020-11-11 17:23:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:23:47","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:23:47","OPEN_FOR_INTERNAL","2020-11-11 17:23:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:23:48","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:23:48","OPEN_FOR_INTERNAL","2020-11-11 17:23:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:23:49","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:23:49","OPEN_FOR_INTERNAL","2020-11-11 17:23:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:26:04","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:26:04","OPEN_FOR_INTERNAL","2020-11-11 17:26:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:26:05","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:26:05","OPEN_FOR_INTERNAL","2020-11-11 17:26:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:26:06","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:26:06","OPEN_FOR_INTERNAL","2020-11-11 17:26:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:26:07","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:26:07","OPEN_FOR_INTERNAL","2020-11-11 17:26:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:26:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:26:08","OPEN_FOR_INTERNAL","2020-11-11 17:26:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:26:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:26:09","OPEN_FOR_INTERNAL","2020-11-11 17:26:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:26:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:26:10","OPEN_FOR_INTERNAL","2020-11-11 17:26:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:26:11","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:26:11","OPEN_FOR_INTERNAL","2020-11-11 17:26:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:28:24","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:28:24","OPEN_FOR_INTERNAL","2020-11-11 17:28:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:28:30","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:28:30","OPEN_FOR_INTERNAL","2020-11-11 17:28:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:28:31","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:28:31","OPEN_FOR_INTERNAL","2020-11-11 17:28:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:28:31","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:28:31","OPEN_FOR_INTERNAL","2020-11-11 17:28:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:28:33","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:28:33","OPEN_FOR_INTERNAL","2020-11-11 17:28:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:28:35","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:28:35","OPEN_FOR_INTERNAL","2020-11-11 17:28:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:28:37","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:28:37","OPEN_FOR_INTERNAL","2020-11-11 17:28:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:28:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:28:38","OPEN_FOR_INTERNAL","2020-11-11 17:28:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:31:25","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:31:25","OPEN_FOR_INTERNAL","2020-11-11 17:31:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:31:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:31:27","OPEN_FOR_INTERNAL","2020-11-11 17:31:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:31:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:31:28","OPEN_FOR_INTERNAL","2020-11-11 17:31:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:32:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:32:10","OPEN_FOR_INTERNAL","2020-11-11 17:32:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:32:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:32:10","OPEN_FOR_INTERNAL","2020-11-11 17:32:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:32:11","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:32:11","OPEN_FOR_INTERNAL","2020-11-11 17:32:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:32:12","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:32:12","OPEN_FOR_INTERNAL","2020-11-11 17:32:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:32:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:32:13","OPEN_FOR_INTERNAL","2020-11-11 17:32:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:32:14","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:32:14","OPEN_FOR_INTERNAL","2020-11-11 17:32:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:32:16","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:32:16","OPEN_FOR_INTERNAL","2020-11-11 17:32:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:32:17","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:32:17","OPEN_FOR_INTERNAL","2020-11-11 17:32:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:37:21","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:37:21","OPEN_FOR_INTERNAL","2020-11-11 17:37:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:37:22","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:37:22","OPEN_FOR_INTERNAL","2020-11-11 17:37:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:37:23","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:37:23","OPEN_FOR_INTERNAL","2020-11-11 17:37:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:37:24","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:37:24","OPEN_FOR_INTERNAL","2020-11-11 17:37:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:37:25","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:37:25","OPEN_FOR_INTERNAL","2020-11-11 17:37:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:37:26","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:37:26","OPEN_FOR_INTERNAL","2020-11-11 17:37:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:37:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:37:27","OPEN_FOR_INTERNAL","2020-11-11 17:37:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:37:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:37:28","OPEN_FOR_INTERNAL","2020-11-11 17:37:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:37:29","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:37:29","OPEN_FOR_INTERNAL","2020-11-11 17:37:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:37:30","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:37:30","OPEN_FOR_INTERNAL","2020-11-11 17:37:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:37:31","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:37:31","OPEN_FOR_INTERNAL","2020-11-11 17:37:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:37:32","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:37:32","OPEN_FOR_INTERNAL","2020-11-11 17:37:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:37:33","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:37:33","OPEN_FOR_INTERNAL","2020-11-11 17:37:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:37:34","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:37:34","OPEN_FOR_INTERNAL","2020-11-11 17:37:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:40:43","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:40:43","OPEN_FOR_INTERNAL","2020-11-11 17:40:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:40:47","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:40:47","OPEN_FOR_INTERNAL","2020-11-11 17:40:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:07","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:07","OPEN_FOR_INTERNAL","2020-11-11 17:41:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:07","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:07","OPEN_FOR_INTERNAL","2020-11-11 17:41:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:08","OPEN_FOR_INTERNAL","2020-11-11 17:41:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:08","OPEN_FOR_INTERNAL","2020-11-11 17:41:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:08","OPEN_FOR_INTERNAL","2020-11-11 17:41:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:08","OPEN_FOR_INTERNAL","2020-11-11 17:41:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:08","OPEN_FOR_INTERNAL","2020-11-11 17:41:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:08","OPEN_FOR_INTERNAL","2020-11-11 17:41:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:08","OPEN_FOR_INTERNAL","2020-11-11 17:41:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:08","OPEN_FOR_INTERNAL","2020-11-11 17:41:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:08","OPEN_FOR_INTERNAL","2020-11-11 17:41:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:08","OPEN_FOR_INTERNAL","2020-11-11 17:41:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:08","OPEN_FOR_INTERNAL","2020-11-11 17:41:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:08","OPEN_FOR_INTERNAL","2020-11-11 17:41:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:11","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:11","OPEN_FOR_INTERNAL","2020-11-11 17:41:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:11","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:11","OPEN_FOR_INTERNAL","2020-11-11 17:41:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:12","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:12","OPEN_FOR_INTERNAL","2020-11-11 17:41:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:12","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:12","OPEN_FOR_INTERNAL","2020-11-11 17:41:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:12","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:12","OPEN_FOR_INTERNAL","2020-11-11 17:41:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:12","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:12","OPEN_FOR_INTERNAL","2020-11-11 17:41:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:12","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:12","OPEN_FOR_INTERNAL","2020-11-11 17:41:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:13","OPEN_FOR_INTERNAL","2020-11-11 17:41:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:14","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:14","OPEN_FOR_INTERNAL","2020-11-11 17:41:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:18","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:18","OPEN_FOR_INTERNAL","2020-11-11 17:41:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:19","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:19","OPEN_FOR_INTERNAL","2020-11-11 17:41:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:21","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:21","OPEN_FOR_INTERNAL","2020-11-11 17:41:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:25","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:25","OPEN_FOR_INTERNAL","2020-11-11 17:41:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:25","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:25","OPEN_FOR_INTERNAL","2020-11-11 17:41:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:25","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:25","OPEN_FOR_INTERNAL","2020-11-11 17:41:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:26","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:26","OPEN_FOR_INTERNAL","2020-11-11 17:41:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:28","OPEN_FOR_INTERNAL","2020-11-11 17:41:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:29","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:29","OPEN_FOR_INTERNAL","2020-11-11 17:41:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:29","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:29","OPEN_FOR_INTERNAL","2020-11-11 17:41:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:29","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:29","OPEN_FOR_INTERNAL","2020-11-11 17:41:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:29","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:29","OPEN_FOR_INTERNAL","2020-11-11 17:41:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:31","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:31","OPEN_FOR_INTERNAL","2020-11-11 17:41:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:31","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:31","OPEN_FOR_INTERNAL","2020-11-11 17:41:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:31","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:31","OPEN_FOR_INTERNAL","2020-11-11 17:41:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:31","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:31","OPEN_FOR_INTERNAL","2020-11-11 17:41:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:42","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:42","OPEN_FOR_INTERNAL","2020-11-11 17:41:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:42","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:42","OPEN_FOR_INTERNAL","2020-11-11 17:41:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:41:45","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:41:45","OPEN_FOR_INTERNAL","2020-11-11 17:41:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:42:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:42:09","OPEN_FOR_INTERNAL","2020-11-11 17:42:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:42:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:42:09","OPEN_FOR_INTERNAL","2020-11-11 17:42:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:42:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:42:09","OPEN_FOR_INTERNAL","2020-11-11 17:42:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:42:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:42:28","OPEN_FOR_INTERNAL","2020-11-11 17:42:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:42:28","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=9&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":432,"customer_code":"C170432","identity_type":"PERSONAL","identity_id":"E722666(0)","title":"Mr","lastname":"Fung","firstname":"Firmus","companyname":"","email":"firmusfung@netvigator.com","tel":"91097337","address":"23A,Amber Garden 70-72 Kennedy Road,Wan Chai,HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1139.0","renew_rent_month":"12","renew_warehousing_date":"2020-11-13","renew_room_key":"056,02703","renew_remark":"12 months contract. Storage rental paid by bank transfer on November 8, 2019. Storage deposit transferred from agreement A14-CT194940 to this agreement. \u820a\u5408\u7d04\u7de8\u865f: A14-CT194940, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196325, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"38","order_discount":[],"order_room":[{"room_id":"481","room_code":"K18","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1139,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6834,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-11-13","rent_from":"2020-11-13","rent_to":"2021-05-12","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on November 11, 2020. Storage deposit transferred from agreement A14-CT196325 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6834,"final_order_total":6834,"location_id":"2","branch_id":"1","company_id":"1","room_key":"056,02703","order_product":[],"pass":true}},"first_order_id":"3598","selected_room_tr":"	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> K18 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1139.00","deposit":"0.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:42:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",432,"NEW","A14-CT209539",1528,1139,0,0,"6","6",6834,6834,6834,"2020-11-11 17:42:28","0",null,null,null,"2020-11-13","2021-05-12","6 months contract. Storage rental paid by bank transfer on November 11, 2020. Storage deposit transferred from agreement A14-CT196325 to this agreement.\r\n","2020-11-13","20",0,null,0,"0.00","2","2020-11-11 17:42:28","2","2020-11-11 17:42:28","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"056,02703","C170432","PERSONAL","Mr","RSJ57\/VBz65mDbe\/7a7v+g==","fw9NU0t2sgJqYX3ZpxPMlA==","","3JlbgSpwU3BPvRypK4uPSQny79GBONT\/L2a1XiTsTCUMQVD6fFet8uvoayaNfzz7","1gEDJR++oJgm1++oiUou+A==","1LgX012VzrfWiaeXi8cpRjJGkiAOyovMuxc18v8zS7U=","czGdq0ynq+TALx5zYq1Q3w==",null,1,"3598"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:42:28","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":["9539","481","1528.0","1528.00","2","2020-11-11 17:42:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:42:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-11-13","2021-05-12","481"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-11-11 17:42:28","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":["9539",432,"SETTLED","A14-I209868","2020-11-11 17:42:28","2020-11-13","2","2020-11-11 17:42:28","2","2020-11-11 17:42:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:42:28","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":["9868","RENT","\u9810\u7e73\u79df\u91d1",1,1139,"MO","1",1139,"2","2020-11-11 17:42:28","2","2020-11-11 17:42:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:42:28","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":["9868","RENT","\u9810\u7e73\u79df\u91d1",2,1139,"MO","1",1139,"2","2020-11-11 17:42:28","2","2020-11-11 17:42:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:42:28","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":["9868","RENT","\u9810\u7e73\u79df\u91d1",3,1139,"MO","1",1139,"2","2020-11-11 17:42:28","2","2020-11-11 17:42:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:42:28","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":["9868","RENT","\u9810\u7e73\u79df\u91d1",4,1139,"MO","1",1139,"2","2020-11-11 17:42:28","2","2020-11-11 17:42:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:42:28","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":["9868","RENT","\u9810\u7e73\u79df\u91d1",5,1139,"MO","1",1139,"2","2020-11-11 17:42:28","2","2020-11-11 17:42:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:42:28","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":["9868","RENT","\u9810\u7e73\u79df\u91d1",6,1139,"MO","1",1139,"2","2020-11-11 17:42:28","2","2020-11-11 17:42:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:42:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6834,0,"9868"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-11-11 17:42:28","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":[432,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P209507","2020-11-11 17:42:28",6834,"2","2020-11-11 17:42:28","2","2020-11-11 17:42:28","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:42:28","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":["9507","DEPOSIT",null,"PAID","2020-11-11 17:42:28",0,"2","2020-11-11 17:42:28","2","2020-11-11 17:42:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:42:28","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":["9507","INVOICE","9868","PAID","2020-11-11 17:42:28",6834,"2","2020-11-11 17:42:28","2","2020-11-11 17:42:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:42:29","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:42:29","OPEN_FOR_INTERNAL","2020-11-11 17:42:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:42:29","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:42:29","OPEN_FOR_INTERNAL","2020-11-11 17:42:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:43:02","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:43:02","OPEN_FOR_INTERNAL","2020-11-11 17:43:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:43:06","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:43:06","OPEN_FOR_INTERNAL","2020-11-11 17:43:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:43:06","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:43:06","OPEN_FOR_INTERNAL","2020-11-11 17:43:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:43:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:43:08","OPEN_FOR_INTERNAL","2020-11-11 17:43:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:43:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:43:09","OPEN_FOR_INTERNAL","2020-11-11 17:43:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:43:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:43:10","OPEN_FOR_INTERNAL","2020-11-11 17:43:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:43:12","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:43:12","OPEN_FOR_INTERNAL","2020-11-11 17:43:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:43:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:43:13","OPEN_FOR_INTERNAL","2020-11-11 17:43:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:43:14","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:43:14","OPEN_FOR_INTERNAL","2020-11-11 17:43:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:43:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:43:15","OPEN_FOR_INTERNAL","2020-11-11 17:43:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:43:16","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:43:16","OPEN_FOR_INTERNAL","2020-11-11 17:43:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:43:17","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:43:17","OPEN_FOR_INTERNAL","2020-11-11 17:43:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:43:18","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:43:18","OPEN_FOR_INTERNAL","2020-11-11 17:43:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:43:19","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:43:19","OPEN_FOR_INTERNAL","2020-11-11 17:43:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:43:20","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:43:20","OPEN_FOR_INTERNAL","2020-11-11 17:43:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:43:21","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:43:21","OPEN_FOR_INTERNAL","2020-11-11 17:43:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:43:22","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:43:22","OPEN_FOR_INTERNAL","2020-11-11 17:43:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:43:23","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:43:23","OPEN_FOR_INTERNAL","2020-11-11 17:43:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:45:50","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:45:50","OPEN_FOR_INTERNAL","2020-11-11 17:45:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:46:12","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:46:12","OPEN_FOR_INTERNAL","2020-11-11 17:46:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:55:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:55:15","OPEN_FOR_INTERNAL","2020-11-11 17:55:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:55:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:55:18","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:55:18","OPEN_FOR_INTERNAL","2020-11-11 17:55:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:55:18","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:55:18","OPEN_FOR_INTERNAL","2020-11-11 17:55:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:55:22","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:55:22","OPEN_FOR_INTERNAL","2020-11-11 17:55:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:55:24","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:55:24","OPEN_FOR_INTERNAL","2020-11-11 17:55:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17: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-11-11 17:55:28","OPEN_FOR_INTERNAL","2020-11-11 17:55:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17:55:30","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 17:55:30","OPEN_FOR_INTERNAL","2020-11-11 17:55:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 17: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-11-11 17:55:31","OPEN_FOR_INTERNAL","2020-11-11 17:55:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:15:54","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:15:54","OPEN_FOR_INTERNAL","2020-11-11 18:15:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:15:55","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:15:55","OPEN_FOR_INTERNAL","2020-11-11 18:15:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:15:57","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:15:57","OPEN_FOR_INTERNAL","2020-11-11 18:15:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:15:59","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:15:59","OPEN_FOR_INTERNAL","2020-11-11 18:15:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:16:00","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:16:00","OPEN_FOR_INTERNAL","2020-11-11 18:16:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:16:01","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:16:01","OPEN_FOR_INTERNAL","2020-11-11 18:16:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:16:02","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:16:02","OPEN_FOR_INTERNAL","2020-11-11 18:16:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:16:03","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:16:03","OPEN_FOR_INTERNAL","2020-11-11 18:16:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:18:48","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:18:48","OPEN_FOR_INTERNAL","2020-11-11 18:18:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:18:50","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:18:50","OPEN_FOR_INTERNAL","2020-11-11 18:18:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:18:50","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:18:50","OPEN_FOR_INTERNAL","2020-11-11 18:18:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:18:52","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:18:52","OPEN_FOR_INTERNAL","2020-11-11 18:18:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:18:52","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:18:52","OPEN_FOR_INTERNAL","2020-11-11 18:18:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:18:53","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:18:53","OPEN_FOR_INTERNAL","2020-11-11 18:18:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:18:55","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:18:55","OPEN_FOR_INTERNAL","2020-11-11 18:18:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:18:56","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:18:56","OPEN_FOR_INTERNAL","2020-11-11 18:18:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:18:57","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:18:57","OPEN_FOR_INTERNAL","2020-11-11 18:18:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:24:45","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:24:45","OPEN_FOR_INTERNAL","2020-11-11 18:24:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:24:55","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:24:55","OPEN_FOR_INTERNAL","2020-11-11 18:24:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:25:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:25:27","OPEN_FOR_INTERNAL","2020-11-11 18:25:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:25:58","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:25:58","OPEN_FOR_INTERNAL","2020-11-11 18:25:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:25:58","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:25:58","OPEN_FOR_INTERNAL","2020-11-11 18:25:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:00","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:00","OPEN_FOR_INTERNAL","2020-11-11 18:26:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:01","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:01","OPEN_FOR_INTERNAL","2020-11-11 18:26:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:07","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:07","OPEN_FOR_INTERNAL","2020-11-11 18:26:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:09","OPEN_FOR_INTERNAL","2020-11-11 18:26:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:09","OPEN_FOR_INTERNAL","2020-11-11 18:26:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:10","OPEN_FOR_INTERNAL","2020-11-11 18:26:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:10","OPEN_FOR_INTERNAL","2020-11-11 18:26:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:10","OPEN_FOR_INTERNAL","2020-11-11 18:26:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:10","OPEN_FOR_INTERNAL","2020-11-11 18:26:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:10","OPEN_FOR_INTERNAL","2020-11-11 18:26:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:10","OPEN_FOR_INTERNAL","2020-11-11 18:26:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:10","OPEN_FOR_INTERNAL","2020-11-11 18:26:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:10","OPEN_FOR_INTERNAL","2020-11-11 18:26:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:10","OPEN_FOR_INTERNAL","2020-11-11 18:26:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:10","OPEN_FOR_INTERNAL","2020-11-11 18:26:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:10","OPEN_FOR_INTERNAL","2020-11-11 18:26:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:10","OPEN_FOR_INTERNAL","2020-11-11 18:26:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:12","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:12","OPEN_FOR_INTERNAL","2020-11-11 18:26:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:12","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:12","OPEN_FOR_INTERNAL","2020-11-11 18:26:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:12","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:12","OPEN_FOR_INTERNAL","2020-11-11 18:26:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:14","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:14","OPEN_FOR_INTERNAL","2020-11-11 18:26:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:15","OPEN_FOR_INTERNAL","2020-11-11 18:26:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:15","OPEN_FOR_INTERNAL","2020-11-11 18:26:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:16","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:16","OPEN_FOR_INTERNAL","2020-11-11 18:26:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:17","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:17","OPEN_FOR_INTERNAL","2020-11-11 18:26:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:17","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:17","OPEN_FOR_INTERNAL","2020-11-11 18:26:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:27","OPEN_FOR_INTERNAL","2020-11-11 18:26:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:27","OPEN_FOR_INTERNAL","2020-11-11 18:26:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:29","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:29","OPEN_FOR_INTERNAL","2020-11-11 18:26:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:55","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:55","OPEN_FOR_INTERNAL","2020-11-11 18:26:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:26:56","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:26:56","OPEN_FOR_INTERNAL","2020-11-11 18:26:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:27:06","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:27:06","OPEN_FOR_INTERNAL","2020-11-11 18:27:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:27:06","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:27:06","OPEN_FOR_INTERNAL","2020-11-11 18:27:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:27:06","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:27:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:27:08","OPEN_FOR_INTERNAL","2020-11-11 18:27:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:27:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:27:08","OPEN_FOR_INTERNAL","2020-11-11 18:27:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:27:12","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:27:12","OPEN_FOR_INTERNAL","2020-11-11 18:27:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:27:12","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:27:12","OPEN_FOR_INTERNAL","2020-11-11 18:27:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:27:32","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:27:32","OPEN_FOR_INTERNAL","2020-11-11 18:27:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:27:33","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:27:33","OPEN_FOR_INTERNAL","2020-11-11 18:27:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:00","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:00","OPEN_FOR_INTERNAL","2020-11-11 18:28:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:09","OPEN_FOR_INTERNAL","2020-11-11 18:28:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:09","OPEN_FOR_INTERNAL","2020-11-11 18:28:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:09","OPEN_FOR_INTERNAL","2020-11-11 18:28:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:09","OPEN_FOR_INTERNAL","2020-11-11 18:28:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:09","OPEN_FOR_INTERNAL","2020-11-11 18:28:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:09","OPEN_FOR_INTERNAL","2020-11-11 18:28:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:09","OPEN_FOR_INTERNAL","2020-11-11 18:28:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:09","OPEN_FOR_INTERNAL","2020-11-11 18:28:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:09","OPEN_FOR_INTERNAL","2020-11-11 18:28:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:09","OPEN_FOR_INTERNAL","2020-11-11 18:28:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:09","OPEN_FOR_INTERNAL","2020-11-11 18:28:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:09","OPEN_FOR_INTERNAL","2020-11-11 18:28:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:09","OPEN_FOR_INTERNAL","2020-11-11 18:28:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:10","OPEN_FOR_INTERNAL","2020-11-11 18:28:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:16","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:16","OPEN_FOR_INTERNAL","2020-11-11 18:28:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:16","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:16","OPEN_FOR_INTERNAL","2020-11-11 18:28:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:16","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:16","OPEN_FOR_INTERNAL","2020-11-11 18:28:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:16","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:16","OPEN_FOR_INTERNAL","2020-11-11 18:28:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:17","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:17","OPEN_FOR_INTERNAL","2020-11-11 18:28:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:17","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:17","OPEN_FOR_INTERNAL","2020-11-11 18:28:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:17","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:17","OPEN_FOR_INTERNAL","2020-11-11 18:28:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:19","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:19","OPEN_FOR_INTERNAL","2020-11-11 18:28:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:19","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:19","OPEN_FOR_INTERNAL","2020-11-11 18:28:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:20","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:20","OPEN_FOR_INTERNAL","2020-11-11 18:28:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:20","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:20","OPEN_FOR_INTERNAL","2020-11-11 18:28:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:21","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:21","OPEN_FOR_INTERNAL","2020-11-11 18:28:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:21","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:21","OPEN_FOR_INTERNAL","2020-11-11 18:28:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:21","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:21","OPEN_FOR_INTERNAL","2020-11-11 18:28:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:33","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:33","OPEN_FOR_INTERNAL","2020-11-11 18:28:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:37","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:37","OPEN_FOR_INTERNAL","2020-11-11 18:28:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:55","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:55","OPEN_FOR_INTERNAL","2020-11-11 18:28:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:55","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:55","OPEN_FOR_INTERNAL","2020-11-11 18:28:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:58","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:58","OPEN_FOR_INTERNAL","2020-11-11 18:28:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:28:59","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:28:59","OPEN_FOR_INTERNAL","2020-11-11 18:28:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:29:00","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:29:00","OPEN_FOR_INTERNAL","2020-11-11 18:29:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:29:00","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:29:00","OPEN_FOR_INTERNAL","2020-11-11 18:29:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:29:04","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:29:04","OPEN_FOR_INTERNAL","2020-11-11 18:29:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:29:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:29:10","OPEN_FOR_INTERNAL","2020-11-11 18:29:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:29:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:29:15","OPEN_FOR_INTERNAL","2020-11-11 18:29:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:29:19","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:29:19","OPEN_FOR_INTERNAL","2020-11-11 18:29:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:30:00","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:30:00","OPEN_FOR_INTERNAL","2020-11-11 18:30:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:30:33","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:30:33","OPEN_FOR_INTERNAL","2020-11-11 18:30:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:31:33","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:31:33","OPEN_FOR_INTERNAL","2020-11-11 18:31:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:31:43","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:31:43","OPEN_FOR_INTERNAL","2020-11-11 18:31:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:32:19","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:32:19","OPEN_FOR_INTERNAL","2020-11-11 18:32:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:32:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:32:27","OPEN_FOR_INTERNAL","2020-11-11 18:32:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:35:36","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:35:36","OPEN_FOR_INTERNAL","2020-11-11 18:35:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:36:26","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:36:26","OPEN_FOR_INTERNAL","2020-11-11 18:36:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:36:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:36:28","OPEN_FOR_INTERNAL","2020-11-11 18:36:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:36:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:36:28","OPEN_FOR_INTERNAL","2020-11-11 18:36:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:36:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:36:28","OPEN_FOR_INTERNAL","2020-11-11 18:36:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:36:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:36:28","OPEN_FOR_INTERNAL","2020-11-11 18:36:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:36:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:36:28","OPEN_FOR_INTERNAL","2020-11-11 18:36:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:36:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:36:28","OPEN_FOR_INTERNAL","2020-11-11 18:36:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:36:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:36:28","OPEN_FOR_INTERNAL","2020-11-11 18:36:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:36:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:36:28","OPEN_FOR_INTERNAL","2020-11-11 18:36:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:36:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:36:28","OPEN_FOR_INTERNAL","2020-11-11 18:36:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:36:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:36:28","OPEN_FOR_INTERNAL","2020-11-11 18:36:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:36:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:36:28","OPEN_FOR_INTERNAL","2020-11-11 18:36:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:36:29","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:36:28","OPEN_FOR_INTERNAL","2020-11-11 18:36:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:36:29","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:36:29","OPEN_FOR_INTERNAL","2020-11-11 18:36:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:36:29","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:36:29","OPEN_FOR_INTERNAL","2020-11-11 18:36:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:36:34","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:36:34","OPEN_FOR_INTERNAL","2020-11-11 18:36:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:36:36","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:36:36","OPEN_FOR_INTERNAL","2020-11-11 18:36:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:36:37","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:36:37","OPEN_FOR_INTERNAL","2020-11-11 18:36:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:36:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:36:38","OPEN_FOR_INTERNAL","2020-11-11 18:36:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:36:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:36:38","OPEN_FOR_INTERNAL","2020-11-11 18:36:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:36:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:36:38","OPEN_FOR_INTERNAL","2020-11-11 18:36:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:36:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:36:39","OPEN_FOR_INTERNAL","2020-11-11 18:36:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:36:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:36:39","OPEN_FOR_INTERNAL","2020-11-11 18:36:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:36:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:36:39","OPEN_FOR_INTERNAL","2020-11-11 18:36:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:37:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:37:09","OPEN_FOR_INTERNAL","2020-11-11 18:37:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:37:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:37:10","OPEN_FOR_INTERNAL","2020-11-11 18:37:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:37:12","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:37:12","OPEN_FOR_INTERNAL","2020-11-11 18:37:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:37:12","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:37:12","OPEN_FOR_INTERNAL","2020-11-11 18:37:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:37:12","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:37:12","OPEN_FOR_INTERNAL","2020-11-11 18:37:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:37:17","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:37:17","OPEN_FOR_INTERNAL","2020-11-11 18:37:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:37:17","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=9&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":877,"customer_code":"C180877","identity_type":"PERSONAL","identity_id":"R938804(3)","title":"Ms","lastname":"Cameron","firstname":"Ekaterina","companyname":"","email":"info@nasonpearl.com","tel":"97337317","address":"Flat 2135, 21\/F, Tower 5, Hong Kong Parkview, 88 Tai Tam Reservoir Road, Hong Kong ","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3462.0","renew_rent_month":"1","renew_warehousing_date":"2020-10-01","renew_room_key":"190,40465,189,29022","renew_remark":"1 month contract. Storage rental paid by bank transfer on 8 Oct 2020. Storage deposit transferred from agreement A18-CT208853 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT209182, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"78","order_discount":[],"order_room":[{"room_id":"846","room_code":"S05","retail_price":"1857.0","discounted_price":"1857.00","location_id":"3"},{"room_id":"810","room_code":"Q07","retail_price":"1605.0","discounted_price":"1605.00","location_id":"3"}],"roughly_size":"44","total_retail_price":3462,"total_discounted_price":3462,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":3462,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-10-01","rent_from":"2020-10-01","rent_to":"2020-10-31","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on NOV 11 2020. Storage deposit transferred from agreement A18-CT209182 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3462,"final_order_total":3462,"location_id":"3","branch_id":"1","company_id":"1","room_key":"190,40465,189,29022","order_product":[],"pass":true}},"first_order_id":"4121","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> S05 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1857.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> Q07 <\/td>\r\n\t\t\t\t\t 4X5X7 <\/td>\r\n\t\t\t\t\t $1605.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"44","total_discounted_price":"3462.00","deposit":"0.00","total_retail_price":"3462.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:37:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",877,"NEW","A18-CT209540",3462,3462,0,0,"1","1",3462,3462,3462,"2020-11-11 18:37:18","0",null,null,null,"2020-10-01","2020-10-31","1 month contract. Storage rental paid by bank transfer on NOV 11 2020. Storage deposit transferred from agreement A18-CT209182 to this agreement.\r\n","2020-10-01","44",0,null,0,"0.00","2","2020-11-11 18:37:17","2","2020-11-11 18:37:17","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190,40465,189,29022","C180877","PERSONAL","Ms","RPthaial2IFX5OTQVN1g+A==","5j4q6ReeucnDk5XYC2qhww==","","rRXmSas1C74UhCIMAl4XVBNkmNxuyBYhPciKj+xVXn2vQd37Gl4JOgs8HGkmy+xJFTDVdTpVVL4FPjZ3S+Pjo17HXHrjXmDiJKqKzjzyVmbMcgqz6jBEyLIHEHGxlwsr","c+0bwcSjwgphezD5fySi+g==","k2\/+w1ZaM4nSEX\/8U65t74fzkbo4RpcfhFOMFpzQU3M=","2SUKxPo6VxWobmWOngKfJg==",null,1,"4121"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:37:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["9540","846","1857.0","1857.00","2","2020-11-11 18:37:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:37:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-10-01","2020-10-31","846"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-11-11 18:37:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["9540","810","1605.0","1605.00","2","2020-11-11 18:37:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:37:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-10-01","2020-10-31","810"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-11-11 18:37:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["9540",877,"SETTLED","A18-I209869","2020-11-11 18:37:17","2020-10-01","2","2020-11-11 18:37:17","2","2020-11-11 18:37:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:37:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["9869","RENT","\u9810\u7e73\u79df\u91d1",1,3462,"MO","1",3462,"2","2020-11-11 18:37:17","2","2020-11-11 18:37:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:37:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3462,0,"9869"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-11-11 18:37:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[877,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P209508","2020-11-11 18:37:17",3462,"2","2020-11-11 18:37:17","2","2020-11-11 18:37:17","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:37:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["9508","DEPOSIT",null,"PAID","2020-11-11 18:37:17",0,"2","2020-11-11 18:37:17","2","2020-11-11 18:37:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:37:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["9508","INVOICE","9869","PAID","2020-11-11 18:37:17",3462,"2","2020-11-11 18:37:17","2","2020-11-11 18:37:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:37:18","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:37:18","OPEN_FOR_INTERNAL","2020-11-11 18:37:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:37:18","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:37:18","OPEN_FOR_INTERNAL","2020-11-11 18:37:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:38:55","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:38:55","OPEN_FOR_INTERNAL","2020-11-11 18:38:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:39:47","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:39:47","OPEN_FOR_INTERNAL","2020-11-11 18:39:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:40:04","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:40:04","OPEN_FOR_INTERNAL","2020-11-11 18:40:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:41:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:41:28","OPEN_FOR_INTERNAL","2020-11-11 18:41:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:48:45","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:48:45","OPEN_FOR_INTERNAL","2020-11-11 18:48:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:49:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:49:28","OPEN_FOR_INTERNAL","2020-11-11 18:49:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:50:26","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:50:26","OPEN_FOR_INTERNAL","2020-11-11 18:50:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 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-11-11 18:50:44","OPEN_FOR_INTERNAL","2020-11-11 18:50:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:51:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:51:13","OPEN_FOR_INTERNAL","2020-11-11 18:51:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 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-11-11 18:51:18","OPEN_FOR_INTERNAL","2020-11-11 18:51:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:52:43","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:52:43","OPEN_FOR_INTERNAL","2020-11-11 18:52:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 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-11-11 18:52:48","OPEN_FOR_INTERNAL","2020-11-11 18:52:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 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-11-11 18:52:48","OPEN_FOR_INTERNAL","2020-11-11 18:52:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:52:49","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:52:49","OPEN_FOR_INTERNAL","2020-11-11 18:52:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 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-11-11 18:53:22","OPEN_FOR_INTERNAL","2020-11-11 18:53:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 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-11-11 18:53:22","OPEN_FOR_INTERNAL","2020-11-11 18:53:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:53:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 18:58:56","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 18:58:56","OPEN_FOR_INTERNAL","2020-11-11 18:58:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-11 19:08:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-11 19:08:27","OPEN_FOR_INTERNAL","2020-11-11 19:08:27"]},"data_before":[],"data_after":[],"step":1} *****