{"created_at":"2020-03-24 10:30:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 10:37:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 11:38:43","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":346,"customer_code":"C170346","identity_type":"PERSONAL","identity_id":"D094885(4)","title":"Ms","lastname":"Cheung","firstname":"Wai King","companyname":"","email":null,"tel":"98397211","address":"\u9999\u6e2f\u9999\u6e2f\u4ed4\u4e2d\u5fc3\u7f8e\u8c50\u95a318\u6a133\u5ba4","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"969.0","renew_rent_month":"3","renew_warehousing_date":"2020-04-01","renew_room_key":"055,31553","renew_remark":"3 months contract. Storage rental paid by EPS on December 17, 2018. Storage deposit transferred from agreement A14-CT183955 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196712, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"43","order_discount":[],"order_room":[{"room_id":"701","room_code":"N18","retail_price":"1138.0","discounted_price":"1138.00","location_id":"2"}],"roughly_size":"15","total_retail_price":1138,"total_discounted_price":918,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":11016,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-01","rent_from":"2020-04-01","rent_to":"2021-03-31","delivery_service":"0","remark":"12 months contract. Special offer $300 Maxim's voucher. Storage rental paid by EPS on March 24, 2020. Storage deposit transferred from agreement A14-CT196712 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":11016,"final_order_total":11016,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,31553","order_product":[],"pass":true}},"first_order_id":"3955","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>
N18 <\/td>\r\n\t\t\t\t\t	3X5X8 <\/td>\r\n\t\t\t\t\t	$1138.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"15","total_discounted_price":"918.00","deposit":"0.00","total_retail_price":"1138.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 11:38:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",346,"NEW","A14-CT207474",1138,918,0,0,"12","12",11016,11016,11016,"2020-03-24 11:38:44","0",null,null,null,"2020-04-01","2021-03-31","12 months contract. Special offer $300 Maxim's voucher. Storage rental paid by EPS on March 24, 2020. Storage deposit transferred from agreement A14-CT196712 to this agreement.","2020-04-01","15",0,null,0,"0","2","2020-03-24 11:38:43","2","2020-03-24 11:38:43","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"055,31553","C170346","PERSONAL","Ms","biASjPGS9upFO2PbGWyo3w==","vCxOlXQuvOQaoL822H2o\/Q==","","kKzhLGinyumdmKLn8FfxRqriv1rgrwcfVQ8LdeLUBBCfjAGvyqb38l91YGC54j\/X","EUHL0064KkIjjAWVpPFvSw==",null,"Hgvwo0mSATJwzXYzCEKGIA==",null,1,"3955"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 11:38:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7474","701","1138.0","1138.00","2","2020-03-24 11:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 11:38:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-01","2021-03-31","701"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-24 11:38:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7474",346,"SETTLED","A14-I207802","2020-03-24 11:38:43","2020-04-01","2","2020-03-24 11:38:43","2","2020-03-24 11:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 11:38:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7802","RENT","\u9810\u7e73\u79df\u91d1",1,918,"MO","1",918,"2","2020-03-24 11:38:43","2","2020-03-24 11:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 11:38:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7802","RENT","\u9810\u7e73\u79df\u91d1",2,918,"MO","1",918,"2","2020-03-24 11:38:43","2","2020-03-24 11:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 11:38:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7802","RENT","\u9810\u7e73\u79df\u91d1",3,918,"MO","1",918,"2","2020-03-24 11:38:43","2","2020-03-24 11:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 11:38:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7802","RENT","\u9810\u7e73\u79df\u91d1",4,918,"MO","1",918,"2","2020-03-24 11:38:43","2","2020-03-24 11:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 11:38:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7802","RENT","\u9810\u7e73\u79df\u91d1",5,918,"MO","1",918,"2","2020-03-24 11:38:43","2","2020-03-24 11:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 11:38:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7802","RENT","\u9810\u7e73\u79df\u91d1",6,918,"MO","1",918,"2","2020-03-24 11:38:43","2","2020-03-24 11:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 11:38:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7802","RENT","\u9810\u7e73\u79df\u91d1",7,918,"MO","1",918,"2","2020-03-24 11:38:43","2","2020-03-24 11:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 11:38:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7802","RENT","\u9810\u7e73\u79df\u91d1",8,918,"MO","1",918,"2","2020-03-24 11:38:43","2","2020-03-24 11:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 11:38:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7802","RENT","\u9810\u7e73\u79df\u91d1",9,918,"MO","1",918,"2","2020-03-24 11:38:43","2","2020-03-24 11:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 11:38:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7802","RENT","\u9810\u7e73\u79df\u91d1",10,918,"MO","1",918,"2","2020-03-24 11:38:43","2","2020-03-24 11:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 11:38:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7802","RENT","\u9810\u7e73\u79df\u91d1",11,918,"MO","1",918,"2","2020-03-24 11:38:43","2","2020-03-24 11:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 11:38:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7802","RENT","\u9810\u7e73\u79df\u91d1",12,918,"MO","1",918,"2","2020-03-24 11:38:43","2","2020-03-24 11:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 11:38:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11016,0,"7802"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-24 11:38:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[346,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207450","2020-03-24 11:38:43",11016,"2","2020-03-24 11:38:43","2","2020-03-24 11:38:43","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 11:38:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7450","DEPOSIT",null,"PAID","2020-03-24 11:38:43",0,"2","2020-03-24 11:38:43","2","2020-03-24 11:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 11:38:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7450","INVOICE","7802","PAID","2020-03-24 11:38:43",11016,"2","2020-03-24 11:38:43","2","2020-03-24 11:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 11:55:51","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 11:56:06","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 11:58:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:07:58","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_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":"899.0","renew_rent_month":"6","renew_warehousing_date":"2020-03-27","renew_room_key":"","renew_remark":"6 months contract. Special offer $500 coupon. Storage rental and deposit paid by cash on Sep 25,2019. Padlock provided on 25 Sep,2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196024, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1996.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"662","room_code":"M73","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":899,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5394,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-27","rent_from":"2020-03-27","rent_to":"2020-09-26","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on March 23, 2020. Storage deposit $1996 transferred from agreement A14-CT196024 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5394,"final_order_total":5394,"location_id":"2","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"first_order_id":6024,"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> M73 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"899.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:07:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",571,"NEW","A14-CT207475",998,899,0,0,"6","6",5394,5394,5394,"2020-03-24 12:07:59","0",null,null,null,"2020-03-27","2020-09-26","6 months contract. Storage rental paid by bank transfer on March 23, 2020. Storage deposit $1996 transferred from agreement A14-CT196024 to this agreement.","2020-03-27","12",0,null,0,"0","2","2020-03-24 12:07:58","2","2020-03-24 12:07:58","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"","C170571","PERSONAL","Mr","LmqwEM+jE6r9IRvnsHAfPQ==","UCPBCXrBLI9U7KKsPqgmNA==","","UblVtA4KAomEZyvTLUKcvNmmbFgTfY4qXDwQ5LiEoFfnyEo8Vlid8YsgeuossH7GiwTx9tUOyF3W8NNk3F8Hfg==","XE4IAvFAXtblV\/n3BRBQDQ==",null,"4f+sN7shrTK\/6Vskm23nAA==",null,1,6024]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:07:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7475","662","998.0","998.00","2","2020-03-24 12:07:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:07:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-27","2020-09-26","662"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-24 12:07:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7475",571,"SETTLED","A14-I207803","2020-03-24 12:07:58","2020-03-27","2","2020-03-24 12:07:58","2","2020-03-24 12:07:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:07:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7803","RENT","\u9810\u7e73\u79df\u91d1",1,899,"MO","1",899,"2","2020-03-24 12:07:58","2","2020-03-24 12:07:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:07:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7803","RENT","\u9810\u7e73\u79df\u91d1",2,899,"MO","1",899,"2","2020-03-24 12:07:58","2","2020-03-24 12:07:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:07:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7803","RENT","\u9810\u7e73\u79df\u91d1",3,899,"MO","1",899,"2","2020-03-24 12:07:58","2","2020-03-24 12:07:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:07:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7803","RENT","\u9810\u7e73\u79df\u91d1",4,899,"MO","1",899,"2","2020-03-24 12:07:58","2","2020-03-24 12:07:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:07:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7803","RENT","\u9810\u7e73\u79df\u91d1",5,899,"MO","1",899,"2","2020-03-24 12:07:58","2","2020-03-24 12:07:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:07:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7803","RENT","\u9810\u7e73\u79df\u91d1",6,899,"MO","1",899,"2","2020-03-24 12:07:58","2","2020-03-24 12:07:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:07:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5394,0,"7803"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-24 12:07:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[571,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207451","2020-03-24 12:07:58",5394,"2","2020-03-24 12:07:58","2","2020-03-24 12:07:58","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:07:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7451","DEPOSIT",null,"PAID","2020-03-24 12:07:58",0,"2","2020-03-24 12:07:58","2","2020-03-24 12:07:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:07:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7451","INVOICE","7803","PAID","2020-03-24 12:07:58",5394,"2","2020-03-24 12:07:58","2","2020-03-24 12:07:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:09:54","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","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-03-24","renew_room_key":"133,33462","renew_remark":"1 month contract. Storage rental paid by bank transfer on February 28, 2020. Storage deposit transferred from agreement A14-CT207054 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207279, \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-03-24","rent_from":"2020-03-24","rent_to":"2020-04-23","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on March 24, 2020. Storage deposit transferred from agreement A14-CT207279 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-03-24 12:09: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","2",469,"NEW","A14-CT207476",598,598,0,0,"1","1",598,598,598,"2020-03-24 12:09:54","0",null,null,null,"2020-03-24","2020-04-23","1 month contract. Storage rental paid by bank transfer on March 24, 2020. Storage deposit transferred from agreement A14-CT207279 to this agreement.","2020-03-24","12",0,null,0,"0","2","2020-03-24 12:09:54","2","2020-03-24 12:09:54","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-03-24 12:09: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":["7476","625","598.0","598.00","2","2020-03-24 12:09:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:09: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-24","2020-04-23","625"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-24 12:09: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":["7476",469,"SETTLED","A14-I207804","2020-03-24 12:09:54","2020-03-24","2","2020-03-24 12:09:54","2","2020-03-24 12:09:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:09: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":["7804","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-03-24 12:09:54","2","2020-03-24 12:09:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:09:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7804"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-24 12:09: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":[469,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207452","2020-03-24 12:09:54",598,"2","2020-03-24 12:09:54","2","2020-03-24 12:09:54","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:09: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":["7452","DEPOSIT",null,"PAID","2020-03-24 12:09:54",0,"2","2020-03-24 12:09:54","2","2020-03-24 12:09:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:09: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":["7452","INVOICE","7804","PAID","2020-03-24 12:09:54",598,"2","2020-03-24 12:09:54","2","2020-03-24 12:09:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:23:21","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=888&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","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":"1112.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-27","renew_room_key":"0005763937","renew_remark":"1 month contract. Storage rental paid by PPS on February 17, 2020. Storage deposit $2224 transferred from agreement B01-CT207012 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT207219, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"140","order_discount":[],"order_room":[{"room_id":"1237","room_code":"B01-047","retail_price":"1112.0","discounted_price":"1112.00","location_id":"5"}],"roughly_size":"16","total_retail_price":1112,"total_discounted_price":1112,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1112,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-27","rent_from":"2020-03-27","rent_to":"2020-04-26","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on March 20, 2020. Storage deposit $2224 transferred from agreement B01-CT207219 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1112,"final_order_total":1112,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0005763937","order_product":[],"pass":true}},"first_order_id":"4003","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-047 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1112.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":"16","total_discounted_price":"1112.0","deposit":"0","total_retail_price":"1112.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:23:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","2","5",888,"NEW","B01-CT207477",1112,1112,0,0,"1","1",1112,1112,1112,"2020-03-24 12:23:22","0",null,null,null,"2020-03-27","2020-04-26","1 month contract. Storage rental paid by PPS on March 20, 2020. Storage deposit $2224 transferred from agreement B01-CT207219 to this agreement.\r\n","2020-03-27","16",0,null,0,"0","2","2020-03-24 12:23:21","2","2020-03-24 12:23:21","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,"4003"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:23:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7477","1237","1112.0","1112.00","2","2020-03-24 12:23:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:23:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-27","2020-04-26","1237"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-24 12:23:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7477",888,"SETTLED","B01-I207805","2020-03-24 12:23:21","2020-03-27","2","2020-03-24 12:23:21","2","2020-03-24 12:23:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:23:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7805","RENT","\u9810\u7e73\u79df\u91d1",1,1112,"MO","1",1112,"2","2020-03-24 12:23:21","2","2020-03-24 12:23:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:23:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1112,0,"7805"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-24 12:23:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[888,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207453","2020-03-24 12:23:21",1112,"2","2020-03-24 12:23:21","2","2020-03-24 12:23:21","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:23:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7453","DEPOSIT",null,"PAID","2020-03-24 12:23:21",0,"2","2020-03-24 12:23:21","2","2020-03-24 12:23:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 12:23:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7453","INVOICE","7805","PAID","2020-03-24 12:23:21",1112,"2","2020-03-24 12:23:21","2","2020-03-24 12:23:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:01:51","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=888&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":506,"customer_code":"C170506","identity_type":"PERSONAL","identity_id":"D435016(3)","title":"Mr","lastname":"Kwok","firstname":"Chi Kong","companyname":"","email":"kwokchikong@gmail.com","tel":"91520880","address":"\u9d28\u8137\u6d32\u5229\u679d\u9053145\u865f\u91d1\u767c\u5927\u5ec85\u6a13F\u5ba4","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-15","renew_room_key":"054,46844","renew_remark":"1 month contract. Storage rental paid by PPS on February 24, 2020. Storage deposit transferred from agreement A12-CT206980 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207259, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"243","room_code":"D47","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":998,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-15","rent_from":"2020-03-15","rent_to":"2020-04-14","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on March 23, 2020. Storage deposit transferred from agreement A12-CT207259 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":998,"final_order_total":998,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,46844","order_product":[],"pass":true}},"first_order_id":"4192","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> D47 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"998.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:01:51","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",506,"NEW","A12-CT207478",998,998,0,0,"1","1",998,998,998,"2020-03-24 14:01:51","0",null,null,null,"2020-03-15","2020-04-14","1 month contract. Storage rental paid by PPS on March 23, 2020. Storage deposit transferred from agreement A12-CT207259 to this agreement.\r\n","2020-03-15","12",0,null,0,"0","2","2020-03-24 14:01:51","2","2020-03-24 14:01:51","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,46844","C170506","PERSONAL","Mr","m+azv2CUGWm2lPm4xNx9sA==","+pNULpsInm3siHASV0hIrg==","","LwVAteVJ0ZkV+zmR7qIDhOZ88Sc7Q+u3tsoHaiRzz2YCnm7wtowmDZcdUdskzm9A","22F8u0roh3XfvK0e6+ag3g==","WR6bE6RUwKqp5feySv5edgfk8AMEkZpUrE0\/8O+jORg=","Rmwt5dKGhWq\/pC\/sJ3hH+A==",null,1,"4192"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:01:51","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":["7478","243","998.0","998.00","2","2020-03-24 14:01:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:01:51","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-15","2020-04-14","243"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-24 14:01:51","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":["7478",506,"SETTLED","A12-I207806","2020-03-24 14:01:51","2020-03-15","2","2020-03-24 14:01:51","2","2020-03-24 14:01:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:01:51","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":["7806","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-03-24 14:01:51","2","2020-03-24 14:01:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:01:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"7806"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-24 14:01:51","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":[506,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207454","2020-03-24 14:01:51",998,"2","2020-03-24 14:01:51","2","2020-03-24 14:01:51","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:01:51","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":["7454","DEPOSIT",null,"PAID","2020-03-24 14:01:51",0,"2","2020-03-24 14:01:51","2","2020-03-24 14:01:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:01:51","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":["7454","INVOICE","7806","PAID","2020-03-24 14:01:51",998,"2","2020-03-24 14:01:51","2","2020-03-24 14:01:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:04: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","index_url_parameter":"filter1=1&filter2=888&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":506,"customer_code":"C170506","identity_type":"PERSONAL","identity_id":"D435016(3)","title":"Mr","lastname":"Kwok","firstname":"Chi Kong","companyname":"","email":"kwokchikong@gmail.com","tel":"91520880","address":"\u9d28\u8137\u6d32\u5229\u679d\u9053145\u865f\u91d1\u767c\u5927\u5ec85\u6a13F\u5ba4","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1286.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-17","renew_room_key":"054,46844","renew_remark":"1 month contract. Storage rental paid by PPS on February 24, 2020. Storage deposit transferred from agreement A12-CT206979 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207258, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"113","room_code":"B61","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1286,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1286,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-17","rent_from":"2020-03-17","rent_to":"2020-04-16","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on March 24, 2020. Storage deposit transferred from agreement A12-CT207258 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1286,"final_order_total":1286,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,46844","order_product":[],"pass":true}},"first_order_id":"4179","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> B61 <\/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":"1286.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:04:25","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",506,"NEW","A12-CT207479",1528,1286,0,0,"1","1",1286,1286,1286,"2020-03-24 14:04:25","0",null,null,null,"2020-03-17","2020-04-16","1 month contract. Storage rental paid by PPS on March 24, 2020. Storage deposit transferred from agreement A12-CT207258 to this agreement.\r\n","2020-03-17","20",0,null,0,"0","2","2020-03-24 14:04:25","2","2020-03-24 14:04:25","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,46844","C170506","PERSONAL","Mr","m+azv2CUGWm2lPm4xNx9sA==","+pNULpsInm3siHASV0hIrg==","","LwVAteVJ0ZkV+zmR7qIDhOZ88Sc7Q+u3tsoHaiRzz2YCnm7wtowmDZcdUdskzm9A","22F8u0roh3XfvK0e6+ag3g==","WR6bE6RUwKqp5feySv5edgfk8AMEkZpUrE0\/8O+jORg=","Rmwt5dKGhWq\/pC\/sJ3hH+A==",null,1,"4179"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:04:25","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":["7479","113","1528.0","1528.00","2","2020-03-24 14:04:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:04:25","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","2020-04-16","113"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-24 14:04:25","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":["7479",506,"SETTLED","A12-I207807","2020-03-24 14:04:25","2020-03-17","2","2020-03-24 14:04:25","2","2020-03-24 14:04:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:04:25","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":["7807","RENT","\u9810\u7e73\u79df\u91d1",1,1286,"MO","1",1286,"2","2020-03-24 14:04:25","2","2020-03-24 14:04:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:04:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1286,0,"7807"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-24 14:04:25","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":[506,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207455","2020-03-24 14:04:25",1286,"2","2020-03-24 14:04:25","2","2020-03-24 14:04:25","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:04:25","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":["7455","DEPOSIT",null,"PAID","2020-03-24 14:04:25",0,"2","2020-03-24 14:04:25","2","2020-03-24 14:04:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:04:25","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":["7455","INVOICE","7807","PAID","2020-03-24 14:04:25",1286,"2","2020-03-24 14:04:25","2","2020-03-24 14:04:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:06:20","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=888&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":448,"customer_code":"C170448","identity_type":"PERSONAL","identity_id":"Z011806(1)","title":"Mr","lastname":"Hau","firstname":"Hil Yeung","companyname":"","email":"hermannhau@gmail.com","tel":"97139457","address":"Flat H,2\/F,Block 2,Chi Fu Fa Yuen,Pok Fu Lam,Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2022.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-15","renew_room_key":"053,46811","renew_remark":"1 month contract. Storage rental paid by PPS on February 19, 2020. Storage deposit transferred from agreement A14-CT206933 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207229, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"549","room_code":"L27","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"548","room_code":"L26","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":2022,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2022,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-15","rent_from":"2020-03-15","rent_to":"2020-04-14","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on March 23, 2020. Storage deposit transferred from agreement A14-CT207229 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":2022,"final_order_total":2022,"location_id":"2","branch_id":"1","company_id":"1","room_key":"053,46811","order_product":[],"pass":true}},"first_order_id":"4790","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> L27 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> L26 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"2022.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:06:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",448,"NEW","A14-CT207480",2196,2022,0,0,"1","1",2022,2022,2022,"2020-03-24 14:06:20","0",null,null,null,"2020-03-15","2020-04-14","1 month contract. Storage rental paid by PPS on March 23, 2020. Storage deposit transferred from agreement A14-CT207229 to this agreement.\r\n","2020-03-15","32",0,null,0,"0","2","2020-03-24 14:06:20","2","2020-03-24 14:06:20","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"053,46811","C170448","PERSONAL","Mr","NVv9pRh+D1VmYB2XsurgEQ==","8OcLe\/VzxU\/Xek1BNlpsfQ==","","0QpZaBXqoW5CgaBIwDwpjWtY5YJYGo9YtwWqdo6IK1Fg9YHW9ZmtiUF11gEm1OcOe3VhZDJuL+H\/IV+pZmf2Kw==","tujHTZIsGcqjKeaOnttAvg==","jGafPuxpS3yTCisx0O3a7o2TE03wjvCrNp2lr0gCkFw=","y4ZDYxl9X3dwkt7\/dDApww==",null,1,"4790"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:06:20","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":["7480","549","1098.0","1098.00","2","2020-03-24 14:06:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:06:20","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-15","2020-04-14","549"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-24 14:06:20","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":["7480","548","1098.0","1098.00","2","2020-03-24 14:06:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:06:20","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-15","2020-04-14","548"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-24 14:06:20","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":["7480",448,"SETTLED","A14-I207808","2020-03-24 14:06:20","2020-03-15","2","2020-03-24 14:06:20","2","2020-03-24 14:06:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:06:20","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":["7808","RENT","\u9810\u7e73\u79df\u91d1",1,2022,"MO","1",2022,"2","2020-03-24 14:06:20","2","2020-03-24 14:06:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:06:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2022,0,"7808"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-24 14:06:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[448,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207456","2020-03-24 14:06:20",2022,"2","2020-03-24 14:06:20","2","2020-03-24 14:06:20","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:06:20","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":["7456","DEPOSIT",null,"PAID","2020-03-24 14:06:20",0,"2","2020-03-24 14:06:20","2","2020-03-24 14:06:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:06:20","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":["7456","INVOICE","7808","PAID","2020-03-24 14:06:20",2022,"2","2020-03-24 14:06:20","2","2020-03-24 14:06:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:12:12","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=888&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"535","master_room_id":"35","room_code":"L13"},{"room_id":"536","master_room_id":"35","room_code":"L14"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> L13 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> L14 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"Z011806(1)","title":"Mr","lastname":"Hau","firstname":"Hil Yeung","companyname":"","email":"hermannhau@gmail.com","tel":"97139457","address":"Flat H,2\/F,Block 2,Chi Fu Fa Yuen,Pok Fu Lam,Hong Kong","pass":true,"customer_id":"448","customer_code":"C170448","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"535","room_code":"L13","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"536","room_code":"L14","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":2318,"deposit":4636,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":6658,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"296.00","warehousing_date":"2020-03-24","rent_from":"2020-03-24","rent_to":"2020-04-23","delivery_service":"0","remark":"1 month contract. Special offer $2022\/month. Storage rental $2022 paid by PPS on March 02, 2020. Storage deposit $4636 paid by PPS on March 23, 2020. ","paymethod":"PPS","paymethod2":"PPS","discount_deduct":296,"order_total":6954,"final_order_total":6658,"location_id":"2","branch_id":"1","company_id":"1","room_key":"053,46811","order_product":[],"pass":true}},"roughly_size":"32","total_discounted_price":"2318.00","deposit":"4636.00","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:12:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2","448","NEW","A14-CT207481",2196,2318,4636,0,"1","1",6658,6954,6658,"2020-03-24 14:12:12","0",null,null,null,"2020-03-24","2020-04-23","1 month contract. Special offer $2022\/month. Storage rental $2022 paid by PPS on March 02, 2020. Storage deposit $4636 paid by PPS on March 23, 2020. ","2020-03-24","32",0,null,296,"296.00","2","2020-03-24 14:12:12","2","2020-03-24 14:12:12","PPS","","","","PPS","","","",null,0,"053,46811","C170448","PERSONAL","Mr","NVv9pRh+D1VmYB2XsurgEQ==","8OcLe\/VzxU\/Xek1BNlpsfQ==","","0QpZaBXqoW5CgaBIwDwpjWtY5YJYGo9YtwWqdo6IK1Fg9YHW9ZmtiUF11gEm1OcOe3VhZDJuL+H\/IV+pZmf2Kw==","tujHTZIsGcqjKeaOnttAvg==","jGafPuxpS3yTCisx0O3a7o2TE03wjvCrNp2lr0gCkFw=","y4ZDYxl9X3dwkt7\/dDApww==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:12:12","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":["7481","535","1098.0","1098.00","2","2020-03-24 14:12:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:12:12","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-24","2020-04-23","535"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-24 14:12:12","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":["7481","536","1098.0","1098.00","2","2020-03-24 14:12:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:12:12","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-24","2020-04-23","536"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-24 14:12:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["7481","A14-D205335","PAID",4636,0,"2020-04-23","2020-03-24 14:12:12","2020-03-24 14:12:12","2","2020-03-24 14:12:12","2","2020-03-24 14:12:12","448"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:12:12","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":["7481","448","SETTLED","A14-I207809","2020-03-24 14:12:12","2020-03-24","2","2020-03-24 14:12:12","2","2020-03-24 14:12:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:12:12","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":["7809","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,2022,"MO","1",2022,"2","2020-03-24 14:12:12","2","2020-03-24 14:12:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:12:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2022,0,"7809"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-24 14:12:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["448","PPS","","","","PPS","","","","PAID","P207457","2020-03-24 14:12:12",6658,"2","2020-03-24 14:12:12","2","2020-03-24 14:12:12","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:12:12","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":["7457","DEPOSIT","5335","PAID","2020-03-24 14:12:12",4636,"2","2020-03-24 14:12:12","2","2020-03-24 14:12:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:12:12","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":["7457","INVOICE","7809","PAID","2020-03-24 14:12:12",2022,"2","2020-03-24 14:12:12","2","2020-03-24 14:12:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:34:40","login_id":"2","controller":"room_modify.php","function":"update query","input":{"sql":"update room set code = ?, status = ?, master_room_id = ?, typeid = ?, lastupby = ?, lastupdate = ? where id = ?","parameters":["B01-016","RENTED","140","STORAGE","2","2020-03-24 14:34:40","1206"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:34:40","login_id":"2","controller":"room_modify.php","function":"update query","input":{"sql":"update room set code = ?, status = ?, master_room_id = ?, typeid = ?, lastupby = ?, lastupdate = ? where id = ?","parameters":["B01-017","RENTED","140","STORAGE","2","2020-03-24 14:34:40","1207"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 14:34:40","login_id":"2","controller":"room_modify.php","function":"update query","input":{"sql":"update room set code = ?, status = ?, master_room_id = ?, typeid = ?, lastupby = ?, lastupdate = ? where id = ?","parameters":["B01-018","RENTED","140","STORAGE","2","2020-03-24 14:34:40","1208"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 15:09:19","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=1125&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"535","master_room_id":"35","room_code":"L13"},{"room_id":"536","master_room_id":"35","room_code":"L14"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":735,"customer_code":"C180735","identity_type":"PERSONAL","identity_id":"R709731(9)","title":"Mr","lastname":"Streeter","firstname":"Charles Henry Roger","companyname":"","email":"cstreeter45@gmail.com","tel":"61101289","address":"5C, Four Winds, 4 Mount Davis Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-21","renew_room_key":"136,43021","renew_remark":"6 months contract. Storage rental paid by bank transfer on August 28, 2019. Storage deposit transferred from agreement A14-CT195699 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195800, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"622","room_code":"M33","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":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":1794,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-21","rent_from":"2020-01-21","rent_to":"2020-04-20","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on March 24, 2020. Storage deposit transferred from agreement A14-CT195800 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1794,"final_order_total":1794,"location_id":"2","branch_id":"1","company_id":"1","room_key":"136,43021","order_product":[],"pass":true}},"first_order_id":"4331","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> M33 <\/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.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 15:09:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",735,"NEW","A14-CT207482",598,598,0,0,"3","3",1794,1794,1794,"2020-03-24 15:09:19","0",null,null,null,"2020-01-21","2020-04-20","3 months contract. Storage rental paid by bank transfer on March 24, 2020. Storage deposit transferred from agreement A14-CT195800 to this agreement.\r\n","2020-01-21","12",0,null,0,"0","2","2020-03-24 15:09:19","2","2020-03-24 15:09:19","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,43021","C180735","PERSONAL","Mr","E8v3aBl7jPeHFvgwE1otWJjRl0tGP0hXdF3Uy\/In1kI=","o60emGd+7xhyjtmo5MTKCg==","","LV1yIsfD0SeXuCH8uYLtbTPQkaHL8fbMFx0MbzBf8Xur9jfKOTn0OeMs9agkkywR","uWVZ9PYB4kip+TgFA7dMHQ==","KbgOiyQIhl2qp1+0s81o4XnOhsMzzv2c+EgUINptrLU=","\/XgTp7XLkVjBHGCcTEb8xg==",null,1,"4331"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 15:09:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7482","622","598.0","598.00","2","2020-03-24 15:09:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 15:09:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-21","2020-04-20","622"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-24 15:09:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7482",735,"SETTLED","A14-I207810","2020-03-24 15:09:19","2020-01-21","2","2020-03-24 15:09:19","2","2020-03-24 15:09:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 15:09:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7810","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-03-24 15:09:19","2","2020-03-24 15:09:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 15:09:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7810","RENT","\u9810\u7e73\u79df\u91d1",2,598,"MO","1",598,"2","2020-03-24 15:09:19","2","2020-03-24 15:09:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 15:09:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7810","RENT","\u9810\u7e73\u79df\u91d1",3,598,"MO","1",598,"2","2020-03-24 15:09:19","2","2020-03-24 15:09:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 15:09:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1794,0,"7810"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-24 15:09:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[735,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207458","2020-03-24 15:09:19",1794,"2","2020-03-24 15:09:19","2","2020-03-24 15:09:19","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 15:09:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7458","DEPOSIT",null,"PAID","2020-03-24 15:09:19",0,"2","2020-03-24 15:09:19","2","2020-03-24 15:09:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 15:09:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7458","INVOICE","7810","PAID","2020-03-24 15:09:19",1794,"2","2020-03-24 15:09:19","2","2020-03-24 15:09:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 15:57:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:24:59","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"1306","master_room_id":"141","room_code":"B01-116"}],"selected_room_tr":"\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n\t\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\t\t\t \n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> B01-115 <\/td>\n\t\t\t\t\t 4X5X7 <\/td>\n\t\t\t\t\t $1308.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr> B01-116 <\/td>\n\t\t\t\t\t 4X5X7 <\/td>\n\t\t\t\t\t $1308.00 <\/td>\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"D812474(5)","title":"Mr","lastname":"CHAN","firstname":"Chi Leung Jackie","companyname":"","email":"takjac@gmail.com","tel":"61786499","address":"Flat D, 12\/F, Kwun Fung Mansion, Lei King Wan, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"342","master_room_id":"141","discount_type":"%","price":"1308.00","disocunted_price":"851.00","discount":"34.94","monthly_deduct":457.0152,"room_id":"1306","is_final_discount":"0","payment_term":"PREPAID_12_MO"},{"master_room_discount_id":"342 available_room_list_input","master_room_id":"141","discount_type":"%","price":"1308.00","disocunted_price":"851.00","discount":"34.94","monthly_deduct":457.0152,"room_id":"1305","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1305","room_code":"B01-115","retail_price":"1308.0","discounted_price":851,"location_id":"5"},{"room_id":"1306","room_code":"B01-116","retail_price":"1308.0","discounted_price":851,"location_id":"5"}],"roughly_size":"40","total_retail_price":2616,"total_discounted_price":1879,"deposit":4816,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":21581,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"5783.00","warehousing_date":"2020-04-01","rent_from":"2020-04-01","rent_to":"2021-03-31","delivery_service":"0","remark":"12 months contract. Special offer 50% off for the first 3 months. $1000 deposit paid by PayMe on Mar 14,2020. The balance of storage rental and deposit $20641 paid by bank transfer on Mar 24,2020. Smartcard paid and provided on Mar 14,2020.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":5783,"order_total":27424,"final_order_total":21641,"location_id":"5","branch_id":"2","company_id":"1","room_key":"'0005013005","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"pass":true}},"roughly_size":"40","total_discounted_price":"1879.00","deposit":"4816.00","total_retail_price":"2616.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:25:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201543","PERSONAL","Mr","Nk9YrQbUipz7CtjNG5BkjWzHbNq0N6Ccq++vuamr\/kQ=","8BEgNhGpCR8jGkzUtrIcXg==","","snMpMSeU6qws6emNy1aCjQ==","kAwMfH0pbq1\/i5FdOZdhilz3TMc8FtV02b2PK6J4\/zo=","BC+NOJhAu0SZ3IFT7LPDTmXCWkEvEtkT3VwUhHUX5CrLB\/Y0\/UllvJosxkWbeOIF3cEL\/SYuhfYZS3ubHebu7Q==","DZJiKMefualT0b9z6MIo6A==",null,"kAwMfH0pbq1\/i5FdOZdhilz3TMc8FtV02b2PK6J4\/zo=","F3h+uVWr6ZhpeB4DfVvhvA==","2","2020-03-24 16:24:59","2","2020-03-24 16:24:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:25:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","2","5",1543,"NEW","B01-CT207483",2616,1879,4816,0,"12","12",21581,27424,21641,"2020-03-24 16:25:01","0",null,null,null,"2020-04-01","2021-03-31","12 months contract. Special offer 50% off for the first 3 months. $1000 deposit paid by PayMe on Mar 14,2020. The balance of storage rental and deposit $20641 paid by bank transfer on Mar 24,2020. Smartcard paid and provided on Mar 14,2020.","2020-04-01","40",0,null,5783,"5783.00","2","2020-03-24 16:24:59","2","2020-03-24 16:24:59","BANKIN","","","","BANKIN","","","",null,0,"'0005013005","C201543","PERSONAL","Mr","Nk9YrQbUipz7CtjNG5BkjWzHbNq0N6Ccq++vuamr\/kQ=","8BEgNhGpCR8jGkzUtrIcXg==","","BC+NOJhAu0SZ3IFT7LPDTmXCWkEvEtkT3VwUhHUX5CrLB\/Y0\/UllvJosxkWbeOIF3cEL\/SYuhfYZS3ubHebu7Q==","snMpMSeU6qws6emNy1aCjQ==","kAwMfH0pbq1\/i5FdOZdhilz3TMc8FtV02b2PK6J4\/zo=","DZJiKMefualT0b9z6MIo6A==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:25:01","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":["7483","342","141","1306","%","34.94",457.0152,"2","2020-03-24 16:24:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:25:01","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":["7483","342 available_room_list_input","141","1305","%","34.94",457.0152,"2","2020-03-24 16:24:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:25:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7483",1543,"11","1","60.0",60,"2","2020-03-24 16:24:59","2","2020-03-24 16:24:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:25:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"7483"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-03-24 16:25:01","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":["7483","1305","1308.0",851,"2","2020-03-24 16:24:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:25:01","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-04-01","2021-03-31","1305"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-24 16:25:01","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":["7483","1306","1308.0",851,"2","2020-03-24 16:24:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:25:01","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-04-01","2021-03-31","1306"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-24 16:25:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["7483","B01-D205336","PAID",4816,0,"2021-03-31","2020-03-24 16:24:59","2020-03-24 16:24:59","2","2020-03-24 16:24:59","2","2020-03-24 16:24:59",1543]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:25:01","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":["7483",1543,"SETTLED","B01-I207811","2020-03-24 16:24:59","2020-04-01","2","2020-03-24 16:24:59","2","2020-03-24 16:24:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:25:01","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":["7811","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-03-24 16:24:59","2","2020-03-24 16:24:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:25:01","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":["7811","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-03-24 16:24:59","2","2020-03-24 16:24:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:25:01","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":["7811","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,0,"MO","1",0,"2","2020-03-24 16:24:59","2","2020-03-24 16:24:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:25:01","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":["7811","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",4,1733,"MO","1",1733,"2","2020-03-24 16:24:59","2","2020-03-24 16:24:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:25:01","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":["7811","RENT","\u9810\u7e73\u79df\u91d1",5,1879,"MO","1",1879,"2","2020-03-24 16:24:59","2","2020-03-24 16:24:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:25:01","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":["7811","RENT","\u9810\u7e73\u79df\u91d1",6,1879,"MO","1",1879,"2","2020-03-24 16:24:59","2","2020-03-24 16:24:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:25:01","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":["7811","RENT","\u9810\u7e73\u79df\u91d1",7,1879,"MO","1",1879,"2","2020-03-24 16:24:59","2","2020-03-24 16:24:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:25:01","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":["7811","RENT","\u9810\u7e73\u79df\u91d1",8,1879,"MO","1",1879,"2","2020-03-24 16:24:59","2","2020-03-24 16:24:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:25:01","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":["7811","RENT","\u9810\u7e73\u79df\u91d1",9,1879,"MO","1",1879,"2","2020-03-24 16:24:59","2","2020-03-24 16:24:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:25:01","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":["7811","RENT","\u9810\u7e73\u79df\u91d1",10,1879,"MO","1",1879,"2","2020-03-24 16:24:59","2","2020-03-24 16:24:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:25:01","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":["7811","RENT","\u9810\u7e73\u79df\u91d1",11,1879,"MO","1",1879,"2","2020-03-24 16:24:59","2","2020-03-24 16:24:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:25:01","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":["7811","RENT","\u9810\u7e73\u79df\u91d1",12,1879,"MO","1",1879,"2","2020-03-24 16:24:59","2","2020-03-24 16:24:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:25:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7811","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-03-24 16:24:59","2","2020-03-24 16:24:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:25:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[16825,0,"7811"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-24 16:25:01","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":[1543,"BANKIN","","","","BANKIN","","","","PAID","P207459","2020-03-24 16:24:59",21641,"2","2020-03-24 16:24:59","2","2020-03-24 16:24:59","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:25:01","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":["7459","DEPOSIT","5336","PAID","2020-03-24 16:24:59",4816,"2","2020-03-24 16:24:59","2","2020-03-24 16:24:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:25:01","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":["7459","INVOICE","7811","PAID","2020-03-24 16:24:59",16825,"2","2020-03-24 16:24:59","2","2020-03-24 16:24:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:55:48","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:59:42","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"1306","master_room_id":"141","room_code":"B01-116"}],"index_url_parameter":"filter1=2&filter2=943&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":793,"customer_code":"C180793","identity_type":"BUSINESS","identity_id":"37793173","title":"Ms","lastname":"Liu","firstname":"Ivy","companyname":"Simway Electrical Co. Int","email":"ivyhyliu@simatelex.com.hk","tel":"67999408","address":"21\/F, One Island South, 2 Heung Yip Road, 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":"1376.0","renew_rent_month":"12","renew_warehousing_date":"2020-04-06","renew_room_key":"054,60012","renew_remark":"12 months contract. Storage rental will be paid by cheque on or before April 5, 2019. Storage deposit transferred from agreement A12-CT183152 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT194482, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[{"master_room_discount_id":"77","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1271.00","discount":"16.82","monthly_deduct":257.0096,"room_id":"389","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"389","room_code":"G30","retail_price":"1528.0","discounted_price":1271,"location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1376,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":16512,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-06","rent_from":"2020-04-06","rent_to":"2021-04-05","delivery_service":"0","remark":"12 months contract. Storage rental paid by cheque deposit on Mar 24,2020. Storage deposit transferred from agreement A12-CT194482 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":16512,"final_order_total":16512,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,60012","order_product":[],"pass":true}},"first_order_id":4482,"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> G30 <\/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":"1376.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:59:43","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",793,"NEW","A12-CT207484",1528,1376,0,0,"12","12",16512,16512,16512,"2020-03-24 16:59:43","0",null,null,null,"2020-04-06","2021-04-05","12 months contract. Storage rental paid by cheque deposit on Mar 24,2020. Storage deposit transferred from agreement A12-CT194482 to this agreement.","2020-04-06","20",0,null,0,"0","2","2020-03-24 16:59:42","2","2020-03-24 16:59:42","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,60012","C180793","BUSINESS","Ms","aBMrNPstXKRoXjqBAvfRlg==","B4ox+DY3LBt2sD1CdZabMw==","Simway Electrical Co. Int","jl\/mWmj+icVCCjDATv3FWOPJJNxUgROVWjTkq44FpThxnTQU+G54ylVM2uLi+ErBJe8Srhzu1ArF3vQ\/lxlZUXHcQbGTRvo89kyB\/xLH9Ck=","3G9bD8aA7eZXVKuRgYPUSg==","Re7bQ5tCEI7nR7pA5GOWCQ9y3\/TpuIDSjCCzBZOF+Sw=",null,"XF8mEQkGaGSTDAG8stC9mw==",1,4482]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:59:43","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":["7484","77","10","389","%","16.82",257.0096,"2","2020-03-24 16:59:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:59:43","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":["7484","389","1528.0",1271,"2","2020-03-24 16:59:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:59:43","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-04-06","2021-04-05","389"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-24 16:59:43","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":["7484",793,"SETTLED","A12-I207812","2020-03-24 16:59:42","2020-04-06","2","2020-03-24 16:59:42","2","2020-03-24 16:59:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:59:43","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":["7812","RENT","\u9810\u7e73\u79df\u91d1",1,1376,"MO","1",1376,"2","2020-03-24 16:59:42","2","2020-03-24 16:59:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:59:43","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":["7812","RENT","\u9810\u7e73\u79df\u91d1",2,1376,"MO","1",1376,"2","2020-03-24 16:59:42","2","2020-03-24 16:59:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:59:43","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":["7812","RENT","\u9810\u7e73\u79df\u91d1",3,1376,"MO","1",1376,"2","2020-03-24 16:59:42","2","2020-03-24 16:59:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:59:43","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":["7812","RENT","\u9810\u7e73\u79df\u91d1",4,1376,"MO","1",1376,"2","2020-03-24 16:59:42","2","2020-03-24 16:59:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:59:43","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":["7812","RENT","\u9810\u7e73\u79df\u91d1",5,1376,"MO","1",1376,"2","2020-03-24 16:59:42","2","2020-03-24 16:59:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:59:43","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":["7812","RENT","\u9810\u7e73\u79df\u91d1",6,1376,"MO","1",1376,"2","2020-03-24 16:59:42","2","2020-03-24 16:59:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:59:43","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":["7812","RENT","\u9810\u7e73\u79df\u91d1",7,1376,"MO","1",1376,"2","2020-03-24 16:59:42","2","2020-03-24 16:59:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:59:43","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":["7812","RENT","\u9810\u7e73\u79df\u91d1",8,1376,"MO","1",1376,"2","2020-03-24 16:59:42","2","2020-03-24 16:59:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:59:43","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":["7812","RENT","\u9810\u7e73\u79df\u91d1",9,1376,"MO","1",1376,"2","2020-03-24 16:59:42","2","2020-03-24 16:59:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:59:43","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":["7812","RENT","\u9810\u7e73\u79df\u91d1",10,1376,"MO","1",1376,"2","2020-03-24 16:59:42","2","2020-03-24 16:59:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:59:43","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":["7812","RENT","\u9810\u7e73\u79df\u91d1",11,1376,"MO","1",1376,"2","2020-03-24 16:59:42","2","2020-03-24 16:59:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:59:43","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":["7812","RENT","\u9810\u7e73\u79df\u91d1",12,1376,"MO","1",1376,"2","2020-03-24 16:59:42","2","2020-03-24 16:59:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:59:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[16512,0,"7812"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-24 16:59:43","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":[793,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207460","2020-03-24 16:59:42",16512,"2","2020-03-24 16:59:42","2","2020-03-24 16:59:42","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:59:43","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":["7460","DEPOSIT",null,"PAID","2020-03-24 16:59:42",0,"2","2020-03-24 16:59:42","2","2020-03-24 16:59:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 16:59:43","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":["7460","INVOICE","7812","PAID","2020-03-24 16:59:42",16512,"2","2020-03-24 16:59:42","2","2020-03-24 16:59:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 17:47:21","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1125&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"535","master_room_id":"35","room_code":"L13"},{"room_id":"536","master_room_id":"35","room_code":"L14"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1195,"customer_code":"C191195","identity_type":"PERSONAL","identity_id":"K406035(0)","title":"Ms","lastname":"Lau","firstname":"Rebecca Kei Shuen","companyname":"","email":"cacalau88@icloud.com","tel":"97188614","address":"4322, 43\/F, AIA tower, 183 Electric Rd, North Point, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1410.0","renew_rent_month":"4","renew_warehousing_date":"2020-01-04","renew_room_key":"'0012521494","renew_remark":"4 months contract. Storage rental paid by bank transfer on September 9, 2019. Storage deposit $2820 transferred from A05-CT195913 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196771, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"115","order_discount":[{"master_room_discount_id":"246","master_room_id":"115","discount_type":"%","price":"1410.00","disocunted_price":"1339.90","discount":"4.97","monthly_deduct":70.077,"room_id":"1157","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1157","room_code":"A05-155(\u670d\u88dd\u5009)","retail_price":"1410.0","discounted_price":1339.9,"location_id":"4"}],"roughly_size":"16","total_retail_price":1410,"total_discounted_price":1410,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":4230,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-04","rent_from":"2020-01-04","rent_to":"2020-04-03","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on March 23, 2020. Storage deposit $2820 transferred from A05-CT196771 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4230,"final_order_total":4230,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0012521494","order_product":[],"pass":true}},"first_order_id":"4292","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-155(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1410.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":"1410.00","deposit":"0.00","total_retail_price":"1410.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 17:47:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1195,"NEW","A05-CT207485",1410,1410,0,0,"3","3",4230,4230,4230,"2020-03-24 17:47:22","0",null,null,null,"2020-01-04","2020-04-03","3 months contract. Storage rental paid by bank transfer on March 23, 2020. Storage deposit $2820 transferred from A05-CT196771 to this agreement.\r\n","2020-01-04","16",0,null,0,"0","2","2020-03-24 17:47:21","2","2020-03-24 17:47:21","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0012521494","C191195","PERSONAL","Ms","cSUqGWHC\/68ybP6W2f0HTeRI19xTcRSN4KHdd8lUrrE=","oe4emdjBwqJ3qUpOcI17hw==","","MJ8n0gP4JnU1c+J2pyaIIc4+mrmiGDDBfqYqYpTFaH8LTSnfnqQz2H9kTfGN9ykw9wgD8Hp63MeJR7IghtRlXQ==","HBKEeOOgSr3ILC7RQLlL1w==","PdyUwKPQexO32ZMwf1ZZORvOARdYMIXK7XwrqBcoZtM=","N3OcSFA9W1M\/ULEzkfIyGQ==",null,1,"4292"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 17:47:22","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":["7485","246","115","1157","%","4.97",70.077,"2","2020-03-24 17:47:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 17:47:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7485","1157","1410.0",1339.9,"2","2020-03-24 17:47:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 17:47:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-04","2020-04-03","1157"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-24 17:47:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7485",1195,"SETTLED","A05-I207813","2020-03-24 17:47:21","2020-01-04","2","2020-03-24 17:47:21","2","2020-03-24 17:47:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 17:47:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7813","RENT","\u9810\u7e73\u79df\u91d1",1,1410,"MO","1",1410,"2","2020-03-24 17:47:21","2","2020-03-24 17:47:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 17:47:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7813","RENT","\u9810\u7e73\u79df\u91d1",2,1410,"MO","1",1410,"2","2020-03-24 17:47:21","2","2020-03-24 17:47:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 17:47:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7813","RENT","\u9810\u7e73\u79df\u91d1",3,1410,"MO","1",1410,"2","2020-03-24 17:47:21","2","2020-03-24 17:47:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 17:47:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4230,0,"7813"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-24 17:47:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1195,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207461","2020-03-24 17:47:21",4230,"2","2020-03-24 17:47:21","2","2020-03-24 17:47:21","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 17:47:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7461","DEPOSIT",null,"PAID","2020-03-24 17:47:21",0,"2","2020-03-24 17:47:21","2","2020-03-24 17:47:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 17:47:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7461","INVOICE","7813","PAID","2020-03-24 17:47:21",4230,"2","2020-03-24 17:47:21","2","2020-03-24 17:47:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-24 18:23:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****