\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>
A48 <\/td>\n\t\t\t\t\t	5X7X8 <\/td>\n\t\t\t\t\t	$2528.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":"35","total_discounted_price":"2528.00","deposit":"5056.00","total_retail_price":"2528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 15:45:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201847","PERSONAL","Mr","nnlX7mzROfBxPCHI2JVk8A==","FYpi4AqOX0lh3rWDosJ5Ww==","","MM2Wz40P\/svSG3JR7eMXfA==",null,"kxLfgebJWG5iEKuzgrECixQtsIYTvU3b79Vfh8oY3iKyTNkfFPCXmm68R5PqbOOyMO0+pwDIiBCdldJBLVxI3w==","0lYrdGWIphtoOJj+2eyVwA==",null,null,"ml82sVUSBTnT8ym4qQjW5A==","2","2020-11-07 15:45:06","2","2020-11-07 15:45:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 15:45:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1",1847,"NEW","A12-CT209506",2528,2528,5056,0,"3","3",8848,12640,8848,"2020-11-07 15:45:08","0",null,null,null,"2020-11-15","2021-02-14","3 months contract. Special offered 50%off discount for the first 3 months. Down-payment $500 received by cash on 14 Oct 2020. The balance of storage rental and deposit paid by cheque on 7 Nov 2020. Smart card and padlock provided on the same day.","2020-11-15","35",0,null,3792,"3792.00","2","2020-11-07 15:45:06","2","2020-11-07 15:45:06","CHEQUE","","","","CHEQUE","","","",null,0,"189,02145","C201847","PERSONAL","Mr","nnlX7mzROfBxPCHI2JVk8A==","FYpi4AqOX0lh3rWDosJ5Ww==","","kxLfgebJWG5iEKuzgrECixQtsIYTvU3b79Vfh8oY3iKyTNkfFPCXmm68R5PqbOOyMO0+pwDIiBCdldJBLVxI3w==","MM2Wz40P\/svSG3JR7eMXfA==",null,"0lYrdGWIphtoOJj+2eyVwA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 15:45:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["9506","48","2528.0","2528.00","2","2020-11-07 15:45:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 15:45:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-11-15","2021-02-14","48"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-11-07 15:45:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["9506","A12-D205849","PAID",5056,0,"2021-02-14","2020-11-07 15:45:06","2020-11-07 15:45:06","2","2020-11-07 15:45:06","2","2020-11-07 15:45:06",1847]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 15:45:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["9506",1847,"SETTLED","A12-I209835","2020-11-07 15:45:06","2020-11-15","2","2020-11-07 15:45:06","2","2020-11-07 15:45:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 15:45:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["9835","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-11-07 15:45:06","2","2020-11-07 15:45:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 15:45:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["9835","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1264,"MO","1",1264,"2","2020-11-07 15:45:06","2","2020-11-07 15:45:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 15:45:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["9835","RENT","\u9810\u7e73\u79df\u91d1",3,2528,"MO","1",2528,"2","2020-11-07 15:45:06","2","2020-11-07 15:45:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 15:45:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3792,0,"9835"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-11-07 15:45:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1847,"CHEQUE","","","","CHEQUE","","","","PAID","P209474","2020-11-07 15:45:06",8848,"2","2020-11-07 15:45:06","2","2020-11-07 15:45:06","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 15:45:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["9474","DEPOSIT","5849","PAID","2020-11-07 15:45:06",5056,"2","2020-11-07 15:45:06","2","2020-11-07 15:45:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 15:45:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["9474","INVOICE","9835","PAID","2020-11-07 15:45:06",3792,"2","2020-11-07 15:45:06","2","2020-11-07 15:45:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 15:45:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 15:45:09","OPEN_FOR_INTERNAL","2020-11-07 15:45:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 15:45:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 15:45:09","OPEN_FOR_INTERNAL","2020-11-07 15:45:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:05:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:05:39","OPEN_FOR_INTERNAL","2020-11-07 16:05:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:05:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:05:42","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:05:42","OPEN_FOR_INTERNAL","2020-11-07 16:05:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:05:53","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:05:53","OPEN_FOR_INTERNAL","2020-11-07 16:05:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:09:25","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:09:25","OPEN_FOR_INTERNAL","2020-11-07 16:09:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:10:07","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:10:07","OPEN_FOR_INTERNAL","2020-11-07 16:10:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:10:16","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:10:16","OPEN_FOR_INTERNAL","2020-11-07 16:10:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:10:34","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:10:34","OPEN_FOR_INTERNAL","2020-11-07 16:10:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:10:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:10:39","OPEN_FOR_INTERNAL","2020-11-07 16:10:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:10:57","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:10:57","OPEN_FOR_INTERNAL","2020-11-07 16:10:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:11:02","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:11:02","OPEN_FOR_INTERNAL","2020-11-07 16:11:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:11:17","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:11:17","OPEN_FOR_INTERNAL","2020-11-07 16:11:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:11:22","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:11:22","OPEN_FOR_INTERNAL","2020-11-07 16:11:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:11:31","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:11:31","OPEN_FOR_INTERNAL","2020-11-07 16:11:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:11:37","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:11:37","OPEN_FOR_INTERNAL","2020-11-07 16:11:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:11:55","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:11:55","OPEN_FOR_INTERNAL","2020-11-07 16:11:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:11:59","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:11:59","OPEN_FOR_INTERNAL","2020-11-07 16:11:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:12:21","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:12:21","OPEN_FOR_INTERNAL","2020-11-07 16:12:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:12:25","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:12:25","OPEN_FOR_INTERNAL","2020-11-07 16:12:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:12:45","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:12:45","OPEN_FOR_INTERNAL","2020-11-07 16:12:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:13:04","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:13:04","OPEN_FOR_INTERNAL","2020-11-07 16:13:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:24","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:24","OPEN_FOR_INTERNAL","2020-11-07 16:14:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:29","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:29","OPEN_FOR_INTERNAL","2020-11-07 16:14:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:29","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:29","OPEN_FOR_INTERNAL","2020-11-07 16:14:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:31","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:31","OPEN_FOR_INTERNAL","2020-11-07 16:14:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:36","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:36","OPEN_FOR_INTERNAL","2020-11-07 16:14:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:38","OPEN_FOR_INTERNAL","2020-11-07 16:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:38","OPEN_FOR_INTERNAL","2020-11-07 16:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:38","OPEN_FOR_INTERNAL","2020-11-07 16:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:38","OPEN_FOR_INTERNAL","2020-11-07 16:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:38","OPEN_FOR_INTERNAL","2020-11-07 16:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:38","OPEN_FOR_INTERNAL","2020-11-07 16:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:38","OPEN_FOR_INTERNAL","2020-11-07 16:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:38","OPEN_FOR_INTERNAL","2020-11-07 16:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:38","OPEN_FOR_INTERNAL","2020-11-07 16:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:38","OPEN_FOR_INTERNAL","2020-11-07 16:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:38","OPEN_FOR_INTERNAL","2020-11-07 16:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:39","OPEN_FOR_INTERNAL","2020-11-07 16:14:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:39","OPEN_FOR_INTERNAL","2020-11-07 16:14:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:39","OPEN_FOR_INTERNAL","2020-11-07 16:14:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:44","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:44","OPEN_FOR_INTERNAL","2020-11-07 16:14:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:45","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:45","OPEN_FOR_INTERNAL","2020-11-07 16:14:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:45","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:45","OPEN_FOR_INTERNAL","2020-11-07 16:14:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:45","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:45","OPEN_FOR_INTERNAL","2020-11-07 16:14:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:45","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:45","OPEN_FOR_INTERNAL","2020-11-07 16:14:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:46","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:46","OPEN_FOR_INTERNAL","2020-11-07 16:14:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:46","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:46","OPEN_FOR_INTERNAL","2020-11-07 16:14:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:46","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:46","OPEN_FOR_INTERNAL","2020-11-07 16:14:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:14:46","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:14:46","OPEN_FOR_INTERNAL","2020-11-07 16:14:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:15:02","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:15:02","OPEN_FOR_INTERNAL","2020-11-07 16:15:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:15:02","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:15:02","OPEN_FOR_INTERNAL","2020-11-07 16:15:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:15:02","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:15:02","OPEN_FOR_INTERNAL","2020-11-07 16:15:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:15:05","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:15:05","OPEN_FOR_INTERNAL","2020-11-07 16:15:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:15:05","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=533&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":197,"customer_code":"C160197","identity_type":"PERSONAL","identity_id":"Z085409(4)","title":"Mr","lastname":"Law","firstname":"Tsz Ching","companyname":"","email":"lawrickylaw@hotmail.com","tel":"67624616","address":"Room 1333, Wah Tai House, Wah Fu Estate,","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-11-08","renew_room_key":"055,49178","renew_remark":"1 month contract. Storage rental paid by bank transfer on 6 Oct 2020. Storage deposit transferred from agreement A12-CT208871 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT209117, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"9","room_code":"A09","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-11-08","rent_from":"2020-11-08","rent_to":"2020-12-07","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on 7 Nov 2020. Storage deposit transferred from agreement A12-CT209117 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,49178","order_product":[],"pass":true}},"first_order_id":"4726","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> A09 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\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":"16","total_discounted_price":"1038.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:15:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",197,"NEW","A12-CT209507",1098,1038,0,0,"1","1",1038,1038,1038,"2020-11-07 16:15:06","0",null,null,null,"2020-11-08","2020-12-07","1 month contract. Storage rental paid by bank transfer on 7 Nov 2020. Storage deposit transferred from agreement A12-CT209117 to this agreement.","2020-11-08","16",0,null,0,"0.00","2","2020-11-07 16:15:05","2","2020-11-07 16:15:05","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,49178","C160197","PERSONAL","Mr","QdEpSylbNMmKejWwEKzDPw==","+moojSUkRE7zuOzLVjRSfQ==","","Nr+zhfcoLZkHs9ekiRB6i9AgkplBFpfkAfkodley4x6sTiCKQDPoQ4LUK0oajT+t","3D\/wzZyg4xuj9bzd1GAt9w==","Cbe7u6XSUPpS1n9ngHhxxux6MAYDMIc9OYuK+Y9HXRo=","2\/lw76RIZjw\/yt0JiFTl9A==",null,1,"4726"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:15:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["9507","9","1098.0","1098.00","2","2020-11-07 16:15:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:15:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-11-08","2020-12-07","9"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-11-07 16:15:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["9507",197,"SETTLED","A12-I209836","2020-11-07 16:15:05","2020-11-08","2","2020-11-07 16:15:05","2","2020-11-07 16:15:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:15:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["9836","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-11-07 16:15:05","2","2020-11-07 16:15:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:15:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"9836"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-11-07 16:15:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[197,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P209475","2020-11-07 16:15:05",1038,"2","2020-11-07 16:15:05","2","2020-11-07 16:15:05","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:15:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["9475","DEPOSIT",null,"PAID","2020-11-07 16:15:05",0,"2","2020-11-07 16:15:05","2","2020-11-07 16:15:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:15:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["9475","INVOICE","9836","PAID","2020-11-07 16:15:05",1038,"2","2020-11-07 16:15:05","2","2020-11-07 16:15:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:15:06","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:15:06","OPEN_FOR_INTERNAL","2020-11-07 16:15:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:15:06","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:15:06","OPEN_FOR_INTERNAL","2020-11-07 16:15:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:16:55","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:16:55","OPEN_FOR_INTERNAL","2020-11-07 16:16:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:16:57","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:16:57","OPEN_FOR_INTERNAL","2020-11-07 16:16:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:17:02","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:17:02","OPEN_FOR_INTERNAL","2020-11-07 16:17:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:20:33","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:20:33","OPEN_FOR_INTERNAL","2020-11-07 16:20:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:20:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:20:39","OPEN_FOR_INTERNAL","2020-11-07 16:20:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:32:24","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:32:24","OPEN_FOR_INTERNAL","2020-11-07 16:32:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:32:24","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-07 16:32:24","OPEN_FOR_INTERNAL","2020-11-07 16:32:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-07 16:32:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****