\n \n \n\t\t\t\t\t

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

\u5009\u5eab\u7de8\u865f<\/td>\n	\u5c3a\u5bf8<\/td>\n	\u539f\u50f9(\u6708)<\/td>\n	\u512a\u60e0\u50f9(\u6708)<\/td>\n	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n	\u50f9\u683c<\/td>\n	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n	<\/td>\n <\/tr>
A16-009 <\/td>\n\t\t\t\t\t	5X3X3.5 <\/td>\n\t\t\t\t\t	$738.00 <\/td>\n\t\t\t\t	- <\/td>	<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"15","total_discounted_price":"665.00","deposit":"1476.00","total_retail_price":"738.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 11:12:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201673","PERSONAL","Ms","Au4qzkeDfyuYATni4b4E0w==","8BEgNhGpCR8jGkzUtrIcXg==","","bLfTXhbf3KLAPG1CGfeXJg==","uEKtfpWnTu9R7YNfyFajoNGpGzy5z3qTtYQVoe79Mvw=","IR9YtD2ZsHXyOjmRRsun4zk88sKfvF3k9UUZ3V7SRnDSzi5K4XIB0IY1CWrCGP5J","YsU9nknD\/HkiP8pQVQgOxA==",null,"uEKtfpWnTu9R7YNfyFajoNGpGzy5z3qTtYQVoe79Mvw=","S985U14TRdm17GTDzlxSCA==","2","2020-07-15 11:12:55","2","2020-07-15 11:12:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 11:12:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7",1673,"NEW","A16-CT208399",738,665,1476,0,"12","12",9060,9456,9060,"2020-07-15 11:12:57","0",null,null,null,"2020-07-20","2021-07-19","12 mths contract. special offer 5% off rent now discount. storage rental and deposit paid by EPS on 2020-7-15. Smart card and pad lock provided on 2020-7-15","2020-07-20","15",0,null,396,"396.00","2","2020-07-15 11:12:55","2","2020-07-15 11:12:55","EPS","","","","EPS","","","",null,0,"190,01134","C201673","PERSONAL","Ms","Au4qzkeDfyuYATni4b4E0w==","8BEgNhGpCR8jGkzUtrIcXg==","","IR9YtD2ZsHXyOjmRRsun4zk88sKfvF3k9UUZ3V7SRnDSzi5K4XIB0IY1CWrCGP5J","bLfTXhbf3KLAPG1CGfeXJg==","uEKtfpWnTu9R7YNfyFajoNGpGzy5z3qTtYQVoe79Mvw=","YsU9nknD\/HkiP8pQVQgOxA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 11:12:57","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":["8399","1500","738.0","738.00","2","2020-07-15 11:12:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 11:12:57","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-07-20","2021-07-19","1500"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-15 11:12:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["8399","A16-D205546","PAID",1476,0,"2021-07-19","2020-07-15 11:12:55","2020-07-15 11:12:55","2","2020-07-15 11:12:55","2","2020-07-15 11:12:55",1673]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 11:12:57","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":["8399",1673,"SETTLED","A16-I208728","2020-07-15 11:12:55","2020-07-20","2","2020-07-15 11:12:55","2","2020-07-15 11:12:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 11:12:57","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":["8728","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,269,"MO","1",269,"2","2020-07-15 11:12:55","2","2020-07-15 11:12:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 11:12:57","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":["8728","RENT","\u9810\u7e73\u79df\u91d1",2,665,"MO","1",665,"2","2020-07-15 11:12:55","2","2020-07-15 11:12:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 11:12:57","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":["8728","RENT","\u9810\u7e73\u79df\u91d1",3,665,"MO","1",665,"2","2020-07-15 11:12:55","2","2020-07-15 11:12:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 11:12:57","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":["8728","RENT","\u9810\u7e73\u79df\u91d1",4,665,"MO","1",665,"2","2020-07-15 11:12:55","2","2020-07-15 11:12:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 11:12:57","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":["8728","RENT","\u9810\u7e73\u79df\u91d1",5,665,"MO","1",665,"2","2020-07-15 11:12:55","2","2020-07-15 11:12:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 11:12:57","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":["8728","RENT","\u9810\u7e73\u79df\u91d1",6,665,"MO","1",665,"2","2020-07-15 11:12:55","2","2020-07-15 11:12:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 11:12:57","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":["8728","RENT","\u9810\u7e73\u79df\u91d1",7,665,"MO","1",665,"2","2020-07-15 11:12:55","2","2020-07-15 11:12:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 11:12:57","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":["8728","RENT","\u9810\u7e73\u79df\u91d1",8,665,"MO","1",665,"2","2020-07-15 11:12:55","2","2020-07-15 11:12:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 11:12:57","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":["8728","RENT","\u9810\u7e73\u79df\u91d1",9,665,"MO","1",665,"2","2020-07-15 11:12:55","2","2020-07-15 11:12:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 11:12:57","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":["8728","RENT","\u9810\u7e73\u79df\u91d1",10,665,"MO","1",665,"2","2020-07-15 11:12:55","2","2020-07-15 11:12:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 11:12:57","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":["8728","RENT","\u9810\u7e73\u79df\u91d1",11,665,"MO","1",665,"2","2020-07-15 11:12:55","2","2020-07-15 11:12:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 11:12:57","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":["8728","RENT","\u9810\u7e73\u79df\u91d1",12,665,"MO","1",665,"2","2020-07-15 11:12:55","2","2020-07-15 11:12:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 11:12:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7584,0,"8728"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-15 11:12:57","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":[1673,"EPS","","","","EPS","","","","PAID","P208371","2020-07-15 11:12:55",9060,"2","2020-07-15 11:12:55","2","2020-07-15 11:12:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 11:12:57","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":["8371","DEPOSIT","5546","PAID","2020-07-15 11:12:55",1476,"2","2020-07-15 11:12:55","2","2020-07-15 11:12:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 11:12:57","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":["8371","INVOICE","8728","PAID","2020-07-15 11:12:55",7584,"2","2020-07-15 11:12:55","2","2020-07-15 11:12:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 11:19:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 11:25:28","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 11:31:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 11:44:06","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 12:05: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":"page=3&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1648","master_room_id":"210","room_code":"A16-157"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":823,"customer_code":"C180823","identity_type":"BUSINESS","identity_id":"39661261","title":"Mr","lastname":"Milan Martinez","firstname":"Alejandro","companyname":"La Nao Group Limited","email":"a.milan@la-nao.com","tel":"90212010","address":"13A, Trust Tower, 68 Johnston Road, Wanchai, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2318.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-13","renew_room_key":"055,09251","renew_remark":"1 month contract. Storage rental paid by bank transfer on June 16, 2020. Storage deposit transferred from agreement A14-CT207853 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT208157, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"794","room_code":"K60","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"515","room_code":"K52","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":2318,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2318,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-13","rent_from":"2020-06-13","rent_to":"2020-07-12","delivery_service":"0","remark":"1 month contract. Storage rental paid by quick cheque deposit on Jul 14, 2020. Storage deposit transferred from agreement A14-CT208157 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":2318,"final_order_total":2318,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,09251","order_product":[],"pass":true}},"first_order_id":"4785","selected_room_tr":"	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\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 \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> K60 <\/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> K52 <\/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":"32","total_discounted_price":"2318.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 12:05: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",823,"NEW","A14-CT208400",2196,2318,0,0,"1","1",2318,2318,2318,"2020-07-15 12:05:06","0",null,null,null,"2020-06-13","2020-07-12","1 month contract. Storage rental paid by quick cheque deposit on Jul 14, 2020. Storage deposit transferred from agreement A14-CT208157 to this agreement.\r\n","2020-06-13","32",0,null,0,"0","2","2020-07-15 12:05:06","2","2020-07-15 12:05:06","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"055,09251","C180823","BUSINESS","Mr","Ltuw0GNYtUHvg5xq\/qUHZw==","B0t4iVfZVAQdLpfngFJQ9g==","La Nao Group Limited","ogXiJSz6bxnQX1arPQzS4HtoujvXU7DtPI6iXMqgmibwYxgUDD+7IDSdp7zHKT1WsucqNnxkVRDDkoVXniYCDA==","oMTdQIHVXIpTgMmFZOwTlA==","toRvij1IyfmFV4d7mZnp4cg+UZM6Nv9c2C6kHmvTa8c=",null,"mWmgEjucdLaH5rglf7tExg==",1,"4785"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 12:05: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":["8400","794","1098.0","1098.00","2","2020-07-15 12:05:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 12:05: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-06-13","2020-07-12","794"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-15 12:05: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":["8400","515","1098.0","1098.00","2","2020-07-15 12:05:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 12:05: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-06-13","2020-07-12","515"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-15 12:05: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":["8400",823,"SETTLED","A14-I208729","2020-07-15 12:05:06","2020-06-13","2","2020-07-15 12:05:06","2","2020-07-15 12:05:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 12:05: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":["8729","RENT","\u9810\u7e73\u79df\u91d1",1,2318,"MO","1",2318,"2","2020-07-15 12:05:06","2","2020-07-15 12:05:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 12:05:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2318,0,"8729"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-15 12:05: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":[823,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P208372","2020-07-15 12:05:06",2318,"2","2020-07-15 12:05:06","2","2020-07-15 12:05:06","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 12:05: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":["8372","DEPOSIT",null,"PAID","2020-07-15 12:05:06",0,"2","2020-07-15 12:05:06","2","2020-07-15 12:05:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 12:05: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":["8372","INVOICE","8729","PAID","2020-07-15 12:05:06",2318,"2","2020-07-15 12:05:06","2","2020-07-15 12:05:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 12:06:43","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","0005796877","1 month contract. Storage rental paid by PPS on June 30, 2020. Storage deposit $2230 transferred from agreement C15-CT208024 to this agreement. \r\n","2020-07-15 12:06:43","2","UCPBCXrBLI9U7KKsPqgmNA==","pyScVxHN1bAPGGa\/Bucd1Q==","IK6uRSfHgYDvM30SfvOBrVdAXD9E++uXhp1WOnqnMIk=","ODUJ\/sh5I9t4EANm7+m4qQ==","LoTfAY\/7hsJ5LMg1lxRl5U61+y\/bHOn3mXXs4ZtLiTsKgr3U0XtRwxPFeprq+NiHAM+QrB+m5+WZ7R14dzMxe+z0ciqodfk7L3bAksKmsSI=",8353]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 12:07:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 12:32:31","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 12:47:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 12:47:39","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=2&filter2=1008&filter3=undefined","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1457","master_room_id":"184","room_code":"C15-151"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\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> C15-151 <\/td>\r\n\t\t\t\t\t 5X8X6.5 <\/td>\r\n\t\t\t\t\t $2168.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","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"K700926(7)","title":"Ms","lastname":"Cheng","firstname":"King","companyname":"","email":"dumpling_jing@hotmail.com","tel":"90989956","address":"FT F 60\/F Tower 2 , 38 Tai Hong Street, Grand Promenade , Sai Wan Ho, Hong Kong","pass":true,"customer_id":"1008","customer_code":"C181008","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1457","room_code":"C15-151","retail_price":"2168.0","discounted_price":"2168.00","location_id":"6"}],"roughly_size":"40","total_retail_price":2168,"total_discounted_price":2168,"deposit":2168,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2106,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2230.00","warehousing_date":"2020-07-10","rent_from":"2020-07-10","rent_to":"2020-08-09","delivery_service":"0","remark":"1 month contract. Change from unit C15-102. Deposit of C15-102 $2230 transferred from C15-CT208024 to this agreement. The balance of storage rental $2106 paid by PPS on June 18($500), June 30($1115), Jul 14($491), 2020.\r\n","paymethod":"PPS","paymethod2":"PPS","discount_deduct":2230,"order_total":4336,"final_order_total":2106,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0005796877","order_product":[],"pass":true}},"roughly_size":"40","total_discounted_price":"2168.00","deposit":"2168.00","total_retail_price":"2168.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 12:47:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","3","6","1008","NEW","C15-CT208401",2168,2168,2168,0,"1","1",2106,4336,2106,"2020-07-15 12:47:39","0",null,null,null,"2020-07-10","2020-08-09","1 month contract. Change from unit C15-102. Deposit of C15-102 $2230 transferred from C15-CT208024 to this agreement. The balance of storage rental $2106 paid by PPS on June 18($500), June 30($1115), Jul 14($491), 2020.\r\n","2020-07-10","40",0,null,2230,"2230.00","2","2020-07-15 12:47:39","2","2020-07-15 12:47:39","PPS","","","","PPS","","","",null,0,"0005796877","C181008","PERSONAL","Ms","pyScVxHN1bAPGGa\/Bucd1Q==","UCPBCXrBLI9U7KKsPqgmNA==","","LoTfAY\/7hsJ5LMg1lxRl5U61+y\/bHOn3mXXs4ZtLiTsKgr3U0XtRwxPFeprq+NiHAM+QrB+m5+WZ7R14dzMxe+z0ciqodfk7L3bAksKmsSI=","ODUJ\/sh5I9t4EANm7+m4qQ==","IK6uRSfHgYDvM30SfvOBrVdAXD9E++uXhp1WOnqnMIk=","0n\/HYQ\/ulfaXU7JBtiiVDg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 12:47:39","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":["8401","1457","2168.0","2168.00","2","2020-07-15 12:47:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 12:47:39","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-07-10","2020-08-09","1457"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-15 12:47:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["8401","C15-D205547","PAID",2168,0,"2020-08-09","2020-07-15 12:47:39","2020-07-15 12:47:39","2","2020-07-15 12:47:39","2","2020-07-15 12:47:39","1008"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 12:47:39","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":["8401","1008","SETTLED","C15-I208730","2020-07-15 12:47:39","2020-07-10","2","2020-07-15 12:47:39","2","2020-07-15 12:47:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 12:47:39","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":["8730","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-07-15 12:47:39","2","2020-07-15 12:47:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 12:47:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[0,0,"8730"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-15 12:47:39","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":["1008","PPS","","","","PPS","","","","PAID","P208373","2020-07-15 12:47:39",2168,"2","2020-07-15 12:47:39","2","2020-07-15 12:47:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 12:47:39","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":["8373","DEPOSIT","5547","PAID","2020-07-15 12:47:39",2168,"2","2020-07-15 12:47:39","2","2020-07-15 12:47:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 12:47:39","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":["8373","INVOICE","8730","PAID","2020-07-15 12:47:39",0,"2","2020-07-15 12:47:39","2","2020-07-15 12:47:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 12:49:01","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","'0005796877","1 month contract. Change from unit C15-102. Deposit of C15-102 $2230 transferred from C15-CT208024 to this agreement. The balance of storage rental $2106 paid by PPS on June 18($500), June 30($1115), Jul 14($491), 2020.\r\n","2020-07-15 12:49:01","2","UCPBCXrBLI9U7KKsPqgmNA==","pyScVxHN1bAPGGa\/Bucd1Q==","IK6uRSfHgYDvM30SfvOBrVdAXD9E++uXhp1WOnqnMIk=","ODUJ\/sh5I9t4EANm7+m4qQ==","LoTfAY\/7hsJ5LMg1lxRl5U61+y\/bHOn3mXXs4ZtLiTsKgr3U0XtRwxPFeprq+NiHAM+QrB+m5+WZ7R14dzMxe+z0ciqodfk7L3bAksKmsSI=",8401]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 14:14:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 14:33:48","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=2&filter2=1008&filter3=undefined","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1457","master_room_id":"184","room_code":"C15-151"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":134,"customer_code":"C160134","identity_type":"PERSONAL","identity_id":"D005655(4)","title":"Mr","lastname":"Wong ","firstname":"Kam Sum","companyname":"","email":null,"tel":"91401401","address":"Flat D, 8\/F, Block 13, Fu Sing Yuen, Chi Fu Fa Yuen","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"6","renew_warehousing_date":"2020-07-21","renew_room_key":"032,25724","renew_remark":"6 months contract. Storage rental paid by bank transfer on January 13, 2019. Storage deposit $1856 transferred from agreement A12-CT194158 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207233, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"20","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"20","room_code":"A20","retail_price":"1098.0","discounted_price":989,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":935,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5610,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-21","rent_from":"2020-07-21","rent_to":"2021-01-20","delivery_service":"0","remark":"6 months contract. Storage rental paid by EPS on Jul 15, 2020. Storage deposit $1856 transferred from agreement A12-CT207233 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":5610,"final_order_total":5610,"location_id":"1","branch_id":"1","company_id":"1","room_key":"032,25724","order_product":[],"pass":true}},"first_order_id":"4158","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> A20 <\/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\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":"16","total_discounted_price":"935.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 14:33: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","1",134,"NEW","A12-CT208402",1098,935,0,0,"6","6",5610,5610,5610,"2020-07-15 14:33:49","0",null,null,null,"2020-07-21","2021-01-20","6 months contract. Storage rental paid by EPS on Jul 15, 2020. Storage deposit $1856 transferred from agreement A12-CT207233 to this agreement.\r\n","2020-07-21","16",0,null,0,"0","2","2020-07-15 14:33:48","2","2020-07-15 14:33:48","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"032,25724","C160134","PERSONAL","Mr","aeGPRhIEz9Q9mUB5bKVQLw==","DgLsCGM4faTvgwjKBW9M0A==","","y87W+Je\/7Xy7HtoJBBGIc+FLiJwqu6rid4JSQDiW0H5g4LSOg2lqZK\/Pa32DKOrAGCLN6BO6jr0h0fdtC3htyA==","vMbqI8hQDW3P3YwJBH4X0A==",null,"dmPQovU\/4QHoIQmGg20+dQ==",null,1,"4158"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 14:33: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":["8402","72","8","20","%","9.93",109.0314,"2","2020-07-15 14:33:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 14:33: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":["8402","20","1098.0",989,"2","2020-07-15 14:33:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 14:33: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-07-21","2021-01-20","20"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-15 14:33: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":["8402",134,"SETTLED","A12-I208731","2020-07-15 14:33:48","2020-07-21","2","2020-07-15 14:33:48","2","2020-07-15 14:33:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 14:33: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":["8731","RENT","\u9810\u7e73\u79df\u91d1",1,935,"MO","1",935,"2","2020-07-15 14:33:48","2","2020-07-15 14:33:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 14:33: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":["8731","RENT","\u9810\u7e73\u79df\u91d1",2,935,"MO","1",935,"2","2020-07-15 14:33:48","2","2020-07-15 14:33:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 14:33: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":["8731","RENT","\u9810\u7e73\u79df\u91d1",3,935,"MO","1",935,"2","2020-07-15 14:33:48","2","2020-07-15 14:33:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 14:33: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":["8731","RENT","\u9810\u7e73\u79df\u91d1",4,935,"MO","1",935,"2","2020-07-15 14:33:48","2","2020-07-15 14:33:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 14:33: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":["8731","RENT","\u9810\u7e73\u79df\u91d1",5,935,"MO","1",935,"2","2020-07-15 14:33:48","2","2020-07-15 14:33:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 14:33: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":["8731","RENT","\u9810\u7e73\u79df\u91d1",6,935,"MO","1",935,"2","2020-07-15 14:33:48","2","2020-07-15 14:33:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 14:33:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5610,0,"8731"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-15 14:33: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":[134,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P208374","2020-07-15 14:33:48",5610,"2","2020-07-15 14:33:48","2","2020-07-15 14:33:48","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 14:33: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":["8374","DEPOSIT",null,"PAID","2020-07-15 14:33:48",0,"2","2020-07-15 14:33:48","2","2020-07-15 14:33:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 14:33: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":["8374","INVOICE","8731","PAID","2020-07-15 14:33:48",5610,"2","2020-07-15 14:33:48","2","2020-07-15 14:33:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 14:52:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 14:53:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 15:04:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 16:04:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 16:21:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 16:22:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 16:22:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 17:12:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 17:34:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 17:50:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 18:08:35","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 18:16:11","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 18:18:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 18:18:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 18:18:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 18:20:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 18:39:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 18:57:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 19:11:12","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":574,"customer_code":"C170574","identity_type":"BUSINESS","identity_id":"67544417-000","title":"Ms","lastname":"Kwok","firstname":"Yuet Wah Albertina","companyname":"Boba Cafe 128","email":"tinaywk33@hotmail.com","tel":"66871716","address":"G\/F, Shop 1, 128 Ap Lei Chau Main Road, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-03","renew_room_key":"055,07586","renew_remark":"1 month contract. Storage rental paid by bank transfer on June 5, 2020. Storage deposit transferred from agreement A12-CT207681 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT208072, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"144","room_code":"C20","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-03","rent_from":"2020-06-03","rent_to":"2020-07-02","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Jul 13, 2020. Storage deposit transferred from agreement A12-CT208072 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,07586","order_product":[],"pass":true}},"first_order_id":"4722","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> C20 <\/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\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":"16","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 19:11:13","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",574,"NEW","A12-CT208403",1098,1038,0,0,"1","1",1038,1038,1038,"2020-07-15 19:11:13","0",null,null,null,"2020-06-03","2020-07-02","1 month contract. Storage rental paid by bank transfer on Jul 13, 2020. Storage deposit transferred from agreement A12-CT208072 to this agreement.","2020-06-03","16",0,null,0,"0","2","2020-07-15 19:11:12","2","2020-07-15 19:11:12","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,07586","C170574","BUSINESS","Ms","A+uRj8p7tDqEbQijhd95GjDFnFB7Op1AqPZ9q\/ChjGU=","+pNULpsInm3siHASV0hIrg==","Boba Cafe 128","Isk4kzOjkF6xeDXceSf25KVcGBgp\/FxQCSbLWl0WDEisZ9I5jVSpGA0hu4eHP+cqW9lXYIwIK1KYgWa8VI8QkA==","cqSYrPZcLGU6olheKS6TwQ==","HyiE2BUsNgIyg65jh\/6C9e6snrjutNDWNVbS\/MDm\/20=",null,"O33I8t0JzOwsECFDTsBzRw==",1,"4722"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 19:11:13","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":["8403","144","1098.0","1098.00","2","2020-07-15 19:11:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 19:11:13","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-03","2020-07-02","144"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-15 19:11:13","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":["8403",574,"SETTLED","A12-I208732","2020-07-15 19:11:12","2020-06-03","2","2020-07-15 19:11:12","2","2020-07-15 19:11:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 19:11:13","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":["8732","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-07-15 19:11:12","2","2020-07-15 19:11:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 19:11:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"8732"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-15 19:11:13","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":[574,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208375","2020-07-15 19:11:12",1038,"2","2020-07-15 19:11:12","2","2020-07-15 19:11:12","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 19:11:13","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":["8375","DEPOSIT",null,"PAID","2020-07-15 19:11:12",0,"2","2020-07-15 19:11:12","2","2020-07-15 19:11:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-15 19:11:13","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":["8375","INVOICE","8732","PAID","2020-07-15 19:11:12",1038,"2","2020-07-15 19:11:12","2","2020-07-15 19:11:12"]},"data_before":[],"data_after":[],"step":1} *****