\r\n\t\t\t\t\tA05-040 6X3X7 $1384.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":"18","total_discounted_price":"1384.0","deposit":"0","total_retail_price":"1384.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 14:55:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1000,"NEW","A05-CT196797",1384,1384,0,0,"1","1",1384,1384,1384,"2019-12-28 14:55:38","0",null,null,null,"2019-12-22","2020-01-21","1 month contract. Storage rental paid by bank transfer on Dec 23, 2019. Storage deposit transferred from agreement A05-CT196466 to this agreement.","2019-12-22","18",0,null,0,"0","2","2019-12-28 14:55:37","2","2019-12-28 14:55:37","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012385366","C181000","BUSINESS","Mr","uH6SR3Usr5pjl15fgk2xBQ==","3hC5jWxTyseC0UGI0aOkAg==","Lancashire Decorating Limited","2Z3GrSs8TtWmHfqJQHcTHSj5PkrfAJG3icQpP+dHb4pR6r6gZDlFua9f0SQRB4T7nesXzD6ZQbIz9hPFFQWgZxCafnJaWissyZGlcu8xHaw=","6vfNYC\/zokp3t8YiOOVHSg==","hDQSd3rKdaAlD3TTnjhsvRH6brF\/H73VmPFKao018qs=",null,"c4A7Vexe0m66GXy70hIIWA==",1,"4793"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 14:55:38","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":["6797","1042","1384.0","1384.00","2","2019-12-28 14:55:37"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 14:55:38","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":["2019-12-22","2020-01-21","1042"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2019-12-28 14:55:38","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":["6797",1000,"SETTLED","A05-I197125","2019-12-28 14:55:37","2019-12-22","2","2019-12-28 14:55:37","2","2019-12-28 14:55:37"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 14:55:38","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":["7125","RENT","\u9810\u7e73\u79df\u91d1",1,1384,"MO","1",1384,"2","2019-12-28 14:55:37","2","2019-12-28 14:55:37"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 14:55:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1384,0,"7125"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2019-12-28 14:55:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1000,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196775","2019-12-28 14:55:37",1384,"2","2019-12-28 14:55:37","2","2019-12-28 14:55:37","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 14:55:38","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":["6775","DEPOSIT",null,"PAID","2019-12-28 14:55:37",0,"2","2019-12-28 14:55:37","2","2019-12-28 14:55:37"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 14:55:38","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":["6775","INVOICE","7125","PAID","2019-12-28 14:55:37",1384,"2","2019-12-28 14:55:37","2","2019-12-28 14:55:37"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 14:59:09","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=INVOICE&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":662,"customer_code":"C170662","identity_type":"PERSONAL","identity_id":"K086615(6)","title":"Ms","lastname":"Yung","firstname":"Chi Han","companyname":"","email":"SandyPui9@yahoo.com.hk","tel":"97393288","address":"Rm 526, Yi Tak House, Lung Tak Court, Stanley ","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2053.0","renew_rent_month":"3","renew_warehousing_date":"2020-12-30","renew_room_key":"054,45426","renew_remark":"3 month contract. Storage rental paid by bank transfer on October 9, 2019. Storage deposit $4116 transferred from agreement A18-CT195814 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196134, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"83","order_discount":[],"order_room":[{"room_id":"997","room_code":"X22","retail_price":"2161.0","discounted_price":"2161.00","location_id":"3"}],"roughly_size":"28","total_retail_price":2161,"total_discounted_price":1945,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":11670,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-12-30","rent_from":"2020-12-30","rent_to":"2021-06-29","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on Dec 28, 2019. Storage deposit $4116 transferred from agreement A18-CT196134 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":11670,"final_order_total":11670,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,45426","order_product":[],"pass":true}},"first_order_id":"3998","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\tX22 7X4X7 $2161.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":"28","total_discounted_price":"1945.00","deposit":"0.00","total_retail_price":"2161.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 14:59:10","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","3",662,"NEW","A18-CT196798",2161,1945,0,0,"6","6",11670,11670,11670,"2019-12-28 14:59:10","0",null,null,null,"2020-12-30","2021-06-29","6 months contract. Storage rental paid by bank transfer on Dec 28, 2019. Storage deposit $4116 transferred from agreement A18-CT196134 to this agreement.","2020-12-30","28",0,null,0,"0","2","2019-12-28 14:59:09","2","2019-12-28 14:59:09","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,45426","C170662","PERSONAL","Ms","mzl9wJ\/hSEhLPzoiI6h6Zg==","Gx5wC5plnNkrLawNtCgpAA==","","QSN9WoJ9HAqQmHqFLp+5omeZP9\/Zep834Gc0bVH0YIcNuUxGnWi98jx1KNX3AiIE","wYbP0yGhFCXVgrI69fweHw==","xlNbTqyqiOnpFGCRI0oDYYLdYgJaoXlL\/aEXLgLIm2E=","\/r1IszNScVIFPiHhdPS6PA==",null,1,"3998"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 14:59:10","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":["6798","997","2161.0","2161.00","2","2019-12-28 14:59:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 14:59:10","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-12-30","2021-06-29","997"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2019-12-28 14:59:10","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":["6798",662,"SETTLED","A18-I197126","2019-12-28 14:59:09","2020-12-30","2","2019-12-28 14:59:09","2","2019-12-28 14:59:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 14:59:10","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":["7126","RENT","\u9810\u7e73\u79df\u91d1",1,1945,"MO","1",1945,"2","2019-12-28 14:59:09","2","2019-12-28 14:59:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 14:59:10","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":["7126","RENT","\u9810\u7e73\u79df\u91d1",2,1945,"MO","1",1945,"2","2019-12-28 14:59:09","2","2019-12-28 14:59:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 14:59:10","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":["7126","RENT","\u9810\u7e73\u79df\u91d1",3,1945,"MO","1",1945,"2","2019-12-28 14:59:09","2","2019-12-28 14:59:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 14:59:10","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":["7126","RENT","\u9810\u7e73\u79df\u91d1",4,1945,"MO","1",1945,"2","2019-12-28 14:59:09","2","2019-12-28 14:59:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 14:59:10","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":["7126","RENT","\u9810\u7e73\u79df\u91d1",5,1945,"MO","1",1945,"2","2019-12-28 14:59:09","2","2019-12-28 14:59:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 14:59:10","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":["7126","RENT","\u9810\u7e73\u79df\u91d1",6,1945,"MO","1",1945,"2","2019-12-28 14:59:09","2","2019-12-28 14:59:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 14:59:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11670,0,"7126"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2019-12-28 14:59:10","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":[662,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196776","2019-12-28 14:59:09",11670,"2","2019-12-28 14:59:09","2","2019-12-28 14:59:09","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 14:59:10","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":["6776","DEPOSIT",null,"PAID","2019-12-28 14:59:09",0,"2","2019-12-28 14:59:09","2","2019-12-28 14:59:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 14:59:10","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":["6776","INVOICE","7126","PAID","2019-12-28 14:59:09",11670,"2","2019-12-28 14:59:09","2","2019-12-28 14:59:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 15:01: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":"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":662,"customer_code":"C170662","identity_type":"PERSONAL","identity_id":"K086615(6)","title":"Ms","lastname":"Yung","firstname":"Chi Han","companyname":"","email":"SandyPui9@yahoo.com.hk","tel":"97393288","address":"Rm 526, Yi Tak House, Lung Tak Court, Stanley ","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1764.0","renew_rent_month":"3","renew_warehousing_date":"2020-12-30","renew_room_key":"054,45426","renew_remark":"3 months contract. Storage rental paid by bank transfer on October 9, 2019. Storage deposit transferred from agreement A18-CT195813 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196137, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"79","order_discount":[],"order_room":[{"room_id":"971","room_code":"W16","retail_price":"1857.0","discounted_price":"1857.00","location_id":"3"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1672,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":10032,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-30","rent_from":"2019-12-30","rent_to":"2020-06-29","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on Dec 28, 2019. Storage deposit transferred from agreement A18-CT196137 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":10032,"final_order_total":10032,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,45426","order_product":[],"pass":true}},"first_order_id":"3796","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\tW16 4X6X7 $1857.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1672.00","deposit":"0.00","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 15:01:29","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","3",662,"NEW","A18-CT196799",1857,1672,0,0,"6","6",10032,10032,10032,"2019-12-28 15:01:29","0",null,null,null,"2019-12-30","2020-06-29","6 months contract. Storage rental paid by bank transfer on Dec 28, 2019. Storage deposit transferred from agreement A18-CT196137 to this agreement.","2019-12-30","24",0,null,0,"0","2","2019-12-28 15:01:29","2","2019-12-28 15:01:29","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,45426","C170662","PERSONAL","Ms","mzl9wJ\/hSEhLPzoiI6h6Zg==","Gx5wC5plnNkrLawNtCgpAA==","","QSN9WoJ9HAqQmHqFLp+5omeZP9\/Zep834Gc0bVH0YIcNuUxGnWi98jx1KNX3AiIE","wYbP0yGhFCXVgrI69fweHw==","xlNbTqyqiOnpFGCRI0oDYYLdYgJaoXlL\/aEXLgLIm2E=","\/r1IszNScVIFPiHhdPS6PA==",null,1,"3796"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 15:01:29","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":["6799","971","1857.0","1857.00","2","2019-12-28 15:01:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 15:01:29","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":["2019-12-30","2020-06-29","971"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2019-12-28 15:01:29","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":["6799",662,"SETTLED","A18-I197127","2019-12-28 15:01:29","2019-12-30","2","2019-12-28 15:01:29","2","2019-12-28 15:01:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 15:01:29","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":["7127","RENT","\u9810\u7e73\u79df\u91d1",1,1672,"MO","1",1672,"2","2019-12-28 15:01:29","2","2019-12-28 15:01:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 15:01:29","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":["7127","RENT","\u9810\u7e73\u79df\u91d1",2,1672,"MO","1",1672,"2","2019-12-28 15:01:29","2","2019-12-28 15:01:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 15:01:29","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":["7127","RENT","\u9810\u7e73\u79df\u91d1",3,1672,"MO","1",1672,"2","2019-12-28 15:01:29","2","2019-12-28 15:01:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 15:01:29","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":["7127","RENT","\u9810\u7e73\u79df\u91d1",4,1672,"MO","1",1672,"2","2019-12-28 15:01:29","2","2019-12-28 15:01:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 15:01:29","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":["7127","RENT","\u9810\u7e73\u79df\u91d1",5,1672,"MO","1",1672,"2","2019-12-28 15:01:29","2","2019-12-28 15:01:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 15:01:29","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":["7127","RENT","\u9810\u7e73\u79df\u91d1",6,1672,"MO","1",1672,"2","2019-12-28 15:01:29","2","2019-12-28 15:01:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 15:01:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10032,0,"7127"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2019-12-28 15:01:29","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":[662,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196777","2019-12-28 15:01:29",10032,"2","2019-12-28 15:01:29","2","2019-12-28 15:01:29","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 15:01:29","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":["6777","DEPOSIT",null,"PAID","2019-12-28 15:01:29",0,"2","2019-12-28 15:01:29","2","2019-12-28 15:01:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 15:01:29","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":["6777","INVOICE","7127","PAID","2019-12-28 15:01:29",10032,"2","2019-12-28 15:01:29","2","2019-12-28 15:01:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 15:08:47","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 15:43:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 16:31:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 16:52:51","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-28 16:55:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****