{"created_at":"2020-01-14 09:58:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 10:04:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 12:29:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 12:37:20","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=225&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":"1063","master_room_id":"108","room_code":"A05-061"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":881,"customer_code":"C180881","identity_type":"PERSONAL","identity_id":"K531352(A)","title":"Ms","lastname":"CHOY","firstname":"EUPHEMIA","companyname":"","email":"euphem@yahoo.com","tel":"92022175","address":"27\/F, Flat D, Block 16, South Horizons, Ap Lei Chau","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"814.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-27","renew_room_key":"0005921000","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 20, 2019. Storage deposit transferred from agreement A05-CT196375 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196755, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"108","order_discount":[],"order_room":[{"room_id":"1034","room_code":"A05-032","retail_price":"1006.0","discounted_price":"1006.00","location_id":"4"}],"roughly_size":"9","total_retail_price":1006,"total_discounted_price":814,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":814,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-27","rent_from":"2019-12-27","rent_to":"2020-01-26","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 14, 2020. Storage deposit transferred from agreement A05-CT196755 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":814,"final_order_total":814,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0005921000","order_product":[],"pass":true}},"first_order_id":"4882","selected_room_tr":"\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t

---

\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t

\u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t

\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>
A05-032 <\/td>\r\n\t\t\t\t\t	3X3X7 <\/td>\r\n\t\t\t\t\t	$1006.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"9","total_discounted_price":"814.0","deposit":"0","total_retail_price":"1006.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 12:37:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",881,"NEW","A05-CT206954",1006,814,0,0,"1","1",814,814,814,"2020-01-14 12:37:21","0",null,null,null,"2019-12-27","2020-01-26","1 month contract. Storage rental paid by bank transfer on January 14, 2020. Storage deposit transferred from agreement A05-CT196755 to this agreement.","2019-12-27","9",0,null,0,"0","2","2020-01-14 12:37:20","2","2020-01-14 12:37:20","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005921000","C180881","PERSONAL","Ms","cgxXGJI\/ZTnh+WLA7hfGwg==","KHX1V\/o61A5lYN2Th2Ak\/Q==","","U8wra+WSnJl5LR7S5iiWZnnh338ln2lsz3xMjaQzmzZP4BCRoLcPkHMf26rmrqVZKqHoyISkO4JAVUv4wniBZg==","JgGxc0OPptFMBUC8eZGB8A==","cCZv0x8iMqg8yBlgEfmg12iFWmQM8Gc1m7ERyq86bXs=","uZ7Ygw5sLpeeqN2M2YKoJA==",null,1,"4882"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 12:37:21","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":["6954","1034","1006.0","1006.00","2","2020-01-14 12:37:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 12:37:21","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-27","2020-01-26","1034"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-14 12:37:21","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":["6954",881,"SETTLED","A05-I207282","2020-01-14 12:37:20","2019-12-27","2","2020-01-14 12:37:20","2","2020-01-14 12:37:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 12:37:21","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":["7282","RENT","\u9810\u7e73\u79df\u91d1",1,814,"MO","1",814,"2","2020-01-14 12:37:20","2","2020-01-14 12:37:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 12:37:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[814,0,"7282"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-14 12:37:21","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":[881,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206931","2020-01-14 12:37:20",814,"2","2020-01-14 12:37:20","2","2020-01-14 12:37:20","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 12:37:21","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":["6931","DEPOSIT",null,"PAID","2020-01-14 12:37:20",0,"2","2020-01-14 12:37:20","2","2020-01-14 12:37:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 12:37:21","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":["6931","INVOICE","7282","PAID","2020-01-14 12:37:20",814,"2","2020-01-14 12:37:20","2","2020-01-14 12:37:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 12:41:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 13:03:58","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=225&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":"1063","master_room_id":"108","room_code":"A05-061"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1063,"customer_code":"C181063","identity_type":"PERSONAL","identity_id":"P150061(2)","title":"Ms","lastname":"HASKINS","firstname":"Eileen Mary","companyname":"","email":"eimart@netvigator.com","tel":"92769708","address":"House 20A Pok Kok Tsven","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"6","renew_warehousing_date":"2019-12-13","renew_room_key":"'0012435080","renew_remark":"6 months contract. Storage rental paid by EPS on July 6, 2019. Storage deposit $2580 transferred from agreement A05-CT195134 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT195411, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"114","order_discount":[],"order_room":[{"room_id":"1126","room_code":"A05-124","retail_price":"1290.0","discounted_price":"1290.00","location_id":"4"}],"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-13","rent_from":"2019-12-13","rent_to":"2020-01-12","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 14, 2019. Storage deposit $2580 transferred from agreement A05-CT195411 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0012435080","order_product":[],"pass":true}},"first_order_id":"3560","selected_room_tr":"	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-124 <\/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.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 13:03:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1063,"NEW","A05-CT206955",1290,1290,0,0,"1","1",1290,1290,1290,"2020-01-14 13:03:59","0",null,null,null,"2019-12-13","2020-01-12","1 month contract. Storage rental paid by bank transfer on January 14, 2019. Storage deposit $2580 transferred from agreement A05-CT195411 to this agreement.","2019-12-13","16",0,null,0,"0","2","2020-01-14 13:03:58","2","2020-01-14 13:03:58","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0012435080","C181063","PERSONAL","Ms","N2dL4uJnRUVt3pWxZbjoPA==","gBCfCDjxN1soEZ6ASSV8CQ==","","WxFMz3JMJw0zIWOLHcLgDzylG1NdowDT02leCzTzNHk=","9LmyvpD23mCmBchshNAO0w==","WMY4NPSZuxSFljp7Sz0XPINva+8MxbIjoBMZ02LKzdU=","UcXhFM2zM7eIpbzXOGUfvA==",null,1,"3560"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 13:03:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6955","1126","1290.0","1290.00","2","2020-01-14 13:03:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 13:03:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-13","2020-01-12","1126"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-14 13:03:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6955",1063,"SETTLED","A05-I207283","2020-01-14 13:03:58","2019-12-13","2","2020-01-14 13:03:58","2","2020-01-14 13:03:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 13:03:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7283","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-01-14 13:03:58","2","2020-01-14 13:03:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 13:03:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"7283"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-14 13:03:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1063,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206932","2020-01-14 13:03:58",1290,"2","2020-01-14 13:03:58","2","2020-01-14 13:03:58","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 13:03:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6932","DEPOSIT",null,"PAID","2020-01-14 13:03:58",0,"2","2020-01-14 13:03:58","2","2020-01-14 13:03:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 13:03:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6932","INVOICE","7283","PAID","2020-01-14 13:03:58",1290,"2","2020-01-14 13:03:58","2","2020-01-14 13:03:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 14:40:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:08:21","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1183&filter3=undefined","floor_plan_rent_room":[{"room_id":"1063","master_room_id":"108","room_code":"A05-061"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1234,"customer_code":"C191234","identity_type":"PERSONAL","identity_id":"A992753(3)","title":"Mr","lastname":"Leung","firstname":"Fook Chi","companyname":"","email":null,"tel":"92580224","address":"Flat 612, Hoi Au Lau, Yue Kwong Chuen, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"568.0","renew_rent_month":"3","renew_warehousing_date":"2020-01-30","renew_room_key":"076,34771","renew_remark":"3 months contract. Storage rental paid by cash on Oct 29, 2019. Storage deposit $1196 transferred from agreement A12-CT196042 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196246, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"1","order_discount":[],"order_room":[{"room_id":"206","room_code":"D10","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":568,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":1704,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-30","rent_from":"2020-01-30","rent_to":"2020-04-29","delivery_service":"0","remark":"3 months contract. Storage rental paid by cash on January 14, 2020. Storage deposit $1196 transferred from agreement A12-CT196246 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":1704,"final_order_total":1704,"location_id":"1","branch_id":"1","company_id":"1","room_key":"076,34771","order_product":[],"pass":true}},"first_order_id":"4825","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> D10 <\/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":"568.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:08:21","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",1234,"NEW","A12-CT206956",598,568,0,0,"3","3",1704,1704,1704,"2020-01-14 15:08:21","0",null,null,null,"2020-01-30","2020-04-29","3 months contract. Storage rental paid by cash on January 14, 2020. Storage deposit $1196 transferred from agreement A12-CT196246 to this agreement.\r\n","2020-01-30","12",0,null,0,"0","2","2020-01-14 15:08:21","2","2020-01-14 15:08:21","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"076,34771","C191234","PERSONAL","Mr","F\/umanY79JktEH7A1eI69g==","xEf2h2aoyRQ71ZVgBH+9WQ==","","XTYU2OniJyv9lUGzwvbJSHyM14sep7GRbYQb3Jgep2k7Fi1IMrcmDV5+Z25SrXkFYSvlx5HtEATFWvWN2DLe2Q==","gnPh6HJdAP7lRaZUREQgWQ==",null,"rDZcYGHuhVj1YRDxDF7BDg==",null,1,"4825"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:08:21","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":["6956","206","598.0","598.00","2","2020-01-14 15:08:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:08:21","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-30","2020-04-29","206"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-14 15:08:21","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":["6956",1234,"SETTLED","A12-I207284","2020-01-14 15:08:21","2020-01-30","2","2020-01-14 15:08:21","2","2020-01-14 15:08:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:08:21","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":["7284","RENT","\u9810\u7e73\u79df\u91d1",1,568,"MO","1",568,"2","2020-01-14 15:08:21","2","2020-01-14 15:08:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:08:21","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":["7284","RENT","\u9810\u7e73\u79df\u91d1",2,568,"MO","1",568,"2","2020-01-14 15:08:21","2","2020-01-14 15:08:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:08:21","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":["7284","RENT","\u9810\u7e73\u79df\u91d1",3,568,"MO","1",568,"2","2020-01-14 15:08:21","2","2020-01-14 15:08:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:08:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1704,0,"7284"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-14 15:08:21","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":[1234,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P206933","2020-01-14 15:08:21",1704,"2","2020-01-14 15:08:21","2","2020-01-14 15:08:21","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:08:21","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":["6933","DEPOSIT",null,"PAID","2020-01-14 15:08:21",0,"2","2020-01-14 15:08:21","2","2020-01-14 15:08:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:08:21","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":["6933","INVOICE","7284","PAID","2020-01-14 15:08:21",1704,"2","2020-01-14 15:08:21","2","2020-01-14 15:08:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:42:02","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1183&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1063","master_room_id":"108","room_code":"A05-061"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":484,"customer_code":"C170484","identity_type":"BUSINESS","identity_id":"31179549","title":"Ms","lastname":"Lui","firstname":"Yu Oi Elaine","companyname":"E-Max Group Limited","email":"elaineyolui@gmail.com","tel":"91690909","address":"Flat C,18\/F,Butler Towers 1-5 Boyce Road, Jardines,Lookout","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2018.0","renew_rent_month":"12","renew_warehousing_date":"2020-01-05","renew_room_key":"136,12279,054,12169","renew_remark":"12 months contract. Storage rental paid by cheque deposit on Januray 4, 2019. Storage deposit transferred from agreement SD14-CT182240 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT194096, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"30","order_discount":[],"order_room":[{"room_id":"660","room_code":"M71","retail_price":"775.0","discounted_price":"775.00","location_id":"2"},{"room_id":"659","room_code":"M70","retail_price":"775.0","discounted_price":"775.00","location_id":"2"},{"room_id":"646","room_code":"M57","retail_price":"775.0","discounted_price":"775.00","location_id":"2"},{"room_id":"645","room_code":"M56","retail_price":"775.0","discounted_price":"775.00","location_id":"2"}],"roughly_size":"36","total_retail_price":3100,"total_discounted_price":2018,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":24216,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-05","rent_from":"2020-01-05","rent_to":"2021-01-04","delivery_service":"0","remark":"12 months contract. Special offer $300 Maxim's voucher. Storage rental paid by cheque deposit on January 14, 2020. Storage deposit transferred from agreement A14-CT194096 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":24216,"final_order_total":24216,"location_id":"2","branch_id":"1","company_id":"1","room_key":"136,12279,054,12169","order_product":[],"pass":true}},"first_order_id":4096,"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\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> M71 <\/td>\r\n\t\t\t\t\t 3X3X8 <\/td>\r\n\t\t\t\t\t $775.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> M70 <\/td>\r\n\t\t\t\t\t 3X3X8 <\/td>\r\n\t\t\t\t\t $775.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> M57 <\/td>\r\n\t\t\t\t\t 3X3X8 <\/td>\r\n\t\t\t\t\t $775.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> M56 <\/td>\r\n\t\t\t\t\t 3X3X8 <\/td>\r\n\t\t\t\t\t $775.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"36","total_discounted_price":"2018.0","deposit":"0","total_retail_price":"3100.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:42:02","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",484,"NEW","A14-CT206957",3100,2018,0,0,"12","12",24216,24216,24216,"2020-01-14 15:42:02","0",null,null,null,"2020-01-05","2021-01-04","12 months contract. Special offer $300 Maxim's voucher. Storage rental paid by cheque deposit on January 14, 2020. Storage deposit transferred from agreement A14-CT194096 to this agreement.","2020-01-05","36",0,null,0,"0","2","2020-01-14 15:42:02","2","2020-01-14 15:42:02","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,12279,054,12169","C170484","BUSINESS","Ms","4Rki7+GZ4\/N3\/SBXOx1Szg==","vyCKi4IYWx3VnCZylJM1yA==","E-Max Group Limited","v4xjkpGLfPjpiXUW3YzJKd0vWx1+UR736FTXE6z1CrCiTdqaiSH4\/PMmpUruifj1mkMIs4DkmMhwN9O+1XLzyA==","SDuuMtMJBeHA5xQm3oDIfQ==","EE5ZEQeHHeusHAEPKfLAp0EfbOuRfCgFFSyyHLM6Hps=",null,"DhwxPF5CEkDhurzM7Juvxw==",1,4096]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:42:02","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":["6957","660","775.0","775.00","2","2020-01-14 15:42:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:42:02","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-05","2021-01-04","660"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-14 15:42:02","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":["6957","659","775.0","775.00","2","2020-01-14 15:42:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:42:02","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-05","2021-01-04","659"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-14 15:42:02","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":["6957","646","775.0","775.00","2","2020-01-14 15:42:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:42:02","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-05","2021-01-04","646"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-14 15:42:02","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":["6957","645","775.0","775.00","2","2020-01-14 15:42:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:42:02","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-05","2021-01-04","645"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-14 15:42:02","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":["6957",484,"SETTLED","A14-I207285","2020-01-14 15:42:02","2020-01-05","2","2020-01-14 15:42:02","2","2020-01-14 15:42:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:42:02","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":["7285","RENT","\u9810\u7e73\u79df\u91d1",1,2018,"MO","1",2018,"2","2020-01-14 15:42:02","2","2020-01-14 15:42:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:42:02","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":["7285","RENT","\u9810\u7e73\u79df\u91d1",2,2018,"MO","1",2018,"2","2020-01-14 15:42:02","2","2020-01-14 15:42:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:42:02","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":["7285","RENT","\u9810\u7e73\u79df\u91d1",3,2018,"MO","1",2018,"2","2020-01-14 15:42:02","2","2020-01-14 15:42:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:42:02","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":["7285","RENT","\u9810\u7e73\u79df\u91d1",4,2018,"MO","1",2018,"2","2020-01-14 15:42:02","2","2020-01-14 15:42:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:42:02","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":["7285","RENT","\u9810\u7e73\u79df\u91d1",5,2018,"MO","1",2018,"2","2020-01-14 15:42:02","2","2020-01-14 15:42:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:42:02","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":["7285","RENT","\u9810\u7e73\u79df\u91d1",6,2018,"MO","1",2018,"2","2020-01-14 15:42:02","2","2020-01-14 15:42:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:42:02","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":["7285","RENT","\u9810\u7e73\u79df\u91d1",7,2018,"MO","1",2018,"2","2020-01-14 15:42:02","2","2020-01-14 15:42:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:42:02","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":["7285","RENT","\u9810\u7e73\u79df\u91d1",8,2018,"MO","1",2018,"2","2020-01-14 15:42:02","2","2020-01-14 15:42:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:42:02","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":["7285","RENT","\u9810\u7e73\u79df\u91d1",9,2018,"MO","1",2018,"2","2020-01-14 15:42:02","2","2020-01-14 15:42:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:42:02","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":["7285","RENT","\u9810\u7e73\u79df\u91d1",10,2018,"MO","1",2018,"2","2020-01-14 15:42:02","2","2020-01-14 15:42:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:42:02","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":["7285","RENT","\u9810\u7e73\u79df\u91d1",11,2018,"MO","1",2018,"2","2020-01-14 15:42:02","2","2020-01-14 15:42:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:42:02","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":["7285","RENT","\u9810\u7e73\u79df\u91d1",12,2018,"MO","1",2018,"2","2020-01-14 15:42:02","2","2020-01-14 15:42:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:42:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[24216,0,"7285"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-14 15:42:02","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":[484,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206934","2020-01-14 15:42:02",24216,"2","2020-01-14 15:42:02","2","2020-01-14 15:42:02","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:42:02","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":["6934","DEPOSIT",null,"PAID","2020-01-14 15:42:02",0,"2","2020-01-14 15:42:02","2","2020-01-14 15:42:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 15:42:02","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":["6934","INVOICE","7285","PAID","2020-01-14 15:42:02",24216,"2","2020-01-14 15:42:02","2","2020-01-14 15:42:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:33:24","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=0&filter2=373&filter3=undefined&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-180 <\/td>\r\n\t\t\t\t\t 5X5X6.5 <\/td>\r\n\t\t\t\t\t $1518.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":"D462569(3)","title":"Mr","lastname":"Choy","firstname":"Sze Chung Jojo","companyname":"","email":"jojochoy@gmail.com","tel":"91903216","address":"15B Evelyn Towers, 38 Cloud View RD, North Point , Hk","pass":true,"customer_id":1160,"customer_code":"C181160","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"422","master_room_id":"182","discount_type":"%","price":"1518.00","disocunted_price":"1139.90","discount":"24.91","monthly_deduct":378.1338,"room_id":"1486","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"945.0","renew_rent_month":"12","renew_warehousing_date":"2020-01-15","renew_room_key":"'0006046794,","renew_remark":"12 months contract. Special promotion offered, 2 months free of charge and \u63a8\u85a6\u56de\u8d08-$250.Storage rental and deposit paid by EPS on 24 Dec 2018. 1 Pcsc Smartcard provided on 24 Dec 2018.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT184027, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1260.0","renew_master_room_id":"182","order_room":[{"room_id":"1486","room_code":"C15-180","retail_price":"1518.0","discounted_price":1139.9,"location_id":"6"}],"roughly_size":"25","total_retail_price":1518,"total_discounted_price":1134,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6804,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-15","rent_from":"2020-01-15","rent_to":"2020-07-14","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on Jan 14,2020. Deposit $1260 transferred from agreement C15-CT184027 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6804,"final_order_total":6804,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0006046794,","order_product":[],"pass":true}},"renew":1,"first_order_id":4027,"roughly_size":"25","total_discounted_price":"1134.00","deposit":"0.00","total_retail_price":"1518.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:33:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1160,"NEW","C15-CT206958",1518,1134,0,0,"6","6",6804,6804,6804,"2020-01-14 16:33:24","0",null,null,null,"2020-01-15","2020-07-14","6 months contract. Storage rental paid by bank transfer on Jan 14,2020. Deposit $1260 transferred from agreement C15-CT184027 to this agreement.","2020-01-15","25",0,null,0,"0","2","2020-01-14 16:33:23","2","2020-01-14 16:33:23","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0006046794,","C181160","PERSONAL","Mr","XogQYsqczoWnr4VqdZowjw==","UrsMAvfb5x9QBcnJ8435JA==","","QgzO2FLBPgqXVT2HNRCQ87I3YqoXNoOgHsBhrNpLCnw+Wn3ZACwNZzmxjIX1MXiYgE3IDkBWxCs7UQ6zi7VCeQ==","jf7soTnmPMmSkegQolte2g==","nBE2d105hijLGGJB19HZKpSsodmdGDDNS1ARH0VsypU=","9Bm8p6PA+pgd+C4g7PSY5w==",null,1,4027]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:33:24","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":["6958","422","182","1486","%","24.91",378.1338,"2","2020-01-14 16:33:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:33:24","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":["6958","1486","1518.0",1139.9,"2","2020-01-14 16:33:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:33:24","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-15","2020-07-14","1486"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-14 16:33:24","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":["6958",1160,"SETTLED","C15-I207286","2020-01-14 16:33:23","2020-01-15","2","2020-01-14 16:33:23","2","2020-01-14 16:33:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:33:24","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":["7286","RENT","\u9810\u7e73\u79df\u91d1",1,1134,"MO","1",1134,"2","2020-01-14 16:33:23","2","2020-01-14 16:33:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:33:24","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":["7286","RENT","\u9810\u7e73\u79df\u91d1",2,1134,"MO","1",1134,"2","2020-01-14 16:33:23","2","2020-01-14 16:33:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:33:24","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":["7286","RENT","\u9810\u7e73\u79df\u91d1",3,1134,"MO","1",1134,"2","2020-01-14 16:33:23","2","2020-01-14 16:33:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:33:24","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":["7286","RENT","\u9810\u7e73\u79df\u91d1",4,1134,"MO","1",1134,"2","2020-01-14 16:33:23","2","2020-01-14 16:33:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:33:24","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":["7286","RENT","\u9810\u7e73\u79df\u91d1",5,1134,"MO","1",1134,"2","2020-01-14 16:33:23","2","2020-01-14 16:33:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:33:24","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":["7286","RENT","\u9810\u7e73\u79df\u91d1",6,1134,"MO","1",1134,"2","2020-01-14 16:33:23","2","2020-01-14 16:33:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:33:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6804,0,"7286"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-14 16:33:24","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":[1160,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206935","2020-01-14 16:33:23",6804,"2","2020-01-14 16:33:23","2","2020-01-14 16:33:23","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:33:24","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":["6935","DEPOSIT",null,"PAID","2020-01-14 16:33:23",0,"2","2020-01-14 16:33:23","2","2020-01-14 16:33:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:33:24","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":["6935","INVOICE","7286","PAID","2020-01-14 16:33:23",6804,"2","2020-01-14 16:33:23","2","2020-01-14 16:33:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:51:04","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1183&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1063","master_room_id":"108","room_code":"A05-061"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":736,"customer_code":"C180736","identity_type":"PERSONAL","identity_id":"K807389(9)","title":"Ms","lastname":"Lau","firstname":"Ka Man","companyname":"","email":"carmenlau125@yahoo.com.hk","tel":"63022090","address":"Flat F, 28\/F, South View Garden, 80 Shek Pai Wan Rd, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-20","renew_room_key":"054,44555","renew_remark":"6 months contract. Storage rental paid by bank transfer on 08 July, 2019. Storage deposit transferred from agreement A14-CT194076 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195435, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"616","room_code":"M27","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-20","rent_from":"2020-01-20","rent_to":"2020-07-19","delivery_service":"0","remark":"6 months contract. Storage rental paid by PPS on January 13, 2020. Storage deposit transferred from agreement A14-CT195435 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,44555","order_product":[],"pass":true}},"first_order_id":"4076","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> M27 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"538.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:51: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","2",736,"NEW","A14-CT206959",598,538,0,0,"6","6",3228,3228,3228,"2020-01-14 16:51:05","0",null,null,null,"2020-01-20","2020-07-19","6 months contract. Storage rental paid by PPS on January 13, 2020. Storage deposit transferred from agreement A14-CT195435 to this agreement.","2020-01-20","12",0,null,0,"0","2","2020-01-14 16:51:04","2","2020-01-14 16:51:04","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,44555","C180736","PERSONAL","Ms","mpGDaYSZYMm5Nv4dlC\/AXA==","oe4emdjBwqJ3qUpOcI17hw==","","Nw7URylCDteDfjqTBIWmV5NTeCR2qzRKgxU12GApB93QPnE67ANjgW8nSMtfrfavhFsRxlzv8pinYLCfD+QU1YNAONWkbU1G5TUcyaF9ZSQ=","ynwAxBpV3TzUg1ubAZeOkA==","dyg4ORHcKdwckBYGeoTEeQq3ZQZtIZcPUiCVcCziH8g=","ukXSVajpezkBeVRgd\/aZYg==",null,1,"4076"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:51: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":["6959","616","598.0","598.00","2","2020-01-14 16:51:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:51: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":["2020-01-20","2020-07-19","616"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-14 16:51: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":["6959",736,"SETTLED","A14-I207287","2020-01-14 16:51:04","2020-01-20","2","2020-01-14 16:51:04","2","2020-01-14 16:51:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:51: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":["7287","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-01-14 16:51:04","2","2020-01-14 16:51:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:51: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":["7287","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-01-14 16:51:04","2","2020-01-14 16:51:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:51: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":["7287","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-01-14 16:51:04","2","2020-01-14 16:51:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:51: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":["7287","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-01-14 16:51:04","2","2020-01-14 16:51:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:51: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":["7287","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-01-14 16:51:04","2","2020-01-14 16:51:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:51: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":["7287","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-01-14 16:51:04","2","2020-01-14 16:51:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:51:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"7287"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-14 16:51: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":[736,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P206936","2020-01-14 16:51:04",3228,"2","2020-01-14 16:51:04","2","2020-01-14 16:51:04","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:51: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":["6936","DEPOSIT",null,"PAID","2020-01-14 16:51:04",0,"2","2020-01-14 16:51:04","2","2020-01-14 16:51:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:51: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":["6936","INVOICE","7287","PAID","2020-01-14 16:51:04",3228,"2","2020-01-14 16:51:04","2","2020-01-14 16:51:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:55:44","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1183&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":"1063","master_room_id":"108","room_code":"A05-061"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":219,"customer_code":"C160219","identity_type":"PERSONAL","identity_id":"R605880(8)","title":"Mr","lastname":"Rinaldi","firstname":"Michael","companyname":"","email":"rinaldi927@gmail.com","tel":"92898464","address":"Flat A,6?F Block 26,555 Victoria Road, Pok Fu Lam","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"12","renew_warehousing_date":"2020-02-01","renew_room_key":"054,60932","renew_remark":"12 months contract. Storage rental paid by EPS on July January 14, 2019. Storage deposit transferred from agreement A14-CT182772 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT194157, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"613","room_code":"M24","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":6456,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-01","rent_from":"2020-02-01","rent_to":"2021-01-31","delivery_service":"0","remark":"12 months contract. Special offer $300 Maxim's voucher. Storage rental paid by PPS on January 13, 2020. Storage deposit transferred from agreement A14-CT194157 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":6456,"final_order_total":6456,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,60932","order_product":[],"pass":true}},"first_order_id":4157,"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> M24 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"538.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:55:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",219,"NEW","A14-CT206960",598,538,0,0,"12","12",6456,6456,6456,"2020-01-14 16:55:44","0",null,null,null,"2020-02-01","2021-01-31","12 months contract. Special offer $300 Maxim's voucher. Storage rental paid by PPS on January 13, 2020. Storage deposit transferred from agreement A14-CT194157 to this agreement.","2020-02-01","12",0,null,0,"0","2","2020-01-14 16:55:44","2","2020-01-14 16:55:44","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,60932","C160219","PERSONAL","Mr","YilGtBh9XURVNx7Mrfqybg==","g5CveKvmE\/IeAQTDoanc8g==","","JwFXHcuw9DC3r9IP\/917v9acFxgWlXgvjj3jdG8g4X\/klbbndDQIKJnLNOaQce5XZm9hw1BF20Def30YJH0EUA==","Vag26Q+JYWCgrARVCa8kyA==","NB0J252RDCs+zIbIjRevpMjPM1\/4EKhTx4IdTu7R+UA=","7Kxc850uFwEcXfcqNmDbHA==",null,1,4157]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:55:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6960","613","598.0","598.00","2","2020-01-14 16:55:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:55:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2021-01-31","613"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-14 16:55:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6960",219,"SETTLED","A14-I207288","2020-01-14 16:55:44","2020-02-01","2","2020-01-14 16:55:44","2","2020-01-14 16:55:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:55:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7288","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-01-14 16:55:44","2","2020-01-14 16:55:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:55:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7288","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-01-14 16:55:44","2","2020-01-14 16:55:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:55:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7288","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-01-14 16:55:44","2","2020-01-14 16:55:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:55:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7288","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-01-14 16:55:44","2","2020-01-14 16:55:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:55:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7288","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-01-14 16:55:44","2","2020-01-14 16:55:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:55:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7288","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-01-14 16:55:44","2","2020-01-14 16:55:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:55:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7288","RENT","\u9810\u7e73\u79df\u91d1",7,538,"MO","1",538,"2","2020-01-14 16:55:44","2","2020-01-14 16:55:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:55:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7288","RENT","\u9810\u7e73\u79df\u91d1",8,538,"MO","1",538,"2","2020-01-14 16:55:44","2","2020-01-14 16:55:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:55:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7288","RENT","\u9810\u7e73\u79df\u91d1",9,538,"MO","1",538,"2","2020-01-14 16:55:44","2","2020-01-14 16:55:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:55:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7288","RENT","\u9810\u7e73\u79df\u91d1",10,538,"MO","1",538,"2","2020-01-14 16:55:44","2","2020-01-14 16:55:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:55:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7288","RENT","\u9810\u7e73\u79df\u91d1",11,538,"MO","1",538,"2","2020-01-14 16:55:44","2","2020-01-14 16:55:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:55:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7288","RENT","\u9810\u7e73\u79df\u91d1",12,538,"MO","1",538,"2","2020-01-14 16:55:44","2","2020-01-14 16:55:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:55:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6456,0,"7288"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-14 16:55:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[219,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P206937","2020-01-14 16:55:44",6456,"2","2020-01-14 16:55:44","2","2020-01-14 16:55:44","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:55:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6937","DEPOSIT",null,"PAID","2020-01-14 16:55:44",0,"2","2020-01-14 16:55:44","2","2020-01-14 16:55:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:55:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6937","INVOICE","7288","PAID","2020-01-14 16:55:44",6456,"2","2020-01-14 16:55:44","2","2020-01-14 16:55:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:58:03","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1183&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":"1063","master_room_id":"108","room_code":"A05-061"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":373,"customer_code":"C170373","identity_type":"PERSONAL","identity_id":"A810524(6)","title":"Ms","lastname":"Tang","firstname":"Wai Fong","companyname":"","email":"tang222888@hotmail.com","tel":"92668877","address":"Flat A,13\/F,Kaning Mansion,Aberdeen,Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3784.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-20","renew_room_key":"055,46666","renew_remark":"1 month contract. Storage rental paid by PPS on November 22, 2019. Storage deposit transferred from agreement A12-CT196320 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196536, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"409","room_code":"H19","retail_price":"1938.0","discounted_price":"1938.00","location_id":"1"},{"room_id":"86","room_code":"B34","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"62.5","total_retail_price":3466,"total_discounted_price":3784,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":3784,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-20","rent_from":"2019-12-20","rent_to":"2020-01-19","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on January 13, 2020. Storage deposit transferred from agreement A12-CT196536 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":3784,"final_order_total":3784,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,46666","order_product":[],"pass":true}},"first_order_id":"4881","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> H19 <\/td>\r\n\t\t\t\t\t 5X8.5X8 <\/td>\r\n\t\t\t\t\t $1938.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> B34 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/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":"62.5","total_discounted_price":"3784.0","deposit":"0","total_retail_price":"3466.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:58:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",373,"NEW","A12-CT206961",3466,3784,0,0,"1","1",3784,3784,3784,"2020-01-14 16:58:04","0",null,null,null,"2019-12-20","2020-01-19","1 month contract. Storage rental paid by PPS on January 13, 2020. Storage deposit transferred from agreement A12-CT196536 to this agreement.","2019-12-20","62.5",0,null,0,"0","2","2020-01-14 16:58:03","2","2020-01-14 16:58:03","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,46666","C170373","PERSONAL","Ms","nTGfHLdEIudAzJAvttiE\/g==","M7CfcmE2OSMlZOkNgaoDmQ==","","BXgfEt9fXMpUNvxC+2X229VwwYS6rNmHtxMS+n23vDnbhk3n3xs6q6u0V\/EvTko5","HCKjEGhRJ8yb3ZyyPfmQag==","jQ4ob3N7+u9PyWPiMEH+PWHdZ55bC9BctdRu99koSsw=","QQr8JjuTNOLQNSu7eSLB1g==",null,1,"4881"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:58:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6961","409","1938.0","1938.00","2","2020-01-14 16:58:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:58:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-20","2020-01-19","409"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-14 16:58:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6961","86","1528.0","1528.00","2","2020-01-14 16:58:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:58:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-20","2020-01-19","86"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-14 16:58:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6961",373,"SETTLED","A12-I207289","2020-01-14 16:58:03","2019-12-20","2","2020-01-14 16:58:03","2","2020-01-14 16:58:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:58:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7289","RENT","\u9810\u7e73\u79df\u91d1",1,3784,"MO","1",3784,"2","2020-01-14 16:58:03","2","2020-01-14 16:58:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:58:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3784,0,"7289"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-14 16:58:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[373,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P206938","2020-01-14 16:58:03",3784,"2","2020-01-14 16:58:03","2","2020-01-14 16:58:03","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:58:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6938","DEPOSIT",null,"PAID","2020-01-14 16:58:03",0,"2","2020-01-14 16:58:03","2","2020-01-14 16:58:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 16:58:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6938","INVOICE","7289","PAID","2020-01-14 16:58:03",3784,"2","2020-01-14 16:58:03","2","2020-01-14 16:58:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:08:29","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1183&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":"1063","master_room_id":"108","room_code":"A05-061"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":678,"customer_code":"C180678","identity_type":"PERSONAL","identity_id":"D689728(3)","title":"Mr","lastname":"Tsang","firstname":"Wai Hong","companyname":"","email":"twhkt10@gmail.com","tel":"98320395","address":"Flat D, 21\/F, Block 1E, Chi Fu Fa Yuen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2390.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-06","renew_room_key":"055, 17451","renew_remark":"6 months contract. Storage rental paid by bank transfer on July 29, 2019. Storage deposit transferred from agreement A18-CT194061 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195597, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"98","order_discount":[{"master_room_discount_id":"274","master_room_id":"98","discount_type":"%","price":"2655.00","disocunted_price":"2389.80","discount":"9.99","monthly_deduct":265.2345,"room_id":"1000","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1000","room_code":"X25","retail_price":"2655.0","discounted_price":2389.8,"location_id":"3"}],"roughly_size":"35","total_retail_price":2655,"total_discounted_price":2390,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":14340,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-01-06","rent_from":"2020-01-06","rent_to":"2020-07-05","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on January 8, 2020. Storage deposit transferred from agreement A18-CT195597 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":14340,"final_order_total":14340,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055, 17451","order_product":[],"pass":true}},"first_order_id":"4061","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> X25 <\/td>\r\n\t\t\t\t\t 5X7X7 <\/td>\r\n\t\t\t\t\t $2655.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"35","total_discounted_price":"2390.00","deposit":"0.00","total_retail_price":"2655.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:08:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",678,"NEW","A18-CT206962",2655,2390,0,0,"6","6",14340,14340,14340,"2020-01-14 17:08:30","0",null,null,null,"2020-01-06","2020-07-05","6 months contract. Storage rental paid by bank transfer on January 8, 2020. Storage deposit transferred from agreement A18-CT195597 to this agreement.\r\n","2020-01-06","35",0,null,0,"0.00","2","2020-01-14 17:08:29","2","2020-01-14 17:08:29","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055, 17451","C180678","PERSONAL","Mr","kEw4c1OfDZt004ctJGNHMQ==","SrBvL8bV9b3Cq\/EiAmR0Dg==","","+ZmZmM8UuCOKXD9IMN73PDN5BFX5s6VE+Roz\/W3Ib8SBROhW\/rH3ehzAOzPc3dGZWM2EJQp3ucOTlWxInEPIxA==","P\/FYGqDGdhTKgtqLRAyV2w==","cfwQueSVin228mUzzU3LLy5R+ZptsRIZzJCQkdYfUgQ=","da9NvuaFEgRAzfRYDfxjrQ==",null,1,"4061"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:08:30","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":["6962","274","98","1000","%","9.99",265.2345,"2","2020-01-14 17:08:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:08:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6962","1000","2655.0",2389.8,"2","2020-01-14 17:08:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:08:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-06","2020-07-05","1000"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-14 17:08:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6962",678,"SETTLED","A18-I207290","2020-01-14 17:08:29","2020-01-06","2","2020-01-14 17:08:29","2","2020-01-14 17:08:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:08:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7290","RENT","\u9810\u7e73\u79df\u91d1",1,2390,"MO","1",2390,"2","2020-01-14 17:08:29","2","2020-01-14 17:08:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:08:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7290","RENT","\u9810\u7e73\u79df\u91d1",2,2390,"MO","1",2390,"2","2020-01-14 17:08:29","2","2020-01-14 17:08:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:08:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7290","RENT","\u9810\u7e73\u79df\u91d1",3,2390,"MO","1",2390,"2","2020-01-14 17:08:29","2","2020-01-14 17:08:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:08:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7290","RENT","\u9810\u7e73\u79df\u91d1",4,2390,"MO","1",2390,"2","2020-01-14 17:08:29","2","2020-01-14 17:08:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:08:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7290","RENT","\u9810\u7e73\u79df\u91d1",5,2390,"MO","1",2390,"2","2020-01-14 17:08:29","2","2020-01-14 17:08:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:08:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7290","RENT","\u9810\u7e73\u79df\u91d1",6,2390,"MO","1",2390,"2","2020-01-14 17:08:29","2","2020-01-14 17:08:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:08:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[14340,0,"7290"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-14 17:08:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[678,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206939","2020-01-14 17:08:29",14340,"2","2020-01-14 17:08:29","2","2020-01-14 17:08:29","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:08:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6939","DEPOSIT",null,"PAID","2020-01-14 17:08:29",0,"2","2020-01-14 17:08:29","2","2020-01-14 17:08:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:08:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6939","INVOICE","7290","PAID","2020-01-14 17:08:29",14340,"2","2020-01-14 17:08:29","2","2020-01-14 17:08:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:27:36","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=0&filter2=373&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1470,"customer_code":"C191470","identity_type":"BUSINESS","identity_id":"1850482","title":"Mr","lastname":"LAU","firstname":"Kevin","companyname":"STAR LIGHT R & D LTD","email":null,"tel":"34711355","address":"5\/F Shing Dao Industrial Building 232 Aberdeen Main Road Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-13","renew_room_key":"190,38711","renew_remark":"1 month contract. Storage rental and deposit paid by bank transfer on Dec 18,2019. Smartcard provided on Dec 13,2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196726, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1996.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"411","room_code":"I02","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":"2020-01-13","rent_from":"2020-01-13","rent_to":"2020-02-12","delivery_service":"0","remark":"1 month contract. Storage rental paid by cheque on Jan 13,2020. Deposit $1996 transferred from agreement A14-CT196726 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":998,"final_order_total":998,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190,38711","order_product":[],"pass":true}},"first_order_id":6726,"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> I02 <\/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":"2020-01-14 17:27:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",1470,"NEW","A14-CT206963",998,998,0,0,"1","1",998,998,998,"2020-01-14 17:27:37","0",null,null,null,"2020-01-13","2020-02-12","1 month contract. Storage rental paid by cheque on Jan 13,2020. Deposit $1996 transferred from agreement A14-CT196726 to this agreement.","2020-01-13","12",0,null,0,"0","2","2020-01-14 17:27:36","2","2020-01-14 17:27:36","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"190,38711","C191470","BUSINESS","Mr","Ya9A\/ywtlmJRIDhH4X4NUQ==","DQ14OHmVeYuzJuBkd+kFHg==","STAR LIGHT R & D LTD","RMk2HFaOIu\/0kDQ3httlkl+nHFgGwCElRnO8ppImjH9dsUITdobnSjeHnsPgiJryoZs+GAuWBjvP13vD90Vf+3FPtjDmCNz9Cr\/JxE\/6OFc=","jdhYGndgmFP0qhtFU\/MiJw==",null,null,"8oF8VHM1sampIinI0bkByg==",1,6726]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:27:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6963","411","998.0","998.00","2","2020-01-14 17:27:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:27:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-13","2020-02-12","411"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-14 17:27:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6963",1470,"SETTLED","A14-I207291","2020-01-14 17:27:36","2020-01-13","2","2020-01-14 17:27:36","2","2020-01-14 17:27:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:27:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7291","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-01-14 17:27:36","2","2020-01-14 17:27:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:27:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"7291"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-14 17:27:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1470,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P206940","2020-01-14 17:27:36",998,"2","2020-01-14 17:27:36","2","2020-01-14 17:27:36","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:27:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6940","DEPOSIT",null,"PAID","2020-01-14 17:27:36",0,"2","2020-01-14 17:27:36","2","2020-01-14 17:27:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:27:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6940","INVOICE","7291","PAID","2020-01-14 17:27:36",998,"2","2020-01-14 17:27:36","2","2020-01-14 17:27:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:35:33","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=0&filter2=373&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","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1470,"customer_code":"C191470","identity_type":"BUSINESS","identity_id":"1850482","title":"Mr","lastname":"LAU","firstname":"Kevin","companyname":"STAR LIGHT R & D LTD","email":null,"tel":"34711355","address":"5\/F Shing Dao Industrial Building 232 Aberdeen Main Road Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"7306.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-16","renew_room_key":"190,38711","renew_remark":"1 month contract. Storage rental and deposit of 14\/F office paid by bank transfer on Dec 18,2019. Smartcard provided on Dec 13,2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196727, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $14612.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"410","room_code":"I01","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":7306,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":7306,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-16","rent_from":"2020-01-16","rent_to":"2020-02-15","delivery_service":"0","remark":"1 month contract. Storage rental of 14\/F office paid by cheque on Jan 13,2020. Deposit $14612 transferred from agreement to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":7306,"final_order_total":7306,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190,38711","order_product":[],"pass":true}},"first_order_id":6727,"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> I01 <\/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":"7306.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:35:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",1470,"NEW","A14-CT206964",998,7306,0,0,"1","1",7306,7306,7306,"2020-01-14 17:35:34","0",null,null,null,"2020-01-16","2020-02-15","1 month contract. Storage rental of 14\/F office paid by cheque on Jan 13,2020. Deposit $14612 transferred from agreement to this agreement.","2020-01-16","12",0,null,0,"0","2","2020-01-14 17:35:33","2","2020-01-14 17:35:33","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"190,38711","C191470","BUSINESS","Mr","Ya9A\/ywtlmJRIDhH4X4NUQ==","DQ14OHmVeYuzJuBkd+kFHg==","STAR LIGHT R & D LTD","RMk2HFaOIu\/0kDQ3httlkl+nHFgGwCElRnO8ppImjH9dsUITdobnSjeHnsPgiJryoZs+GAuWBjvP13vD90Vf+3FPtjDmCNz9Cr\/JxE\/6OFc=","jdhYGndgmFP0qhtFU\/MiJw==",null,null,"8oF8VHM1sampIinI0bkByg==",1,6727]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:35:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6964","410","998.0","998.00","2","2020-01-14 17:35:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:35:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-16","2020-02-15","410"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-14 17:35:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6964",1470,"SETTLED","A14-I207292","2020-01-14 17:35:33","2020-01-16","2","2020-01-14 17:35:33","2","2020-01-14 17:35:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:35:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7292","RENT","\u9810\u7e73\u79df\u91d1",1,7306,"MO","1",7306,"2","2020-01-14 17:35:33","2","2020-01-14 17:35:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:35:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7306,0,"7292"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-14 17:35:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1470,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P206941","2020-01-14 17:35:33",7306,"2","2020-01-14 17:35:33","2","2020-01-14 17:35:33","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:35:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6941","DEPOSIT",null,"PAID","2020-01-14 17:35:33",0,"2","2020-01-14 17:35:33","2","2020-01-14 17:35:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 17:35:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6941","INVOICE","7292","PAID","2020-01-14 17:35:33",7306,"2","2020-01-14 17:35:33","2","2020-01-14 17:35:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 18:16:47","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=0&filter2=373&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","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":939,"customer_code":"C180939","identity_type":"PERSONAL","identity_id":"D189507(A)","title":"Mr","lastname":"Luk","firstname":" Kam Tong, Kenneth","companyname":"","email":"clip@live.hk","tel":"53678669","address":"Flat D, 14\/F, Green Valley Mansion, 51 Wong Nai Chung Road, Happy Valley, H.K.","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2330.0","renew_rent_month":"12","renew_warehousing_date":"2019-12-18","renew_room_key":"'0012459958","renew_remark":"12 months contract. Special promotion offered 5% extra discount ,2 month free of charge . Storage Rental $5469 and deposit $6076 transfer from agreement no. C15-CT182979 to this agreement. Remaining storage rental and deposit $19638 paid by Cheque on 17 Dec 2018.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT183912, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $3268.0","renew_master_room_id":"178","order_discount":[],"order_room":[{"room_id":"1481","room_code":"C15-175","retail_price":"1260.0","discounted_price":"1260.00","location_id":"6"},{"room_id":"1478","room_code":"C15-172","retail_price":"1798.0","discounted_price":"1798.00","location_id":"6"}],"roughly_size":"54","total_retail_price":3058,"total_discounted_price":2942,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":17652,"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 Jan 14,2020. Deposit $3268 transferred from agreement C15-CT183912 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":17652,"final_order_total":17652,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012459958","order_product":[],"pass":true}},"first_order_id":3912,"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> C15-175 <\/td>\r\n\t\t\t\t\t 5X4.5X6.5 <\/td>\r\n\t\t\t\t\t $1260.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> C15-172 <\/td>\r\n\t\t\t\t\t 4.5X7X6.5 <\/td>\r\n\t\t\t\t\t $1798.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":"54","total_discounted_price":"2942.00","deposit":"0.00","total_retail_price":"3058.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 18:16:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",939,"NEW","C15-CT206965",3058,2942,0,0,"6","6",17652,17652,17652,"2020-01-14 18:16:48","0",null,null,null,"2019-12-18","2020-06-17","6 months contract. Storage rental paid by bank transfer on Jan 14,2020. Deposit $3268 transferred from agreement C15-CT183912 to this agreement.","2019-12-18","54",0,null,0,"0","2","2020-01-14 18:16:47","2","2020-01-14 18:16:47","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0012459958","C180939","PERSONAL","Mr","2iuz43woGXm9zxI5hQCj81EWuN5tfTJ9tlitUzpe3h0=","IHUAk+wmQucha2u9xporqw==","","j+A5anaZw20Yx3EfcjcndeMoGyklbnHwqkjgWUNPGezZ5J\/pDTvz+vyNMe1QBQMuTiGipxLhd9CAFM69eeIKbv8OTmSpQTi8zc3A2DLiF70=","yVA0w8AbkLdKwsGAXFJeIA==","GEaIwe7ViZNO\/PO1MZANIw==","lzeP2FbcTvjvFK8CRDpooA==",null,1,3912]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 18:16:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6965","1481","1260.0","1260.00","2","2020-01-14 18:16:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 18:16:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-18","2020-06-17","1481"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-14 18:16:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6965","1478","1798.0","1798.00","2","2020-01-14 18:16:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 18:16:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-18","2020-06-17","1478"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-14 18:16:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6965",939,"SETTLED","C15-I207293","2020-01-14 18:16:47","2019-12-18","2","2020-01-14 18:16:47","2","2020-01-14 18:16:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 18:16:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7293","RENT","\u9810\u7e73\u79df\u91d1",1,2942,"MO","1",2942,"2","2020-01-14 18:16:47","2","2020-01-14 18:16:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 18:16:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7293","RENT","\u9810\u7e73\u79df\u91d1",2,2942,"MO","1",2942,"2","2020-01-14 18:16:47","2","2020-01-14 18:16:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 18:16:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7293","RENT","\u9810\u7e73\u79df\u91d1",3,2942,"MO","1",2942,"2","2020-01-14 18:16:47","2","2020-01-14 18:16:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 18:16:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7293","RENT","\u9810\u7e73\u79df\u91d1",4,2942,"MO","1",2942,"2","2020-01-14 18:16:47","2","2020-01-14 18:16:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 18:16:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7293","RENT","\u9810\u7e73\u79df\u91d1",5,2942,"MO","1",2942,"2","2020-01-14 18:16:47","2","2020-01-14 18:16:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 18:16:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7293","RENT","\u9810\u7e73\u79df\u91d1",6,2942,"MO","1",2942,"2","2020-01-14 18:16:47","2","2020-01-14 18:16:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 18:16:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[17652,0,"7293"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-14 18:16:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[939,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206942","2020-01-14 18:16:47",17652,"2","2020-01-14 18:16:47","2","2020-01-14 18:16:47","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 18:16:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6942","DEPOSIT",null,"PAID","2020-01-14 18:16:47",0,"2","2020-01-14 18:16:47","2","2020-01-14 18:16:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-14 18:16:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6942","INVOICE","7293","PAID","2020-01-14 18:16:47",17652,"2","2020-01-14 18:16:47","2","2020-01-14 18:16:47"]},"data_before":[],"data_after":[],"step":1} *****