\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-03-18 10:12:56","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-CT207427",1768,1535,0,0,"1","1",1535,1535,1535,"2020-03-18 10:12:56","0",null,null,null,"2020-03-19","2020-04-18","1 month contract. Storage rental paid by cash on March 18, 2020. Storage deposit transferred from agreement A12-CT207236 to this agreement.","2020-03-19","24",0,null,0,"0","2","2020-03-18 10:12:56","2","2020-03-18 10:12:56","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-03-18 10:12:56","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":["7427","373","1768.0","1768.00","2","2020-03-18 10:12:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:12:56","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-19","2020-04-18","373"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-18 10:12:56","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":["7427",275,"SETTLED","A12-I207755","2020-03-18 10:12:56","2020-03-19","2","2020-03-18 10:12:56","2","2020-03-18 10:12:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:12:56","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":["7755","RENT","\u9810\u7e73\u79df\u91d1",1,1535,"MO","1",1535,"2","2020-03-18 10:12:56","2","2020-03-18 10:12:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:12:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1535,0,"7755"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-18 10:12:56","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","P207403","2020-03-18 10:12:56",1535,"2","2020-03-18 10:12:56","2","2020-03-18 10:12:56","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:12:56","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":["7403","DEPOSIT",null,"PAID","2020-03-18 10:12:56",0,"2","2020-03-18 10:12:56","2","2020-03-18 10:12:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:12:56","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":["7403","INVOICE","7755","PAID","2020-03-18 10:12:56",1535,"2","2020-03-18 10:12:56","2","2020-03-18 10:12:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:25:15","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=571&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"732","master_room_id":"34","room_code":"O08"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":823,"customer_code":"C180823","identity_type":"BUSINESS","identity_id":"39661261","title":"Mr","lastname":"Milan Martinez","firstname":"Alejandro","companyname":"La Nao Group Limited","email":"a.milan@la-nao.com","tel":"90212010","address":"13A, Trust Tower, 68 Johnston Road, Wanchai, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2318.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-13","renew_room_key":"055,09251","renew_remark":"1 month contract. Storage rental paid by bank transfer on February 14, 2020. Storage deposit transferred from agreement A14-CT206985 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207199, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"794","room_code":"K60","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"515","room_code":"K52","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":2318,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2318,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-13","rent_from":"2020-02-13","rent_to":"2020-03-12","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on March 16, 2020. Storage deposit transferred from agreement A14-CT207199 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2318,"final_order_total":2318,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,09251","order_product":[],"pass":true}},"first_order_id":"4785","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\tK60 4X4X8 $1098.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\tK52 4X4X8 $1098.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":"32","total_discounted_price":"2318.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:25:15","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",823,"NEW","A14-CT207428",2196,2318,0,0,"1","1",2318,2318,2318,"2020-03-18 10:25:15","0",null,null,null,"2020-02-13","2020-03-12","1 month contract. Storage rental paid by bank transfer on March 16, 2020. Storage deposit transferred from agreement A14-CT207199 to this agreement.","2020-02-13","32",0,null,0,"0","2","2020-03-18 10:25:15","2","2020-03-18 10:25:15","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,09251","C180823","BUSINESS","Mr","Ltuw0GNYtUHvg5xq\/qUHZw==","B0t4iVfZVAQdLpfngFJQ9g==","La Nao Group Limited","ogXiJSz6bxnQX1arPQzS4HtoujvXU7DtPI6iXMqgmibwYxgUDD+7IDSdp7zHKT1WsucqNnxkVRDDkoVXniYCDA==","oMTdQIHVXIpTgMmFZOwTlA==","toRvij1IyfmFV4d7mZnp4cg+UZM6Nv9c2C6kHmvTa8c=",null,"mWmgEjucdLaH5rglf7tExg==",1,"4785"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:25:15","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":["7428","794","1098.0","1098.00","2","2020-03-18 10:25:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:25:15","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-13","2020-03-12","794"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-18 10:25:15","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":["7428","515","1098.0","1098.00","2","2020-03-18 10:25:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:25:15","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-13","2020-03-12","515"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-18 10:25:15","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":["7428",823,"SETTLED","A14-I207756","2020-03-18 10:25:15","2020-02-13","2","2020-03-18 10:25:15","2","2020-03-18 10:25:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:25:15","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":["7756","RENT","\u9810\u7e73\u79df\u91d1",1,2318,"MO","1",2318,"2","2020-03-18 10:25:15","2","2020-03-18 10:25:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:25:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2318,0,"7756"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-18 10:25:15","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":[823,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207404","2020-03-18 10:25:15",2318,"2","2020-03-18 10:25:15","2","2020-03-18 10:25:15","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:25:15","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":["7404","DEPOSIT",null,"PAID","2020-03-18 10:25:15",0,"2","2020-03-18 10:25:15","2","2020-03-18 10:25:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:25:15","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":["7404","INVOICE","7756","PAID","2020-03-18 10:25:15",2318,"2","2020-03-18 10:25:15","2","2020-03-18 10:25:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:47: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","index_url_parameter":"filter1=1&filter2=571&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"238","master_room_id":"6","room_code":"D42"},{"room_id":"239","master_room_id":"6","room_code":"D43"},{"room_id":"249","master_room_id":"6","room_code":"D53"},{"room_id":"250","master_room_id":"6","room_code":"D54"}],"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\tD42 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\tD43 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\tD53 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\tD54 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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"D125298(5)","title":"Mr","lastname":"TSUI","firstname":"Kam Lun","companyname":"","email":"alantsui0620@gmail.com","tel":"93258253","address":"Room 906, Wah Yin House, Wah Kwai Estate, Aberdeen, H.K.","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"469","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"998.00","discount":"4.91","monthly_deduct":49.0018,"room_id":"250","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"469","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"998.00","discount":"4.91","monthly_deduct":49.0018,"room_id":"249","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"469","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"998.00","discount":"4.91","monthly_deduct":49.0018,"room_id":"239","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"469","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"998.00","discount":"4.91","monthly_deduct":49.0018,"room_id":"238","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"238","room_code":"D42","retail_price":"998.0","discounted_price":949,"location_id":"1"},{"room_id":"239","room_code":"D43","retail_price":"998.0","discounted_price":949,"location_id":"1"},{"room_id":"249","room_code":"D53","retail_price":"998.0","discounted_price":949,"location_id":"1"},{"room_id":"250","room_code":"D54","retail_price":"998.0","discounted_price":949,"location_id":"1"}],"roughly_size":"48","total_retail_price":3992,"total_discounted_price":3485,"deposit":7336,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":12838,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"4953.00","warehousing_date":"2020-03-25","rent_from":"2020-03-25","rent_to":"2020-06-24","delivery_service":"0","remark":"3 months contract. Special offer first 3 months 50% off. Storage rental and deposit paid by cash on March 18, 2020. Smartcard and padlock provided on March 18, 2020. ","paymethod":"CASH","paymethod2":"CASH","discount_deduct":4953,"order_total":17791,"final_order_total":12838,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190, 39669","order_product":[],"pass":true}},"roughly_size":"48","total_discounted_price":"3485.00","deposit":"7336.00","total_retail_price":"3992.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:47:32","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":["C201538","PERSONAL","Mr","pEbcaHC\/pfkOb62ZmXi\/xg==","4zek2V6v+muRHEsNI7xEHw==","","jD8m5+oNvPK+rounbt\/1YA==","kEYaF0oS4wB5ZGnrK8ZGHyxa2HqcDeHeRYnpppRJodU=","X4JJcZ3sWI5XTJc7AfbY4JMHQCqXJ0AUevjgcL3lt2LsRwZUiBp22Cu7iQT+WBYlMvlBfY6C6OUXw8RFvQIk8g==","hVkoyO4f5Aj6YCior\/LFvg==",null,"kEYaF0oS4wB5ZGnrK8ZGHyxa2HqcDeHeRYnpppRJodU=","M5wOF2jz4o5U9GQSy\/sQDw==","2","2020-03-18 10:47:31","2","2020-03-18 10:47:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:47:32","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",1538,"NEW","A12-CT207429",3992,3485,7336,0,"3","3",12838,17791,12838,"2020-03-18 10:47:32","0",null,null,null,"2020-03-25","2020-06-24","3 months contract. Special offer first 3 months 50% off. Storage rental and deposit paid by cash on March 18, 2020. Smartcard and padlock provided on March 18, 2020. ","2020-03-25","48",0,null,4953,"4953.00","2","2020-03-18 10:47:31","2","2020-03-18 10:47:31","CASH","","","","CASH","","","",null,0,"190, 39669","C201538","PERSONAL","Mr","pEbcaHC\/pfkOb62ZmXi\/xg==","4zek2V6v+muRHEsNI7xEHw==","","X4JJcZ3sWI5XTJc7AfbY4JMHQCqXJ0AUevjgcL3lt2LsRwZUiBp22Cu7iQT+WBYlMvlBfY6C6OUXw8RFvQIk8g==","jD8m5+oNvPK+rounbt\/1YA==","kEYaF0oS4wB5ZGnrK8ZGHyxa2HqcDeHeRYnpppRJodU=","hVkoyO4f5Aj6YCior\/LFvg==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:47:32","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":["7429","469","6","250","%","4.91",49.0018,"2","2020-03-18 10:47:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:47:32","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":["7429","469","6","249","%","4.91",49.0018,"2","2020-03-18 10:47:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:47:32","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":["7429","469","6","239","%","4.91",49.0018,"2","2020-03-18 10:47:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:47:32","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":["7429","469","6","238","%","4.91",49.0018,"2","2020-03-18 10:47:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:47:32","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":["7429","238","998.0",949,"2","2020-03-18 10:47:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:47:32","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-25","2020-06-24","238"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-18 10:47:32","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":["7429","239","998.0",949,"2","2020-03-18 10:47:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:47:32","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-25","2020-06-24","239"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-18 10:47:32","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":["7429","249","998.0",949,"2","2020-03-18 10:47:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:47:32","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-25","2020-06-24","249"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-18 10:47:32","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":["7429","250","998.0",949,"2","2020-03-18 10:47:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:47:32","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-25","2020-06-24","250"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-18 10:47:32","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":["7429","A12-D205322","PAID",7336,0,"2020-06-24","2020-03-18 10:47:31","2020-03-18 10:47:31","2","2020-03-18 10:47:31","2","2020-03-18 10:47:31",1538]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:47:32","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":["7429",1538,"SETTLED","A12-I207757","2020-03-18 10:47:31","2020-03-25","2","2020-03-18 10:47:31","2","2020-03-18 10:47:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:47:32","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":["7757","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-03-18 10:47:31","2","2020-03-18 10:47:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:47:32","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":["7757","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,2017,"MO","1",2017,"2","2020-03-18 10:47:31","2","2020-03-18 10:47:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:47:32","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":["7757","RENT","\u9810\u7e73\u79df\u91d1",3,3485,"MO","1",3485,"2","2020-03-18 10:47:31","2","2020-03-18 10:47:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:47:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5502,0,"7757"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-18 10:47:32","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":[1538,"CASH","","","","CASH","","","","PAID","P207405","2020-03-18 10:47:31",12838,"2","2020-03-18 10:47:31","2","2020-03-18 10:47:31","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:47:32","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":["7405","DEPOSIT","5322","PAID","2020-03-18 10:47:31",7336,"2","2020-03-18 10:47:31","2","2020-03-18 10:47:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:47:32","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":["7405","INVOICE","7757","PAID","2020-03-18 10:47:31",5502,"2","2020-03-18 10:47:31","2","2020-03-18 10:47:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 10:52:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:06:25","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":[{"room_id":"1214","master_room_id":"143","room_code":"B01-024"}],"selected_room_tr":"\n\t\t\t\t\t\t\t\t\t\t\t\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n\t\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\t\t\t\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>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> \n\t\t\t\t\tB01-023 5X6X7 $1838.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\t\t\t\t\tB01-024 4X6X7 $1488.00 N\/A <\/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\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"Y064298(1)","title":"Ms","lastname":"TONG","firstname":"Ka Ming","companyname":"","email":"kaming.tong928@gmail.com","tel":"60266931","address":"\u5c07\u8ecd\u6fb3\u539a\u5fb7\u6751\u5fb7\u88d5\u6a1337\u6a134\u5ba4","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1213","room_code":"B01-023","retail_price":"1838.0","discounted_price":"1838.00","location_id":"5"},{"room_id":"1214","room_code":"B01-024","retail_price":"1488.0","discounted_price":"1488.00","location_id":"5"}],"roughly_size":"54","total_retail_price":3326,"total_discounted_price":3058,"deposit":6116,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":9021,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"153.00","warehousing_date":"2020-03-17","rent_from":"2020-03-17","rent_to":"2020-04-16","delivery_service":"0","remark":"1 month contract. Special offer 5% discount. $500 deposit paid by cash on Mar 16,2020. The balance of storage rental and deposit $8581 paid by bank transfer on Mar 17,2020. Smart card paid on the same day.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":153,"order_total":9234,"final_order_total":9081,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0005795970","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"pass":true}},"roughly_size":"54","total_discounted_price":"3058.00","deposit":"6116.00","total_retail_price":"3326.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:06:26","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":["C201539","PERSONAL","Ms","emjjkRBZVUSRLbEK77SFEw==","gXED7wniUUNHTT8LsF+fbg==","","rzzpVRFrFmmseYl9vvbFwA==","YSHrDxAftHtY\/YX7L1PEr5QDC4wwmDjJTX59NG9kGk0=","bNlP7L7RLt8Fl8B\/yay2q\/dmX7vl9M\/ct23uQR74gJmaO+DCNAZgg0xupPoXF2Hi","0ux6P2R1VhDModzCYtVS5A==",null,"YSHrDxAftHtY\/YX7L1PEr5QDC4wwmDjJTX59NG9kGk0=","V6gHwSF0lwKDy8EkEc917w==","2","2020-03-18 11:06:25","2","2020-03-18 11:06:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:06: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` = ?","parameters":["1","2","5",1539,"NEW","B01-CT207430",3326,3058,6116,0,"1","1",9021,9234,9081,"2020-03-18 11:06:27","0",null,null,null,"2020-03-17","2020-04-16","1 month contract. Special offer 5% discount. $500 deposit paid by cash on Mar 16,2020. The balance of storage rental and deposit $8581 paid by bank transfer on Mar 17,2020. Smart card paid on the same day.","2020-03-17","54",0,null,153,"153.00","2","2020-03-18 11:06:25","2","2020-03-18 11:06:25","BANKIN","","","","BANKIN","","","",null,0,"0005795970","C201539","PERSONAL","Ms","emjjkRBZVUSRLbEK77SFEw==","gXED7wniUUNHTT8LsF+fbg==","","bNlP7L7RLt8Fl8B\/yay2q\/dmX7vl9M\/ct23uQR74gJmaO+DCNAZgg0xupPoXF2Hi","rzzpVRFrFmmseYl9vvbFwA==","YSHrDxAftHtY\/YX7L1PEr5QDC4wwmDjJTX59NG9kGk0=","0ux6P2R1VhDModzCYtVS5A==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:06:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7430",1539,"11","1","60.0",60,"2","2020-03-18 11:06:25","2","2020-03-18 11:06:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:06:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"7430"]},"data_before":[],"data_after":[],"step":4}
*****
{"created_at":"2020-03-18 11:06: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":["7430","1213","1838.0","1838.00","2","2020-03-18 11:06:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:06: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-17","2020-04-16","1213"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-18 11:06: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":["7430","1214","1488.0","1488.00","2","2020-03-18 11:06:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:06: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-17","2020-04-16","1214"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-18 11:06:27","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":["7430","B01-D205323","PAID",6116,0,"2020-04-16","2020-03-18 11:06:25","2020-03-18 11:06:25","2","2020-03-18 11:06:25","2","2020-03-18 11:06:25",1539]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:06: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":["7430",1539,"SETTLED","B01-I207758","2020-03-18 11:06:25","2020-03-17","2","2020-03-18 11:06:25","2","2020-03-18 11:06:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:06: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":["7758","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,2905,"MO","1",2905,"2","2020-03-18 11:06:25","2","2020-03-18 11:06:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:06:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7758","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-03-18 11:06:25","2","2020-03-18 11:06:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:06:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2965,0,"7758"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-18 11:06: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":[1539,"BANKIN","","","","BANKIN","","","","PAID","P207406","2020-03-18 11:06:25",9081,"2","2020-03-18 11:06:25","2","2020-03-18 11:06:25","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:06: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":["7406","DEPOSIT","5323","PAID","2020-03-18 11:06:25",6116,"2","2020-03-18 11:06:25","2","2020-03-18 11:06:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:06: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":["7406","INVOICE","7758","PAID","2020-03-18 11:06:25",2965,"2","2020-03-18 11:06:25","2","2020-03-18 11:06:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:25:47","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=571&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"238","master_room_id":"6","room_code":"D42"},{"room_id":"239","master_room_id":"6","room_code":"D43"},{"room_id":"249","master_room_id":"6","room_code":"D53"},{"room_id":"250","master_room_id":"6","room_code":"D54"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":610,"customer_code":"C170610","identity_type":"PERSONAL","identity_id":"Z082137(4)","title":"Mr","lastname":"Yuen","firstname":"Chi Wai","companyname":"","email":"waijeff@yahoo.com","tel":"91775726","address":"Room 2010, Wah Yin House, Wah Kwai Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"698.0","renew_rent_month":"2","renew_warehousing_date":"2020-02-16","renew_room_key":"055,37967","renew_remark":"2 months contract. Storage rental paid by bank transfer on Jan 07,2020. Storage deposit transferred from agreement A14-CT195474 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT206891, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"30","order_discount":[],"order_room":[{"room_id":"642","room_code":"M53","retail_price":"775.0","discounted_price":"775.00","location_id":"2"}],"roughly_size":"9","total_retail_price":775,"total_discounted_price":698,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":1396,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-16","rent_from":"2020-02-16","rent_to":"2020-04-15","delivery_service":"0","remark":"2 months contract. Special offer $698\/month. Storage rental paid by bank transfer on March 17, 2020. Storage deposit transferred from agreement A14-CT206891 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1396,"final_order_total":1396,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,37967","order_product":[],"pass":true}},"first_order_id":"3936","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\tM53 3X3X8 $775.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":"9","total_discounted_price":"698.0","deposit":"0","total_retail_price":"775.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:25: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",610,"NEW","A14-CT207431",775,698,0,0,"2","2",1396,1396,1396,"2020-03-18 11:25:47","0",null,null,null,"2020-02-16","2020-04-15","2 months contract. Special offer $698\/month. Storage rental paid by bank transfer on March 17, 2020. Storage deposit transferred from agreement A14-CT206891 to this agreement.","2020-02-16","9",0,null,0,"0","2","2020-03-18 11:25:47","2","2020-03-18 11:25:47","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,37967","C170610","PERSONAL","Mr","gRYbQt3pC62mUupe40WPwQ==","DtbrOSvE4C7BOu5x4dBFtg==","","7OBn1YtfKbtu\/m30fJWXHKa2ex+ax1hlgO7w1bfVyVziN7HN621Vte0mJS4BimBLi29JbHIlOu0YL\/eGNB5eJg==","t3Y91fzQTOQ0zfQ1Vf7lYw==","ZS42Yo\/u\/2uwsXWxVcCwKvxJcoRgo91JieW4VtkBUqY=","g7Of79kzCCBYM1LLpZVVHA==",null,1,"3936"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:25: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":["7431","642","775.0","775.00","2","2020-03-18 11:25:47"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:25: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-02-16","2020-04-15","642"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-18 11:25: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":["7431",610,"SETTLED","A14-I207759","2020-03-18 11:25:47","2020-02-16","2","2020-03-18 11:25:47","2","2020-03-18 11:25:47"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:25: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":["7759","RENT","\u9810\u7e73\u79df\u91d1",1,698,"MO","1",698,"2","2020-03-18 11:25:47","2","2020-03-18 11:25:47"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:25: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":["7759","RENT","\u9810\u7e73\u79df\u91d1",2,698,"MO","1",698,"2","2020-03-18 11:25:47","2","2020-03-18 11:25:47"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:25:47","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1396,0,"7759"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-18 11:25: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":[610,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207407","2020-03-18 11:25:47",1396,"2","2020-03-18 11:25:47","2","2020-03-18 11:25:47","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:25: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":["7407","DEPOSIT",null,"PAID","2020-03-18 11:25:47",0,"2","2020-03-18 11:25:47","2","2020-03-18 11:25:47"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:25: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":["7407","INVOICE","7759","PAID","2020-03-18 11:25:47",1396,"2","2020-03-18 11:25:47","2","2020-03-18 11:25:47"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:27:43","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","076, 26139","3 months contract. Special offer first 3 months 50% off. Storage rental and deposit paid by bank transfer on March 16, 2020. Smartcard provided on March 16, 2020.","2020-03-18 11:27:42","2","RgTQL6em\/We21zilKNSwtg==","QoxtZbvpB3h4jnM47BGoLQ==","gEvUCNziKgP\/TCw2naIi3P83I9N0Hy\/tmv4MZ3e1XM4=","28KM6keYo21+UrqtICcroQ==","wSAAs815SSTsLlXnxGu1os7BzTbR8JUF3k1iys9PHoSaMSxD1mpoR2D3CfwkeEM2WYoQ\/T7ofHQxXl7iPOkXYQ==",7413]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:28:40","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","floor_plan_rent_room":[{"room_id":"238","master_room_id":"6","room_code":"D42"},{"room_id":"239","master_room_id":"6","room_code":"D43"},{"room_id":"249","master_room_id":"6","room_code":"D53"},{"room_id":"250","master_room_id":"6","room_code":"D54"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1063,"customer_code":"C181063","identity_type":"PERSONAL","identity_id":"P150061(2)","title":"Ms","lastname":"HASKINS","firstname":"Eileen Mary","companyname":"","email":"eimart@netvigator.com","tel":"92769708","address":"House 20A Pok Kok Tsven","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-13","renew_room_key":"'0012435080","renew_remark":"1 month contract. Storage rental paid by bank transfer on March 4, 2020. Storage deposit $2580 transferred from agreement A05-CT207182 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\tA05-124 4X4X7 $1290.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":"16","total_discounted_price":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:28:40","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",1063,"NEW","A05-CT207432",1290,1290,0,0,"1","1",1290,1290,1290,"2020-03-18 11:28:40","0",null,null,null,"2020-03-13","2020-04-12","1 month contract. Storage rental paid by bank transfer on March 17, 2020. Storage deposit $2580 transferred from agreement A05-CT207317 to this agreement.\r\n","2020-03-13","16",0,null,0,"0","2","2020-03-18 11:28:40","2","2020-03-18 11:28:40","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0012435080","C181063","PERSONAL","Ms","N2dL4uJnRUVt3pWxZbjoPA==","gBCfCDjxN1soEZ6ASSV8CQ==","","WxFMz3JMJw0zIWOLHcLgDzylG1NdowDT02leCzTzNHk=","9LmyvpD23mCmBchshNAO0w==","WMY4NPSZuxSFljp7Sz0XPINva+8MxbIjoBMZ02LKzdU=","UcXhFM2zM7eIpbzXOGUfvA==",null,1,"3560"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:28:40","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":["7432","1126","1290.0","1290.00","2","2020-03-18 11:28:40"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:28:40","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-13","2020-04-12","1126"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-18 11:28:40","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":["7432",1063,"SETTLED","A05-I207760","2020-03-18 11:28:40","2020-03-13","2","2020-03-18 11:28:40","2","2020-03-18 11:28:40"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:28:40","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":["7760","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-03-18 11:28:40","2","2020-03-18 11:28:40"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:28:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"7760"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-18 11:28:40","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":[1063,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207408","2020-03-18 11:28:40",1290,"2","2020-03-18 11:28:40","2","2020-03-18 11:28:40","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:28:40","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":["7408","DEPOSIT",null,"PAID","2020-03-18 11:28:40",0,"2","2020-03-18 11:28:40","2","2020-03-18 11:28:40"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:28:40","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":["7408","INVOICE","7760","PAID","2020-03-18 11:28:40",1290,"2","2020-03-18 11:28:40","2","2020-03-18 11:28:40"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:52:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 11:52:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 12:11:10","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=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":18,"customer_code":"C150018","identity_type":"PERSONAL","identity_id":"D191657(3)","title":"Ms","lastname":"Wong","firstname":"Hoi Chi","companyname":"","email":null,"tel":"98855112","address":"\u77f3\u6392\u7063\u78a7\u5c71\u6a133\u6a13303\u5ba4","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-02","renew_room_key":"053,34812","renew_remark":"1 month contract. Storage rental paid by cheque on February 17, 2020. Storage deposit transferred from agreement A12-CT206997 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207204, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"141","room_code":"C17","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","warehousing_date":"2020-03-02","rent_from":"2020-03-02","rent_to":"2020-04-01","delivery_service":"0","remark":"1 month contract. Storage rental paid by cheque on February 17, 2020. Storage deposit transferred from agreement A12-CT207204 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"053,34812","order_product":[],"pass":true}},"first_order_id":"4773","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\tC17 4X4X8 $1098.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":"16","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 12:11:11","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",18,"NEW","A12-CT207433",1098,1038,0,0,"1","1",1038,1038,1038,"2020-03-18 12:11:11","0",null,null,null,"2020-03-02","2020-04-01","1 month contract. Storage rental paid by cheque on February 17, 2020. Storage deposit transferred from agreement A12-CT207204 to this agreement.\r\n","2020-03-02","16",0,null,0,"0","2","2020-03-18 12:11:10","2","2020-03-18 12:11:10","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"053,34812","C150018","PERSONAL","Ms","Wf\/obv2attkTYKMJ\/vWT9A==","hULSwM2MvFtpeV9\/z+er8Q==","","\/W3QUjKWE3CC73zLiOhBi2cNYO8UXtn0ViOT+SD0I4Y=","ErI4QcMFcZ94m4Lf9PgLBg==",null,"1f1y9zugJv2nxoT+IuBxXw==",null,1,"4773"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 12:11:11","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":["7433","141","1098.0","1098.00","2","2020-03-18 12:11:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 12:11:11","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-02","2020-04-01","141"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-18 12:11:11","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":["7433",18,"SETTLED","A12-I207761","2020-03-18 12:11:10","2020-03-02","2","2020-03-18 12:11:10","2","2020-03-18 12:11:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 12:11:11","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":["7761","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-03-18 12:11:10","2","2020-03-18 12:11:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 12:11:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"7761"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-18 12:11:11","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":[18,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207409","2020-03-18 12:11:10",1038,"2","2020-03-18 12:11:10","2","2020-03-18 12:11:10","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 12:11:11","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":["7409","DEPOSIT",null,"PAID","2020-03-18 12:11:10",0,"2","2020-03-18 12:11:10","2","2020-03-18 12:11:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 12:11:11","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":["7409","INVOICE","7761","PAID","2020-03-18 12:11:10",1038,"2","2020-03-18 12:11:10","2","2020-03-18 12:11:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 12:18:10","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&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"238","master_room_id":"6","room_code":"D42"},{"room_id":"239","master_room_id":"6","room_code":"D43"},{"room_id":"249","master_room_id":"6","room_code":"D53"},{"room_id":"250","master_room_id":"6","room_code":"D54"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":18,"customer_code":"C150018","identity_type":"PERSONAL","identity_id":"D191657(3)","title":"Ms","lastname":"Wong","firstname":"Hoi Chi","companyname":"","email":null,"tel":"98855112","address":"\u77f3\u6392\u7063\u78a7\u5c71\u6a133\u6a13303\u5ba4","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1860.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-18","renew_room_key":"055,34812","renew_remark":"1 month contract. Storage rental paid by cheque on February 17, 2020. Storage deposit transferred from agreement A12-CT206998 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\tA02 4X7X8 $2058.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":"28","total_discounted_price":"1860.0","deposit":"0","total_retail_price":"2058.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 12:18:11","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",18,"NEW","A12-CT207434",2058,1860,0,0,"1","1",1860,1860,1860,"2020-03-18 12:18:11","0",null,null,null,"2020-03-18","2020-04-17","1 month contract. Storage rental paid by cheque on March 18, 2020. Storage deposit transferred from agreement A12-CT207203 to this agreement.\r\n","2020-03-18","28",0,null,0,"0","2","2020-03-18 12:18:10","2","2020-03-18 12:18:10","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"055,34812","C150018","PERSONAL","Ms","Wf\/obv2attkTYKMJ\/vWT9A==","hULSwM2MvFtpeV9\/z+er8Q==","","\/W3QUjKWE3CC73zLiOhBi2cNYO8UXtn0ViOT+SD0I4Y=","ErI4QcMFcZ94m4Lf9PgLBg==",null,"1f1y9zugJv2nxoT+IuBxXw==",null,1,"4773"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 12:18:11","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":["7434","2","2058.0","2058.00","2","2020-03-18 12:18:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 12:18:11","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-18","2020-04-17","2"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-18 12:18:11","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":["7434",18,"SETTLED","A12-I207762","2020-03-18 12:18:10","2020-03-18","2","2020-03-18 12:18:10","2","2020-03-18 12:18:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 12:18:11","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":["7762","RENT","\u9810\u7e73\u79df\u91d1",1,1860,"MO","1",1860,"2","2020-03-18 12:18:10","2","2020-03-18 12:18:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 12:18:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1860,0,"7762"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-18 12:18:11","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":[18,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207410","2020-03-18 12:18:10",1860,"2","2020-03-18 12:18:10","2","2020-03-18 12:18:10","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 12:18:11","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":["7410","DEPOSIT",null,"PAID","2020-03-18 12:18:10",0,"2","2020-03-18 12:18:10","2","2020-03-18 12:18:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 12:18:11","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":["7410","INVOICE","7762","PAID","2020-03-18 12:18:10",1860,"2","2020-03-18 12:18:10","2","2020-03-18 12:18:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 14:12:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:05:53","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","054,04838,055,43980","1 month contract. Storage rental paid by cash on Jan 24,2020. Deposit transferred from agreement A14-CT196305 to this agreement.","2020-03-18 16:05:53","2","7KCehmxbvwRMb+U8lHGoVA==","uB9sFpdG5i+5cUgdIIlOnw==","4Qg05wmbWd4NjKCZmlXvDQ==","svs26+0y1LPqWe\/gH171E6P0QrRGU0IyAe\/sso7l1PE=",7039]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:09:00","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","floor_plan_rent_room":[{"room_id":"581","master_room_id":"35","room_code":"L59"},{"room_id":"582","master_room_id":"35","room_code":"L60"},{"room_id":"796","master_room_id":"35","room_code":"L69"},{"room_id":"797","master_room_id":"35","room_code":"L70"}],"renew":1,"warehousing":{"1":{"new_customer":"0","customer_id":"281","customer_code":"C170281","identity_type":"PERSONAL","identity_id":"A928255(9)","title":"Mr","lastname":"Li","firstname":"Man Tim","companyname":"","email":"","tel":"98696693","address":"\u83ef\u8cb4\u90a8\u83ef\u79ae\u6a133316\u5ba4","pass":true,"customer_first_order":false},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3864.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-19","renew_room_key":"054,04838,055,43980","renew_remark":"1 month contract. Storage rental paid by cash on Jan 24,2020. Deposit transferred from agreement A14-CT196305 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207039, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"581","room_code":"L59","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"582","room_code":"L60","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"796","room_code":"L69","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"797","room_code":"L70","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"64","total_retail_price":4392,"total_discounted_price":3478,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":20868,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-19","rent_from":"2020-01-19","rent_to":"2020-07-18","delivery_service":"0","remark":"6 month contract. Storage rental paid by cash on Jan 24 and Mar 18, 2020. Deposit transferred from agreement A14-CT207039 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":20868,"final_order_total":20868,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,04838,055,43980","order_product":[],"pass":true}},"first_order_id":"4065","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\tL59 4X4X8 $1098.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\tL60 4X4X8 $1098.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\tL69 4X4X8 $1098.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\tL70 4X4X8 $1098.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":"64","total_discounted_price":"3478.00","deposit":"0.00","total_retail_price":"4392.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:09:01","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","281","NEW","A14-CT207435",4392,3478,0,0,"6","6",20868,20868,20868,"2020-03-18 16:09:01","0",null,null,null,"2020-01-19","2020-07-18","6 month contract. Storage rental paid by cash on Jan 24 and Mar 18, 2020. Deposit transferred from agreement A14-CT207039 to this agreement.","2020-01-19","64",0,null,0,"0","2","2020-03-18 16:09:00","2","2020-03-18 16:09:00","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"054,04838,055,43980","C170281","PERSONAL","Mr","uB9sFpdG5i+5cUgdIIlOnw==","7KCehmxbvwRMb+U8lHGoVA==","","svs26+0y1LPqWe\/gH171E6P0QrRGU0IyAe\/sso7l1PE=","4Qg05wmbWd4NjKCZmlXvDQ==",null,"s7cYbtvvsWH7SD0LZNTpdw==",null,1,"4065"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:09:01","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":["7435","581","1098.0","1098.00","2","2020-03-18 16:09:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:09:01","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-01-19","2020-07-18","581"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-18 16:09:01","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":["7435","582","1098.0","1098.00","2","2020-03-18 16:09:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:09:01","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-01-19","2020-07-18","582"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-18 16:09:01","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":["7435","796","1098.0","1098.00","2","2020-03-18 16:09:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:09:01","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-01-19","2020-07-18","796"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-18 16:09:01","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":["7435","797","1098.0","1098.00","2","2020-03-18 16:09:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:09:01","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-01-19","2020-07-18","797"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-18 16:09:01","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":["7435","281","SETTLED","A14-I207763","2020-03-18 16:09:00","2020-01-19","2","2020-03-18 16:09:00","2","2020-03-18 16:09:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:09:01","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":["7763","RENT","\u9810\u7e73\u79df\u91d1",1,3478,"MO","1",3478,"2","2020-03-18 16:09:00","2","2020-03-18 16:09:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:09:01","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":["7763","RENT","\u9810\u7e73\u79df\u91d1",2,3478,"MO","1",3478,"2","2020-03-18 16:09:00","2","2020-03-18 16:09:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:09:01","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":["7763","RENT","\u9810\u7e73\u79df\u91d1",3,3478,"MO","1",3478,"2","2020-03-18 16:09:00","2","2020-03-18 16:09:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:09:01","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":["7763","RENT","\u9810\u7e73\u79df\u91d1",4,3478,"MO","1",3478,"2","2020-03-18 16:09:00","2","2020-03-18 16:09:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:09:01","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":["7763","RENT","\u9810\u7e73\u79df\u91d1",5,3478,"MO","1",3478,"2","2020-03-18 16:09:00","2","2020-03-18 16:09:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:09:01","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":["7763","RENT","\u9810\u7e73\u79df\u91d1",6,3478,"MO","1",3478,"2","2020-03-18 16:09:00","2","2020-03-18 16:09:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:09:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[20868,0,"7763"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-18 16:09:01","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":["281","NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207411","2020-03-18 16:09:00",20868,"2","2020-03-18 16:09:00","2","2020-03-18 16:09:00","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:09:01","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":["7411","DEPOSIT",null,"PAID","2020-03-18 16:09:00",0,"2","2020-03-18 16:09:00","2","2020-03-18 16:09:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:09:01","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":["7411","INVOICE","7763","PAID","2020-03-18 16:09:00",20868,"2","2020-03-18 16:09:00","2","2020-03-18 16:09:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:58:29","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","floor_plan_rent_room":[{"room_id":"581","master_room_id":"35","room_code":"L59"},{"room_id":"582","master_room_id":"35","room_code":"L60"},{"room_id":"796","master_room_id":"35","room_code":"L69"},{"room_id":"797","master_room_id":"35","room_code":"L70"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":278,"customer_code":"C170278","identity_type":"PERSONAL","identity_id":"R393433(A)","title":"Mr","lastname":"ROSS","firstname":"William Field","companyname":"","email":"willsayshi2u@gmail.com","tel":"95056748","address":"Apt 46B,Tower 2,8 Robinson Road,HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2068.0","renew_rent_month":"3","renew_warehousing_date":"2020-02-21","renew_room_key":"055,30128","renew_remark":"3 months contract. Storage rental paid by bank transfer on December 13, 2019. Storage deposit transferred from agreement A14-CT195920 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196683, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"52","order_discount":[],"order_room":[{"room_id":"462","room_code":"J44","retail_price":"2188.0","discounted_price":"2188.00","location_id":"2"}],"roughly_size":"35","total_retail_price":2188,"total_discounted_price":2068,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":6204,"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-05-20","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on March 18, 2020. Storage deposit transferred from agreement A14-CT196683 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6204,"final_order_total":6204,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,30128","order_product":[],"pass":true}},"first_order_id":"4602","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\tJ44 5X7X8 $2188.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":"35","total_discounted_price":"2068.0","deposit":"0","total_retail_price":"2188.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:58:30","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",278,"NEW","A14-CT207436",2188,2068,0,0,"3","3",6204,6204,6204,"2020-03-18 16:58:30","0",null,null,null,"2020-02-21","2020-05-20","3 months contract. Storage rental paid by bank transfer on March 18, 2020. Storage deposit transferred from agreement A14-CT196683 to this agreement.\r\n","2020-02-21","35",0,null,0,"0","2","2020-03-18 16:58:29","2","2020-03-18 16:58:29","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,30128","C170278","PERSONAL","Mr","yafPg9M\/QPDQWQLzUsvRSA==","\/lawQck8DPdkWbFvcCySzQ==","","9UcCt81e4rOZl+HJBdCDBqfm2PW2RdVK1QdOmgdX3B1XiTZ6XgW5Da\/OcrKGEsiL","5BeNvZlJ6BUTFP24hGFRsg==","kOfFUwHXpo2C\/37OxTGl0kIjEq4FbRQD+xEuk9oG2OI=","NpNdd8ytqHWC7\/5NUnt5zw==",null,1,"4602"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:58:30","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":["7436","462","2188.0","2188.00","2","2020-03-18 16:58:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:58:30","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-05-20","462"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-18 16:58:30","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":["7436",278,"SETTLED","A14-I207764","2020-03-18 16:58:29","2020-02-21","2","2020-03-18 16:58:29","2","2020-03-18 16:58:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:58:30","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":["7764","RENT","\u9810\u7e73\u79df\u91d1",1,2068,"MO","1",2068,"2","2020-03-18 16:58:29","2","2020-03-18 16:58:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:58:30","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":["7764","RENT","\u9810\u7e73\u79df\u91d1",2,2068,"MO","1",2068,"2","2020-03-18 16:58:29","2","2020-03-18 16:58:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:58:30","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":["7764","RENT","\u9810\u7e73\u79df\u91d1",3,2068,"MO","1",2068,"2","2020-03-18 16:58:29","2","2020-03-18 16:58:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:58:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6204,0,"7764"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-18 16:58:30","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":[278,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207412","2020-03-18 16:58:29",6204,"2","2020-03-18 16:58:29","2","2020-03-18 16:58:29","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:58:30","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":["7412","DEPOSIT",null,"PAID","2020-03-18 16:58:29",0,"2","2020-03-18 16:58:29","2","2020-03-18 16:58:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 16:58:30","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":["7412","INVOICE","7764","PAID","2020-03-18 16:58:29",6204,"2","2020-03-18 16:58:29","2","2020-03-18 16:58:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 17:30:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 17:36:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 17:45: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":[{"room_id":"1314","master_room_id":"164","room_code":"C15-008"}],"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\tC15-008 4X2.5X6.5 $773.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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"Z225837(5)","title":"Ms","lastname":"YU","firstname":"Chui Yee","companyname":"","email":"","tel":"98016082","address":"tbc","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1314","room_code":"C15-008","retail_price":"773.0","discounted_price":"773.00","location_id":"6"}],"roughly_size":"10","total_retail_price":773,"total_discounted_price":696,"deposit":773,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":7393,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1732.00","warehousing_date":"2020-03-28","rent_from":"2020-03-28","rent_to":"2021-03-27","delivery_service":"0","remark":"12 months contract. Special offer 5% discount. Deposit $500 paid by bank transfer on Mar 11,2020. The balance of storage rental and deposit $6893 paid by cheque on Mar 18,2020. Smart card provided on the same day.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":1732,"order_total":9125,"final_order_total":7393,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012492290","order_product":[],"pass":true}},"roughly_size":"10","total_discounted_price":"696.00","deposit":"773.00","total_retail_price":"773.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 17:45: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":["C201540","PERSONAL","Ms","39b2Uz40US4bGfyAgVDXKw==","4sZhlLfrmxrYN8eefiQ6Rg==","","w59qMbmrWXCL20vvy60DlA==",null,"L\/L04tL1KwAXTf\/XIAPmWg==","AL4gJAceEzRX\/pfE9WzyPA==",null,null,"bmNFqT44NVBHSd1X3sQnqw==","2","2020-03-18 17:45:45","2","2020-03-18 17:45:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 17:45:46","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",1540,"NEW","C15-CT207437",773,696,773,0,"12","12",7393,9125,7393,"2020-03-18 17:45:46","0",null,null,null,"2020-03-28","2021-03-27","12 months contract. Special offer 5% discount. Deposit $500 paid by bank transfer on Mar 11,2020. The balance of storage rental and deposit $6893 paid by cheque on Mar 18,2020. Smart card provided on the same day.","2020-03-28","10",0,null,1732,"1732.00","2","2020-03-18 17:45:45","2","2020-03-18 17:45:45","BANKIN","","","","BANKIN","","","",null,0,"0012492290","C201540","PERSONAL","Ms","39b2Uz40US4bGfyAgVDXKw==","4sZhlLfrmxrYN8eefiQ6Rg==","","L\/L04tL1KwAXTf\/XIAPmWg==","w59qMbmrWXCL20vvy60DlA==",null,"AL4gJAceEzRX\/pfE9WzyPA==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 17:45:46","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":["7437","1314","773.0","773.00","2","2020-03-18 17:45:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 17:45:46","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-28","2021-03-27","1314"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-18 17:45:46","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":["7437","C15-D205324","PAID",773,0,"2021-03-27","2020-03-18 17:45:45","2020-03-18 17:45:45","2","2020-03-18 17:45:45","2","2020-03-18 17:45:45",1540]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 17:45:46","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":["7437",1540,"SETTLED","C15-I207765","2020-03-18 17:45:45","2020-03-28","2","2020-03-18 17:45:45","2","2020-03-18 17:45:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 17:45:46","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":["7765","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-03-18 17:45:45","2","2020-03-18 17:45:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 17:45:46","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":["7765","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-03-18 17:45:45","2","2020-03-18 17:45:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 17:45:46","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":["7765","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,356,"MO","1",356,"2","2020-03-18 17:45:45","2","2020-03-18 17:45:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 17:45:46","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":["7765","RENT","\u9810\u7e73\u79df\u91d1",4,696,"MO","1",696,"2","2020-03-18 17:45:45","2","2020-03-18 17:45:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 17:45:46","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":["7765","RENT","\u9810\u7e73\u79df\u91d1",5,696,"MO","1",696,"2","2020-03-18 17:45:45","2","2020-03-18 17:45:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 17:45:46","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":["7765","RENT","\u9810\u7e73\u79df\u91d1",6,696,"MO","1",696,"2","2020-03-18 17:45:45","2","2020-03-18 17:45:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 17:45:46","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":["7765","RENT","\u9810\u7e73\u79df\u91d1",7,696,"MO","1",696,"2","2020-03-18 17:45:45","2","2020-03-18 17:45:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 17:45:46","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":["7765","RENT","\u9810\u7e73\u79df\u91d1",8,696,"MO","1",696,"2","2020-03-18 17:45:45","2","2020-03-18 17:45:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 17:45:46","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":["7765","RENT","\u9810\u7e73\u79df\u91d1",9,696,"MO","1",696,"2","2020-03-18 17:45:45","2","2020-03-18 17:45:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 17:45:46","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":["7765","RENT","\u9810\u7e73\u79df\u91d1",10,696,"MO","1",696,"2","2020-03-18 17:45:45","2","2020-03-18 17:45:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 17:45:46","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":["7765","RENT","\u9810\u7e73\u79df\u91d1",11,696,"MO","1",696,"2","2020-03-18 17:45:45","2","2020-03-18 17:45:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 17:45:46","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":["7765","RENT","\u9810\u7e73\u79df\u91d1",12,696,"MO","1",696,"2","2020-03-18 17:45:45","2","2020-03-18 17:45:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 17:45:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6620,0,"7765"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-18 17:45:46","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":[1540,"BANKIN","","","","BANKIN","","","","PAID","P207413","2020-03-18 17:45:45",7393,"2","2020-03-18 17:45:45","2","2020-03-18 17:45:45","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 17:45:46","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":["7413","DEPOSIT","5324","PAID","2020-03-18 17:45:45",773,"2","2020-03-18 17:45:45","2","2020-03-18 17:45:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 17:45:46","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":["7413","INVOICE","7765","PAID","2020-03-18 17:45:45",6620,"2","2020-03-18 17:45:45","2","2020-03-18 17:45:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 17:58:11","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":["NEW","0012492290","12 months contract. Special offer 5% discount. Deposit $500 paid by bank transfer on Mar 11,2020. The balance of storage rental and deposit $6893 paid by cheque on Mar 18,2020. Smart card provided on the same day.","2020-03-18 17:58:11","2","4sZhlLfrmxrYN8eefiQ6Rg==","39b2Uz40US4bGfyAgVDXKw==","w59qMbmrWXCL20vvy60DlA==","GT8COU9P9fEvtd+hujQvcAHX77CaqrOk0z\/zEmszUv7fcsDzRDaSR8wTEOrUtp+hi3o0lZdAIB4Uce5+SKKgfA==",7437]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:16:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:24:17","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":"type=INVOICE&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"Z297632(4)","title":"Mr","lastname":"CHEUNG","firstname":"Chi Man","companyname":"","email":"","tel":"97597344","address":"Flat D, 13\/F, BLK 5, Yuet Wu Villa, Tuen Mun, N.T.","pass":true,"customer_id":"1221","customer_code":"C191221","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"437 available_room_list_input","master_room_id":"162","discount_type":"%","price":"692.00","disocunted_price":"520.00","discount":"24.86","monthly_deduct":172.0312,"room_id":"1367","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1367","room_code":"C15-061","retail_price":"692.0","discounted_price":520,"location_id":"6"}],"roughly_size":"8","total_retail_price":692,"total_discounted_price":623,"deposit":692,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":7658,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"510.00","warehousing_date":"2020-03-18","rent_from":"2020-03-18","rent_to":"2021-03-17","delivery_service":"0","remark":"12 months contract. Change unit from C15-145 to C15-061. Storage deposit $510 transferred from agreement C15-CT194574 to this agreement. Storage rental and deposit paid by bank transfer on Mar 16,2020.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":510,"order_total":8168,"final_order_total":7658,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012492322","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-061 4X2X6.5 $692.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":"8","total_discounted_price":"623.00","deposit":"692.00","total_retail_price":"692.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:24:18","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","1221","NEW","C15-CT207438",692,623,692,0,"12","12",7658,8168,7658,"2020-03-18 18:24:18","0",null,null,null,"2020-03-18","2021-03-17","12 months contract. Change unit from C15-145 to C15-061. Storage deposit $510 transferred from agreement C15-CT194574 to this agreement. Storage rental and deposit paid by bank transfer on Mar 16,2020.","2020-03-18","8",0,null,510,"510.00","2","2020-03-18 18:24:17","2","2020-03-18 18:24:17","BANKIN","","","","BANKIN","","","",null,0,"'0012492322","C191221","PERSONAL","Mr","+C9tc1TdnI5EfCJwPTju+g==","ts1WQ6NWxfSAyKGz8YWojw==","","jMmL5ziMp020z3nZ5iGhJfRW2a8NZzWuqkUCCiY2s9d+frhlZwiJiZncaulL+AKHVtazE1kCwILKx0RO8F\/ARw==","aTQHNFEGNwy2GksHgXQEZQ==",null,"Ivrb26rGhx3t3rmxblkgtQ==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:24:18","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":["7438","437 available_room_list_input","162","1367","%","24.86",172.0312,"2","2020-03-18 18:24:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:24:18","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":["7438","1367","692.0",520,"2","2020-03-18 18:24:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:24:18","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-18","2021-03-17","1367"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-18 18:24:18","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":["7438","C15-D205325","PAID",692,0,"2021-03-17","2020-03-18 18:24:17","2020-03-18 18:24:17","2","2020-03-18 18:24:17","2","2020-03-18 18:24:17","1221"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:24:18","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":["7438","1221","SETTLED","C15-I207766","2020-03-18 18:24:17","2020-03-18","2","2020-03-18 18:24:17","2","2020-03-18 18:24:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:24:18","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":["7766","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,113,"MO","1",113,"2","2020-03-18 18:24:17","2","2020-03-18 18:24:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:24:18","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":["7766","RENT","\u9810\u7e73\u79df\u91d1",2,623,"MO","1",623,"2","2020-03-18 18:24:17","2","2020-03-18 18:24:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:24:18","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":["7766","RENT","\u9810\u7e73\u79df\u91d1",3,623,"MO","1",623,"2","2020-03-18 18:24:17","2","2020-03-18 18:24:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:24:18","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":["7766","RENT","\u9810\u7e73\u79df\u91d1",4,623,"MO","1",623,"2","2020-03-18 18:24:17","2","2020-03-18 18:24:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:24:18","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":["7766","RENT","\u9810\u7e73\u79df\u91d1",5,623,"MO","1",623,"2","2020-03-18 18:24:17","2","2020-03-18 18:24:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:24:18","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":["7766","RENT","\u9810\u7e73\u79df\u91d1",6,623,"MO","1",623,"2","2020-03-18 18:24:17","2","2020-03-18 18:24:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:24:18","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":["7766","RENT","\u9810\u7e73\u79df\u91d1",7,623,"MO","1",623,"2","2020-03-18 18:24:17","2","2020-03-18 18:24:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:24:18","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":["7766","RENT","\u9810\u7e73\u79df\u91d1",8,623,"MO","1",623,"2","2020-03-18 18:24:17","2","2020-03-18 18:24:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:24:18","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":["7766","RENT","\u9810\u7e73\u79df\u91d1",9,623,"MO","1",623,"2","2020-03-18 18:24:17","2","2020-03-18 18:24:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:24:18","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":["7766","RENT","\u9810\u7e73\u79df\u91d1",10,623,"MO","1",623,"2","2020-03-18 18:24:17","2","2020-03-18 18:24:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:24:18","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":["7766","RENT","\u9810\u7e73\u79df\u91d1",11,623,"MO","1",623,"2","2020-03-18 18:24:17","2","2020-03-18 18:24:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:24:18","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":["7766","RENT","\u9810\u7e73\u79df\u91d1",12,623,"MO","1",623,"2","2020-03-18 18:24:17","2","2020-03-18 18:24:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:24:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6966,0,"7766"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-18 18:24:18","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":["1221","BANKIN","","","","BANKIN","","","","PAID","P207414","2020-03-18 18:24:17",7658,"2","2020-03-18 18:24:17","2","2020-03-18 18:24:17","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:24:18","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":["7414","DEPOSIT","5325","PAID","2020-03-18 18:24:17",692,"2","2020-03-18 18:24:17","2","2020-03-18 18:24:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:24:18","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":["7414","INVOICE","7766","PAID","2020-03-18 18:24:17",6966,"2","2020-03-18 18:24:17","2","2020-03-18 18:24:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:27:56","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":"type=INVOICE&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1028,"customer_code":"C181028","identity_type":"PERSONAL","identity_id":"Z637488(4)","title":"Mr","lastname":"Lau","firstname":"Tsz Pui","companyname":"","email":"tszpui_lau@yahoo.com.hk","tel":"62230534","address":"Flat F, 14\/F , Fu On Court , 394 Chai Wan RD, Chai Wan","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1709.0","renew_rent_month":"4","renew_warehousing_date":"2020-03-09","renew_room_key":"'0012469943","renew_remark":"4 months contract. Storage rental paid by bank transfer on 10 Jan 2020. Storage deposit $3596 transferred from agreement C15-CT183501 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\tC15-028 4X8X6.5 $1798.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":"32","total_discounted_price":"1619.00","deposit":"0.00","total_retail_price":"1798.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:27:56","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","3","6",1028,"NEW","C15-CT207439",1798,1619,0,0,"6","6",9714,9714,9714,"2020-03-18 18:27:56","0",null,null,null,"2020-03-09","2020-09-08","6 months contract. Storage rental paid by bank transfer on Mar 18,2020. Storage deposit $3596 transferred from agreement C15-CT206917 to this agreement. ","2020-03-09","32",0,null,0,"0","2","2020-03-18 18:27:56","2","2020-03-18 18:27:56","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0012469943","C181028","PERSONAL","Mr","Z47KBKMfrUFOYZIXrfc3vg==","oe4emdjBwqJ3qUpOcI17hw==","","huCsJ1Z\/6+uPRSM+jlsqCgEc5MpkJAFG+IbgMU1UloDr+bQ+Ah18x4dH8gSnuW7mSw4B8lYAycTU8F9ruymN7A==","UpTDawqOu8bBv1mRJuVTSA==","wP4h5Qj6EXMVQ2TH0nZJOP5TERDr5tP09PrMyRHFvWI=","mV2es2FO+t8Ad2akC7hJFg==",null,1,"3501"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:27:56","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":["7439","426","175","1334","%","24.92",448.0616,"2","2020-03-18 18:27:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:27:56","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":["7439","1334","1798.0",1349.9,"2","2020-03-18 18:27:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:27:56","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-09","2020-09-08","1334"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-18 18:27:56","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":["7439",1028,"SETTLED","C15-I207767","2020-03-18 18:27:56","2020-03-09","2","2020-03-18 18:27:56","2","2020-03-18 18:27:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:27:56","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":["7767","RENT","\u9810\u7e73\u79df\u91d1",1,1619,"MO","1",1619,"2","2020-03-18 18:27:56","2","2020-03-18 18:27:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:27:56","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":["7767","RENT","\u9810\u7e73\u79df\u91d1",2,1619,"MO","1",1619,"2","2020-03-18 18:27:56","2","2020-03-18 18:27:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:27:56","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":["7767","RENT","\u9810\u7e73\u79df\u91d1",3,1619,"MO","1",1619,"2","2020-03-18 18:27:56","2","2020-03-18 18:27:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:27:56","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":["7767","RENT","\u9810\u7e73\u79df\u91d1",4,1619,"MO","1",1619,"2","2020-03-18 18:27:56","2","2020-03-18 18:27:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:27:56","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":["7767","RENT","\u9810\u7e73\u79df\u91d1",5,1619,"MO","1",1619,"2","2020-03-18 18:27:56","2","2020-03-18 18:27:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:27:56","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":["7767","RENT","\u9810\u7e73\u79df\u91d1",6,1619,"MO","1",1619,"2","2020-03-18 18:27:56","2","2020-03-18 18:27:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:27:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[9714,0,"7767"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-18 18:27:56","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":[1028,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207415","2020-03-18 18:27:56",9714,"2","2020-03-18 18:27:56","2","2020-03-18 18:27:56","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:27:56","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":["7415","DEPOSIT",null,"PAID","2020-03-18 18:27:56",0,"2","2020-03-18 18:27:56","2","2020-03-18 18:27:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:27:56","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":["7415","INVOICE","7767","PAID","2020-03-18 18:27:56",9714,"2","2020-03-18 18:27:56","2","2020-03-18 18:27:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:32:32","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":"type=INVOICE&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1101,"customer_code":"C181101","identity_type":"BUSINESS","identity_id":"63953971-000-10-17-6","title":"Ms","lastname":"Yau ","firstname":"Yuk Yan","companyname":"Alive Yoga Alliance Ltd","email":"amyyoga@ymail.com","tel":"92530001","address":"Flat C & D, 1\/F Fook Ying Building, 379-381 King\u2019s Rd, North Point, H.K","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1798.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-19","renew_room_key":"\u20180012415083","renew_remark":"1 month contract. Storage rental paid by bank transfer on Jan 30,2020. Deposit $4532 transferred from agreement from C15-CT196327 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT207064, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"171","order_discount":[{"master_room_discount_id":"415","master_room_id":"170","discount_type":"%","price":"1108.00","disocunted_price":"1052.90","discount":"4.97","monthly_deduct":55.0676,"room_id":"1460","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1460","room_code":"C15-154","retail_price":"1108.0","discounted_price":1052.9,"location_id":"6"},{"room_id":"1461","room_code":"C15-155","retail_price":"1108.0","location_id":"6"}],"roughly_size":"32","total_retail_price":2216,"total_discounted_price":1709,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":5127,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-19","rent_from":"2020-03-19","rent_to":"2020-06-18","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on Mar 16,2020. Deposit $4532 transferred from agreement from C15-CT207064 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5127,"final_order_total":5127,"location_id":"6","branch_id":"3","company_id":"1","room_key":"\u20180012415083","order_product":[],"pass":true}},"first_order_id":"3638","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\tC15-154 4X4X6.5 $1108.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\tC15-155 4X4X6.5 $1108.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":"32","total_discounted_price":"1709.00","deposit":"0.00","total_retail_price":"2216.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:32: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1101,"NEW","C15-CT207440",2216,1709,0,0,"3","3",5127,5127,5127,"2020-03-18 18:32:33","0",null,null,null,"2020-03-19","2020-06-18","3 months contract. Storage rental paid by bank transfer on Mar 16,2020. Deposit $4532 transferred from agreement from C15-CT207064 to this agreement.","2020-03-19","32",0,null,0,"0","2","2020-03-18 18:32:32","2","2020-03-18 18:32:32","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"\u20180012415083","C181101","BUSINESS","Ms","RlKt34vcZvRZ1B47nY\/fgQ==","eg6mnYsOn64SOpH7hwzmzw==","Alive Yoga Alliance Ltd","J4gN8qCnHYBqifDoM\/w3B4pMnK9R3SOmOekdx0aWx8wFimkFSq\/ovz+SLDRz0JHP0zuDSTMzbkaxg9fQx26Whny0nYhF6eJVpEH5UtgLSVs=","tjARpijmRPN33ts7XMesgw==","26iudEKydkbSBd6ePqD2yTnY4IH4Yvw\/VHV7dVhQ8Rw=",null,"4sVsRnjmji+akrTf224OtJHLnqERjelObNdOANDjidM=",1,"3638"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:32:33","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":["7440","415","170","1460","%","4.97",55.0676,"2","2020-03-18 18:32:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:32: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":["7440","1460","1108.0",1052.9,"2","2020-03-18 18:32:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:32: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-19","2020-06-18","1460"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-18 18:32: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":["7440","1461","1108.0",null,"2","2020-03-18 18:32:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:32: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-19","2020-06-18","1461"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-18 18:32: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":["7440",1101,"SETTLED","C15-I207768","2020-03-18 18:32:32","2020-03-19","2","2020-03-18 18:32:32","2","2020-03-18 18:32:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:32: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":["7768","RENT","\u9810\u7e73\u79df\u91d1",1,1709,"MO","1",1709,"2","2020-03-18 18:32:32","2","2020-03-18 18:32:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:32: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":["7768","RENT","\u9810\u7e73\u79df\u91d1",2,1709,"MO","1",1709,"2","2020-03-18 18:32:32","2","2020-03-18 18:32:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:32: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":["7768","RENT","\u9810\u7e73\u79df\u91d1",3,1709,"MO","1",1709,"2","2020-03-18 18:32:32","2","2020-03-18 18:32:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:32:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5127,0,"7768"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-18 18:32: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":[1101,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207416","2020-03-18 18:32:32",5127,"2","2020-03-18 18:32:32","2","2020-03-18 18:32:32","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:32: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":["7416","DEPOSIT",null,"PAID","2020-03-18 18:32:32",0,"2","2020-03-18 18:32:32","2","2020-03-18 18:32:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:32: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":["7416","INVOICE","7768","PAID","2020-03-18 18:32:32",5127,"2","2020-03-18 18:32:32","2","2020-03-18 18:32:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-18 18:47:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****