\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":"598.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:56:56","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,598,1196,0,"3","3",2990,2990,2990,"2022-10-28 17:56:56","0",null,null,null,"2022-10-28","2023-01-27","","2022-10-28","12",0,null,0,"0","0","1","2022-10-28 17:56:55","1","2022-10-28 17:56:55","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-10-28 17:56:56","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":["12035","212","598.0","598.00","1","2022-10-28 17:56:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:56:56","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-28","2023-01-27","212"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2022-10-28 17:56:56","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":["12035","A12-D226590","PAID",1196,0,"2023-01-27","2022-10-28 17:56:55","2022-10-28 17:56:55","1","2022-10-28 17:56:55","1","2022-10-28 17:56:55","14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:56:56","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":["12035","14","NEW","A12-I220328","2022-10-28 17:56:55","2022-10-28","1","2022-10-28 17:56:55","1","2022-10-28 17:56:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:56:56","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":["328","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"1","2022-10-28 17:56:55","1","2022-10-28 17:56:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:56:56","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":["328","RENT","\u9810\u7e73\u79df\u91d1",2,598,"MO","1",598,"1","2022-10-28 17:56:55","1","2022-10-28 17:56:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:56:56","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":["328","RENT","\u9810\u7e73\u79df\u91d1",3,598,"MO","1",598,"1","2022-10-28 17:56:55","1","2022-10-28 17:56:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:57: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-10-28 17:57:51","OPEN_FOR_INTERNAL","2022-10-28 17:57:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:57: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-10-28 17:57:55","OPEN_FOR_INTERNAL","2022-10-28 17:57:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:57:55","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","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":"212","room_code":"D16","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-10-28","rent_from":"2022-10-28","rent_to":"2023-01-27","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> 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":"598.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:57:56","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,598,1196,0,"3","3",2990,2990,2990,"2022-10-28 17:57:56","0",null,null,null,"2022-10-28","2023-01-27","","2022-10-28","12",0,null,0,"0","0","1","2022-10-28 17:57:55","1","2022-10-28 17:57:55","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-10-28 17:57:56","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":["12036","212","598.0","598.00","1","2022-10-28 17:57:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:57:56","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-28","2023-01-27","212"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2022-10-28 17:57:56","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":["12036","A12-D226590","PAID",1196,0,"2023-01-27","2022-10-28 17:57:55","2022-10-28 17:57:55","1","2022-10-28 17:57:55","1","2022-10-28 17:57:55","14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:57:56","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":["12036","14","NEW","A12-I220328","2022-10-28 17:57:55","2022-10-28","1","2022-10-28 17:57:55","1","2022-10-28 17:57:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:57:56","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":["329","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"1","2022-10-28 17:57:55","1","2022-10-28 17:57:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:57:56","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":["329","RENT","\u9810\u7e73\u79df\u91d1",2,598,"MO","1",598,"1","2022-10-28 17:57:55","1","2022-10-28 17:57:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:57:56","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":["329","RENT","\u9810\u7e73\u79df\u91d1",3,598,"MO","1",598,"1","2022-10-28 17:57:55","1","2022-10-28 17:57:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:57: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-10-28 17:57:58","OPEN_FOR_INTERNAL","2022-10-28 17:57:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:59: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-28 17:59:11","OPEN_FOR_INTERNAL","2022-10-28 17:59:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:59:11","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","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":"212","room_code":"D16","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-10-28","rent_from":"2022-10-28","rent_to":"2023-01-27","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> 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":"598.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:59:12","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,598,1196,0,"3","3",2990,2990,2990,"2022-10-28 17:59:12","0",null,null,null,"2022-10-28","2023-01-27","","2022-10-28","12",0,null,0,"0","0","1","2022-10-28 17:59:11","1","2022-10-28 17:59:11","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-10-28 17:59:12","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":["12037","212","598.0","598.00","1","2022-10-28 17:59:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:59:12","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-28","2023-01-27","212"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2022-10-28 17:59:12","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":["12037","A12-D226590","PAID",1196,0,"2023-01-27","2022-10-28 17:59:11","2022-10-28 17:59:11","1","2022-10-28 17:59:11","1","2022-10-28 17:59:11","14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:59:12","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":["12037","14","NEW","A12-I220328","2022-10-28 17:59:11","2022-10-28","1","2022-10-28 17:59:11","1","2022-10-28 17:59:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:59:12","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":["330","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"1","2022-10-28 17:59:11","1","2022-10-28 17:59:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:59:12","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":["330","RENT","\u9810\u7e73\u79df\u91d1",2,598,"MO","1",598,"1","2022-10-28 17:59:11","1","2022-10-28 17:59:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:59:12","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":["330","RENT","\u9810\u7e73\u79df\u91d1",3,598,"MO","1",598,"1","2022-10-28 17:59:11","1","2022-10-28 17:59:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:59: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-28 17:59:23","OPEN_FOR_INTERNAL","2022-10-28 17:59:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:59:23","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","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":"212","room_code":"D16","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-10-28","rent_from":"2022-10-28","rent_to":"2023-01-27","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> 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":"598.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:59:24","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,598,1196,0,"3","3",2990,2990,2990,"2022-10-28 17:59:24","0",null,null,null,"2022-10-28","2023-01-27","","2022-10-28","12",0,null,0,"0","0","1","2022-10-28 17:59:23","1","2022-10-28 17:59:23","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-10-28 17:59:24","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":["12038","212","598.0","598.00","1","2022-10-28 17:59:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:59:24","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-28","2023-01-27","212"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2022-10-28 17:59:24","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":["12038","A12-D226590","PAID",1196,0,"2023-01-27","2022-10-28 17:59:23","2022-10-28 17:59:23","1","2022-10-28 17:59:23","1","2022-10-28 17:59:23","14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:59:24","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":["12038","14","NEW","A12-I220328","2022-10-28 17:59:23","2022-10-28","1","2022-10-28 17:59:23","1","2022-10-28 17:59:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:59:24","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":["331","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"1","2022-10-28 17:59:23","1","2022-10-28 17:59:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:59:24","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":["331","RENT","\u9810\u7e73\u79df\u91d1",2,598,"MO","1",598,"1","2022-10-28 17:59:23","1","2022-10-28 17:59:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:59:24","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":["331","RENT","\u9810\u7e73\u79df\u91d1",3,598,"MO","1",598,"1","2022-10-28 17:59:23","1","2022-10-28 17:59:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 17:59: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-28 17:59:31","OPEN_FOR_INTERNAL","2022-10-28 17:59:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 18:00: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-28 18:00:00","OPEN_FOR_INTERNAL","2022-10-28 18:00:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 18:00:00","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","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":"212","room_code":"D16","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-10-28","rent_from":"2022-10-28","rent_to":"2023-01-27","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> 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":"598.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 18:00:01","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,598,1196,0,"3","3",2990,2990,2990,"2022-10-28 18:00:01","0",null,null,null,"2022-10-28","2023-01-27","","2022-10-28","12",0,null,0,"0","0","1","2022-10-28 18:00:00","1","2022-10-28 18:00:00","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-10-28 18:00:01","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":["12039","212","598.0","598.00","1","2022-10-28 18:00:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 18:00:01","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-28","2023-01-27","212"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2022-10-28 18:00:01","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":["12039","A12-D226590","PAID",1196,0,"2023-01-27","2022-10-28 18:00:00","2022-10-28 18:00:00","1","2022-10-28 18:00:00","1","2022-10-28 18:00:00","14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 18:00:01","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":["12039","14","NEW","A12-I220328","2022-10-28 18:00:00","2022-10-28","1","2022-10-28 18:00:00","1","2022-10-28 18:00:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 18:00:01","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":["332","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"1","2022-10-28 18:00:00","1","2022-10-28 18:00:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 18:00:01","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":["332","RENT","\u9810\u7e73\u79df\u91d1",2,598,"MO","1",598,"1","2022-10-28 18:00:00","1","2022-10-28 18:00:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 18:00:01","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":["332","RENT","\u9810\u7e73\u79df\u91d1",3,598,"MO","1",598,"1","2022-10-28 18:00:00","1","2022-10-28 18:00:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 18:00: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-28 18:00:14","OPEN_FOR_INTERNAL","2022-10-28 18:00:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 18:00: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","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":"212","room_code":"D16","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-10-28","rent_from":"2022-10-28","rent_to":"2023-01-27","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> 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":"598.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 18:00: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","14","NEW","A12-CT2212035",598,598,1196,0,"3","3",2990,2990,2990,"2022-10-28 18:00:15","0",null,null,null,"2022-10-28","2023-01-27","","2022-10-28","12",0,null,0,"0","0","1","2022-10-28 18:00:14","1","2022-10-28 18:00:14","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-10-28 18:00: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":["12040","212","598.0","598.00","1","2022-10-28 18:00:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 18:00: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-10-28","2023-01-27","212"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2022-10-28 18:00: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":["12040","A12-D226590","PAID",1196,0,"2023-01-27","2022-10-28 18:00:14","2022-10-28 18:00:14","1","2022-10-28 18:00:14","1","2022-10-28 18:00:14","14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 18:00: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":["12040","14","NEW","A12-I220328","2022-10-28 18:00:14","2022-10-28","1","2022-10-28 18:00:14","1","2022-10-28 18:00:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 18:00: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":["333","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"1","2022-10-28 18:00:14","1","2022-10-28 18:00:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 18:00: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":["333","RENT","\u9810\u7e73\u79df\u91d1",2,598,"MO","1",598,"1","2022-10-28 18:00:14","1","2022-10-28 18:00:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2022-10-28 18:00: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":["333","RENT","\u9810\u7e73\u79df\u91d1",3,598,"MO","1",598,"1","2022-10-28 18:00:14","1","2022-10-28 18:00:14"]},"data_before":[],"data_after":[],"step":1} *****