\r\n\t\t\t\t\tM20 4X3X4 $598.00 N\/A <\/td> <\/td> \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":"568.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 12:09:52","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","2",1447,"NEW","A14-CT207345",598,568,0,0,"4","4",2272,2272,2272,"2020-03-07 12:09:52","0",null,null,null,"2020-03-22","2020-07-21","4 months contract. Storage rental paid by cash on March 7, 2020. Storage deposit $1196 transferred from agreement A14-CT196422 to this agreement.\r\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196422, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1196.0","2020-03-22","12",0,null,0,"0","2","2020-03-07 12:09:52","2","2020-03-07 12:09:52","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"191,03201","C191447","PERSONAL","Mr","r7ZMw5+gvVPJEbOGvzW2eA==","brgGVGuPrfoSjI4k+kLGow==","","vwhP+yYU979j1IYrPaAewIRPS8ehlS1H96rdTWSLd7qM5Oal0cPlaQyzHMh9\/xwFb2hdzm8MH12mYhqzH\/mnjrpbzlu+e+Og146xkagM+R0=","9fB1C9GBClx2SST6Fs3MQA==","LzSRnclRfzwcqs62h9RfY8XSQVhof\/4Xatlmf9a\/HHg=","nCw6FUnPF7aVTQtKLG0isQ==",null,1,6422]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 12:09:52","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":["7345","609","598.0","598.00","2","2020-03-07 12:09:52"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 12:09:52","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-03-22","2020-07-21","609"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-07 12:09:52","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":["7345",1447,"SETTLED","A14-I207673","2020-03-07 12:09:52","2020-03-22","2","2020-03-07 12:09:52","2","2020-03-07 12:09:52"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 12:09:52","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":["7673","RENT","\u9810\u7e73\u79df\u91d1",1,568,"MO","1",568,"2","2020-03-07 12:09:52","2","2020-03-07 12:09:52"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 12:09:52","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":["7673","RENT","\u9810\u7e73\u79df\u91d1",2,568,"MO","1",568,"2","2020-03-07 12:09:52","2","2020-03-07 12:09:52"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 12:09:52","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":["7673","RENT","\u9810\u7e73\u79df\u91d1",3,568,"MO","1",568,"2","2020-03-07 12:09:52","2","2020-03-07 12:09:52"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 12:09:52","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":["7673","RENT","\u9810\u7e73\u79df\u91d1",4,568,"MO","1",568,"2","2020-03-07 12:09:52","2","2020-03-07 12:09:52"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 12:09:52","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2272,0,"7673"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-07 12:09:52","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":[1447,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207321","2020-03-07 12:09:52",2272,"2","2020-03-07 12:09:52","2","2020-03-07 12:09:52","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 12:09:52","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":["7321","DEPOSIT",null,"PAID","2020-03-07 12:09:52",0,"2","2020-03-07 12:09:52","2","2020-03-07 12:09:52"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 12:09:52","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":["7321","INVOICE","7673","PAID","2020-03-07 12:09:52",2272,"2","2020-03-07 12:09:52","2","2020-03-07 12:09:52"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 12:38:26","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":"all=1&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"376","master_room_id":"11","room_code":"G17"},{"room_id":"377","master_room_id":"11","room_code":"G18"},{"room_id":"378","master_room_id":"11","room_code":"G19"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1237,"customer_code":"C191237","identity_type":"PERSONAL","identity_id":"P559566(9)","title":"Ms","lastname":"Leung","firstname":"Fung Sin","companyname":"","email":"ann6811608@gmail.com","tel":"97780111","address":"DD 129 Lot Fu Cho Deep Bay Road, Lau Fo Shan, Yuen Long, New Territories","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-01","renew_room_key":"076,34910","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 31, 2020. Deposit $1638 transferred from agreement A14-CT206887 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\tN07 4X3X4 $598.00 N\/A <\/td> <\/td> \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":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 12:38:27","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","2",1237,"NEW","A14-CT207346",598,598,0,0,"1","1",598,598,598,"2020-03-07 12:38:27","0",null,null,null,"2020-03-01","2020-03-31","1 month contract. Storage rental paid by bank transfer on March 6, 2020. Extra $2 will transfer to next contract. Deposit $1638 transferred from agreement A14-CT207082 to this agreement. \r\n","2020-03-01","12",0,null,0,"0","2","2020-03-07 12:38:26","2","2020-03-07 12:38:26","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,34910","C191237","PERSONAL","Ms","Mp1uQYBOKjCa3MjeNTcq3A==","xEf2h2aoyRQ71ZVgBH+9WQ==","","iW47FVp7s8TaEAMIorm0fGFj9skS6ydpaz9yZj+INMKJBmGfo988uGIjotbmyMfP2KQgH8yFjAojrqrHAGBn6MgcYUYvWbTLv+DzFp74hsI=","PTohJuR+UgjG7jslfxI4rw==","cH16fP4YQ5zYD3D2dgGxK3fdRCDVqpQpUvgIFEG73lQ=","8oqTJK9vVVGqI+5lGb64IA==",null,1,"6047"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 12:38:27","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":["7346","690","598.0","598.00","2","2020-03-07 12:38:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 12:38:27","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-03-01","2020-03-31","690"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-07 12:38:27","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":["7346",1237,"SETTLED","A14-I207674","2020-03-07 12:38:26","2020-03-01","2","2020-03-07 12:38:26","2","2020-03-07 12:38:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 12:38:27","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":["7674","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-03-07 12:38:26","2","2020-03-07 12:38:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 12:38:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7674"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-07 12:38:27","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":[1237,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207322","2020-03-07 12:38:26",598,"2","2020-03-07 12:38:26","2","2020-03-07 12:38:26","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 12:38:27","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":["7322","DEPOSIT",null,"PAID","2020-03-07 12:38:26",0,"2","2020-03-07 12:38:26","2","2020-03-07 12:38:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 12:38:27","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":["7322","INVOICE","7674","PAID","2020-03-07 12:38:26",598,"2","2020-03-07 12:38:26","2","2020-03-07 12:38:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 12:39:50","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":"all=1&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"376","master_room_id":"11","room_code":"G17"},{"room_id":"377","master_room_id":"11","room_code":"G18"},{"room_id":"378","master_room_id":"11","room_code":"G19"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":445,"customer_code":"C170445","identity_type":"PERSONAL","identity_id":"K738319(3)","title":"Mr","lastname":"Sin","firstname":"Dai Chuen Sunny","companyname":"","email":"sindaichuen@netvigator.com","tel":"93632429","address":"\u9999\u6e2f\u4ed4\u4e2d\u5fc3K\u5ea7\u6d77\u6676\u95a313\u6a134\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1198.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-10","renew_room_key":"054,60440","renew_remark":"1 month contract. Storage rental paid by bank transfer on February 7,2020. Storage deposit transferred from agreement A14-CT206892 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\tN39 3X6X8 $1318.00 N\/A <\/td> <\/td> \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":"18","total_discounted_price":"1198.0","deposit":"0","total_retail_price":"1318.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 12:39:50","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","2",445,"NEW","A14-CT207347",1318,1198,0,0,"1","1",1198,1198,1198,"2020-03-07 12:39:50","0",null,null,null,"2020-03-10","2020-04-09","1 month contract. Storage rental paid by bank transfer on March 7,2020. Storage deposit transferred from agreement A14-CT207145 to this agreement.\r\n","2020-03-10","18",0,null,0,"0","2","2020-03-07 12:39:49","2","2020-03-07 12:39:49","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,60440","C170445","PERSONAL","Mr","9L2K7wn1Opvr3WQ4vJABDA==","995YTEe316mZ2NiY\/8o00g==","","mvDoTgHRyEEzx3aiSCEV4DxQZHD5YYGgvyNzPm1QCr\/nAPIFPb3QfWTpiQPnxKX2","QrHnF9IXwKZ9qN6l8eYD5g==","A+zYSJpoRkceQYWowNFQUv3ec39gnccN6z82YnuKfNw=","d5o++GGoW7Lf\/yZcJ7PGQw==",null,1,"4712"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 12:39:50","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":["7347","722","1318.0","1318.00","2","2020-03-07 12:39:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 12:39:50","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-03-10","2020-04-09","722"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-07 12:39:50","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":["7347",445,"SETTLED","A14-I207675","2020-03-07 12:39:49","2020-03-10","2","2020-03-07 12:39:49","2","2020-03-07 12:39:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 12:39:50","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":["7675","RENT","\u9810\u7e73\u79df\u91d1",1,1198,"MO","1",1198,"2","2020-03-07 12:39:49","2","2020-03-07 12:39:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 12:39:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1198,0,"7675"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-07 12:39:50","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":[445,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207323","2020-03-07 12:39:49",1198,"2","2020-03-07 12:39:49","2","2020-03-07 12:39:49","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 12:39:50","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":["7323","DEPOSIT",null,"PAID","2020-03-07 12:39:49",0,"2","2020-03-07 12:39:49","2","2020-03-07 12:39:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 12:39:50","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":["7323","INVOICE","7675","PAID","2020-03-07 12:39:49",1198,"2","2020-03-07 12:39:49","2","2020-03-07 12:39:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 13:12:45","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","floor_plan_rent_room":[],"index_url_parameter":"filter1=2&filter2=1470&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"K430408(A)","title":"Ms","lastname":"MAK","firstname":"Yee Man","companyname":"","email":"","tel":"69270968","address":"\u9c02\u9b5a\u6d8c\u5357\u8c50\u65b0\u90a84\u5ea712\u6a13F\u5ba4","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1483","room_code":"C15-177","retail_price":"1115.0","discounted_price":"1115.00","location_id":"6"}],"roughly_size":"20","total_retail_price":1115,"total_discounted_price":1004,"deposit":1115,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":9817,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3346.00","warehousing_date":"2020-03-08","rent_from":"2020-03-08","rent_to":"2021-03-07","delivery_service":"0","remark":"12 months contract. Special offer 50%off and 2 months free. Deposit $500 paid by bank transfer on Feb 21,2020. The balance of storage renal and deposit $9317 paid by bank transfer on Mar 06,2020. Smartcard provided and mailed out on Mar 07,2020.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":3346,"order_total":13163,"final_order_total":9817,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012488883","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \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> \n\t\t\t\t\tC15-177 4X5X6.5 $1115.00 - <\/td> \u9810\u4ed83\u500b\u6708 \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"20","total_discounted_price":"1004.00","deposit":"1115.00","total_retail_price":"1115.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 13:12:46","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":["C201529","PERSONAL","Ms","OSpwVZLaj11jKWHakE7sQg==","22KPgW1C3CU66tb5kESLdQ==","","\/AutW89B8NRv7G3KMNTyTQ==",null,"nELiZMzA+bAVEMcdeiAvsrRwEbDJu\/xcppTj1Fm1IgGVnv43lIQ2OXVpHPXR4nB7","pagKsuTaMkvDGOWW8mfdvQ==",null,null,"G77vZU8757WXR78gpbCY3Q==","2","2020-03-07 13:12:45","2","2020-03-07 13:12:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 13:12:47","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","3","6",1529,"NEW","C15-CT207348",1115,1004,1115,0,"12","12",9817,13163,9817,"2020-03-07 13:12:47","0",null,null,null,"2020-03-08","2021-03-07","12 months contract. Special offer 50%off and 2 months free. Deposit $500 paid by bank transfer on Feb 21,2020. The balance of storage renal and deposit $9317 paid by bank transfer on Mar 06,2020. Smartcard provided and mailed out on Mar 07,2020.","2020-03-08","20",0,null,3346,"3346.00","2","2020-03-07 13:12:45","2","2020-03-07 13:12:45","BANKIN","","","","BANKIN","","","",null,0,"0012488883","C201529","PERSONAL","Ms","OSpwVZLaj11jKWHakE7sQg==","22KPgW1C3CU66tb5kESLdQ==","","nELiZMzA+bAVEMcdeiAvsrRwEbDJu\/xcppTj1Fm1IgGVnv43lIQ2OXVpHPXR4nB7","\/AutW89B8NRv7G3KMNTyTQ==",null,"pagKsuTaMkvDGOWW8mfdvQ==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 13:12:47","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":["7348","1483","1115.0","1115.00","2","2020-03-07 13:12:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 13:12:47","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-03-08","2021-03-07","1483"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-07 13:12:47","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":["7348","C15-D205312","PAID",1115,0,"2021-03-07","2020-03-07 13:12:45","2020-03-07 13:12:45","2","2020-03-07 13:12:45","2","2020-03-07 13:12:45",1529]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 13:12:47","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":["7348",1529,"SETTLED","C15-I207676","2020-03-07 13:12:45","2020-03-08","2","2020-03-07 13:12:45","2","2020-03-07 13:12:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 13:12:47","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":["7676","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-03-07 13:12:45","2","2020-03-07 13:12:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 13:12:47","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":["7676","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-03-07 13:12:45","2","2020-03-07 13:12:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 13:12:47","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":["7676","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,0,"MO","1",0,"2","2020-03-07 13:12:45","2","2020-03-07 13:12:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 13:12:47","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":["7676","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",4,670,"MO","1",670,"2","2020-03-07 13:12:45","2","2020-03-07 13:12:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 13:12:47","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":["7676","RENT","\u9810\u7e73\u79df\u91d1",5,1004,"MO","1",1004,"2","2020-03-07 13:12:45","2","2020-03-07 13:12:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 13:12:47","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":["7676","RENT","\u9810\u7e73\u79df\u91d1",6,1004,"MO","1",1004,"2","2020-03-07 13:12:45","2","2020-03-07 13:12:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 13:12:47","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":["7676","RENT","\u9810\u7e73\u79df\u91d1",7,1004,"MO","1",1004,"2","2020-03-07 13:12:45","2","2020-03-07 13:12:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 13:12:47","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":["7676","RENT","\u9810\u7e73\u79df\u91d1",8,1004,"MO","1",1004,"2","2020-03-07 13:12:45","2","2020-03-07 13:12:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 13:12:47","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":["7676","RENT","\u9810\u7e73\u79df\u91d1",9,1004,"MO","1",1004,"2","2020-03-07 13:12:45","2","2020-03-07 13:12:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 13:12:47","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":["7676","RENT","\u9810\u7e73\u79df\u91d1",10,1004,"MO","1",1004,"2","2020-03-07 13:12:45","2","2020-03-07 13:12:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 13:12:47","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":["7676","RENT","\u9810\u7e73\u79df\u91d1",11,1004,"MO","1",1004,"2","2020-03-07 13:12:45","2","2020-03-07 13:12:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 13:12:47","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":["7676","RENT","\u9810\u7e73\u79df\u91d1",12,1004,"MO","1",1004,"2","2020-03-07 13:12:45","2","2020-03-07 13:12:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 13:12:47","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8702,0,"7676"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-07 13:12:47","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":[1529,"BANKIN","","","","BANKIN","","","","PAID","P207324","2020-03-07 13:12:45",9817,"2","2020-03-07 13:12:45","2","2020-03-07 13:12:45","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 13:12:47","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":["7324","DEPOSIT","5312","PAID","2020-03-07 13:12:45",1115,"2","2020-03-07 13:12:45","2","2020-03-07 13:12:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 13:12:47","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":["7324","INVOICE","7676","PAID","2020-03-07 13:12:45",8702,"2","2020-03-07 13:12:45","2","2020-03-07 13:12:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 13:47:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 15:47:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 16:01:31","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","floor_plan_rent_room":[],"index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"Y091089(7)","title":"Ms","lastname":"YIM","firstname":"Yat Yu Phoenix","companyname":"","email":"phoenixy913@gmail.com","tel":"92009767","address":"Flat 608, 6\/F, Pik Long Hse, Shek Pai Wan Est, Aberdeen, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"131","room_code":"C07","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1098,"deposit":2196,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3843,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1647.00","warehousing_date":"2020-03-23","rent_from":"2020-03-23","rent_to":"2020-06-22","delivery_service":"0","remark":"3 months contract. Special offer 50% off. Storage rental and deposit paid by EPS on Mar 07,2020. Smartcard provided on the same day.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":1647,"order_total":5490,"final_order_total":3843,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190,39716","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \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> \n\t\t\t\t\tC07 4X4X8 $1098.00 - <\/td> \u9810\u4ed86\u500b\u6708 \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"16","total_discounted_price":"1098.00","deposit":"2196.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 16:01:33","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":["C201530","PERSONAL","Ms","WGUvdUMJNIeY4+94TsoUOw==","S\/ugMns\/7JWW81SW9VU9Dw==","","rh6cJcP5HiOW53mtdTdFqw==","ja3mTKRt2XPWnj1qjfkjasRm0sQ6LEAzKdGBUFU0d0g=","7eLUmR7zfauTaCI9eJ0Uarw1CWPcYZ7J\/4uuZGP7O\/ge4WXqMcvaF5lRCX+vUxsungay2jBuzTWIbsfSHrNbaQ==","78ySvidUCLMnh17Ib4LxBQ==",null,"ja3mTKRt2XPWnj1qjfkjasRm0sQ6LEAzKdGBUFU0d0g=","bcE+VIeNy3eAwN0+CjChdQ==","2","2020-03-07 16:01:31","2","2020-03-07 16:01:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 16:01:33","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",1530,"NEW","A12-CT207349",1098,1098,2196,0,"3","3",3843,5490,3843,"2020-03-07 16:01:33","0",null,null,null,"2020-03-23","2020-06-22","3 months contract. Special offer 50% off. Storage rental and deposit paid by EPS on Mar 07,2020. Smartcard provided on the same day.","2020-03-23","16",0,null,1647,"1647.00","2","2020-03-07 16:01:31","2","2020-03-07 16:01:31","EPS","","","","EPS","","","",null,0,"190,39716","C201530","PERSONAL","Ms","WGUvdUMJNIeY4+94TsoUOw==","S\/ugMns\/7JWW81SW9VU9Dw==","","7eLUmR7zfauTaCI9eJ0Uarw1CWPcYZ7J\/4uuZGP7O\/ge4WXqMcvaF5lRCX+vUxsungay2jBuzTWIbsfSHrNbaQ==","rh6cJcP5HiOW53mtdTdFqw==","ja3mTKRt2XPWnj1qjfkjasRm0sQ6LEAzKdGBUFU0d0g=","78ySvidUCLMnh17Ib4LxBQ==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 16:01:33","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":["7349","131","1098.0","1098.00","2","2020-03-07 16:01:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 16:01:33","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-03-23","2020-06-22","131"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-07 16:01:33","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":["7349","A12-D205313","PAID",2196,0,"2020-06-22","2020-03-07 16:01:31","2020-03-07 16:01:31","2","2020-03-07 16:01:31","2","2020-03-07 16:01:31",1530]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 16:01:33","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":["7349",1530,"SETTLED","A12-I207677","2020-03-07 16:01:31","2020-03-23","2","2020-03-07 16:01:31","2","2020-03-07 16:01:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 16:01:33","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":["7677","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-03-07 16:01:31","2","2020-03-07 16:01:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 16:01:33","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":["7677","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,549,"MO","1",549,"2","2020-03-07 16:01:31","2","2020-03-07 16:01:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 16:01:33","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":["7677","RENT","\u9810\u7e73\u79df\u91d1",3,1098,"MO","1",1098,"2","2020-03-07 16:01:31","2","2020-03-07 16:01:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 16:01:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1647,0,"7677"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-07 16:01:33","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":[1530,"EPS","","","","EPS","","","","PAID","P207325","2020-03-07 16:01:31",3843,"2","2020-03-07 16:01:31","2","2020-03-07 16:01:31","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 16:01:33","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":["7325","DEPOSIT","5313","PAID","2020-03-07 16:01:31",2196,"2","2020-03-07 16:01:31","2","2020-03-07 16:01:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-07 16:01:33","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":["7325","INVOICE","7677","PAID","2020-03-07 16:01:31",1647,"2","2020-03-07 16:01:31","2","2020-03-07 16:01:31"]},"data_before":[],"data_after":[],"step":1}
*****