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

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

\u5009\u5eab\u7de8\u865f<\/td>\n	\u5c3a\u5bf8<\/td>\n	\u539f\u50f9(\u6708)<\/td>\n	\u512a\u60e0\u50f9(\u6708)<\/td>\n	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n	\u50f9\u683c<\/td>\n	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n	<\/td>\n <\/tr>
D16 <\/td>\n\t\t\t\t\t	4X3X4 <\/td>\n\t\t\t\t\t	$598.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"12","total_discounted_price":"539.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:57:17","login_id":"1","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` = ?, `discount_amount` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1","14","NEW","A12-CT2212035",598,539,1196,0,"6","6",4430,4430,4430,"2022-11-03 15:57:17","0",null,null,null,"2022-11-03","2023-05-02","","2022-11-03","12",0,null,0,"0","0","1","2022-11-03 15:57:16","1","2022-11-03 15:57:16","CASH","","","","CASH","","","",null,0,"","C220012","PERSONAL","Mr","KHskzBnhdzBUsg6kf2c6kQ==","JeOZEMNUNd9AIVJJXay9Yg==","","\/c07ypx0rrHw0toQ40xga6f7gvUwjV47TJrZPDl0lcujjauxHhjzgxW1grCUZtFx","m7yf6obPuRz4yDkAkV7HQg==","ievc43tdp7kuH1njljQW4RCGxKYYAwsNpQ\/Rt7qwq58=","sAKstd00DhW1v\/Xuw5WHPw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:57:17","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["12041","68 available_room_list_input","1","212","%","10.00",59.8,"1","2022-11-03 15:57:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:57:17","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["12041","212","598.0",538.2,"1","2022-11-03 15:57:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:57:17","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2022-11-03","2023-05-02","212"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2022-11-03 15:57:17","login_id":"1","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":["12041","A12-D226590","PAID",1196,0,"2023-05-02","2022-11-03 15:57:16","2022-11-03 15:57:16","1","2022-11-03 15:57:16","1","2022-11-03 15:57:16","14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:57:17","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["12041","14","SETTLED","A12-I220336","2022-11-03 15:57:16","2022-11-03","1","2022-11-03 15:57:16","1","2022-11-03 15:57:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:57:17","login_id":"1","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":["336","RENT","\u9810\u7e73\u79df\u91d1",1,539,"MO","1",539,"1","2022-11-03 15:57:16","1","2022-11-03 15:57:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:57:17","login_id":"1","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":["336","RENT","\u9810\u7e73\u79df\u91d1",2,539,"MO","1",539,"1","2022-11-03 15:57:16","1","2022-11-03 15:57:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:57:17","login_id":"1","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":["336","RENT","\u9810\u7e73\u79df\u91d1",3,539,"MO","1",539,"1","2022-11-03 15:57:16","1","2022-11-03 15:57:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:57:17","login_id":"1","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":["336","RENT","\u9810\u7e73\u79df\u91d1",4,539,"MO","1",539,"1","2022-11-03 15:57:16","1","2022-11-03 15:57:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:57:17","login_id":"1","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":["336","RENT","\u9810\u7e73\u79df\u91d1",5,539,"MO","1",539,"1","2022-11-03 15:57:16","1","2022-11-03 15:57:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:57:17","login_id":"1","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":["336","RENT","\u9810\u7e73\u79df\u91d1",6,539,"MO","1",539,"1","2022-11-03 15:57:16","1","2022-11-03 15:57:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:57:17","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3234,0,"336"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2022-11-03 15:57:17","login_id":"1","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":["14","CASH","","","","CASH","","","","PAID","P220230","2022-11-03 15:57:16",4430,"1","2022-11-03 15:57:16","1","2022-11-03 15:57:16","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:57:17","login_id":"1","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":["230","DEPOSIT","6596","PAID","2022-11-03 15:57:16",1196,"1","2022-11-03 15:57:16","1","2022-11-03 15:57:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:57:17","login_id":"1","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":["230","INVOICE","336","PAID","2022-11-03 15:57:16",3234,"1","2022-11-03 15:57:16","1","2022-11-03 15:57:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:57:18","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 15:57:18","OPEN_FOR_INTERNAL","2022-11-03 15:57:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:57:18","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 15:57:18","OPEN_FOR_INTERNAL","2022-11-03 15:57:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:57:22","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 15:57:22","OPEN_FOR_INTERNAL","2022-11-03 15:57:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:57:25","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 15:57:25","OPEN_FOR_INTERNAL","2022-11-03 15:57:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:57:30","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 15:57:30","OPEN_FOR_INTERNAL","2022-11-03 15:57:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:57:39","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 15:57:39","OPEN_FOR_INTERNAL","2022-11-03 15:57:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:57:39","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `amount` = ?, `balance` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":[12041,"14","SENT","A12-I220337",0,0,"2022-11-03 15:57:39","2022-11-03","1","2022-11-03 15:57:39","1","2022-11-03 15:57:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:57:39","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `remark` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["337","PENALTY",0,"PCS","1",0,"\u9000\u5009\u901a\u77e5\u8ce0\u511f","1","2022-11-03 15:57:39","1","2022-11-03 15:57:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:57:39","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 15:57:39","OPEN_FOR_INTERNAL","2022-11-03 15:57:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:57:42","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 15:57:42","OPEN_FOR_INTERNAL","2022-11-03 15:57:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:57:45","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 15:57:45","OPEN_FOR_INTERNAL","2022-11-03 15:57:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:58:00","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 15:58:00","OPEN_FOR_INTERNAL","2022-11-03 15:58:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:58:05","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 15:58:05","OPEN_FOR_INTERNAL","2022-11-03 15:58:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:58:11","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 15:58:11","OPEN_FOR_INTERNAL","2022-11-03 15:58:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:58:15","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 15:58:15","OPEN_FOR_INTERNAL","2022-11-03 15:58:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:58:19","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 15:58:19","OPEN_FOR_INTERNAL","2022-11-03 15:58:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:58:19","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 15:58:19","OPEN_FOR_INTERNAL","2022-11-03 15:58:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:58:20","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 15:58:20","OPEN_FOR_INTERNAL","2022-11-03 15:58:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:58:20","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 15:58:20","OPEN_FOR_INTERNAL","2022-11-03 15:58:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:58:24","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 15:58:24","OPEN_FOR_INTERNAL","2022-11-03 15:58:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 15:58:24","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 15:58:24","OPEN_FOR_INTERNAL","2022-11-03 15:58:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:03:34","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:03:34","OPEN_FOR_INTERNAL","2022-11-03 16:03:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:03:34","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:03:34","OPEN_FOR_INTERNAL","2022-11-03 16:03:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:03:35","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:03:35","OPEN_FOR_INTERNAL","2022-11-03 16:03:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:03:35","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:03:35","OPEN_FOR_INTERNAL","2022-11-03 16:03:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:03:35","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:03:35","OPEN_FOR_INTERNAL","2022-11-03 16:03:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:03:36","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:03:36","OPEN_FOR_INTERNAL","2022-11-03 16:03:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:03:37","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:03:37","OPEN_FOR_INTERNAL","2022-11-03 16:03:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:03:38","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:03:38","OPEN_FOR_INTERNAL","2022-11-03 16:03:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:03:38","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:03:38","OPEN_FOR_INTERNAL","2022-11-03 16:03:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:03:38","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:03:38","OPEN_FOR_INTERNAL","2022-11-03 16:03:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:03:40","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:03:40","OPEN_FOR_INTERNAL","2022-11-03 16:03:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:03:40","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:03:40","OPEN_FOR_INTERNAL","2022-11-03 16:03:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:08:04","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:08:04","OPEN_FOR_INTERNAL","2022-11-03 16:08:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:08:04","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:08:04","OPEN_FOR_INTERNAL","2022-11-03 16:08:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:08:04","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:08:04","OPEN_FOR_INTERNAL","2022-11-03 16:08:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:08:10","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:08:10","OPEN_FOR_INTERNAL","2022-11-03 16:08:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:08:10","login_id":"1","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"skyadmin","cmsloginid":"1","loginid":"1","cmsrole":"super_admin","role":"super_admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"x123456(7)","title":"Mr","lastname":"R","firstname":"W","companyname":"","email":"test@test.com","tel":"54325432","address":"Wah Shing Building","pass":true,"customer_id":"12","customer_code":"C220010","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"213","room_code":"D17","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":1196,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2990,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"discount_amount":"0","last_paid":"0","warehousing_date":"2022-11-03","rent_from":"2022-11-03","rent_to":"2023-02-02","delivery_service":"0","remark":"","paymethod":"CASH","paymethod2":"UNPAID","discount_deduct":0,"order_total":2990,"final_order_total":2990,"location_id":"1","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"selected_room_tr":"\n	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n	\n \n\n \n \n \n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> D17 <\/td>\n\t\t\t\t\t 4X3X4 <\/td>\n\t\t\t\t\t $598.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"12","total_discounted_price":"598.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:08:11","login_id":"1","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` = ?, `discount_amount` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1","12","NEW","A12-CT2212036",598,598,1196,0,"3","3",2990,2990,2990,"2022-11-03 16:08:11","0",null,null,null,"2022-11-03","2023-02-02","","2022-11-03","12",0,null,0,"0","0","1","2022-11-03 16:08:10","1","2022-11-03 16:08:10","CASH","","","","UNPAID","","","",null,0,"","C220010","PERSONAL","Mr","7LutgkIODYlTr8d+OWW14w==","v\/DgFKIQ6\/M55ywo8wV7Cg==","","0x458iGiF3wsSwSrEj5tJf0t1aSAI9YyXyEieytVW24=","Ix\/L\/L1UaMe4qEWrPL11Og==","I7YdzbMD3ivT4sxW8o4wWQ==","at4rb9Xcm\/gsKsfeCdhSEg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:08:11","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["12042","213","598.0","598.00","1","2022-11-03 16:08:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:08:11","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2022-11-03","2023-02-02","213"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2022-11-03 16:08:11","login_id":"1","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":["12042","A12-D226597","PAID",1196,0,"2023-02-02","2022-11-03 16:08:10","2022-11-03 16:08:10","1","2022-11-03 16:08:10","1","2022-11-03 16:08:10","12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:08:11","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["12042","12","NEW","A12-I220338","2022-11-03 16:08:10","2022-11-03","1","2022-11-03 16:08:10","1","2022-11-03 16:08:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:08:11","login_id":"1","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":["338","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"1","2022-11-03 16:08:10","1","2022-11-03 16:08:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:08:11","login_id":"1","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":["338","RENT","\u9810\u7e73\u79df\u91d1",2,598,"MO","1",598,"1","2022-11-03 16:08:10","1","2022-11-03 16:08:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:08:11","login_id":"1","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":["338","RENT","\u9810\u7e73\u79df\u91d1",3,598,"MO","1",598,"1","2022-11-03 16:08:10","1","2022-11-03 16:08:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:08:11","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1794,598,"338"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2022-11-03 16:08:11","login_id":"1","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":["12","CASH","","","","UNPAID","","","","PAID","P220231","2022-11-03 16:08:10",1196,"1","2022-11-03 16:08:10","1","2022-11-03 16:08:10","DEPOSIT"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:08:11","login_id":"1","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":["231","DEPOSIT","6597","PAID","2022-11-03 16:08:10",1196,"1","2022-11-03 16:08:10","1","2022-11-03 16:08:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:08:11","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:08:11","OPEN_FOR_INTERNAL","2022-11-03 16:08:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:08:12","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:08:12","OPEN_FOR_INTERNAL","2022-11-03 16:08:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:13:32","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:13:32","OPEN_FOR_INTERNAL","2022-11-03 16:13:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:14:36","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:14:36","OPEN_FOR_INTERNAL","2022-11-03 16:14:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:16:09","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:16:09","OPEN_FOR_INTERNAL","2022-11-03 16:16:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:16:10","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `amount` = ?, `balance` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":[12042,"12","SENT","A12-I220339",598,598,"2022-11-03 16:16:09","2023-03-03","1","2022-11-03 16:16:09","1","2022-11-03 16:16:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:16:10","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `remark` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["339","PENALTY",598,"PCS","1",598,"\u9000\u5009\u901a\u77e5\u8ce0\u511f","1","2022-11-03 16:16:09","1","2022-11-03 16:16:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:16:10","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `remark` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["12","CASH","","","","PAID","P220232","2022-11-03 16:16:09",1196,"\u9000\u5009\u4ed8\u6b3e\u3002","1","2022-11-03 16:16:09","1","2022-11-03 16:16:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:16:10","login_id":"1","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":["232","INVOICE","339","PAID","2022-11-03 16:16:09","598.0","1","2022-11-03 16:16:09","1","2022-11-03 16:16:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:16:10","login_id":"1","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":["232","INVOICE","338","PAID","2022-11-03 16:16:09","598.0","1","2022-11-03 16:16:09","1","2022-11-03 16:16:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:16:10","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:16:10","OPEN_FOR_INTERNAL","2022-11-03 16:16:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:16:13","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:16:13","OPEN_FOR_INTERNAL","2022-11-03 16:16:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:16:45","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:16:45","OPEN_FOR_INTERNAL","2022-11-03 16:16:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:16:48","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:16:48","OPEN_FOR_INTERNAL","2022-11-03 16:16:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:16:51","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:16:51","OPEN_FOR_INTERNAL","2022-11-03 16:16:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:16:56","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:16:56","OPEN_FOR_INTERNAL","2022-11-03 16:16:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:16:56","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:16:56","OPEN_FOR_INTERNAL","2022-11-03 16:16:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:16:56","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:16:56","OPEN_FOR_INTERNAL","2022-11-03 16:16:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:16:57","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:16:57","OPEN_FOR_INTERNAL","2022-11-03 16:16:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:03","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:03","OPEN_FOR_INTERNAL","2022-11-03 16:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:04","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:04","OPEN_FOR_INTERNAL","2022-11-03 16:17:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:04","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:04","OPEN_FOR_INTERNAL","2022-11-03 16:17:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:04","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:04","OPEN_FOR_INTERNAL","2022-11-03 16:17:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:06","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:06","OPEN_FOR_INTERNAL","2022-11-03 16:17:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:06","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:06","OPEN_FOR_INTERNAL","2022-11-03 16:17:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:08","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:08","OPEN_FOR_INTERNAL","2022-11-03 16:17:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:09","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:09","OPEN_FOR_INTERNAL","2022-11-03 16:17:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:10","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:10","OPEN_FOR_INTERNAL","2022-11-03 16:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:10","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:10","OPEN_FOR_INTERNAL","2022-11-03 16:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:10","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:10","OPEN_FOR_INTERNAL","2022-11-03 16:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:10","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:10","OPEN_FOR_INTERNAL","2022-11-03 16:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:13","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:13","OPEN_FOR_INTERNAL","2022-11-03 16:17:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:13","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:13","OPEN_FOR_INTERNAL","2022-11-03 16:17:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:14","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:14","OPEN_FOR_INTERNAL","2022-11-03 16:17:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:14","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:14","OPEN_FOR_INTERNAL","2022-11-03 16:17:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:15","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:15","OPEN_FOR_INTERNAL","2022-11-03 16:17:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:15","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:15","OPEN_FOR_INTERNAL","2022-11-03 16:17:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:19","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:19","OPEN_FOR_INTERNAL","2022-11-03 16:17:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:19","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:19","OPEN_FOR_INTERNAL","2022-11-03 16:17:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:19","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:19","OPEN_FOR_INTERNAL","2022-11-03 16:17:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:27","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:27","OPEN_FOR_INTERNAL","2022-11-03 16:17:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:27","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:27","OPEN_FOR_INTERNAL","2022-11-03 16:17:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:27","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:27","OPEN_FOR_INTERNAL","2022-11-03 16:17:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:30","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:30","OPEN_FOR_INTERNAL","2022-11-03 16:17:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:31","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:31","OPEN_FOR_INTERNAL","2022-11-03 16:17:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:31","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:31","OPEN_FOR_INTERNAL","2022-11-03 16:17:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:31","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:31","OPEN_FOR_INTERNAL","2022-11-03 16:17:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:32","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:32","OPEN_FOR_INTERNAL","2022-11-03 16:17:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:32","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:32","OPEN_FOR_INTERNAL","2022-11-03 16:17:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:34","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:34","OPEN_FOR_INTERNAL","2022-11-03 16:17:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:34","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:34","OPEN_FOR_INTERNAL","2022-11-03 16:17:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:45","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:45","OPEN_FOR_INTERNAL","2022-11-03 16:17:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:45","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:45","OPEN_FOR_INTERNAL","2022-11-03 16:17:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:46","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:46","OPEN_FOR_INTERNAL","2022-11-03 16:17:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:17:46","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:17:46","OPEN_FOR_INTERNAL","2022-11-03 16:17:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:18:01","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:18:01","OPEN_FOR_INTERNAL","2022-11-03 16:18:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:18:01","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:18:01","OPEN_FOR_INTERNAL","2022-11-03 16:18:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:18:01","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:18:01","OPEN_FOR_INTERNAL","2022-11-03 16:18:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:15","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:20:15","OPEN_FOR_INTERNAL","2022-11-03 16:20:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:15","login_id":"1","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"skyadmin","cmsloginid":"1","loginid":"1","cmsrole":"super_admin","role":"super_admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"x123456(7)","title":"Mr","lastname":"R","firstname":"W","companyname":"","email":"test@test.com","tel":"54325432","address":"Wah Shing Building","pass":true,"customer_id":"12","customer_code":"C220010","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"214","room_code":"D18","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":1196,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2990,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"discount_amount":"0","last_paid":"0","warehousing_date":"2022-11-03","rent_from":"2022-11-03","rent_to":"2023-02-02","delivery_service":"0","remark":"","paymethod":"CASH","paymethod2":"UNPAID","discount_deduct":0,"order_total":2990,"final_order_total":2990,"location_id":"1","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n\n \n \n \n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> D18 <\/td>\n\t\t\t\t\t 4X3X4 <\/td>\n\t\t\t\t\t $598.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"12","total_discounted_price":"598.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:16","login_id":"1","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` = ?, `discount_amount` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1","12","NEW","A12-CT2212037",598,598,1196,0,"3","3",2990,2990,2990,"2022-11-03 16:20:16","0",null,null,null,"2022-11-03","2023-02-02","","2022-11-03","12",0,null,0,"0","0","1","2022-11-03 16:20:15","1","2022-11-03 16:20:15","CASH","","","","UNPAID","","","",null,0,"","C220010","PERSONAL","Mr","7LutgkIODYlTr8d+OWW14w==","v\/DgFKIQ6\/M55ywo8wV7Cg==","","0x458iGiF3wsSwSrEj5tJf0t1aSAI9YyXyEieytVW24=","Ix\/L\/L1UaMe4qEWrPL11Og==","I7YdzbMD3ivT4sxW8o4wWQ==","at4rb9Xcm\/gsKsfeCdhSEg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:16","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["12043","214","598.0","598.00","1","2022-11-03 16:20:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:16","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2022-11-03","2023-02-02","214"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2022-11-03 16:20:16","login_id":"1","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":["12043","A12-D226598","PAID",1196,0,"2023-02-02","2022-11-03 16:20:15","2022-11-03 16:20:15","1","2022-11-03 16:20:15","1","2022-11-03 16:20:15","12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:16","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["12043","12","NEW","A12-I220340","2022-11-03 16:20:15","2022-11-03","1","2022-11-03 16:20:15","1","2022-11-03 16:20:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:16","login_id":"1","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":["340","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"1","2022-11-03 16:20:15","1","2022-11-03 16:20:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:16","login_id":"1","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":["340","RENT","\u9810\u7e73\u79df\u91d1",2,598,"MO","1",598,"1","2022-11-03 16:20:15","1","2022-11-03 16:20:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:16","login_id":"1","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":["340","RENT","\u9810\u7e73\u79df\u91d1",3,598,"MO","1",598,"1","2022-11-03 16:20:15","1","2022-11-03 16:20:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:29","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:20:29","OPEN_FOR_INTERNAL","2022-11-03 16:20:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:29","login_id":"1","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"skyadmin","cmsloginid":"1","loginid":"1","cmsrole":"super_admin","role":"super_admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"x123456(7)","title":"Mr","lastname":"R","firstname":"W","companyname":"","email":"test@test.com","tel":"54325432","address":"Wah Shing Building","pass":true,"customer_id":"12","customer_code":"C220010","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"214","room_code":"D18","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":1196,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2990,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"discount_amount":"0","last_paid":"0","warehousing_date":"2022-11-03","rent_from":"2022-11-03","rent_to":"2023-02-02","delivery_service":"0","remark":"","paymethod":"CASH","paymethod2":"UNPAID","discount_deduct":0,"order_total":2990,"final_order_total":2990,"location_id":"1","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n\n \n \n \n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> D18 <\/td>\n\t\t\t\t\t 4X3X4 <\/td>\n\t\t\t\t\t $598.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"12","total_discounted_price":"598.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:30","login_id":"1","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` = ?, `discount_amount` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1","12","NEW","A12-CT2212037",598,598,1196,0,"3","3",2990,2990,2990,"2022-11-03 16:20:30","0",null,null,null,"2022-11-03","2023-02-02","","2022-11-03","12",0,null,0,"0","0","1","2022-11-03 16:20:29","1","2022-11-03 16:20:29","CASH","","","","UNPAID","","","",null,0,"","C220010","PERSONAL","Mr","7LutgkIODYlTr8d+OWW14w==","v\/DgFKIQ6\/M55ywo8wV7Cg==","","0x458iGiF3wsSwSrEj5tJf0t1aSAI9YyXyEieytVW24=","Ix\/L\/L1UaMe4qEWrPL11Og==","I7YdzbMD3ivT4sxW8o4wWQ==","at4rb9Xcm\/gsKsfeCdhSEg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:30","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["12044","214","598.0","598.00","1","2022-11-03 16:20:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:30","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2022-11-03","2023-02-02","214"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2022-11-03 16:20:30","login_id":"1","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":["12044","A12-D226598","PAID",1196,0,"2023-02-02","2022-11-03 16:20:29","2022-11-03 16:20:29","1","2022-11-03 16:20:29","1","2022-11-03 16:20:29","12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:30","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["12044","12","NEW","A12-I220340","2022-11-03 16:20:29","2022-11-03","1","2022-11-03 16:20:29","1","2022-11-03 16:20:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:30","login_id":"1","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":["341","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"1","2022-11-03 16:20:29","1","2022-11-03 16:20:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:30","login_id":"1","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":["341","RENT","\u9810\u7e73\u79df\u91d1",2,598,"MO","1",598,"1","2022-11-03 16:20:29","1","2022-11-03 16:20:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:30","login_id":"1","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":["341","RENT","\u9810\u7e73\u79df\u91d1",3,598,"MO","1",598,"1","2022-11-03 16:20:29","1","2022-11-03 16:20:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:30","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:20:30","OPEN_FOR_INTERNAL","2022-11-03 16:20:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:46","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:20:46","OPEN_FOR_INTERNAL","2022-11-03 16:20:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:46","login_id":"1","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"skyadmin","cmsloginid":"1","loginid":"1","cmsrole":"super_admin","role":"super_admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"x123456(7)","title":"Mr","lastname":"R","firstname":"W","companyname":"","email":"test@test.com","tel":"54325432","address":"Wah Shing Building","pass":true,"customer_id":"12","customer_code":"C220010","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"214","room_code":"D18","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":1196,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2990,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"discount_amount":"0","last_paid":"0","warehousing_date":"2022-11-03","rent_from":"2022-11-03","rent_to":"2023-02-02","delivery_service":"0","remark":"","paymethod":"CASH","paymethod2":"UNPAID","discount_deduct":0,"order_total":2990,"final_order_total":2990,"location_id":"1","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n\n \n \n \n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> D18 <\/td>\n\t\t\t\t\t 4X3X4 <\/td>\n\t\t\t\t\t $598.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"12","total_discounted_price":"598.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:46","login_id":"1","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` = ?, `discount_amount` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1","12","NEW","A12-CT2212037",598,598,1196,0,"3","3",2990,2990,2990,"2022-11-03 16:20:46","0",null,null,null,"2022-11-03","2023-02-02","","2022-11-03","12",0,null,0,"0","0","1","2022-11-03 16:20:46","1","2022-11-03 16:20:46","CASH","","","","UNPAID","","","",null,0,"","C220010","PERSONAL","Mr","7LutgkIODYlTr8d+OWW14w==","v\/DgFKIQ6\/M55ywo8wV7Cg==","","0x458iGiF3wsSwSrEj5tJf0t1aSAI9YyXyEieytVW24=","Ix\/L\/L1UaMe4qEWrPL11Og==","I7YdzbMD3ivT4sxW8o4wWQ==","at4rb9Xcm\/gsKsfeCdhSEg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:46","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["12045","214","598.0","598.00","1","2022-11-03 16:20:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:46","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2022-11-03","2023-02-02","214"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2022-11-03 16:20:46","login_id":"1","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":["12045","A12-D226598","PAID",1196,0,"2023-02-02","2022-11-03 16:20:46","2022-11-03 16:20:46","1","2022-11-03 16:20:46","1","2022-11-03 16:20:46","12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:46","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["12045","12","NEW","A12-I220340","2022-11-03 16:20:46","2022-11-03","1","2022-11-03 16:20:46","1","2022-11-03 16:20:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:46","login_id":"1","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":["342","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"1","2022-11-03 16:20:46","1","2022-11-03 16:20:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:46","login_id":"1","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":["342","RENT","\u9810\u7e73\u79df\u91d1",2,598,"MO","1",598,"1","2022-11-03 16:20:46","1","2022-11-03 16:20:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:20:47","login_id":"1","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":["342","RENT","\u9810\u7e73\u79df\u91d1",3,598,"MO","1",598,"1","2022-11-03 16:20:46","1","2022-11-03 16:20:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:21:14","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:21:14","OPEN_FOR_INTERNAL","2022-11-03 16:21:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:21:14","login_id":"1","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"skyadmin","cmsloginid":"1","loginid":"1","cmsrole":"super_admin","role":"super_admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"x123456(7)","title":"Mr","lastname":"R","firstname":"W","companyname":"","email":"test@test.com","tel":"54325432","address":"Wah Shing Building","pass":true,"customer_id":"12","customer_code":"C220010","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"214","room_code":"D18","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":1196,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2990,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"discount_amount":"0","last_paid":"0","warehousing_date":"2022-11-03","rent_from":"2022-11-03","rent_to":"2023-02-02","delivery_service":"0","remark":"","paymethod":"CASH","paymethod2":"UNPAID","discount_deduct":0,"order_total":2990,"final_order_total":2990,"location_id":"1","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n\n \n \n \n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> D18 <\/td>\n\t\t\t\t\t 4X3X4 <\/td>\n\t\t\t\t\t $598.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"12","total_discounted_price":"598.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:21:15","login_id":"1","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` = ?, `discount_amount` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1","12","NEW","A12-CT2212037",598,598,1196,0,"3","3",2990,2990,2990,"2022-11-03 16:21:15","0",null,null,null,"2022-11-03","2023-02-02","","2022-11-03","12",0,null,0,"0","0","1","2022-11-03 16:21:14","1","2022-11-03 16:21:14","CASH","","","","UNPAID","","","",null,0,"","C220010","PERSONAL","Mr","7LutgkIODYlTr8d+OWW14w==","v\/DgFKIQ6\/M55ywo8wV7Cg==","","0x458iGiF3wsSwSrEj5tJf0t1aSAI9YyXyEieytVW24=","Ix\/L\/L1UaMe4qEWrPL11Og==","I7YdzbMD3ivT4sxW8o4wWQ==","at4rb9Xcm\/gsKsfeCdhSEg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:21:15","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["12046","214","598.0","598.00","1","2022-11-03 16:21:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:21:15","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2022-11-03","2023-02-02","214"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2022-11-03 16:21:15","login_id":"1","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":["12046","A12-D226598","PAID",1196,0,"2023-02-02","2022-11-03 16:21:14","2022-11-03 16:21:14","1","2022-11-03 16:21:14","1","2022-11-03 16:21:14","12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:21:15","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["12046","12","NEW","A12-I220340","2022-11-03 16:21:14","2022-11-03","1","2022-11-03 16:21:14","1","2022-11-03 16:21:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:21:15","login_id":"1","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":["343","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"1","2022-11-03 16:21:14","1","2022-11-03 16:21:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:21:15","login_id":"1","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":["343","RENT","\u9810\u7e73\u79df\u91d1",2,598,"MO","1",598,"1","2022-11-03 16:21:14","1","2022-11-03 16:21:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:21:15","login_id":"1","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":["343","RENT","\u9810\u7e73\u79df\u91d1",3,598,"MO","1",598,"1","2022-11-03 16:21:14","1","2022-11-03 16:21:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:39:56","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:39:56","OPEN_FOR_INTERNAL","2022-11-03 16:39:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:40:33","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:40:33","OPEN_FOR_INTERNAL","2022-11-03 16:40:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:41:22","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:41:22","OPEN_FOR_INTERNAL","2022-11-03 16:41:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:41:27","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:41:27","OPEN_FOR_INTERNAL","2022-11-03 16:41:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:41:31","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:41:31","OPEN_FOR_INTERNAL","2022-11-03 16:41:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:41:36","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:41:36","OPEN_FOR_INTERNAL","2022-11-03 16:41:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:41:36","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:41:36","OPEN_FOR_INTERNAL","2022-11-03 16:41:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:41:37","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:41:37","OPEN_FOR_INTERNAL","2022-11-03 16:41:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:41:37","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:41:37","OPEN_FOR_INTERNAL","2022-11-03 16:41:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:41:39","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:41:39","OPEN_FOR_INTERNAL","2022-11-03 16:41:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:41:39","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:41:39","OPEN_FOR_INTERNAL","2022-11-03 16:41:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:41:42","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:41:42","OPEN_FOR_INTERNAL","2022-11-03 16:41:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:41:42","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:41:42","OPEN_FOR_INTERNAL","2022-11-03 16:41:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:41:42","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:41:42","OPEN_FOR_INTERNAL","2022-11-03 16:41:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:41:42","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:41:42","OPEN_FOR_INTERNAL","2022-11-03 16:41:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:41:43","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:41:43","OPEN_FOR_INTERNAL","2022-11-03 16:41:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:41:43","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:41:43","OPEN_FOR_INTERNAL","2022-11-03 16:41:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:41:52","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:41:52","OPEN_FOR_INTERNAL","2022-11-03 16:41:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:41:59","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:41:59","OPEN_FOR_INTERNAL","2022-11-03 16:41:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:41:59","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:41:59","OPEN_FOR_INTERNAL","2022-11-03 16:41:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:42:05","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:42:05","OPEN_FOR_INTERNAL","2022-11-03 16:42:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:42:05","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:42:05","OPEN_FOR_INTERNAL","2022-11-03 16:42:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:42:06","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:42:06","OPEN_FOR_INTERNAL","2022-11-03 16:42:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:42:06","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:42:06","OPEN_FOR_INTERNAL","2022-11-03 16:42:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:42:06","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:42:06","OPEN_FOR_INTERNAL","2022-11-03 16:42:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:42:07","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:42:07","OPEN_FOR_INTERNAL","2022-11-03 16:42:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:42:16","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:42:16","OPEN_FOR_INTERNAL","2022-11-03 16:42:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:42:16","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:42:16","OPEN_FOR_INTERNAL","2022-11-03 16:42:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:42:16","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:42:16","OPEN_FOR_INTERNAL","2022-11-03 16:42:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:42:22","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:42:22","OPEN_FOR_INTERNAL","2022-11-03 16:42:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:42:22","login_id":"1","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"skyadmin","cmsloginid":"1","loginid":"1","cmsrole":"super_admin","role":"super_admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"x123456(7)","title":"Mr","lastname":"R","firstname":"W","companyname":"","email":"test@test.com","tel":"54325432","address":"Wah Shing Building","pass":true,"customer_id":"12","customer_code":"C220010","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"33","room_code":"A33","retail_price":"1228.0","discounted_price":"1228.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1228,"total_discounted_price":1228,"deposit":2456,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":6140,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"discount_amount":"0","last_paid":"0","warehousing_date":"2022-11-03","rent_from":"2022-11-03","rent_to":"2023-02-02","delivery_service":"0","remark":"","paymethod":"CASH","paymethod2":"UNPAID","discount_deduct":0,"order_total":6140,"final_order_total":6140,"location_id":"1","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n\n \n \n \n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> A33 <\/td>\n\t\t\t\t\t 4X4X8 <\/td>\n\t\t\t\t\t $1228.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"16","total_discounted_price":"1228.00","deposit":"2456.00","total_retail_price":"1228.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:42:23","login_id":"1","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` = ?, `discount_amount` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1","12","NEW","A12-CT2212037",1228,1228,2456,0,"3","3",6140,6140,6140,"2022-11-03 16:42:23","0",null,null,null,"2022-11-03","2023-02-02","","2022-11-03","16",0,null,0,"0","0","1","2022-11-03 16:42:22","1","2022-11-03 16:42:22","CASH","","","","UNPAID","","","",null,0,"","C220010","PERSONAL","Mr","7LutgkIODYlTr8d+OWW14w==","v\/DgFKIQ6\/M55ywo8wV7Cg==","","0x458iGiF3wsSwSrEj5tJf0t1aSAI9YyXyEieytVW24=","Ix\/L\/L1UaMe4qEWrPL11Og==","I7YdzbMD3ivT4sxW8o4wWQ==","at4rb9Xcm\/gsKsfeCdhSEg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:42:23","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["12047","33","1228.0","1228.00","1","2022-11-03 16:42:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:42:23","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2022-11-03","2023-02-02","33"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2022-11-03 16:42:23","login_id":"1","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":["12047","A12-D226598","PAID",2456,0,"2023-02-02","2022-11-03 16:42:22","2022-11-03 16:42:22","1","2022-11-03 16:42:22","1","2022-11-03 16:42:22","12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:42:23","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["12047","12","NEW","A12-I220340","2022-11-03 16:42:22","2022-11-03","1","2022-11-03 16:42:22","1","2022-11-03 16:42:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:42:23","login_id":"1","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":["344","RENT","\u9810\u7e73\u79df\u91d1",1,1228,"MO","1",1228,"1","2022-11-03 16:42:22","1","2022-11-03 16:42:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:42:23","login_id":"1","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":["344","RENT","\u9810\u7e73\u79df\u91d1",2,1228,"MO","1",1228,"1","2022-11-03 16:42:22","1","2022-11-03 16:42:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:42:23","login_id":"1","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":["344","RENT","\u9810\u7e73\u79df\u91d1",3,1228,"MO","1",1228,"1","2022-11-03 16:42:22","1","2022-11-03 16:42:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:42:23","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3684,1228,"344"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2022-11-03 16:42:23","login_id":"1","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":["12","CASH","","","","UNPAID","","","","PAID","P220233","2022-11-03 16:42:22",2456,"1","2022-11-03 16:42:22","1","2022-11-03 16:42:22","DEPOSIT"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:42:23","login_id":"1","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":["233","DEPOSIT","6602","PAID","2022-11-03 16:42:22",2456,"1","2022-11-03 16:42:22","1","2022-11-03 16:42:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:42:23","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:42:23","OPEN_FOR_INTERNAL","2022-11-03 16:42:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:42:24","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:42:24","OPEN_FOR_INTERNAL","2022-11-03 16:42:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:42:36","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:42:36","OPEN_FOR_INTERNAL","2022-11-03 16:42:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:42:41","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:42:41","OPEN_FOR_INTERNAL","2022-11-03 16:42:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:43:22","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:43:22","OPEN_FOR_INTERNAL","2022-11-03 16:43:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:43:22","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `amount` = ?, `balance` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":[12047,"12","SENT","A12-I220345",44,44,"2022-11-03 16:43:22","2023-02-03","1","2022-11-03 16:43:22","1","2022-11-03 16:43:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:43:22","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `remark` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["345","PENALTY",44,"PCS","1",44,"\u9000\u5009\u901a\u77e5\u8ce0\u511f","1","2022-11-03 16:43:22","1","2022-11-03 16:43:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:43:22","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `remark` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["12","CASH","","","","PAID","P220234","2022-11-03 16:43:22",1272,"\u4f7f\u7528\u6309\u91d1($2,456.00)\u652f\u4ed8\u90e8\u4efd\u6b3e\u9805\u3002","1","2022-11-03 16:43:22","1","2022-11-03 16:43:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:43:22","login_id":"1","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":["234","INVOICE","345","PAID","2022-11-03 16:43:22","44.0","1","2022-11-03 16:43:22","1","2022-11-03 16:43:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:43:22","login_id":"1","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":["234","INVOICE","344","PAID","2022-11-03 16:43:22","1228.0","1","2022-11-03 16:43:22","1","2022-11-03 16:43:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:43:58","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:43:58","OPEN_FOR_INTERNAL","2022-11-03 16:43:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:44:25","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:44:25","OPEN_FOR_INTERNAL","2022-11-03 16:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:44:25","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `amount` = ?, `balance` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":[12047,"12","SENT","A12-I220345",44,44,"2022-11-03 16:44:25","2023-02-03","1","2022-11-03 16:44:25","1","2022-11-03 16:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:44:25","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `remark` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["346","PENALTY",44,"PCS","1",44,"\u9000\u5009\u901a\u77e5\u8ce0\u511f","1","2022-11-03 16:44:25","1","2022-11-03 16:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:44:25","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:44:25","OPEN_FOR_INTERNAL","2022-11-03 16:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:46:38","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:46:38","OPEN_FOR_INTERNAL","2022-11-03 16:46:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:46:48","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:46:48","OPEN_FOR_INTERNAL","2022-11-03 16:46:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:46:56","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:46:56","OPEN_FOR_INTERNAL","2022-11-03 16:46:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:46:59","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:46:59","OPEN_FOR_INTERNAL","2022-11-03 16:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:46:59","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:46:59","OPEN_FOR_INTERNAL","2022-11-03 16:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:47:00","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:47:00","OPEN_FOR_INTERNAL","2022-11-03 16:47:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:47:00","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:47:00","OPEN_FOR_INTERNAL","2022-11-03 16:47:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:47:03","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:47:03","OPEN_FOR_INTERNAL","2022-11-03 16:47:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:47:03","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:47:03","OPEN_FOR_INTERNAL","2022-11-03 16:47:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:47:06","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:47:06","OPEN_FOR_INTERNAL","2022-11-03 16:47:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:47:08","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:47:08","OPEN_FOR_INTERNAL","2022-11-03 16:47:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:47:10","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:47:10","OPEN_FOR_INTERNAL","2022-11-03 16:47:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:47:10","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:47:10","OPEN_FOR_INTERNAL","2022-11-03 16:47:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:47:12","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:47:12","OPEN_FOR_INTERNAL","2022-11-03 16:47:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:47:12","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:47:12","OPEN_FOR_INTERNAL","2022-11-03 16:47:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:58:15","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:58:15","OPEN_FOR_INTERNAL","2022-11-03 16:58:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:58:15","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:58:15","OPEN_FOR_INTERNAL","2022-11-03 16:58:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:58:16","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:58:16","OPEN_FOR_INTERNAL","2022-11-03 16:58:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:58:22","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:58:22","OPEN_FOR_INTERNAL","2022-11-03 16:58:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:58:22","login_id":"1","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"skyadmin","cmsloginid":"1","loginid":"1","cmsrole":"super_admin","role":"super_admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"y123456(7)","title":"Mr","lastname":"DOE","firstname":"John","companyname":"","email":"johndoe123@gmail.com","tel":"56785678","address":"11\/F., Wah Shing Building, Kwun Tong, Kowloon","pass":true,"customer_id":"14","customer_code":"C220012","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"34","room_code":"A34","retail_price":"1228.0","discounted_price":"1228.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1228,"total_discounted_price":1228,"deposit":2456,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":3684,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"discount_amount":"0","last_paid":"0","warehousing_date":"2022-11-03","rent_from":"2022-11-03","rent_to":"2022-12-02","delivery_service":"0","remark":"","paymethod":"CASH","paymethod2":"UNPAID","discount_deduct":0,"order_total":3684,"final_order_total":3684,"location_id":"1","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n\n \n \n \n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> A34 <\/td>\n\t\t\t\t\t 4X4X8 <\/td>\n\t\t\t\t\t $1228.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"16","total_discounted_price":"1228.00","deposit":"2456.00","total_retail_price":"1228.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:58:23","login_id":"1","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` = ?, `discount_amount` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1","14","NEW","A12-CT2212038",1228,1228,2456,0,"1","1",3684,3684,3684,"2022-11-03 16:58:23","0",null,null,null,"2022-11-03","2022-12-02","","2022-11-03","16",0,null,0,"0","0","1","2022-11-03 16:58:22","1","2022-11-03 16:58:22","CASH","","","","UNPAID","","","",null,0,"","C220012","PERSONAL","Mr","KHskzBnhdzBUsg6kf2c6kQ==","JeOZEMNUNd9AIVJJXay9Yg==","","\/c07ypx0rrHw0toQ40xga6f7gvUwjV47TJrZPDl0lcujjauxHhjzgxW1grCUZtFx","m7yf6obPuRz4yDkAkV7HQg==","ievc43tdp7kuH1njljQW4RCGxKYYAwsNpQ\/Rt7qwq58=","sAKstd00DhW1v\/Xuw5WHPw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:58:23","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["12048","34","1228.0","1228.00","1","2022-11-03 16:58:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:58:23","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2022-11-03","2022-12-02","34"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2022-11-03 16:58:23","login_id":"1","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":["12048","A12-D226603","PAID",2456,0,"2022-12-02","2022-11-03 16:58:22","2022-11-03 16:58:22","1","2022-11-03 16:58:22","1","2022-11-03 16:58:22","14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:58:23","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["12048","14","NEW","A12-I220347","2022-11-03 16:58:22","2022-11-03","1","2022-11-03 16:58:22","1","2022-11-03 16:58:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:58:23","login_id":"1","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":["347","RENT","\u9810\u7e73\u79df\u91d1",1,1228,"MO","1",1228,"1","2022-11-03 16:58:22","1","2022-11-03 16:58:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:58:23","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1228,1228,"347"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2022-11-03 16:58:23","login_id":"1","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":["14","CASH","","","","UNPAID","","","","PAID","P220234","2022-11-03 16:58:22",2456,"1","2022-11-03 16:58:22","1","2022-11-03 16:58:22","DEPOSIT"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:58:23","login_id":"1","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":["235","DEPOSIT","6603","PAID","2022-11-03 16:58:22",2456,"1","2022-11-03 16:58:22","1","2022-11-03 16:58:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:58:24","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:58:24","OPEN_FOR_INTERNAL","2022-11-03 16:58:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:58:24","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:58:24","OPEN_FOR_INTERNAL","2022-11-03 16:58:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:58:30","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:58:30","OPEN_FOR_INTERNAL","2022-11-03 16:58:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 16:58:46","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 16:58:46","OPEN_FOR_INTERNAL","2022-11-03 16:58:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:31:31","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:31:31","OPEN_FOR_INTERNAL","2022-11-03 17:31:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:31:32","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `amount` = ?, `balance` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":[12048,"14","SENT","A12-I220348",0,0,"2022-11-03 17:31:31","2022-11-03","1","2022-11-03 17:31:31","1","2022-11-03 17:31:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:31:32","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `remark` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["348","PENALTY",0,"PCS","1",0,"\u9000\u5009\u901a\u77e5\u8ce0\u511f","1","2022-11-03 17:31:31","1","2022-11-03 17:31:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:31:32","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `remark` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["14","CASH","","","","PAID","P220236","2022-11-03 17:31:31",1228,"\u9000\u5009\u4ed8\u6b3e\u3002","1","2022-11-03 17:31:31","1","2022-11-03 17:31:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:31:32","login_id":"1","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":["236","INVOICE","347","PAID","2022-11-03 17:31:31","1228.0","1","2022-11-03 17:31:31","1","2022-11-03 17:31:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:31:32","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:31:32","OPEN_FOR_INTERNAL","2022-11-03 17:31:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:37:09","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:37:09","OPEN_FOR_INTERNAL","2022-11-03 17:37:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:37:16","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:37:16","OPEN_FOR_INTERNAL","2022-11-03 17:37:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:37:19","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:37:19","OPEN_FOR_INTERNAL","2022-11-03 17:37:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:37:30","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:37:30","OPEN_FOR_INTERNAL","2022-11-03 17:37:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:37:59","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:37:58","OPEN_FOR_INTERNAL","2022-11-03 17:37:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:38:11","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:38:11","OPEN_FOR_INTERNAL","2022-11-03 17:38:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:38:18","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:38:18","OPEN_FOR_INTERNAL","2022-11-03 17:38:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:38:20","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:38:20","OPEN_FOR_INTERNAL","2022-11-03 17:38:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:38:22","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:38:22","OPEN_FOR_INTERNAL","2022-11-03 17:38:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:38:27","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:38:27","OPEN_FOR_INTERNAL","2022-11-03 17:38:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:38:31","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:38:31","OPEN_FOR_INTERNAL","2022-11-03 17:38:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:38:34","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:38:34","OPEN_FOR_INTERNAL","2022-11-03 17:38:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:38:44","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:38:44","OPEN_FOR_INTERNAL","2022-11-03 17:38:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:38:46","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:38:46","OPEN_FOR_INTERNAL","2022-11-03 17:38:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:38:47","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:38:47","OPEN_FOR_INTERNAL","2022-11-03 17:38:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:38:47","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:38:47","OPEN_FOR_INTERNAL","2022-11-03 17:38:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:38:47","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:38:47","OPEN_FOR_INTERNAL","2022-11-03 17:38:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:38:50","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:38:50","OPEN_FOR_INTERNAL","2022-11-03 17:38:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:38:52","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:38:52","OPEN_FOR_INTERNAL","2022-11-03 17:38:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:38:53","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:38:53","OPEN_FOR_INTERNAL","2022-11-03 17:38:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:38:54","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:38:54","OPEN_FOR_INTERNAL","2022-11-03 17:38:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:38:55","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:38:55","OPEN_FOR_INTERNAL","2022-11-03 17:38:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:38:55","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:38:55","OPEN_FOR_INTERNAL","2022-11-03 17:38:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:39:00","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:39:00","OPEN_FOR_INTERNAL","2022-11-03 17:39:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:39:00","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:39:00","OPEN_FOR_INTERNAL","2022-11-03 17:39:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:39:01","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:39:01","OPEN_FOR_INTERNAL","2022-11-03 17:39:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:39:01","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:39:01","OPEN_FOR_INTERNAL","2022-11-03 17:39:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:39:01","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:39:01","OPEN_FOR_INTERNAL","2022-11-03 17:39:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:39:01","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:39:01","OPEN_FOR_INTERNAL","2022-11-03 17:39:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:39:04","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:39:04","OPEN_FOR_INTERNAL","2022-11-03 17:39:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:39:04","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:39:04","OPEN_FOR_INTERNAL","2022-11-03 17:39:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:39:07","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:39:07","OPEN_FOR_INTERNAL","2022-11-03 17:39:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:39:07","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:39:07","OPEN_FOR_INTERNAL","2022-11-03 17:39:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:39:07","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:39:07","OPEN_FOR_INTERNAL","2022-11-03 17:39:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:39:12","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:39:12","OPEN_FOR_INTERNAL","2022-11-03 17:39:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:39:12","login_id":"1","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"skyadmin","cmsloginid":"1","loginid":"1","cmsrole":"super_admin","role":"super_admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"y123456(7)","title":"Mr","lastname":"DOE","firstname":"John","companyname":"","email":"johndoe123@gmail.com","tel":"56785678","address":"11\/F., Wah Shing Building, Kwun Tong, Kowloon","pass":true,"customer_id":"14","customer_code":"C220012","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"35","room_code":"A35","retail_price":"1228.0","discounted_price":"1228.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1228,"total_discounted_price":1228,"deposit":2456,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":6140,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"discount_amount":"0","last_paid":"0","warehousing_date":"2022-11-03","rent_from":"2022-11-03","rent_to":"2023-02-02","delivery_service":"0","remark":"","paymethod":"CASH","paymethod2":"UNPAID","discount_deduct":0,"order_total":6140,"final_order_total":6140,"location_id":"1","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n\n \n \n \n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> A35 <\/td>\n\t\t\t\t\t 4X4X8 <\/td>\n\t\t\t\t\t $1228.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"16","total_discounted_price":"1228.00","deposit":"2456.00","total_retail_price":"1228.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:39:13","login_id":"1","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` = ?, `discount_amount` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1","14","NEW","A12-CT2212039",1228,1228,2456,0,"3","3",6140,6140,6140,"2022-11-03 17:39:13","0",null,null,null,"2022-11-03","2023-02-02","","2022-11-03","16",0,null,0,"0","0","1","2022-11-03 17:39:12","1","2022-11-03 17:39:12","CASH","","","","UNPAID","","","",null,0,"","C220012","PERSONAL","Mr","KHskzBnhdzBUsg6kf2c6kQ==","JeOZEMNUNd9AIVJJXay9Yg==","","\/c07ypx0rrHw0toQ40xga6f7gvUwjV47TJrZPDl0lcujjauxHhjzgxW1grCUZtFx","m7yf6obPuRz4yDkAkV7HQg==","ievc43tdp7kuH1njljQW4RCGxKYYAwsNpQ\/Rt7qwq58=","sAKstd00DhW1v\/Xuw5WHPw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:39:13","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["12049","35","1228.0","1228.00","1","2022-11-03 17:39:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:39:13","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2022-11-03","2023-02-02","35"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2022-11-03 17:39:13","login_id":"1","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":["12049","A12-D226604","PAID",2456,0,"2023-02-02","2022-11-03 17:39:12","2022-11-03 17:39:12","1","2022-11-03 17:39:12","1","2022-11-03 17:39:12","14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:39:13","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["12049","14","NEW","A12-I220349","2022-11-03 17:39:12","2022-11-03","1","2022-11-03 17:39:12","1","2022-11-03 17:39:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:39:13","login_id":"1","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":["349","RENT","\u9810\u7e73\u79df\u91d1",1,1228,"MO","1",1228,"1","2022-11-03 17:39:12","1","2022-11-03 17:39:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:39:13","login_id":"1","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":["349","RENT","\u9810\u7e73\u79df\u91d1",2,1228,"MO","1",1228,"1","2022-11-03 17:39:12","1","2022-11-03 17:39:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:39:13","login_id":"1","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":["349","RENT","\u9810\u7e73\u79df\u91d1",3,1228,"MO","1",1228,"1","2022-11-03 17:39:12","1","2022-11-03 17:39:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:39:13","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3684,1228,"349"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2022-11-03 17:39:13","login_id":"1","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":["14","CASH","","","","UNPAID","","","","PAID","P220237","2022-11-03 17:39:12",2456,"1","2022-11-03 17:39:12","1","2022-11-03 17:39:12","DEPOSIT"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:39:13","login_id":"1","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":["237","DEPOSIT","6604","PAID","2022-11-03 17:39:12",2456,"1","2022-11-03 17:39:12","1","2022-11-03 17:39:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:39:14","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:39:14","OPEN_FOR_INTERNAL","2022-11-03 17:39:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:39:14","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:39:14","OPEN_FOR_INTERNAL","2022-11-03 17:39:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:39:18","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:39:17","OPEN_FOR_INTERNAL","2022-11-03 17:39:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:39:25","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:39:25","OPEN_FOR_INTERNAL","2022-11-03 17:39:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:42:11","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:42:11","OPEN_FOR_INTERNAL","2022-11-03 17:42:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:42:11","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `amount` = ?, `balance` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":[12049,"14","SENT","A12-I220350",0,0,"2022-11-03 17:42:11","2022-11-03","1","2022-11-03 17:42:11","1","2022-11-03 17:42:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:42:11","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `remark` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["350","PENALTY",0,"PCS","1",0,"\u9000\u5009\u901a\u77e5\u8ce0\u511f","1","2022-11-03 17:42:11","1","2022-11-03 17:42:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:42:11","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:42:11","OPEN_FOR_INTERNAL","2022-11-03 17:42:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-11-03 17:42:14","login_id":"1","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","1","2022-11-03 17:42:14","OPEN_FOR_INTERNAL","2022-11-03 17:42:14"]},"data_before":[],"data_after":[],"step":1} *****