{"created_at":"2020-02-07 10:19:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 10:52:26","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":748,"customer_code":"C180748","identity_type":"PERSONAL","identity_id":"D135664(0)","title":"Ms","lastname":"Chau","firstname":"Sau Ying","companyname":"","email":null,"tel":"61834868","address":"\u9999\u6e2f\u4ed4\u83ef\u5bcc\u6751\u83ef\u6cf0\u6a132023\u5ba4","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1672.0","renew_rent_month":"6","renew_warehousing_date":"2020-02-04","renew_room_key":"0008973235,0003605964","renew_remark":"6 months contract. Storage rental paid by cash on August 3, 2019. Storage deposit transferred from agreement A05-CT194275 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT195631, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"117","order_discount":[],"order_room":[{"room_id":"1027","room_code":"A05-025","retail_price":"1857.0","discounted_price":"1857.00","location_id":"4"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1672,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":20064,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1672.00","warehousing_date":"2020-02-04","rent_from":"2020-02-04","rent_to":"2021-03-03","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by cash on February 7, 2020. Storage deposit transferred from agreement A05-CT195631 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":1672,"order_total":21736,"final_order_total":20064,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0008973235,0003605964","order_product":[],"pass":true}},"first_order_id":"4275","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-025 <\/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>	\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":"24","total_discounted_price":"1672.00","deposit":"0.00","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 10:52:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",748,"NEW","A05-CT207134",1857,1672,0,0,"13","13",20064,21736,20064,"2020-02-07 10:52:27","0",null,null,null,"2020-02-04","2021-03-03","13 months contract. Special offer the 13th month free. Storage rental paid by cash on February 7, 2020. Storage deposit transferred from agreement A05-CT195631 to this agreement.\r\n","2020-02-04","24",0,null,1672,"1672.00","2","2020-02-07 10:52:26","2","2020-02-07 10:52:26","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"0008973235,0003605964","C180748","PERSONAL","Ms","yANzfeHOhYehhNPJXy6BjA==","kOK3vHUlGE9qjoVnzYRDGA==","","Kduq13gOeK5604RWMUq1Zljhcv\/2bcSrLXmtCOw8pNYdASLUNLMxDwp5o58Po2Y2","IvAn+kY0J+spVA1GktQLFg==",null,"iAxjOyyADX4mysy09Ifbkg==",null,1,"4275"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 10:52:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7134","1027","1857.0","1857.00","2","2020-02-07 10:52:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 10:52:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-04","2021-03-03","1027"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-07 10:52:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7134",748,"SETTLED","A05-I207462","2020-02-07 10:52:26","2020-02-04","2","2020-02-07 10:52:26","2","2020-02-07 10:52:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 10:52:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7462","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1672,"MO","1",1672,"2","2020-02-07 10:52:26","2","2020-02-07 10:52:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 10:52:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7462","RENT","\u9810\u7e73\u79df\u91d1",3,1672,"MO","1",1672,"2","2020-02-07 10:52:26","2","2020-02-07 10:52:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 10:52:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7462","RENT","\u9810\u7e73\u79df\u91d1",4,1672,"MO","1",1672,"2","2020-02-07 10:52:26","2","2020-02-07 10:52:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 10:52:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7462","RENT","\u9810\u7e73\u79df\u91d1",5,1672,"MO","1",1672,"2","2020-02-07 10:52:26","2","2020-02-07 10:52:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 10:52:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7462","RENT","\u9810\u7e73\u79df\u91d1",6,1672,"MO","1",1672,"2","2020-02-07 10:52:26","2","2020-02-07 10:52:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 10:52:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7462","RENT","\u9810\u7e73\u79df\u91d1",7,1672,"MO","1",1672,"2","2020-02-07 10:52:26","2","2020-02-07 10:52:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 10:52:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7462","RENT","\u9810\u7e73\u79df\u91d1",8,1672,"MO","1",1672,"2","2020-02-07 10:52:26","2","2020-02-07 10:52:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 10:52:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7462","RENT","\u9810\u7e73\u79df\u91d1",9,1672,"MO","1",1672,"2","2020-02-07 10:52:26","2","2020-02-07 10:52:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 10:52:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7462","RENT","\u9810\u7e73\u79df\u91d1",10,1672,"MO","1",1672,"2","2020-02-07 10:52:26","2","2020-02-07 10:52:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 10:52:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7462","RENT","\u9810\u7e73\u79df\u91d1",11,1672,"MO","1",1672,"2","2020-02-07 10:52:26","2","2020-02-07 10:52:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 10:52:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7462","RENT","\u9810\u7e73\u79df\u91d1",12,1672,"MO","1",1672,"2","2020-02-07 10:52:26","2","2020-02-07 10:52:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 10:52:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7462","RENT","\u9810\u7e73\u79df\u91d1",13,1672,"MO","1",1672,"2","2020-02-07 10:52:26","2","2020-02-07 10:52:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 10:52:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[20064,0,"7462"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-07 10:52:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[748,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207110","2020-02-07 10:52:26",20064,"2","2020-02-07 10:52:26","2","2020-02-07 10:52:26","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 10:52:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7110","DEPOSIT",null,"PAID","2020-02-07 10:52:26",0,"2","2020-02-07 10:52:26","2","2020-02-07 10:52:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 10:52:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7110","INVOICE","7462","PAID","2020-02-07 10:52:26",20064,"2","2020-02-07 10:52:26","2","2020-02-07 10:52:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 10:56:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 10:57:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 11:12:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 11:27:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:13:16","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":418,"customer_code":"C170418","identity_type":"PERSONAL","identity_id":"D254599(4)","title":"Ms","lastname":"Cheung","firstname":"Yee Man","companyname":"","email":null,"tel":"60159661","address":"\u9999\u6e2f\u4ed4\u4e2d\u5fc3\u6d77\u6676\u95a317\u6a131\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-09","renew_room_key":"054,47889","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 3, 2020. Storage deposit transferred A14-CT196578 to this agreement. \u820a\u5408\u7d04\u7de8\u865f: A14-CT196578, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT206834, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"757","room_code":"O33","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":998,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-09","rent_from":"2020-02-09","rent_to":"2020-03-08","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on February 6, 2020. Storage deposit transferred A14-CT206834 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":998,"final_order_total":998,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,47889","order_product":[],"pass":true}},"first_order_id":"4700","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> O33 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"998.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:13:16","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",418,"NEW","A14-CT207135",998,998,0,0,"1","1",998,998,998,"2020-02-07 14:13:16","0",null,null,null,"2020-02-09","2020-03-08","1 month contract. Storage rental paid by bank transfer on February 6, 2020. Storage deposit transferred A14-CT206834 to this agreement.\r\n","2020-02-09","12",0,null,0,"0","2","2020-02-07 14:13:16","2","2020-02-07 14:13:16","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,47889","C170418","PERSONAL","Ms","OSpwVZLaj11jKWHakE7sQg==","vCxOlXQuvOQaoL822H2o\/Q==","","hI6IrHjcy5pLAjEBRvfJ4609cWRuORlDVf1yu6P5hRnRjvCLtw+B8QJk\/h1VC39A","+X1wpo4tNWX3Q8nWqGEQTw==",null,"1j94IrN7Ua\/hHPZd+nL1Ig==",null,1,"4700"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:13:16","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":["7135","757","998.0","998.00","2","2020-02-07 14:13:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:13:16","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-02-09","2020-03-08","757"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-07 14:13:16","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":["7135",418,"SETTLED","A14-I207463","2020-02-07 14:13:16","2020-02-09","2","2020-02-07 14:13:16","2","2020-02-07 14:13:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:13:16","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":["7463","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-02-07 14:13:16","2","2020-02-07 14:13:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:13:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"7463"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-07 14:13:16","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":[418,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207111","2020-02-07 14:13:16",998,"2","2020-02-07 14:13:16","2","2020-02-07 14:13:16","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:13:16","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":["7111","DEPOSIT",null,"PAID","2020-02-07 14:13:16",0,"2","2020-02-07 14:13:16","2","2020-02-07 14:13:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:13:16","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":["7111","INVOICE","7463","PAID","2020-02-07 14:13:16",998,"2","2020-02-07 14:13:16","2","2020-02-07 14:13:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:23: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","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":650,"customer_code":"C170650","identity_type":"PERSONAL","identity_id":"Z603985(6)","title":"Mr","lastname":"Li","firstname":"Ka Man Carmen ","companyname":"","email":"licarmen120@outlook.com","tel":"60866005","address":"Flat 11D, Block 7, Chi Fu Fa Yuen, Pok Fu Lam ","pass":true},"2":{"renew_paymethod2":"OTHER","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1857.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-01","renew_room_key":"053,30656","renew_remark":"1 month contract. Storage rental paid by PayMe on January 6, 2020. Storage deposit transferred from agreement A18-CT196582 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT206886, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"79","order_discount":[],"order_room":[{"room_id":"832","room_code":"R06","retail_price":"1857.0","discounted_price":"1857.00","location_id":"3"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1857,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1857,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-01","rent_from":"2020-02-01","rent_to":"2020-02-29","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on February 6, 2020. Storage deposit transferred from agreement A18-CT206886 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1857,"final_order_total":1857,"location_id":"3","branch_id":"1","company_id":"1","room_key":"053,30656","order_product":[],"pass":true}},"first_order_id":"4117","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> R06 <\/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> \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":"24","total_discounted_price":"1857.0","deposit":"0","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14: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","3",650,"NEW","A18-CT207136",1857,1857,0,0,"1","1",1857,1857,1857,"2020-02-07 14:23:22","0",null,null,null,"2020-02-01","2020-02-29","1 month contract. Storage rental paid by PPS on February 6, 2020. Storage deposit transferred from agreement A18-CT206886 to this agreement.\r\n","2020-02-01","24",0,null,0,"0","2","2020-02-07 14:23:21","2","2020-02-07 14:23:21","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"053,30656","C170650","PERSONAL","Mr","mqlU7HwzD2KcOzmXS2v+sA==","7KCehmxbvwRMb+U8lHGoVA==","","N1UMvJRIlBDaipk\/6myaA2yvOWbLAlcHBaBFvhn3ndwzx9gjypD9HQoLkbHY903D","j9uSn7lfecYNB\/L0v79ywg==","D\/P9IXVUbziIb70tKXH1egvc8mQBlMIAFVy1O5krGx4=","qJTrGPQQj78pb5tx0e8DHg==",null,1,"4117"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14: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":["7136","832","1857.0","1857.00","2","2020-02-07 14:23:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14: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-02-01","2020-02-29","832"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-07 14: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":["7136",650,"SETTLED","A18-I207464","2020-02-07 14:23:21","2020-02-01","2","2020-02-07 14:23:21","2","2020-02-07 14:23:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14: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":["7464","RENT","\u9810\u7e73\u79df\u91d1",1,1857,"MO","1",1857,"2","2020-02-07 14:23:21","2","2020-02-07 14:23:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:23:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1857,0,"7464"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-07 14: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":[650,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207112","2020-02-07 14:23:21",1857,"2","2020-02-07 14:23:21","2","2020-02-07 14:23:21","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14: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":["7112","DEPOSIT",null,"PAID","2020-02-07 14:23:21",0,"2","2020-02-07 14:23:21","2","2020-02-07 14:23:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14: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":["7112","INVOICE","7464","PAID","2020-02-07 14:23:21",1857,"2","2020-02-07 14:23:21","2","2020-02-07 14:23:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:25: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":"&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","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":688,"customer_code":"C180688","identity_type":"PERSONAL","identity_id":"K122210(4)","title":"Mr","lastname":"Cheung","firstname":"Wai Yung","companyname":"","email":"yung912@gmail.com","tel":"92637806","address":"Rm A, 20\/F, Block 20, Mei Cheung Court, 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":"1090.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-08","renew_room_key":"054,60450","renew_remark":"1 month contract. Storage rental paid by PPS on January 2, 2020. Storage deposit transferred from agreement A18-CT196592 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT206854, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"77","order_discount":[],"order_room":[{"room_id":"813","room_code":"Q10","retail_price":"1090.0","discounted_price":"1090.00","location_id":"3"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":1090,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1090,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-08","rent_from":"2020-02-08","rent_to":"2020-03-07","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on February 6, 2020. Storage deposit transferred from agreement A18-CT206854 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1090,"final_order_total":1090,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,60450","order_product":[],"pass":true}},"first_order_id":"4769","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> Q10 <\/td>\r\n\t\t\t\t\t 3X4X7 <\/td>\r\n\t\t\t\t\t $1090.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":"1090.0","deposit":"0","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:25:44","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",688,"NEW","A18-CT207137",1090,1090,0,0,"1","1",1090,1090,1090,"2020-02-07 14:25:44","0",null,null,null,"2020-02-08","2020-03-07","1 month contract. Storage rental paid by PPS on February 6, 2020. Storage deposit transferred from agreement A18-CT206854 to this agreement.\r\n","2020-02-08","12",0,null,0,"0","2","2020-02-07 14:25:44","2","2020-02-07 14:25:44","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,60450","C180688","PERSONAL","Mr","w+3oxtOYocerQ225PhLj2Q==","vCxOlXQuvOQaoL822H2o\/Q==","","QvNFWPnZK2SY5iOuJxtofiF6G+A71It3PRUQIo0auvIWzvBTZRm2wfB\/VYgB4L2eWR9M0rvXLhbVNAUw9JyOPpQPVCto6YLfO\/ESHYYW+OA=","+JEnloGcmAHQH7QI0dDDrg==","KssyFPR1OHCnH1SYGPPT\/JDvr7I47++6Ndv+5eVj1fE=","OGIBS1CZsN25WARbNGD97w==",null,1,"4769"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:25:44","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":["7137","813","1090.0","1090.00","2","2020-02-07 14:25:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:25:44","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-02-08","2020-03-07","813"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-07 14:25:44","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":["7137",688,"SETTLED","A18-I207465","2020-02-07 14:25:44","2020-02-08","2","2020-02-07 14:25:44","2","2020-02-07 14:25:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:25:44","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":["7465","RENT","\u9810\u7e73\u79df\u91d1",1,1090,"MO","1",1090,"2","2020-02-07 14:25:44","2","2020-02-07 14:25:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:25:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1090,0,"7465"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-07 14:25:44","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":[688,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207113","2020-02-07 14:25:44",1090,"2","2020-02-07 14:25:44","2","2020-02-07 14:25:44","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:25:44","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":["7113","DEPOSIT",null,"PAID","2020-02-07 14:25:44",0,"2","2020-02-07 14:25:44","2","2020-02-07 14:25:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:25:44","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":["7113","INVOICE","7465","PAID","2020-02-07 14:25:44",1090,"2","2020-02-07 14:25:44","2","2020-02-07 14:25:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:45: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","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":168,"customer_code":"C160168","identity_type":"PERSONAL","identity_id":"D197954(0)","title":"Mr","lastname":"Li","firstname":"Ho Leung","companyname":"","email":"hlli1@hotmail.com","tel":"93159482","address":"22H, Block 15, South Horizons, Apleichau, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1788.0","renew_rent_month":"6","renew_warehousing_date":"2020-02-01","renew_room_key":"054, 51791","renew_remark":"6 months contract. Storage rental paid by bank transfer on August 2, 2019. Storage deposit transferred from agreement A12-CT194435 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195617, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"134","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"148","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"148","room_code":"C24","retail_price":"1098.0","discounted_price":989,"location_id":"1"},{"room_id":"134","room_code":"C10","retail_price":"1098.0","discounted_price":989,"location_id":"1"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":1788,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":10728,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-01","rent_from":"2020-02-01","rent_to":"2020-07-31","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on February 7, 2020. Storage deposit transferred from agreement A12-CT195617 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":10728,"final_order_total":10728,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054, 51791","order_product":[],"pass":true}},"first_order_id":"4435","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> C24 <\/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> C10 <\/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":"32","total_discounted_price":"1788.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:45:21","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",168,"NEW","A12-CT207138",2196,1788,0,0,"6","6",10728,10728,10728,"2020-02-07 14:45:21","0",null,null,null,"2020-02-01","2020-07-31","6 months contract. Storage rental paid by bank transfer on February 7, 2020. Storage deposit transferred from agreement A12-CT195617 to this agreement.","2020-02-01","32",0,null,0,"0","2","2020-02-07 14:45:21","2","2020-02-07 14:45:21","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054, 51791","C160168","PERSONAL","Mr","9aivimD9vaENHbzOSD7Qmw==","7KCehmxbvwRMb+U8lHGoVA==","","6hodw+Y5869heZlv4HL5saiNNRp5XMz3EbYpK\/XczqU774Y9\/57tjmKj5n8ktO29","GqbBpAP6HuZDvjv+mMCNhQ==","yE0MLNPcwh2YQ2hnGMS6ZUfgB6H2usgUNpRR4g+FiwA=","g1C0DsGSLZBjuj+X9vLq7Q==",null,1,"4435"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:45:21","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":["7138","72","8","134","%","9.93",109.0314,"2","2020-02-07 14:45:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:45:21","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":["7138","72","8","148","%","9.93",109.0314,"2","2020-02-07 14:45:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:45:21","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":["7138","148","1098.0",989,"2","2020-02-07 14:45:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:45:21","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-02-01","2020-07-31","148"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-07 14:45:21","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":["7138","134","1098.0",989,"2","2020-02-07 14:45:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:45:21","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-02-01","2020-07-31","134"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-07 14:45:21","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":["7138",168,"SETTLED","A12-I207466","2020-02-07 14:45:21","2020-02-01","2","2020-02-07 14:45:21","2","2020-02-07 14:45:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:45:21","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":["7466","RENT","\u9810\u7e73\u79df\u91d1",1,1788,"MO","1",1788,"2","2020-02-07 14:45:21","2","2020-02-07 14:45:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:45:21","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":["7466","RENT","\u9810\u7e73\u79df\u91d1",2,1788,"MO","1",1788,"2","2020-02-07 14:45:21","2","2020-02-07 14:45:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:45:21","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":["7466","RENT","\u9810\u7e73\u79df\u91d1",3,1788,"MO","1",1788,"2","2020-02-07 14:45:21","2","2020-02-07 14:45:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:45:21","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":["7466","RENT","\u9810\u7e73\u79df\u91d1",4,1788,"MO","1",1788,"2","2020-02-07 14:45:21","2","2020-02-07 14:45:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:45:21","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":["7466","RENT","\u9810\u7e73\u79df\u91d1",5,1788,"MO","1",1788,"2","2020-02-07 14:45:21","2","2020-02-07 14:45:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:45:21","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":["7466","RENT","\u9810\u7e73\u79df\u91d1",6,1788,"MO","1",1788,"2","2020-02-07 14:45:21","2","2020-02-07 14:45:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:45:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10728,0,"7466"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-07 14:45:21","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":[168,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207114","2020-02-07 14:45:21",10728,"2","2020-02-07 14:45:21","2","2020-02-07 14:45:21","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:45:21","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":["7114","DEPOSIT",null,"PAID","2020-02-07 14:45:21",0,"2","2020-02-07 14:45:21","2","2020-02-07 14:45:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 14:45:21","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":["7114","INVOICE","7466","PAID","2020-02-07 14:45:21",10728,"2","2020-02-07 14:45:21","2","2020-02-07 14:45:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:03:58","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":876,"customer_code":"C180876","identity_type":"PERSONAL","identity_id":"K098389(6)","title":"Ms","lastname":"Chiu","firstname":"Yuen Man","companyname":"","email":"kennethleungsk@yahoo.com.hk","tel":"94781221","address":"Flat C, 18\/F, Tower 16, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"989.0","renew_rent_month":"6","renew_warehousing_date":"2020-03-02","renew_room_key":"111,41208","renew_remark":"6 months contract. change from unit D34 to A23. Storage deposit ($2076 - 1\/9 rental $35 = $2041) transferred from agreement A12-CT195288 to this agreement. Remaining storage rental and deposit (ttl:$6089) paid by cash on August 27, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195804, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2196.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"23","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"23","room_code":"A23","retail_price":"1098.0","discounted_price":989,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":989,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5934,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-02","rent_from":"2020-03-02","rent_to":"2020-09-01","delivery_service":"0","remark":"6 months contract. Storage rental paid by cash on February 7, 2020. Storage deposit $2196 transferred from agreement A12-CT195804 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":5934,"final_order_total":5934,"location_id":"1","branch_id":"1","company_id":"1","room_key":"111,41208","order_product":[],"pass":true}},"first_order_id":5804,"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> A23 <\/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.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:03:59","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",876,"NEW","A12-CT207139",1098,989,0,0,"6","6",5934,5934,5934,"2020-02-07 15:03:59","0",null,null,null,"2020-03-02","2020-09-01","6 months contract. Storage rental paid by cash on February 7, 2020. Storage deposit $2196 transferred from agreement A12-CT195804 to this agreement. ","2020-03-02","16",0,null,0,"0","2","2020-02-07 15:03:58","2","2020-02-07 15:03:58","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"111,41208","C180876","PERSONAL","Ms","5wFLBCB3V2yjZaMJePpEfw==","sQFQFKDK2lCJDg4WUvEEAw==","","tFOKuyTyj9mSIBST\/yJBElyhP7Zw9i6gxUp6xz2xhCHbXUSi17ApJmQYtPxJRfxA81aiPBMeaNHP\/6cKvWqrVA==","Suy\/MugKDanC+fcveQSgBw==","QfZE\/V35fbmNmVWO9qtsF42UuXbJllpF\/QM2KB7jsRc=","kGLSFNZNSwJ7X4k4Vvza3A==",null,1,5804]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:03:59","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":["7139","72","8","23","%","9.93",109.0314,"2","2020-02-07 15:03:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:03:59","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":["7139","23","1098.0",989,"2","2020-02-07 15:03:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:03:59","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-03-02","2020-09-01","23"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-07 15:03:59","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":["7139",876,"SETTLED","A12-I207467","2020-02-07 15:03:58","2020-03-02","2","2020-02-07 15:03:58","2","2020-02-07 15:03:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:03:59","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":["7467","RENT","\u9810\u7e73\u79df\u91d1",1,989,"MO","1",989,"2","2020-02-07 15:03:58","2","2020-02-07 15:03:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:03:59","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":["7467","RENT","\u9810\u7e73\u79df\u91d1",2,989,"MO","1",989,"2","2020-02-07 15:03:58","2","2020-02-07 15:03:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:03:59","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":["7467","RENT","\u9810\u7e73\u79df\u91d1",3,989,"MO","1",989,"2","2020-02-07 15:03:58","2","2020-02-07 15:03:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:03:59","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":["7467","RENT","\u9810\u7e73\u79df\u91d1",4,989,"MO","1",989,"2","2020-02-07 15:03:58","2","2020-02-07 15:03:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:03:59","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":["7467","RENT","\u9810\u7e73\u79df\u91d1",5,989,"MO","1",989,"2","2020-02-07 15:03:58","2","2020-02-07 15:03:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:03:59","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":["7467","RENT","\u9810\u7e73\u79df\u91d1",6,989,"MO","1",989,"2","2020-02-07 15:03:58","2","2020-02-07 15:03:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:03:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5934,0,"7467"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-07 15:03:59","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":[876,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207115","2020-02-07 15:03:58",5934,"2","2020-02-07 15:03:58","2","2020-02-07 15:03:58","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:03:59","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":["7115","DEPOSIT",null,"PAID","2020-02-07 15:03:58",0,"2","2020-02-07 15:03:58","2","2020-02-07 15:03:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:03:59","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":["7115","INVOICE","7467","PAID","2020-02-07 15:03:58",5934,"2","2020-02-07 15:03:58","2","2020-02-07 15:03:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:17:37","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":754,"customer_code":"C180754","identity_type":"PERSONAL","identity_id":"D276420(3)","title":"Ms","lastname":"Lee","firstname":"Yuen Yu","companyname":"","email":null,"tel":"98127099","address":"Flat 708, 7\/F, Pik Yuet House, Shek Pai Wan Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"6","renew_warehousing_date":"2020-02-12","renew_room_key":"055,36498(lost),111,43397","renew_remark":"6 months contract. Storage rental paid by cash on August 8, 2019. Storage deposit transferred from agreement A14-CT194279 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195673, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"626","room_code":"M37","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-12","rent_from":"2020-02-12","rent_to":"2020-08-11","delivery_service":"0","remark":"6 months contract. Storage rental paid by cheque on February 7, 2020. Storage deposit transferred from agreement A14-CT195673 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,36498(lost),111,43397","order_product":[],"pass":true}},"first_order_id":"4279","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> M37 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"538.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:17:37","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",754,"NEW","A14-CT207140",598,538,0,0,"6","6",3228,3228,3228,"2020-02-07 15:17:37","0",null,null,null,"2020-02-12","2020-08-11","6 months contract. Storage rental paid by cheque on February 7, 2020. Storage deposit transferred from agreement A14-CT195673 to this agreement.","2020-02-12","12",0,null,0,"0","2","2020-02-07 15:17:37","2","2020-02-07 15:17:37","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"055,36498(lost),111,43397","C180754","PERSONAL","Ms","e523\/E6u0vj8cQujTfOdLg==","kiriEIqhcx866RNZiMXdKQ==","","xlcdUTq9chMErwT1\/LubxtrE7FZIYtP6lTyqzIyIJkq9PrSKz8iEIciEeI24fvi3NreVmso+xebWDeKTxe9ZpyPh4EoSgH9Mra9LiJ\/dpzU=","Sf4DjxDkDZX4ytVGAQtmRg==",null,"gSn\/q1Pf60Yx2h79w5\/azQ==",null,1,"4279"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:17:37","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":["7140","626","598.0","598.00","2","2020-02-07 15:17:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:17:37","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-02-12","2020-08-11","626"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-07 15:17:37","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":["7140",754,"SETTLED","A14-I207468","2020-02-07 15:17:37","2020-02-12","2","2020-02-07 15:17:37","2","2020-02-07 15:17:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:17:37","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":["7468","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-02-07 15:17:37","2","2020-02-07 15:17:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:17:37","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":["7468","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-02-07 15:17:37","2","2020-02-07 15:17:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:17:37","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":["7468","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-02-07 15:17:37","2","2020-02-07 15:17:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:17:37","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":["7468","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-02-07 15:17:37","2","2020-02-07 15:17:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:17:37","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":["7468","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-02-07 15:17:37","2","2020-02-07 15:17:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:17:37","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":["7468","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-02-07 15:17:37","2","2020-02-07 15:17:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:17:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"7468"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-07 15:17:37","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":[754,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207116","2020-02-07 15:17:37",3228,"2","2020-02-07 15:17:37","2","2020-02-07 15:17:37","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:17:37","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":["7116","DEPOSIT",null,"PAID","2020-02-07 15:17:37",0,"2","2020-02-07 15:17:37","2","2020-02-07 15:17:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 15:17:37","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":["7116","INVOICE","7468","PAID","2020-02-07 15:17:37",3228,"2","2020-02-07 15:17:37","2","2020-02-07 15:17:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:00:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:09:01","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:18:40","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":342,"customer_code":"C170342","identity_type":"PERSONAL","identity_id":"E753300(8)","title":"Ms","lastname":"Tang ","firstname":"Yuk Ha Albertina","companyname":"","email":"tinatang@paliburg.com.hk","tel":"91554846","address":"11\/F,68 Yee Wo street,Causeway Bay Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3478.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-23","renew_room_key":"052,34956","renew_remark":"6 months contract. Storage rental paid by bank transfer on August 17, 2019. Storage deposit transferred from agreement A14-CT194374 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195751, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"500","room_code":"K37","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"491","room_code":"K28","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"499","room_code":"K36","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"490","room_code":"K27","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"64","total_retail_price":4392,"total_discounted_price":3478,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":20868,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-23","rent_from":"2020-01-23","rent_to":"2020-07-22","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on February 7, 2020. Storage deposit transferred from agreement A14-CT195751 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":20868,"final_order_total":20868,"location_id":"2","branch_id":"1","company_id":"1","room_key":"052,34956","order_product":[],"pass":true}},"first_order_id":"4374","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> K37 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> K28 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> K36 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> K27 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"64","total_discounted_price":"3478.0","deposit":"0","total_retail_price":"4392.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:18:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",342,"NEW","A14-CT207141",4392,3478,0,0,"6","6",20868,20868,20868,"2020-02-07 16:18:40","0",null,null,null,"2020-01-23","2020-07-22","6 months contract. Storage rental paid by bank transfer on February 7, 2020. Storage deposit transferred from agreement A14-CT195751 to this agreement.\r\n","2020-01-23","64",0,null,0,"0","2","2020-02-07 16:18:40","2","2020-02-07 16:18:40","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,34956","C170342","PERSONAL","Ms","kRCz78YpmfnTx9YEMStxc2NHyFF8hc\/bm1exLLFMU7A=","D2u5F1t2Ua28czFdD4B98Q==","","pbNlYhtpNQSESyaMCY2y7FBwvyCtvSn4iLa88d5r3g467AbpNDlGGRHlM0kRkJzr","ZzYDm0++oP1cC48abOPaSg==","BlPVKOzYsOg616NyfHGCobMN5S6qFdKFrowqKyzHr\/0=","GAR4oUAoh9i5k3Xuf0adZw==",null,1,"4374"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:18:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7141","500","1098.0","1098.00","2","2020-02-07 16:18:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:18:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-23","2020-07-22","500"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-07 16:18:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7141","491","1098.0","1098.00","2","2020-02-07 16:18:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:18:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-23","2020-07-22","491"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-07 16:18:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7141","499","1098.0","1098.00","2","2020-02-07 16:18:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:18:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-23","2020-07-22","499"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-07 16:18:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7141","490","1098.0","1098.00","2","2020-02-07 16:18:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:18:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-23","2020-07-22","490"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-07 16:18:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7141",342,"SETTLED","A14-I207469","2020-02-07 16:18:40","2020-01-23","2","2020-02-07 16:18:40","2","2020-02-07 16:18:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:18:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7469","RENT","\u9810\u7e73\u79df\u91d1",1,3478,"MO","1",3478,"2","2020-02-07 16:18:40","2","2020-02-07 16:18:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:18:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7469","RENT","\u9810\u7e73\u79df\u91d1",2,3478,"MO","1",3478,"2","2020-02-07 16:18:40","2","2020-02-07 16:18:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:18:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7469","RENT","\u9810\u7e73\u79df\u91d1",3,3478,"MO","1",3478,"2","2020-02-07 16:18:40","2","2020-02-07 16:18:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:18:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7469","RENT","\u9810\u7e73\u79df\u91d1",4,3478,"MO","1",3478,"2","2020-02-07 16:18:40","2","2020-02-07 16:18:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:18:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7469","RENT","\u9810\u7e73\u79df\u91d1",5,3478,"MO","1",3478,"2","2020-02-07 16:18:40","2","2020-02-07 16:18:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:18:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7469","RENT","\u9810\u7e73\u79df\u91d1",6,3478,"MO","1",3478,"2","2020-02-07 16:18:40","2","2020-02-07 16:18:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:18:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[20868,0,"7469"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-07 16:18: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":[342,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207117","2020-02-07 16:18:40",20868,"2","2020-02-07 16:18:40","2","2020-02-07 16:18:40","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:18: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":["7117","DEPOSIT",null,"PAID","2020-02-07 16:18:40",0,"2","2020-02-07 16:18:40","2","2020-02-07 16:18:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:18: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":["7117","INVOICE","7469","PAID","2020-02-07 16:18:40",20868,"2","2020-02-07 16:18:40","2","2020-02-07 16:18:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:42:32","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":712,"customer_code":"C180712","identity_type":"PERSONAL","identity_id":"P754247(3)","title":"Ms","lastname":"Clift","firstname":"Susan Brown","companyname":"","email":"sueclift@gmail.com","tel":"90491105","address":"40B, Jadewater, 238 Aberdeen Main Road, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"6","renew_warehousing_date":"2020-02-15","renew_room_key":"054,60829","renew_remark":"6 months contract. Storage rental paid by bank transfer on August 12, 2019. Storage deposit transferred from agreement A18-CT195441 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195856, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[{"master_room_discount_id":"250","master_room_id":"91","discount_type":"%","price":"1290.00","disocunted_price":"1161.00","discount":"10.00","monthly_deduct":129,"room_id":"915","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"915","room_code":"U16","retail_price":"1290.0","discounted_price":1161,"location_id":"3"}],"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-02-15","rent_from":"2020-02-15","rent_to":"2020-08-14","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on February 7, 2020. Storage deposit transferred from agreement A18-CT195856 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6972,"final_order_total":6972,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,60829","order_product":[],"pass":true}},"first_order_id":"4226","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> U16 <\/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.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:42:33","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",712,"NEW","A18-CT207142",1290,1162,0,0,"6","6",6972,6972,6972,"2020-02-07 16:42:33","0",null,null,null,"2020-02-15","2020-08-14","6 months contract. Storage rental paid by bank transfer on February 7, 2020. Storage deposit transferred from agreement A18-CT195856 to this agreement.\r\n","2020-02-15","16",0,null,0,"0","2","2020-02-07 16:42:32","2","2020-02-07 16:42:32","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,60829","C180712","PERSONAL","Ms","ClNQzFDQpwClMixVkzNk1w==","DC+Ldja4fOt7spvvh54SUA==","","GLrzVBwvUdSi8AKkRD2+fMrQ2vmLicKSHN5KbBYvW\/H1g3eVFoyJZhYoeO05T5oB\/kgYPoFohehx2nTZWWFQeA==","V2y9yXcL2MI0Nv19Uy4QVQ==","4z1Ydn8ZwxbNTAQEdVfzGAW+4ZGfE8qzvcxBOpVy9XQ=","NAqAbHRW7He3cx3N8A+ffA==",null,1,"4226"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:42:33","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":["7142","250","91","915","%","10.00",129,"2","2020-02-07 16:42:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:42:33","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":["7142","915","1290.0",1161,"2","2020-02-07 16:42:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:42:33","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-02-15","2020-08-14","915"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-07 16:42:33","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":["7142",712,"SETTLED","A18-I207470","2020-02-07 16:42:32","2020-02-15","2","2020-02-07 16:42:32","2","2020-02-07 16:42:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:42:33","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":["7470","RENT","\u9810\u7e73\u79df\u91d1",1,1162,"MO","1",1162,"2","2020-02-07 16:42:32","2","2020-02-07 16:42:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:42:33","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":["7470","RENT","\u9810\u7e73\u79df\u91d1",2,1162,"MO","1",1162,"2","2020-02-07 16:42:32","2","2020-02-07 16:42:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:42:33","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":["7470","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-02-07 16:42:32","2","2020-02-07 16:42:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:42:33","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":["7470","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-02-07 16:42:32","2","2020-02-07 16:42:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:42:33","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":["7470","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-02-07 16:42:32","2","2020-02-07 16:42:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:42:33","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":["7470","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-02-07 16:42:32","2","2020-02-07 16:42:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:42:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6972,0,"7470"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-07 16:42:33","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":[712,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207118","2020-02-07 16:42:32",6972,"2","2020-02-07 16:42:32","2","2020-02-07 16:42:32","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:42:33","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":["7118","DEPOSIT",null,"PAID","2020-02-07 16:42:32",0,"2","2020-02-07 16:42:32","2","2020-02-07 16:42:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:42:33","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":["7118","INVOICE","7470","PAID","2020-02-07 16:42:32",6972,"2","2020-02-07 16:42:32","2","2020-02-07 16:42:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:44: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":"&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","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":712,"customer_code":"C180712","identity_type":"PERSONAL","identity_id":"P754247(3)","title":"Ms","lastname":"Clift","firstname":"Susan Brown","companyname":"","email":"sueclift@gmail.com","tel":"90491105","address":"40B, Jadewater, 238 Aberdeen Main Road, Aberdeen, 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-02-13","renew_room_key":"054,60829","renew_remark":"6 months contract. Storage rental paid by bank transfer on August 12, 2019. Storage deposit transferred from agreement A18-CT195440 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195855, \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":"901","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"901","room_code":"U02","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-02-13","rent_from":"2020-02-13","rent_to":"2020-08-12","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on February 7, 2020. Storage deposit transferred from agreement A18-CT195855 to this agreement.\r\n","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,60829","order_product":[],"pass":true}},"first_order_id":"4225","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> U02 <\/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-02-07 16:44:54","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",712,"NEW","A18-CT207143",1930,1737,0,0,"6","6",10422,10422,10422,"2020-02-07 16:44:54","0",null,null,null,"2020-02-13","2020-08-12","6 months contract. Storage rental paid by bank transfer on February 7, 2020. Storage deposit transferred from agreement A18-CT195855 to this agreement.\r\n","2020-02-13","25",0,null,0,"0","2","2020-02-07 16:44:54","2","2020-02-07 16:44:54","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,60829","C180712","PERSONAL","Ms","ClNQzFDQpwClMixVkzNk1w==","DC+Ldja4fOt7spvvh54SUA==","","GLrzVBwvUdSi8AKkRD2+fMrQ2vmLicKSHN5KbBYvW\/H1g3eVFoyJZhYoeO05T5oB\/kgYPoFohehx2nTZWWFQeA==","V2y9yXcL2MI0Nv19Uy4QVQ==","4z1Ydn8ZwxbNTAQEdVfzGAW+4ZGfE8qzvcxBOpVy9XQ=","NAqAbHRW7He3cx3N8A+ffA==",null,1,"4225"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:44:54","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":["7143","471","104","901","%","10.00",193,"2","2020-02-07 16:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:44:54","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":["7143","901","1930.0",1737,"2","2020-02-07 16:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:44:54","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-02-13","2020-08-12","901"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-07 16:44:54","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":["7143",712,"SETTLED","A18-I207471","2020-02-07 16:44:54","2020-02-13","2","2020-02-07 16:44:54","2","2020-02-07 16:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:44:54","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":["7471","RENT","\u9810\u7e73\u79df\u91d1",1,1737,"MO","1",1737,"2","2020-02-07 16:44:54","2","2020-02-07 16:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:44:54","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":["7471","RENT","\u9810\u7e73\u79df\u91d1",2,1737,"MO","1",1737,"2","2020-02-07 16:44:54","2","2020-02-07 16:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:44:54","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":["7471","RENT","\u9810\u7e73\u79df\u91d1",3,1737,"MO","1",1737,"2","2020-02-07 16:44:54","2","2020-02-07 16:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:44:54","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":["7471","RENT","\u9810\u7e73\u79df\u91d1",4,1737,"MO","1",1737,"2","2020-02-07 16:44:54","2","2020-02-07 16:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:44:54","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":["7471","RENT","\u9810\u7e73\u79df\u91d1",5,1737,"MO","1",1737,"2","2020-02-07 16:44:54","2","2020-02-07 16:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:44:54","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":["7471","RENT","\u9810\u7e73\u79df\u91d1",6,1737,"MO","1",1737,"2","2020-02-07 16:44:54","2","2020-02-07 16:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:44:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10422,0,"7471"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-07 16:44:54","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":[712,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207119","2020-02-07 16:44:54",10422,"2","2020-02-07 16:44:54","2","2020-02-07 16:44:54","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:44:54","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":["7119","DEPOSIT",null,"PAID","2020-02-07 16:44:54",0,"2","2020-02-07 16:44:54","2","2020-02-07 16:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 16:44:54","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":["7119","INVOICE","7471","PAID","2020-02-07 16:44:54",10422,"2","2020-02-07 16:44:54","2","2020-02-07 16:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 17:01:53","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":696,"customer_code":"C180696","identity_type":"PERSONAL","identity_id":"A885242(4)","title":"Ms","lastname":"Lee","firstname":"Sheung King Susanna","companyname":"","email":"smartyleehk@yahoo.com","tel":"61078166","address":"Flat 1, G\/F, Tin Fai House, Yue Fai Court, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1135.0","renew_rent_month":"3","renew_warehousing_date":"2020-02-07","renew_room_key":"054,20651","renew_remark":"3 months contract. Storage rental paid by bank transfer on November 9, 2019. Storage deposit transferred from agreement A18-CT195788 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196367, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"88","order_discount":[],"order_room":[{"room_id":"926","room_code":"U27","retail_price":"1195.0","discounted_price":"1195.00","location_id":"3"}],"roughly_size":"15","total_retail_price":1195,"total_discounted_price":1135,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3405,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-07","rent_from":"2020-02-07","rent_to":"2020-05-06","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on February 7, 2020. Storage deposit transferred from agreement A18-CT196367 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3405,"final_order_total":3405,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,20651","order_product":[],"pass":true}},"first_order_id":"4426","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> U27 <\/td>\r\n\t\t\t\t\t 5X3X7 <\/td>\r\n\t\t\t\t\t $1195.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":"15","total_discounted_price":"1135.0","deposit":"0","total_retail_price":"1195.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 17:01:53","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",696,"NEW","A18-CT207144",1195,1135,0,0,"3","3",3405,3405,3405,"2020-02-07 17:01:53","0",null,null,null,"2020-02-07","2020-05-06","3 months contract. Storage rental paid by bank transfer on February 7, 2020. Storage deposit transferred from agreement A18-CT196367 to this agreement.\r\n","2020-02-07","15",0,null,0,"0","2","2020-02-07 17:01:52","2","2020-02-07 17:01:52","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,20651","C180696","PERSONAL","Ms","lUUgSqiO+3UfkBqsAoZcOIMXrzpK0Yrf\/\/Tskggn5OY=","kiriEIqhcx866RNZiMXdKQ==","","wbDuUqfTidJv1h01201xU8gFUWgLug2G5kn12AU51ASLzDUuPdgGwRE7nJizRWNsgxWjbU12WRi\/SWy+If7DTQ==","n++DQL9\/RTIOCwM9RgoxHg==","FSzM\/bOuWmiXsTeEFVthPnIVOHnDgw5qifiOLfY8cmU=","3\/z4\/6NRZprrf5\/EjtdVNQ==",null,1,"4426"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 17:01:53","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":["7144","926","1195.0","1195.00","2","2020-02-07 17:01:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 17:01:53","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-02-07","2020-05-06","926"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-07 17:01:53","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":["7144",696,"SETTLED","A18-I207472","2020-02-07 17:01:52","2020-02-07","2","2020-02-07 17:01:52","2","2020-02-07 17:01:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 17:01:53","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":["7472","RENT","\u9810\u7e73\u79df\u91d1",1,1135,"MO","1",1135,"2","2020-02-07 17:01:52","2","2020-02-07 17:01:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 17:01:53","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":["7472","RENT","\u9810\u7e73\u79df\u91d1",2,1135,"MO","1",1135,"2","2020-02-07 17:01:52","2","2020-02-07 17:01:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 17:01:53","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":["7472","RENT","\u9810\u7e73\u79df\u91d1",3,1135,"MO","1",1135,"2","2020-02-07 17:01:52","2","2020-02-07 17:01:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 17:01:53","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3405,0,"7472"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-07 17:01:53","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":[696,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207120","2020-02-07 17:01:52",3405,"2","2020-02-07 17:01:52","2","2020-02-07 17:01:52","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 17:01:53","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":["7120","DEPOSIT",null,"PAID","2020-02-07 17:01:52",0,"2","2020-02-07 17:01:52","2","2020-02-07 17:01:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 17:01:53","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":["7120","INVOICE","7472","PAID","2020-02-07 17:01:52",3405,"2","2020-02-07 17:01:52","2","2020-02-07 17:01:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 17:42:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-07 18:36:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****