{"created_at":"2019-12-17 10:38:31","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 11:03:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 11:42:14","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=456&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1347","master_room_id":"171","room_code":"C15-041"},{"room_id":"1348","master_room_id":"170","room_code":"C15-042"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","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":"918.0","renew_rent_month":"12","renew_warehousing_date":"2020-01-01","renew_room_key":"055,31553","renew_remark":"12 months contract. Storage rental paid by EPS on December 19, 2018. Storage deposit transferred from agreement SD14-CT182437 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT183955, \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":969,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2907,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-01","rent_from":"2020-01-01","rent_to":"2020-03-31","delivery_service":"0","remark":"3 months contract. Storage rental paid by EPS on December 17, 2018. Storage deposit transferred from agreement A14-CT183955 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":2907,"final_order_total":2907,"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":"969.00","deposit":"0.00","total_retail_price":"1138.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 11:42:15","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-CT196712",1138,969,0,0,"3","3",2907,2907,2907,"2019-12-17 11:42:15","0",null,null,null,"2020-01-01","2020-03-31","3 months contract. Storage rental paid by EPS on December 17, 2018. Storage deposit transferred from agreement A14-CT183955 to this agreement.","2020-01-01","15",0,null,0,"0","2","2019-12-17 11:42:14","2","2019-12-17 11:42:14","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":"2019-12-17 11:42:15","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":["6712","701","1138.0","1138.00","2","2019-12-17 11:42:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 11:42:15","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-01","2020-03-31","701"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-17 11:42:15","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":["6712",346,"SETTLED","A14-I197040","2019-12-17 11:42:14","2020-01-01","2","2019-12-17 11:42:14","2","2019-12-17 11:42:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 11:42:15","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":["7040","RENT","\u9810\u7e73\u79df\u91d1",1,969,"MO","1",969,"2","2019-12-17 11:42:14","2","2019-12-17 11:42:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 11:42:15","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":["7040","RENT","\u9810\u7e73\u79df\u91d1",2,969,"MO","1",969,"2","2019-12-17 11:42:14","2","2019-12-17 11:42:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 11:42:15","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":["7040","RENT","\u9810\u7e73\u79df\u91d1",3,969,"MO","1",969,"2","2019-12-17 11:42:14","2","2019-12-17 11:42:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 11:42:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2907,0,"7040"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-17 11:42:15","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","P196690","2019-12-17 11:42:14",2907,"2","2019-12-17 11:42:14","2","2019-12-17 11:42:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 11:42:15","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":["6690","DEPOSIT",null,"PAID","2019-12-17 11:42:14",0,"2","2019-12-17 11:42:14","2","2019-12-17 11:42:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 11:42:15","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":["6690","INVOICE","7040","PAID","2019-12-17 11:42:14",2907,"2","2019-12-17 11:42:14","2","2019-12-17 11:42:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:01:28","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"1393","master_room_id":"191","room_code":"C15-087"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-087 <\/td>\r\n\t\t\t\t\t 8.9X4.5X6.5 <\/td>\r\n\t\t\t\t\t $2168.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"M401195(9)","title":"Ms","lastname":"ERMOLINA ","firstname":"Ekateina","companyname":"","email":"PATOLYA@BK.RU","tel":"63116244","address":"tbc","pass":true,"customer_id":"1356","customer_code":"C191356","customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1393","room_code":"C15-087","retail_price":"2168.0","discounted_price":"2168.00","location_id":"6"}],"roughly_size":"40.05","total_retail_price":2168,"total_discounted_price":1952,"deposit":2168,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":13298,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"582","warehousing_date":"2019-12-17","rent_from":"2019-12-17","rent_to":"2020-06-16","delivery_service":"0","remark":"6 months contract. Special offer 5% discount. Storage rental and deposit paid by cash on Dec 17,2019. Smartcard paid on Dec 17,2019.","paymethod":"CASH","paymethod2":"CASH","discount_deduct":582,"order_total":13940,"final_order_total":13358,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012388433","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"pass":true}},"roughly_size":"40.05","total_discounted_price":"1952.00","deposit":"2168.00","total_retail_price":"2168.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:01:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C191471","PERSONAL","Ms","sap1FCkN9scsEHFv0xBilw==","7QM+yyy7q4wEu11I\/Z7bBw==","","gER1nLsIbRwHZdhCxE+1Xw==","8rJFgzxEeXf9zuEdm3AuGg==","L\/L04tL1KwAXTf\/XIAPmWg==","E0iemuO+bdANG\/83EOiXCw==",null,"8rJFgzxEeXf9zuEdm3AuGg==","ghz\/Rd29jIol+Xiag8nSuQ==","2","2019-12-17 12:01:28","2","2019-12-17 12:01:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:01:29","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","3","6",1471,"NEW","C15-CT196713",2168,1952,2168,0,"6","6",13298,13940,13358,"2019-12-17 12:01:29","0",null,null,null,"2019-12-17","2020-06-16","6 months contract. Special offer 5% discount. Storage rental and deposit paid by cash on Dec 17,2019. Smartcard paid on Dec 17,2019.","2019-12-17","40.05",0,null,582,"582","2","2019-12-17 12:01:28","2","2019-12-17 12:01:28","CASH","","","","CASH","","","",null,0,"0012388433","C191471","PERSONAL","Ms","sap1FCkN9scsEHFv0xBilw==","7QM+yyy7q4wEu11I\/Z7bBw==","","L\/L04tL1KwAXTf\/XIAPmWg==","gER1nLsIbRwHZdhCxE+1Xw==","8rJFgzxEeXf9zuEdm3AuGg==","E0iemuO+bdANG\/83EOiXCw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:01:29","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":["6713",1471,"11","1","60.0",60,"2","2019-12-17 12:01:28","2","2019-12-17 12:01:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:01:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"6713"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2019-12-17 12:01:29","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":["6713","1393","2168.0","2168.00","2","2019-12-17 12:01:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:01:29","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":["2019-12-17","2020-06-16","1393"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-17 12:01:29","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":["6713","C15-D195221","PAID",2168,0,"2020-06-16","2019-12-17 12:01:28","2019-12-17 12:01:28","2","2019-12-17 12:01:28","2","2019-12-17 12:01:28",1471]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:01:29","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":["6713",1471,"SETTLED","C15-I197041","2019-12-17 12:01:28","2019-12-17","2","2019-12-17 12:01:28","2","2019-12-17 12:01:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:01:29","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":["7041","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,1370,"MO","1",1370,"2","2019-12-17 12:01:28","2","2019-12-17 12:01:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:01:29","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":["7041","RENT","\u9810\u7e73\u79df\u91d1",2,1952,"MO","1",1952,"2","2019-12-17 12:01:28","2","2019-12-17 12:01:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:01:29","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":["7041","RENT","\u9810\u7e73\u79df\u91d1",3,1952,"MO","1",1952,"2","2019-12-17 12:01:28","2","2019-12-17 12:01:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:01:29","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":["7041","RENT","\u9810\u7e73\u79df\u91d1",4,1952,"MO","1",1952,"2","2019-12-17 12:01:28","2","2019-12-17 12:01:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:01:29","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":["7041","RENT","\u9810\u7e73\u79df\u91d1",5,1952,"MO","1",1952,"2","2019-12-17 12:01:28","2","2019-12-17 12:01:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:01:29","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":["7041","RENT","\u9810\u7e73\u79df\u91d1",6,1952,"MO","1",1952,"2","2019-12-17 12:01:28","2","2019-12-17 12:01:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:01:29","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":["7041","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2019-12-17 12:01:28","2","2019-12-17 12:01:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:01:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11190,0,"7041"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-17 12:01:29","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":[1471,"CASH","","","","CASH","","","","PAID","P196691","2019-12-17 12:01:28",13358,"2","2019-12-17 12:01:28","2","2019-12-17 12:01:28","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:01:29","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":["6691","DEPOSIT","5221","PAID","2019-12-17 12:01:28",2168,"2","2019-12-17 12:01:28","2","2019-12-17 12:01:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:01:29","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":["6691","INVOICE","7041","PAID","2019-12-17 12:01:28",11190,"2","2019-12-17 12:01:28","2","2019-12-17 12:01:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:02:20","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=456&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1347","master_room_id":"171","room_code":"C15-041"},{"room_id":"1348","master_room_id":"170","room_code":"C15-042"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":621,"customer_code":"C170621","identity_type":"PERSONAL","identity_id":"Z083036(5)","title":"Mr","lastname":"Ng","firstname":"Wai Yip","companyname":"","email":"waiyip010@gmail.com","tel":"98388160","address":"Room 2, 22\/F, Kwun Chiu Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2019-11-28","renew_room_key":"054,54144","renew_remark":"1 month contract. Storage rental paid by bank transfer on Nov 22,2019. Storage deposit transferred from agreement A18-CT196128 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196470, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"849","room_code":"S08","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1290,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-28","rent_from":"2019-11-28","rent_to":"2019-12-27","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on December 16,2019. Storage deposit transferred from agreement A18-CT196470 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,54144","order_product":[],"pass":true}},"first_order_id":"4764","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> S08 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:02: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","3",621,"NEW","A18-CT196714",1290,1290,0,0,"1","1",1290,1290,1290,"2019-12-17 12:02:20","0",null,null,null,"2019-11-28","2019-12-27","1 month contract. Storage rental paid by bank transfer on December 16,2019. Storage deposit transferred from agreement A18-CT196470 to this agreement.","2019-11-28","16",0,null,0,"0","2","2019-12-17 12:02:20","2","2019-12-17 12:02:20","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,54144","C170621","PERSONAL","Mr","ih4aUrxtlcexLCp\/tdkvvw==","cxr02xsD1tXvJ4ihJHZKWw==","","yR95NWcy8orgfJiv4o8nUhldJm21pHQyPqtwASYolM1Kfk2Djou6qn5enXkBMxam3xy5zhVtYjz\/vUJqcjgCQwJJ6wImNgSpgm7xbtLd7UU=","484inTWWBLYNYwPtLecM3w==","eXhWO16jYYVtb51D98Y8hU3AEhjg0o6Un\/aNYSBOey4=","xt28FcrgbbbToDMexv\/cfg==",null,1,"4764"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:02: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":["6714","849","1290.0","1290.00","2","2019-12-17 12:02:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:02: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":["2019-11-28","2019-12-27","849"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-17 12:02: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":["6714",621,"SETTLED","A18-I197042","2019-12-17 12:02:20","2019-11-28","2","2019-12-17 12:02:20","2","2019-12-17 12:02:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:02: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":["7042","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2019-12-17 12:02:20","2","2019-12-17 12:02:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:02:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"7042"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-17 12:02: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":[621,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196692","2019-12-17 12:02:20",1290,"2","2019-12-17 12:02:20","2","2019-12-17 12:02:20","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:02: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":["6692","DEPOSIT",null,"PAID","2019-12-17 12:02:20",0,"2","2019-12-17 12:02:20","2","2019-12-17 12:02:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:02: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":["6692","INVOICE","7042","PAID","2019-12-17 12:02:20",1290,"2","2019-12-17 12:02:20","2","2019-12-17 12:02:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:04:04","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=456&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1347","master_room_id":"171","room_code":"C15-041"},{"room_id":"1348","master_room_id":"170","room_code":"C15-042"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":263,"customer_code":"C170263","identity_type":"PERSONAL","identity_id":"D704585(A)","title":"Mr","lastname":"Leung","firstname":"Man Kai","companyname":"","email":"hellomkhk@yahoo.com.hk","tel":"97352237","address":"Flat 5, 27\/F, BLK A, Yue Fai Court","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2318.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-06","renew_room_key":"054,00997","renew_remark":"1 month contract. Storage rental paid by bank transfer on November 14, 2019. Storage deposit transferred from agreement A12-CT196177 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196406, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"32","room_code":"A32","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"},{"room_id":"31","room_code":"A31","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":2318,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2318,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-06","rent_from":"2019-12-06","rent_to":"2020-01-05","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on December 17, 2019. Storage deposit transferred from agreement A12-CT196406 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2318,"final_order_total":2318,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,00997","order_product":[],"pass":true}},"first_order_id":"4781","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> A32 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> A31 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"2318.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:04:05","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",263,"NEW","A12-CT196715",2196,2318,0,0,"1","1",2318,2318,2318,"2019-12-17 12:04:05","0",null,null,null,"2019-12-06","2020-01-05","1 month contract. Storage rental paid by bank transfer on December 17, 2019. Storage deposit transferred from agreement A12-CT196406 to this agreement.","2019-12-06","32",0,null,0,"0","2","2019-12-17 12:04:04","2","2019-12-17 12:04:04","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,00997","C170263","PERSONAL","Mr","nRvnQbLeZEN7gUr1x\/8GHQ==","xEf2h2aoyRQ71ZVgBH+9WQ==","","aQak8hG9FmECD+\/o3qbqPw48j8cKpXf13a9FHWLZJj3a8gSxqyhYsUtF0aVccmhO","k9yvnbmpfXW5Z3ZwhLsQZQ==","p65IBdT2ZCL5fh+ct7VZ+jkIQMQs\/mV6AeDzTTgXcsg=","2lzZZ98xqcDCMYSbgaPj3g==",null,1,"4781"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:04:05","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":["6715","32","1098.0","1098.00","2","2019-12-17 12:04:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:04:05","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":["2019-12-06","2020-01-05","32"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-17 12:04:05","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":["6715","31","1098.0","1098.00","2","2019-12-17 12:04:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:04:05","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":["2019-12-06","2020-01-05","31"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-17 12:04:05","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":["6715",263,"SETTLED","A12-I197043","2019-12-17 12:04:04","2019-12-06","2","2019-12-17 12:04:04","2","2019-12-17 12:04:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:04:05","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":["7043","RENT","\u9810\u7e73\u79df\u91d1",1,2318,"MO","1",2318,"2","2019-12-17 12:04:04","2","2019-12-17 12:04:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:04:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2318,0,"7043"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-17 12:04:05","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":[263,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196693","2019-12-17 12:04:04",2318,"2","2019-12-17 12:04:04","2","2019-12-17 12:04:04","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:04:05","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":["6693","DEPOSIT",null,"PAID","2019-12-17 12:04:04",0,"2","2019-12-17 12:04:04","2","2019-12-17 12:04:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:04:05","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":["6693","INVOICE","7043","PAID","2019-12-17 12:04:04",2318,"2","2019-12-17 12:04:04","2","2019-12-17 12:04:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:05:59","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=456&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1347","master_room_id":"171","room_code":"C15-041"},{"room_id":"1348","master_room_id":"170","room_code":"C15-042"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1220,"customer_code":"C191220","identity_type":"PERSONAL","identity_id":"Z024485(7)","title":"Mr","lastname":"TSANG","firstname":"Wai Hang","companyname":"","email":null,"tel":"63937108","address":"Room K, 1\/F, Blk 2, Harmony Garden, Siu Sai Wan, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1228.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-06","renew_room_key":"054,00997","renew_remark":"1 month contract. Storage rental paid by bank transfer on November 14, 2019. Storage deposit transferred from agreement A12-CT196176 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196407, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"149","room_code":"C25","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1228,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-06","rent_from":"2019-12-06","rent_to":"2020-01-05","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on December 17, 2019. Storage deposit transferred from agreement A12-CT196407 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1228,"final_order_total":1228,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,00997","order_product":[],"pass":true}},"first_order_id":"4572","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> C25 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1228.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:06:00","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",1220,"NEW","A12-CT196716",1098,1228,0,0,"1","1",1228,1228,1228,"2019-12-17 12:06:00","0",null,null,null,"2019-12-06","2020-01-05","1 month contract. Storage rental paid by bank transfer on December 17, 2019. Storage deposit transferred from agreement A12-CT196407 to this agreement.","2019-12-06","16",0,null,0,"0","2","2019-12-17 12:05:59","2","2019-12-17 12:05:59","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,00997","C191220","PERSONAL","Mr","ovFd6oXHMscYazWfsL42IQ==","CQSkiYI47zpAX0jM\/inYfQ==","","tNsYAtswVgIwRrnefohYHwqW0\/qT7EFi\/n034QAND88omd7DZqoDYRrjLqyU8SiOBPBLrQHBbi3iORo8Yd6vjw==","oAlpDeafBj+l77mjY6qR2A==",null,"Z\/Uc2OSsjoza5npRKlVrJw==",null,1,"4572"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:06:00","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":["6716","149","1098.0","1098.00","2","2019-12-17 12:05:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:06:00","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":["2019-12-06","2020-01-05","149"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-17 12:06:00","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":["6716",1220,"SETTLED","A12-I197044","2019-12-17 12:05:59","2019-12-06","2","2019-12-17 12:05:59","2","2019-12-17 12:05:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:06:00","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":["7044","RENT","\u9810\u7e73\u79df\u91d1",1,1228,"MO","1",1228,"2","2019-12-17 12:05:59","2","2019-12-17 12:05:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:06:00","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1228,0,"7044"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-17 12:06:00","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":[1220,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196694","2019-12-17 12:05:59",1228,"2","2019-12-17 12:05:59","2","2019-12-17 12:05:59","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:06:00","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":["6694","DEPOSIT",null,"PAID","2019-12-17 12:05:59",0,"2","2019-12-17 12:05:59","2","2019-12-17 12:05:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:06:00","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":["6694","INVOICE","7044","PAID","2019-12-17 12:05:59",1228,"2","2019-12-17 12:05:59","2","2019-12-17 12:05:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:07:08","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=456&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1347","master_room_id":"171","room_code":"C15-041"},{"room_id":"1348","master_room_id":"170","room_code":"C15-042"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":263,"customer_code":"C170263","identity_type":"PERSONAL","identity_id":"D704585(A)","title":"Mr","lastname":"Leung","firstname":"Man Kai","companyname":"","email":"hellomkhk@yahoo.com.hk","tel":"97352237","address":"Flat 5, 27\/F, BLK A, Yue Fai Court","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":"2019-12-04","renew_room_key":"054,00997","renew_remark":"1 month contract. Storage rental paid by bank transfer on November 14, 2019. Storage deposit transferred from agreement A14-CT196174 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196408, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"688","room_code":"N05","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":"2019-12-04","rent_from":"2019-12-04","rent_to":"2020-01-03","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on December 17, 2019. Storage deposit transferred from agreement A14-CT196408 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":"054,00997","order_product":[],"pass":true}},"first_order_id":"4783","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> N05 <\/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":"2019-12-17 12:07:09","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",263,"NEW","A14-CT196717",598,598,0,0,"1","1",598,598,598,"2019-12-17 12:07:09","0",null,null,null,"2019-12-04","2020-01-03","1 month contract. Storage rental paid by bank transfer on December 17, 2019. Storage deposit transferred from agreement A14-CT196408 to this agreement.","2019-12-04","12",0,null,0,"0","2","2019-12-17 12:07:08","2","2019-12-17 12:07:08","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,00997","C170263","PERSONAL","Mr","nRvnQbLeZEN7gUr1x\/8GHQ==","xEf2h2aoyRQ71ZVgBH+9WQ==","","aQak8hG9FmECD+\/o3qbqPw48j8cKpXf13a9FHWLZJj3a8gSxqyhYsUtF0aVccmhO","k9yvnbmpfXW5Z3ZwhLsQZQ==","p65IBdT2ZCL5fh+ct7VZ+jkIQMQs\/mV6AeDzTTgXcsg=","2lzZZ98xqcDCMYSbgaPj3g==",null,1,"4783"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:07:09","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":["6717","688","598.0","598.00","2","2019-12-17 12:07:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:07:09","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":["2019-12-04","2020-01-03","688"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-17 12:07:09","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":["6717",263,"SETTLED","A14-I197045","2019-12-17 12:07:08","2019-12-04","2","2019-12-17 12:07:08","2","2019-12-17 12:07:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:07:09","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":["7045","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2019-12-17 12:07:08","2","2019-12-17 12:07:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:07:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7045"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-17 12:07:09","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":[263,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196695","2019-12-17 12:07:08",598,"2","2019-12-17 12:07:08","2","2019-12-17 12:07:08","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:07:09","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":["6695","DEPOSIT",null,"PAID","2019-12-17 12:07:08",0,"2","2019-12-17 12:07:08","2","2019-12-17 12:07:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:07:09","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":["6695","INVOICE","7045","PAID","2019-12-17 12:07:08",598,"2","2019-12-17 12:07:08","2","2019-12-17 12:07:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:08:16","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=456&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1347","master_room_id":"171","room_code":"C15-041"},{"room_id":"1348","master_room_id":"170","room_code":"C15-042"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":263,"customer_code":"C170263","identity_type":"PERSONAL","identity_id":"D704585(A)","title":"Mr","lastname":"Leung","firstname":"Man Kai","companyname":"","email":"hellomkhk@yahoo.com.hk","tel":"97352237","address":"Flat 5, 27\/F, BLK A, Yue Fai Court","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-08","renew_room_key":"054,00997","renew_remark":"1 month contract. Storage rental paid by bank transfer on November 14, 2019. Storage deposit transferred from agreement A14-CT196175 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196409, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"736","room_code":"O12","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":998,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-08","rent_from":"2019-12-08","rent_to":"2020-01-07","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on December 17, 2019. Storage deposit transferred from agreement A14-CT196409 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":998,"final_order_total":998,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,00997","order_product":[],"pass":true}},"first_order_id":"4784","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> O12 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"998.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:08:17","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",263,"NEW","A14-CT196718",998,998,0,0,"1","1",998,998,998,"2019-12-17 12:08:17","0",null,null,null,"2019-12-08","2020-01-07","1 month contract. Storage rental paid by bank transfer on December 17, 2019. Storage deposit transferred from agreement A14-CT196409 to this agreement.","2019-12-08","12",0,null,0,"0","2","2019-12-17 12:08:16","2","2019-12-17 12:08:16","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,00997","C170263","PERSONAL","Mr","nRvnQbLeZEN7gUr1x\/8GHQ==","xEf2h2aoyRQ71ZVgBH+9WQ==","","aQak8hG9FmECD+\/o3qbqPw48j8cKpXf13a9FHWLZJj3a8gSxqyhYsUtF0aVccmhO","k9yvnbmpfXW5Z3ZwhLsQZQ==","p65IBdT2ZCL5fh+ct7VZ+jkIQMQs\/mV6AeDzTTgXcsg=","2lzZZ98xqcDCMYSbgaPj3g==",null,1,"4784"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:08:17","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":["6718","736","998.0","998.00","2","2019-12-17 12:08:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:08:17","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":["2019-12-08","2020-01-07","736"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-17 12:08:17","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":["6718",263,"SETTLED","A14-I197046","2019-12-17 12:08:16","2019-12-08","2","2019-12-17 12:08:16","2","2019-12-17 12:08:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:08:17","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":["7046","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2019-12-17 12:08:16","2","2019-12-17 12:08:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:08:17","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"7046"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-17 12:08:17","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":[263,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196696","2019-12-17 12:08:16",998,"2","2019-12-17 12:08:16","2","2019-12-17 12:08:16","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:08:17","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":["6696","DEPOSIT",null,"PAID","2019-12-17 12:08:16",0,"2","2019-12-17 12:08:16","2","2019-12-17 12:08:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 12:08:17","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":["6696","INVOICE","7046","PAID","2019-12-17 12:08:16",998,"2","2019-12-17 12:08:16","2","2019-12-17 12:08:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 14:42:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:01:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:01:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:06:11","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1158&filter3=undefined","floor_plan_rent_room":[{"room_id":"1347","master_room_id":"171","room_code":"C15-041"},{"room_id":"1348","master_room_id":"170","room_code":"C15-042"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1301,"customer_code":"C191301","identity_type":"PERSONAL","identity_id":"K08388(5)","title":"Ms","lastname":"Kwan","firstname":"Yuen Yee Amy","companyname":"","email":"akyyhk@yahoo.com","tel":"92750360","address":"Flat L, 9\/F, Blk 5, Hong Sing Garden, Tseung Kwan O, N.T.","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1226.0","renew_rent_month":"3","renew_warehousing_date":"2019-12-16","renew_room_key":"111,40893","renew_remark":"3 month contract. Storage rental paid by bank transfer on September 15, 2019. Storage deposit transferred from agreement A16-CT195235 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT195950, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"202","order_discount":[],"order_room":[{"room_id":"1519","room_code":"A16-028","retail_price":"1290.0","discounted_price":"1290.00","location_id":"7"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1290,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-16","rent_from":"2019-12-16","rent_to":"2020-01-15","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on December 16, 2019. Storage deposit transferred from agreement A16-CT195950 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"7","branch_id":"1","company_id":"1","room_key":"111,40893","order_product":[],"pass":true}},"first_order_id":"5235","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> A16-028 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1290.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:06: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","7",1301,"NEW","A16-CT196719",1290,1290,0,0,"1","1",1290,1290,1290,"2019-12-17 15:06:12","0",null,null,null,"2019-12-16","2020-01-15","1 month contract. Storage rental paid by PPS on December 16, 2019. Storage deposit transferred from agreement A16-CT195950 to this agreement.","2019-12-16","16",0,null,0,"0","2","2019-12-17 15:06:11","2","2019-12-17 15:06:11","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"111,40893","C191301","PERSONAL","Ms","5wigC8kzb56lGRRSAEYGsw==","iNwdG3Dj3OBaAQ6MRfBM1w==","","\/Ewh1holgp6WSTJa\/JHYhYvoqKRvnYtpL3yQk4vYZf\/xWDWin6QHzWL6hMnAUJ4T8XbSzfh5jMoFXOktD1XRYw==","YESwwapoFqF3cRsBQ+uG6A==","G8w9ZbnhyRcx0XoYCRwUCjIw8+4PSVsFNffrrS+i8x4=","kt7RlFLP4CUDPa9sfSXSrg==",null,1,"5235"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:06: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":["6719","1519","1290.0","1290.00","2","2019-12-17 15:06:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:06: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":["2019-12-16","2020-01-15","1519"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-17 15:06: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":["6719",1301,"SETTLED","A16-I197047","2019-12-17 15:06:11","2019-12-16","2","2019-12-17 15:06:11","2","2019-12-17 15:06:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:06: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":["7047","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2019-12-17 15:06:11","2","2019-12-17 15:06:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:06:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"7047"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-17 15:06: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":[1301,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P196697","2019-12-17 15:06:11",1290,"2","2019-12-17 15:06:11","2","2019-12-17 15:06:11","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:06: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":["6697","DEPOSIT",null,"PAID","2019-12-17 15:06:11",0,"2","2019-12-17 15:06:11","2","2019-12-17 15:06:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:06: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":["6697","INVOICE","7047","PAID","2019-12-17 15:06:11",1290,"2","2019-12-17 15:06:11","2","2019-12-17 15:06:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:09:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:09:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:15:31","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1158&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1347","master_room_id":"171","room_code":"C15-041"},{"room_id":"1348","master_room_id":"170","room_code":"C15-042"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":107,"customer_code":"C160107","identity_type":"PERSONAL","identity_id":"D621339(2)","title":"Mr","lastname":"Wong","firstname":"Tin Lun","companyname":"","email":"lin_lun@yahoo.com","tel":"90181732","address":"Flat A, 14\/F, Block 2, Ocean Court, 3 Aberdeen Praya Road","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"899.0","renew_rent_month":"12","renew_warehousing_date":"2019-12-19","renew_room_key":"054,43334","renew_remark":"12 months contract. Storage rental paid by bank transfer on November 30, 2018. Storage deposit transferred from agreement SD12-CT171449 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT183801, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[{"master_room_discount_id":"71","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"829.90","discount":"16.84","monthly_deduct":168.0632,"room_id":"322","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"322","room_code":"F07","retail_price":"998.0","discounted_price":829.9,"location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":899,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":10788,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-19","rent_from":"2019-12-19","rent_to":"2020-12-18","delivery_service":"0","remark":"12 months contract. Special offer $300 Maxim's coupon. Storage rental $10688 paid by PPS on December 16, 2019. Remaining balance $100 will deduct from deposit. Storage deposit transferred from agreement A12-CT183801 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":10788,"final_order_total":10788,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,43334","order_product":[],"pass":true}},"first_order_id":3801,"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> F07 <\/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":"899.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:15:31","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",107,"NEW","A12-CT196720",998,899,0,0,"12","12",10788,10788,10788,"2019-12-17 15:15:31","0",null,null,null,"2019-12-19","2020-12-18","12 months contract. Special offer $300 Maxim's coupon. Storage rental $10688 paid by PPS on December 16, 2019. Remaining balance $100 will deduct from deposit. Storage deposit transferred from agreement A12-CT183801 to this agreement.","2019-12-19","12",0,null,0,"0","2","2019-12-17 15:15:31","2","2019-12-17 15:15:31","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,43334","C160107","PERSONAL","Mr","JCGo1ZBZZZ9ESpw5qm3kZQ==","hULSwM2MvFtpeV9\/z+er8Q==","","G51k54Pn+ZedzYuHGXTpJPmuEkI3zKF\/cc429dp5N7a8zFq\/S4iRULK9oddQ8\/edzI70t4yJhol8\/WTzQCbNdg==","hKQu57nG00HYCkiOYiRgPQ==","1bpnImCAtzUy0UnbXQncV9It60YvJJTsmv1mvgPEiwY=","jl\/gUJVPguu1ZRRj9TSudw==",null,1,3801]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:15:31","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":["6720","71","6","322","%","16.84",168.0632,"2","2019-12-17 15:15:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:15:31","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":["6720","322","998.0",829.9,"2","2019-12-17 15:15:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:15:31","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":["2019-12-19","2020-12-18","322"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-17 15:15:31","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":["6720",107,"SETTLED","A12-I197048","2019-12-17 15:15:31","2019-12-19","2","2019-12-17 15:15:31","2","2019-12-17 15:15:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:15:31","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":["7048","RENT","\u9810\u7e73\u79df\u91d1",1,899,"MO","1",899,"2","2019-12-17 15:15:31","2","2019-12-17 15:15:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:15:31","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":["7048","RENT","\u9810\u7e73\u79df\u91d1",2,899,"MO","1",899,"2","2019-12-17 15:15:31","2","2019-12-17 15:15:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:15:31","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":["7048","RENT","\u9810\u7e73\u79df\u91d1",3,899,"MO","1",899,"2","2019-12-17 15:15:31","2","2019-12-17 15:15:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:15:31","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":["7048","RENT","\u9810\u7e73\u79df\u91d1",4,899,"MO","1",899,"2","2019-12-17 15:15:31","2","2019-12-17 15:15:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:15:31","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":["7048","RENT","\u9810\u7e73\u79df\u91d1",5,899,"MO","1",899,"2","2019-12-17 15:15:31","2","2019-12-17 15:15:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:15:31","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":["7048","RENT","\u9810\u7e73\u79df\u91d1",6,899,"MO","1",899,"2","2019-12-17 15:15:31","2","2019-12-17 15:15:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:15:31","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":["7048","RENT","\u9810\u7e73\u79df\u91d1",7,899,"MO","1",899,"2","2019-12-17 15:15:31","2","2019-12-17 15:15:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:15:31","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":["7048","RENT","\u9810\u7e73\u79df\u91d1",8,899,"MO","1",899,"2","2019-12-17 15:15:31","2","2019-12-17 15:15:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:15:31","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":["7048","RENT","\u9810\u7e73\u79df\u91d1",9,899,"MO","1",899,"2","2019-12-17 15:15:31","2","2019-12-17 15:15:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:15:31","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":["7048","RENT","\u9810\u7e73\u79df\u91d1",10,899,"MO","1",899,"2","2019-12-17 15:15:31","2","2019-12-17 15:15:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:15:31","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":["7048","RENT","\u9810\u7e73\u79df\u91d1",11,899,"MO","1",899,"2","2019-12-17 15:15:31","2","2019-12-17 15:15:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:15:31","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":["7048","RENT","\u9810\u7e73\u79df\u91d1",12,899,"MO","1",899,"2","2019-12-17 15:15:31","2","2019-12-17 15:15:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:15:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10788,0,"7048"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-17 15:15:31","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":[107,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P196698","2019-12-17 15:15:31",10788,"2","2019-12-17 15:15:31","2","2019-12-17 15:15:31","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:15:31","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":["6698","DEPOSIT",null,"PAID","2019-12-17 15:15:31",0,"2","2019-12-17 15:15:31","2","2019-12-17 15:15:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:15:31","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":["6698","INVOICE","7048","PAID","2019-12-17 15:15:31",10788,"2","2019-12-17 15:15:31","2","2019-12-17 15:15:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:47:25","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1021&filter3=undefined","floor_plan_rent_room":[{"room_id":"1192","master_room_id":"140","room_code":"B01-002"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> B01-002 <\/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","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"D423761(8)","title":"Ms","lastname":"Lee","firstname":"Shuk Hing Carol","companyname":"","email":"","tel":"93099392","address":"\u674f\u82b1\u90a8\u7b2c34\u5ea76\u6a1307\u5ba4","pass":true,"customer_id":"1021","customer_code":"C181021","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"341","master_room_id":"140","discount_type":"%","price":"1112.00","disocunted_price":"723.90","discount":"34.90","monthly_deduct":388.088,"room_id":"1192","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1192","room_code":"B01-002","retail_price":"1112.0","discounted_price":723.9,"location_id":"5"}],"roughly_size":"16","total_retail_price":1112,"total_discounted_price":868,"deposit":2224,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":10024,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2616.00","warehousing_date":"2019-12-21","rent_from":"2019-12-21","rent_to":"2020-12-20","delivery_service":"0","remark":"12 months contract. Special offer 2 months free. 5% 'Rent Now' discount, $200 change storage offer and $250 referral offer. Storage rental and deposit paid by bank transfer on December 17, 2019. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":2616,"order_total":12640,"final_order_total":10024,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0012492259","order_product":[],"pass":true}},"roughly_size":"16","total_discounted_price":"868.00","deposit":"2224.00","total_retail_price":"1112.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:47: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` = ?","parameters":["1","2","5","1021","NEW","B01-CT196721",1112,868,2224,0,"12","12",10024,12640,10024,"2019-12-17 15:47:25","0",null,null,null,"2019-12-21","2020-12-20","12 months contract. Special offer 2 months free. 5% 'Rent Now' discount, $200 change storage offer and $250 referral offer. Storage rental and deposit paid by bank transfer on December 17, 2019. ","2019-12-21","16",0,null,2616,"2616.00","2","2019-12-17 15:47:25","2","2019-12-17 15:47:25","BANKIN","","","","BANKIN","","","",null,0,"0012492259","C181021","PERSONAL","Ms","syb8IwPXnj42YtyRxku\/FA==","kiriEIqhcx866RNZiMXdKQ==","","pxPQU8D5i5RDq8Ody3Fqr+TKlPZU0OmY\/H6zzFpIbQg=","farH9g+t710ddMuRS3kC6g==",null,"eMhoaZGiLthlKtECQ5EqSg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:47:25","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":["6721","341","140","1192","%","34.90",388.088,"2","2019-12-17 15:47:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:47: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":["6721","1192","1112.0",723.9,"2","2019-12-17 15:47:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:47: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":["2019-12-21","2020-12-20","1192"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-17 15:47:25","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":["6721","B01-D195222","PAID",2224,0,"2020-12-20","2019-12-17 15:47:25","2019-12-17 15:47:25","2","2019-12-17 15:47:25","2","2019-12-17 15:47:25","1021"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:47: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":["6721","1021","SETTLED","B01-I197049","2019-12-17 15:47:25","2019-12-21","2","2019-12-17 15:47:25","2","2019-12-17 15:47:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:47: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":["7049","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2019-12-17 15:47:25","2","2019-12-17 15:47:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:47: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":["7049","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2019-12-17 15:47:25","2","2019-12-17 15:47:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:47: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":["7049","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,0,"MO","1",0,"2","2019-12-17 15:47:25","2","2019-12-17 15:47:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:47: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":["7049","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",4,856,"MO","1",856,"2","2019-12-17 15:47:25","2","2019-12-17 15:47:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:47: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":["7049","RENT","\u9810\u7e73\u79df\u91d1",5,868,"MO","1",868,"2","2019-12-17 15:47:25","2","2019-12-17 15:47:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:47: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":["7049","RENT","\u9810\u7e73\u79df\u91d1",6,868,"MO","1",868,"2","2019-12-17 15:47:25","2","2019-12-17 15:47:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:47: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":["7049","RENT","\u9810\u7e73\u79df\u91d1",7,868,"MO","1",868,"2","2019-12-17 15:47:25","2","2019-12-17 15:47:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:47: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":["7049","RENT","\u9810\u7e73\u79df\u91d1",8,868,"MO","1",868,"2","2019-12-17 15:47:25","2","2019-12-17 15:47:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:47: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":["7049","RENT","\u9810\u7e73\u79df\u91d1",9,868,"MO","1",868,"2","2019-12-17 15:47:25","2","2019-12-17 15:47:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:47: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":["7049","RENT","\u9810\u7e73\u79df\u91d1",10,868,"MO","1",868,"2","2019-12-17 15:47:25","2","2019-12-17 15:47:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:47: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":["7049","RENT","\u9810\u7e73\u79df\u91d1",11,868,"MO","1",868,"2","2019-12-17 15:47:25","2","2019-12-17 15:47:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:47: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":["7049","RENT","\u9810\u7e73\u79df\u91d1",12,868,"MO","1",868,"2","2019-12-17 15:47:25","2","2019-12-17 15:47:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:47:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7800,0,"7049"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-17 15:47: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":["1021","BANKIN","","","","BANKIN","","","","PAID","P196699","2019-12-17 15:47:25",10024,"2","2019-12-17 15:47:25","2","2019-12-17 15:47:25","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:47: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":["6699","DEPOSIT","5222","PAID","2019-12-17 15:47:25",2224,"2","2019-12-17 15:47:25","2","2019-12-17 15:47:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:47: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":["6699","INVOICE","7049","PAID","2019-12-17 15:47:25",7800,"2","2019-12-17 15:47:25","2","2019-12-17 15:47:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:54:26","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1021&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1246","master_room_id":"144","room_code":"B01-056"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> B01-056 <\/td>\r\n\t\t\t\t\t 4X7X7 <\/td>\r\n\t\t\t\t\t $1722.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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"Y176039(2)","title":"Mr","lastname":"NG","firstname":"Hing Lun","companyname":"","email":"","tel":"65956599","address":"Flat 7, 6\/F, Block 34, Heng Fa Chuen, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"345","master_room_id":"144","discount_type":"%","price":"1722.00","disocunted_price":"1120.00","discount":"34.96","monthly_deduct":602.0112,"room_id":"1246","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1246","room_code":"B01-056","retail_price":"1722.0","discounted_price":1120,"location_id":"5"}],"roughly_size":"28","total_retail_price":1722,"total_discounted_price":1344,"deposit":3444,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":15964,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3608.00","warehousing_date":"2019-12-21","rent_from":"2019-12-21","rent_to":"2020-12-20","delivery_service":"0","remark":"12 months contract. Special offer 2 months free, 5% 'Rent Now' discount and $250 referral bonus. Storag rental and deposit paid by bank transfer on December 17, 2019. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":3608,"order_total":19572,"final_order_total":15964,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0012422237","order_product":[],"pass":true}},"roughly_size":"28","total_discounted_price":"1344.00","deposit":"3444.00","total_retail_price":"1722.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:54:26","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":["C191472","PERSONAL","Mr","F\/SH9ZKxr9X7Y5h1jOO6WQ==","yXKLXTtbNpECaRVTZxF\/Rw==","","bhYO\/qyYCguaI1o+S\/Wibg==",null,"DT0qvFTFdR50sO0nB\/fwcCVsuvfD\/2JkU6KRUWC\/GXWpkO\/+SZR8iXPG9EFaigo2","gY3QjX8iZDxbFwAnAuZPNw==",null,null,"cABZPWSF3GVdcnhbsuN8RQ==","2","2019-12-17 15:54:26","2","2019-12-17 15:54:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:54:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","2","5",1472,"NEW","B01-CT196722",1722,1344,3444,0,"12","12",15964,19572,15964,"2019-12-17 15:54:27","0",null,null,null,"2019-12-21","2020-12-20","12 months contract. Special offer 2 months free, 5% 'Rent Now' discount and $250 referral bonus. Storag rental and deposit paid by bank transfer on December 17, 2019. ","2019-12-21","28",0,null,3608,"3608.00","2","2019-12-17 15:54:26","2","2019-12-17 15:54:26","BANKIN","","","","BANKIN","","","",null,0,"0012422237","C191472","PERSONAL","Mr","F\/SH9ZKxr9X7Y5h1jOO6WQ==","yXKLXTtbNpECaRVTZxF\/Rw==","","DT0qvFTFdR50sO0nB\/fwcCVsuvfD\/2JkU6KRUWC\/GXWpkO\/+SZR8iXPG9EFaigo2","bhYO\/qyYCguaI1o+S\/Wibg==",null,"gY3QjX8iZDxbFwAnAuZPNw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:54:27","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":["6722","345","144","1246","%","34.96",602.0112,"2","2019-12-17 15:54:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:54:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6722","1246","1722.0",1120,"2","2019-12-17 15:54:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:54:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-21","2020-12-20","1246"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-17 15:54:27","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":["6722","B01-D195223","PAID",3444,0,"2020-12-20","2019-12-17 15:54:26","2019-12-17 15:54:26","2","2019-12-17 15:54:26","2","2019-12-17 15:54:26",1472]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:54:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6722",1472,"SETTLED","B01-I197050","2019-12-17 15:54:26","2019-12-21","2","2019-12-17 15:54:26","2","2019-12-17 15:54:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:54:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7050","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2019-12-17 15:54:26","2","2019-12-17 15:54:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:54:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7050","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2019-12-17 15:54:26","2","2019-12-17 15:54:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:54:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7050","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,424,"MO","1",424,"2","2019-12-17 15:54:26","2","2019-12-17 15:54:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:54:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7050","RENT","\u9810\u7e73\u79df\u91d1",4,1344,"MO","1",1344,"2","2019-12-17 15:54:26","2","2019-12-17 15:54:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:54:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7050","RENT","\u9810\u7e73\u79df\u91d1",5,1344,"MO","1",1344,"2","2019-12-17 15:54:26","2","2019-12-17 15:54:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:54:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7050","RENT","\u9810\u7e73\u79df\u91d1",6,1344,"MO","1",1344,"2","2019-12-17 15:54:26","2","2019-12-17 15:54:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:54:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7050","RENT","\u9810\u7e73\u79df\u91d1",7,1344,"MO","1",1344,"2","2019-12-17 15:54:26","2","2019-12-17 15:54:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:54:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7050","RENT","\u9810\u7e73\u79df\u91d1",8,1344,"MO","1",1344,"2","2019-12-17 15:54:26","2","2019-12-17 15:54:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:54:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7050","RENT","\u9810\u7e73\u79df\u91d1",9,1344,"MO","1",1344,"2","2019-12-17 15:54:26","2","2019-12-17 15:54:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:54:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7050","RENT","\u9810\u7e73\u79df\u91d1",10,1344,"MO","1",1344,"2","2019-12-17 15:54:26","2","2019-12-17 15:54:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:54:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7050","RENT","\u9810\u7e73\u79df\u91d1",11,1344,"MO","1",1344,"2","2019-12-17 15:54:26","2","2019-12-17 15:54:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:54:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7050","RENT","\u9810\u7e73\u79df\u91d1",12,1344,"MO","1",1344,"2","2019-12-17 15:54:26","2","2019-12-17 15:54:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:54:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[12520,0,"7050"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-17 15:54:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1472,"BANKIN","","","","BANKIN","","","","PAID","P196700","2019-12-17 15:54:26",15964,"2","2019-12-17 15:54:26","2","2019-12-17 15:54:26","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:54:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6700","DEPOSIT","5223","PAID","2019-12-17 15:54:26",3444,"2","2019-12-17 15:54:26","2","2019-12-17 15:54:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 15:54:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6700","INVOICE","7050","PAID","2019-12-17 15:54:26",12520,"2","2019-12-17 15:54:26","2","2019-12-17 15:54:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 16:52:55","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1021&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1246","master_room_id":"144","room_code":"B01-056"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1425,"customer_code":"C191425","identity_type":"BUSINESS","identity_id":"2519978","title":"Mr","lastname":"Wong ","firstname":"Man Cheung","companyname":"Serene Capital Limited","email":"philipwong@certproperty.co.uk","tel":"90941892","address":"16A, 16\/F Chung Hing Commercial Building, 62 Connaught Road Central, Central, H.K.","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"2","renew_warehousing_date":"2019-12-17","renew_room_key":"0012450069","renew_remark":"2 months contract. Special offer 5% \u201crent Now\u201d discount. Storage rental and deposit paid by cash on October 17, 2019. Smartcard and padlock provided on October 17, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196162, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1196.0","renew_master_room_id":"1","order_discount":[],"order_room":[{"room_id":"213","room_code":"D17","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":1196,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-17","rent_from":"2019-12-17","rent_to":"2020-02-16","delivery_service":"0","remark":"2 months contract. Storage rental paid by WeChat Pay on December 17, 2019. Storage deposit $1196 transferred from agreement A12-CT196162 to this agreement. **$18 charge for WeChat Pay.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"OTHER","paymethod_other2":"WeChat Pay","discount_deduct":0,"order_total":1196,"final_order_total":1196,"location_id":"1","branch_id":"1","company_id":"1","room_key":"0012450069","order_product":[],"pass":true}},"first_order_id":"3347","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> D17 <\/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> \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":"12","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 16:52:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",1425,"NEW","A12-CT196723",598,598,0,0,"2","2",1196,1196,1196,"2019-12-17 16:52:55","0",null,null,null,"2019-12-17","2020-02-16","2 months contract. Storage rental paid by WeChat Pay on December 17, 2019. Storage deposit $1196 transferred from agreement A12-CT196162 to this agreement. **$18 charge for WeChat Pay.","2019-12-17","12",0,null,0,"0","2","2019-12-17 16:52:55","2","2019-12-17 16:52:55","NO_NEED_PAID_RENEW","","","","OTHER","","","WeChat Pay",null,0,"0012450069","C191425","BUSINESS","Mr","G+w65JkR7AS+JT7hCDD+yg==","DgLsCGM4faTvgwjKBW9M0A==","Serene Capital Limited","S4o9AXA7eRky9fl+GI6ii2+TMoCmBDuByzpKzUF7jpxGD0QmypETmhNR0PVTCj612a7mYANU+Sc3i0encOiszMwjCriyODNCJhdNRzJhCfKfqggF6Ry9Getc\/0LKYKRN","CL6e4EkMiRzRr0Rve85mrw==","eLkWayCc4RkCZg6CrTQmBSr+4xmx9fTzOhnQ35wQOzA=",null,"JdjeYwtWISTCzDjjVIKzVw==",1,"3347"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 16:52:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6723","213","598.0","598.00","2","2019-12-17 16:52:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 16:52:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-17","2020-02-16","213"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-17 16:52:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6723",1425,"SETTLED","A12-I197051","2019-12-17 16:52:55","2019-12-17","2","2019-12-17 16:52:55","2","2019-12-17 16:52:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 16:52:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7051","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2019-12-17 16:52:55","2","2019-12-17 16:52:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 16:52:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7051","RENT","\u9810\u7e73\u79df\u91d1",2,598,"MO","1",598,"2","2019-12-17 16:52:55","2","2019-12-17 16:52:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 16:52:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1196,0,"7051"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-17 16:52:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1425,"NO_NEED_PAID_RENEW","","","","OTHER","","","WeChat Pay","PAID","P196701","2019-12-17 16:52:55",1196,"2","2019-12-17 16:52:55","2","2019-12-17 16:52:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 16:52:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6701","DEPOSIT",null,"PAID","2019-12-17 16:52:55",0,"2","2019-12-17 16:52:55","2","2019-12-17 16:52:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 16:52:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6701","INVOICE","7051","PAID","2019-12-17 16:52:55",1196,"2","2019-12-17 16:52:55","2","2019-12-17 16:52:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 17:36:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 18:16:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 18:43:11","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"all=1&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1246","master_room_id":"144","room_code":"B01-056"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":611,"customer_code":"C170611","identity_type":"PERSONAL","identity_id":"G134295(8)","title":"Ms","lastname":"Lam","firstname":"Yi Wa Eva","companyname":"","email":"lam10bin@yahoo.com.hk","tel":"96770069","address":"Rm. 3, 28\/F, Kwun Chiu Court, Aberdeen Centre, 3 Nam Ning St, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"5028.0","renew_rent_month":"6","renew_warehousing_date":"2019-12-18","renew_room_key":"136,58225","renew_remark":"6 months contract. Storage rental paid by bank transfer on June 21, 2019. Storage deposit transferred from agreement A18-CT183918 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195304, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"94","order_discount":[],"order_room":[{"room_id":"856","room_code":"S15","retail_price":"5442.0","discounted_price":"5442.00","location_id":"3"}],"roughly_size":"72","total_retail_price":5442,"total_discounted_price":5028,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":30168,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-18","rent_from":"2019-12-18","rent_to":"2020-06-17","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on December 15, 2019. Storage deposit transferred from agreement A18-CT195304 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":30168,"final_order_total":30168,"location_id":"3","branch_id":"1","company_id":"1","room_key":"136,58225","order_product":[],"pass":true}},"first_order_id":"3918","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> S15 <\/td>\r\n\t\t\t\t\t 9X8X7 <\/td>\r\n\t\t\t\t\t $5442.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":"72","total_discounted_price":"5028.0","deposit":"0","total_retail_price":"5442.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 18:43:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",611,"NEW","A18-CT196724",5442,5028,0,0,"6","6",30168,30168,30168,"2019-12-17 18:43:11","0",null,null,null,"2019-12-18","2020-06-17","6 months contract. Storage rental paid by bank transfer on December 15, 2019. Storage deposit transferred from agreement A18-CT195304 to this agreement.","2019-12-18","72",0,null,0,"0","2","2019-12-17 18:43:11","2","2019-12-17 18:43:11","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,58225","C170611","PERSONAL","Ms","k6KJ030A7zfFevzzPI1dtA==","0JxYUqbNPOvgfMwVa0l0NA==","","1AxWEBjVAlrF+cc3dFMqQhOUjyeR3BrT85QHP0YVRL4R8sghj8C57WASejsvdqmlmfGCulfc4XMvQ+32pJ+rv70HbkmgUk\/53YKu8Tj+rWA=","sDBEWc2c2gJA\/JUUiY2C7A==","\/FRzpvEdV5N09FgT\/FXZ7O0VeFhZryC3q7d3WjLoXeU=","qVaKW1QzXr5qSXIgHFwmWQ==",null,1,"3918"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 18:43:11","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":["6724","856","5442.0","5442.00","2","2019-12-17 18:43:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 18:43:11","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":["2019-12-18","2020-06-17","856"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-17 18:43:11","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":["6724",611,"SETTLED","A18-I197052","2019-12-17 18:43:11","2019-12-18","2","2019-12-17 18:43:11","2","2019-12-17 18:43:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 18:43:11","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":["7052","RENT","\u9810\u7e73\u79df\u91d1",1,5028,"MO","1",5028,"2","2019-12-17 18:43:11","2","2019-12-17 18:43:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 18:43:11","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":["7052","RENT","\u9810\u7e73\u79df\u91d1",2,5028,"MO","1",5028,"2","2019-12-17 18:43:11","2","2019-12-17 18:43:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 18:43:11","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":["7052","RENT","\u9810\u7e73\u79df\u91d1",3,5028,"MO","1",5028,"2","2019-12-17 18:43:11","2","2019-12-17 18:43:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 18:43:11","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":["7052","RENT","\u9810\u7e73\u79df\u91d1",4,5028,"MO","1",5028,"2","2019-12-17 18:43:11","2","2019-12-17 18:43:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 18:43:11","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":["7052","RENT","\u9810\u7e73\u79df\u91d1",5,5028,"MO","1",5028,"2","2019-12-17 18:43:11","2","2019-12-17 18:43:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 18:43:11","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":["7052","RENT","\u9810\u7e73\u79df\u91d1",6,5028,"MO","1",5028,"2","2019-12-17 18:43:11","2","2019-12-17 18:43:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 18:43:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[30168,0,"7052"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-17 18:43:11","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":[611,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196702","2019-12-17 18:43:11",30168,"2","2019-12-17 18:43:11","2","2019-12-17 18:43:11","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 18:43:11","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":["6702","DEPOSIT",null,"PAID","2019-12-17 18:43:11",0,"2","2019-12-17 18:43:11","2","2019-12-17 18:43:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-17 18:43:11","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":["6702","INVOICE","7052","PAID","2019-12-17 18:43:11",30168,"2","2019-12-17 18:43:11","2","2019-12-17 18:43:11"]},"data_before":[],"data_after":[],"step":1} *****