{"created_at":"2020-06-16 10:06:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 10:16:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 10:19:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 10:20:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 10:20:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 10:21:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 10:27: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":"filter1=0&filter2=7271&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1128,"customer_code":"C181128","identity_type":"PERSONAL","identity_id":"D693697(1)","title":"Mr","lastname":"Cheung","firstname":"Yiu Chung","companyname":"","email":"vincent_cheung1207@yahoo.com.hk","tel":"96264550","address":"Rm 1714, Wah Hing House, Wah Fu Est. H.K.","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"689.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-28","renew_room_key":"189,02161","renew_remark":"6 months contract, storage rental paid by cash on Dec 07,2019; Deposit $1550 transferred from agreement A12-CT183776 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196625, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"2","order_discount":[{"master_room_discount_id":"60","master_room_id":"2","discount_type":"%","price":"814.00","disocunted_price":"732.60","discount":"10.00","monthly_deduct":81.4,"room_id":"299","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"299","room_code":"E26","retail_price":"814.0","discounted_price":732.6,"location_id":"1"}],"roughly_size":"9","total_retail_price":814,"total_discounted_price":689,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":4134,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-28","rent_from":"2020-05-28","rent_to":"2020-11-27","delivery_service":"0","remark":"6 months contract, storage rental paid by cash on JUNE 16,2020; Deposit $1550 transferred from agreement A12-CT196625 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":4134,"final_order_total":4134,"location_id":"1","branch_id":"1","company_id":"1","room_key":"189,02161","order_product":[],"pass":true}},"first_order_id":"3776","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>
E26 <\/td>\r\n\t\t\t\t\t	3X3X8 <\/td>\r\n\t\t\t\t\t	$814.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":"9","total_discounted_price":"689.0","deposit":"0","total_retail_price":"814.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 10:27:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",1128,"NEW","A12-CT208142",814,689,0,0,"6","6",4134,4134,4134,"2020-06-16 10:27:55","0",null,null,null,"2020-05-28","2020-11-27","6 months contract, storage rental paid by cash on JUNE 16,2020; Deposit $1550 transferred from agreement A12-CT196625 to this agreement.","2020-05-28","9",0,null,0,"0","2","2020-06-16 10:27:54","2","2020-06-16 10:27:54","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"189,02161","C181128","PERSONAL","Mr","NULh+sl2lJu5iiFCcrRT8w==","vCxOlXQuvOQaoL822H2o\/Q==","","0Wo4YbB5nah1HkbAgepLO22c7gWx2GVI164ijFtcFY0HFk+16jodIsuaV70S8s45","GmP73ZMJGut+JjoxWeiKeQ==","UfP9y7Wiv9rHXwCjc5e+M2ymk2sXUqxQm9P65GPPWaw=","FAsq55gWbL6qPzlzlmfzFg==",null,1,"3776"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 10:27:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["8142","60","2","299","%","10.00",81.4,"2","2020-06-16 10:27:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 10:27:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8142","299","814.0",732.6,"2","2020-06-16 10:27:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 10:27:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-28","2020-11-27","299"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-16 10:27:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8142",1128,"SETTLED","A12-I208471","2020-06-16 10:27:54","2020-05-28","2","2020-06-16 10:27:54","2","2020-06-16 10:27:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 10:27:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8471","RENT","\u9810\u7e73\u79df\u91d1",1,689,"MO","1",689,"2","2020-06-16 10:27:54","2","2020-06-16 10:27:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 10:27:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8471","RENT","\u9810\u7e73\u79df\u91d1",2,689,"MO","1",689,"2","2020-06-16 10:27:54","2","2020-06-16 10:27:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 10:27:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8471","RENT","\u9810\u7e73\u79df\u91d1",3,689,"MO","1",689,"2","2020-06-16 10:27:54","2","2020-06-16 10:27:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 10:27:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8471","RENT","\u9810\u7e73\u79df\u91d1",4,689,"MO","1",689,"2","2020-06-16 10:27:54","2","2020-06-16 10:27:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 10:27:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8471","RENT","\u9810\u7e73\u79df\u91d1",5,689,"MO","1",689,"2","2020-06-16 10:27:54","2","2020-06-16 10:27:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 10:27:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8471","RENT","\u9810\u7e73\u79df\u91d1",6,689,"MO","1",689,"2","2020-06-16 10:27:54","2","2020-06-16 10:27:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 10:27:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4134,0,"8471"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-16 10:27:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1128,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P208114","2020-06-16 10:27:54",4134,"2","2020-06-16 10:27:54","2","2020-06-16 10:27:54","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 10:27:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8114","DEPOSIT",null,"PAID","2020-06-16 10:27:54",0,"2","2020-06-16 10:27:54","2","2020-06-16 10:27:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 10:27:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8114","INVOICE","8471","PAID","2020-06-16 10:27:54",4134,"2","2020-06-16 10:27:54","2","2020-06-16 10:27:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 11:03:06","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 11:20: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&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":431,"customer_code":"C170431","identity_type":"PERSONAL","identity_id":"D413337(5)","title":"Ms","lastname":"Wu","firstname":"Yuen Fong","companyname":"","email":null,"tel":"93139577","address":"\u7f6e\u5bcc\u82b1\u571210\u5ea718\u6a13A\u5ba4","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1198.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-12","renew_room_key":"136,17013","renew_remark":"1 month contract. Storage rental paid by cheque on May 26, 2020. Storage deposit transferred from agreement A14-CT207673 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207963, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"30","order_discount":[],"order_room":[{"room_id":"648","room_code":"M59","retail_price":"775.0","discounted_price":"775.00","location_id":"2"},{"room_id":"634","room_code":"M45","retail_price":"775.0","discounted_price":"775.00","location_id":"2"}],"roughly_size":"18","total_retail_price":1550,"total_discounted_price":1198,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1198,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-12","rent_from":"2020-06-12","rent_to":"2020-07-11","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on JUNE 11, 2020. Storage deposit transferred from agreement A14-CT207963 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1198,"final_order_total":1198,"location_id":"2","branch_id":"1","company_id":"1","room_key":"136,17013","order_product":[],"pass":true}},"first_order_id":"4768","selected_room_tr":"	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> M59 <\/td>\r\n\t\t\t\t\t 3X3X8 <\/td>\r\n\t\t\t\t\t $775.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> M45 <\/td>\r\n\t\t\t\t\t 3X3X8 <\/td>\r\n\t\t\t\t\t $775.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"18","total_discounted_price":"1198.0","deposit":"0","total_retail_price":"1550.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 11:20:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",431,"NEW","A14-CT208143",1550,1198,0,0,"1","1",1198,1198,1198,"2020-06-16 11:20:26","0",null,null,null,"2020-06-12","2020-07-11","1 month contract. Storage rental paid by bank transfer on JUNE 11, 2020. Storage deposit transferred from agreement A14-CT207963 to this agreement.","2020-06-12","18",0,null,0,"0","2","2020-06-16 11:20:26","2","2020-06-16 11:20:26","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,17013","C170431","PERSONAL","Ms","UxlXQiCLdPwPautaCTB+Hw==","6BZ3jKM7u1vzGCs7Yb+Ugw==","","n4HXLIkQV7R3SmsiP7KfX4xGRy\/8rX+8EebxY4Sn+pQ=","\/5Bh87k0zl6kketxJ3ZvuA==",null,"eYnja6hmcz0ZXhSZIkdH7w==",null,1,"4768"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 11:20:26","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":["8143","648","775.0","775.00","2","2020-06-16 11:20:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 11:20:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-12","2020-07-11","648"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-16 11:20:26","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":["8143","634","775.0","775.00","2","2020-06-16 11:20:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 11:20:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-12","2020-07-11","634"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-16 11:20:26","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":["8143",431,"SETTLED","A14-I208472","2020-06-16 11:20:26","2020-06-12","2","2020-06-16 11:20:26","2","2020-06-16 11:20:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 11:20:26","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":["8472","RENT","\u9810\u7e73\u79df\u91d1",1,1198,"MO","1",1198,"2","2020-06-16 11:20:26","2","2020-06-16 11:20:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 11:20:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1198,0,"8472"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-16 11:20:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[431,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208115","2020-06-16 11:20:26",1198,"2","2020-06-16 11:20:26","2","2020-06-16 11:20:26","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 11:20:26","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":["8115","DEPOSIT",null,"PAID","2020-06-16 11:20:26",0,"2","2020-06-16 11:20:26","2","2020-06-16 11:20:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 11:20:26","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":["8115","INVOICE","8472","PAID","2020-06-16 11:20:26",1198,"2","2020-06-16 11:20:26","2","2020-06-16 11:20:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 11:22:38","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":431,"customer_code":"C170431","identity_type":"PERSONAL","identity_id":"D413337(5)","title":"Ms","lastname":"Wu","firstname":"Yuen Fong","companyname":"","email":null,"tel":"93139577","address":"\u7f6e\u5bcc\u82b1\u571210\u5ea718\u6a13A\u5ba4","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-13","renew_room_key":"072,48391","renew_remark":"1 month contract. Storage rental paid by cheque on May 26, 2020. Storage deposit transferred from agreement A14-CT207674 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207962, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"633","room_code":"M44","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-13","rent_from":"2020-06-13","rent_to":"2020-07-12","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on JUNE 11, 2020. Storage deposit transferred from agreement A14-CT207962 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"072,48391","order_product":[],"pass":true}},"first_order_id":"4767","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> M44 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 11:22:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",431,"NEW","A14-CT208144",598,598,0,0,"1","1",598,598,598,"2020-06-16 11:22:38","0",null,null,null,"2020-06-13","2020-07-12","1 month contract. Storage rental paid by bank transfer on JUNE 11, 2020. Storage deposit transferred from agreement A14-CT207962 to this agreement.","2020-06-13","12",0,null,0,"0","2","2020-06-16 11:22:38","2","2020-06-16 11:22:38","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"072,48391","C170431","PERSONAL","Ms","UxlXQiCLdPwPautaCTB+Hw==","6BZ3jKM7u1vzGCs7Yb+Ugw==","","n4HXLIkQV7R3SmsiP7KfX4xGRy\/8rX+8EebxY4Sn+pQ=","\/5Bh87k0zl6kketxJ3ZvuA==",null,"eYnja6hmcz0ZXhSZIkdH7w==",null,1,"4767"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 11:22:38","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":["8144","633","598.0","598.00","2","2020-06-16 11:22:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 11:22:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-13","2020-07-12","633"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-16 11:22:38","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":["8144",431,"SETTLED","A14-I208473","2020-06-16 11:22:38","2020-06-13","2","2020-06-16 11:22:38","2","2020-06-16 11:22:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 11:22:38","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":["8473","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-06-16 11:22:38","2","2020-06-16 11:22:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 11:22:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8473"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-16 11:22:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[431,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208116","2020-06-16 11:22:38",598,"2","2020-06-16 11:22:38","2","2020-06-16 11:22:38","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 11:22:38","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":["8116","DEPOSIT",null,"PAID","2020-06-16 11:22:38",0,"2","2020-06-16 11:22:38","2","2020-06-16 11:22:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 11:22:38","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":["8116","INVOICE","8473","PAID","2020-06-16 11:22:38",598,"2","2020-06-16 11:22:38","2","2020-06-16 11:22:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 11:23:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 11:32:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 12:35:06","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 13:34:01","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 13:37:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 13:57:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 13:57: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":"filter1=2&filter2=612&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1542","master_room_id":"201","room_code":"A16-051"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A16-051 <\/td>\r\n\t\t\t\t\t 4X3X7 <\/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","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"K144531(6)","title":"Mr","lastname":"HO","firstname":"Chung Fai","companyname":"","email":"ianchungfai@yahoo.com.hk","tel":"97870304","address":"Flat F, 15\/F, Comfort Centre, 108 Old Main Street, Aberdeen, H.K.","pass":true,"customer_id":"1612","customer_code":"C201612","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1542","room_code":"A16-051","retail_price":"1090.0","discounted_price":"1090.00","location_id":"7"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":1090,"deposit":2180,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":12644,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3706.00","warehousing_date":"2020-06-16","rent_from":"2020-06-16","rent_to":"2021-07-15","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free and 50% off for the first 3 months. Storage rental and deposit paid by credit card on June 16, 2020. Padlock provided on June 8, 2020. 3% credit card additional charge $379. ","paymethod":"CREDIT_CARD","paymethod2":"CREDIT_CARD","discount_deduct":3706,"order_total":16350,"final_order_total":12644,"location_id":"7","branch_id":"1","company_id":"1","room_key":"'0012398480","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"1090.00","deposit":"2180.00","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 13:57:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7","1612","NEW","A16-CT208145",1090,1090,2180,0,"13","13",12644,16350,12644,"2020-06-16 13:57:41","0",null,null,null,"2020-06-16","2021-07-15","13 months contract. Special offer the 13th month free and 50% off for the first 3 months. Storage rental and deposit paid by credit card on June 16, 2020. Padlock provided on June 8, 2020. 3% credit card additional charge $379. ","2020-06-16","12",0,null,3706,"3706.00","2","2020-06-16 13:57:40","2","2020-06-16 13:57:40","CREDIT_CARD","","","","CREDIT_CARD","","","",null,0,"'0012398480","C201612","PERSONAL","Mr","8+otsFWBUC8WFepvKI7Dew==","Zzv1eRCimQisUlUlw\/fpjg==","","05bGvfHWxhV0Sfxkrse5cyVZsIQE4QqgD\/BNPqipwE\/dKgGjCBtbzaHU6PQel8dOzEESIL0I9R3vWFxI4HbszKNEM9scPUKzcffZwX3Q0nQ=","rllNUQXT049sFETPjtczjg==","nqjeqHyjBPEEd7fl6wU+2dSytG3d90gvrOVoAbw\/FeA=","LfX6ES4t9QoR33w0SR5pBA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 13:57:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8145","1542","1090.0","1090.00","2","2020-06-16 13:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 13:57:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-16","2021-07-15","1542"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-16 13:57:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["8145","A16-D205475","PAID",2180,0,"2021-07-15","2020-06-16 13:57:40","2020-06-16 13:57:40","2","2020-06-16 13:57:40","2","2020-06-16 13:57:40","1612"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 13:57:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8145","1612","SETTLED","A16-I208474","2020-06-16 13:57:40","2020-06-16","2","2020-06-16 13:57:40","2","2020-06-16 13:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 13:57:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8474","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-16 13:57:40","2","2020-06-16 13:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 13:57:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8474","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-06-16 13:57:40","2","2020-06-16 13:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 13:57:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8474","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,0,"MO","1",0,"2","2020-06-16 13:57:40","2","2020-06-16 13:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 13:57:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8474","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",4,654,"MO","1",654,"2","2020-06-16 13:57:40","2","2020-06-16 13:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 13:57:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8474","RENT","\u9810\u7e73\u79df\u91d1",5,1090,"MO","1",1090,"2","2020-06-16 13:57:40","2","2020-06-16 13:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 13:57:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8474","RENT","\u9810\u7e73\u79df\u91d1",6,1090,"MO","1",1090,"2","2020-06-16 13:57:40","2","2020-06-16 13:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 13:57:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8474","RENT","\u9810\u7e73\u79df\u91d1",7,1090,"MO","1",1090,"2","2020-06-16 13:57:40","2","2020-06-16 13:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 13:57:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8474","RENT","\u9810\u7e73\u79df\u91d1",8,1090,"MO","1",1090,"2","2020-06-16 13:57:40","2","2020-06-16 13:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 13:57:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8474","RENT","\u9810\u7e73\u79df\u91d1",9,1090,"MO","1",1090,"2","2020-06-16 13:57:40","2","2020-06-16 13:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 13:57:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8474","RENT","\u9810\u7e73\u79df\u91d1",10,1090,"MO","1",1090,"2","2020-06-16 13:57:40","2","2020-06-16 13:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 13:57:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8474","RENT","\u9810\u7e73\u79df\u91d1",11,1090,"MO","1",1090,"2","2020-06-16 13:57:40","2","2020-06-16 13:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 13:57:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8474","RENT","\u9810\u7e73\u79df\u91d1",12,1090,"MO","1",1090,"2","2020-06-16 13:57:40","2","2020-06-16 13:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 13:57:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8474","RENT","\u9810\u7e73\u79df\u91d1",13,1090,"MO","1",1090,"2","2020-06-16 13:57:40","2","2020-06-16 13:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 13:57:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10464,0,"8474"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-16 13:57: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":["1612","CREDIT_CARD","","","","CREDIT_CARD","","","","PAID","P208117","2020-06-16 13:57:40",12644,"2","2020-06-16 13:57:40","2","2020-06-16 13:57:40","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 13:57: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":["8117","DEPOSIT","5475","PAID","2020-06-16 13:57:40",2180,"2","2020-06-16 13:57:40","2","2020-06-16 13:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 13:57: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":["8117","INVOICE","8474","PAID","2020-06-16 13:57:40",10464,"2","2020-06-16 13:57:40","2","2020-06-16 13:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:05:10","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","'0012398480; '0012415302","13 months contract. Special offer the 13th month free and 50% off for the first 3 months. Storage rental and deposit paid by credit card on June 16, 2020. Padlock provided on June 8, 2020. 3% credit card additional charge $379. ","2020-06-16 14:05:10","2","Zzv1eRCimQisUlUlw\/fpjg==","8+otsFWBUC8WFepvKI7Dew==","nqjeqHyjBPEEd7fl6wU+2dSytG3d90gvrOVoAbw\/FeA=","rllNUQXT049sFETPjtczjg==","05bGvfHWxhV0Sfxkrse5cyVZsIQE4QqgD\/BNPqipwE\/dKgGjCBtbzaHU6PQel8dOzEESIL0I9R3vWFxI4HbszKNEM9scPUKzcffZwX3Q0nQ=",8145]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:19:03","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":"","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":273,"customer_code":"C170273","identity_type":"PERSONAL","identity_id":"M432924(A)","title":"Mr","lastname":"Ye","firstname":"Xiaodong","companyname":"","email":null,"tel":"64330476","address":"\u6df1\u5733\u5e02\u7f85\u6e56\u7f85\u82b3\u6751641\u865f","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"6","renew_warehousing_date":"2020-07-17","renew_room_key":"133,50419,076,34754","renew_remark":"6 months contract. Storage rental paid by cash on Jan 13, 2020. Storage deposit transferred from agreement A12-CT195482 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT206940, \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":"38","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"38","room_code":"A38","retail_price":"1098.0","discounted_price":989,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":935,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5610,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-17","rent_from":"2020-07-17","rent_to":"2021-01-16","delivery_service":"0","remark":"6 months contract. Storage rental paid by cash on June 16, 2020. Storage deposit transferred from agreement A12-CT206940 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":5610,"final_order_total":5610,"location_id":"1","branch_id":"1","company_id":"1","room_key":"133,50419,076,34754","order_product":[],"pass":true}},"first_order_id":"4175","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> A38 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"935.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:19:03","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",273,"NEW","A12-CT208146",1098,935,0,0,"6","6",5610,5610,5610,"2020-06-16 14:19:03","0",null,null,null,"2020-07-17","2021-01-16","6 months contract. Storage rental paid by cash on June 16, 2020. Storage deposit transferred from agreement A12-CT206940 to this agreement.\r\n","2020-07-17","16",0,null,0,"0","2","2020-06-16 14:19:03","2","2020-06-16 14:19:03","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"133,50419,076,34754","C170273","PERSONAL","Mr","\/r+nw+Hrwr71g2M2LIxhog==","j4rd614DPInD4J8v51pwNQ==","","7vj0H72vjkFMWgxfv67tgrC\/+xkA9o1PyCaKRXLdncQ=","7Zmx0g\/HDuZGW5h5ebP8gQ==",null,"vNoJv2kv\/w7WxmBjh1Rztg==",null,1,"4175"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:19:03","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":["8146","72","8","38","%","9.93",109.0314,"2","2020-06-16 14:19:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:19:03","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":["8146","38","1098.0",989,"2","2020-06-16 14:19:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:19:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-17","2021-01-16","38"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-16 14:19:03","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":["8146",273,"SETTLED","A12-I208475","2020-06-16 14:19:03","2020-07-17","2","2020-06-16 14:19:03","2","2020-06-16 14:19:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:19:03","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":["8475","RENT","\u9810\u7e73\u79df\u91d1",1,935,"MO","1",935,"2","2020-06-16 14:19:03","2","2020-06-16 14:19:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:19:03","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":["8475","RENT","\u9810\u7e73\u79df\u91d1",2,935,"MO","1",935,"2","2020-06-16 14:19:03","2","2020-06-16 14:19:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:19:03","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":["8475","RENT","\u9810\u7e73\u79df\u91d1",3,935,"MO","1",935,"2","2020-06-16 14:19:03","2","2020-06-16 14:19:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:19:03","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":["8475","RENT","\u9810\u7e73\u79df\u91d1",4,935,"MO","1",935,"2","2020-06-16 14:19:03","2","2020-06-16 14:19:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:19:03","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":["8475","RENT","\u9810\u7e73\u79df\u91d1",5,935,"MO","1",935,"2","2020-06-16 14:19:03","2","2020-06-16 14:19:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:19:03","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":["8475","RENT","\u9810\u7e73\u79df\u91d1",6,935,"MO","1",935,"2","2020-06-16 14:19:03","2","2020-06-16 14:19:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:19:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5610,0,"8475"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-16 14:19:03","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":[273,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P208118","2020-06-16 14:19:03",5610,"2","2020-06-16 14:19:03","2","2020-06-16 14:19:03","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:19:03","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":["8118","DEPOSIT",null,"PAID","2020-06-16 14:19:03",0,"2","2020-06-16 14:19:03","2","2020-06-16 14:19:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:19:03","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":["8118","INVOICE","8475","PAID","2020-06-16 14:19:03",5610,"2","2020-06-16 14:19:03","2","2020-06-16 14:19:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:42:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:46:18","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"1711","master_room_id":"204","room_code":"A16-220"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A16-220 <\/td>\r\n\t\t\t\t\t 4X5X7 <\/td>\r\n\t\t\t\t\t $1605.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"M818501(3)","title":"Mr","lastname":"Ming","firstname":"Lei","companyname":"","email":"Cloudymyeong@gmail.com","tel":"91427133","address":"22A Cheong Kat Mansion, no 98-100 Catchick Road, Kennedy Town, H.K","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1711","room_code":"A16-220","retail_price":"1605.0","discounted_price":"1605.00","location_id":"7"}],"roughly_size":"12","total_retail_price":1605,"total_discounted_price":1138,"deposit":2276,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":7058,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2046","warehousing_date":"2020-06-17","rent_from":"2020-06-17","rent_to":"2020-12-16","delivery_service":"0","remark":"6 months contract. Special offer first 3months 50% off. Smart Card provided on JUNE 16, 2020. Paid by post-dated 6 cheque for 6 months on JUNE 16, 2020. ","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":2046,"order_total":9104,"final_order_total":7058,"location_id":"7","branch_id":"1","company_id":"1","room_key":"\u2018189,51775","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"1138","deposit":"2276","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:46:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201627","PERSONAL","Mr","mPtfLVPAqbL7WABBq+ZU4g==","j5L6y1rEsPOpLa1ytUjFJw==","","NLPapEWtDjBEC8\/KQlkw+g==","YWqShxH8VWD40id9gc1wXFMKO+9iL0qnk6CeLTgFIT0=","7qT\/cQXrxQSmY+tgdkjgsOV5Lol6\/c1FyyoRRbI76\/KpNgc8lXFTk7+dbTL\/yLFwhDFbu4bxtFBjZf0qNzPCcEjwA9Q6wBrFTtTdZHHE3is=","KJK6wekz4RjKnTQqCU46CA==",null,"YWqShxH8VWD40id9gc1wXFMKO+9iL0qnk6CeLTgFIT0=","sF7xGv3OHI3Z5UIN+shLXg==","2","2020-06-16 14:46:18","2","2020-06-16 14:46:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:46:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7",1627,"NEW","A16-CT208147",1605,1138,2276,0,"6","6",7058,9104,7058,"2020-06-16 14:46:19","0",null,null,null,"2020-06-17","2020-12-16","6 months contract. Special offer first 3months 50% off. Smart Card provided on JUNE 16, 2020. Paid by post-dated 6 cheque for 6 months on JUNE 16, 2020. ","2020-06-17","12",0,null,2046,"2046","2","2020-06-16 14:46:18","2","2020-06-16 14:46:18","CHEQUE","","","","CHEQUE","","","",null,0,"\u2018189,51775","C201627","PERSONAL","Mr","mPtfLVPAqbL7WABBq+ZU4g==","j5L6y1rEsPOpLa1ytUjFJw==","","7qT\/cQXrxQSmY+tgdkjgsOV5Lol6\/c1FyyoRRbI76\/KpNgc8lXFTk7+dbTL\/yLFwhDFbu4bxtFBjZf0qNzPCcEjwA9Q6wBrFTtTdZHHE3is=","NLPapEWtDjBEC8\/KQlkw+g==","YWqShxH8VWD40id9gc1wXFMKO+9iL0qnk6CeLTgFIT0=","KJK6wekz4RjKnTQqCU46CA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:46:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8147","1711","1605.0","1605.00","2","2020-06-16 14:46:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:46:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-17","2020-12-16","1711"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-16 14:46:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["8147","A16-D205476","PAID",2276,0,"2020-12-16","2020-06-16 14:46:18","2020-06-16 14:46:18","2","2020-06-16 14:46:18","2","2020-06-16 14:46:18",1627]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:46:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8147",1627,"SETTLED","A16-I208476","2020-06-16 14:46:18","2020-06-17","2","2020-06-16 14:46:18","2","2020-06-16 14:46:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:46:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8476","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-16 14:46:18","2","2020-06-16 14:46:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:46:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8476","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,230,"MO","1",230,"2","2020-06-16 14:46:18","2","2020-06-16 14:46:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:46:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8476","RENT","\u9810\u7e73\u79df\u91d1",3,1138,"MO","1",1138,"2","2020-06-16 14:46:18","2","2020-06-16 14:46:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:46:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8476","RENT","\u9810\u7e73\u79df\u91d1",4,1138,"MO","1",1138,"2","2020-06-16 14:46:18","2","2020-06-16 14:46:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:46:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8476","RENT","\u9810\u7e73\u79df\u91d1",5,1138,"MO","1",1138,"2","2020-06-16 14:46:18","2","2020-06-16 14:46:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:46:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8476","RENT","\u9810\u7e73\u79df\u91d1",6,1138,"MO","1",1138,"2","2020-06-16 14:46:18","2","2020-06-16 14:46:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:46:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4782,0,"8476"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-16 14:46:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1627,"CHEQUE","","","","CHEQUE","","","","PAID","P208119","2020-06-16 14:46:18",7058,"2","2020-06-16 14:46:18","2","2020-06-16 14:46:18","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:46:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8119","DEPOSIT","5476","PAID","2020-06-16 14:46:18",2276,"2","2020-06-16 14:46:18","2","2020-06-16 14:46:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:46:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8119","INVOICE","8476","PAID","2020-06-16 14:46:18",4782,"2","2020-06-16 14:46:18","2","2020-06-16 14:46:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 14:51:01","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 15:12:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 15:53:51","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 16:20:28","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"656","master_room_id":"30","room_code":"M67"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> M67 <\/td>\r\n\t\t\t\t\t 3X3X8 <\/td>\r\n\t\t\t\t\t $775.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"Y466568(4)","title":"Ms","lastname":"IP","firstname":"Lee Kwan","companyname":"","email":"ilk_lilian@live.hk","tel":"51676798","address":"Flat 1303, 13\/F, Pik Shan House, Shek Pai Wan Estate, Aberdeen, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"656","room_code":"M67","retail_price":"775.0","discounted_price":"775.00","location_id":"2"}],"roughly_size":"9","total_retail_price":775,"total_discounted_price":775,"deposit":1550,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":8995,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1855.00","warehousing_date":"2020-06-18","rent_from":"2020-06-18","rent_to":"2021-06-17","delivery_service":"0","remark":"12 months contract. Special offer 50% off for the first 3 months based on the original price. Storage rental and deposit paid by EPS on June 16,2020. Smart card provided on the same day.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":1855,"order_total":10850,"final_order_total":8995,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,47791","order_product":[],"pass":true}},"roughly_size":"9","total_discounted_price":"775.00","deposit":"1550.00","total_retail_price":"775.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 16:20:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201628","PERSONAL","Ms","4frM6zN9ED77bjdMNmetWg==","BxzCT5OGas7BCbwmbXAF7w==","","OT+R2OJv2zNjnDLpng9Hcg==","pQTm9MDd1jDm\/twxK35DfAqSHYNQTv7oYhrYNl5Bx68=","rAkzlTL6sRQHhz4569LxQTyIBVnI6DoGFmQeuiGL+BzXSRN3nYqTSTjLkIJDGJ9a0oxjeAFmt8MAM33MV6hGqPG9teHEQmBRl0Icznl8i4w=","PzeTu3Nv5ef66LRzZ9oYbA==",null,"pQTm9MDd1jDm\/twxK35DfAqSHYNQTv7oYhrYNl5Bx68=","iCHlsZ74MPQBos31R7mIyg==","2","2020-06-16 16:20:28","2","2020-06-16 16:20:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 16:20:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2",1628,"NEW","A14-CT208148",775,775,1550,0,"12","12",8995,10850,8995,"2020-06-16 16:20:30","0",null,null,null,"2020-06-18","2021-06-17","12 months contract. Special offer 50% off for the first 3 months based on the original price. Storage rental and deposit paid by EPS on June 16,2020. Smart card provided on the same day.","2020-06-18","9",0,null,1855,"1855.00","2","2020-06-16 16:20:28","2","2020-06-16 16:20:28","EPS","","","","EPS","","","",null,0,"076,47791","C201628","PERSONAL","Ms","4frM6zN9ED77bjdMNmetWg==","BxzCT5OGas7BCbwmbXAF7w==","","rAkzlTL6sRQHhz4569LxQTyIBVnI6DoGFmQeuiGL+BzXSRN3nYqTSTjLkIJDGJ9a0oxjeAFmt8MAM33MV6hGqPG9teHEQmBRl0Icznl8i4w=","OT+R2OJv2zNjnDLpng9Hcg==","pQTm9MDd1jDm\/twxK35DfAqSHYNQTv7oYhrYNl5Bx68=","PzeTu3Nv5ef66LRzZ9oYbA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 16:20:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8148","656","775.0","775.00","2","2020-06-16 16:20:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 16:20:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-18","2021-06-17","656"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-16 16:20:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["8148","A14-D205477","PAID",1550,0,"2021-06-17","2020-06-16 16:20:28","2020-06-16 16:20:28","2","2020-06-16 16:20:28","2","2020-06-16 16:20:28",1628]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 16:20:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8148",1628,"SETTLED","A14-I208477","2020-06-16 16:20:28","2020-06-18","2","2020-06-16 16:20:28","2","2020-06-16 16:20:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 16:20:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8477","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-16 16:20:28","2","2020-06-16 16:20:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 16:20:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8477","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-06-16 16:20:28","2","2020-06-16 16:20:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 16:20:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8477","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,470,"MO","1",470,"2","2020-06-16 16:20:28","2","2020-06-16 16:20:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 16:20:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8477","RENT","\u9810\u7e73\u79df\u91d1",4,775,"MO","1",775,"2","2020-06-16 16:20:28","2","2020-06-16 16:20:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 16:20:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8477","RENT","\u9810\u7e73\u79df\u91d1",5,775,"MO","1",775,"2","2020-06-16 16:20:28","2","2020-06-16 16:20:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 16:20:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8477","RENT","\u9810\u7e73\u79df\u91d1",6,775,"MO","1",775,"2","2020-06-16 16:20:28","2","2020-06-16 16:20:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 16:20:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8477","RENT","\u9810\u7e73\u79df\u91d1",7,775,"MO","1",775,"2","2020-06-16 16:20:28","2","2020-06-16 16:20:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 16:20:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8477","RENT","\u9810\u7e73\u79df\u91d1",8,775,"MO","1",775,"2","2020-06-16 16:20:28","2","2020-06-16 16:20:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 16:20:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8477","RENT","\u9810\u7e73\u79df\u91d1",9,775,"MO","1",775,"2","2020-06-16 16:20:28","2","2020-06-16 16:20:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 16:20:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8477","RENT","\u9810\u7e73\u79df\u91d1",10,775,"MO","1",775,"2","2020-06-16 16:20:28","2","2020-06-16 16:20:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 16:20:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8477","RENT","\u9810\u7e73\u79df\u91d1",11,775,"MO","1",775,"2","2020-06-16 16:20:28","2","2020-06-16 16:20:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 16:20:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8477","RENT","\u9810\u7e73\u79df\u91d1",12,775,"MO","1",775,"2","2020-06-16 16:20:28","2","2020-06-16 16:20:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 16:20:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7445,0,"8477"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-16 16:20:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1628,"EPS","","","","EPS","","","","PAID","P208120","2020-06-16 16:20:28",8995,"2","2020-06-16 16:20:28","2","2020-06-16 16:20:28","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 16:20:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8120","DEPOSIT","5477","PAID","2020-06-16 16:20:28",1550,"2","2020-06-16 16:20:28","2","2020-06-16 16:20:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 16:20:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8120","INVOICE","8477","PAID","2020-06-16 16:20:28",7445,"2","2020-06-16 16:20:28","2","2020-06-16 16:20:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:14:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:29:18","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=612&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1542","master_room_id":"201","room_code":"A16-051"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1137,"customer_code":"C181137","identity_type":"PERSONAL","identity_id":"D511733(0)","title":"Ms","lastname":"Cheung","firstname":"Mei Ping","companyname":"","email":null,"tel":"54034230","address":"Flat 3, 23\/F, Block Q, Mei Fai Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-08","renew_room_key":"0007305364","renew_remark":"1 month contract. Storage rental paid by bank transfer on May 13, 2020. Storage deposit transferred from agreement A05-CT207604 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207841, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"110","order_discount":[],"order_room":[{"room_id":"1087","room_code":"A05-085","retail_price":"598.0","discounted_price":"598.00","location_id":"4"}],"roughly_size":"8","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-08","rent_from":"2020-06-08","rent_to":"2020-07-07","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on June 16, 2020. Storage deposit transferred from agreement A05-CT207841 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0007305364","order_product":[],"pass":true}},"first_order_id":"4717","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-085 <\/td>\r\n\t\t\t\t\t 4X2X3.5 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \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":"8","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:29:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1137,"NEW","A05-CT208149",598,598,0,0,"1","1",598,598,598,"2020-06-16 18:29:19","0",null,null,null,"2020-06-08","2020-07-07","1 month contract. Storage rental paid by bank transfer on June 16, 2020. Storage deposit transferred from agreement A05-CT207841 to this agreement.\r\n","2020-06-08","8",0,null,0,"0","2","2020-06-16 18:29:18","2","2020-06-16 18:29:18","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0007305364","C181137","PERSONAL","Ms","ov4itGGMhitaTATk31YbvA==","vCxOlXQuvOQaoL822H2o\/Q==","","E1vSnV3\/zTD\/COo0L4lGPzFMAscGCZXb3LMO+qHc4+tCAMOAjpkWSa444NxIRpkUETecgSZwbVUPrOe8jXLqvSR8eOGI+jndWcBFCAJnBXs=","pvHbwmM2tVjF9UsDRGbtTQ==",null,"itJoZuSGBd5W3YULMxGxDQ==",null,1,"4717"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:29:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8149","1087","598.0","598.00","2","2020-06-16 18:29:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:29:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-08","2020-07-07","1087"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-16 18:29:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8149",1137,"SETTLED","A05-I208478","2020-06-16 18:29:18","2020-06-08","2","2020-06-16 18:29:18","2","2020-06-16 18:29:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:29:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8478","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-06-16 18:29:18","2","2020-06-16 18:29:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:29:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8478"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-16 18:29:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1137,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208121","2020-06-16 18:29:18",598,"2","2020-06-16 18:29:18","2","2020-06-16 18:29:18","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:29:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8121","DEPOSIT",null,"PAID","2020-06-16 18:29:18",0,"2","2020-06-16 18:29:18","2","2020-06-16 18:29:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:29:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8121","INVOICE","8478","PAID","2020-06-16 18:29:18",598,"2","2020-06-16 18:29:18","2","2020-06-16 18:29:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:41:09","login_id":"2","controller":"room_modify.php","function":"update query","input":{"sql":"update room set code = ?, status = ?, master_room_id = ?, typeid = ?, lastupby = ?, lastupdate = ? where id = ?","parameters":["K49","OPEN","35","STORAGE","2","2020-06-16 18:41:09","512"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:41:09","login_id":"2","controller":"room_modify.php","function":"update query","input":{"sql":"update room set code = ?, status = ?, master_room_id = ?, typeid = ?, lastupby = ?, lastupdate = ? where id = ?","parameters":["K50","OPEN","35","STORAGE","2","2020-06-16 18:41:09","513"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:43:39","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=612&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1542","master_room_id":"201","room_code":"A16-051"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":448,"customer_code":"C170448","identity_type":"PERSONAL","identity_id":"Z011806(1)","title":"Mr","lastname":"Hau","firstname":"Hil Yeung","companyname":"","email":"hermannhau@gmail.com","tel":"97139457","address":"Flat H,2\/F,Block 2,Chi Fu Fa Yuen,Pok Fu Lam,Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2022.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-15","renew_room_key":"053,46811","renew_remark":"1 month contract. Storage rental paid by PPS on May 11, 2020. Storage deposit transferred from agreement A14-CT207633 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207829, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"549","room_code":"L27","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"548","room_code":"L26","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":2022,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2022,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-15","rent_from":"2020-06-15","rent_to":"2020-07-14","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on June 11, 2020. Storage deposit transferred from agreement A14-CT207829 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":2022,"final_order_total":2022,"location_id":"2","branch_id":"1","company_id":"1","room_key":"053,46811","order_product":[],"pass":true}},"first_order_id":"4790","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> L27 <\/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> L26 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"2022.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:43: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",448,"NEW","A14-CT208150",2196,2022,0,0,"1","1",2022,2022,2022,"2020-06-16 18:43:40","0",null,null,null,"2020-06-15","2020-07-14","1 month contract. Storage rental paid by PPS on June 11, 2020. Storage deposit transferred from agreement A14-CT207829 to this agreement.\r\n","2020-06-15","32",0,null,0,"0","2","2020-06-16 18:43:39","2","2020-06-16 18:43:39","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"053,46811","C170448","PERSONAL","Mr","NVv9pRh+D1VmYB2XsurgEQ==","8OcLe\/VzxU\/Xek1BNlpsfQ==","","0QpZaBXqoW5CgaBIwDwpjWtY5YJYGo9YtwWqdo6IK1Fg9YHW9ZmtiUF11gEm1OcOe3VhZDJuL+H\/IV+pZmf2Kw==","tujHTZIsGcqjKeaOnttAvg==","jGafPuxpS3yTCisx0O3a7o2TE03wjvCrNp2lr0gCkFw=","y4ZDYxl9X3dwkt7\/dDApww==",null,1,"4790"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:43: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":["8150","549","1098.0","1098.00","2","2020-06-16 18:43:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:43:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-15","2020-07-14","549"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-16 18:43: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":["8150","548","1098.0","1098.00","2","2020-06-16 18:43:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:43:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-15","2020-07-14","548"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-16 18:43: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":["8150",448,"SETTLED","A14-I208479","2020-06-16 18:43:39","2020-06-15","2","2020-06-16 18:43:39","2","2020-06-16 18:43:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:43: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":["8479","RENT","\u9810\u7e73\u79df\u91d1",1,2022,"MO","1",2022,"2","2020-06-16 18:43:39","2","2020-06-16 18:43:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:43:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2022,0,"8479"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-16 18:43:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[448,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208122","2020-06-16 18:43:39",2022,"2","2020-06-16 18:43:39","2","2020-06-16 18:43:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:43:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8122","DEPOSIT",null,"PAID","2020-06-16 18:43:39",0,"2","2020-06-16 18:43:39","2","2020-06-16 18:43:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:43:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8122","INVOICE","8479","PAID","2020-06-16 18:43:39",2022,"2","2020-06-16 18:43:39","2","2020-06-16 18:43:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:45: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":"filter1=2&filter2=612&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1542","master_room_id":"201","room_code":"A16-051"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":448,"customer_code":"C170448","identity_type":"PERSONAL","identity_id":"Z011806(1)","title":"Mr","lastname":"Hau","firstname":"Hil Yeung","companyname":"","email":"hermannhau@gmail.com","tel":"97139457","address":"Flat H,2\/F,Block 2,Chi Fu Fa Yuen,Pok Fu Lam,Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2022.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-24","renew_room_key":"053,46811","renew_remark":"1 month contract. Special offer $2022\/month. Storage rental $2022 paid by PPS on May 11, 2020. Storage deposit $4636 transferred from agreement A14-CT207634 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207828, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"535","room_code":"L13","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"536","room_code":"L14","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":2022,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2022,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-24","rent_from":"2020-06-24","rent_to":"2020-07-23","delivery_service":"0","remark":"1 month contract. Special offer $2022\/month. Storage rental $2022 paid by PPS on June 11, 2020. Storage deposit $4636 transferred from agreement A14-CT207828 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":2022,"final_order_total":2022,"location_id":"2","branch_id":"1","company_id":"1","room_key":"053,46811","order_product":[],"pass":true}},"first_order_id":"7481","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> L13 <\/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> L14 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"2022.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:45:58","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",448,"NEW","A14-CT208151",2196,2022,0,0,"1","1",2022,2022,2022,"2020-06-16 18:45:58","0",null,null,null,"2020-06-24","2020-07-23","1 month contract. Special offer $2022\/month. Storage rental $2022 paid by PPS on June 11, 2020. Storage deposit $4636 transferred from agreement A14-CT207828 to this agreement.\r\n","2020-06-24","32",0,null,0,"0","2","2020-06-16 18:45:58","2","2020-06-16 18:45:58","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"053,46811","C170448","PERSONAL","Mr","NVv9pRh+D1VmYB2XsurgEQ==","8OcLe\/VzxU\/Xek1BNlpsfQ==","","0QpZaBXqoW5CgaBIwDwpjWtY5YJYGo9YtwWqdo6IK1Fg9YHW9ZmtiUF11gEm1OcOe3VhZDJuL+H\/IV+pZmf2Kw==","tujHTZIsGcqjKeaOnttAvg==","jGafPuxpS3yTCisx0O3a7o2TE03wjvCrNp2lr0gCkFw=","y4ZDYxl9X3dwkt7\/dDApww==",null,1,"7481"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:45:58","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":["8151","535","1098.0","1098.00","2","2020-06-16 18:45:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:45:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-24","2020-07-23","535"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-16 18:45:58","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":["8151","536","1098.0","1098.00","2","2020-06-16 18:45:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:45:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-24","2020-07-23","536"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-16 18:45:58","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":["8151",448,"SETTLED","A14-I208480","2020-06-16 18:45:58","2020-06-24","2","2020-06-16 18:45:58","2","2020-06-16 18:45:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:45:58","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":["8480","RENT","\u9810\u7e73\u79df\u91d1",1,2022,"MO","1",2022,"2","2020-06-16 18:45:58","2","2020-06-16 18:45:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:45:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2022,0,"8480"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-16 18:45:58","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":[448,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208123","2020-06-16 18:45:58",2022,"2","2020-06-16 18:45:58","2","2020-06-16 18:45:58","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:45:58","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":["8123","DEPOSIT",null,"PAID","2020-06-16 18:45:58",0,"2","2020-06-16 18:45:58","2","2020-06-16 18:45:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:45:58","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":["8123","INVOICE","8480","PAID","2020-06-16 18:45:58",2022,"2","2020-06-16 18:45:58","2","2020-06-16 18:45:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:47:39","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=612&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1542","master_room_id":"201","room_code":"A16-051"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":448,"customer_code":"C170448","identity_type":"PERSONAL","identity_id":"Z011806(1)","title":"Mr","lastname":"Hau","firstname":"Hil Yeung","companyname":"","email":"hermannhau@gmail.com","tel":"97139457","address":"Flat H,2\/F,Block 2,Chi Fu Fa Yuen,Pok Fu Lam,Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-13","renew_room_key":"'0012469943","renew_remark":"1 month contract.Storage rental $598 paid by PPS on May 11, 2020. Storage deposit $1196 Transferred from agreement A14-CT207602 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207830, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"685","room_code":"N02","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-13","rent_from":"2020-06-13","rent_to":"2020-07-12","delivery_service":"0","remark":"1 month contract.Storage rental $598 paid by PPS on June 11, 2020. Storage deposit $1196 Transferred from agreement A14-CT207830 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"'0012469943","order_product":[],"pass":true}},"first_order_id":"7602","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> N02 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:47:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",448,"NEW","A14-CT208152",598,598,0,0,"1","1",598,598,598,"2020-06-16 18:47:39","0",null,null,null,"2020-06-13","2020-07-12","1 month contract.Storage rental $598 paid by PPS on June 11, 2020. Storage deposit $1196 Transferred from agreement A14-CT207830 to this agreement. \r\n","2020-06-13","12",0,null,0,"0","2","2020-06-16 18:47:39","2","2020-06-16 18:47:39","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"'0012469943","C170448","PERSONAL","Mr","NVv9pRh+D1VmYB2XsurgEQ==","8OcLe\/VzxU\/Xek1BNlpsfQ==","","0QpZaBXqoW5CgaBIwDwpjWtY5YJYGo9YtwWqdo6IK1Fg9YHW9ZmtiUF11gEm1OcOe3VhZDJuL+H\/IV+pZmf2Kw==","tujHTZIsGcqjKeaOnttAvg==","jGafPuxpS3yTCisx0O3a7o2TE03wjvCrNp2lr0gCkFw=","y4ZDYxl9X3dwkt7\/dDApww==",null,1,"7602"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:47:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8152","685","598.0","598.00","2","2020-06-16 18:47:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:47:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-13","2020-07-12","685"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-16 18:47:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8152",448,"SETTLED","A14-I208481","2020-06-16 18:47:39","2020-06-13","2","2020-06-16 18:47:39","2","2020-06-16 18:47:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:47:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8481","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-06-16 18:47:39","2","2020-06-16 18:47:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:47:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8481"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-16 18:47:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[448,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208124","2020-06-16 18:47:39",598,"2","2020-06-16 18:47:39","2","2020-06-16 18:47:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:47:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8124","DEPOSIT",null,"PAID","2020-06-16 18:47:39",0,"2","2020-06-16 18:47:39","2","2020-06-16 18:47:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:47:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8124","INVOICE","8481","PAID","2020-06-16 18:47:39",598,"2","2020-06-16 18:47:39","2","2020-06-16 18:47:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:48:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:52:38","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=612&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1763","master_room_id":"232","room_code":"WC-06"}],"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> E39 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":0,"identity_type":"PERSONAL","identity_id":"D409025(0)","title":"Mr","lastname":"Chan","firstname":"Kam Yuen ","companyname":"","email":"Kychan26@gmail.com","tel":"91952696","address":"Flat 2211, 22\/F, Wah Yin House, Wah Kwai Estate, Aberdeen, Hong Kong","pass":true,"customer_id":355,"customer_code":"C170355","customer_first_order":false},"2":{"order_discount":[],"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"899.0","renew_rent_month":"13","renew_warehousing_date":"2020-06-17","renew_room_key":"055,06707","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by PPS on May 15, 2019. Storage deposit transferred from agreement A12-CT183610 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT194976, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_room":[{"room_id":"312","room_code":"E39","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":899,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":10788,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"899.00","warehousing_date":"2020-06-17","rent_from":"2020-06-17","rent_to":"2021-07-16","delivery_service":"0","remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by PPS on June 12, 2020. Storage deposit transferred from agreement A12-CT194976 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":899,"order_total":11687,"final_order_total":10788,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,06707","order_product":[],"pass":true}},"renew":1,"first_order_id":"3610","roughly_size":"12","total_discounted_price":"899.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:52:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",355,"NEW","A12-CT208153",998,899,0,0,"13","13",10788,11687,10788,"2020-06-16 18:52:39","0",null,null,null,"2020-06-17","2021-07-16","13 months contract. Special renewal offer, one month free. Storage rental paid by PPS on June 12, 2020. Storage deposit transferred from agreement A12-CT194976 to this agreement.\r\n","2020-06-17","12",0,null,899,"899.00","2","2020-06-16 18:52:38","2","2020-06-16 18:52:38","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,06707","C170355","PERSONAL","Mr","yE6g0t4WJwoo3ogGet475A==","U9yoE9KqV1v8YlRkf7Q2yg==","","SwSOFKU+1ApudzIx\/YnvqOk5VOVpjXdt3iu5MZG6xrw3HIITz6U1hUq7az7cYx+6QvUQbYrx8Y5iVPCI430amUccbu6vcWQDX3wb5zgiF\/U=","gHoB6A6UOM9bZif+VZTBfA==","wFqzY3lCbrxIRDLjz8Iw4pVl1ibyZv9Wm4htKcQYL8o=","0v2amDQXlORHQG0ho0sP+Q==",null,1,"3610"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:52:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8153","312","998.0","998.00","2","2020-06-16 18:52:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:52:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-17","2021-07-16","312"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-16 18:52:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8153",355,"SETTLED","A12-I208482","2020-06-16 18:52:38","2020-06-17","2","2020-06-16 18:52:38","2","2020-06-16 18:52:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:52:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8482","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,899,"MO","1",899,"2","2020-06-16 18:52:38","2","2020-06-16 18:52:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:52:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8482","RENT","\u9810\u7e73\u79df\u91d1",3,899,"MO","1",899,"2","2020-06-16 18:52:38","2","2020-06-16 18:52:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:52:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8482","RENT","\u9810\u7e73\u79df\u91d1",4,899,"MO","1",899,"2","2020-06-16 18:52:38","2","2020-06-16 18:52:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:52:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8482","RENT","\u9810\u7e73\u79df\u91d1",5,899,"MO","1",899,"2","2020-06-16 18:52:38","2","2020-06-16 18:52:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:52:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8482","RENT","\u9810\u7e73\u79df\u91d1",6,899,"MO","1",899,"2","2020-06-16 18:52:38","2","2020-06-16 18:52:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:52:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8482","RENT","\u9810\u7e73\u79df\u91d1",7,899,"MO","1",899,"2","2020-06-16 18:52:38","2","2020-06-16 18:52:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:52:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8482","RENT","\u9810\u7e73\u79df\u91d1",8,899,"MO","1",899,"2","2020-06-16 18:52:38","2","2020-06-16 18:52:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:52:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8482","RENT","\u9810\u7e73\u79df\u91d1",9,899,"MO","1",899,"2","2020-06-16 18:52:38","2","2020-06-16 18:52:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:52:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8482","RENT","\u9810\u7e73\u79df\u91d1",10,899,"MO","1",899,"2","2020-06-16 18:52:38","2","2020-06-16 18:52:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:52:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8482","RENT","\u9810\u7e73\u79df\u91d1",11,899,"MO","1",899,"2","2020-06-16 18:52:38","2","2020-06-16 18:52:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:52:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8482","RENT","\u9810\u7e73\u79df\u91d1",12,899,"MO","1",899,"2","2020-06-16 18:52:38","2","2020-06-16 18:52:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:52:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8482","RENT","\u9810\u7e73\u79df\u91d1",13,899,"MO","1",899,"2","2020-06-16 18:52:38","2","2020-06-16 18:52:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:52:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10788,0,"8482"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-16 18:52:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[355,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208125","2020-06-16 18:52:38",10788,"2","2020-06-16 18:52:38","2","2020-06-16 18:52:38","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:52:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8125","DEPOSIT",null,"PAID","2020-06-16 18:52:38",0,"2","2020-06-16 18:52:38","2","2020-06-16 18:52:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:52:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8125","INVOICE","8482","PAID","2020-06-16 18:52:38",10788,"2","2020-06-16 18:52:38","2","2020-06-16 18:52:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:56:13","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=612&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1763","master_room_id":"232","room_code":"WC-06"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":645,"customer_code":"C170645","identity_type":"PERSONAL","identity_id":"K758362(1)","title":"Ms","lastname":"Lo","firstname":"Chi Man","companyname":"","email":"genena22@hotmail.com","tel":"91944806","address":"Flat 414, Hoy Au Lau, 30 Aberdeen Reservoir Road, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1930.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-13","renew_room_key":"055,32901","renew_remark":"1 month contract. Storage rental paid by PPS on May 12, 2020. Storage deposit transferred from agreement A18-CT207547 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207838, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"104","order_discount":[],"order_room":[{"room_id":"921","room_code":"U22","retail_price":"1930.0","discounted_price":"1930.00","location_id":"3"}],"roughly_size":"25","total_retail_price":1930,"total_discounted_price":1930,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1930,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-13","rent_from":"2020-06-13","rent_to":"2020-07-12","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on June 15, 2020. Storage deposit transferred from agreement A18-CT207838 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1930,"final_order_total":1930,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,32901","order_product":[],"pass":true}},"first_order_id":"4603","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> U22 <\/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":"1930.0","deposit":"0","total_retail_price":"1930.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:56:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",645,"NEW","A18-CT208154",1930,1930,0,0,"1","1",1930,1930,1930,"2020-06-16 18:56:13","0",null,null,null,"2020-06-13","2020-07-12","1 month contract. Storage rental paid by PPS on June 15, 2020. Storage deposit transferred from agreement A18-CT207838 to this agreement.\r\n","2020-06-13","25",0,null,0,"0","2","2020-06-16 18:56:13","2","2020-06-16 18:56:13","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,32901","C170645","PERSONAL","Ms","+C9tc1TdnI5EfCJwPTju+g==","4w4biS+jM\/Q3DAzxHdf3pA==","","QMkWrBFC2X6lmw9G0kXHhByvUdctN4xesGoioPV7sHj0ug\/2VE3Vu0hVGC54w69582+1x9K+zMchNd7qlRGsNg==","h+d\/rmx9gukw63otAze1Lw==","1z3NagnfII+6QFgwXezQPOKHlQj6cPA1M\/NudLu\/U1M=","qSA+xbsjXbCHJxgeqBksBQ==",null,1,"4603"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:56:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8154","921","1930.0","1930.00","2","2020-06-16 18:56:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:56:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-13","2020-07-12","921"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-16 18:56:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8154",645,"SETTLED","A18-I208483","2020-06-16 18:56:13","2020-06-13","2","2020-06-16 18:56:13","2","2020-06-16 18:56:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:56:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8483","RENT","\u9810\u7e73\u79df\u91d1",1,1930,"MO","1",1930,"2","2020-06-16 18:56:13","2","2020-06-16 18:56:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:56:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1930,0,"8483"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-16 18:56:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[645,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208126","2020-06-16 18:56:13",1930,"2","2020-06-16 18:56:13","2","2020-06-16 18:56:13","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:56:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8126","DEPOSIT",null,"PAID","2020-06-16 18:56:13",0,"2","2020-06-16 18:56:13","2","2020-06-16 18:56:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:56:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8126","INVOICE","8483","PAID","2020-06-16 18:56:13",1930,"2","2020-06-16 18:56:13","2","2020-06-16 18:56:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:58:13","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=612&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1763","master_room_id":"232","room_code":"WC-06"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":645,"customer_code":"C170645","identity_type":"PERSONAL","identity_id":"K758362(1)","title":"Ms","lastname":"Lo","firstname":"Chi Man","companyname":"","email":"genena22@hotmail.com","tel":"91944806","address":"Flat 414, Hoy Au Lau, 30 Aberdeen Reservoir Road, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3180.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-27","renew_room_key":"055,32901","renew_remark":"1 month contract. Storage rental paid by PPS on May 12, 2020. Storage deposit transferred from agreement A18-CT207548 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207839, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"102","order_discount":[],"order_room":[{"room_id":"951","room_code":"V25","retail_price":"3180.0","discounted_price":"3180.00","location_id":"3"}],"roughly_size":"42","total_retail_price":3180,"total_discounted_price":3180,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":3180,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-27","rent_from":"2020-06-27","rent_to":"2020-07-26","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on June 15, 2020. Storage deposit transferred from agreement A18-CT207839 to this agreement.\r\n\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":3180,"final_order_total":3180,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,32901","order_product":[],"pass":true}},"first_order_id":"4604","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> V25 <\/td>\r\n\t\t\t\t\t 6X7X7 <\/td>\r\n\t\t\t\t\t $3180.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":"42","total_discounted_price":"3180.0","deposit":"0","total_retail_price":"3180.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:58:14","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",645,"NEW","A18-CT208155",3180,3180,0,0,"1","1",3180,3180,3180,"2020-06-16 18:58:14","0",null,null,null,"2020-06-27","2020-07-26","1 month contract. Storage rental paid by PPS on June 15, 2020. Storage deposit transferred from agreement A18-CT207839 to this agreement.\r\n\r\n","2020-06-27","42",0,null,0,"0","2","2020-06-16 18:58:13","2","2020-06-16 18:58:13","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,32901","C170645","PERSONAL","Ms","+C9tc1TdnI5EfCJwPTju+g==","4w4biS+jM\/Q3DAzxHdf3pA==","","QMkWrBFC2X6lmw9G0kXHhByvUdctN4xesGoioPV7sHj0ug\/2VE3Vu0hVGC54w69582+1x9K+zMchNd7qlRGsNg==","h+d\/rmx9gukw63otAze1Lw==","1z3NagnfII+6QFgwXezQPOKHlQj6cPA1M\/NudLu\/U1M=","qSA+xbsjXbCHJxgeqBksBQ==",null,1,"4604"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:58:14","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":["8155","951","3180.0","3180.00","2","2020-06-16 18:58:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:58:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-27","2020-07-26","951"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-16 18:58:14","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":["8155",645,"SETTLED","A18-I208484","2020-06-16 18:58:13","2020-06-27","2","2020-06-16 18:58:13","2","2020-06-16 18:58:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:58:14","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":["8484","RENT","\u9810\u7e73\u79df\u91d1",1,3180,"MO","1",3180,"2","2020-06-16 18:58:13","2","2020-06-16 18:58:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:58:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3180,0,"8484"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-16 18:58:14","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":[645,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208127","2020-06-16 18:58:13",3180,"2","2020-06-16 18:58:13","2","2020-06-16 18:58:13","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:58:14","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":["8127","DEPOSIT",null,"PAID","2020-06-16 18:58:13",0,"2","2020-06-16 18:58:13","2","2020-06-16 18:58:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 18:58:14","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":["8127","INVOICE","8484","PAID","2020-06-16 18:58:13",3180,"2","2020-06-16 18:58:13","2","2020-06-16 18:58:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 19:22:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-16 19:27:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****