{"created_at":"2020-06-10 10:07:15","login_id":"2","controller":"room_modify.php","function":"update query","input":{"sql":"update room set code = ?, status = ?, master_room_id = ?, typeid = ?, lastupby = ?, lastupdate = ? where id = ?","parameters":["B01-014","RENTED","141","STORAGE","2","2020-06-10 10:07:15","1204"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 10:07:15","login_id":"2","controller":"room_modify.php","function":"update query","input":{"sql":"update room set code = ?, status = ?, master_room_id = ?, typeid = ?, lastupby = ?, lastupdate = ? where id = ?","parameters":["B01-021","RENTED","140","STORAGE","2","2020-06-10 10:07:15","1211"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 10:35:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 10:43:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 10:44:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 10:45: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&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1548","master_room_id":"194","room_code":"A16-057"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":783,"customer_code":"C180783","identity_type":"PERSONAL","identity_id":"D459443(7)","title":"Ms","lastname":"Leung","firstname":"So King","companyname":"","email":null,"tel":"93399270","address":"Room 909, Pik Shan House, Shek Pai Wan Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"6","renew_warehousing_date":"2020-06-21","renew_room_key":"055,03045,055,15637","renew_remark":"6 months contract. Storage rental paid by Cash on December 19, 2019. Storage deposit transferred from agreement A14-CT195173 to this agreement\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196739, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"689","room_code":"N06","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-21","rent_from":"2020-06-21","rent_to":"2020-12-20","delivery_service":"0","remark":"6 months contract. Storage rental paid by Cash on June 10. Storage deposit transferred from agreement A14-CT196739 to this agreement\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,03045,055,15637","order_product":[],"pass":true}},"first_order_id":"3932","selected_room_tr":"\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t

---

\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t

\u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t

\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>
N06 <\/td>\r\n\t\t\t\t\t	4X3X4 <\/td>\r\n\t\t\t\t\t	$598.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"538.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 10:45: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","2",783,"NEW","A14-CT208085",598,538,0,0,"6","6",3228,3228,3228,"2020-06-10 10:45:40","0",null,null,null,"2020-06-21","2020-12-20","6 months contract. Storage rental paid by Cash on June 10. Storage deposit transferred from agreement A14-CT196739 to this agreement\r\n","2020-06-21","12",0,null,0,"0","2","2020-06-10 10:45:40","2","2020-06-10 10:45:40","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"055,03045,055,15637","C180783","PERSONAL","Ms","1wvt7j9sKAXiKrAYEESBEA==","xEf2h2aoyRQ71ZVgBH+9WQ==","","5jrEey1TOOmPRMsdqiHNYDwg8vYXpIrxGXu+rSzTfXmiTH3INRdWQrPdUIQSzqG8Nw\/HOJFcV+btpwSi5Vg6+elG4MKGYkptWB8s1frXrZ0=","1WHiqOSyl49pEAJJlNcK0Q==",null,"\/fE4fuk5bWTWsVOJX65UQg==",null,1,"3932"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 10:45: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":["8085","689","598.0","598.00","2","2020-06-10 10:45:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 10:45: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-06-21","2020-12-20","689"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 10:45: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":["8085",783,"SETTLED","A14-I208414","2020-06-10 10:45:40","2020-06-21","2","2020-06-10 10:45:40","2","2020-06-10 10:45:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 10:45: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":["8414","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-06-10 10:45:40","2","2020-06-10 10:45:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 10:45: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":["8414","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-06-10 10:45:40","2","2020-06-10 10:45:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 10:45: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":["8414","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-06-10 10:45:40","2","2020-06-10 10:45:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 10:45: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":["8414","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-06-10 10:45:40","2","2020-06-10 10:45:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 10:45: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":["8414","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-06-10 10:45:40","2","2020-06-10 10:45:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 10:45: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":["8414","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-06-10 10:45:40","2","2020-06-10 10:45:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 10:45:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"8414"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-10 10:45: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":[783,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P208057","2020-06-10 10:45:40",3228,"2","2020-06-10 10:45:40","2","2020-06-10 10:45:40","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 10:45: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":["8057","DEPOSIT",null,"PAID","2020-06-10 10:45:40",0,"2","2020-06-10 10:45:40","2","2020-06-10 10:45:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 10:45: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":["8057","INVOICE","8414","PAID","2020-06-10 10:45:40",3228,"2","2020-06-10 10:45:40","2","2020-06-10 10:45:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 11:03:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 11:05:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 12:05:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 12:08:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 12:40:44","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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":212,"customer_code":"C160212","identity_type":"PERSONAL","identity_id":"D285534(9)","title":"Mr","lastname":"Mak","firstname":"Che Yan","companyname":"","email":"davidcy.mak@gmail.com","tel":"90435747","address":"13A, Block 23, Baguio Villa, 555 Victoria Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"949.0","renew_rent_month":"3","renew_warehousing_date":"2020-06-10","renew_room_key":"054,43821","renew_remark":"3 months contract. Storage rental paid by bank transfer on March 9, 2020. Storage deposit transferred from agreement A12-CT196645 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207354, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"220","room_code":"D24","retail_price":"998.0","discounted_price":"949.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":949,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":0,"prepaid_amount":0,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-10","rent_from":"2020-06-10","rent_to":"2020-09-09","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on JUNE 10, 2020. Storage deposit transferred from agreement A12-CT207354 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2847,"final_order_total":2847,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,43821","order_product":[],"pass":true}},"first_order_id":"4549","selected_room_tr":"	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> D24 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"949.0","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 12:40:45","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",212,"NEW","A12-CT208086",998,949,0,0,"3",0,0,2847,2847,"2020-06-10 12:40:45","0",null,null,null,"2020-06-10","2020-09-09","3 months contract. Storage rental paid by bank transfer on JUNE 10, 2020. Storage deposit transferred from agreement A12-CT207354 to this agreement. ","2020-06-10","12",0,null,0,"0","2","2020-06-10 12:40:44","2","2020-06-10 12:40:44","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,43821","C160212","PERSONAL","Mr","QMdo4NmpjqV\/3s1QKx1gOQ==","DGNg\/pKHJ\/mTaSVRFTWCKw==","","81v4Ds3okvpkyWWGB85n4xU+OGL3XTVm52q2rAuaYfRkwNVWuNcSFXbV5+CxdL+5DkE0fx06BlYm2oRHyzW2QQ==","HYnJYtaUMZQPiLVK4mRPsw==","3d9EX5\/c7dA6NvE2V921JGQiwkORAbLjhJZwk0bpolI=","kimoPHeAaNKLapbOk2eYCQ==",null,1,"4549"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 12:40:45","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":["8086","220","998.0","949.00","2","2020-06-10 12:40:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 12:40:45","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-06-10","2020-09-09","220"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 12:40:45","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":["8086",212,"SETTLED","A12-I208415","2020-06-10 12:40:44","2020-06-10","2","2020-06-10 12:40:44","2","2020-06-10 12:40:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 12:40:45","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":["8415","RENT","",1,949,"MO","1",949,"2","2020-06-10 12:40:44","2","2020-06-10 12:40:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 12:40:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[949,0,"8415"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-10 12:40:45","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":[212,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208058","2020-06-10 12:40:44",949,"2","2020-06-10 12:40:44","2","2020-06-10 12:40:44","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 12:40:45","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":["8058","DEPOSIT",null,"PAID","2020-06-10 12:40:44",0,"2","2020-06-10 12:40:44","2","2020-06-10 12:40:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 12:40:45","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":["8058","INVOICE","8415","PAID","2020-06-10 12:40:44",949,"2","2020-06-10 12:40:44","2","2020-06-10 12:40:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 12:53:08","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","054,43821","3 months contract. Storage rental paid by bank transfer on JUNE 10, 2020. Storage deposit transferred from agreement A12-CT207354 to this agreement. ","2020-06-10 12:53:08","2","DGNg\/pKHJ\/mTaSVRFTWCKw==","QMdo4NmpjqV\/3s1QKx1gOQ==","3d9EX5\/c7dA6NvE2V921JGQiwkORAbLjhJZwk0bpolI=","HYnJYtaUMZQPiLVK4mRPsw==","81v4Ds3okvpkyWWGB85n4xU+OGL3XTVm52q2rAuaYfRkwNVWuNcSFXbV5+CxdL+5DkE0fx06BlYm2oRHyzW2QQ==",8086]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 13:36:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 13:58:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 14:52:11","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=3&filter2=1300","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":338,"customer_code":"C170338","identity_type":"PERSONAL","identity_id":"Z921933(2)","title":"Mr","lastname":"Ng","firstname":"Ka Fai","companyname":"","email":"ny1442@yahoo.com.hk","tel":"98135663","address":"\u9d28\u8137\u6d32\u5229\u6771\u90a8\u6771\u8302\u6a131708\u5ba4","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1139.0","renew_rent_month":"12","renew_warehousing_date":"2020-06-17","renew_room_key":"133,54027","renew_remark":"12 months contract. $100 Wellcome coupon provided on Jun 10, 2019. Storage rental paid by EPS on Jun 10, 2019. Storage deposit transferred from agreement A14-CT183857 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195188, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"38","order_discount":[],"order_room":[{"room_id":"478","room_code":"K15","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1139,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":0,"prepaid_amount":0,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-17","rent_from":"2020-06-17","rent_to":"2021-06-16","delivery_service":"0","remark":"12 months contract. $300 maxim's coupon provided on JUNE10, 2020. Storage rental paid by EPS on Jun 10, 2020. Storage deposit transferred from agreement A14-CT195188 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":13668,"final_order_total":13668,"location_id":"2","branch_id":"1","company_id":"1","room_key":"133,54027","order_product":[],"pass":true}},"first_order_id":"3857","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> K15 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1139.00","deposit":"00.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 14:52: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","2",338,"NEW","A14-CT208087",1528,1139,0,0,"12",0,0,13668,13668,"2020-06-10 14:52:11","0",null,null,null,"2020-06-17","2021-06-16","12 months contract. $300 maxim's coupon provided on JUNE10, 2020. Storage rental paid by EPS on Jun 10, 2020. Storage deposit transferred from agreement A14-CT195188 to this agreement.","2020-06-17","20",0,null,0,"0","2","2020-06-10 14:52:11","2","2020-06-10 14:52:11","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"133,54027","C170338","PERSONAL","Mr","zVlEiKadi4uPrN2vxEA9pw==","cxr02xsD1tXvJ4ihJHZKWw==","","JP4Rs\/ygk7B5+4qY1O\/77uXdtRZBvtiXXcMrvCr\/8UowqIKlz04xK0u7N5OedW9X","VmvgVApMoVaTCzdFCxO\/8g==","VMaobsdE2w01cvyQf2ZUds3ODtLTmq04yGKsUADs\/Ao=","BLDFhxl52i6NQs2eORxp8w==",null,1,"3857"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 14:52: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":["8087","478","1528.0","1528.00","2","2020-06-10 14:52:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 14:52: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-06-17","2021-06-16","478"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 14:52: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":["8087",338,"SETTLED","A14-I208416","2020-06-10 14:52:11","2020-06-17","2","2020-06-10 14:52:11","2","2020-06-10 14:52:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 14:52: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":["8416","RENT","",1,1139,"MO","1",1139,"2","2020-06-10 14:52:11","2","2020-06-10 14:52:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 14:52:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1139,0,"8416"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-10 14:52: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":[338,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P208059","2020-06-10 14:52:11",1139,"2","2020-06-10 14:52:11","2","2020-06-10 14:52:11","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 14:52: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":["8059","DEPOSIT",null,"PAID","2020-06-10 14:52:11",0,"2","2020-06-10 14:52:11","2","2020-06-10 14:52:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 14:52: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":["8059","INVOICE","8416","PAID","2020-06-10 14:52:11",1139,"2","2020-06-10 14:52:11","2","2020-06-10 14:52:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 15:14:30","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","133,54027","12 months contract. $300 maxim's coupon provided on JUNE10, 2020. Storage rental paid by EPS on Jun 10, 2020. Storage deposit transferred from agreement A14-CT195188 to this agreement.","2020-06-10 15:14:30","2","cxr02xsD1tXvJ4ihJHZKWw==","zVlEiKadi4uPrN2vxEA9pw==","VMaobsdE2w01cvyQf2ZUds3ODtLTmq04yGKsUADs\/Ao=","VmvgVApMoVaTCzdFCxO\/8g==","JP4Rs\/ygk7B5+4qY1O\/77uXdtRZBvtiXXcMrvCr\/8UowqIKlz04xK0u7N5OedW9X",8087]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 15:29:26","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":153,"customer_code":"C160153","identity_type":"PERSONAL","identity_id":"Z614380(7)","title":"Ms","lastname":"Au-Yeung","firstname":"Pik Kwan","companyname":"","email":"carol_85_2000@yahoo.com.hk","tel":"97502271","address":"\u9999\u6e2f\u77f3\u6392\u7063\u6751\u78a7\u8f1d\u6a137\u6a13706\u5ba4","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-20","renew_room_key":"053,63642","renew_remark":"1 month contract. Storage rental paid by PPS on May 6, 2020. Storage deposit transferred from agreement A12-CT207587 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207796, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"227","room_code":"D31","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":998,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-20","rent_from":"2020-05-20","rent_to":"2020-06-19","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on June 5, 2020. Storage deposit transferred from agreement A12-CT207796 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":998,"final_order_total":998,"location_id":"1","branch_id":"1","company_id":"1","room_key":"053,63642","order_product":[],"pass":true}},"first_order_id":"4883","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> D31 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"998.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 15:29:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",153,"NEW","A12-CT208088",998,998,0,0,"1","1",998,998,998,"2020-06-10 15:29:27","0",null,null,null,"2020-05-20","2020-06-19","1 month contract. Storage rental paid by PPS on June 5, 2020. Storage deposit transferred from agreement A12-CT207796 to this agreement.\r\n","2020-05-20","12",0,null,0,"0","2","2020-06-10 15:29:26","2","2020-06-10 15:29:26","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"053,63642","C160153","PERSONAL","Ms","KkrSDrQ1H2C7AHMXanK04g==","5c4M0ZQmSIw3LaJy30yaLQ==","","VydP8q4rzuZV5xu3JM4S94+vjANpX0mSGFwOYMOB853mNnGiX4hnOAOtYB32IPMF","G4ql4s\/qkLFXwmJNbU6cdQ==","2yv4BPlbG\/\/YEJETfEEfNB1ddarjnzyQnu7bGnobgMM=","N0BX828OAg4Z6rH9GAZdUA==",null,1,"4883"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 15:29: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":["8088","227","998.0","998.00","2","2020-06-10 15:29:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 15:29: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-05-20","2020-06-19","227"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 15:29: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":["8088",153,"SETTLED","A12-I208417","2020-06-10 15:29:26","2020-05-20","2","2020-06-10 15:29:26","2","2020-06-10 15:29:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 15:29: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":["8417","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-06-10 15:29:26","2","2020-06-10 15:29:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 15:29:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"8417"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-10 15:29: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":[153,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208060","2020-06-10 15:29:26",998,"2","2020-06-10 15:29:26","2","2020-06-10 15:29:26","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 15:29: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":["8060","DEPOSIT",null,"PAID","2020-06-10 15:29:26",0,"2","2020-06-10 15:29:26","2","2020-06-10 15:29:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 15:29: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":["8060","INVOICE","8417","PAID","2020-06-10 15:29:26",998,"2","2020-06-10 15:29:26","2","2020-06-10 15:29:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 15:37: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","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":888,"customer_code":"C180888","identity_type":"PERSONAL","identity_id":"K099955(5)","title":"Ms","lastname":"Ho","firstname":"Man Yee Cherie","companyname":"","email":"cheriehmy@gmail.com","tel":"90575456","address":"Flat A, 1\/F, Block 9, Fullview Garden, 18 Siu Sai Wan Road, Siu Sai Wan, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1488.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-06","renew_room_key":"0005763937","renew_remark":"1 month contract. Storage rental paid by PPS on May 4, 2020. Storage deposit $2976 transferred from agreement B01-CT207586 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT207786, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"143","order_discount":[],"order_room":[{"room_id":"1274","room_code":"B01-084","retail_price":"1488.0","discounted_price":"1488.00","location_id":"5"}],"roughly_size":"24","total_retail_price":1488,"total_discounted_price":1488,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1488,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-06","rent_from":"2020-06-06","rent_to":"2020-07-05","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on June 9, 2020. Storage deposit $2976 transferred from agreement B01-CT207786 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1488,"final_order_total":1488,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0005763937","order_product":[],"pass":true}},"first_order_id":"4797","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> B01-084 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1488.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1488.0","deposit":"0","total_retail_price":"1488.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 15:37:25","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","2","5",888,"NEW","B01-CT208089",1488,1488,0,0,"1","1",1488,1488,1488,"2020-06-10 15:37:25","0",null,null,null,"2020-06-06","2020-07-05","1 month contract. Storage rental paid by PPS on June 9, 2020. Storage deposit $2976 transferred from agreement B01-CT207786 to this agreement.\r\n","2020-06-06","24",0,null,0,"0","2","2020-06-10 15:37:25","2","2020-06-10 15:37:25","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0005763937","C180888","PERSONAL","Ms","B6XcmzmDA9cWki+qLStEaA==","D\/skxQ5s\/L5yyRWaDK\/iSg==","","zb+wEJU2BcjiqagYCnyRNQzS3jTcz1KQCkGgLWtY\/y+C8KU+srfsdCNTrRUrjSHTpRbkV0JFumXQh3K4klaHUNKIaPzoQH6Ro1qQAUtDwWHyil1VPuPOWLDOdLKNt30K","Mv9sZMBZUVgbHGVZIxyZfQ==","d8Ms1Ternr8fasYV7yyV8x0bubUdhthIhbdOyphH3tQ=","b0wVwk81Vh1dF13X\/TkOaw==",null,1,"4797"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 15:37:25","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":["8089","1274","1488.0","1488.00","2","2020-06-10 15:37:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 15:37:25","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-06-06","2020-07-05","1274"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 15:37:25","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":["8089",888,"SETTLED","B01-I208418","2020-06-10 15:37:25","2020-06-06","2","2020-06-10 15:37:25","2","2020-06-10 15:37:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 15:37:25","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":["8418","RENT","\u9810\u7e73\u79df\u91d1",1,1488,"MO","1",1488,"2","2020-06-10 15:37:25","2","2020-06-10 15:37:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 15:37:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1488,0,"8418"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-10 15:37:25","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":[888,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208061","2020-06-10 15:37:25",1488,"2","2020-06-10 15:37:25","2","2020-06-10 15:37:25","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 15:37:25","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":["8061","DEPOSIT",null,"PAID","2020-06-10 15:37:25",0,"2","2020-06-10 15:37:25","2","2020-06-10 15:37:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 15:37:25","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":["8061","INVOICE","8418","PAID","2020-06-10 15:37:25",1488,"2","2020-06-10 15:37:25","2","2020-06-10 15:37:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 15:42:22","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&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":888,"customer_code":"C180888","identity_type":"PERSONAL","identity_id":"K099955(5)","title":"Ms","lastname":"Ho","firstname":"Man Yee Cherie","companyname":"","email":"cheriehmy@gmail.com","tel":"90575456","address":"Flat A, 1\/F, Block 9, Fullview Garden, 18 Siu Sai Wan Road, Siu Sai Wan, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1112.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-27","renew_room_key":"0005763937","renew_remark":"1 month contract. Storage rental paid by PPS on May 26, 2020. Storage deposit $2224 transferred from agreement B01-CT207661 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT207980, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"140","order_discount":[],"order_room":[{"room_id":"1237","room_code":"B01-047","retail_price":"1112.0","discounted_price":"1112.00","location_id":"5"}],"roughly_size":"16","total_retail_price":1112,"total_discounted_price":1112,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1112,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-27","rent_from":"2020-06-27","rent_to":"2020-07-26","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on JUNE 9, 2020. Storage deposit $2224 transferred from agreement B01-CT207980 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1112,"final_order_total":1112,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0005763937","order_product":[],"pass":true}},"first_order_id":"4003","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> B01-047 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1112.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1112.00","deposit":"00.00","total_retail_price":"1112.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 15:42:22","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","2","5",888,"NEW","B01-CT208090",1112,1112,0,0,"1","1",1112,1112,1112,"2020-06-10 15:42:22","0",null,null,null,"2020-06-27","2020-07-26","1 month contract. Storage rental paid by PPS on JUNE 9, 2020. Storage deposit $2224 transferred from agreement B01-CT207980 to this agreement.\r\n","2020-06-27","16",0,null,0,"0","2","2020-06-10 15:42:21","2","2020-06-10 15:42:21","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0005763937","C180888","PERSONAL","Ms","B6XcmzmDA9cWki+qLStEaA==","D\/skxQ5s\/L5yyRWaDK\/iSg==","","zb+wEJU2BcjiqagYCnyRNQzS3jTcz1KQCkGgLWtY\/y+C8KU+srfsdCNTrRUrjSHTpRbkV0JFumXQh3K4klaHUNKIaPzoQH6Ro1qQAUtDwWHyil1VPuPOWLDOdLKNt30K","Mv9sZMBZUVgbHGVZIxyZfQ==","d8Ms1Ternr8fasYV7yyV8x0bubUdhthIhbdOyphH3tQ=","b0wVwk81Vh1dF13X\/TkOaw==",null,1,"4003"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 15:42:22","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":["8090","1237","1112.0","1112.00","2","2020-06-10 15:42:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 15:42:22","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-06-27","2020-07-26","1237"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 15:42:22","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":["8090",888,"SETTLED","B01-I208419","2020-06-10 15:42:21","2020-06-27","2","2020-06-10 15:42:21","2","2020-06-10 15:42:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 15:42:22","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":["8419","RENT","\u9810\u7e73\u79df\u91d1",1,1112,"MO","1",1112,"2","2020-06-10 15:42:21","2","2020-06-10 15:42:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 15:42:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1112,0,"8419"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-10 15:42:22","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":[888,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208062","2020-06-10 15:42:21",1112,"2","2020-06-10 15:42:21","2","2020-06-10 15:42:21","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 15:42:22","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":["8062","DEPOSIT",null,"PAID","2020-06-10 15:42:21",0,"2","2020-06-10 15:42:21","2","2020-06-10 15:42:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 15:42:22","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":["8062","INVOICE","8419","PAID","2020-06-10 15:42:21",1112,"2","2020-06-10 15:42:21","2","2020-06-10 15:42:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 15:50:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:25:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:33:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:42:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:43:54","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":428,"customer_code":"C170428","identity_type":"PERSONAL","identity_id":"E5844510(0)","title":"Mr","lastname":"Yip","firstname":"Kwok Kwai","companyname":"","email":"joeyippkk@hotmail.com","tel":"61830561","address":"Flat D,13\/F,Mei Hay Court,South Horizon,Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1139.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-06","renew_room_key":"053,57784,055,49261","renew_remark":"6 months contract. Storage rental paid by bank transfer on Nov 2, 2019. Storage deposit transferred from agreement A12-CT194871 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196292, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"102","room_code":"B50","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1205,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3615,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-06","rent_from":"2020-05-06","rent_to":"2020-08-05","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on May 4, 2020. Storage deposit transferred from agreement A12-CT196292 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3615,"final_order_total":3615,"location_id":"1","branch_id":"1","company_id":"1","room_key":"053,57784,055,49261","order_product":[],"pass":true}},"first_order_id":"4871","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> B50 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1205.00","deposit":"0.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:43:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",428,"NEW","A12-CT208091",1528,1205,0,0,"3","3",3615,3615,3615,"2020-06-10 16:43:55","0",null,null,null,"2020-05-06","2020-08-05","3 months contract. Storage rental paid by bank transfer on May 4, 2020. Storage deposit transferred from agreement A12-CT196292 to this agreement.\r\n","2020-05-06","20",0,null,0,"0","2","2020-06-10 16:43:54","2","2020-06-10 16:43:54","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"053,57784,055,49261","C170428","PERSONAL","Mr","91\/laaizCwPmpW9Kp7VfpQ==","H9gmHz05\/Te4s1\/V+q8XVg==","","65X9bXQhfMS5Sw3s18SCYnlHuJ74GEdJyMMi7ZWpUt\/xzahhd5USFse9zIrw+zM344D4e5mlnLBzwvdEJf5l0w==","BiBf1UPmN8aaS3XWB1RrSQ==","89NMk5xkAVgN7m2oNV6RkxT9h8K4NzHWFs3mEXMgHMY=","sMhsPbXldtAIhN9s+8njNA==",null,1,"4871"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:43:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8091","102","1528.0","1528.00","2","2020-06-10 16:43:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:43:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-06","2020-08-05","102"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 16:43:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8091",428,"SETTLED","A12-I208420","2020-06-10 16:43:54","2020-05-06","2","2020-06-10 16:43:54","2","2020-06-10 16:43:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:43:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8420","RENT","\u9810\u7e73\u79df\u91d1",1,1205,"MO","1",1205,"2","2020-06-10 16:43:54","2","2020-06-10 16:43:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:43:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8420","RENT","\u9810\u7e73\u79df\u91d1",2,1205,"MO","1",1205,"2","2020-06-10 16:43:54","2","2020-06-10 16:43:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:43:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8420","RENT","\u9810\u7e73\u79df\u91d1",3,1205,"MO","1",1205,"2","2020-06-10 16:43:54","2","2020-06-10 16:43:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:43:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3615,0,"8420"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-10 16:43:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[428,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208063","2020-06-10 16:43:54",3615,"2","2020-06-10 16:43:54","2","2020-06-10 16:43:54","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:43:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8063","DEPOSIT",null,"PAID","2020-06-10 16:43:54",0,"2","2020-06-10 16:43:54","2","2020-06-10 16:43:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:43:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8063","INVOICE","8420","PAID","2020-06-10 16:43:54",3615,"2","2020-06-10 16:43:54","2","2020-06-10 16:43:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16: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","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":153,"customer_code":"C160153","identity_type":"PERSONAL","identity_id":"Z614380(7)","title":"Ms","lastname":"Au-Yeung","firstname":"Pik Kwan","companyname":"","email":"carol_85_2000@yahoo.com.hk","tel":"97502271","address":"\u9999\u6e2f\u77f3\u6392\u7063\u6751\u78a7\u8f1d\u6a137\u6a13706\u5ba4","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-20","renew_room_key":"053,63642","renew_remark":"1 month contract. Storage rental paid by PPS on June 5, 2020. Storage deposit transferred from agreement A12-CT207796 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT208088, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"227","room_code":"D31","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":998,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-20","rent_from":"2020-06-20","rent_to":"2020-07-19","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on JUNE 10, 2020. Storage deposit transferred from agreement A12-CT208088 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":998,"final_order_total":998,"location_id":"1","branch_id":"1","company_id":"1","room_key":"053,63642","order_product":[],"pass":true}},"first_order_id":"4883","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> D31 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"998.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:45:45","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",153,"NEW","A12-CT208092",998,998,0,0,"1","1",998,998,998,"2020-06-10 16:45:45","0",null,null,null,"2020-06-20","2020-07-19","1 month contract. Storage rental paid by PPS on JUNE 10, 2020. Storage deposit transferred from agreement A12-CT208088 to this agreement.","2020-06-20","12",0,null,0,"0","2","2020-06-10 16:45:45","2","2020-06-10 16:45:45","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"053,63642","C160153","PERSONAL","Ms","KkrSDrQ1H2C7AHMXanK04g==","5c4M0ZQmSIw3LaJy30yaLQ==","","VydP8q4rzuZV5xu3JM4S94+vjANpX0mSGFwOYMOB853mNnGiX4hnOAOtYB32IPMF","G4ql4s\/qkLFXwmJNbU6cdQ==","2yv4BPlbG\/\/YEJETfEEfNB1ddarjnzyQnu7bGnobgMM=","N0BX828OAg4Z6rH9GAZdUA==",null,1,"4883"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:45:45","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":["8092","227","998.0","998.00","2","2020-06-10 16:45:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:45:45","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-06-20","2020-07-19","227"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 16:45:45","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":["8092",153,"SETTLED","A12-I208421","2020-06-10 16:45:45","2020-06-20","2","2020-06-10 16:45:45","2","2020-06-10 16:45:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:45:45","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":["8421","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-06-10 16:45:45","2","2020-06-10 16:45:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:45:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"8421"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-10 16:45:45","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":[153,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208064","2020-06-10 16:45:45",998,"2","2020-06-10 16:45:45","2","2020-06-10 16:45:45","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:45:45","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":["8064","DEPOSIT",null,"PAID","2020-06-10 16:45:45",0,"2","2020-06-10 16:45:45","2","2020-06-10 16:45:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:45:45","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":["8064","INVOICE","8421","PAID","2020-06-10 16:45:45",998,"2","2020-06-10 16:45:45","2","2020-06-10 16:45:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:54:37","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","053,57784,055,49261","3 months contract. Storage rental paid by bank transfer on May 4, 2020. Storage deposit transferred from agreement A12-CT196292 to this agreement.\r\n","2020-06-10 16:54:37","2","H9gmHz05\/Te4s1\/V+q8XVg==","91\/laaizCwPmpW9Kp7VfpQ==","89NMk5xkAVgN7m2oNV6RkxT9h8K4NzHWFs3mEXMgHMY=","BiBf1UPmN8aaS3XWB1RrSQ==","65X9bXQhfMS5Sw3s18SCYnlHuJ74GEdJyMMi7ZWpUt\/xzahhd5USFse9zIrw+zM344D4e5mlnLBzwvdEJf5l0w==",8091]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:58:26","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":94,"customer_code":"C160094","identity_type":"PERSONAL","identity_id":"D206211(A)","title":"Ms","lastname":"Man","firstname":"Kam Ping","companyname":"","email":null,"tel":"91236797","address":"Room F,15\/FL,Tower 25,South Horizons,AP LEI CHAU ,HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"338.0","renew_rent_month":"3","renew_warehousing_date":"2020-05-05","renew_room_key":"032,36140","renew_remark":"3 months contract. Storage rental paid by bank transfer on February 6, 2020. Storage deposit transferred from agreement A12-CT196469 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207125, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"26","order_discount":[],"order_room":[{"room_id":"298","room_code":"E25","retail_price":"268.0","discounted_price":"268.00","location_id":"1"}],"roughly_size":"4","total_retail_price":268,"total_discounted_price":338,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":1014,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-05","rent_from":"2020-05-05","rent_to":"2020-08-04","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on May 11, 2020. Storage deposit transferred from agreement A12-CT207125 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1014,"final_order_total":1014,"location_id":"1","branch_id":"1","company_id":"1","room_key":"032,36140","order_product":[],"pass":true}},"first_order_id":"3669","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> E25 <\/td>\r\n\t\t\t\t\t 1X4X8 <\/td>\r\n\t\t\t\t\t $268.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"4","total_discounted_price":"338.0","deposit":"0","total_retail_price":"268.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:58:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",94,"NEW","A12-CT208093",268,338,0,0,"3","3",1014,1014,1014,"2020-06-10 16:58:27","0",null,null,null,"2020-05-05","2020-08-04","3 months contract. Storage rental paid by bank transfer on May 11, 2020. Storage deposit transferred from agreement A12-CT207125 to this agreement.","2020-05-05","4",0,null,0,"0","2","2020-06-10 16:58:26","2","2020-06-10 16:58:26","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"032,36140","C160094","PERSONAL","Ms","92ETzwHeYMOYZxdoGpxA8A==","1iB+Fi5mVPBhoP\/ei\/0Bag==","","pePfDJoMhvz2LcMCDENBlc7wGRh5AvJF3bXEYvrf9Ot4kNFvR\/krqOxYffey5CQ4l6W3\/9p0HQuoDJII5yNhtw==","xoV7Mm99UV+XnUNheCKUvw==",null,"eMMMOH6zPRoPG9zZWSgWxw==",null,1,"3669"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:58: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":["8093","298","268.0","268.00","2","2020-06-10 16:58:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:58: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-05-05","2020-08-04","298"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 16:58: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":["8093",94,"SETTLED","A12-I208422","2020-06-10 16:58:26","2020-05-05","2","2020-06-10 16:58:26","2","2020-06-10 16:58:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:58: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":["8422","RENT","\u9810\u7e73\u79df\u91d1",1,338,"MO","1",338,"2","2020-06-10 16:58:26","2","2020-06-10 16:58:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:58: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":["8422","RENT","\u9810\u7e73\u79df\u91d1",2,338,"MO","1",338,"2","2020-06-10 16:58:26","2","2020-06-10 16:58:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:58: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":["8422","RENT","\u9810\u7e73\u79df\u91d1",3,338,"MO","1",338,"2","2020-06-10 16:58:26","2","2020-06-10 16:58:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:58:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1014,0,"8422"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-10 16:58: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":[94,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208065","2020-06-10 16:58:26",1014,"2","2020-06-10 16:58:26","2","2020-06-10 16:58:26","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:58: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":["8065","DEPOSIT",null,"PAID","2020-06-10 16:58:26",0,"2","2020-06-10 16:58:26","2","2020-06-10 16:58:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 16:58: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":["8065","INVOICE","8422","PAID","2020-06-10 16:58:26",1014,"2","2020-06-10 16:58:26","2","2020-06-10 16:58:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:11:26","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":428,"customer_code":"C170428","identity_type":"PERSONAL","identity_id":"E5844510(0)","title":"Mr","lastname":"Yip","firstname":"Kwok Kwai","companyname":"","email":"joeyippkk@hotmail.com","tel":"61830561","address":"Flat D,13\/F,Mei Hay Court,South Horizon,Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"949.0","renew_rent_month":"3","renew_warehousing_date":"2020-05-18","renew_room_key":"053,57784,055,49261","renew_remark":"3 months contract. Storage rental paid by bank transfer on February 13, 2020. Storage deposit $1996 transferred from agreement A12-CT196355 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207189, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[{"master_room_discount_id":"469","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"949.00","discount":"4.91","monthly_deduct":49.0018,"room_id":"222","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"222","room_code":"D26","retail_price":"998.0","discounted_price":949,"location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":949,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2847,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-18","rent_from":"2020-05-18","rent_to":"2020-08-17","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on MAY 4, 2020. Storage deposit $1996 transferred from agreement A12-CT207189 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2847,"final_order_total":2847,"location_id":"1","branch_id":"1","company_id":"1","room_key":"053,57784,055,49261","order_product":[],"pass":true}},"first_order_id":"6355","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> D26 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"949.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:11:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",428,"NEW","A12-CT208094",998,949,0,0,"3","3",2847,2847,2847,"2020-06-10 17:11:27","0",null,null,null,"2020-05-18","2020-08-17","3 months contract. Storage rental paid by bank transfer on MAY 4, 2020. Storage deposit $1996 transferred from agreement A12-CT207189 to this agreement. ","2020-05-18","12",0,null,0,"0","2","2020-06-10 17:11:26","2","2020-06-10 17:11:26","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"053,57784,055,49261","C170428","PERSONAL","Mr","91\/laaizCwPmpW9Kp7VfpQ==","H9gmHz05\/Te4s1\/V+q8XVg==","","65X9bXQhfMS5Sw3s18SCYnlHuJ74GEdJyMMi7ZWpUt\/xzahhd5USFse9zIrw+zM344D4e5mlnLBzwvdEJf5l0w==","BiBf1UPmN8aaS3XWB1RrSQ==","89NMk5xkAVgN7m2oNV6RkxT9h8K4NzHWFs3mEXMgHMY=","sMhsPbXldtAIhN9s+8njNA==",null,1,"6355"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:11:27","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":["8094","469","6","222","%","4.91",49.0018,"2","2020-06-10 17:11:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:11: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":["8094","222","998.0",949,"2","2020-06-10 17:11:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:11: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-05-18","2020-08-17","222"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 17:11: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":["8094",428,"SETTLED","A12-I208423","2020-06-10 17:11:26","2020-05-18","2","2020-06-10 17:11:26","2","2020-06-10 17:11:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:11: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":["8423","RENT","\u9810\u7e73\u79df\u91d1",1,949,"MO","1",949,"2","2020-06-10 17:11:26","2","2020-06-10 17:11:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:11: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":["8423","RENT","\u9810\u7e73\u79df\u91d1",2,949,"MO","1",949,"2","2020-06-10 17:11:26","2","2020-06-10 17:11:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:11: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":["8423","RENT","\u9810\u7e73\u79df\u91d1",3,949,"MO","1",949,"2","2020-06-10 17:11:26","2","2020-06-10 17:11:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:11:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2847,0,"8423"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-10 17:11: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":[428,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208066","2020-06-10 17:11:26",2847,"2","2020-06-10 17:11:26","2","2020-06-10 17:11:26","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:11: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":["8066","DEPOSIT",null,"PAID","2020-06-10 17:11:26",0,"2","2020-06-10 17:11:26","2","2020-06-10 17:11:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:11: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":["8066","INVOICE","8423","PAID","2020-06-10 17:11:26",2847,"2","2020-06-10 17:11:26","2","2020-06-10 17:11:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:12: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=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1433,"customer_code":"C191433","identity_type":"PERSONAL","identity_id":"K186942(6)","title":"Ms","lastname":"CHONG","firstname":"Hiu Sai Stephanie","companyname":"","email":"kaczorowski@netvigator.com","tel":"96159015","address":"Flat B, 18\/F, TWR 10, Larvotto, 8 Ap Lei Chau Praya Rd, Ap Lei Chau, HK.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4400.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-01","renew_room_key":"191,03185","renew_remark":"1 month contract. Special offer $4400\/mth. Storage rental paid by bank transfer on April 8, 2020. Deposit $4400 transferred from A14-CT207424 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207600, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"579","room_code":"L57","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"578","room_code":"L56","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"577","room_code":"L55","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"589","room_code":"L67","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"588","room_code":"L66","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"587","room_code":"L65","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"96","total_retail_price":6588,"total_discounted_price":4400,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":4400,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-01","rent_from":"2020-04-01","rent_to":"2020-04-30","delivery_service":"0","remark":"1 month contract. Special offer $4400\/mth. Storage rental paid by bank transfer on June 8, 2020. Deposit $4400 transferred from A14-CT207600 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4400,"final_order_total":4400,"location_id":"2","branch_id":"1","company_id":"1","room_key":"191,03185","order_product":[],"pass":true}},"first_order_id":"6263","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> L57 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> L56 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> L55 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> L67 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> L66 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> L65 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"96","total_discounted_price":"4400.0","deposit":"0","total_retail_price":"6588.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:12:41","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",1433,"NEW","A14-CT208095",6588,4400,0,0,"1","1",4400,4400,4400,"2020-06-10 17:12:41","0",null,null,null,"2020-04-01","2020-04-30","1 month contract. Special offer $4400\/mth. Storage rental paid by bank transfer on June 8, 2020. Deposit $4400 transferred from A14-CT207600 to this agreement.\r\n","2020-04-01","96",0,null,0,"0","2","2020-06-10 17:12:40","2","2020-06-10 17:12:40","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"191,03185","C191433","PERSONAL","Ms","jvk7zrBnQZbXfX1dgEQlHe0RI1vs\/c8ofCzDIiHPduw=","sFvIMVuF8ZsYisXFtwlNOg==","","voDtSK9PGGTovDOARqXC4\/CqVs\/FW\/EFt+7Y8XgoNXnKX\/oYLjrZhZIszuJBDn5WLlxnxR+ombwIyw2An8MxBSJza\/jcybdtGn9ZStmQV6U=","WkO2u9lqQEjRnfUKLBy+6Q==","WfnjLYwTfgHTPaehcdhvGWTDmhNfxmwxxekvQ0TBxrg=","F4vjEMLSruInVObtV1LPJw==",null,1,"6263"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:12:41","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":["8095","579","1098.0","1098.00","2","2020-06-10 17:12:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:12:41","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-04-01","2020-04-30","579"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 17:12:41","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":["8095","578","1098.0","1098.00","2","2020-06-10 17:12:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:12:41","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-04-01","2020-04-30","578"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 17:12:41","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":["8095","577","1098.0","1098.00","2","2020-06-10 17:12:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:12:41","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-04-01","2020-04-30","577"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 17:12:41","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":["8095","589","1098.0","1098.00","2","2020-06-10 17:12:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:12:41","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-04-01","2020-04-30","589"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 17:12:41","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":["8095","588","1098.0","1098.00","2","2020-06-10 17:12:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:12:41","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-04-01","2020-04-30","588"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 17:12:41","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":["8095","587","1098.0","1098.00","2","2020-06-10 17:12:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:12:41","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-04-01","2020-04-30","587"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 17:12:41","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":["8095",1433,"SETTLED","A14-I208424","2020-06-10 17:12:40","2020-04-01","2","2020-06-10 17:12:40","2","2020-06-10 17:12:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:12:41","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":["8424","RENT","\u9810\u7e73\u79df\u91d1",1,4400,"MO","1",4400,"2","2020-06-10 17:12:40","2","2020-06-10 17:12:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:12:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4400,0,"8424"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-10 17:12:41","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":[1433,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208067","2020-06-10 17:12:40",4400,"2","2020-06-10 17:12:40","2","2020-06-10 17:12:40","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:12:41","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":["8067","DEPOSIT",null,"PAID","2020-06-10 17:12:40",0,"2","2020-06-10 17:12:40","2","2020-06-10 17:12:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:12:41","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":["8067","INVOICE","8424","PAID","2020-06-10 17:12:40",4400,"2","2020-06-10 17:12:40","2","2020-06-10 17:12:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:13: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","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1433,"customer_code":"C191433","identity_type":"PERSONAL","identity_id":"K186942(6)","title":"Ms","lastname":"CHONG","firstname":"Hiu Sai Stephanie","companyname":"","email":"kaczorowski@netvigator.com","tel":"96159015","address":"Flat B, 18\/F, TWR 10, Larvotto, 8 Ap Lei Chau Praya Rd, Ap Lei Chau, HK.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3920.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-01","renew_room_key":"191,03185","renew_remark":"1 month contract. Special price $3920\/mth. Storage rental paid by bank transfer on April 8, 2020. Deposit $3920 transferred from agreement A14-CT207425 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207601, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"683","room_code":"M94","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"682","room_code":"M93","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"681","room_code":"M92","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"672","room_code":"M83","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"671","room_code":"M82","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"670","room_code":"M81","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"72","total_retail_price":5988,"total_discounted_price":3920,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":3920,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-01","rent_from":"2020-04-01","rent_to":"2020-04-30","delivery_service":"0","remark":"1 month contract. Special price $3920\/mth. Storage rental paid by bank transfer on June 8, 2020. Deposit $3920 transferred from agreement A14-CT207601 to this agreement.\r\n\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3920,"final_order_total":3920,"location_id":"2","branch_id":"1","company_id":"1","room_key":"191,03185","order_product":[],"pass":true}},"first_order_id":"6272","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> M94 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> M93 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> M92 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> M83 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> M82 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> M81 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"72","total_discounted_price":"3920.0","deposit":"0","total_retail_price":"5988.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:13: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",1433,"NEW","A14-CT208096",5988,3920,0,0,"1","1",3920,3920,3920,"2020-06-10 17:13:46","0",null,null,null,"2020-04-01","2020-04-30","1 month contract. Special price $3920\/mth. Storage rental paid by bank transfer on June 8, 2020. Deposit $3920 transferred from agreement A14-CT207601 to this agreement.\r\n\r\n","2020-04-01","72",0,null,0,"0","2","2020-06-10 17:13:45","2","2020-06-10 17:13:45","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"191,03185","C191433","PERSONAL","Ms","jvk7zrBnQZbXfX1dgEQlHe0RI1vs\/c8ofCzDIiHPduw=","sFvIMVuF8ZsYisXFtwlNOg==","","voDtSK9PGGTovDOARqXC4\/CqVs\/FW\/EFt+7Y8XgoNXnKX\/oYLjrZhZIszuJBDn5WLlxnxR+ombwIyw2An8MxBSJza\/jcybdtGn9ZStmQV6U=","WkO2u9lqQEjRnfUKLBy+6Q==","WfnjLYwTfgHTPaehcdhvGWTDmhNfxmwxxekvQ0TBxrg=","F4vjEMLSruInVObtV1LPJw==",null,1,"6272"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:13: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":["8096","683","998.0","998.00","2","2020-06-10 17:13:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:13: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-04-01","2020-04-30","683"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 17:13: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":["8096","682","998.0","998.00","2","2020-06-10 17:13:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:13: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-04-01","2020-04-30","682"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 17:13: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":["8096","681","998.0","998.00","2","2020-06-10 17:13:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:13: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-04-01","2020-04-30","681"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 17:13: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":["8096","672","998.0","998.00","2","2020-06-10 17:13:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:13: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-04-01","2020-04-30","672"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 17:13: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":["8096","671","998.0","998.00","2","2020-06-10 17:13:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:13: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-04-01","2020-04-30","671"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 17:13: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":["8096","670","998.0","998.00","2","2020-06-10 17:13:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:13: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-04-01","2020-04-30","670"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 17:13: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":["8096",1433,"SETTLED","A14-I208425","2020-06-10 17:13:45","2020-04-01","2","2020-06-10 17:13:45","2","2020-06-10 17:13:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:13: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":["8425","RENT","\u9810\u7e73\u79df\u91d1",1,3920,"MO","1",3920,"2","2020-06-10 17:13:45","2","2020-06-10 17:13:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:13:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3920,0,"8425"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-10 17:13: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":[1433,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208068","2020-06-10 17:13:45",3920,"2","2020-06-10 17:13:45","2","2020-06-10 17:13:45","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:13: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":["8068","DEPOSIT",null,"PAID","2020-06-10 17:13:45",0,"2","2020-06-10 17:13:45","2","2020-06-10 17:13:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:13: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":["8068","INVOICE","8425","PAID","2020-06-10 17:13:45",3920,"2","2020-06-10 17:13:45","2","2020-06-10 17:13:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:19:06","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&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":398,"customer_code":"C170398","identity_type":"PERSONAL","identity_id":"D57404(8)","title":"Ms","lastname":" Leung","firstname":"Yuen Yee","companyname":"","email":"hinmama@yahoo.com","tel":"92232100","address":"16B Hoi Fai Court,South Horizon Drive 2,South Horizon,Apleichau","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"992.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-01","renew_room_key":"055,00264","renew_remark":"6 months contract. Storage rental paid by bank transfer on December 9, 2019. Storage deposit transferred from agreement A14-CT195010 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196649, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"67","order_discount":[],"order_room":[{"room_id":"709","room_code":"N26(\u670d\u88dd\u5009)","retail_price":"1118.0","discounted_price":"1118.00","location_id":"2"}],"roughly_size":"12","total_retail_price":1118,"total_discounted_price":992,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5952,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-01","rent_from":"2020-05-01","rent_to":"2020-10-31","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on June 4, 2020. Storage deposit transferred from agreement A14-CT196649 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5952,"final_order_total":5952,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,00264","order_product":[],"pass":true}},"first_order_id":"3864","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> N26(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $1118.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"992.0","deposit":"0","total_retail_price":"1118.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:19:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",398,"NEW","A14-CT208097",1118,992,0,0,"6","6",5952,5952,5952,"2020-06-10 17:19:06","0",null,null,null,"2020-05-01","2020-10-31","6 months contract. Storage rental paid by bank transfer on June 4, 2020. Storage deposit transferred from agreement A14-CT196649 to this agreement.","2020-05-01","12",0,null,0,"0","2","2020-06-10 17:19:06","2","2020-06-10 17:19:06","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,00264","C170398","PERSONAL","Ms","KrUWcmrrreWoFN9TjxoGzw==","hDcaVKVh5vEJg+a3zjrLLQ==","","ixJqWT7UXFmW3+S2xFsrcPC9YERnwpjfXouDStHci4TR55B+LaQrE4227D0WlNtRfvH9PRhjLg3yY9ENR+tHGw==","PRYRih+aY5sIAghH77HWmw==","uWOM3aL+hXXKFD0tHtvJpl3+ilhkKnRtQ3LeugegR8o=","XZPM\/RS69ycEGeSGozKkAw==",null,1,"3864"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:19:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8097","709","1118.0","1118.00","2","2020-06-10 17:19:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:19:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-01","2020-10-31","709"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 17:19:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8097",398,"SETTLED","A14-I208426","2020-06-10 17:19:06","2020-05-01","2","2020-06-10 17:19:06","2","2020-06-10 17:19:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:19:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8426","RENT","\u9810\u7e73\u79df\u91d1",1,992,"MO","1",992,"2","2020-06-10 17:19:06","2","2020-06-10 17:19:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:19:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8426","RENT","\u9810\u7e73\u79df\u91d1",2,992,"MO","1",992,"2","2020-06-10 17:19:06","2","2020-06-10 17:19:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:19:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8426","RENT","\u9810\u7e73\u79df\u91d1",3,992,"MO","1",992,"2","2020-06-10 17:19:06","2","2020-06-10 17:19:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:19:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8426","RENT","\u9810\u7e73\u79df\u91d1",4,992,"MO","1",992,"2","2020-06-10 17:19:06","2","2020-06-10 17:19:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:19:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8426","RENT","\u9810\u7e73\u79df\u91d1",5,992,"MO","1",992,"2","2020-06-10 17:19:06","2","2020-06-10 17:19:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:19:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8426","RENT","\u9810\u7e73\u79df\u91d1",6,992,"MO","1",992,"2","2020-06-10 17:19:06","2","2020-06-10 17:19:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:19:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5952,0,"8426"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-10 17:19:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[398,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208069","2020-06-10 17:19:06",5952,"2","2020-06-10 17:19:06","2","2020-06-10 17:19:06","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:19:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8069","DEPOSIT",null,"PAID","2020-06-10 17:19:06",0,"2","2020-06-10 17:19:06","2","2020-06-10 17:19:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:19:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8069","INVOICE","8426","PAID","2020-06-10 17:19:06",5952,"2","2020-06-10 17:19:06","2","2020-06-10 17:19:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:26:22","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&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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":580,"customer_code":"C170580","identity_type":"PERSONAL","identity_id":"P163993(9)","title":"Mr","lastname":"Chau","firstname":"Hei Keung Matthew","companyname":"","email":"matthew.chau.hk@gmail.com","tel":"95298642","address":"Room 5, 11\/F, Block B, Yue Fai Court, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2288.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-11","renew_room_key":"055,31848","renew_remark":"6 months contract. Storage rental paid by EPS on Nov 09, 2019. Storage deposit transferred from agreement A14-CT194866 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196345, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"72","order_discount":[{"master_room_discount_id":"158","master_room_id":"72","discount_type":"%","price":"3028.00","disocunted_price":"2422.40","discount":"20.00","monthly_deduct":605.6,"room_id":"712","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"712","room_code":"N29","retail_price":"3028.0","discounted_price":2422.4,"location_id":"2"}],"roughly_size":"42","total_retail_price":3028,"total_discounted_price":2288,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":13728,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-11","rent_from":"2020-05-11","rent_to":"2020-11-10","delivery_service":"0","remark":"6 months contract. Storage rental paid by cash on May 10, 2020. Storage deposit transferred from agreement A14-CT196345 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":13728,"final_order_total":13728,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,31848","order_product":[],"pass":true}},"first_order_id":"4866","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> N29 <\/td>\r\n\t\t\t\t\t 7X6X8 <\/td>\r\n\t\t\t\t\t $3028.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"42","total_discounted_price":"2288.0","deposit":"0","total_retail_price":"3028.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:26:23","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",580,"NEW","A14-CT208098",3028,2288,0,0,"6","6",13728,13728,13728,"2020-06-10 17:26:23","0",null,null,null,"2020-05-11","2020-11-10","6 months contract. Storage rental paid by cash on May 10, 2020. Storage deposit transferred from agreement A14-CT196345 to this agreement.","2020-05-11","42",0,null,0,"0","2","2020-06-10 17:26:22","2","2020-06-10 17:26:22","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"055,31848","C170580","PERSONAL","Mr","5PXCv8mhYFjinu5EmtGAzfRH0Bke7CtCl8Q46fXkeHs=","kOK3vHUlGE9qjoVnzYRDGA==","","aK7sZFwnxbZUPM5V+bu2FGf\/P+q6y\/XOTiLRZJ2J0vrF1YmKRBBm7m0WFqEpD2fSEnFyDuSaiidjH3vm3YE4Pg==","GdwWFqi2rQIhijwmSD3eUQ==","7D5iWGekwSjzHJI3wtDuGO7HEM+VDrVJtQTdOzmFUbE=","ySyFh24H+aoPO5qSE5zNHg==",null,1,"4866"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:26:23","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":["8098","158","72","712","%","20.00",605.6,"2","2020-06-10 17:26:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:26:23","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":["8098","712","3028.0",2422.4,"2","2020-06-10 17:26:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:26:23","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-05-11","2020-11-10","712"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 17:26:23","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":["8098",580,"SETTLED","A14-I208427","2020-06-10 17:26:22","2020-05-11","2","2020-06-10 17:26:22","2","2020-06-10 17:26:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:26:23","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":["8427","RENT","\u9810\u7e73\u79df\u91d1",1,2288,"MO","1",2288,"2","2020-06-10 17:26:22","2","2020-06-10 17:26:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:26:23","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":["8427","RENT","\u9810\u7e73\u79df\u91d1",2,2288,"MO","1",2288,"2","2020-06-10 17:26:22","2","2020-06-10 17:26:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:26:23","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":["8427","RENT","\u9810\u7e73\u79df\u91d1",3,2288,"MO","1",2288,"2","2020-06-10 17:26:22","2","2020-06-10 17:26:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:26:23","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":["8427","RENT","\u9810\u7e73\u79df\u91d1",4,2288,"MO","1",2288,"2","2020-06-10 17:26:22","2","2020-06-10 17:26:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:26:23","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":["8427","RENT","\u9810\u7e73\u79df\u91d1",5,2288,"MO","1",2288,"2","2020-06-10 17:26:22","2","2020-06-10 17:26:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:26:23","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":["8427","RENT","\u9810\u7e73\u79df\u91d1",6,2288,"MO","1",2288,"2","2020-06-10 17:26:22","2","2020-06-10 17:26:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:26:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13728,0,"8427"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-10 17:26:23","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":[580,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P208070","2020-06-10 17:26:22",13728,"2","2020-06-10 17:26:22","2","2020-06-10 17:26:22","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:26:23","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":["8070","DEPOSIT",null,"PAID","2020-06-10 17:26:22",0,"2","2020-06-10 17:26:22","2","2020-06-10 17:26:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:26:23","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":["8070","INVOICE","8427","PAID","2020-06-10 17:26:22",13728,"2","2020-06-10 17:26:22","2","2020-06-10 17:26:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:27:49","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&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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":675,"customer_code":"C170675","identity_type":"PERSONAL","identity_id":"D219583(7)","title":"Mr","lastname":"Pun","firstname":"Wing Cheong","companyname":"","email":null,"tel":"93211435","address":"Flat 3413, Tung Ping House, Lei Tung Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1525.0","renew_rent_month":"3","renew_warehousing_date":"2020-05-01","renew_room_key":"055,43050","renew_remark":"3 months contract. Storage rental paid by bank transfer on March 4, 2020. Storage deposit transferred from agreement A18-CT196813 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207326, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"78","order_discount":[{"master_room_discount_id":"252","master_room_id":"78","discount_type":"%","price":"1605.00","disocunted_price":"1524.80","discount":"5.00","monthly_deduct":80.25,"room_id":"922","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"922","room_code":"U23","retail_price":"1605.0","discounted_price":1524.8,"location_id":"3"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1525,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":4575,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-01","rent_from":"2020-05-01","rent_to":"2020-07-31","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on June 5, 2020. Storage deposit transferred from agreement A18-CT207326 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4575,"final_order_total":4575,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,43050","order_product":[],"pass":true}},"first_order_id":"4424","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> U23 <\/td>\r\n\t\t\t\t\t 4X5X7 <\/td>\r\n\t\t\t\t\t $1605.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1525.0","deposit":"0","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:27:49","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",675,"NEW","A18-CT208099",1605,1525,0,0,"3","3",4575,4575,4575,"2020-06-10 17:27:49","0",null,null,null,"2020-05-01","2020-07-31","3 months contract. Storage rental paid by bank transfer on June 5, 2020. Storage deposit transferred from agreement A18-CT207326 to this agreement.","2020-05-01","20",0,null,0,"0","2","2020-06-10 17:27:49","2","2020-06-10 17:27:49","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,43050","C170675","PERSONAL","Mr","zRl2wRT0bzGoBjayPtj0bg==","\/jZHfDSzBL6DMeP8beh11g==","","rQco+JL2vKS2IoKrZwA1yaG3nzWq9+b9wc4T7W6Yt5olYDVZu54iSWq\/s0b5tugnFNud6gxx+RBPNAHg26JO7xa3o0irEl2KUDPUiuatuPs=","8b1BJH8lCd7DJqxRE314HA==",null,"Od0RWXaEAXXPAqK4kTG2DQ==",null,1,"4424"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:27:49","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":["8099","252","78","922","%","5.00",80.25,"2","2020-06-10 17:27:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:27:49","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":["8099","922","1605.0",1524.8,"2","2020-06-10 17:27:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:27:49","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-05-01","2020-07-31","922"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 17:27:49","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":["8099",675,"SETTLED","A18-I208428","2020-06-10 17:27:49","2020-05-01","2","2020-06-10 17:27:49","2","2020-06-10 17:27:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:27:49","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":["8428","RENT","\u9810\u7e73\u79df\u91d1",1,1525,"MO","1",1525,"2","2020-06-10 17:27:49","2","2020-06-10 17:27:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:27:49","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":["8428","RENT","\u9810\u7e73\u79df\u91d1",2,1525,"MO","1",1525,"2","2020-06-10 17:27:49","2","2020-06-10 17:27:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:27:49","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":["8428","RENT","\u9810\u7e73\u79df\u91d1",3,1525,"MO","1",1525,"2","2020-06-10 17:27:49","2","2020-06-10 17:27:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:27:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4575,0,"8428"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-10 17:27:49","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":[675,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208071","2020-06-10 17:27:49",4575,"2","2020-06-10 17:27:49","2","2020-06-10 17:27:49","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:27:49","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":["8071","DEPOSIT",null,"PAID","2020-06-10 17:27:49",0,"2","2020-06-10 17:27:49","2","2020-06-10 17:27:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:27:49","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":["8071","INVOICE","8428","PAID","2020-06-10 17:27:49",4575,"2","2020-06-10 17:27:49","2","2020-06-10 17:27:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:31:04","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","053,57784,055,49261","3 months contract. Storage rental paid by bank transfer on MAY 4, 2020. Storage deposit $1996 transferred from agreement A12-CT207189 to this agreement. ","2020-06-10 17:31:04","2","H9gmHz05\/Te4s1\/V+q8XVg==","91\/laaizCwPmpW9Kp7VfpQ==","89NMk5xkAVgN7m2oNV6RkxT9h8K4NzHWFs3mEXMgHMY=","BiBf1UPmN8aaS3XWB1RrSQ==","65X9bXQhfMS5Sw3s18SCYnlHuJ74GEdJyMMi7ZWpUt\/xzahhd5USFse9zIrw+zM344D4e5mlnLBzwvdEJf5l0w==",8094]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:41:28","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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1286,"customer_code":"C191286","identity_type":"PERSONAL","identity_id":"K299542(5)","title":"Mr","lastname":"WAN","firstname":"Siu Chuen","companyname":"","email":"norki525@yahoo.com.hk","tel":"92389437","address":"Rm 2603, Wu On House, Yue On Court, Ap Lei Chau","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"6","renew_warehousing_date":"2020-06-09","renew_room_key":"076,58166","renew_remark":"6 months contract. Storage rental paid by cash on December 11, 2019. Storage deposit $1196 transferred from agreement A16-CT195163 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT196674, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"200","order_discount":[{"master_room_discount_id":"474","master_room_id":"200","discount_type":"%","price":"668.00","disocunted_price":"600.90","discount":"10.04","monthly_deduct":67.0672,"room_id":"1496","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1496","room_code":"A16-005","retail_price":"668.0","discounted_price":600.9,"location_id":"7"}],"roughly_size":"12","total_retail_price":668,"total_discounted_price":602,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3612,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-09","rent_from":"2020-06-09","rent_to":"2020-12-08","delivery_service":"0","remark":"6 months contract. Storage rental paid by EPS on JUNE 10. Storage deposit $1196 transferred from agreement A16-CT196674 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":3612,"final_order_total":3612,"location_id":"7","branch_id":"1","company_id":"1","room_key":"076,58166","order_product":[],"pass":true}},"first_order_id":"5163","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A16-005 <\/td>\r\n\t\t\t\t\t 4X3X3.5 <\/td>\r\n\t\t\t\t\t $668.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"602.00","deposit":"0","total_retail_price":"668.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:41:28","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","7",1286,"NEW","A16-CT208100",668,602,0,0,"6","6",3612,3612,3612,"2020-06-10 17:41:28","0",null,null,null,"2020-06-09","2020-12-08","6 months contract. Storage rental paid by EPS on JUNE 10. Storage deposit $1196 transferred from agreement A16-CT196674 to this agreement. ","2020-06-09","12",0,null,0,"0","2","2020-06-10 17:41:28","2","2020-06-10 17:41:28","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"076,58166","C191286","PERSONAL","Mr","\/vSa70zhic2PBI3\/SYA9hg==","2+HhFlKBGl3L\/0uDqNi5+g==","","90hiaCa3Ox\/aQSXnM\/CKz2KFaqLAzp+M6PDFO7O4QJBYbbOMkB00wKM1iR2tXveP","eK+vnDTqwMWXbLLlPuYW9Q==","RCAA9oqQn4aU7kXNIDRBSoB0gExzyePtfqGgJHtCC\/g=","zJEGcYRJWhy2wnkEkrgXOg==",null,1,"5163"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:41:28","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":["8100","474","200","1496","%","10.04",67.0672,"2","2020-06-10 17:41:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:41:28","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":["8100","1496","668.0",600.9,"2","2020-06-10 17:41:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:41:28","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-06-09","2020-12-08","1496"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 17:41:28","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":["8100",1286,"SETTLED","A16-I208429","2020-06-10 17:41:28","2020-06-09","2","2020-06-10 17:41:28","2","2020-06-10 17:41:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:41:28","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":["8429","RENT","\u9810\u7e73\u79df\u91d1",1,602,"MO","1",602,"2","2020-06-10 17:41:28","2","2020-06-10 17:41:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:41:28","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":["8429","RENT","\u9810\u7e73\u79df\u91d1",2,602,"MO","1",602,"2","2020-06-10 17:41:28","2","2020-06-10 17:41:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:41:28","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":["8429","RENT","\u9810\u7e73\u79df\u91d1",3,602,"MO","1",602,"2","2020-06-10 17:41:28","2","2020-06-10 17:41:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:41:28","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":["8429","RENT","\u9810\u7e73\u79df\u91d1",4,602,"MO","1",602,"2","2020-06-10 17:41:28","2","2020-06-10 17:41:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:41:28","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":["8429","RENT","\u9810\u7e73\u79df\u91d1",5,602,"MO","1",602,"2","2020-06-10 17:41:28","2","2020-06-10 17:41:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:41:28","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":["8429","RENT","\u9810\u7e73\u79df\u91d1",6,602,"MO","1",602,"2","2020-06-10 17:41:28","2","2020-06-10 17:41:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:41:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3612,0,"8429"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-10 17:41:28","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":[1286,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P208072","2020-06-10 17:41:28",3612,"2","2020-06-10 17:41:28","2","2020-06-10 17:41:28","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:41:28","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":["8072","DEPOSIT",null,"PAID","2020-06-10 17:41:28",0,"2","2020-06-10 17:41:28","2","2020-06-10 17:41:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:41:28","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":["8072","INVOICE","8429","PAID","2020-06-10 17:41:28",3612,"2","2020-06-10 17:41:28","2","2020-06-10 17:41:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:42:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 17:47:53","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,58166","6 months contract. Storage rental paid by EPS on JUNE 10. Storage deposit $1196 transferred from agreement A16-CT196674 to this agreement. ","2020-06-10 17:47:53","2","2+HhFlKBGl3L\/0uDqNi5+g==","\/vSa70zhic2PBI3\/SYA9hg==","RCAA9oqQn4aU7kXNIDRBSoB0gExzyePtfqGgJHtCC\/g=","eK+vnDTqwMWXbLLlPuYW9Q==","90hiaCa3Ox\/aQSXnM\/CKz2KFaqLAzp+M6PDFO7O4QJBYbbOMkB00wKM1iR2tXveP",8100]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 18:02:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 18:13: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":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":310,"customer_code":"C170310","identity_type":"PERSONAL","identity_id":"A895188(0)","title":"Mr","lastname":"Lo","firstname":"Yau Shing","companyname":"","email":null,"tel":"98888080","address":"Unit G, 10\/F, Tower 2, The Tanner Hill, 8 Tanner Road, North Point, 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":"13","renew_warehousing_date":"2020-06-19","renew_room_key":"052,43303","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by bank transfer on May 15, 2019. Storage deposit transferred from agreement A14-CT183712 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT194972, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"30","order_discount":[],"order_room":[{"room_id":"637","room_code":"M48","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":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":8376,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"698","warehousing_date":"2020-06-19","rent_from":"2020-06-19","rent_to":"2021-07-18","delivery_service":"0","remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by bank transfer on JUNE 10, 2020. Storage deposit transferred from agreement A14-CT194972 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":698,"order_total":9074,"final_order_total":8376,"location_id":"2","branch_id":"1","company_id":"1","room_key":"052,43303","order_product":[],"pass":true}},"first_order_id":"3712","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> M48 <\/td>\r\n\t\t\t\t\t 3X3X8 <\/td>\r\n\t\t\t\t\t $775.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"9","total_discounted_price":"698.0","deposit":"0","total_retail_price":"775.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 18:13: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","2",310,"NEW","A14-CT208101",775,698,0,0,"13","13",8376,9074,8376,"2020-06-10 18:13:10","0",null,null,null,"2020-06-19","2021-07-18","13 months contract. Special renewal offer, one month free. Storage rental paid by bank transfer on JUNE 10, 2020. Storage deposit transferred from agreement A14-CT194972 to this agreement.","2020-06-19","9",0,null,698,"698","2","2020-06-10 18:13:09","2","2020-06-10 18:13:09","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,43303","C170310","PERSONAL","Mr","MJBZLbrpqh3TT1VrfF137w==","4w4biS+jM\/Q3DAzxHdf3pA==","","WpEiEaYtmccC0nYeGH2fs679aQz+I4ClG20E6\/t8hNNhIpAK6Tqdm5sLdfu6LaCX+Wg8pg1viohqKjNIGMzdG5WxR2wfcCxK7odC2AAKr8k=","nKIBk++ZEDPq15SH7LqGkw==",null,"HxeWBAxsIAJvky0opG6+fA==",null,1,"3712"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 18:13: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":["8101","637","775.0","775.00","2","2020-06-10 18:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 18:13: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-06-19","2021-07-18","637"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-10 18:13: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":["8101",310,"SETTLED","A14-I208430","2020-06-10 18:13:09","2020-06-19","2","2020-06-10 18:13:09","2","2020-06-10 18:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 18:13: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":["8430","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,698,"MO","1",698,"2","2020-06-10 18:13:09","2","2020-06-10 18:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 18:13: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":["8430","RENT","\u9810\u7e73\u79df\u91d1",3,698,"MO","1",698,"2","2020-06-10 18:13:09","2","2020-06-10 18:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 18:13: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":["8430","RENT","\u9810\u7e73\u79df\u91d1",4,698,"MO","1",698,"2","2020-06-10 18:13:09","2","2020-06-10 18:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 18:13: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":["8430","RENT","\u9810\u7e73\u79df\u91d1",5,698,"MO","1",698,"2","2020-06-10 18:13:09","2","2020-06-10 18:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 18:13: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":["8430","RENT","\u9810\u7e73\u79df\u91d1",6,698,"MO","1",698,"2","2020-06-10 18:13:09","2","2020-06-10 18:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 18:13: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":["8430","RENT","\u9810\u7e73\u79df\u91d1",7,698,"MO","1",698,"2","2020-06-10 18:13:09","2","2020-06-10 18:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 18:13: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":["8430","RENT","\u9810\u7e73\u79df\u91d1",8,698,"MO","1",698,"2","2020-06-10 18:13:09","2","2020-06-10 18:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 18:13: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":["8430","RENT","\u9810\u7e73\u79df\u91d1",9,698,"MO","1",698,"2","2020-06-10 18:13:09","2","2020-06-10 18:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 18:13: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":["8430","RENT","\u9810\u7e73\u79df\u91d1",10,698,"MO","1",698,"2","2020-06-10 18:13:09","2","2020-06-10 18:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 18:13: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":["8430","RENT","\u9810\u7e73\u79df\u91d1",11,698,"MO","1",698,"2","2020-06-10 18:13:09","2","2020-06-10 18:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 18:13: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":["8430","RENT","\u9810\u7e73\u79df\u91d1",12,698,"MO","1",698,"2","2020-06-10 18:13:09","2","2020-06-10 18:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 18:13: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":["8430","RENT","\u9810\u7e73\u79df\u91d1",13,698,"MO","1",698,"2","2020-06-10 18:13:09","2","2020-06-10 18:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 18:13:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8376,0,"8430"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-10 18:13: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":[310,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208073","2020-06-10 18:13:09",8376,"2","2020-06-10 18:13:09","2","2020-06-10 18:13:09","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 18:13: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":["8073","DEPOSIT",null,"PAID","2020-06-10 18:13:09",0,"2","2020-06-10 18:13:09","2","2020-06-10 18:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 18:13: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":["8073","INVOICE","8430","PAID","2020-06-10 18:13:09",8376,"2","2020-06-10 18:13:09","2","2020-06-10 18:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 18:40:01","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 18:40:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 18:45:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 19:23:28","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":["VOID","053,63642","1 month contract. Storage rental paid by PPS on JUNE 10, 2020. Storage deposit transferred from agreement A12-CT208088 to this agreement.","2020-06-10 19:23:28","2","5c4M0ZQmSIw3LaJy30yaLQ==","KkrSDrQ1H2C7AHMXanK04g==","2yv4BPlbG\/\/YEJETfEEfNB1ddarjnzyQnu7bGnobgMM=","G4ql4s\/qkLFXwmJNbU6cdQ==","VydP8q4rzuZV5xu3JM4S94+vjANpX0mSGFwOYMOB853mNnGiX4hnOAOtYB32IPMF",8092]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 19:24:20","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":[null,"053,63642","1 month contract. Storage rental paid by PPS on JUNE 10, 2020. Storage deposit transferred from agreement A12-CT208088 to this agreement.","2020-06-10 19:24:20","2","5c4M0ZQmSIw3LaJy30yaLQ==","KkrSDrQ1H2C7AHMXanK04g==","2yv4BPlbG\/\/YEJETfEEfNB1ddarjnzyQnu7bGnobgMM=","G4ql4s\/qkLFXwmJNbU6cdQ==","VydP8q4rzuZV5xu3JM4S94+vjANpX0mSGFwOYMOB853mNnGiX4hnOAOtYB32IPMF",8092]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 19:25:33","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":["VOID","053,63642","1 month contract. Storage rental paid by PPS on JUNE 10, 2020. Storage deposit transferred from agreement A12-CT208088 to this agreement.","2020-06-10 19:25:33","2","5c4M0ZQmSIw3LaJy30yaLQ==","KkrSDrQ1H2C7AHMXanK04g==","2yv4BPlbG\/\/YEJETfEEfNB1ddarjnzyQnu7bGnobgMM=","G4ql4s\/qkLFXwmJNbU6cdQ==","VydP8q4rzuZV5xu3JM4S94+vjANpX0mSGFwOYMOB853mNnGiX4hnOAOtYB32IPMF",8092]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-10 19:25:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****