\r\n\t\t\t\t\tA05-030 4X6X7 $1857.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"24","total_discounted_price":"1857.0","deposit":"0","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 10:30:24","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","4",1000,"NEW","A05-CT207235",1857,1857,0,0,"1","1",1857,1857,1857,"2020-02-20 10:30:24","0",null,null,null,"2020-02-22","2020-03-21","1 month contract. Storage rental paid by bank transfer on February 20, 2020. Storage Deposit $3714 transferred from agreement A05-CT206943 to this agreement. ","2020-02-22","24",0,null,0,"0","2","2020-02-20 10:30:23","2","2020-02-20 10:30:23","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012385366","C181000","BUSINESS","Mr","uH6SR3Usr5pjl15fgk2xBQ==","3hC5jWxTyseC0UGI0aOkAg==","Lancashire Decorating Limited","2Z3GrSs8TtWmHfqJQHcTHSj5PkrfAJG3icQpP+dHb4pR6r6gZDlFua9f0SQRB4T7nesXzD6ZQbIz9hPFFQWgZxCafnJaWissyZGlcu8xHaw=","6vfNYC\/zokp3t8YiOOVHSg==","hDQSd3rKdaAlD3TTnjhsvRH6brF\/H73VmPFKao018qs=",null,"c4A7Vexe0m66GXy70hIIWA==",1,6943]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 10:30:24","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":["7235","1032","1857.0","1857.00","2","2020-02-20 10:30:23"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 10:30:24","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-02-22","2020-03-21","1032"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-02-20 10:30:24","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":["7235",1000,"SETTLED","A05-I207563","2020-02-20 10:30:23","2020-02-22","2","2020-02-20 10:30:23","2","2020-02-20 10:30:23"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 10:30:24","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":["7563","RENT","\u9810\u7e73\u79df\u91d1",1,1857,"MO","1",1857,"2","2020-02-20 10:30:23","2","2020-02-20 10:30:23"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 10:30:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1857,0,"7563"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-02-20 10:30:24","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":[1000,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207211","2020-02-20 10:30:23",1857,"2","2020-02-20 10:30:23","2","2020-02-20 10:30:23","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 10:30:24","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":["7211","DEPOSIT",null,"PAID","2020-02-20 10:30:23",0,"2","2020-02-20 10:30:23","2","2020-02-20 10:30:23"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 10:30:24","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":["7211","INVOICE","7563","PAID","2020-02-20 10:30:23",1857,"2","2020-02-20 10:30:23","2","2020-02-20 10:30:23"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 11:44:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 12:29:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 16:20:35","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":"type=INVOICE&filter1=0&filter2=1513&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":275,"customer_code":"C170275","identity_type":"PERSONAL","identity_id":"P935426(7)","title":"Ms","lastname":"Au","firstname":"Shing San","companyname":"","email":null,"tel":"68750303","address":"\u77f3\u6392\u7063\u90a8\u78a7\u8f1d\u6a13707\u5ba4","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1535.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-19","renew_room_key":"133,2756","renew_remark":"1 month contract. Storage rental paid by cash on January 17, 2020. Storage deposit transferred from agreement A12-CT196748 to this agreement.\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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tG14 4X6X8 $1768.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"24","total_discounted_price":"1535.0","deposit":"0","total_retail_price":"1768.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 16:20:36","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",275,"NEW","A12-CT207236",1768,1535,0,0,"1","1",1535,1535,1535,"2020-02-20 16:20:36","0",null,null,null,"2020-02-19","2020-03-18","1 month contract. Storage rental paid by cash on Feb 20, 2020. Storage deposit transferred from agreement A12-CT206988 to this agreement.","2020-02-19","24",0,null,0,"0","2","2020-02-20 16:20:35","2","2020-02-20 16:20:35","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"133,2756","C170275","PERSONAL","Ms","EFxpJJXvWP6pxqsrB6e4rw==","egeOlBPCZ2i\/hzcvvQMisg==","","cfhLoHunuImSyfV\/aZ+b9adtcjA+s\/\/16tHC7+KYDRk=","rzzwlkWLr5BLkj5wjDqTZQ==",null,"djxx0GEU1zjEGX4LvLIgug==",null,1,"4776"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 16:20:36","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":["7236","373","1768.0","1768.00","2","2020-02-20 16:20:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 16:20:36","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-02-19","2020-03-18","373"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-02-20 16:20:36","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":["7236",275,"SETTLED","A12-I207564","2020-02-20 16:20:35","2020-02-19","2","2020-02-20 16:20:35","2","2020-02-20 16:20:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 16:20:36","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":["7564","RENT","\u9810\u7e73\u79df\u91d1",1,1535,"MO","1",1535,"2","2020-02-20 16:20:35","2","2020-02-20 16:20:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 16:20:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1535,0,"7564"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-02-20 16:20:36","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":[275,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207212","2020-02-20 16:20:35",1535,"2","2020-02-20 16:20:35","2","2020-02-20 16:20:35","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 16:20:36","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":["7212","DEPOSIT",null,"PAID","2020-02-20 16:20:35",0,"2","2020-02-20 16:20:35","2","2020-02-20 16:20:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 16:20:36","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":["7212","INVOICE","7564","PAID","2020-02-20 16:20:35",1535,"2","2020-02-20 16:20:35","2","2020-02-20 16:20:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 17:11:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 17:27:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 19:05:47","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 19:07:54","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":"type=INVOICE","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":798,"customer_code":"C180798","identity_type":"PERSONAL","identity_id":"Z916749(9)","title":"Mr","lastname":"Lo","firstname":"Ka Chun","companyname":"","email":"loka0039@gmai.com","tel":"96670730","address":"Flat 3107, 31\/F, Tin Chak House, Tin Wan Estate, Aberdeen, Hong Kong","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-02-21","renew_room_key":"055,32980","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 24, 2020. Storage deposit transferred from agreement A12-CT196765 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207234, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"279","room_code":"E06","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"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","warehousing_date":"2020-02-21","rent_from":"2020-02-21","rent_to":"2020-03-20","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Feb 20, 2020. Storage deposit transferred from agreement A12-CT207234 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,32980","order_product":[],"pass":true}},"first_order_id":"4789","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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tE06 4X3X8 $998.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"12","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 19:07:55","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",798,"NEW","A12-CT207237",998,1038,0,0,"1","1",1038,1038,1038,"2020-02-20 19:07:55","0",null,null,null,"2020-02-21","2020-03-20","1 month contract. Storage rental paid by bank transfer on Feb 20, 2020. Storage deposit transferred from agreement A12-CT207234 to this agreement.","2020-02-21","12",0,null,0,"0","2","2020-02-20 19:07:54","2","2020-02-20 19:07:54","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,32980","C180798","PERSONAL","Mr","51MA8AWBJt370WUqsUeCnw==","4w4biS+jM\/Q3DAzxHdf3pA==","","mMzQ1c7IXnG31el3pMn+cAlVmwOEO8RAHQZJFRSLNV\/SmYFvT5hQ\/KG4Is71QjPxXCoAkN9ubgFw5NXyRPui2oMB3Uo2T5sIHAA\/TnArqac=","iu3rJGYyixnPHEo1U9vPkA==","vSxCV4H9VfvlX9eKdpf+03ZOzigLaCc\/nH8UtdLNTfM=","L8wtX\/W+agotXtDfSAWTVA==",null,1,"4789"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 19:07:55","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":["7237","279","998.0","998.00","2","2020-02-20 19:07:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 19:07:55","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-02-21","2020-03-20","279"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-02-20 19:07:55","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":["7237",798,"SETTLED","A12-I207565","2020-02-20 19:07:54","2020-02-21","2","2020-02-20 19:07:54","2","2020-02-20 19:07:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 19:07:55","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":["7565","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-02-20 19:07:54","2","2020-02-20 19:07:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 19:07:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"7565"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-02-20 19:07:55","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":[798,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207213","2020-02-20 19:07:54",1038,"2","2020-02-20 19:07:54","2","2020-02-20 19:07:54","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 19:07:55","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":["7213","DEPOSIT",null,"PAID","2020-02-20 19:07:54",0,"2","2020-02-20 19:07:54","2","2020-02-20 19:07:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 19:07:55","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":["7213","INVOICE","7565","PAID","2020-02-20 19:07:54",1038,"2","2020-02-20 19:07:54","2","2020-02-20 19:07:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 19:19:42","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","0012492388","2 months contract. Storage rental paid by cheque on February 13, 2020. Storage deposit $4868 transferred from agreement A05-CT195675 to this agreement.","2020-02-20 19:19:42","2","D\/skxQ5s\/L5yyRWaDK\/iSg==","Xu2ADsb1wS73d8AGH+\/WTg==","l6cxkQzaXPtplwz5jlBAcw==","9FD5PzyZ1jqJvlUxI5j2ifPss1nzDLR\/XaKSNFsEotK4TehfR1JBK+O+UL2ob0Z+Jggf4RWVyIt8RTsjSd4JNTO\/fIiOalrdMRRp8JT+1os=",7174]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 19:23:02","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":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1137","master_room_id":"131","room_code":"A05-135"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tA05-135 8X4X7 $2434.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"A940893(5)","title":"Ms","lastname":"Ho","firstname":"Emily Siu Yee","companyname":"","email":"","tel":"92899079","address":"Flat B, 1\/F, Seaview Court, 26 Aberdeen Main Road, Aberdeen, Hong Kong","pass":true,"customer_id":"1169","customer_code":"C191169","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"301","master_room_id":"131","discount_type":"%","price":"2434.00","disocunted_price":"2434.00","discount":"5.00","monthly_deduct":121.7,"room_id":"1137","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1137","room_code":"A05-135","retail_price":"2434.0","discounted_price":2312.3,"location_id":"4"}],"roughly_size":"32","total_retail_price":2434,"total_discounted_price":2312,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":6936,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-20","rent_from":"2020-02-20","rent_to":"2020-05-19","delivery_service":"0","remark":"3 months contract. Storage rental paid by cheque on February 20, 2020. Storage deposit $4868 transferred from agreement A05-CT195675 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":6936,"final_order_total":6936,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012492388","order_product":[],"pass":true}},"roughly_size":"32","total_discounted_price":"2312.00","deposit":"0.00","total_retail_price":"2434.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 19:23:03","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","4","1169","NEW","A05-CT207238",2434,2312,0,0,"3","3",6936,6936,6936,"2020-02-20 19:23:03","0",null,null,null,"2020-02-20","2020-05-19","3 months contract. Storage rental paid by cheque on February 20, 2020. Storage deposit $4868 transferred from agreement A05-CT195675 to this agreement.","2020-02-20","32",0,null,0,"0","2","2020-02-20 19:23:02","2","2020-02-20 19:23:02","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"0012492388","C191169","PERSONAL","Ms","Xu2ADsb1wS73d8AGH+\/WTg==","D\/skxQ5s\/L5yyRWaDK\/iSg==","","9FD5PzyZ1jqJvlUxI5j2ifPss1nzDLR\/XaKSNFsEotK4TehfR1JBK+O+UL2ob0Z+Jggf4RWVyIt8RTsjSd4JNTO\/fIiOalrdMRRp8JT+1os=","l6cxkQzaXPtplwz5jlBAcw==",null,"WyYJQDbA5P1MT+cdxWYplA==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 19:23:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["7238","301","131","1137","%","5.00",121.7,"2","2020-02-20 19:23:02"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 19:23:03","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":["7238","1137","2434.0",2312.3,"2","2020-02-20 19:23:02"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 19:23:03","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-02-20","2020-05-19","1137"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-02-20 19:23:03","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":["7238","1169","SETTLED","A05-I207566","2020-02-20 19:23:02","2020-02-20","2","2020-02-20 19:23:02","2","2020-02-20 19:23:02"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 19:23:03","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":["7566","RENT","\u9810\u7e73\u79df\u91d1",1,2312,"MO","1",2312,"2","2020-02-20 19:23:02","2","2020-02-20 19:23:02"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 19:23:03","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":["7566","RENT","\u9810\u7e73\u79df\u91d1",2,2312,"MO","1",2312,"2","2020-02-20 19:23:02","2","2020-02-20 19:23:02"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 19:23:03","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":["7566","RENT","\u9810\u7e73\u79df\u91d1",3,2312,"MO","1",2312,"2","2020-02-20 19:23:02","2","2020-02-20 19:23:02"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 19:23:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6936,0,"7566"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-02-20 19:23:03","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":["1169","NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207214","2020-02-20 19:23:02",6936,"2","2020-02-20 19:23:02","2","2020-02-20 19:23:02","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 19:23:03","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":["7214","DEPOSIT",null,"PAID","2020-02-20 19:23:02",0,"2","2020-02-20 19:23:02","2","2020-02-20 19:23:02"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-20 19:23:03","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":["7214","INVOICE","7566","PAID","2020-02-20 19:23:02",6936,"2","2020-02-20 19:23:02","2","2020-02-20 19:23:02"]},"data_before":[],"data_after":[],"step":1}
*****