\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>
Q14 <\/td>\n\t\t\t\t\t	4X4.5X7 <\/td>\n\t\t\t\t\t	$1.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":"18","total_discounted_price":"3998.00","deposit":"7704.00","total_retail_price":"1.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 18:47:35","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":["C201672","PERSONAL","Mr","5AGzITqOidXxvzV1kmdBqw==","NlDo74jBWrJTBIeQELf7PA==","","cfjuUqasL0bNnKwE1UbMug==","l0l5m+hQP0RUmQse044G45IzCkxk3QC0G4Sr6m9cHNU=","6F88GPSmmnGXsPk2ZyJKWg==","5QP5DWfaBFw+k1agQ2Yi\/Q==",null,"l0l5m+hQP0RUmQse044G45IzCkxk3QC0G4Sr6m9cHNU=","e45HiFwwCaiL\/1g0nUZoOQ==","2","2020-07-14 18:47:33","2","2020-07-14 18:47:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 18:47:35","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",1672,"NEW","A18-CT208392",1,3998,7704,0,"13","13",46396,59678,46396,"2020-07-14 18:47:35","0",null,null,null,"2020-05-29","2021-06-28","13 months contract. Special offer 50% off for the first 3 months and the 13th month free for the first contract. Storage rental and deposit $11196 paid by bank transfer on May 28, 2020 and the balance paid by post-dated cheque.","2020-05-29","18",0,null,13282,"13282.00","2","2020-07-14 18:47:33","2","2020-07-14 18:47:33","BANKIN","","","","BANKIN","","","",null,0,"","C201672","PERSONAL","Mr","5AGzITqOidXxvzV1kmdBqw==","NlDo74jBWrJTBIeQELf7PA==","","6F88GPSmmnGXsPk2ZyJKWg==","cfjuUqasL0bNnKwE1UbMug==","l0l5m+hQP0RUmQse044G45IzCkxk3QC0G4Sr6m9cHNU=","5QP5DWfaBFw+k1agQ2Yi\/Q==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 18:47:35","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":["8392","817","1.0","1.00","2","2020-07-14 18:47:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 18:47:35","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-29","2021-06-28","817"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-14 18:47:35","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":["8392","A18-D205545","PAID",7704,0,"2021-06-28","2020-07-14 18:47:33","2020-07-14 18:47:33","2","2020-07-14 18:47:33","2","2020-07-14 18:47:33",1672]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 18:47:35","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":["8392",1672,"SETTLED","A18-I208721","2020-07-14 18:47:33","2020-05-29","2","2020-07-14 18:47:33","2","2020-07-14 18:47:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 18:47:35","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":["8721","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-07-14 18:47:33","2","2020-07-14 18:47:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 18:47:35","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":["8721","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-07-14 18:47:33","2","2020-07-14 18:47:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 18:47:35","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":["8721","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,0,"MO","1",0,"2","2020-07-14 18:47:33","2","2020-07-14 18:47:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 18:47:35","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":["8721","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",4,2710,"MO","1",2710,"2","2020-07-14 18:47:33","2","2020-07-14 18:47:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 18:47:35","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":["8721","RENT","\u9810\u7e73\u79df\u91d1",5,3998,"MO","1",3998,"2","2020-07-14 18:47:33","2","2020-07-14 18:47:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 18:47:35","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":["8721","RENT","\u9810\u7e73\u79df\u91d1",6,3998,"MO","1",3998,"2","2020-07-14 18:47:33","2","2020-07-14 18:47:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 18:47:35","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":["8721","RENT","\u9810\u7e73\u79df\u91d1",7,3998,"MO","1",3998,"2","2020-07-14 18:47:33","2","2020-07-14 18:47:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 18:47:35","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":["8721","RENT","\u9810\u7e73\u79df\u91d1",8,3998,"MO","1",3998,"2","2020-07-14 18:47:33","2","2020-07-14 18:47:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 18:47:35","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":["8721","RENT","\u9810\u7e73\u79df\u91d1",9,3998,"MO","1",3998,"2","2020-07-14 18:47:33","2","2020-07-14 18:47:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 18:47:35","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":["8721","RENT","\u9810\u7e73\u79df\u91d1",10,3998,"MO","1",3998,"2","2020-07-14 18:47:33","2","2020-07-14 18:47:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 18:47:35","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":["8721","RENT","\u9810\u7e73\u79df\u91d1",11,3998,"MO","1",3998,"2","2020-07-14 18:47:33","2","2020-07-14 18:47:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 18:47:35","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":["8721","RENT","\u9810\u7e73\u79df\u91d1",12,3998,"MO","1",3998,"2","2020-07-14 18:47:33","2","2020-07-14 18:47:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 18:47:35","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":["8721","RENT","\u9810\u7e73\u79df\u91d1",13,3998,"MO","1",3998,"2","2020-07-14 18:47:33","2","2020-07-14 18:47:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 18:47:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[38692,0,"8721"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-14 18:47:35","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":[1672,"BANKIN","","","","BANKIN","","","","PAID","P208364","2020-07-14 18:47:33",46396,"2","2020-07-14 18:47:33","2","2020-07-14 18:47:33","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 18:47:35","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":["8364","DEPOSIT","5545","PAID","2020-07-14 18:47:33",7704,"2","2020-07-14 18:47:33","2","2020-07-14 18:47:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 18:47:35","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":["8364","INVOICE","8721","PAID","2020-07-14 18:47:33",38692,"2","2020-07-14 18:47:33","2","2020-07-14 18:47:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:07:50","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=445&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":72,"customer_code":"C160072","identity_type":"PERSONAL","identity_id":"D704707(0)","title":"Mr","lastname":"Chau","firstname":"Cheuk Lim","companyname":"","email":"kc1.mailbox@gmail.com","tel":"94152009","address":"Flat D , 26\/F , Block 17 , South Horizons Apleichau , HK","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"13","renew_warehousing_date":"2020-07-15","renew_room_key":"053,35395","renew_remark":"13 months contract. Storage rental paid by PPS on June 12, 2019. Storage deposit transferred from agreement A12-CT183852 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195228, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"1","order_discount":[{"master_room_discount_id":"68","master_room_id":"1","discount_type":"%","price":"598.00","disocunted_price":"538.20","discount":"10.00","monthly_deduct":59.8,"room_id":"210","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"210","room_code":"D14","retail_price":"598.0","discounted_price":538.2,"location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-15","rent_from":"2020-07-15","rent_to":"2021-01-14","delivery_service":"0","remark":"6 months contract. Storage rental paid by PPS on July 10, 2020. Storage deposit transferred from agreement A12-CT195228 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"1","branch_id":"1","company_id":"1","room_key":"053,35395","order_product":[],"pass":true}},"first_order_id":"3852","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> D14 <\/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":"538.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:07:50","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",72,"NEW","A12-CT208393",598,538,0,0,"6","6",3228,3228,3228,"2020-07-14 19:07:50","0",null,null,null,"2020-07-15","2021-01-14","6 months contract. Storage rental paid by PPS on July 10, 2020. Storage deposit transferred from agreement A12-CT195228 to this agreement.\r\n","2020-07-15","12",0,null,0,"0","2","2020-07-14 19:07:50","2","2020-07-14 19:07:50","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"053,35395","C160072","PERSONAL","Mr","n0u8ujyB01s7mRK1WFXlLg==","kOK3vHUlGE9qjoVnzYRDGA==","","eI5dQFNPcF6ak2JnJTDiah9y7OfsZC3DRPTgnFJmkW0Jkhl7UW+Nthm084sc5CWTgCUGV46W1MwTKZmnhT+boA==","KfTf\/6vJRRN\/8tPWjWi0sw==","hOnEWTselpuyn+5ke7N9Pw7SCzmL+e4lm1UT\/TwaYN4=","4hNFGvJFCNIlJTcfRvsc5Q==",null,1,"3852"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:07:50","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":["8393","68","1","210","%","10.00",59.8,"2","2020-07-14 19:07:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:07:50","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":["8393","210","598.0",538.2,"2","2020-07-14 19:07:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:07:50","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-15","2021-01-14","210"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-14 19:07:50","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":["8393",72,"SETTLED","A12-I208722","2020-07-14 19:07:50","2020-07-15","2","2020-07-14 19:07:50","2","2020-07-14 19:07:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:07:50","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":["8722","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-07-14 19:07:50","2","2020-07-14 19:07:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:07:50","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":["8722","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-07-14 19:07:50","2","2020-07-14 19:07:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:07:50","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":["8722","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-07-14 19:07:50","2","2020-07-14 19:07:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:07:50","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":["8722","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-07-14 19:07:50","2","2020-07-14 19:07:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:07:50","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":["8722","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-07-14 19:07:50","2","2020-07-14 19:07:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:07:50","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":["8722","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-07-14 19:07:50","2","2020-07-14 19:07:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:07:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"8722"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-14 19:07:50","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":[72,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208365","2020-07-14 19:07:50",3228,"2","2020-07-14 19:07:50","2","2020-07-14 19:07:50","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:07:50","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":["8365","DEPOSIT",null,"PAID","2020-07-14 19:07:50",0,"2","2020-07-14 19:07:50","2","2020-07-14 19:07:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:07:50","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":["8365","INVOICE","8722","PAID","2020-07-14 19:07:50",3228,"2","2020-07-14 19:07:50","2","2020-07-14 19:07:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:10:28","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=445&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":901,"customer_code":"C180901","identity_type":"PERSONAL","identity_id":"D428931(6)","title":"Mr","lastname":"Chu","firstname":"Ho Kei Howard","companyname":"","email":"hhkchu@hotmail.com","tel":"90842263","address":"Flat G, 29\/F, Block 33A, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"733.0","renew_rent_month":"12","renew_warehousing_date":"2020-07-15","renew_room_key":"190,38718","renew_remark":"12 months contract. Special renewal offer, $300 wellcome vouchers offered. Storage rental paid by PPS on July 15, 2019. Storage deposit transferred from agreement A14-CT194342 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195483, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"30","order_discount":[],"order_room":[{"room_id":"643","room_code":"M54","retail_price":"775.0","discounted_price":"775.00","location_id":"2"}],"roughly_size":"9","total_retail_price":775,"total_discounted_price":733,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":4398,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-15","rent_from":"2020-07-15","rent_to":"2021-01-14","delivery_service":"0","remark":"6 months contract. Storage rental paid by PPS on July 13, 2020. Storage deposit transferred from agreement A14-CT195483 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":4398,"final_order_total":4398,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190,38718","order_product":[],"pass":true}},"first_order_id":"4342","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> M54 <\/td>\r\n\t\t\t\t\t 3X3X8 <\/td>\r\n\t\t\t\t\t $775.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"9","total_discounted_price":"733.00","deposit":"0.00","total_retail_price":"775.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:10:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",901,"NEW","A14-CT208394",775,733,0,0,"6","6",4398,4398,4398,"2020-07-14 19:10:28","0",null,null,null,"2020-07-15","2021-01-14","6 months contract. Storage rental paid by PPS on July 13, 2020. Storage deposit transferred from agreement A14-CT195483 to this agreement.\r\n","2020-07-15","9",0,null,0,"0","2","2020-07-14 19:10:28","2","2020-07-14 19:10:28","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"190,38718","C180901","PERSONAL","Mr","PMyJCwgCHWUVNkHizqrOwg==","uwdKi3S38jh5+tBibXKG4A==","","e4SYV3wJOXmhLWnft+DTZ\/mmpYrQsZbRSge\/l54fiuKlwgGM4QFdfCt7FFZ2XJPIB7wmjQ\/9+hCzAmYPbg73Gw==","yMSCZvWVrVw20ou6upKBOA==","zvAK3uwrPxJSSxsiZ0ohdQgbrNOLX\/kL\/mU8oasAE5g=","dBADHe+C7USP5eboqIAo0Q==",null,1,"4342"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:10:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8394","643","775.0","775.00","2","2020-07-14 19:10:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:10:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-15","2021-01-14","643"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-14 19:10:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8394",901,"SETTLED","A14-I208723","2020-07-14 19:10:28","2020-07-15","2","2020-07-14 19:10:28","2","2020-07-14 19:10:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:10:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8723","RENT","\u9810\u7e73\u79df\u91d1",1,733,"MO","1",733,"2","2020-07-14 19:10:28","2","2020-07-14 19:10:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:10:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8723","RENT","\u9810\u7e73\u79df\u91d1",2,733,"MO","1",733,"2","2020-07-14 19:10:28","2","2020-07-14 19:10:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:10:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8723","RENT","\u9810\u7e73\u79df\u91d1",3,733,"MO","1",733,"2","2020-07-14 19:10:28","2","2020-07-14 19:10:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:10:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8723","RENT","\u9810\u7e73\u79df\u91d1",4,733,"MO","1",733,"2","2020-07-14 19:10:28","2","2020-07-14 19:10:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:10:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8723","RENT","\u9810\u7e73\u79df\u91d1",5,733,"MO","1",733,"2","2020-07-14 19:10:28","2","2020-07-14 19:10:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:10:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8723","RENT","\u9810\u7e73\u79df\u91d1",6,733,"MO","1",733,"2","2020-07-14 19:10:28","2","2020-07-14 19:10:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:10:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4398,0,"8723"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-14 19:10:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[901,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208366","2020-07-14 19:10:28",4398,"2","2020-07-14 19:10:28","2","2020-07-14 19:10:28","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:10:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8366","DEPOSIT",null,"PAID","2020-07-14 19:10:28",0,"2","2020-07-14 19:10:28","2","2020-07-14 19:10:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:10:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8366","INVOICE","8723","PAID","2020-07-14 19:10:28",4398,"2","2020-07-14 19:10:28","2","2020-07-14 19:10:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:16: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=2&filter2=445&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1312,"customer_code":"C191312","identity_type":"PERSONAL","identity_id":"D495559(6)","title":"Mr","lastname":"YUNG","firstname":"Chun Man Tony","companyname":"","email":"Tony.yung@ymail.com","tel":"96641563","address":"Room B, 9\/F, Tin Hing Manson, 305 Des Voeux Road West, HK","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"989.0","renew_rent_month":"13","renew_warehousing_date":"2020-08-01","renew_room_key":"076,33530","renew_remark":"13 months contract. Special offer 13th month free and 5% \u201cRent Now\u201d offer. Storage rental paid on June 22, 2019. Smart card provided on June 22, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195293, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2196.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"73","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"913.00","discount":"16.85","monthly_deduct":185.013,"room_id":"146","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"146","room_code":"C22","retail_price":"1098.0","discounted_price":913,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":989,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":11868,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-08-01","rent_from":"2020-08-01","rent_to":"2021-07-31","delivery_service":"0","remark":"12 months contract. Storage rental paid by PPS on July 13, 2020. Storage rental $2196 transferred from agreement A12-CT195293 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":11868,"final_order_total":11868,"location_id":"1","branch_id":"1","company_id":"1","room_key":"076,33530","order_product":[],"pass":true}},"first_order_id":5293,"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> C22 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"989.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:16: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","1","1",1312,"NEW","A12-CT208395",1098,989,0,0,"12","12",11868,11868,11868,"2020-07-14 19:16:09","0",null,null,null,"2020-08-01","2021-07-31","12 months contract. Storage rental paid by PPS on July 13, 2020. Storage rental $2196 transferred from agreement A12-CT195293 to this agreement. \r\n","2020-08-01","16",0,null,0,"0","2","2020-07-14 19:16:08","2","2020-07-14 19:16:08","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"076,33530","C191312","PERSONAL","Mr","GPJBHBFx3Ox7vojAOF02bg==","7ajmLy9SpvmTEmc2Hg5GzA==","","dsNL4uB2jMizrg1JZ89etk4AnNC2BLtA2IBlviII19L3o7JWSYI2S\/xJnWYvSTHvCtKNuY2jU0fNGZlQBWCQzg==","33+99vyZM7EY+5aLKLQ9NA==","FtdJn9DAj\/yKCy4AjtJhjpIzNJC+q4C86z8QZmfhGew=","iAtXkdE4I6CTB3ro2v67vw==",null,1,5293]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:16:09","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":["8395","73","8","146","%","16.85",185.013,"2","2020-07-14 19:16:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:16: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":["8395","146","1098.0",913,"2","2020-07-14 19:16:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:16: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-08-01","2021-07-31","146"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-14 19:16: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":["8395",1312,"SETTLED","A12-I208724","2020-07-14 19:16:08","2020-08-01","2","2020-07-14 19:16:08","2","2020-07-14 19:16:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:16: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":["8724","RENT","\u9810\u7e73\u79df\u91d1",1,989,"MO","1",989,"2","2020-07-14 19:16:08","2","2020-07-14 19:16:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:16: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":["8724","RENT","\u9810\u7e73\u79df\u91d1",2,989,"MO","1",989,"2","2020-07-14 19:16:08","2","2020-07-14 19:16:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:16: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":["8724","RENT","\u9810\u7e73\u79df\u91d1",3,989,"MO","1",989,"2","2020-07-14 19:16:08","2","2020-07-14 19:16:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:16: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":["8724","RENT","\u9810\u7e73\u79df\u91d1",4,989,"MO","1",989,"2","2020-07-14 19:16:08","2","2020-07-14 19:16:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:16: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":["8724","RENT","\u9810\u7e73\u79df\u91d1",5,989,"MO","1",989,"2","2020-07-14 19:16:08","2","2020-07-14 19:16:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:16: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":["8724","RENT","\u9810\u7e73\u79df\u91d1",6,989,"MO","1",989,"2","2020-07-14 19:16:08","2","2020-07-14 19:16:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:16: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":["8724","RENT","\u9810\u7e73\u79df\u91d1",7,989,"MO","1",989,"2","2020-07-14 19:16:08","2","2020-07-14 19:16:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:16: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":["8724","RENT","\u9810\u7e73\u79df\u91d1",8,989,"MO","1",989,"2","2020-07-14 19:16:08","2","2020-07-14 19:16:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:16: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":["8724","RENT","\u9810\u7e73\u79df\u91d1",9,989,"MO","1",989,"2","2020-07-14 19:16:08","2","2020-07-14 19:16:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:16: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":["8724","RENT","\u9810\u7e73\u79df\u91d1",10,989,"MO","1",989,"2","2020-07-14 19:16:08","2","2020-07-14 19:16:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:16: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":["8724","RENT","\u9810\u7e73\u79df\u91d1",11,989,"MO","1",989,"2","2020-07-14 19:16:08","2","2020-07-14 19:16:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:16: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":["8724","RENT","\u9810\u7e73\u79df\u91d1",12,989,"MO","1",989,"2","2020-07-14 19:16:08","2","2020-07-14 19:16:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:16:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11868,0,"8724"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-14 19:16: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":[1312,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208367","2020-07-14 19:16:08",11868,"2","2020-07-14 19:16:08","2","2020-07-14 19:16:08","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:16: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":["8367","DEPOSIT",null,"PAID","2020-07-14 19:16:08",0,"2","2020-07-14 19:16:08","2","2020-07-14 19:16:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:16: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":["8367","INVOICE","8724","PAID","2020-07-14 19:16:08",11868,"2","2020-07-14 19:16:08","2","2020-07-14 19:16:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:17:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:20: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":"filter1=2&filter2=445&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1291,"customer_code":"C191291","identity_type":"BUSINESS","identity_id":"61490169-000-05-19-5","title":"Mr","lastname":"WONG","firstname":"Kin Tak","companyname":"DR WONG KIN TAK CLINIC LIMITED","email":"dr.wongkintak@gmail.com","tel":"90291628","address":"805A, 8\/F, Melbourne Plaza, 33 Queen's Road Central, Central, HK","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"13","renew_warehousing_date":"2020-07-20","renew_room_key":"'0012522916","renew_remark":"13 months contract. Special offer free the 13th month. $300 discount for "change Storage" and 5% "rent now" Offer. Storage rental and deposit paid by cheque on Jun 10, 2019. Smartcard provided on Jun 10, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT195287, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2580.0","renew_master_room_id":"114","order_discount":[{"master_room_discount_id":"251","master_room_id":"114","discount_type":"%","price":"1290.00","disocunted_price":"1161.00","discount":"10.00","monthly_deduct":129,"room_id":"1014","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1014","room_code":"A05-012","retail_price":"1290.0","discounted_price":1161,"location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6972,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-20","rent_from":"2020-07-20","rent_to":"2021-01-19","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on July 14, 2020. Storage deposit $2580 transferred from agreement A05-CT195287 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":6972,"final_order_total":6972,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0012522916","order_product":[],"pass":true,"paymethod_other2":""}},"first_order_id":5287,"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> A05-012 <\/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":"1162.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:20:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1291,"NEW","A05-CT208396",1290,1162,0,0,"6","6",6972,6972,6972,"2020-07-14 19:20:23","0",null,null,null,"2020-07-20","2021-01-19","6 months contract. Storage rental paid by bank transfer on July 14, 2020. Storage deposit $2580 transferred from agreement A05-CT195287 to this agreement. \r\n","2020-07-20","16",0,null,0,"0","2","2020-07-14 19:20:22","2","2020-07-14 19:20:22","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0012522916","C191291","BUSINESS","Mr","zHajDv+x2\/HdPqCE+KMmQw==","ddrfzAYTmkL\/QNu3psjONQ==","DR WONG KIN TAK CLINIC LIMITED","hXkyJ9MNJHDLj4tVG0tzrPgeAA1\/2lkEATuvWvgu\/l\/kX6L1m1i\/4\/AQhKq4NwgbJn2D9e4sTextOv37y9NtsasQyniS9mihnhyQeDPLPPc=","VxGdwwVsnuofawj3L16NCA==","ECMAG4yws9UdqauQjwAcp3vY22TNDgIsJvMu03pMN3U=",null,"s4BfKtwvqapKzR8XfV0UtB46XInICkvG56oSxi4fzfo=",1,5287]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:20:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["8396","251","114","1014","%","10.00",129,"2","2020-07-14 19:20:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:20: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":["8396","1014","1290.0",1161,"2","2020-07-14 19:20:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:20: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-20","2021-01-19","1014"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-14 19:20: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":["8396",1291,"SETTLED","A05-I208725","2020-07-14 19:20:22","2020-07-20","2","2020-07-14 19:20:22","2","2020-07-14 19:20:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:20: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":["8725","RENT","\u9810\u7e73\u79df\u91d1",1,1162,"MO","1",1162,"2","2020-07-14 19:20:22","2","2020-07-14 19:20:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:20: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":["8725","RENT","\u9810\u7e73\u79df\u91d1",2,1162,"MO","1",1162,"2","2020-07-14 19:20:22","2","2020-07-14 19:20:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:20: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":["8725","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-07-14 19:20:22","2","2020-07-14 19:20:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:20: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":["8725","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-07-14 19:20:22","2","2020-07-14 19:20:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:20: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":["8725","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-07-14 19:20:22","2","2020-07-14 19:20:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:20: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":["8725","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-07-14 19:20:22","2","2020-07-14 19:20:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:20:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6972,0,"8725"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-14 19:20: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":[1291,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208368","2020-07-14 19:20:22",6972,"2","2020-07-14 19:20:22","2","2020-07-14 19:20:22","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:20: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":["8368","DEPOSIT",null,"PAID","2020-07-14 19:20:22",0,"2","2020-07-14 19:20:22","2","2020-07-14 19:20:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:20: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":["8368","INVOICE","8725","PAID","2020-07-14 19:20:22",6972,"2","2020-07-14 19:20:22","2","2020-07-14 19:20:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:21:44","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=445&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":431,"customer_code":"C170431","identity_type":"PERSONAL","identity_id":"D413337(5)","title":"Ms","lastname":"Wu","firstname":"Yuen Fong","companyname":"","email":null,"tel":"93139577","address":"\u7f6e\u5bcc\u82b1\u571210\u5ea718\u6a13A\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-07-13","renew_room_key":"072,48391","renew_remark":"1 month contract. Storage rental paid by bank transfer on JUNE 11, 2020. Storage deposit transferred from agreement A14-CT207962 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT208144, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"633","room_code":"M44","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"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-07-13","rent_from":"2020-07-13","rent_to":"2020-08-12","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on July 14, 2020. Storage deposit transferred from agreement A14-CT208144 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"072,48391","order_product":[],"pass":true}},"first_order_id":"4767","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> M44 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:21:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",431,"NEW","A14-CT208397",598,598,0,0,"1","1",598,598,598,"2020-07-14 19:21:45","0",null,null,null,"2020-07-13","2020-08-12","1 month contract. Storage rental paid by bank transfer on July 14, 2020. Storage deposit transferred from agreement A14-CT208144 to this agreement.\r\n","2020-07-13","12",0,null,0,"0","2","2020-07-14 19:21:44","2","2020-07-14 19:21:44","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"072,48391","C170431","PERSONAL","Ms","UxlXQiCLdPwPautaCTB+Hw==","6BZ3jKM7u1vzGCs7Yb+Ugw==","","n4HXLIkQV7R3SmsiP7KfX4xGRy\/8rX+8EebxY4Sn+pQ=","\/5Bh87k0zl6kketxJ3ZvuA==",null,"eYnja6hmcz0ZXhSZIkdH7w==",null,1,"4767"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:21:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8397","633","598.0","598.00","2","2020-07-14 19:21:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:21:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-13","2020-08-12","633"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-14 19:21:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8397",431,"SETTLED","A14-I208726","2020-07-14 19:21:44","2020-07-13","2","2020-07-14 19:21:44","2","2020-07-14 19:21:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:21:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8726","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-07-14 19:21:44","2","2020-07-14 19:21:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:21:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8726"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-14 19:21:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[431,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208369","2020-07-14 19:21:44",598,"2","2020-07-14 19:21:44","2","2020-07-14 19:21:44","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:21:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8369","DEPOSIT",null,"PAID","2020-07-14 19:21:44",0,"2","2020-07-14 19:21:44","2","2020-07-14 19:21:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:21:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8369","INVOICE","8726","PAID","2020-07-14 19:21:44",598,"2","2020-07-14 19:21:44","2","2020-07-14 19:21:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:22:30","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=445&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":431,"customer_code":"C170431","identity_type":"PERSONAL","identity_id":"D413337(5)","title":"Ms","lastname":"Wu","firstname":"Yuen Fong","companyname":"","email":null,"tel":"93139577","address":"\u7f6e\u5bcc\u82b1\u571210\u5ea718\u6a13A\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1198.0","renew_rent_month":"1","renew_warehousing_date":"2020-07-12","renew_room_key":"136,17013","renew_remark":"1 month contract. Storage rental paid by bank transfer on JUNE 11, 2020. Storage deposit transferred from agreement A14-CT207963 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT208143, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"30","order_discount":[],"order_room":[{"room_id":"648","room_code":"M59","retail_price":"775.0","discounted_price":"775.00","location_id":"2"},{"room_id":"634","room_code":"M45","retail_price":"775.0","discounted_price":"775.00","location_id":"2"}],"roughly_size":"18","total_retail_price":1550,"total_discounted_price":1198,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1198,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-12","rent_from":"2020-07-12","rent_to":"2020-08-11","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on July 14, 2020. Storage deposit transferred from agreement A14-CT208143 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1198,"final_order_total":1198,"location_id":"2","branch_id":"1","company_id":"1","room_key":"136,17013","order_product":[],"pass":true}},"first_order_id":"4768","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> M59 <\/td>\r\n\t\t\t\t\t 3X3X8 <\/td>\r\n\t\t\t\t\t $775.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> M45 <\/td>\r\n\t\t\t\t\t 3X3X8 <\/td>\r\n\t\t\t\t\t $775.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"18","total_discounted_price":"1198.0","deposit":"0","total_retail_price":"1550.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",431,"NEW","A14-CT208398",1550,1198,0,0,"1","1",1198,1198,1198,"2020-07-14 19:22:30","0",null,null,null,"2020-07-12","2020-08-11","1 month contract. Storage rental paid by bank transfer on July 14, 2020. Storage deposit transferred from agreement A14-CT208143 to this agreement.","2020-07-12","18",0,null,0,"0","2","2020-07-14 19:22:30","2","2020-07-14 19:22:30","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,17013","C170431","PERSONAL","Ms","UxlXQiCLdPwPautaCTB+Hw==","6BZ3jKM7u1vzGCs7Yb+Ugw==","","n4HXLIkQV7R3SmsiP7KfX4xGRy\/8rX+8EebxY4Sn+pQ=","\/5Bh87k0zl6kketxJ3ZvuA==",null,"eYnja6hmcz0ZXhSZIkdH7w==",null,1,"4768"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8398","648","775.0","775.00","2","2020-07-14 19:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:22:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-12","2020-08-11","648"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-14 19:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8398","634","775.0","775.00","2","2020-07-14 19:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:22:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-12","2020-08-11","634"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-14 19:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8398",431,"SETTLED","A14-I208727","2020-07-14 19:22:30","2020-07-12","2","2020-07-14 19:22:30","2","2020-07-14 19:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8727","RENT","\u9810\u7e73\u79df\u91d1",1,1198,"MO","1",1198,"2","2020-07-14 19:22:30","2","2020-07-14 19:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:22:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1198,0,"8727"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-14 19:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[431,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208370","2020-07-14 19:22:30",1198,"2","2020-07-14 19:22:30","2","2020-07-14 19:22:30","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8370","DEPOSIT",null,"PAID","2020-07-14 19:22:30",0,"2","2020-07-14 19:22:30","2","2020-07-14 19:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-14 19:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8370","INVOICE","8727","PAID","2020-07-14 19:22:30",1198,"2","2020-07-14 19:22:30","2","2020-07-14 19:22:30"]},"data_before":[],"data_after":[],"step":1} *****