{"created_at":"2020-02-29 12:01:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:07: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":"filter1=2&filter2=494&filter3=undefined","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1646","master_room_id":"206","room_code":"A16-155"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":494,"customer_code":"C170494","identity_type":"PERSONAL","identity_id":"C531200(9)","title":"Mr","lastname":"Cheung","firstname":"Sai Pui","companyname":"","email":null,"tel":"92070072","address":"\u9999\u6e2f\u4ed4\u4e2d\u5fc3\u6d77\u9f8d\u95a33\u6a131\u5ba4","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1139.0","renew_rent_month":"12","renew_warehousing_date":"2020-06-12","renew_room_key":"052,30473,076,34911","renew_remark":"6 months contract. Special offer $100 Wellcome Voucher. Storage rental paid by EPS on June 25, 2019. Storage deposit transferred from agreement A14-CT194142 to this agreement.
\u820a\u5408\u7d04\u7de8\u865f: A14-CT194142, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195315, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"38","order_discount":[],"order_room":[{"room_id":"454","room_code":"J36","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"}],"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":3415,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"200.00","warehousing_date":"2020-06-12","rent_from":"2020-06-12","rent_to":"2020-09-11","delivery_service":"0","remark":"3 months contract. Special offer $200 \"Come back again\" coupon. Storage rental paid by EPS on February 29, 2020. Storage deposit transferred from agreement A14-CT195315 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":200,"order_total":3615,"final_order_total":3415,"location_id":"2","branch_id":"1","company_id":"1","room_key":"052,30473,076,34911","order_product":[],"pass":true}},"first_order_id":"4142","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>
J36 <\/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>	<\/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-02-29 12:07: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","1","2",494,"NEW","A14-CT207276",1528,1205,0,0,"3","3",3415,3615,3415,"2020-02-29 12:07:34","0",null,null,null,"2020-06-12","2020-09-11","3 months contract. Special offer $200 \"Come back again\" coupon. Storage rental paid by EPS on February 29, 2020. Storage deposit transferred from agreement A14-CT195315 to this agreement.\r\n","2020-06-12","20",0,null,200,"200.00","2","2020-02-29 12:07:33","2","2020-02-29 12:07:33","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"052,30473,076,34911","C170494","PERSONAL","Mr","UKoGzVPoLz4Ey6q++gHanQ==","vCxOlXQuvOQaoL822H2o\/Q==","","hI6IrHjcy5pLAjEBRvfJ4wWjUBiKlW6CSZppVj5CYxP3Zxg2dkgqfFUPLbcoyXKo","\/v9UEQAg9dNWum9CzCoWKg==",null,"a8ZGBYUHc3bnjwCIinDdfA==",null,1,"4142"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:07: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":["7276","454","1528.0","1528.00","2","2020-02-29 12:07:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:07: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-06-12","2020-09-11","454"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-29 12:07: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":["7276",494,"SETTLED","A14-I207604","2020-02-29 12:07:33","2020-06-12","2","2020-02-29 12:07:33","2","2020-02-29 12:07:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:07: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":["7604","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,1005,"MO","1",1005,"2","2020-02-29 12:07:33","2","2020-02-29 12:07:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:07: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":["7604","RENT","\u9810\u7e73\u79df\u91d1",2,1205,"MO","1",1205,"2","2020-02-29 12:07:33","2","2020-02-29 12:07:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:07: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":["7604","RENT","\u9810\u7e73\u79df\u91d1",3,1205,"MO","1",1205,"2","2020-02-29 12:07:33","2","2020-02-29 12:07:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:07:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3415,0,"7604"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-29 12:07: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":[494,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207252","2020-02-29 12:07:33",3415,"2","2020-02-29 12:07:33","2","2020-02-29 12:07:33","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:07: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":["7252","DEPOSIT",null,"PAID","2020-02-29 12:07:33",0,"2","2020-02-29 12:07:33","2","2020-02-29 12:07:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:07: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":["7252","INVOICE","7604","PAID","2020-02-29 12:07:33",3415,"2","2020-02-29 12:07:33","2","2020-02-29 12:07:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:12: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":"filter1=2&filter2=494&filter3=undefined&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1646","master_room_id":"206","room_code":"A16-155"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":494,"customer_code":"C170494","identity_type":"PERSONAL","identity_id":"C531200(9)","title":"Mr","lastname":"Cheung","firstname":"Sai Pui","companyname":"","email":null,"tel":"92070072","address":"\u9999\u6e2f\u4ed4\u4e2d\u5fc3\u6d77\u9f8d\u95a33\u6a131\u5ba4","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1205.0","renew_rent_month":"3","renew_warehousing_date":"2020-09-12","renew_room_key":"052,30473,076,34911","renew_remark":"3 months contract. Special offer $200 "Come back again" coupon. Storage rental paid by EPS on February 29, 2020. Storage deposit transferred from agreement A14-CT195315 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207276, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"38","order_discount":[],"order_room":[{"room_id":"454","room_code":"J36","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1139,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6634,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"200.00","warehousing_date":"2020-06-11","rent_from":"2020-06-11","rent_to":"2020-12-10","delivery_service":"0","remark":"6 months contract. Special offer $200 \"Come back again\" coupon. Storage rental paid by EPS on February 29, 2020. Storage deposit transferred from agreement A14-CT195315 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":200,"order_total":6834,"final_order_total":6634,"location_id":"2","branch_id":"1","company_id":"1","room_key":"052,30473,076,34911","order_product":[],"pass":true}},"first_order_id":"4142","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> J36 <\/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> <\/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":"1139.00","deposit":"0.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:12:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",494,"NEW","A14-CT207277",1528,1139,0,0,"6","6",6634,6834,6634,"2020-02-29 12:12:33","0",null,null,null,"2020-06-11","2020-12-10","6 months contract. Special offer $200 \"Come back again\" coupon. Storage rental paid by EPS on February 29, 2020. Storage deposit transferred from agreement A14-CT195315 to this agreement.\r\n","2020-06-11","20",0,null,200,"200.00","2","2020-02-29 12:12:33","2","2020-02-29 12:12:33","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"052,30473,076,34911","C170494","PERSONAL","Mr","UKoGzVPoLz4Ey6q++gHanQ==","vCxOlXQuvOQaoL822H2o\/Q==","","hI6IrHjcy5pLAjEBRvfJ4wWjUBiKlW6CSZppVj5CYxP3Zxg2dkgqfFUPLbcoyXKo","\/v9UEQAg9dNWum9CzCoWKg==",null,"a8ZGBYUHc3bnjwCIinDdfA==",null,1,"4142"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:12:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7277","454","1528.0","1528.00","2","2020-02-29 12:12:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:12:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-11","2020-12-10","454"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-29 12:12:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7277",494,"SETTLED","A14-I207605","2020-02-29 12:12:33","2020-06-11","2","2020-02-29 12:12:33","2","2020-02-29 12:12:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:12:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7605","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,939,"MO","1",939,"2","2020-02-29 12:12:33","2","2020-02-29 12:12:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:12:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7605","RENT","\u9810\u7e73\u79df\u91d1",2,1139,"MO","1",1139,"2","2020-02-29 12:12:33","2","2020-02-29 12:12:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:12:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7605","RENT","\u9810\u7e73\u79df\u91d1",3,1139,"MO","1",1139,"2","2020-02-29 12:12:33","2","2020-02-29 12:12:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:12:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7605","RENT","\u9810\u7e73\u79df\u91d1",4,1139,"MO","1",1139,"2","2020-02-29 12:12:33","2","2020-02-29 12:12:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:12:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7605","RENT","\u9810\u7e73\u79df\u91d1",5,1139,"MO","1",1139,"2","2020-02-29 12:12:33","2","2020-02-29 12:12:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:12:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7605","RENT","\u9810\u7e73\u79df\u91d1",6,1139,"MO","1",1139,"2","2020-02-29 12:12:33","2","2020-02-29 12:12:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:12:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6634,0,"7605"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-29 12:12:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[494,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207253","2020-02-29 12:12:33",6634,"2","2020-02-29 12:12:33","2","2020-02-29 12:12:33","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:12:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7253","DEPOSIT",null,"PAID","2020-02-29 12:12:33",0,"2","2020-02-29 12:12:33","2","2020-02-29 12:12:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:12:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7253","INVOICE","7605","PAID","2020-02-29 12:12:33",6634,"2","2020-02-29 12:12:33","2","2020-02-29 12:12:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:16:14","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=494&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1646","master_room_id":"206","room_code":"A16-155"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1025,"customer_code":"C181025","identity_type":"PERSONAL","identity_id":"D304320(8)","title":"Ms","lastname":"Chi","firstname":"Chung Lin","companyname":"","email":"ruthclchi2@gmail.com","tel":"92079203","address":"Flat E, 27\/F, Block 5, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"12","renew_warehousing_date":"2020-03-01","renew_room_key":"0005941404;0006005604","renew_remark":"12 months contract. Storage rental and deposit paid by EPS on February 22, 2019. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT194433, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2580.0","renew_master_room_id":"114","order_discount":[],"order_room":[{"room_id":"1018","room_code":"A05-016","retail_price":"1290.0","discounted_price":"1290.00","location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":13944,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1162.00","warehousing_date":"2020-03-01","rent_from":"2020-03-01","rent_to":"2021-03-31","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by cheque on February 29, 2020. Storage deposit $2580 transferred from agreement A05-CT194433 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":1162,"order_total":15106,"final_order_total":13944,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0005941404;0006005604","order_product":[],"pass":true}},"first_order_id":4433,"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-016 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1162.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:16:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1025,"NEW","A05-CT207278",1290,1162,0,0,"13","13",13944,15106,13944,"2020-02-29 12:16:14","0",null,null,null,"2020-03-01","2021-03-31","13 months contract. Special offer the 13th month free. Storage rental paid by cheque on February 29, 2020. Storage deposit $2580 transferred from agreement A05-CT194433 to this agreement. ","2020-03-01","16",0,null,1162,"1162.00","2","2020-02-29 12:16:14","2","2020-02-29 12:16:14","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"0005941404;0006005604","C181025","PERSONAL","Ms","YxYC6+6JbCHQfZfTQEbknQ==","F9hHqfEpbwzOOQkdZVNx4g==","","OFM+xQoHCxILqQX6lBsfurETZ6Zbkr8W20WZTkMbKtGDMjgq567sLJ59oONBPtSe79LmiKmxPavzockl1UQ2ag==","cfTXaqqlfPckLJIxa8XNRg==","3Xv\/dgIiAyJLrhh3f1qwzWXVhor7ZDQtK6c5f+uCWVo=","aAjyYBtytPn8NQK+5GD5Aw==",null,1,4433]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:16:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7278","1018","1290.0","1290.00","2","2020-02-29 12:16:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:16:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-01","2021-03-31","1018"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-29 12:16:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7278",1025,"SETTLED","A05-I207606","2020-02-29 12:16:14","2020-03-01","2","2020-02-29 12:16:14","2","2020-02-29 12:16:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:16:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7606","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1162,"MO","1",1162,"2","2020-02-29 12:16:14","2","2020-02-29 12:16:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:16:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7606","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-02-29 12:16:14","2","2020-02-29 12:16:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:16:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7606","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-02-29 12:16:14","2","2020-02-29 12:16:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:16:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7606","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-02-29 12:16:14","2","2020-02-29 12:16:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:16:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7606","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-02-29 12:16:14","2","2020-02-29 12:16:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:16:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7606","RENT","\u9810\u7e73\u79df\u91d1",7,1162,"MO","1",1162,"2","2020-02-29 12:16:14","2","2020-02-29 12:16:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:16:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7606","RENT","\u9810\u7e73\u79df\u91d1",8,1162,"MO","1",1162,"2","2020-02-29 12:16:14","2","2020-02-29 12:16:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:16:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7606","RENT","\u9810\u7e73\u79df\u91d1",9,1162,"MO","1",1162,"2","2020-02-29 12:16:14","2","2020-02-29 12:16:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:16:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7606","RENT","\u9810\u7e73\u79df\u91d1",10,1162,"MO","1",1162,"2","2020-02-29 12:16:14","2","2020-02-29 12:16:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:16:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7606","RENT","\u9810\u7e73\u79df\u91d1",11,1162,"MO","1",1162,"2","2020-02-29 12:16:14","2","2020-02-29 12:16:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:16:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7606","RENT","\u9810\u7e73\u79df\u91d1",12,1162,"MO","1",1162,"2","2020-02-29 12:16:14","2","2020-02-29 12:16:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:16:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7606","RENT","\u9810\u7e73\u79df\u91d1",13,1162,"MO","1",1162,"2","2020-02-29 12:16:14","2","2020-02-29 12:16:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:16:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13944,0,"7606"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-29 12:16:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1025,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207254","2020-02-29 12:16:14",13944,"2","2020-02-29 12:16:14","2","2020-02-29 12:16:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:16:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7254","DEPOSIT",null,"PAID","2020-02-29 12:16:14",0,"2","2020-02-29 12:16:14","2","2020-02-29 12:16:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:16:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7254","INVOICE","7606","PAID","2020-02-29 12:16:14",13944,"2","2020-02-29 12:16:14","2","2020-02-29 12:16:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:44:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 12:45:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 13:14:34","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=494&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1646","master_room_id":"206","room_code":"A16-155"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":469,"customer_code":"C170469","identity_type":"PERSONAL","identity_id":"E562535(5)","title":"Mr","lastname":"Poon ","firstname":"Yin Ming","companyname":"","email":null,"tel":"67039272","address":"Rm1403,14\/F,Ming Cheun House,Shui Chuen O Estate,Sha Tin","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-24","renew_room_key":"133,33462","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 28, 2020. Storage deposit transferred from agreement A14-CT207045 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207054, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"625","room_code":"M36","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-24","rent_from":"2020-02-24","rent_to":"2020-03-23","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on February 28, 2020. Storage deposit transferred from agreement A14-CT207054 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"133,33462","order_product":[],"pass":true}},"first_order_id":"4725","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> M36 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 13:14:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",469,"NEW","A14-CT207279",598,598,0,0,"1","1",598,598,598,"2020-02-29 13:14:35","0",null,null,null,"2020-02-24","2020-03-23","1 month contract. Storage rental paid by bank transfer on February 28, 2020. Storage deposit transferred from agreement A14-CT207054 to this agreement.","2020-02-24","12",0,null,0,"0","2","2020-02-29 13:14:34","2","2020-02-29 13:14:34","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"133,33462","C170469","PERSONAL","Mr","7zuhiU2fzaatGP2D2mnAJA==","c9CkZ4cZzKCidNu3YYjrkw==","","QJ5AY46e6jExLz0oVTYEajr8ICB272rxLBtUMHgM2LeYYJatyO4QCPJb6GJOXbbZ2qJarCJxAoCZti1Uif3gKw==","2+3VDW\/cQQxeWAv\/Fi3w0Q==",null,"So0zSsBwxE4\/4T3R4c76WA==",null,1,"4725"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 13:14:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7279","625","598.0","598.00","2","2020-02-29 13:14:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 13:14:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-24","2020-03-23","625"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-29 13:14:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7279",469,"SETTLED","A14-I207607","2020-02-29 13:14:34","2020-02-24","2","2020-02-29 13:14:34","2","2020-02-29 13:14:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 13:14:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7607","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-02-29 13:14:34","2","2020-02-29 13:14:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 13:14:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7607"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-29 13:14:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[469,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207255","2020-02-29 13:14:34",598,"2","2020-02-29 13:14:34","2","2020-02-29 13:14:34","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 13:14:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7255","DEPOSIT",null,"PAID","2020-02-29 13:14:34",0,"2","2020-02-29 13:14:34","2","2020-02-29 13:14:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 13:14:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7255","INVOICE","7607","PAID","2020-02-29 13:14:34",598,"2","2020-02-29 13:14:34","2","2020-02-29 13:14:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 13:30:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-29 13:31:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****