{"created_at":"2020-03-05 09:57:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 10:08:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 10:35:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 10:41:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 10:57:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 10:58:04","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[],"index_url_parameter":"","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1185,"customer_code":"C191185","identity_type":"PERSONAL","identity_id":"D522909(0)","title":"Mr","lastname":"Lui","firstname":"Cheuk Ho","companyname":"","email":null,"tel":"60381903","address":"Flat\/Rm B, Mei Lun House, 2~4 Mei Lun Street, Central, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1322.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-01","renew_room_key":"0012516868","renew_remark":"1 month contract. Storage rental paid by bank transfer on Feb 01,2020. Storage deposit $1322 transferred from agreement C15-CT206883 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT207096, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"173","order_discount":[],"order_room":[{"room_id":"1421","room_code":"C15-115","retail_price":"1322.0","discounted_price":"1322.00","location_id":"6"}],"roughly_size":"24","total_retail_price":1322,"total_discounted_price":1322,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1322,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-01","rent_from":"2020-03-01","rent_to":"2020-03-31","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Mar 05,2020. Storage deposit $1322 transferred from agreement C15-CT207096 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1322,"final_order_total":1322,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012516868","order_product":[],"pass":true}},"first_order_id":"4243","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>
C15-115 <\/td>\r\n\t\t\t\t\t	4X6X6.5 <\/td>\r\n\t\t\t\t\t	$1322.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":"24","total_discounted_price":"1322.0","deposit":"0","total_retail_price":"1322.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 10:58:04","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","3","6",1185,"NEW","C15-CT207324",1322,1322,0,0,"1","1",1322,1322,1322,"2020-03-05 10:58:04","0",null,null,null,"2020-03-01","2020-03-31","1 month contract. Storage rental paid by bank transfer on Mar 05,2020. Storage deposit $1322 transferred from agreement C15-CT207096 to this agreement.","2020-03-01","24",0,null,0,"0","2","2020-03-05 10:58:04","2","2020-03-05 10:58:04","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012516868","C191185","PERSONAL","Mr","\/JQwF1+M6FL7Yun0+bBCFg==","vyCKi4IYWx3VnCZylJM1yA==","","M40cxW4GMmuJRXhcXM+Wt7bO\/WDVLnPGUxgCIY4qYL\/XYrR2lvobKWJ1rPDsF3EoUQ75QxAufkpF6LMIzO2Rkg==","KUOWIMoqsVaNtCRfR6snnQ==",null,"QAJCjnmgSugLsyxdh+ZSuA==",null,1,"4243"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 10:58:04","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":["7324","1421","1322.0","1322.00","2","2020-03-05 10:58:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 10:58:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-01","2020-03-31","1421"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-05 10:58:04","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":["7324",1185,"SETTLED","C15-I207652","2020-03-05 10:58:04","2020-03-01","2","2020-03-05 10:58:04","2","2020-03-05 10:58:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 10:58:04","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":["7652","RENT","\u9810\u7e73\u79df\u91d1",1,1322,"MO","1",1322,"2","2020-03-05 10:58:04","2","2020-03-05 10:58:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 10:58:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1322,0,"7652"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-05 10:58:04","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":[1185,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207300","2020-03-05 10:58:04",1322,"2","2020-03-05 10:58:04","2","2020-03-05 10:58:04","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 10:58:04","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":["7300","DEPOSIT",null,"PAID","2020-03-05 10:58:04",0,"2","2020-03-05 10:58:04","2","2020-03-05 10:58:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 10:58:04","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":["7300","INVOICE","7652","PAID","2020-03-05 10:58:04",1322,"2","2020-03-05 10:58:04","2","2020-03-05 10:58:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 11:35:36","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[],"index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":193,"customer_code":"C160193","identity_type":"PERSONAL","identity_id":"K727396(7)","title":"Mr","lastname":"Lau","firstname":"Wing Kan","companyname":"","email":null,"tel":"63488822","address":"\u9d28\u8137\u6d32\u5229\u6771\u90a8\u6771\u5e73\u6a13417\u5ba4","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1286.0","renew_rent_month":"2","renew_warehousing_date":"2020-02-19","renew_room_key":"190,40484","renew_remark":"2 months contract. Storage rental paid by cash on Jan 22,2020. Storage deposit transferred from agreement A12-CT196439 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207022, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"371","room_code":"G12","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1205,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3615,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-19","rent_from":"2020-02-19","rent_to":"2020-05-18","delivery_service":"0","remark":"3 months contract. Storage rental paid by cash on Mar 05,2020. Storage deposit transferred from agreement A12-CT207022 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":3615,"final_order_total":3615,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190,40484","order_product":[],"pass":true}},"first_order_id":"4777","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> G12 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1205.00","deposit":"0.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 11:35:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",193,"NEW","A12-CT207325",1528,1205,0,0,"3","3",3615,3615,3615,"2020-03-05 11:35:37","0",null,null,null,"2020-02-19","2020-05-18","3 months contract. Storage rental paid by cash on Mar 05,2020. Storage deposit transferred from agreement A12-CT207022 to this agreement.","2020-02-19","20",0,null,0,"0","2","2020-03-05 11:35:36","2","2020-03-05 11:35:36","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"190,40484","C160193","PERSONAL","Mr","6PbxGXCeHIo\/MzWTc4fcRg==","oe4emdjBwqJ3qUpOcI17hw==","","JP4Rs\/ygk7B5+4qY1O\/77n4G4SUpGWQ1R+59le4zwir8onzHxmiKA5kLXAeJHhuO","3GH4gAMvtTCKkEWDOO\/eWw==",null,"m393lxqgH7t7KDeHWstXmg==",null,1,"4777"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 11:35:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7325","371","1528.0","1528.00","2","2020-03-05 11:35:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 11:35:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-19","2020-05-18","371"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-05 11:35:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7325",193,"SETTLED","A12-I207653","2020-03-05 11:35:36","2020-02-19","2","2020-03-05 11:35:36","2","2020-03-05 11:35:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 11:35:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7653","RENT","\u9810\u7e73\u79df\u91d1",1,1205,"MO","1",1205,"2","2020-03-05 11:35:36","2","2020-03-05 11:35:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 11:35:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7653","RENT","\u9810\u7e73\u79df\u91d1",2,1205,"MO","1",1205,"2","2020-03-05 11:35:36","2","2020-03-05 11:35:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 11:35:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7653","RENT","\u9810\u7e73\u79df\u91d1",3,1205,"MO","1",1205,"2","2020-03-05 11:35:36","2","2020-03-05 11:35:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 11:35:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3615,0,"7653"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-05 11:35:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[193,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207301","2020-03-05 11:35:36",3615,"2","2020-03-05 11:35:36","2","2020-03-05 11:35:36","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 11:35:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7301","DEPOSIT",null,"PAID","2020-03-05 11:35:36",0,"2","2020-03-05 11:35:36","2","2020-03-05 11:35:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 11:35:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7301","INVOICE","7653","PAID","2020-03-05 11:35:36",3615,"2","2020-03-05 11:35:36","2","2020-03-05 11:35:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 11:36:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 11:36:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 11:54:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 11:54:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:10:48","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":675,"customer_code":"C170675","identity_type":"PERSONAL","identity_id":"D219583(7)","title":"Mr","lastname":"Pun","firstname":"Wing Cheong","companyname":"","email":null,"tel":"93211435","address":"Flat 3413, Tung Ping House, Lei Tung Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1525.0","renew_rent_month":"3","renew_warehousing_date":"2020-02-01","renew_room_key":"055,43050","renew_remark":"3 months contract. Storage rental paid by bank transfer on Dec 30, 2019. Storage deposit transferred from agreement A18-CT196165 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196813, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"78","order_discount":[{"master_room_discount_id":"252","master_room_id":"78","discount_type":"%","price":"1605.00","disocunted_price":"1524.80","discount":"5.00","monthly_deduct":80.25,"room_id":"922","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"922","room_code":"U23","retail_price":"1605.0","discounted_price":1524.8,"location_id":"3"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1525,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":4575,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-01","rent_from":"2020-02-01","rent_to":"2020-04-30","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on March 4, 2020. Storage deposit transferred from agreement A18-CT196813 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4575,"final_order_total":4575,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,43050","order_product":[],"pass":true}},"first_order_id":"4424","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> U23 <\/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> \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":"20","total_discounted_price":"1525.0","deposit":"0","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:10:48","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",675,"NEW","A18-CT207326",1605,1525,0,0,"3","3",4575,4575,4575,"2020-03-05 12:10:48","0",null,null,null,"2020-02-01","2020-04-30","3 months contract. Storage rental paid by bank transfer on March 4, 2020. Storage deposit transferred from agreement A18-CT196813 to this agreement.","2020-02-01","20",0,null,0,"0","2","2020-03-05 12:10:48","2","2020-03-05 12:10:48","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,43050","C170675","PERSONAL","Mr","zRl2wRT0bzGoBjayPtj0bg==","\/jZHfDSzBL6DMeP8beh11g==","","rQco+JL2vKS2IoKrZwA1yaG3nzWq9+b9wc4T7W6Yt5olYDVZu54iSWq\/s0b5tugnFNud6gxx+RBPNAHg26JO7xa3o0irEl2KUDPUiuatuPs=","8b1BJH8lCd7DJqxRE314HA==",null,"Od0RWXaEAXXPAqK4kTG2DQ==",null,1,"4424"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:10:48","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":["7326","252","78","922","%","5.00",80.25,"2","2020-03-05 12:10:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:10:48","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":["7326","922","1605.0",1524.8,"2","2020-03-05 12:10:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:10:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2020-04-30","922"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-05 12:10:48","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":["7326",675,"SETTLED","A18-I207654","2020-03-05 12:10:48","2020-02-01","2","2020-03-05 12:10:48","2","2020-03-05 12:10:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:10:48","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":["7654","RENT","\u9810\u7e73\u79df\u91d1",1,1525,"MO","1",1525,"2","2020-03-05 12:10:48","2","2020-03-05 12:10:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:10:48","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":["7654","RENT","\u9810\u7e73\u79df\u91d1",2,1525,"MO","1",1525,"2","2020-03-05 12:10:48","2","2020-03-05 12:10:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:10:48","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":["7654","RENT","\u9810\u7e73\u79df\u91d1",3,1525,"MO","1",1525,"2","2020-03-05 12:10:48","2","2020-03-05 12:10:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:10:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4575,0,"7654"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-05 12:10:48","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":[675,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207302","2020-03-05 12:10:48",4575,"2","2020-03-05 12:10:48","2","2020-03-05 12:10:48","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:10:48","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":["7302","DEPOSIT",null,"PAID","2020-03-05 12:10:48",0,"2","2020-03-05 12:10:48","2","2020-03-05 12:10:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:10:48","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":["7302","INVOICE","7654","PAID","2020-03-05 12:10:48",4575,"2","2020-03-05 12:10:48","2","2020-03-05 12:10:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:19:33","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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":888,"customer_code":"C180888","identity_type":"PERSONAL","identity_id":"K099955(5)","title":"Ms","lastname":"Ho","firstname":"Man Yee Cherie","companyname":"","email":"cheriehmy@gmail.com","tel":"90575456","address":"Flat A, 1\/F, Block 9, Fullview Garden, 18 Siu Sai Wan Road, Siu Sai Wan, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1488.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-06","renew_room_key":"0005763937","renew_remark":"1 month contract. Storage rental paid by PPS on February 4, 2020. Storage deposit $2976 transferred from agreement B01-CT206903 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT207118, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"143","order_discount":[],"order_room":[{"room_id":"1274","room_code":"B01-084","retail_price":"1488.0","discounted_price":"1488.00","location_id":"5"}],"roughly_size":"24","total_retail_price":1488,"total_discounted_price":1488,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1488,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-06","rent_from":"2020-03-06","rent_to":"2020-04-05","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on March 4, 2020. Storage deposit $2976 transferred from agreement B01-CT207118 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1488,"final_order_total":1488,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0005763937","order_product":[],"pass":true}},"first_order_id":"4797","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> B01-084 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1488.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1488.0","deposit":"0","total_retail_price":"1488.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:19:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","2","5",888,"NEW","B01-CT207327",1488,1488,0,0,"1","1",1488,1488,1488,"2020-03-05 12:19:34","0",null,null,null,"2020-03-06","2020-04-05","1 month contract. Storage rental paid by PPS on March 4, 2020. Storage deposit $2976 transferred from agreement B01-CT207118 to this agreement.\r\n","2020-03-06","24",0,null,0,"0","2","2020-03-05 12:19:33","2","2020-03-05 12:19:33","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0005763937","C180888","PERSONAL","Ms","B6XcmzmDA9cWki+qLStEaA==","D\/skxQ5s\/L5yyRWaDK\/iSg==","","zb+wEJU2BcjiqagYCnyRNQzS3jTcz1KQCkGgLWtY\/y+C8KU+srfsdCNTrRUrjSHTpRbkV0JFumXQh3K4klaHUNKIaPzoQH6Ro1qQAUtDwWHyil1VPuPOWLDOdLKNt30K","Mv9sZMBZUVgbHGVZIxyZfQ==","d8Ms1Ternr8fasYV7yyV8x0bubUdhthIhbdOyphH3tQ=","b0wVwk81Vh1dF13X\/TkOaw==",null,1,"4797"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:19:34","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":["7327","1274","1488.0","1488.00","2","2020-03-05 12:19:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:19:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-06","2020-04-05","1274"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-05 12:19:34","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":["7327",888,"SETTLED","B01-I207655","2020-03-05 12:19:33","2020-03-06","2","2020-03-05 12:19:33","2","2020-03-05 12:19:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:19:34","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":["7655","RENT","\u9810\u7e73\u79df\u91d1",1,1488,"MO","1",1488,"2","2020-03-05 12:19:33","2","2020-03-05 12:19:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:19:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1488,0,"7655"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-05 12:19:34","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":[888,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207303","2020-03-05 12:19:33",1488,"2","2020-03-05 12:19:33","2","2020-03-05 12:19:33","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:19:34","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":["7303","DEPOSIT",null,"PAID","2020-03-05 12:19:33",0,"2","2020-03-05 12:19:33","2","2020-03-05 12:19:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:19:34","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":["7303","INVOICE","7655","PAID","2020-03-05 12:19:33",1488,"2","2020-03-05 12:19:33","2","2020-03-05 12:19:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:39:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:40:29","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","0012385365","12 months contract, Storage rental paid by bank transfer on March 4, 2020. Storage deposit transferred from C15-CT194336 to this agreement.\r\n","2020-03-05 12:40:29","2","ts1WQ6NWxfSAyKGz8YWojw==","aoif98WXGg69q9tqSJEpOg==","Qn2df0BC6sxl2qAyAmCVOHx2Rud1fKa4hCXNJBJOCac=","gdBE4a3ag+29Q+tj2wOxXQ==","2l3ADaBqXmXeu61Fghs1XDfHJdk2inZBofsc4RIPRiC85cykYIt5Ulttf6rg3lxiXIP6p0FWHOJpk1JEQijUtQ==",7321]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:50: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","floor_plan_rent_room":[],"index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1379,"customer_code":"C191379","identity_type":"PERSONAL","identity_id":"Z300789(9)","title":"Mr","lastname":"WU","firstname":"Chi Wing","companyname":"","email":"wuchiwing@gmail.com","tel":"96258318","address":"Flat E, 19\/F, Blk 4, Harmony Garden, Siu Sai Wan, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"800.0","renew_rent_month":"6","renew_warehousing_date":"2020-03-01","renew_room_key":"0012403766","renew_remark":"6 months contract. Special offer 1 month free and 5% "Rent Now" discount. Storage rental and deposit paid by chequr on August 26, 2019. Smartcard paid on August 26, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT195801, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1816.0","renew_master_room_id":"136","order_discount":[],"order_room":[{"room_id":"1248","room_code":"B01-058","retail_price":"908.0","discounted_price":"908.00","location_id":"5"}],"roughly_size":"12","total_retail_price":908,"total_discounted_price":709,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":8508,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-01","rent_from":"2020-03-01","rent_to":"2021-02-28","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on Mar 05,2020. Deposit $1816 transferred from agreement B01-CT195801 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":8508,"final_order_total":8508,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0012403766","order_product":[],"pass":true}},"first_order_id":5801,"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> B01-058 <\/td>\r\n\t\t\t\t\t 3X4X7 <\/td>\r\n\t\t\t\t\t $908.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":"709.00","deposit":"0.00","total_retail_price":"908.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:50:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","2","5",1379,"NEW","B01-CT207328",908,709,0,0,"12","12",8508,8508,8508,"2020-03-05 12:50:27","0",null,null,null,"2020-03-01","2021-02-28","12 months contract. Storage rental paid by bank transfer on Mar 05,2020. Deposit $1816 transferred from agreement B01-CT195801 to this agreement.","2020-03-01","12",0,null,0,"0","2","2020-03-05 12:50:26","2","2020-03-05 12:50:26","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012403766","C191379","PERSONAL","Mr","b8Q\/\/MN9YZXl3XD3LuyRXw==","RgTQL6em\/We21zilKNSwtg==","","2Cwrnow\/Aa0\/2h\/MRqpekZHxsXb8XeQ2rdAvFBVLNgs8gbobaapSJHgjXXwanucSoc\/z+MPTTD7ecsL26Gh3Lw==","ACUNeM+iDgYY4oyCpH7EGQ==","pd9IJEiAInKZRSjGqaFPOUVG3vVqeNAmMz6GcPS6tPw=","4VDjtZSK8A2PxKlpny1ftQ==",null,1,5801]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:50:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7328","1248","908.0","908.00","2","2020-03-05 12:50:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:50:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-01","2021-02-28","1248"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-05 12:50:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7328",1379,"SETTLED","B01-I207656","2020-03-05 12:50:26","2020-03-01","2","2020-03-05 12:50:26","2","2020-03-05 12:50:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:50:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7656","RENT","\u9810\u7e73\u79df\u91d1",1,709,"MO","1",709,"2","2020-03-05 12:50:26","2","2020-03-05 12:50:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:50:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7656","RENT","\u9810\u7e73\u79df\u91d1",2,709,"MO","1",709,"2","2020-03-05 12:50:26","2","2020-03-05 12:50:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:50:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7656","RENT","\u9810\u7e73\u79df\u91d1",3,709,"MO","1",709,"2","2020-03-05 12:50:26","2","2020-03-05 12:50:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:50:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7656","RENT","\u9810\u7e73\u79df\u91d1",4,709,"MO","1",709,"2","2020-03-05 12:50:26","2","2020-03-05 12:50:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:50:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7656","RENT","\u9810\u7e73\u79df\u91d1",5,709,"MO","1",709,"2","2020-03-05 12:50:26","2","2020-03-05 12:50:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:50:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7656","RENT","\u9810\u7e73\u79df\u91d1",6,709,"MO","1",709,"2","2020-03-05 12:50:26","2","2020-03-05 12:50:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:50:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7656","RENT","\u9810\u7e73\u79df\u91d1",7,709,"MO","1",709,"2","2020-03-05 12:50:26","2","2020-03-05 12:50:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:50:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7656","RENT","\u9810\u7e73\u79df\u91d1",8,709,"MO","1",709,"2","2020-03-05 12:50:26","2","2020-03-05 12:50:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:50:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7656","RENT","\u9810\u7e73\u79df\u91d1",9,709,"MO","1",709,"2","2020-03-05 12:50:26","2","2020-03-05 12:50:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:50:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7656","RENT","\u9810\u7e73\u79df\u91d1",10,709,"MO","1",709,"2","2020-03-05 12:50:26","2","2020-03-05 12:50:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:50:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7656","RENT","\u9810\u7e73\u79df\u91d1",11,709,"MO","1",709,"2","2020-03-05 12:50:26","2","2020-03-05 12:50:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:50:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7656","RENT","\u9810\u7e73\u79df\u91d1",12,709,"MO","1",709,"2","2020-03-05 12:50:26","2","2020-03-05 12:50:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:50:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8508,0,"7656"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-05 12:50:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1379,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207304","2020-03-05 12:50:26",8508,"2","2020-03-05 12:50:26","2","2020-03-05 12:50:26","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:50:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7304","DEPOSIT",null,"PAID","2020-03-05 12:50:26",0,"2","2020-03-05 12:50:26","2","2020-03-05 12:50:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 12:50:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7304","INVOICE","7656","PAID","2020-03-05 12:50:26",8508,"2","2020-03-05 12:50:26","2","2020-03-05 12:50:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 13:32:52","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","0012403766","12 months contract. Storage rental $8505 paid by bank transfer on Mar 05,2020. Outstanding $3 will pay in next contract. Deposit $1816 transferred from agreement B01-CT195801 to this agreement.","2020-03-05 13:32:52","2","RgTQL6em\/We21zilKNSwtg==","b8Q\/\/MN9YZXl3XD3LuyRXw==","pd9IJEiAInKZRSjGqaFPOUVG3vVqeNAmMz6GcPS6tPw=","ACUNeM+iDgYY4oyCpH7EGQ==","2Cwrnow\/Aa0\/2h\/MRqpekZHxsXb8XeQ2rdAvFBVLNgs8gbobaapSJHgjXXwanucSoc\/z+MPTTD7ecsL26Gh3Lw==",7328]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:44:25","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[],"index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1143,"customer_code":"C181143","identity_type":"PERSONAL","identity_id":"P043956(1)","title":"Mr","lastname":"NG","firstname":"Chi On","companyname":"","email":"redteac668@gmail.com","tel":"91507763","address":"Flat\/Rm 24 Floor 14, Yick Fat Building, 1048 King's Road, Quarry Bay ","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"684.0","renew_rent_month":"3","renew_warehousing_date":"2020-03-10","renew_room_key":"0012513902","renew_remark":"3 month contract. Storage rental paid by bank transfer on December 13, 2019. Storage deposit $720 transferred from agreement C15-CT195926 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT196692, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"159","order_discount":[],"order_room":[{"room_id":"1411","room_code":"C15-105","retail_price":"720.0","discounted_price":"720.00","location_id":"6"}],"roughly_size":"9","total_retail_price":720,"total_discounted_price":648,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":7776,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-10","rent_from":"2020-03-10","rent_to":"2021-03-09","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on Mar 05,2020. Storage deposit $720 transferred from agreement C15-CT196692 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":7776,"final_order_total":7776,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012513902","order_product":[],"pass":true}},"first_order_id":"4483","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> C15-105 <\/td>\r\n\t\t\t\t\t 3X3X6.5 <\/td>\r\n\t\t\t\t\t $720.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":"9","total_discounted_price":"648","deposit":"0.00","total_retail_price":"720.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:44: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","3","6",1143,"NEW","C15-CT207329",720,648,0,0,"12","12",7776,7776,7776,"2020-03-05 14:44:26","0",null,null,null,"2020-03-10","2021-03-09","12 months contract. Storage rental paid by bank transfer on Mar 05,2020. Storage deposit $720 transferred from agreement C15-CT196692 to this agreement. ","2020-03-10","9",0,null,0,"0","2","2020-03-05 14:44:25","2","2020-03-05 14:44:25","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012513902","C181143","PERSONAL","Mr","ETH7g0aOUlCOcIBTrcksAg==","yXKLXTtbNpECaRVTZxF\/Rw==","","VjDVb2N8oiZpjUQsB\/cddbJHhr9V8Zd4p25chSG3fxpxsQZR8lucCLOj6lqzRee9QzuSxYEuexIJrOELyDG0KPWzu9u9TxeWHP7fFA29UVs=","fssRUCbxqvAzfOn5pnVlOQ==","POeCSRn6MWcpcIRlMd8N09FFm\/GO+XIGr7W6nDVr5fQ=","nNAYzEQ4gSbpq8L0\/sugEw==",null,1,"4483"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:44: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":["7329","1411","720.0","720.00","2","2020-03-05 14:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:44: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-03-10","2021-03-09","1411"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-05 14:44: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":["7329",1143,"SETTLED","C15-I207657","2020-03-05 14:44:25","2020-03-10","2","2020-03-05 14:44:25","2","2020-03-05 14:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:44: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":["7657","RENT","\u9810\u7e73\u79df\u91d1",1,648,"MO","1",648,"2","2020-03-05 14:44:25","2","2020-03-05 14:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:44: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":["7657","RENT","\u9810\u7e73\u79df\u91d1",2,648,"MO","1",648,"2","2020-03-05 14:44:25","2","2020-03-05 14:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:44: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":["7657","RENT","\u9810\u7e73\u79df\u91d1",3,648,"MO","1",648,"2","2020-03-05 14:44:25","2","2020-03-05 14:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:44: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":["7657","RENT","\u9810\u7e73\u79df\u91d1",4,648,"MO","1",648,"2","2020-03-05 14:44:25","2","2020-03-05 14:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:44: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":["7657","RENT","\u9810\u7e73\u79df\u91d1",5,648,"MO","1",648,"2","2020-03-05 14:44:25","2","2020-03-05 14:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:44: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":["7657","RENT","\u9810\u7e73\u79df\u91d1",6,648,"MO","1",648,"2","2020-03-05 14:44:25","2","2020-03-05 14:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:44: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":["7657","RENT","\u9810\u7e73\u79df\u91d1",7,648,"MO","1",648,"2","2020-03-05 14:44:25","2","2020-03-05 14:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:44: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":["7657","RENT","\u9810\u7e73\u79df\u91d1",8,648,"MO","1",648,"2","2020-03-05 14:44:25","2","2020-03-05 14:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:44: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":["7657","RENT","\u9810\u7e73\u79df\u91d1",9,648,"MO","1",648,"2","2020-03-05 14:44:25","2","2020-03-05 14:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:44: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":["7657","RENT","\u9810\u7e73\u79df\u91d1",10,648,"MO","1",648,"2","2020-03-05 14:44:25","2","2020-03-05 14:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:44: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":["7657","RENT","\u9810\u7e73\u79df\u91d1",11,648,"MO","1",648,"2","2020-03-05 14:44:25","2","2020-03-05 14:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:44: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":["7657","RENT","\u9810\u7e73\u79df\u91d1",12,648,"MO","1",648,"2","2020-03-05 14:44:25","2","2020-03-05 14:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:44:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7776,0,"7657"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-05 14:44: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":[1143,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207305","2020-03-05 14:44:25",7776,"2","2020-03-05 14:44:25","2","2020-03-05 14:44:25","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:44: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":["7305","DEPOSIT",null,"PAID","2020-03-05 14:44:25",0,"2","2020-03-05 14:44:25","2","2020-03-05 14:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:44: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":["7305","INVOICE","7657","PAID","2020-03-05 14:44:25",7776,"2","2020-03-05 14:44:25","2","2020-03-05 14:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:45:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:45:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:46: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=1&filter2=1198","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":679,"customer_code":"C180679","identity_type":"BUSINESS","identity_id":"30490025","title":"Ms","lastname":"Chan","firstname":"Doris","companyname":"Hemandas Industrial Ltd.","email":"dorischan@esc.com.hk","tel":"92896007","address":"Unit 2243, 22\/F, Yan's Tower, 25-27 Wong Chuk Hang Rd, Wong Chuk Hang, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2728.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-03","renew_room_key":"055,56887","renew_remark":"1 month contract. Storage rental paid by bank transfer on February 10, 2020. Storage deposit transferred from agreement A18-CT206915 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207154, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"82","order_discount":[],"order_room":[{"room_id":"859","room_code":"T03","retail_price":"2728.0","discounted_price":"2728.00","location_id":"3"}],"roughly_size":"36","total_retail_price":2728,"total_discounted_price":2728,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2728,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-03","rent_from":"2020-03-03","rent_to":"2020-04-02","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on March 5, 2020. Storage deposit transferred from agreement A18-CT207154 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2728,"final_order_total":2728,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,56887","order_product":[],"pass":true}},"first_order_id":"4697","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> T03 <\/td>\r\n\t\t\t\t\t 6X6X7 <\/td>\r\n\t\t\t\t\t $2728.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":"36","total_discounted_price":"2728.0","deposit":"0","total_retail_price":"2728.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:46:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",679,"NEW","A18-CT207330",2728,2728,0,0,"1","1",2728,2728,2728,"2020-03-05 14:46:54","0",null,null,null,"2020-03-03","2020-04-02","1 month contract. Storage rental paid by bank transfer on March 5, 2020. Storage deposit transferred from agreement A18-CT207154 to this agreement.\r\n","2020-03-03","36",0,null,0,"0","2","2020-03-05 14:46:54","2","2020-03-05 14:46:54","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,56887","C180679","BUSINESS","Ms","1p0+HSxbHlPSeHnKL1+MnA==","U9yoE9KqV1v8YlRkf7Q2yg==","Hemandas Industrial Ltd.","NNq9wxs1efEwHG+GfiDv3WoHFlyl2ik9vc5ha7eicfoFr48wfjXwEVDp3r5jjcxqeRyrZaz+NALvMBTiKSrb1OMQJpkhkNMPCpwd2zTkR61b7UwwjxTbA4OPPOLfvpDG","gMEFsGZs7+56GFUaxLbplg==","Um3+ktI0eYcw3estHH8TQKxSuSRl+2j3b4bDI46i5yg=",null,"UeK5wwtn5\/PTJNB6lM3obw==",1,"4697"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:46:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7330","859","2728.0","2728.00","2","2020-03-05 14:46:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:46:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-03","2020-04-02","859"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-05 14:46:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7330",679,"SETTLED","A18-I207658","2020-03-05 14:46:54","2020-03-03","2","2020-03-05 14:46:54","2","2020-03-05 14:46:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:46:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7658","RENT","\u9810\u7e73\u79df\u91d1",1,2728,"MO","1",2728,"2","2020-03-05 14:46:54","2","2020-03-05 14:46:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:46:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2728,0,"7658"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-05 14:46:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[679,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207306","2020-03-05 14:46:54",2728,"2","2020-03-05 14:46:54","2","2020-03-05 14:46:54","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:46:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7306","DEPOSIT",null,"PAID","2020-03-05 14:46:54",0,"2","2020-03-05 14:46:54","2","2020-03-05 14:46:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:46:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7306","INVOICE","7658","PAID","2020-03-05 14:46:54",2728,"2","2020-03-05 14:46:54","2","2020-03-05 14:46:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:48:36","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1198&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":663,"customer_code":"C170663","identity_type":"PERSONAL","identity_id":"D302826(8)","title":"Ms","lastname":"Chu","firstname":"Lai Ngan ","companyname":"","email":null,"tel":"91216789","address":"Flat E, 13\/F, Tower 8, South Horizons, Ap Lei Chau","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-01","renew_room_key":"055,06790","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 31, 2020. Storage deposit transferred from agreement A18-CT206881 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207079, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"989","room_code":"X14","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1290,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-01","rent_from":"2020-03-01","rent_to":"2020-03-31","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on March 5, 2020. Storage deposit transferred from agreement A18-CT207079 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,06790","order_product":[],"pass":true}},"first_order_id":"4345","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> X14 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:48:36","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",663,"NEW","A18-CT207331",1290,1290,0,0,"1","1",1290,1290,1290,"2020-03-05 14:48:36","0",null,null,null,"2020-03-01","2020-03-31","1 month contract. Storage rental paid by bank transfer on March 5, 2020. Storage deposit transferred from agreement A18-CT207079 to this agreement.\r\n","2020-03-01","16",0,null,0,"0","2","2020-03-05 14:48:36","2","2020-03-05 14:48:36","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,06790","C170663","PERSONAL","Ms","+hf2BdEzeyuAlJ9o86BQkA==","uwdKi3S38jh5+tBibXKG4A==","","ZkyPYW\/X9p1lPTh\/bKU+\/PiAtXClt+yHReh+airMmSnG6Uwc2BRo5SF4sycqncKB\/EoNyhigJWrejarCTwNPAg==","q3\/rgHjoH\/vhcz82yJ8JGA==",null,"x7LEi0saK+ePsbHhJKXpDQ==",null,1,"4345"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:48:36","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":["7331","989","1290.0","1290.00","2","2020-03-05 14:48:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:48:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-01","2020-03-31","989"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-05 14:48:36","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":["7331",663,"SETTLED","A18-I207659","2020-03-05 14:48:36","2020-03-01","2","2020-03-05 14:48:36","2","2020-03-05 14:48:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:48:36","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":["7659","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-03-05 14:48:36","2","2020-03-05 14:48:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:48:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"7659"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-05 14:48:36","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":[663,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207307","2020-03-05 14:48:36",1290,"2","2020-03-05 14:48:36","2","2020-03-05 14:48:36","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:48:36","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":["7307","DEPOSIT",null,"PAID","2020-03-05 14:48:36",0,"2","2020-03-05 14:48:36","2","2020-03-05 14:48:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 14:48:36","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":["7307","INVOICE","7659","PAID","2020-03-05 14:48:36",1290,"2","2020-03-05 14:48:36","2","2020-03-05 14:48:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 15:03:18","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 15:26:57","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=392&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1396,"customer_code":"C191396","identity_type":"PERSONAL","identity_id":"E907922(3)","title":"Ms","lastname":"Leung","firstname":"Wai Sum Sandy","companyname":"","email":"sandy22leung@gmail.com","tel":"94000431","address":"Rm2706, Ho King Commercial Centre, 2-16 Fa Yuen Street, Kowloon","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"989.0","renew_rent_month":"6","renew_warehousing_date":"2020-03-17","renew_room_key":"076,47843","renew_remark":"6 month contract. Special offer 5% \u201crent Now\u201d discount. Storage rental and deposit paid by cheque on September 16, 2019. Smartcard paid on September 16, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195954, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2196.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"506","room_code":"K43","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":989,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":11868,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"989.00","warehousing_date":"2020-03-17","rent_from":"2020-03-17","rent_to":"2021-04-16","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by cheque on March 5, 2020. Storage deposit $2196 transferred from agreement A14-CT195954 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":989,"order_total":12857,"final_order_total":11868,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,47843","order_product":[],"pass":true}},"first_order_id":5954,"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> K43 <\/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":"16","total_discounted_price":"989.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 15:26:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",1396,"NEW","A14-CT207332",1098,989,0,0,"13","13",11868,12857,11868,"2020-03-05 15:26:57","0",null,null,null,"2020-03-17","2021-04-16","13 months contract. Special offer the 13th month free. Storage rental paid by cheque on March 5, 2020. Storage deposit $2196 transferred from agreement A14-CT195954 to this agreement. \r\n","2020-03-17","16",0,null,989,"989.00","2","2020-03-05 15:26:57","2","2020-03-05 15:26:57","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"076,47843","C191396","PERSONAL","Ms","VOnveSCgMRSVBFUlz+uMYA==","xEf2h2aoyRQ71ZVgBH+9WQ==","","jzxTrn06vHzYy9oG4jA0OpExWZVyFlSjbzyd410Mx7kmznjWt0epLUYJw5KbyTF7GZ+gPTI4OZkj5vJMHuhdQA==","wdL\/c7kvCbRYgq399l+Uwg==","CTRwS1OY1zDpY3dOi6KNzBRvFLf7BErhSon2Cqece1k=","0CcRcs1ALGASy8tTL8Yp9A==",null,1,5954]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 15:26:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7332","506","1098.0","1098.00","2","2020-03-05 15:26:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 15:26:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-17","2021-04-16","506"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-05 15:26:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7332",1396,"SETTLED","A14-I207660","2020-03-05 15:26:57","2020-03-17","2","2020-03-05 15:26:57","2","2020-03-05 15:26:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 15:26:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7660","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,989,"MO","1",989,"2","2020-03-05 15:26:57","2","2020-03-05 15:26:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 15:26:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7660","RENT","\u9810\u7e73\u79df\u91d1",3,989,"MO","1",989,"2","2020-03-05 15:26:57","2","2020-03-05 15:26:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 15:26:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7660","RENT","\u9810\u7e73\u79df\u91d1",4,989,"MO","1",989,"2","2020-03-05 15:26:57","2","2020-03-05 15:26:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 15:26:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7660","RENT","\u9810\u7e73\u79df\u91d1",5,989,"MO","1",989,"2","2020-03-05 15:26:57","2","2020-03-05 15:26:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 15:26:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7660","RENT","\u9810\u7e73\u79df\u91d1",6,989,"MO","1",989,"2","2020-03-05 15:26:57","2","2020-03-05 15:26:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 15:26:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7660","RENT","\u9810\u7e73\u79df\u91d1",7,989,"MO","1",989,"2","2020-03-05 15:26:57","2","2020-03-05 15:26:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 15:26:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7660","RENT","\u9810\u7e73\u79df\u91d1",8,989,"MO","1",989,"2","2020-03-05 15:26:57","2","2020-03-05 15:26:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 15:26:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7660","RENT","\u9810\u7e73\u79df\u91d1",9,989,"MO","1",989,"2","2020-03-05 15:26:57","2","2020-03-05 15:26:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 15:26:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7660","RENT","\u9810\u7e73\u79df\u91d1",10,989,"MO","1",989,"2","2020-03-05 15:26:57","2","2020-03-05 15:26:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 15:26:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7660","RENT","\u9810\u7e73\u79df\u91d1",11,989,"MO","1",989,"2","2020-03-05 15:26:57","2","2020-03-05 15:26:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 15:26:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7660","RENT","\u9810\u7e73\u79df\u91d1",12,989,"MO","1",989,"2","2020-03-05 15:26:57","2","2020-03-05 15:26:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 15:26:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7660","RENT","\u9810\u7e73\u79df\u91d1",13,989,"MO","1",989,"2","2020-03-05 15:26:57","2","2020-03-05 15:26:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 15:26:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11868,0,"7660"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-05 15:26:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1396,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207308","2020-03-05 15:26:57",11868,"2","2020-03-05 15:26:57","2","2020-03-05 15:26:57","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 15:26:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7308","DEPOSIT",null,"PAID","2020-03-05 15:26:57",0,"2","2020-03-05 15:26:57","2","2020-03-05 15:26:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 15:26:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7308","INVOICE","7660","PAID","2020-03-05 15:26:57",11868,"2","2020-03-05 15:26:57","2","2020-03-05 15:26:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 15:40:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 16:31:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 17:09:36","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[],"index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":571,"customer_code":"C170571","identity_type":"PERSONAL","identity_id":"D076450(8)","title":"Mr","lastname":"Cheng","firstname":"Wai Sun","companyname":"","email":null,"tel":"62375791","address":"6, Kingston street, 7\/A, Causeway Bay, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"6","renew_warehousing_date":"2020-03-08","renew_room_key":"076,46478","renew_remark":"6 months contract. Storage rental paid by cash on August 19, 2019. Storage deposit $1196 transferred from agreement A14-CT194502 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195747, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"608","room_code":"M19","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-08","rent_from":"2020-03-08","rent_to":"2020-09-07","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on Mar 05,2020. Storage deposit $1196 transferred from agreement A14-CT195747 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,46478","order_product":[],"pass":true}},"first_order_id":"4502","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> M19 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"538.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 17:09:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",571,"NEW","A14-CT207333",598,538,0,0,"6","6",3228,3228,3228,"2020-03-05 17:09:37","0",null,null,null,"2020-03-08","2020-09-07","6 months contract. Storage rental paid by bank transfer on Mar 05,2020. Storage deposit $1196 transferred from agreement A14-CT195747 to this agreement.","2020-03-08","12",0,null,0,"0","2","2020-03-05 17:09:36","2","2020-03-05 17:09:36","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,46478","C170571","PERSONAL","Mr","LmqwEM+jE6r9IRvnsHAfPQ==","UCPBCXrBLI9U7KKsPqgmNA==","","UblVtA4KAomEZyvTLUKcvNmmbFgTfY4qXDwQ5LiEoFfnyEo8Vlid8YsgeuossH7GiwTx9tUOyF3W8NNk3F8Hfg==","XE4IAvFAXtblV\/n3BRBQDQ==",null,"4f+sN7shrTK\/6Vskm23nAA==",null,1,"4502"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 17:09:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7333","608","598.0","598.00","2","2020-03-05 17:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 17:09:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-08","2020-09-07","608"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-05 17:09:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7333",571,"SETTLED","A14-I207661","2020-03-05 17:09:36","2020-03-08","2","2020-03-05 17:09:36","2","2020-03-05 17:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 17:09:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7661","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-03-05 17:09:36","2","2020-03-05 17:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 17:09:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7661","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-03-05 17:09:36","2","2020-03-05 17:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 17:09:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7661","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-03-05 17:09:36","2","2020-03-05 17:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 17:09:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7661","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-03-05 17:09:36","2","2020-03-05 17:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 17:09:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7661","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-03-05 17:09:36","2","2020-03-05 17:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 17:09:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7661","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-03-05 17:09:36","2","2020-03-05 17:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 17:09:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"7661"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-05 17:09:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[571,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207309","2020-03-05 17:09:36",3228,"2","2020-03-05 17:09:36","2","2020-03-05 17:09:36","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 17:09:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7309","DEPOSIT",null,"PAID","2020-03-05 17:09:36",0,"2","2020-03-05 17:09:36","2","2020-03-05 17:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 17:09:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7309","INVOICE","7661","PAID","2020-03-05 17:09:36",3228,"2","2020-03-05 17:09:36","2","2020-03-05 17:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-05 19:09:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****