\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>
D08 <\/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-10-25 17:36:26","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-CT2211988",598,598,1196,0,"3","3",2990,2990,2990,"2022-10-25 17:36:26","0",null,null,null,"2022-07-26","2022-10-25","","2022-07-26","12",0,null,0,"0","0","1","2022-10-25 17:36:25","1","2022-10-25 17:36:25","CASH","","","","CASH","","","",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-10-25 17:36:26","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":["11988","204","598.0","598.00","1","2022-10-25 17:36:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:36:26","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-07-26","2022-10-25","204"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2022-10-25 17:36:26","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":["11988","A12-D226558","PAID",1196,0,"2022-10-25","2022-10-25 17:36:25","2022-10-25 17:36:25","1","2022-10-25 17:36:25","1","2022-10-25 17:36:25","12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:36:26","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":["11988","12","SETTLED","A12-I220260","2022-10-25 17:36:25","2022-07-26","1","2022-10-25 17:36:25","1","2022-10-25 17:36:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:36:26","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":["260","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"1","2022-10-25 17:36:25","1","2022-10-25 17:36:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:36:26","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":["260","RENT","\u9810\u7e73\u79df\u91d1",2,598,"MO","1",598,"1","2022-10-25 17:36:25","1","2022-10-25 17:36:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:36:26","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":["260","RENT","\u9810\u7e73\u79df\u91d1",3,598,"MO","1",598,"1","2022-10-25 17:36:25","1","2022-10-25 17:36:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:36:26","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1794,0,"260"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2022-10-25 17:36:26","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","","","","CASH","","","","PAID","P220187","2022-10-25 17:36:25",2990,"1","2022-10-25 17:36:25","1","2022-10-25 17:36:25","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:36:26","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":["187","DEPOSIT","6558","PAID","2022-10-25 17:36:25",1196,"1","2022-10-25 17:36:25","1","2022-10-25 17:36:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:36:26","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":["187","INVOICE","260","PAID","2022-10-25 17:36:25",1794,"1","2022-10-25 17:36:25","1","2022-10-25 17:36:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:36:26","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-10-25 17:36:26","OPEN_FOR_INTERNAL","2022-10-25 17:36:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:36: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-10-25 17:36:27","OPEN_FOR_INTERNAL","2022-10-25 17:36:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:36: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-10-25 17:36:31","OPEN_FOR_INTERNAL","2022-10-25 17:36:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:36: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-10-25 17:36:41","OPEN_FOR_INTERNAL","2022-10-25 17:36:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:36: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-10-25 17:36:47","OPEN_FOR_INTERNAL","2022-10-25 17:36:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:36: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-10-25 17:36:56","OPEN_FOR_INTERNAL","2022-10-25 17:36:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:36: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-10-25 17:36:56","OPEN_FOR_INTERNAL","2022-10-25 17:36:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:36: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-10-25 17:36:57","OPEN_FOR_INTERNAL","2022-10-25 17:36:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:36: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-10-25 17:36:57","OPEN_FOR_INTERNAL","2022-10-25 17:36:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:37: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-10-25 17:37:20","OPEN_FOR_INTERNAL","2022-10-25 17:37:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:37: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-10-25 17:37:20","OPEN_FOR_INTERNAL","2022-10-25 17:37:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:37: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-10-25 17:37:25","OPEN_FOR_INTERNAL","2022-10-25 17:37:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:37: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-10-25 17:37:31","OPEN_FOR_INTERNAL","2022-10-25 17:37:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38: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-10-25 17:38:03","OPEN_FOR_INTERNAL","2022-10-25 17:38:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38: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-10-25 17:38:08","OPEN_FOR_INTERNAL","2022-10-25 17:38:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38: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-10-25 17:38:12","OPEN_FOR_INTERNAL","2022-10-25 17:38:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38: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-10-25 17:38:12","OPEN_FOR_INTERNAL","2022-10-25 17:38:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38: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-10-25 17:38:12","OPEN_FOR_INTERNAL","2022-10-25 17:38:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38: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-10-25 17:38:12","OPEN_FOR_INTERNAL","2022-10-25 17:38:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38: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-10-25 17:38:12","OPEN_FOR_INTERNAL","2022-10-25 17:38:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38: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-10-25 17:38:13","OPEN_FOR_INTERNAL","2022-10-25 17:38:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38: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-10-25 17:38:13","OPEN_FOR_INTERNAL","2022-10-25 17:38:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38: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-10-25 17:38:13","OPEN_FOR_INTERNAL","2022-10-25 17:38:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38: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-10-25 17:38:13","OPEN_FOR_INTERNAL","2022-10-25 17:38:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38: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-10-25 17:38:13","OPEN_FOR_INTERNAL","2022-10-25 17:38:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38: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-10-25 17:38:13","OPEN_FOR_INTERNAL","2022-10-25 17:38:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38: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-10-25 17:38:32","OPEN_FOR_INTERNAL","2022-10-25 17:38:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38: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-10-25 17:38:33","OPEN_FOR_INTERNAL","2022-10-25 17:38:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38: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-10-25 17:38:33","OPEN_FOR_INTERNAL","2022-10-25 17:38:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38: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-10-25 17:38:36","OPEN_FOR_INTERNAL","2022-10-25 17:38:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38:36","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":"","switch":{"order_info":{"id":"11988","createby":"1","createdate":"2022-10-25 17:36:25","lastupby":"1","lastupdate":"2022-10-25 17:36:25","deleted":"0","company_id":"1","branch_id":"1","location_id":"1","customer_id":"12","status":"NEW","code":"A12-CT2211988","total_retail_price":"598.0","total_discounted_price":"598.0","original_amount":"2990.0","deposit":"1196.0","deposit_penalty":"0.0","prepaid_month":"3","prepaid_amount":"2990.0","last_order_id":"0","last_paid":"0.0","balance":"2990.0","docdate":"2022-10-25 17:36:26","transport_enable":"0","transport_date":null,"transport_address":null,"transport_destination":null,"warehousing_date":"2022-07-26","startdate":"2022-07-26","enddate":"2022-10-25","remark":"","rent_month":"3","roughly_size":"12","free_first_month_deduct":"0.0","discount_deduct":"0.0","free_2_month_deduct":null,"paymethod":"CASH","bank_name":"","cheque_num":"","paymethod_other":"","paymethod2":"CASH","bank_name2":"","cheque_num2":"","paymethod_other2":"","from_order_id":null,"total_return_amount":"0.0","room_key":"","is_online_order":"0","total_order_product":null,"send_email":"0","customer_code":" 220010","customer_typeid":"PERSONAL","customer_title":"Mr","customer_firstname":"7LutgkIODYlTr8d+OWW14w==","customer_lastname":"v\/DgFKIQ6\/M55ywo8wV7Cg==","customer_tel":"Ix\/L\/L1UaMe4qEWrPL11Og==","customer_email":"I7YdzbMD3ivT4sxW8o4wWQ==","customer_address":"0x458iGiF3wsSwSrEj5tJf0t1aSAI9YyXyEieytVW24=","customer_companyname":"","customer_hkid":"at4rb9Xcm\/gsKsfeCdhSEg==","customer_hkbr":null,"recurring_payment":"0","recurring_profile_id":null,"withdraw_remuneration":null,"withdraw_process_date":null,"withdraw_date":null,"renew":"0","first_order_id":"0","discount_amount":"0.0","customer_identity_id":"at4rb9Xcm\/gsKsfeCdhSEg==","clientID":"12","clientName":" 220010","customer_name":"W R"},"ordered_room_code":[],"ordered_room_id":["204"],"total_return_amount":0},"warehousing":{"1":{"customer_id":12,"new_customer":0,"customer_code":"C220010","title":"Mr","identity_type":"PERSONAL","identity_id":"x123456(7)","lastname":"R","firstname":"W","companyname":"","email":"test@test.com","tel":"54325432","address":"Wah Shing Building","pass":true,"customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"84","master_room_id":"14","discount_type":"%","price":"2318.00","disocunted_price":"2086.20","discount":"10.00","monthly_deduct":231.8,"room_id":"46","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"renew_paymethod2":"UNPAID","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2087.0","renew_rent_month":"6","renew_warehousing_date":"2023-03-27","renew_room_key":"","renew_remark":"\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT2211908, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $4636.0","renew_master_room_id":"14","order_room":[{"room_id":"46","room_code":"A46","retail_price":"2318.0","discounted_price":2086.2,"location_id":"1"}],"roughly_size":"32","total_retail_price":2318,"total_discounted_price":2087,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":12522,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"discount_amount":"0","last_paid":"0","warehousing_date":"2022-10-25","rent_from":"2022-10-25","rent_to":"2023-04-24","delivery_service":"0","remark":"\r\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT2211908, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $4636.0","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"UNPAID","discount_deduct":0,"order_total":12522,"final_order_total":12522,"location_id":"1","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"renew":1,"first_order_id":11908,"selected_room_tr":"	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A46 <\/td>\r\n\t\t\t\t\t 4X8X8 <\/td>\r\n\t\t\t\t\t $2318.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"2087.0","deposit":"0","total_retail_price":"2318.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38:36","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set status = ? where id = ? and status != ?","parameters":["REVISED","11988","COMPLETED"]},"data_before":[],"data_after":[],"step":2} ***** {"created_at":"2022-10-25 17:38:36","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set status = ?, lastupby = ?, lastupdate = ?, reservedate_from = NULL, reservedate_to = NULL, rentaldate_from = NULL, rentaldate_to = NULL where id = ?","parameters":["SUSPENDED","1","2022-10-25 17:38:36","204"]},"data_before":[],"data_after":[],"step":3} ***** {"created_at":"2022-10-25 17:38:37","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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",12,"NEW","A12-CT2211989",2318,2087,0,0,"6","6",12522,12522,12522,"2022-10-25 17:38:37","0",null,null,null,"2022-10-25","2023-04-24","\r\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT2211908, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $4636.0","2022-10-25","32",0,null,0,"0","0","1","2022-10-25 17:38:36","1","2022-10-25 17:38:36","NO_NEED_PAID_RENEW","","","","UNPAID","","","","11988",0,"","C220010","PERSONAL","Mr","7LutgkIODYlTr8d+OWW14w==","v\/DgFKIQ6\/M55ywo8wV7Cg==","","0x458iGiF3wsSwSrEj5tJf0t1aSAI9YyXyEieytVW24=","Ix\/L\/L1UaMe4qEWrPL11Og==","I7YdzbMD3ivT4sxW8o4wWQ==","at4rb9Xcm\/gsKsfeCdhSEg==",null,1,11908]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38:37","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":["11989","84","14","46","%","10.00",231.8,"1","2022-10-25 17:38:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38:37","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":["11989","46","2318.0",2086.2,"1","2022-10-25 17:38:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38:37","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-10-25","2023-04-24","46"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2022-10-25 17:38:37","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":["11989",12,"NEW","A12-I220261","2022-10-25 17:38:36","2022-10-25","1","2022-10-25 17:38:36","1","2022-10-25 17:38:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38:37","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":["261","RENT","\u9810\u7e73\u79df\u91d1",1,2087,"MO","1",2087,"1","2022-10-25 17:38:36","1","2022-10-25 17:38:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38:37","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":["261","RENT","\u9810\u7e73\u79df\u91d1",2,2087,"MO","1",2087,"1","2022-10-25 17:38:36","1","2022-10-25 17:38:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38:37","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":["261","RENT","\u9810\u7e73\u79df\u91d1",3,2087,"MO","1",2087,"1","2022-10-25 17:38:36","1","2022-10-25 17:38:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38:37","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":["261","RENT","\u9810\u7e73\u79df\u91d1",4,2087,"MO","1",2087,"1","2022-10-25 17:38:36","1","2022-10-25 17:38:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38:37","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":["261","RENT","\u9810\u7e73\u79df\u91d1",5,2087,"MO","1",2087,"1","2022-10-25 17:38:36","1","2022-10-25 17:38:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38:37","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":["261","RENT","\u9810\u7e73\u79df\u91d1",6,2087,"MO","1",2087,"1","2022-10-25 17:38:36","1","2022-10-25 17:38:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38:37","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[12522,2087,"261"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2022-10-25 17:38: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-10-25 17:38:37","OPEN_FOR_INTERNAL","2022-10-25 17:38:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:38: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-10-25 17:38:37","OPEN_FOR_INTERNAL","2022-10-25 17:38:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 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-10-25 17:38:52","OPEN_FOR_INTERNAL","2022-10-25 17:38:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:42: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-10-25 17:42:46","OPEN_FOR_INTERNAL","2022-10-25 17:42:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:42: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-10-25 17:42:54","OPEN_FOR_INTERNAL","2022-10-25 17:42:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:43: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-10-25 17:43:01","OPEN_FOR_INTERNAL","2022-10-25 17:43:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:43: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-10-25 17:43:05","OPEN_FOR_INTERNAL","2022-10-25 17:43:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:43: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-10-25 17:43:05","OPEN_FOR_INTERNAL","2022-10-25 17:43:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:43: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-10-25 17:43:05","OPEN_FOR_INTERNAL","2022-10-25 17:43:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:43: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-10-25 17:43:05","OPEN_FOR_INTERNAL","2022-10-25 17:43:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:43: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-10-25 17:43:11","OPEN_FOR_INTERNAL","2022-10-25 17:43:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:43: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-10-25 17:43:12","OPEN_FOR_INTERNAL","2022-10-25 17:43:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:43: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-10-25 17:43:12","OPEN_FOR_INTERNAL","2022-10-25 17:43:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:43: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-10-25 17:43:12","OPEN_FOR_INTERNAL","2022-10-25 17:43:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:43: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-10-25 17:43:13","OPEN_FOR_INTERNAL","2022-10-25 17:43:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:43: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-10-25 17:43:14","OPEN_FOR_INTERNAL","2022-10-25 17:43:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:43: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-10-25 17:43:16","OPEN_FOR_INTERNAL","2022-10-25 17:43:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:43: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-10-25 17:43:16","OPEN_FOR_INTERNAL","2022-10-25 17:43:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17: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-10-25 17:43:22","OPEN_FOR_INTERNAL","2022-10-25 17:43:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:43: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-10-25 17:43:23","OPEN_FOR_INTERNAL","2022-10-25 17:43:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:43: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-10-25 17:43:23","OPEN_FOR_INTERNAL","2022-10-25 17:43:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:43: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-10-25 17:43:23","OPEN_FOR_INTERNAL","2022-10-25 17:43:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:43: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-10-25 17:43:27","OPEN_FOR_INTERNAL","2022-10-25 17:43:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:43: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-10-25 17:43:27","OPEN_FOR_INTERNAL","2022-10-25 17:43:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:43: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-10-25 17:43:34","OPEN_FOR_INTERNAL","2022-10-25 17:43:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:43: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-10-25 17:43:34","OPEN_FOR_INTERNAL","2022-10-25 17:43:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:43: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-10-25 17:43:35","OPEN_FOR_INTERNAL","2022-10-25 17:43:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:43: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-10-25 17:43:35","OPEN_FOR_INTERNAL","2022-10-25 17:43:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:44: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-10-25 17:44:46","OPEN_FOR_INTERNAL","2022-10-25 17:44:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:44: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-10-25 17:44:46","OPEN_FOR_INTERNAL","2022-10-25 17:44:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:44: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-10-25 17:44:46","OPEN_FOR_INTERNAL","2022-10-25 17:44:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:44: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-10-25 17:44:57","OPEN_FOR_INTERNAL","2022-10-25 17:44:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:44:57","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":"360","room_code":"G01","retail_price":"775.0","discounted_price":"775.00","location_id":"1"}],"roughly_size":"9","total_retail_price":775,"total_discounted_price":775,"deposit":1550,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2325,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"discount_amount":"0","last_paid":"0","warehousing_date":"2022-10-25","rent_from":"2022-10-25","rent_to":"2022-11-24","delivery_service":"0","remark":"","paymethod":"CASH","paymethod2":"CASH","discount_deduct":0,"order_total":2325,"final_order_total":2325,"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> G01 <\/td>\n\t\t\t\t\t 3X3X8 <\/td>\n\t\t\t\t\t $775.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":"9","total_discounted_price":"775.00","deposit":"1550.00","total_retail_price":"775.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:44:59","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-CT2211990",775,775,1550,0,"1","1",2325,2325,2325,"2022-10-25 17:44:59","0",null,null,null,"2022-10-25","2022-11-24","","2022-10-25","9",0,null,0,"0","0","1","2022-10-25 17:44:57","1","2022-10-25 17:44:57","CASH","","","","CASH","","","",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-10-25 17:44:59","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":["11990","360","775.0","775.00","1","2022-10-25 17:44:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:44:59","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-10-25","2022-11-24","360"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2022-10-25 17:44:59","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":["11990","A12-D226559","PAID",1550,0,"2022-11-24","2022-10-25 17:44:57","2022-10-25 17:44:57","1","2022-10-25 17:44:57","1","2022-10-25 17:44:57","12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:44:59","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":["11990","12","SETTLED","A12-I220262","2022-10-25 17:44:57","2022-10-25","1","2022-10-25 17:44:57","1","2022-10-25 17:44:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:44:59","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":["262","RENT","\u9810\u7e73\u79df\u91d1",1,775,"MO","1",775,"1","2022-10-25 17:44:57","1","2022-10-25 17:44:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:44:59","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[775,0,"262"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2022-10-25 17:44:59","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","","","","CASH","","","","PAID","P220188","2022-10-25 17:44:57",2325,"1","2022-10-25 17:44:57","1","2022-10-25 17:44:57","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:44:59","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":["188","DEPOSIT","6559","PAID","2022-10-25 17:44:57",1550,"1","2022-10-25 17:44:57","1","2022-10-25 17:44:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:44:59","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":["188","INVOICE","262","PAID","2022-10-25 17:44:57",775,"1","2022-10-25 17:44:57","1","2022-10-25 17:44:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:44: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-10-25 17:44:59","OPEN_FOR_INTERNAL","2022-10-25 17:44:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-25 17:45: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-10-25 17:44:59","OPEN_FOR_INTERNAL","2022-10-25 17:44:59"]},"data_before":[],"data_after":[],"step":1} *****