\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-082 <\/td>\n\t\t\t\t\t	4X4X7 <\/td>\n\t\t\t\t\t	$1410.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":"16","total_discounted_price":"1269.00","deposit":"2820.00","total_retail_price":"1410.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:31: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` = ?","parameters":["1","1","7","738","NEW","A16-CT208318",1410,1269,2820,0,"13","13",17560,19317,17560,"2020-07-07 11:31:41","0",null,null,null,"2020-06-13","2021-07-12","13 months contract. Special offer the 13th month free. Changed unit from V03. Remaining balance $488 of V03 transferred from agreement A18-CT207171 to this agreement. The balance of storage rental and deposit of A16-182 (ttl: $17560) paid by bank transfer on Jul 06,2020.","2020-06-13","16",0,null,1757,"1757.00","2","2020-07-07 11:31:41","2","2020-07-07 11:31:41","BANKIN","","","","BANKIN","","","",null,0,"054,51120","C180738","PERSONAL","Ms","gP+\/\/W1SrQ5dYoeYqP1XvBM5lUEGOXL7DWT5DWpBfmc=","F5uIWSqx2McFcjiJ4bOqSw==","","2aYIPOH64af129RFwpNAYJaJjDU0wf2ZJI82wUXQra+IyIVJtlTju5M9iX5uEqcS","qMor+Bb0pdvymUPd2LXZ2g==","rgb96oX9vs4yMRU5SzBqe6TCC9M4Jqk+Oum8jFU\/RHM=","88Qgd5mbsLJBerPLGXWCGg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:31: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":["8318","1573","1410.0","1410.00","2","2020-07-07 11:31:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:31: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-06-13","2021-07-12","1573"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-07 11:31:41","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":["8318","A16-D205529","PAID",2820,0,"2021-07-12","2020-07-07 11:31:41","2020-07-07 11:31:41","2","2020-07-07 11:31:41","2","2020-07-07 11:31:41","738"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:31: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":["8318","738","SETTLED","A16-I208647","2020-07-07 11:31:41","2020-06-13","2","2020-07-07 11:31:41","2","2020-07-07 11:31:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:31: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":["8647","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-07-07 11:31:41","2","2020-07-07 11:31:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:31: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":["8647","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,781,"MO","1",781,"2","2020-07-07 11:31:41","2","2020-07-07 11:31:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:31: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":["8647","RENT","\u9810\u7e73\u79df\u91d1",3,1269,"MO","1",1269,"2","2020-07-07 11:31:41","2","2020-07-07 11:31:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:31: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":["8647","RENT","\u9810\u7e73\u79df\u91d1",4,1269,"MO","1",1269,"2","2020-07-07 11:31:41","2","2020-07-07 11:31:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:31: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":["8647","RENT","\u9810\u7e73\u79df\u91d1",5,1269,"MO","1",1269,"2","2020-07-07 11:31:41","2","2020-07-07 11:31:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:31: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":["8647","RENT","\u9810\u7e73\u79df\u91d1",6,1269,"MO","1",1269,"2","2020-07-07 11:31:41","2","2020-07-07 11:31:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:31: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":["8647","RENT","\u9810\u7e73\u79df\u91d1",7,1269,"MO","1",1269,"2","2020-07-07 11:31:41","2","2020-07-07 11:31:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:31: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":["8647","RENT","\u9810\u7e73\u79df\u91d1",8,1269,"MO","1",1269,"2","2020-07-07 11:31:41","2","2020-07-07 11:31:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:31: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":["8647","RENT","\u9810\u7e73\u79df\u91d1",9,1269,"MO","1",1269,"2","2020-07-07 11:31:41","2","2020-07-07 11:31:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:31: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":["8647","RENT","\u9810\u7e73\u79df\u91d1",10,1269,"MO","1",1269,"2","2020-07-07 11:31:41","2","2020-07-07 11:31:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:31: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":["8647","RENT","\u9810\u7e73\u79df\u91d1",11,1269,"MO","1",1269,"2","2020-07-07 11:31:41","2","2020-07-07 11:31:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:31: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":["8647","RENT","\u9810\u7e73\u79df\u91d1",12,1269,"MO","1",1269,"2","2020-07-07 11:31:41","2","2020-07-07 11:31:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:31: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":["8647","RENT","\u9810\u7e73\u79df\u91d1",13,1269,"MO","1",1269,"2","2020-07-07 11:31:41","2","2020-07-07 11:31:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:31:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[14740,0,"8647"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-07 11:31: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":["738","BANKIN","","","","BANKIN","","","","PAID","P208290","2020-07-07 11:31:41",17560,"2","2020-07-07 11:31:41","2","2020-07-07 11:31:41","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:31: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":["8290","DEPOSIT","5529","PAID","2020-07-07 11:31:41",2820,"2","2020-07-07 11:31:41","2","2020-07-07 11:31:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:31: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":["8290","INVOICE","8647","PAID","2020-07-07 11:31:41",14740,"2","2020-07-07 11:31:41","2","2020-07-07 11:31:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:43:21","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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"M781982(5)","title":"Ms","lastname":"CASTETS","firstname":"Leonica Clare","companyname":"","email":"nicaclarecastets@gmail.com","tel":"60318251","address":"Flat B, 35\/F, Lun Fung Court, 363 Des Voeux Road, West Shek Tong Tsui, HK Island","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1688","room_code":"A16-197","retail_price":"3852.0","discounted_price":"3852.00","location_id":"7"}],"roughly_size":"48","total_retail_price":3852,"total_discounted_price":3467,"deposit":7704,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":26904,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1602.00","warehousing_date":"2020-07-13","rent_from":"2020-07-13","rent_to":"2021-01-12","delivery_service":"0","remark":"6 months contract. Special offer $3200\/month. $500 deposit paid by Alipay on Jul 06,2020. The balance of storage rental and deposit $26404 will pay by bank transfer. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":1602,"order_total":28506,"final_order_total":26904,"location_id":"7","branch_id":"1","company_id":"1","room_key":"189,12087","order_product":[],"pass":true}},"index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","selected_room_tr":"\n	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n	\n \n\n \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-197 <\/td>\n\t\t\t\t\t 8X6X7 <\/td>\n\t\t\t\t\t $3852.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":"48","total_discounted_price":"3467.00","deposit":"7704.00","total_retail_price":"3852.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:43:22","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":["C201660","PERSONAL","Ms","z4ycFjCbw87PCT9whZESww==","9gQIqoFLC6iUffjGlyHwgw==","","lhoAQ1LXBhrXJ5imHFlWiQ==","pPdW8BWkJuhqVi7qzBJrrccquog2zgkmpyUBqUt9Ggk=","ffcqxG2Ov+NctvEyTb6bGfHHAmydz3+sYmsY239bddZWsJ0rKbARtEE\/\/sA\/YUL4HnFSeauDszZZFOqgXh549\/oLZf2IQXISAPw2KfGNhjPRNDzu9EhroFf0a++Cqkqd","emJLzndNtSfuqGSExNsloA==",null,"pPdW8BWkJuhqVi7qzBJrrccquog2zgkmpyUBqUt9Ggk=","oDd8hFRvgCiKNnBRWGyvhg==","2","2020-07-07 11:43:21","2","2020-07-07 11:43:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:43: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` = ?","parameters":["1","1","7",1660,"NEW","A16-CT208319",3852,3467,7704,0,"6","6",26904,28506,26904,"2020-07-07 11:43:23","0",null,null,null,"2020-07-13","2021-01-12","6 months contract. Special offer $3200\/month. $500 deposit paid by Alipay on Jul 06,2020. The balance of storage rental and deposit $26404 will pay by bank transfer. ","2020-07-13","48",0,null,1602,"1602.00","2","2020-07-07 11:43:21","2","2020-07-07 11:43:21","BANKIN","","","","BANKIN","","","",null,0,"189,12087","C201660","PERSONAL","Ms","z4ycFjCbw87PCT9whZESww==","9gQIqoFLC6iUffjGlyHwgw==","","ffcqxG2Ov+NctvEyTb6bGfHHAmydz3+sYmsY239bddZWsJ0rKbARtEE\/\/sA\/YUL4HnFSeauDszZZFOqgXh549\/oLZf2IQXISAPw2KfGNhjPRNDzu9EhroFf0a++Cqkqd","lhoAQ1LXBhrXJ5imHFlWiQ==","pPdW8BWkJuhqVi7qzBJrrccquog2zgkmpyUBqUt9Ggk=","emJLzndNtSfuqGSExNsloA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:43: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":["8319","1688","3852.0","3852.00","2","2020-07-07 11:43:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:43: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-07-13","2021-01-12","1688"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-07 11:43:23","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":["8319","A16-D205530","PAID",7704,0,"2021-01-12","2020-07-07 11:43:21","2020-07-07 11:43:21","2","2020-07-07 11:43:21","2","2020-07-07 11:43:21",1660]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:43: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":["8319",1660,"SETTLED","A16-I208648","2020-07-07 11:43:21","2020-07-13","2","2020-07-07 11:43:21","2","2020-07-07 11:43:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:43: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":["8648","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,1865,"MO","1",1865,"2","2020-07-07 11:43:21","2","2020-07-07 11:43:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:43: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":["8648","RENT","\u9810\u7e73\u79df\u91d1",2,3467,"MO","1",3467,"2","2020-07-07 11:43:21","2","2020-07-07 11:43:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:43: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":["8648","RENT","\u9810\u7e73\u79df\u91d1",3,3467,"MO","1",3467,"2","2020-07-07 11:43:21","2","2020-07-07 11:43:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:43: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":["8648","RENT","\u9810\u7e73\u79df\u91d1",4,3467,"MO","1",3467,"2","2020-07-07 11:43:21","2","2020-07-07 11:43:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:43: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":["8648","RENT","\u9810\u7e73\u79df\u91d1",5,3467,"MO","1",3467,"2","2020-07-07 11:43:21","2","2020-07-07 11:43:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:43: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":["8648","RENT","\u9810\u7e73\u79df\u91d1",6,3467,"MO","1",3467,"2","2020-07-07 11:43:21","2","2020-07-07 11:43:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:43:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[19200,0,"8648"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-07 11:43: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":[1660,"BANKIN","","","","BANKIN","","","","PAID","P208291","2020-07-07 11:43:21",26904,"2","2020-07-07 11:43:21","2","2020-07-07 11:43:21","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:43: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":["8291","DEPOSIT","5530","PAID","2020-07-07 11:43:21",7704,"2","2020-07-07 11:43:21","2","2020-07-07 11:43:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:43: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":["8291","INVOICE","8648","PAID","2020-07-07 11:43:21",19200,"2","2020-07-07 11:43:21","2","2020-07-07 11:43:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:47:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:48:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:52: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":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1750","master_room_id":"232","room_code":"WC-19"}],"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> WC-19 <\/td>\r\n\t\t\t\t\t 2.5X2.5X4 <\/td>\r\n\t\t\t\t\t $798.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","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"M781982(5)","title":"Ms","lastname":"CASTETS","firstname":"Leonica Clare","companyname":"","email":"nicaclarecastets@gmail.com","tel":"60318251","address":"Flat B, 35\/F, Lun Fung Court, 363 Des Voeux Road, West Shek Tong Tsui, HK Island","pass":true,"customer_id":"1660","customer_code":"C201660","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1750","room_code":"WC-19","retail_price":"798.0","discounted_price":"798.00","location_id":"8"}],"roughly_size":"6.25","total_retail_price":798,"total_discounted_price":719,"deposit":1596,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5910,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-13","rent_from":"2020-07-13","rent_to":"2021-01-12","delivery_service":"0","remark":"6 months contract. Storage rental and deposit will be paid by bank transfer.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5910,"final_order_total":5910,"location_id":"8","branch_id":"1","company_id":"1","room_key":"189,12087","order_product":[],"pass":true}},"roughly_size":"6.25","total_discounted_price":"719.00","deposit":"1596.00","total_retail_price":"798.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:52: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` = ?","parameters":["1","1","8","1660","NEW","WC-CT208320",798,719,1596,0,"6","6",5910,5910,5910,"2020-07-07 11:52:49","0",null,null,null,"2020-07-13","2021-01-12","6 months contract. Storage rental and deposit will be paid by bank transfer.","2020-07-13","6.25",0,null,0,"0","2","2020-07-07 11:52:48","2","2020-07-07 11:52:48","BANKIN","","","","BANKIN","","","",null,0,"189,12087","C201660","PERSONAL","Ms","z4ycFjCbw87PCT9whZESww==","9gQIqoFLC6iUffjGlyHwgw==","","ffcqxG2Ov+NctvEyTb6bGfHHAmydz3+sYmsY239bddZWsJ0rKbARtEE\/\/sA\/YUL4HnFSeauDszZZFOqgXh549\/oLZf2IQXISAPw2KfGNhjPRNDzu9EhroFf0a++Cqkqd","lhoAQ1LXBhrXJ5imHFlWiQ==","pPdW8BWkJuhqVi7qzBJrrccquog2zgkmpyUBqUt9Ggk=","emJLzndNtSfuqGSExNsloA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:52: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":["8320","1750","798.0","798.00","2","2020-07-07 11:52:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:52: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-13","2021-01-12","1750"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-07 11:52:49","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":["8320","WC-D205531","PAID",1596,0,"2021-01-12","2020-07-07 11:52:48","2020-07-07 11:52:48","2","2020-07-07 11:52:48","2","2020-07-07 11:52:48","1660"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:52: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":["8320","1660","SETTLED","WC-I208649","2020-07-07 11:52:48","2020-07-13","2","2020-07-07 11:52:48","2","2020-07-07 11:52:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:52: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":["8649","RENT","\u9810\u7e73\u79df\u91d1",1,719,"MO","1",719,"2","2020-07-07 11:52:48","2","2020-07-07 11:52:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:52: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":["8649","RENT","\u9810\u7e73\u79df\u91d1",2,719,"MO","1",719,"2","2020-07-07 11:52:48","2","2020-07-07 11:52:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:52: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":["8649","RENT","\u9810\u7e73\u79df\u91d1",3,719,"MO","1",719,"2","2020-07-07 11:52:48","2","2020-07-07 11:52:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:52: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":["8649","RENT","\u9810\u7e73\u79df\u91d1",4,719,"MO","1",719,"2","2020-07-07 11:52:48","2","2020-07-07 11:52:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:52: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":["8649","RENT","\u9810\u7e73\u79df\u91d1",5,719,"MO","1",719,"2","2020-07-07 11:52:48","2","2020-07-07 11:52:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:52: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":["8649","RENT","\u9810\u7e73\u79df\u91d1",6,719,"MO","1",719,"2","2020-07-07 11:52:48","2","2020-07-07 11:52:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:52:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4314,0,"8649"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-07 11:52: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":["1660","BANKIN","","","","BANKIN","","","","PAID","P208292","2020-07-07 11:52:48",5910,"2","2020-07-07 11:52:48","2","2020-07-07 11:52:48","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:52: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":["8292","DEPOSIT","5531","PAID","2020-07-07 11:52:48",1596,"2","2020-07-07 11:52:48","2","2020-07-07 11:52:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 11:52: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":["8292","INVOICE","8649","PAID","2020-07-07 11:52:48",4314,"2","2020-07-07 11:52:48","2","2020-07-07 11:52:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 12:09:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 12:42:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:08: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","054,45426","6 months contract. Special offer $500 coupon. Storage rental paid by bank transfer on Jul 01, 2020. Storage deposit $4116 transferred from agreement A18-CT196798 to this agreement.","2020-07-07 13:08:33","2","Gx5wC5plnNkrLawNtCgpAA==","mzl9wJ\/hSEhLPzoiI6h6Zg==","xlNbTqyqiOnpFGCRI0oDYYLdYgJaoXlL\/aEXLgLIm2E=","wYbP0yGhFCXVgrI69fweHw==","QSN9WoJ9HAqQmHqFLp+5omeZP9\/Zep834Gc0bVH0YIcNuUxGnWi98jx1KNX3AiIE",8315]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:12:18","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[],"index_url_parameter":"filter1=2&filter2=662&filter3=undefined","_payment_type":"INVOICE","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"K086615(6)","title":"Ms","lastname":"Yung","firstname":"Chi Han","companyname":"","email":"SandyPui9@yahoo.com.hk","tel":"97393288","address":"Rm 526, Yi Tak House, Lung Tak Court, Stanley ","pass":true,"customer_id":"662","customer_code":"C170662","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"997","room_code":"X22","retail_price":"2161.0","discounted_price":"2161.00","location_id":"3"}],"roughly_size":"28","total_retail_price":2161,"total_discounted_price":1945,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":11170,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"500.00","warehousing_date":"2020-06-30","rent_from":"2020-06-30","rent_to":"2020-12-29","delivery_service":"0","remark":"6 months contract. Special offer $500 coupon. Storage rental paid by bank transfer on Jul 01, 2020. Storage deposit $4116 transferred from agreement A18-CT196798 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":500,"order_total":11670,"final_order_total":11170,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,45426","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n\n \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> X22 <\/td>\n\t\t\t\t\t 7X4X7 <\/td>\n\t\t\t\t\t $2161.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":"28","total_discounted_price":"1945.00","deposit":"0.00","total_retail_price":"2161.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:12:19","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","3","662","NEW","A18-CT208321",2161,1945,0,0,"6","6",11170,11670,11170,"2020-07-07 13:12:19","0",null,null,null,"2020-06-30","2020-12-29","6 months contract. Special offer $500 coupon. Storage rental paid by bank transfer on Jul 01, 2020. Storage deposit $4116 transferred from agreement A18-CT196798 to this agreement.","2020-06-30","28",0,null,500,"500.00","2","2020-07-07 13:12:18","2","2020-07-07 13:12:18","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,45426","C170662","PERSONAL","Ms","mzl9wJ\/hSEhLPzoiI6h6Zg==","Gx5wC5plnNkrLawNtCgpAA==","","QSN9WoJ9HAqQmHqFLp+5omeZP9\/Zep834Gc0bVH0YIcNuUxGnWi98jx1KNX3AiIE","wYbP0yGhFCXVgrI69fweHw==","xlNbTqyqiOnpFGCRI0oDYYLdYgJaoXlL\/aEXLgLIm2E=","\/r1IszNScVIFPiHhdPS6PA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:12:19","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":["8321","997","2161.0","2161.00","2","2020-07-07 13:12:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:12:19","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-30","2020-12-29","997"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-07 13:12:19","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":["8321","662","SETTLED","A18-I208650","2020-07-07 13:12:18","2020-06-30","2","2020-07-07 13:12:18","2","2020-07-07 13:12:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:12:19","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":["8650","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,1445,"MO","1",1445,"2","2020-07-07 13:12:18","2","2020-07-07 13:12:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:12:19","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":["8650","RENT","\u9810\u7e73\u79df\u91d1",2,1945,"MO","1",1945,"2","2020-07-07 13:12:18","2","2020-07-07 13:12:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:12:19","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":["8650","RENT","\u9810\u7e73\u79df\u91d1",3,1945,"MO","1",1945,"2","2020-07-07 13:12:18","2","2020-07-07 13:12:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:12:19","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":["8650","RENT","\u9810\u7e73\u79df\u91d1",4,1945,"MO","1",1945,"2","2020-07-07 13:12:18","2","2020-07-07 13:12:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:12:19","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":["8650","RENT","\u9810\u7e73\u79df\u91d1",5,1945,"MO","1",1945,"2","2020-07-07 13:12:18","2","2020-07-07 13:12:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:12:19","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":["8650","RENT","\u9810\u7e73\u79df\u91d1",6,1945,"MO","1",1945,"2","2020-07-07 13:12:18","2","2020-07-07 13:12:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:12:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11170,0,"8650"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-07 13:12:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["662","NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208293","2020-07-07 13:12:18",11170,"2","2020-07-07 13:12:18","2","2020-07-07 13:12:18","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:12:19","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":["8293","DEPOSIT",null,"PAID","2020-07-07 13:12:18",0,"2","2020-07-07 13:12:18","2","2020-07-07 13:12:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:12:19","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":["8293","INVOICE","8650","PAID","2020-07-07 13:12:18",11170,"2","2020-07-07 13:12:18","2","2020-07-07 13:12:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:36:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:43:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:43:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:46:07","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":693,"customer_code":"C180693","identity_type":"PERSONAL","identity_id":"D565129(9)","title":"Ms","lastname":"Leung","firstname":"Kwai Fong","companyname":"","email":"jessicakfleung@hotmail.com","tel":"96728663","address":"Flat C, 1\/F, Tower 15, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1737.0","renew_rent_month":"6","renew_warehousing_date":"2020-07-05","renew_room_key":"054,48522","renew_remark":"6 months contract. Storage rental paid by bank transfer on January 5, 2020. Storage deposit transferred from agreement A18-CT195397 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT206874, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"104","order_discount":[{"master_room_discount_id":"471","master_room_id":"104","discount_type":"%","price":"1930.00","disocunted_price":"1737.00","discount":"10.00","monthly_deduct":193,"room_id":"924","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"924","room_code":"U25","retail_price":"1930.0","discounted_price":1737,"location_id":"3"}],"roughly_size":"25","total_retail_price":1930,"total_discounted_price":1737,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":10422,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-05","rent_from":"2020-07-05","rent_to":"2021-01-04","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on July 4, 2020. Storage deposit transferred from agreement A18-CT206874 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":10422,"final_order_total":10422,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,48522","order_product":[],"pass":true}},"first_order_id":"4071","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> U25 <\/td>\r\n\t\t\t\t\t 5X5X7 <\/td>\r\n\t\t\t\t\t $1930.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\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":"25","total_discounted_price":"1737.0","deposit":"0","total_retail_price":"1930.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:46:08","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",693,"NEW","A18-CT208322",1930,1737,0,0,"6","6",10422,10422,10422,"2020-07-07 13:46:08","0",null,null,null,"2020-07-05","2021-01-04","6 months contract. Storage rental paid by bank transfer on July 4, 2020. Storage deposit transferred from agreement A18-CT206874 to this agreement.","2020-07-05","25",0,null,0,"0","2","2020-07-07 13:46:07","2","2020-07-07 13:46:07","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,48522","C180693","PERSONAL","Ms","ZDrpquwkwPpy9nQ\/hoLvWg==","xEf2h2aoyRQ71ZVgBH+9WQ==","","lRcsKhHA4vEMmQFs8Z1xVl14ZyKY7zea3KIuIvH2+8tOR0ubeSGQy4fGa4Mn6UEeJiaB1uB\/ralIZd0z2dtCwQ==","Cr1sInxdrsZ\/KrsFTopt5g==","gk9EaWdpCIuN4GRKj6ECgMCv+1T9s97pJxDpLsccXGw=","KQG6Ym4ctwdq+9V9SC\/\/Rg==",null,1,"4071"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:46:08","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":["8322","471","104","924","%","10.00",193,"2","2020-07-07 13:46:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:46:08","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":["8322","924","1930.0",1737,"2","2020-07-07 13:46:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:46:08","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-05","2021-01-04","924"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-07 13:46:08","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":["8322",693,"SETTLED","A18-I208651","2020-07-07 13:46:07","2020-07-05","2","2020-07-07 13:46:07","2","2020-07-07 13:46:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:46:08","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":["8651","RENT","\u9810\u7e73\u79df\u91d1",1,1737,"MO","1",1737,"2","2020-07-07 13:46:07","2","2020-07-07 13:46:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:46:08","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":["8651","RENT","\u9810\u7e73\u79df\u91d1",2,1737,"MO","1",1737,"2","2020-07-07 13:46:07","2","2020-07-07 13:46:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:46:08","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":["8651","RENT","\u9810\u7e73\u79df\u91d1",3,1737,"MO","1",1737,"2","2020-07-07 13:46:07","2","2020-07-07 13:46:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:46:08","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":["8651","RENT","\u9810\u7e73\u79df\u91d1",4,1737,"MO","1",1737,"2","2020-07-07 13:46:07","2","2020-07-07 13:46:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:46:08","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":["8651","RENT","\u9810\u7e73\u79df\u91d1",5,1737,"MO","1",1737,"2","2020-07-07 13:46:07","2","2020-07-07 13:46:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:46:08","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":["8651","RENT","\u9810\u7e73\u79df\u91d1",6,1737,"MO","1",1737,"2","2020-07-07 13:46:07","2","2020-07-07 13:46:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:46:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10422,0,"8651"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-07 13:46:08","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":[693,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208294","2020-07-07 13:46:07",10422,"2","2020-07-07 13:46:07","2","2020-07-07 13:46:07","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:46:08","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":["8294","DEPOSIT",null,"PAID","2020-07-07 13:46:07",0,"2","2020-07-07 13:46:07","2","2020-07-07 13:46:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 13:46:08","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":["8294","INVOICE","8651","PAID","2020-07-07 13:46:07",10422,"2","2020-07-07 13:46:07","2","2020-07-07 13:46:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 14:02:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 14:06:08","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1539&filter3=undefined","floor_plan_rent_room":[{"room_id":"1750","master_room_id":"232","room_code":"WC-19"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1539,"customer_code":"C201539","identity_type":"PERSONAL","identity_id":"Y064298(1)","title":"Ms","lastname":"TONG","firstname":"Ka Ming","companyname":"","email":"kaming.tong928@gmail.com","tel":"60266931","address":"\u5c07\u8ecd\u6fb3\u539a\u5fb7\u6751\u5fb7\u88d5\u6a1337\u6a134\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3058.0","renew_rent_month":"1","renew_warehousing_date":"2020-07-17","renew_room_key":"0005795970","renew_remark":"1 month contract. Storage rental paid by bank transfer on Jun 15, 2020. Storage deposit $6116 transfered from agreement B01-CT207855 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT208139, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"143","order_discount":[],"order_room":[{"room_id":"1213","room_code":"B01-023","retail_price":"1838.0","discounted_price":"1838.00","location_id":"5"},{"room_id":"1214","room_code":"B01-024","retail_price":"1488.0","discounted_price":"1488.00","location_id":"5"}],"roughly_size":"54","total_retail_price":3326,"total_discounted_price":3058,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":3058,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-17","rent_from":"2020-07-17","rent_to":"2020-08-16","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Jul 07, 2020. Storage deposit $6116 transfered from agreement B01-CT208139 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3058,"final_order_total":3058,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0005795970","order_product":[],"pass":true}},"first_order_id":"7430","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> B01-023 <\/td>\r\n\t\t\t\t\t 5X6X7 <\/td>\r\n\t\t\t\t\t $1838.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> B01-024 <\/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":"54","total_discounted_price":"3058.0","deposit":"0","total_retail_price":"3326.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 14:06:09","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",1539,"NEW","B01-CT208323",3326,3058,0,0,"1","1",3058,3058,3058,"2020-07-07 14:06:09","0",null,null,null,"2020-07-17","2020-08-16","1 month contract. Storage rental paid by bank transfer on Jul 07, 2020. Storage deposit $6116 transfered from agreement B01-CT208139 to this agreement.\r\n","2020-07-17","54",0,null,0,"0","2","2020-07-07 14:06:08","2","2020-07-07 14:06:08","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005795970","C201539","PERSONAL","Ms","emjjkRBZVUSRLbEK77SFEw==","gXED7wniUUNHTT8LsF+fbg==","","bNlP7L7RLt8Fl8B\/yay2q\/dmX7vl9M\/ct23uQR74gJmaO+DCNAZgg0xupPoXF2Hi","rzzpVRFrFmmseYl9vvbFwA==","YSHrDxAftHtY\/YX7L1PEr5QDC4wwmDjJTX59NG9kGk0=","0ux6P2R1VhDModzCYtVS5A==",null,1,"7430"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 14:06:09","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":["8323","1213","1838.0","1838.00","2","2020-07-07 14:06:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 14:06:09","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-17","2020-08-16","1213"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-07 14:06:09","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":["8323","1214","1488.0","1488.00","2","2020-07-07 14:06:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 14:06:09","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-17","2020-08-16","1214"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-07 14:06:09","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":["8323",1539,"SETTLED","B01-I208652","2020-07-07 14:06:08","2020-07-17","2","2020-07-07 14:06:08","2","2020-07-07 14:06:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 14:06:09","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":["8652","RENT","\u9810\u7e73\u79df\u91d1",1,3058,"MO","1",3058,"2","2020-07-07 14:06:08","2","2020-07-07 14:06:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 14:06:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3058,0,"8652"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-07 14:06:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1539,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208295","2020-07-07 14:06:08",3058,"2","2020-07-07 14:06:08","2","2020-07-07 14:06:08","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 14:06:09","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":["8295","DEPOSIT",null,"PAID","2020-07-07 14:06:08",0,"2","2020-07-07 14:06:08","2","2020-07-07 14:06:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 14:06:09","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":["8295","INVOICE","8652","PAID","2020-07-07 14:06:08",3058,"2","2020-07-07 14:06:08","2","2020-07-07 14:06:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 14:34:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 15:11:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 15:12:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 15:13:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 15:55:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 16:02:41","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[],"index_url_parameter":"filter1=2&filter2=662&filter3=undefined","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":690,"customer_code":"C180690","identity_type":"PERSONAL","identity_id":"D705175(2)","title":"Mr","lastname":"Won","firstname":"Siu Fai","companyname":"","email":"cwsfz01@ha.org.hk","tel":"91225716","address":"Room 511, Wah Mei House, Wah Fu Estate, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1226.0","renew_rent_month":"3","renew_warehousing_date":"2020-10-06","renew_room_key":"134,25576","renew_remark":"3 months contract. Storage rental paid by bank transfer on July 03, 2020. Storage deposit transferred from agreement A18-CT207558 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT208306, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[{"master_room_discount_id":"248","master_room_id":"91","discount_type":"%","price":"1290.00","disocunted_price":"1225.90","discount":"4.97","monthly_deduct":64.113,"room_id":"958","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"958","room_code":"W03","retail_price":"1290.0","discounted_price":1225.9,"location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1226,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3678,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-10-06","rent_from":"2020-10-06","rent_to":"2021-01-05","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on July 03, 2020. Storage deposit transferred from agreement A18-CT208306 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3678,"final_order_total":3678,"location_id":"3","branch_id":"1","company_id":"1","room_key":"134,25576","order_product":[],"pass":true}},"first_order_id":"4695","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> W03 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.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":"16","total_discounted_price":"1226.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 16:02: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","3",690,"NEW","A18-CT208324",1290,1226,0,0,"3","3",3678,3678,3678,"2020-07-07 16:02:41","0",null,null,null,"2020-10-06","2021-01-05","3 months contract. Storage rental paid by bank transfer on July 03, 2020. Storage deposit transferred from agreement A18-CT208306 to this agreement.","2020-10-06","16",0,null,0,"0","2","2020-07-07 16:02:41","2","2020-07-07 16:02:41","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"134,25576","C180690","PERSONAL","Mr","oMVGeCm8WBCR2o0n0feOIA==","qpk4ojzePwRudjj9aJKrXw==","","7xSGioytLcEU12Rk9BKOgR87yALsOrFitCmjogNY1TKJKAMhVU7acUwfpCUyoZsBFOpPFSijnS1N8IN8ErkAag==","RWNAm\/lx9kQBOf03gYh1\/g==","i6mloX6eyZE8uEg94TGtWDRJeSKUjYDwskVYR7fURWo=","1e3Wb4gTw9zwpSjLHWvFbg==",null,1,"4695"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 16:02:41","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":["8324","248","91","958","%","4.97",64.113,"2","2020-07-07 16:02:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 16:02: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":["8324","958","1290.0",1225.9,"2","2020-07-07 16:02:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 16:02: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-10-06","2021-01-05","958"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-07 16:02: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":["8324",690,"SETTLED","A18-I208653","2020-07-07 16:02:41","2020-10-06","2","2020-07-07 16:02:41","2","2020-07-07 16:02:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 16:02: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":["8653","RENT","\u9810\u7e73\u79df\u91d1",1,1226,"MO","1",1226,"2","2020-07-07 16:02:41","2","2020-07-07 16:02:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 16:02: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":["8653","RENT","\u9810\u7e73\u79df\u91d1",2,1226,"MO","1",1226,"2","2020-07-07 16:02:41","2","2020-07-07 16:02:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 16:02: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":["8653","RENT","\u9810\u7e73\u79df\u91d1",3,1226,"MO","1",1226,"2","2020-07-07 16:02:41","2","2020-07-07 16:02:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 16:02:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3678,0,"8653"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-07 16:02: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":[690,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208296","2020-07-07 16:02:41",3678,"2","2020-07-07 16:02:41","2","2020-07-07 16:02:41","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 16:02: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":["8296","DEPOSIT",null,"PAID","2020-07-07 16:02:41",0,"2","2020-07-07 16:02:41","2","2020-07-07 16:02:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 16:02: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":["8296","INVOICE","8653","PAID","2020-07-07 16:02:41",3678,"2","2020-07-07 16:02:41","2","2020-07-07 16:02:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 16:48:28","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:18:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:22:10","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","134,25576","3 months contract. Storage rental paid by bank transfer on July 03, 2020. Storage deposit transferred from agreement A18-CT208306 to this agreement.","2020-07-07 17:22:10","2","qpk4ojzePwRudjj9aJKrXw==","oMVGeCm8WBCR2o0n0feOIA==","i6mloX6eyZE8uEg94TGtWDRJeSKUjYDwskVYR7fURWo=","RWNAm\/lx9kQBOf03gYh1\/g==","7xSGioytLcEU12Rk9BKOgR87yALsOrFitCmjogNY1TKJKAMhVU7acUwfpCUyoZsBFOpPFSijnS1N8IN8ErkAag==",8324]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:23: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":"type=INVOICE&filter1=0&filter2=1539&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1750","master_room_id":"232","room_code":"WC-19"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":21,"customer_code":"C150021","identity_type":"PERSONAL","identity_id":"K072676(1)","title":"Mr","lastname":"Cheng","firstname":"Wai Kin","companyname":"","email":"cwkroy@yahoo.com.hk","tel":"93033492","address":"Flat 2B, Block 14, Chi Fu Fa Yuen, H.K.","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-22","renew_room_key":"054,59552","renew_remark":"1 month contract. Storage rental paid by PPS on June 3, 2020. Storage deposit transferred from agreement A12-CT207265 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT208051, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"1","order_discount":[],"order_room":[{"room_id":"211","room_code":"D15","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-22","rent_from":"2020-05-22","rent_to":"2020-06-21","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on Jul 6, 2020. Storage deposit transferred from agreement A12-CT208051 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,59552","order_product":[],"pass":true}},"first_order_id":"5130","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> D15 <\/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> \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":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:23: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","1","1",21,"NEW","A12-CT208325",598,598,0,0,"1","1",598,598,598,"2020-07-07 17:23:22","0",null,null,null,"2020-05-22","2020-06-21","1 month contract. Storage rental paid by PPS on Jul 6, 2020. Storage deposit transferred from agreement A12-CT208051 to this agreement.\r\n","2020-05-22","12",0,null,0,"0","2","2020-07-07 17:23:22","2","2020-07-07 17:23:22","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,59552","C150021","PERSONAL","Mr","MLCe5vmZDmd8r2fUbVc13A==","UCPBCXrBLI9U7KKsPqgmNA==","","6e\/BP2gUBkTAY5yPTvoK7RwdSoD67HISilZb2LuPrHeikacP8o2utC4vDnnnhvni","YemE6fp9WuJaRz9GK0KgKA==","EGeNYE9J78gEvzgbENBQeL\/9UQajTXO7AoyiNhVjolY=","6OwZ\/TwaT9UKVnq5GjUg9w==",null,1,"5130"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:23: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":["8325","211","598.0","598.00","2","2020-07-07 17:23:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:23: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-05-22","2020-06-21","211"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-07 17:23: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":["8325",21,"SETTLED","A12-I208654","2020-07-07 17:23:22","2020-05-22","2","2020-07-07 17:23:22","2","2020-07-07 17:23:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:23: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":["8654","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-07-07 17:23:22","2","2020-07-07 17:23:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:23:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8654"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-07 17:23: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":[21,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208297","2020-07-07 17:23:22",598,"2","2020-07-07 17:23:22","2","2020-07-07 17:23:22","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:23: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":["8297","DEPOSIT",null,"PAID","2020-07-07 17:23:22",0,"2","2020-07-07 17:23:22","2","2020-07-07 17:23:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:23: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":["8297","INVOICE","8654","PAID","2020-07-07 17:23:22",598,"2","2020-07-07 17:23:22","2","2020-07-07 17:23:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:29:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:36: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","index_url_parameter":"type=INVOICE&filter1=0&filter2=1539&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1750","master_room_id":"232","room_code":"WC-19"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":392,"customer_code":"C170392","identity_type":"PERSONAL","identity_id":"P988279(4)","title":"Mr","lastname":"Lee","firstname":"Kenneth Pak Lok","companyname":"","email":"kenneth_P_Lee@yahoo.com","tel":"69712837","address":"Flat B,22\/F,Tower 2,Sham Wan Towers 3 Ap Lei Chau Drive, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4335.0","renew_rent_month":"6","renew_warehousing_date":"2020-11-01","renew_room_key":"138,17024","renew_remark":"6 month contract. Special offer $4335\/month. Storage rental paid by PPS on May 4, 2020. Storage deposit transferred from agreement A12-CT207551 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207783, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[{"master_room_discount_id":"76","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1376.00","discount":"9.95","monthly_deduct":152.036,"room_id":"106","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"76","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1376.00","discount":"9.95","monthly_deduct":152.036,"room_id":"115","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"76","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1376.00","discount":"9.95","monthly_deduct":152.036,"room_id":"114","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"76","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1376.00","discount":"9.95","monthly_deduct":152.036,"room_id":"105","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"115","room_code":"B63","retail_price":"1528.0","discounted_price":1376,"location_id":"1"},{"room_id":"114","room_code":"B62","retail_price":"1528.0","discounted_price":1376,"location_id":"1"},{"room_id":"106","room_code":"B54","retail_price":"1528.0","discounted_price":1376,"location_id":"1"},{"room_id":"105","room_code":"B53","retail_price":"1528.0","discounted_price":1376,"location_id":"1"}],"roughly_size":"80","total_retail_price":6112,"total_discounted_price":4335,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":26010,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-11-01","rent_from":"2020-11-01","rent_to":"2021-04-30","delivery_service":"0","remark":"6 month contract. Special offer $4335\/month. Storage rental paid by PPS on Jul 3, 2020. Storage deposit transferred from agreement A12-CT207783 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":26010,"final_order_total":26010,"location_id":"1","branch_id":"1","company_id":"1","room_key":"138,17024","order_product":[],"pass":true}},"first_order_id":"3904","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 \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> B63 <\/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> B62 <\/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> B54 <\/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> B53 <\/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":"80","total_discounted_price":"4335.0","deposit":"0","total_retail_price":"6112.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:36: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",392,"NEW","A12-CT208326",6112,4335,0,0,"6","6",26010,26010,26010,"2020-07-07 17:36:55","0",null,null,null,"2020-11-01","2021-04-30","6 month contract. Special offer $4335\/month. Storage rental paid by PPS on Jul 3, 2020. Storage deposit transferred from agreement A12-CT207783 to this agreement. \r\n","2020-11-01","80",0,null,0,"0","2","2020-07-07 17:36:54","2","2020-07-07 17:36:54","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"138,17024","C170392","PERSONAL","Mr","BEeVus+G60XJp0DLlFrw5Q==","kiriEIqhcx866RNZiMXdKQ==","","VBX\/XdmRdgqhOmFZK5ALSyxeI8iku\/iH07d+anuZyhubwt\/HaXR\/HjzcA3Wmmw6VBgIGznHH4FxYZNbCfAjNaYs6u2AtWPKHmRXPxCIWvd4=","u2w9koTKJQGsIdFvv8jAeA==","L4egO5Mnnt0ETYeC+58eDoCS0BetZV+b23ZS6nqWBBs=","1A9B3kdXJoFpDPdlSZGM4g==",null,1,"3904"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:36:55","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":["8326","76","10","106","%","9.95",152.036,"2","2020-07-07 17:36:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:36:55","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":["8326","76","10","115","%","9.95",152.036,"2","2020-07-07 17:36:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:36:55","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":["8326","76","10","114","%","9.95",152.036,"2","2020-07-07 17:36:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:36:55","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":["8326","76","10","105","%","9.95",152.036,"2","2020-07-07 17:36:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:36: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":["8326","115","1528.0",1376,"2","2020-07-07 17:36:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:36: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-11-01","2021-04-30","115"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-07 17:36: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":["8326","114","1528.0",1376,"2","2020-07-07 17:36:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:36: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-11-01","2021-04-30","114"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-07 17:36: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":["8326","106","1528.0",1376,"2","2020-07-07 17:36:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:36: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-11-01","2021-04-30","106"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-07 17:36: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":["8326","105","1528.0",1376,"2","2020-07-07 17:36:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:36: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-11-01","2021-04-30","105"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-07 17:36: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":["8326",392,"SETTLED","A12-I208655","2020-07-07 17:36:54","2020-11-01","2","2020-07-07 17:36:54","2","2020-07-07 17:36:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:36: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":["8655","RENT","\u9810\u7e73\u79df\u91d1",1,4335,"MO","1",4335,"2","2020-07-07 17:36:54","2","2020-07-07 17:36:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:36: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":["8655","RENT","\u9810\u7e73\u79df\u91d1",2,4335,"MO","1",4335,"2","2020-07-07 17:36:54","2","2020-07-07 17:36:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:36: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":["8655","RENT","\u9810\u7e73\u79df\u91d1",3,4335,"MO","1",4335,"2","2020-07-07 17:36:54","2","2020-07-07 17:36:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:36: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":["8655","RENT","\u9810\u7e73\u79df\u91d1",4,4335,"MO","1",4335,"2","2020-07-07 17:36:54","2","2020-07-07 17:36:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:36: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":["8655","RENT","\u9810\u7e73\u79df\u91d1",5,4335,"MO","1",4335,"2","2020-07-07 17:36:54","2","2020-07-07 17:36:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:36: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":["8655","RENT","\u9810\u7e73\u79df\u91d1",6,4335,"MO","1",4335,"2","2020-07-07 17:36:54","2","2020-07-07 17:36:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:36:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[26010,0,"8655"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-07 17:36: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":[392,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208298","2020-07-07 17:36:54",26010,"2","2020-07-07 17:36:54","2","2020-07-07 17:36:54","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:36: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":["8298","DEPOSIT",null,"PAID","2020-07-07 17:36:54",0,"2","2020-07-07 17:36:54","2","2020-07-07 17:36:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:36: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":["8298","INVOICE","8655","PAID","2020-07-07 17:36:54",26010,"2","2020-07-07 17:36:54","2","2020-07-07 17:36:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:40:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:41:40","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","138,17024","6 month contract. Special offer $4335\/month. Storage rental paid by PPS on Jul 3, 2020. Storage deposit transferred from agreement A12-CT207783 to this agreement. \r\n","2020-07-07 17:41:40","2","kiriEIqhcx866RNZiMXdKQ==","BEeVus+G60XJp0DLlFrw5Q==","L4egO5Mnnt0ETYeC+58eDoCS0BetZV+b23ZS6nqWBBs=","u2w9koTKJQGsIdFvv8jAeA==","VBX\/XdmRdgqhOmFZK5ALSyxeI8iku\/iH07d+anuZyhubwt\/HaXR\/HjzcA3Wmmw6VBgIGznHH4FxYZNbCfAjNaYs6u2AtWPKHmRXPxCIWvd4=",8326]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:54:31","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 17:56:36","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` = ?, `customer_companyname` = ? where id = ?","parameters":["NEW","092,18279","3 months contract. Storage rental paid by bank transfer on June 29, 2020. Storage deposit $5310 transferred from agreement A16-CT207523 to this agreement.","2020-07-07 17:56:36","2","Zzv1eRCimQisUlUlw\/fpjg==","aSBBtAs7bqfl5dV3rXfGGg==","Ab\/R2lan0QiDbiz1yaOXWb4qMLUpURe9bMyZ\/fyH\/H4=","pXFnlcoNY7GMI6BDQ45dxg==","AowVIbVtwBhQXZODO3Iu+kjJGRcUi3I\/CIqwF\/f1YBv6bxU8NQbyCEpOZX5cHEye","ACP Services Limited",8258]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 18:36:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 18:37:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 18:57:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 19:07: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":"type=INVOICE&filter1=0&filter2=1539&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1750","master_room_id":"232","room_code":"WC-19"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1190,"customer_code":"C191190","identity_type":"PERSONAL","identity_id":"Y542390(0)","title":"Ms","lastname":"YAU","firstname":"Hoi Ching","companyname":"","email":"hoichingyau@yahoo.com.hk","tel":"98286010","address":"Flat 2703, 27\/F, Hoi Tin Court, Aberdeen Centre, H.K.","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1342.0","renew_rent_month":"3","renew_warehousing_date":"2020-05-02","renew_room_key":"088,29636","renew_remark":"3 months contract. Storage rental $3300 paid by bank transfer on April 9, 2020. Remaining balance $726 paid by PayMe on April 15, 2020.Storage deposit transferred from agreement A14-CT207035 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207619, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"68","order_discount":[],"order_room":[{"room_id":"471","room_code":"K08(\u670d\u88dd\u5009)","retail_price":"1342.0","discounted_price":"1342.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1342,"total_discounted_price":1275,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3825,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-02","rent_from":"2020-05-02","rent_to":"2020-08-01","delivery_service":"0","remark":"3 months contract. Storage rental $3825 paid by PPS on Jul 2, 2020.Storage deposit transferred from agreement A14-CT207619 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":3825,"final_order_total":3825,"location_id":"2","branch_id":"1","company_id":"1","room_key":"088,29636","order_product":[],"pass":true}},"first_order_id":"6197","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> K08(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1342.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":"16","total_discounted_price":"1275.00","deposit":"0","total_retail_price":"1342.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 19:07: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","1","2",1190,"NEW","A14-CT208327",1342,1275,0,0,"3","3",3825,3825,3825,"2020-07-07 19:07:25","0",null,null,null,"2020-05-02","2020-08-01","3 months contract. Storage rental $3825 paid by PPS on Jul 2, 2020.Storage deposit transferred from agreement A14-CT207619 to this agreement.","2020-05-02","16",0,null,0,"0","2","2020-07-07 19:07:25","2","2020-07-07 19:07:25","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"088,29636","C191190","PERSONAL","Ms","6xj4DbIC8gpxDREqt\/B+EA==","UVY\/HEZSKUPvom9zK4XPwQ==","","2DxST9L++AVFDrp9kqOR+yNcCTgvrEFAbuJgJ13c5xMM6Bt6nxgGJLr69i4wti8HSiFkei69OG3Sr5mAjbh9ww==","iYQqKb+DhKHyc7lRAXgFTQ==","ta5gSuJOiqrW0ihrVIPASVaAT6MyRLxzqFuCiH8tgNQ=","KjAi6kd8noXu\/72l80Vugg==",null,1,"6197"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 19:07: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":["8327","471","1342.0","1342.00","2","2020-07-07 19:07:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 19:07: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-05-02","2020-08-01","471"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-07 19:07: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":["8327",1190,"SETTLED","A14-I208656","2020-07-07 19:07:25","2020-05-02","2","2020-07-07 19:07:25","2","2020-07-07 19:07:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 19:07: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":["8656","RENT","\u9810\u7e73\u79df\u91d1",1,1275,"MO","1",1275,"2","2020-07-07 19:07:25","2","2020-07-07 19:07:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 19:07: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":["8656","RENT","\u9810\u7e73\u79df\u91d1",2,1275,"MO","1",1275,"2","2020-07-07 19:07:25","2","2020-07-07 19:07:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 19:07: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":["8656","RENT","\u9810\u7e73\u79df\u91d1",3,1275,"MO","1",1275,"2","2020-07-07 19:07:25","2","2020-07-07 19:07:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 19:07:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3825,0,"8656"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-07 19:07: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":[1190,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208299","2020-07-07 19:07:25",3825,"2","2020-07-07 19:07:25","2","2020-07-07 19:07:25","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 19:07: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":["8299","DEPOSIT",null,"PAID","2020-07-07 19:07:25",0,"2","2020-07-07 19:07:25","2","2020-07-07 19:07:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 19:07: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":["8299","INVOICE","8656","PAID","2020-07-07 19:07:25",3825,"2","2020-07-07 19:07:25","2","2020-07-07 19:07:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 19:17:46","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=1190&filter3=undefined","floor_plan_rent_room":[{"room_id":"1750","master_room_id":"232","room_code":"WC-19"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1190,"customer_code":"C191190","identity_type":"PERSONAL","identity_id":"Y542390(0)","title":"Ms","lastname":"YAU","firstname":"Hoi Ching","companyname":"","email":"hoichingyau@yahoo.com.hk","tel":"98286010","address":"Flat 2703, 27\/F, Hoi Tin Court, Aberdeen Centre, H.K.","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1857.0","renew_rent_month":"1","renew_warehousing_date":"2020-07-01","renew_room_key":"","renew_remark":"1 month contract. Storage rental paid by PPS on May 18, 2020. Storage deposit $3714 transferred from agreement A16-CT207620 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT207898, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"205","order_discount":[],"order_room":[{"room_id":"1524","room_code":"A16-033","retail_price":"1857.0","discounted_price":"1857.00","location_id":"7"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1847,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1847,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-01","rent_from":"2020-07-01","rent_to":"2020-07-31","delivery_service":"0","remark":"1 month contract. Storage rental paid $1794 by PPS on Jul 2, 2020.(outstanding $53 transferred from A16-CT207898 to this agreement.) Storage deposit $3714 transferred from agreement A16-CT207898 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1847,"final_order_total":1847,"location_id":"7","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"first_order_id":"6282","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-033 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1857.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":"24","total_discounted_price":"1847.00","deposit":"0","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 19:17:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","7",1190,"NEW","A16-CT208328",1857,1847,0,0,"1","1",1847,1847,1847,"2020-07-07 19:17:47","0",null,null,null,"2020-07-01","2020-07-31","1 month contract. Storage rental paid $1794 by PPS on Jul 2, 2020.(outstanding $53 transferred from A16-CT207898 to this agreement.) Storage deposit $3714 transferred from agreement A16-CT207898 to this agreement. \r\n","2020-07-01","24",0,null,0,"0","2","2020-07-07 19:17:46","2","2020-07-07 19:17:46","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"","C191190","PERSONAL","Ms","6xj4DbIC8gpxDREqt\/B+EA==","UVY\/HEZSKUPvom9zK4XPwQ==","","2DxST9L++AVFDrp9kqOR+yNcCTgvrEFAbuJgJ13c5xMM6Bt6nxgGJLr69i4wti8HSiFkei69OG3Sr5mAjbh9ww==","iYQqKb+DhKHyc7lRAXgFTQ==","ta5gSuJOiqrW0ihrVIPASVaAT6MyRLxzqFuCiH8tgNQ=","KjAi6kd8noXu\/72l80Vugg==",null,1,"6282"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 19:17:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8328","1524","1857.0","1857.00","2","2020-07-07 19:17:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 19:17:47","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-01","2020-07-31","1524"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-07 19:17:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8328",1190,"SETTLED","A16-I208657","2020-07-07 19:17:46","2020-07-01","2","2020-07-07 19:17:46","2","2020-07-07 19:17:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 19:17:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8657","RENT","\u9810\u7e73\u79df\u91d1",1,1847,"MO","1",1847,"2","2020-07-07 19:17:46","2","2020-07-07 19:17:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 19:17:47","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1847,0,"8657"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-07 19:17:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1190,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208300","2020-07-07 19:17:46",1847,"2","2020-07-07 19:17:46","2","2020-07-07 19:17:46","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 19:17:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8300","DEPOSIT",null,"PAID","2020-07-07 19:17:46",0,"2","2020-07-07 19:17:46","2","2020-07-07 19:17:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-07 19:17:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8300","INVOICE","8657","PAID","2020-07-07 19:17:46",1847,"2","2020-07-07 19:17:46","2","2020-07-07 19:17:46"]},"data_before":[],"data_after":[],"step":1} *****