{"created_at":"2020-02-18 10:18:45","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 10:35:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 10:56:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 11:03:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 11:54:10","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=1427&filter3=undefined","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1102","master_room_id":"112","room_code":"A05-100"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":500,"customer_code":"C170500","identity_type":"PERSONAL","identity_id":"D253627(8)","title":"Mr","lastname":"Lo","firstname":"Ka Wo Athan","companyname":"","email":"jh138@163.com","tel":"62098098","address":"FT 1 ,31\/F, Hung Lai House,Hung Fuk Court,Aberdeen,HK","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"6","renew_warehousing_date":"2019-12-27","renew_room_key":"054,47831","renew_remark":"6 months contract. Storage rental paid by cash on Aug 16, 2019. Storage deposit transferred from agreement A14-CT194304 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195727, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"560","room_code":"L38","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":935,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5610,"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-06-26","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on February 18, 2020. Storage deposit transferred from agreement A14-CT195727 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5610,"final_order_total":5610,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,47831","order_product":[],"pass":true}},"first_order_id":"4304","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>
L38 <\/td>\r\n\t\t\t\t\t	4X4X8 <\/td>\r\n\t\t\t\t\t	$1098.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"935.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 11:54:10","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",500,"NEW","A14-CT207213",1098,935,0,0,"6","6",5610,5610,5610,"2020-02-18 11:54:10","0",null,null,null,"2019-12-27","2020-06-26","6 months contract. Storage rental paid by bank transfer on February 18, 2020. Storage deposit transferred from agreement A14-CT195727 to this agreement.\r\n","2019-12-27","16",0,null,0,"0","2","2020-02-18 11:54:10","2","2020-02-18 11:54:10","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,47831","C170500","PERSONAL","Mr","wBfWBonFMjsvxfAggU5\/UQ==","4w4biS+jM\/Q3DAzxHdf3pA==","","M3VNEk3wL8Ojs59RRrb6hL1rUPnJOOIVvIMoWALW4pyIrQelE6UyhGISxl6ivJ66OHzTP+nrhjG90\/q1NDaekg==","H66uZhUvNsTCV4dDoXv8iw==","4HFUj6p9LFocK\/F9HEOqqQ==","HAFhDQ3vSoblWDKP7ve00Q==",null,1,"4304"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 11:54:10","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":["7213","560","1098.0","1098.00","2","2020-02-18 11:54:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 11:54:10","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-06-26","560"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-18 11:54:10","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":["7213",500,"SETTLED","A14-I207541","2020-02-18 11:54:10","2019-12-27","2","2020-02-18 11:54:10","2","2020-02-18 11:54:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 11:54:10","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":["7541","RENT","\u9810\u7e73\u79df\u91d1",1,935,"MO","1",935,"2","2020-02-18 11:54:10","2","2020-02-18 11:54:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 11:54:10","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":["7541","RENT","\u9810\u7e73\u79df\u91d1",2,935,"MO","1",935,"2","2020-02-18 11:54:10","2","2020-02-18 11:54:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 11:54:10","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":["7541","RENT","\u9810\u7e73\u79df\u91d1",3,935,"MO","1",935,"2","2020-02-18 11:54:10","2","2020-02-18 11:54:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 11:54:10","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":["7541","RENT","\u9810\u7e73\u79df\u91d1",4,935,"MO","1",935,"2","2020-02-18 11:54:10","2","2020-02-18 11:54:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 11:54:10","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":["7541","RENT","\u9810\u7e73\u79df\u91d1",5,935,"MO","1",935,"2","2020-02-18 11:54:10","2","2020-02-18 11:54:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 11:54:10","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":["7541","RENT","\u9810\u7e73\u79df\u91d1",6,935,"MO","1",935,"2","2020-02-18 11:54:10","2","2020-02-18 11:54:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 11:54:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5610,0,"7541"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-18 11:54:10","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":[500,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207189","2020-02-18 11:54:10",5610,"2","2020-02-18 11:54:10","2","2020-02-18 11:54:10","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 11:54:10","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":["7189","DEPOSIT",null,"PAID","2020-02-18 11:54:10",0,"2","2020-02-18 11:54:10","2","2020-02-18 11:54:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 11:54:10","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":["7189","INVOICE","7541","PAID","2020-02-18 11:54:10",5610,"2","2020-02-18 11:54:10","2","2020-02-18 11:54:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 12:01:46","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=1427&filter3=undefined&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1102","master_room_id":"112","room_code":"A05-100"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":747,"customer_code":"C180747","identity_type":"PERSONAL","identity_id":"E468901(5)","title":"Ms","lastname":"Tang","firstname":"Yuet Ha","companyname":"","email":"feederems@yahoo.com","tel":"97877843","address":"Flat A, 24\/F, Tower 3, Marina Habitat, Ap Lei Chau, HK","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1445.0","renew_rent_month":"12","renew_warehousing_date":"2020-02-24","renew_room_key":"055,02422","renew_remark":"12 months contract. change from unit V27 to V17. Storage rental $10601 and deposit $4116 transferred from agreement A18-CT194359 to this agreement. Remaining storage rental and deposit (ttl:$5833) paid by EPS on February 21, 2019. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT194420, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $3210.0","renew_master_room_id":"78","order_discount":[],"order_room":[{"room_id":"943","room_code":"V17","retail_price":"1605.0","discounted_price":"1605.00","location_id":"3"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1445,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":17340,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1445.00","warehousing_date":"2020-02-24","rent_from":"2020-02-24","rent_to":"2021-03-23","delivery_service":"0","remark":"13 months contract. Special offer 13th month free. Storage rental paid by EPS on February 18, 2020. Storage deposit $3210 transferred from agreement A18-CT194420 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":1445,"order_total":18785,"final_order_total":17340,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,02422","order_product":[],"pass":true}},"first_order_id":4420,"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> V17 <\/td>\r\n\t\t\t\t\t 4X5X7 <\/td>\r\n\t\t\t\t\t $1605.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1445.00","deposit":"0.00","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 12:01:46","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",747,"NEW","A18-CT207214",1605,1445,0,0,"13","13",17340,18785,17340,"2020-02-18 12:01:46","0",null,null,null,"2020-02-24","2021-03-23","13 months contract. Special offer 13th month free. Storage rental paid by EPS on February 18, 2020. Storage deposit $3210 transferred from agreement A18-CT194420 to this agreement. ","2020-02-24","20",0,null,1445,"1445.00","2","2020-02-18 12:01:46","2","2020-02-18 12:01:46","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"055,02422","C180747","PERSONAL","Ms","ZaxygZpDICMlWoLPFlr2SQ==","M7CfcmE2OSMlZOkNgaoDmQ==","","7WKVWkce3+lok9\/bOxlk+\/KvGqx9nOwE+nipg\/2xOnLGdosVyw3pyIJU8EH89fd11Q9bYxkMAmcwxTgku\/JPsw==","bmmPj4VyUZ3jH6dibjVeNg==","rxTeBMr5MzGfxwx+TFzBDm8YEcxzfAGqa5LR8Lcf0Bg=","vWNkwX41gb0vKkC8CZu+4w==",null,1,4420]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 12:01:46","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":["7214","943","1605.0","1605.00","2","2020-02-18 12:01:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 12:01:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-24","2021-03-23","943"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-18 12:01:46","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":["7214",747,"SETTLED","A18-I207542","2020-02-18 12:01:46","2020-02-24","2","2020-02-18 12:01:46","2","2020-02-18 12:01:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 12:01:46","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":["7542","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1445,"MO","1",1445,"2","2020-02-18 12:01:46","2","2020-02-18 12:01:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 12:01:46","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":["7542","RENT","\u9810\u7e73\u79df\u91d1",3,1445,"MO","1",1445,"2","2020-02-18 12:01:46","2","2020-02-18 12:01:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 12:01:46","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":["7542","RENT","\u9810\u7e73\u79df\u91d1",4,1445,"MO","1",1445,"2","2020-02-18 12:01:46","2","2020-02-18 12:01:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 12:01:46","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":["7542","RENT","\u9810\u7e73\u79df\u91d1",5,1445,"MO","1",1445,"2","2020-02-18 12:01:46","2","2020-02-18 12:01:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 12:01:46","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":["7542","RENT","\u9810\u7e73\u79df\u91d1",6,1445,"MO","1",1445,"2","2020-02-18 12:01:46","2","2020-02-18 12:01:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 12:01:46","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":["7542","RENT","\u9810\u7e73\u79df\u91d1",7,1445,"MO","1",1445,"2","2020-02-18 12:01:46","2","2020-02-18 12:01:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 12:01:46","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":["7542","RENT","\u9810\u7e73\u79df\u91d1",8,1445,"MO","1",1445,"2","2020-02-18 12:01:46","2","2020-02-18 12:01:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 12:01:46","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":["7542","RENT","\u9810\u7e73\u79df\u91d1",9,1445,"MO","1",1445,"2","2020-02-18 12:01:46","2","2020-02-18 12:01:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 12:01:46","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":["7542","RENT","\u9810\u7e73\u79df\u91d1",10,1445,"MO","1",1445,"2","2020-02-18 12:01:46","2","2020-02-18 12:01:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 12:01:46","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":["7542","RENT","\u9810\u7e73\u79df\u91d1",11,1445,"MO","1",1445,"2","2020-02-18 12:01:46","2","2020-02-18 12:01:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 12:01:46","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":["7542","RENT","\u9810\u7e73\u79df\u91d1",12,1445,"MO","1",1445,"2","2020-02-18 12:01:46","2","2020-02-18 12:01:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 12:01:46","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":["7542","RENT","\u9810\u7e73\u79df\u91d1",13,1445,"MO","1",1445,"2","2020-02-18 12:01:46","2","2020-02-18 12:01:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 12:01:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[17340,0,"7542"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-18 12:01:46","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":[747,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207190","2020-02-18 12:01:46",17340,"2","2020-02-18 12:01:46","2","2020-02-18 12:01:46","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 12:01:46","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":["7190","DEPOSIT",null,"PAID","2020-02-18 12:01:46",0,"2","2020-02-18 12:01:46","2","2020-02-18 12:01:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 12:01:46","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":["7190","INVOICE","7542","PAID","2020-02-18 12:01:46",17340,"2","2020-02-18 12:01:46","2","2020-02-18 12:01:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:09:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:27:37","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=1000&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":[{"room_id":"1102","master_room_id":"112","room_code":"A05-100"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1261,"customer_code":"C191261","identity_type":"PERSONAL","identity_id":"G285177(5)","title":"Mr","lastname":"Lee","firstname":"Pak Ho","companyname":"","email":null,"tel":"62037746","address":"Room 2510, Lei Fook House, Lower Block, Apleichau Estate, Ap Lei Chau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1098.0","renew_rent_month":"3","renew_warehousing_date":"2019-12-04","renew_room_key":"076,58156","renew_remark":"3 months contract. Storage rental ($1098\/mth) paid by bank transfer on Nov 10th, 12th and Dec 06,2019. Storage deposit $2196 transferred from agreement A14-CT195878 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196621, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[{"master_room_discount_id":"434","master_room_id":"35","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"742","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"742","room_code":"O18","retail_price":"1098.0","discounted_price":1043.4,"location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1098,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3294,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-04","rent_from":"2019-12-04","rent_to":"2020-03-03","delivery_service":"0","remark":"3 months contract. Storage rental $2000 paid by cash on February 10, 2020. Remaining balance $1294 on February 16, 2020. Storage deposit $2196 transferred from agreement A14-CT196621 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3294,"final_order_total":3294,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,58156","order_product":[],"pass":true}},"first_order_id":"4872","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> O18 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1098.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:27:38","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",1261,"NEW","A14-CT207215",1098,1098,0,0,"3","3",3294,3294,3294,"2020-02-18 15:27:38","0",null,null,null,"2019-12-04","2020-03-03","3 months contract. Storage rental $2000 paid by cash on February 10, 2020. Remaining balance $1294 on February 16, 2020. Storage deposit $2196 transferred from agreement A14-CT196621 to this agreement.\r\n","2019-12-04","16",0,null,0,"0","2","2020-02-18 15:27:37","2","2020-02-18 15:27:37","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,58156","C191261","PERSONAL","Mr","l497mGOiMNQGidT3z5xzAA==","kiriEIqhcx866RNZiMXdKQ==","","qHi3rsy91wJafe8aQmSjkmxOhUk0X6aK9VcTSc7yi\/AmaNRZB7kJOc\/zHJ5gm+eKW\/g5fEQeq8RrqyNpSUg9Gp\/65DlaMHcBxxfKpNEtdiupU2zfVkpLoVZKNjzC+yhw","JmEgNMwRplOvZMflhfIdgw==",null,"itGnrdkuMhaVMvNK+jHZew==",null,1,"4872"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:27:38","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":["7215","434","35","742","%","4.97",54.5706,"2","2020-02-18 15:27:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:27:38","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":["7215","742","1098.0",1043.4,"2","2020-02-18 15:27:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:27:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-04","2020-03-03","742"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-18 15:27:38","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":["7215",1261,"SETTLED","A14-I207543","2020-02-18 15:27:37","2019-12-04","2","2020-02-18 15:27:37","2","2020-02-18 15:27:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:27:38","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":["7543","RENT","\u9810\u7e73\u79df\u91d1",1,1098,"MO","1",1098,"2","2020-02-18 15:27:37","2","2020-02-18 15:27:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:27:38","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":["7543","RENT","\u9810\u7e73\u79df\u91d1",2,1098,"MO","1",1098,"2","2020-02-18 15:27:37","2","2020-02-18 15:27:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:27:38","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":["7543","RENT","\u9810\u7e73\u79df\u91d1",3,1098,"MO","1",1098,"2","2020-02-18 15:27:37","2","2020-02-18 15:27:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:27:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3294,0,"7543"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-18 15:27:38","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":[1261,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207191","2020-02-18 15:27:37",3294,"2","2020-02-18 15:27:37","2","2020-02-18 15:27:37","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:27:38","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":["7191","DEPOSIT",null,"PAID","2020-02-18 15:27:37",0,"2","2020-02-18 15:27:37","2","2020-02-18 15:27:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:27:38","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":["7191","INVOICE","7543","PAID","2020-02-18 15:27:37",3294,"2","2020-02-18 15:27:37","2","2020-02-18 15:27:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:30:35","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=1000&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":[{"room_id":"1102","master_room_id":"112","room_code":"A05-100"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1261,"customer_code":"C191261","identity_type":"PERSONAL","identity_id":"G285177(5)","title":"Mr","lastname":"Lee","firstname":"Pak Ho","companyname":"","email":null,"tel":"62037746","address":"Room 2510, Lei Fook House, Lower Block, Apleichau Estate, Ap Lei Chau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1098.0","renew_rent_month":"2","renew_warehousing_date":"2019-12-06","renew_room_key":"076,58156","renew_remark":"2 months contract. Storage rental paid by bank transfer on Nov 10th,12th and Dec 6th,2019. Storage deposit transferred from agreement A14-CT196222 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196622, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[{"master_room_discount_id":"434","master_room_id":"35","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"759","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"759","room_code":"O35","retail_price":"1098.0","discounted_price":1043.4,"location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1098,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3294,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-06","rent_from":"2019-12-06","rent_to":"2020-03-05","delivery_service":"0","remark":"3 months contract. Storage rental $2588 paid by PPS on February 17, 2020. Remaining balance $706 paid by cash on February 10, 2020. Storage deposit transferred from agreement A14-CT196622 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3294,"final_order_total":3294,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,58156","order_product":[],"pass":true}},"first_order_id":"3630","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> O35 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1098.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:30:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",1261,"NEW","A14-CT207216",1098,1098,0,0,"3","3",3294,3294,3294,"2020-02-18 15:30:36","0",null,null,null,"2019-12-06","2020-03-05","3 months contract. Storage rental $2588 paid by PPS on February 17, 2020. Remaining balance $706 paid by cash on February 10, 2020. Storage deposit transferred from agreement A14-CT196622 to this agreement.\r\n","2019-12-06","16",0,null,0,"0","2","2020-02-18 15:30:35","2","2020-02-18 15:30:35","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,58156","C191261","PERSONAL","Mr","l497mGOiMNQGidT3z5xzAA==","kiriEIqhcx866RNZiMXdKQ==","","qHi3rsy91wJafe8aQmSjkmxOhUk0X6aK9VcTSc7yi\/AmaNRZB7kJOc\/zHJ5gm+eKW\/g5fEQeq8RrqyNpSUg9Gp\/65DlaMHcBxxfKpNEtdiupU2zfVkpLoVZKNjzC+yhw","JmEgNMwRplOvZMflhfIdgw==",null,"itGnrdkuMhaVMvNK+jHZew==",null,1,"3630"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:30:36","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":["7216","434","35","759","%","4.97",54.5706,"2","2020-02-18 15:30:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:30:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7216","759","1098.0",1043.4,"2","2020-02-18 15:30:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:30:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-06","2020-03-05","759"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-18 15:30:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7216",1261,"SETTLED","A14-I207544","2020-02-18 15:30:35","2019-12-06","2","2020-02-18 15:30:35","2","2020-02-18 15:30:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:30:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7544","RENT","\u9810\u7e73\u79df\u91d1",1,1098,"MO","1",1098,"2","2020-02-18 15:30:35","2","2020-02-18 15:30:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:30:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7544","RENT","\u9810\u7e73\u79df\u91d1",2,1098,"MO","1",1098,"2","2020-02-18 15:30:35","2","2020-02-18 15:30:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:30:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7544","RENT","\u9810\u7e73\u79df\u91d1",3,1098,"MO","1",1098,"2","2020-02-18 15:30:35","2","2020-02-18 15:30:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:30:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3294,0,"7544"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-18 15:30:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1261,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207192","2020-02-18 15:30:35",3294,"2","2020-02-18 15:30:35","2","2020-02-18 15:30:35","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:30:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7192","DEPOSIT",null,"PAID","2020-02-18 15:30:35",0,"2","2020-02-18 15:30:35","2","2020-02-18 15:30:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:30:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7192","INVOICE","7544","PAID","2020-02-18 15:30:35",3294,"2","2020-02-18 15:30:35","2","2020-02-18 15:30:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:34:46","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=1000&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1102","master_room_id":"112","room_code":"A05-100"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1425,"customer_code":"C191425","identity_type":"BUSINESS","identity_id":"2519978","title":"Mr","lastname":"Wong ","firstname":"Man Cheung","companyname":"Serene Capital Limited","email":"philipwong@certproperty.co.uk","tel":"90941892","address":"16A, 16\/F Chung Hing Commercial Building, 62 Connaught Road Central, Central, H.K.","pass":true},"2":{"renew_paymethod2":"OTHER","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"2","renew_warehousing_date":"2020-02-17","renew_room_key":"0012450069","renew_remark":"2 months contract. Storage rental paid by WeChat Pay on December 17, 2019. Storage deposit $1196 transferred from agreement A12-CT196162 to this agreement. **$18 charge for WeChat Pay.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196723, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"1","order_discount":[],"order_room":[{"room_id":"213","room_code":"D17","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-17","rent_from":"2020-02-17","rent_to":"2020-03-16","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on February 17, 2020. Storage deposit $1196 transferred from agreement A12-CT196723 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"1","branch_id":"1","company_id":"1","room_key":"0012450069","order_product":[],"pass":true}},"first_order_id":"3347","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> D17 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:34:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",1425,"NEW","A12-CT207217",598,598,0,0,"1","1",598,598,598,"2020-02-18 15:34:47","0",null,null,null,"2020-02-17","2020-03-16","1 month contract. Storage rental paid by PPS on February 17, 2020. Storage deposit $1196 transferred from agreement A12-CT196723 to this agreement. \r\n","2020-02-17","12",0,null,0,"0","2","2020-02-18 15:34:46","2","2020-02-18 15:34:46","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0012450069","C191425","BUSINESS","Mr","G+w65JkR7AS+JT7hCDD+yg==","DgLsCGM4faTvgwjKBW9M0A==","Serene Capital Limited","S4o9AXA7eRky9fl+GI6ii2+TMoCmBDuByzpKzUF7jpxGD0QmypETmhNR0PVTCj612a7mYANU+Sc3i0encOiszMwjCriyODNCJhdNRzJhCfKfqggF6Ry9Getc\/0LKYKRN","CL6e4EkMiRzRr0Rve85mrw==","eLkWayCc4RkCZg6CrTQmBSr+4xmx9fTzOhnQ35wQOzA=",null,"JdjeYwtWISTCzDjjVIKzVw==",1,"3347"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:34:47","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":["7217","213","598.0","598.00","2","2020-02-18 15:34:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:34:47","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-17","2020-03-16","213"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-18 15:34:47","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":["7217",1425,"SETTLED","A12-I207545","2020-02-18 15:34:46","2020-02-17","2","2020-02-18 15:34:46","2","2020-02-18 15:34:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:34:47","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":["7545","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-02-18 15:34:46","2","2020-02-18 15:34:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:34:47","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7545"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-18 15:34:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1425,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207193","2020-02-18 15:34:46",598,"2","2020-02-18 15:34:46","2","2020-02-18 15:34:46","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:34:47","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":["7193","DEPOSIT",null,"PAID","2020-02-18 15:34:46",0,"2","2020-02-18 15:34:46","2","2020-02-18 15:34:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:34:47","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":["7193","INVOICE","7545","PAID","2020-02-18 15:34:46",598,"2","2020-02-18 15:34:46","2","2020-02-18 15:34:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:37:09","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=1000&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1102","master_room_id":"112","room_code":"A05-100"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":290,"customer_code":"C170290","identity_type":"PERSONAL","identity_id":"G683435(2)","title":"Mr","lastname":"Cheung","firstname":"Sai Yiu","companyname":"","email":"leosycheung@netvigator.com","tel":"91036345","address":"Flat C, 6\/F, Tower 10, Grand Yoho, 9 Long Yat Road, Yuen Long, NT, HK ","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1887.0","renew_rent_month":"3","renew_warehousing_date":"2020-02-25","renew_room_key":"55, 24359","renew_remark":"3 months contract. Storage rental paid by PPS on November 20, 2019. Storage deposit transferred from agreement A12-CT195797 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196473, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"433","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"181","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"433","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"192","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"192","room_code":"C68","retail_price":"1098.0","discounted_price":1043.4,"location_id":"1"},{"room_id":"181","room_code":"C57","retail_price":"1098.0","discounted_price":1043.4,"location_id":"1"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":1887,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":5661,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-25","rent_from":"2020-02-25","rent_to":"2020-05-24","delivery_service":"0","remark":"3 months contract. Storage rental paid by PPS on February 17, 2020. Storage deposit transferred from agreement A12-CT196473 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":5661,"final_order_total":5661,"location_id":"1","branch_id":"1","company_id":"1","room_key":"55, 24359","order_product":[],"pass":true}},"first_order_id":"4390","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> C68 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> C57 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"1887.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:37:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",290,"NEW","A12-CT207218",2196,1887,0,0,"3","3",5661,5661,5661,"2020-02-18 15:37:09","0",null,null,null,"2020-02-25","2020-05-24","3 months contract. Storage rental paid by PPS on February 17, 2020. Storage deposit transferred from agreement A12-CT196473 to this agreement.\r\n","2020-02-25","32",0,null,0,"0","2","2020-02-18 15:37:09","2","2020-02-18 15:37:09","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"55, 24359","C170290","PERSONAL","Mr","+m7AdbAN1WsKKht+JZSaJQ==","vCxOlXQuvOQaoL822H2o\/Q==","","s+tdPbtKddtBtaV3zBKye3ZjQJ7CcLDLDIJHNmyA3JVftU9z8jrwQnOn6FuueVLQKrD1BpmxJy4f2jCIZcnJPHAqeaRmkIGjM0yLlH88xw8=","+RHeMCJYuOZuC8aAQkm2jA==","47sg70e8qTY4uR2FyNDr867LMn2R3L2cH5c2x6+7VfY=","kd+EYnRfPcJ\/+u7iwjgo4w==",null,1,"4390"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:37:09","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":["7218","433","8","181","%","4.97",54.5706,"2","2020-02-18 15:37:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:37:09","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":["7218","433","8","192","%","4.97",54.5706,"2","2020-02-18 15:37:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:37:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7218","192","1098.0",1043.4,"2","2020-02-18 15:37:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:37:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-25","2020-05-24","192"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-18 15:37:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7218","181","1098.0",1043.4,"2","2020-02-18 15:37:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:37:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-25","2020-05-24","181"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-18 15:37:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7218",290,"SETTLED","A12-I207546","2020-02-18 15:37:09","2020-02-25","2","2020-02-18 15:37:09","2","2020-02-18 15:37:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:37:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7546","RENT","\u9810\u7e73\u79df\u91d1",1,1887,"MO","1",1887,"2","2020-02-18 15:37:09","2","2020-02-18 15:37:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:37:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7546","RENT","\u9810\u7e73\u79df\u91d1",2,1887,"MO","1",1887,"2","2020-02-18 15:37:09","2","2020-02-18 15:37:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:37:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7546","RENT","\u9810\u7e73\u79df\u91d1",3,1887,"MO","1",1887,"2","2020-02-18 15:37:09","2","2020-02-18 15:37:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:37:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5661,0,"7546"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-18 15:37:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[290,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207194","2020-02-18 15:37:09",5661,"2","2020-02-18 15:37:09","2","2020-02-18 15:37:09","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:37:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7194","DEPOSIT",null,"PAID","2020-02-18 15:37:09",0,"2","2020-02-18 15:37:09","2","2020-02-18 15:37:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:37:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7194","INVOICE","7546","PAID","2020-02-18 15:37:09",5661,"2","2020-02-18 15:37:09","2","2020-02-18 15:37:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:39:16","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=1000&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1102","master_room_id":"112","room_code":"A05-100"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":888,"customer_code":"C180888","identity_type":"PERSONAL","identity_id":"K099955(5)","title":"Ms","lastname":"Ho","firstname":"Man Yee Cherie","companyname":"","email":"cheriehmy@gmail.com","tel":"90575456","address":"Flat A, 1\/F, Block 9, Fullview Garden, 18 Siu Sai Wan Road, Siu Sai Wan, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1112.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-27","renew_room_key":"0005763937","renew_remark":"1 month contract. Storage rental paid by PPS on January 20, 2020. Storage deposit $2224 transferred from agreement B01-CT206839 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT207012, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"140","order_discount":[],"order_room":[{"room_id":"1237","room_code":"B01-047","retail_price":"1112.0","discounted_price":"1112.00","location_id":"5"}],"roughly_size":"16","total_retail_price":1112,"total_discounted_price":1112,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1112,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-27","rent_from":"2020-02-27","rent_to":"2020-03-26","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on February 17, 2020. Storage deposit $2224 transferred from agreement B01-CT207012 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1112,"final_order_total":1112,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0005763937","order_product":[],"pass":true}},"first_order_id":"4003","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> B01-047 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1112.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1112.0","deposit":"0","total_retail_price":"1112.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:39:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","2","5",888,"NEW","B01-CT207219",1112,1112,0,0,"1","1",1112,1112,1112,"2020-02-18 15:39:16","0",null,null,null,"2020-02-27","2020-03-26","1 month contract. Storage rental paid by PPS on February 17, 2020. Storage deposit $2224 transferred from agreement B01-CT207012 to this agreement.\r\n","2020-02-27","16",0,null,0,"0","2","2020-02-18 15:39:16","2","2020-02-18 15:39:16","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0005763937","C180888","PERSONAL","Ms","B6XcmzmDA9cWki+qLStEaA==","D\/skxQ5s\/L5yyRWaDK\/iSg==","","zb+wEJU2BcjiqagYCnyRNQzS3jTcz1KQCkGgLWtY\/y+C8KU+srfsdCNTrRUrjSHTpRbkV0JFumXQh3K4klaHUNKIaPzoQH6Ro1qQAUtDwWHyil1VPuPOWLDOdLKNt30K","Mv9sZMBZUVgbHGVZIxyZfQ==","d8Ms1Ternr8fasYV7yyV8x0bubUdhthIhbdOyphH3tQ=","b0wVwk81Vh1dF13X\/TkOaw==",null,1,"4003"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:39:16","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":["7219","1237","1112.0","1112.00","2","2020-02-18 15:39:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:39:16","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-27","2020-03-26","1237"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-18 15:39:16","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":["7219",888,"SETTLED","B01-I207547","2020-02-18 15:39:16","2020-02-27","2","2020-02-18 15:39:16","2","2020-02-18 15:39:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:39:16","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":["7547","RENT","\u9810\u7e73\u79df\u91d1",1,1112,"MO","1",1112,"2","2020-02-18 15:39:16","2","2020-02-18 15:39:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:39:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1112,0,"7547"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-18 15:39:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[888,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207195","2020-02-18 15:39:16",1112,"2","2020-02-18 15:39:16","2","2020-02-18 15:39:16","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:39:16","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":["7195","DEPOSIT",null,"PAID","2020-02-18 15:39:16",0,"2","2020-02-18 15:39:16","2","2020-02-18 15:39:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:39:16","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":["7195","INVOICE","7547","PAID","2020-02-18 15:39:16",1112,"2","2020-02-18 15:39:16","2","2020-02-18 15:39:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:47: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=2&filter2=1000&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1102","master_room_id":"112","room_code":"A05-100"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":332,"customer_code":"C170332","identity_type":"PERSONAL","identity_id":"Z619206(9)","title":"Ms","lastname":"Yu","firstname":"Tsui Ha","companyname":"","email":null,"tel":"92153768","address":"Rm 3122 ,Tung Hing Hse, Lei Tung Est ","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4074.0","renew_rent_month":"6","renew_warehousing_date":"2019-12-11","renew_room_key":"056,01969\/054,50297\/136,39278","renew_remark":"6 months contract. Storage rental paid by PPS on June 30, 2019. Storage deposit transferred from agreement A14-CT194311 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195298, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"44","order_discount":[],"order_room":[{"room_id":"790","room_code":"P24","retail_price":"1768.0","discounted_price":"1768.00","location_id":"2"},{"room_id":"789","room_code":"P23","retail_price":"1768.0","discounted_price":"1768.00","location_id":"2"},{"room_id":"788","room_code":"P22","retail_price":"1768.0","discounted_price":"1768.00","location_id":"2"}],"roughly_size":"72","total_retail_price":5304,"total_discounted_price":4074,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":48888,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-11","rent_from":"2019-12-11","rent_to":"2020-12-10","delivery_service":"0","remark":"12 months contract. Special offer $300 Maxim's voucher. Storage rental paid by PPS on February 17, 2020. Storage deposit transferred from agreement A14-CT195298 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":48888,"final_order_total":48888,"location_id":"2","branch_id":"1","company_id":"1","room_key":"056,01969\/054,50297\/136,39278","order_product":[],"pass":true}},"first_order_id":"4311","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 \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> P24 <\/td>\r\n\t\t\t\t\t 4X6X8 <\/td>\r\n\t\t\t\t\t $1768.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> P23 <\/td>\r\n\t\t\t\t\t 4X6X8 <\/td>\r\n\t\t\t\t\t $1768.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> P22 <\/td>\r\n\t\t\t\t\t 4X6X8 <\/td>\r\n\t\t\t\t\t $1768.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"72","total_discounted_price":"4074.00","deposit":"0.00","total_retail_price":"5304.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:47:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",332,"NEW","A14-CT207220",5304,4074,0,0,"12","12",48888,48888,48888,"2020-02-18 15:47:48","0",null,null,null,"2019-12-11","2020-12-10","12 months contract. Special offer $300 Maxim's voucher. Storage rental paid by PPS on February 17, 2020. Storage deposit transferred from agreement A14-CT195298 to this agreement.\r\n","2019-12-11","72",0,null,0,"0","2","2020-02-18 15:47:47","2","2020-02-18 15:47:47","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"056,01969\/054,50297\/136,39278","C170332","PERSONAL","Ms","\/ZlnrrWgpen7zUAgYYQhAw==","thtRZ5CDeQ9OOuodTdr1ng==","","9RyhEwQ\/vQdGbbE4uEasZ7+UVSLD2li3\/pv4hHPaTiMwzV5MxMn\/aWc80iWO4+TL","e4xWqTyidJ9wZ0dGddQU4Q==",null,"0NkipAEbfchAB1+CotBvEg==",null,1,"4311"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:47: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":["7220","790","1768.0","1768.00","2","2020-02-18 15:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:47: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-11","2020-12-10","790"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-18 15:47: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":["7220","789","1768.0","1768.00","2","2020-02-18 15:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:47: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-11","2020-12-10","789"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-18 15:47: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":["7220","788","1768.0","1768.00","2","2020-02-18 15:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:47: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-11","2020-12-10","788"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-18 15:47: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":["7220",332,"SETTLED","A14-I207548","2020-02-18 15:47:47","2019-12-11","2","2020-02-18 15:47:47","2","2020-02-18 15:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:47: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":["7548","RENT","\u9810\u7e73\u79df\u91d1",1,4074,"MO","1",4074,"2","2020-02-18 15:47:47","2","2020-02-18 15:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:47: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":["7548","RENT","\u9810\u7e73\u79df\u91d1",2,4074,"MO","1",4074,"2","2020-02-18 15:47:47","2","2020-02-18 15:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:47: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":["7548","RENT","\u9810\u7e73\u79df\u91d1",3,4074,"MO","1",4074,"2","2020-02-18 15:47:47","2","2020-02-18 15:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:47: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":["7548","RENT","\u9810\u7e73\u79df\u91d1",4,4074,"MO","1",4074,"2","2020-02-18 15:47:47","2","2020-02-18 15:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:47: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":["7548","RENT","\u9810\u7e73\u79df\u91d1",5,4074,"MO","1",4074,"2","2020-02-18 15:47:47","2","2020-02-18 15:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:47: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":["7548","RENT","\u9810\u7e73\u79df\u91d1",6,4074,"MO","1",4074,"2","2020-02-18 15:47:47","2","2020-02-18 15:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:47: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":["7548","RENT","\u9810\u7e73\u79df\u91d1",7,4074,"MO","1",4074,"2","2020-02-18 15:47:47","2","2020-02-18 15:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:47: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":["7548","RENT","\u9810\u7e73\u79df\u91d1",8,4074,"MO","1",4074,"2","2020-02-18 15:47:47","2","2020-02-18 15:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:47: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":["7548","RENT","\u9810\u7e73\u79df\u91d1",9,4074,"MO","1",4074,"2","2020-02-18 15:47:47","2","2020-02-18 15:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:47: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":["7548","RENT","\u9810\u7e73\u79df\u91d1",10,4074,"MO","1",4074,"2","2020-02-18 15:47:47","2","2020-02-18 15:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:47: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":["7548","RENT","\u9810\u7e73\u79df\u91d1",11,4074,"MO","1",4074,"2","2020-02-18 15:47:47","2","2020-02-18 15:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:47: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":["7548","RENT","\u9810\u7e73\u79df\u91d1",12,4074,"MO","1",4074,"2","2020-02-18 15:47:47","2","2020-02-18 15:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:47:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[48888,0,"7548"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-18 15:47: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":[332,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207196","2020-02-18 15:47:47",48888,"2","2020-02-18 15:47:47","2","2020-02-18 15:47:47","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:47: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":["7196","DEPOSIT",null,"PAID","2020-02-18 15:47:47",0,"2","2020-02-18 15:47:47","2","2020-02-18 15:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:47: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":["7196","INVOICE","7548","PAID","2020-02-18 15:47:47",48888,"2","2020-02-18 15:47:47","2","2020-02-18 15:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:55:39","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=1000&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1102","master_room_id":"112","room_code":"A05-100"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1213,"customer_code":"C191213","identity_type":"PERSONAL","identity_id":"D675154(8)","title":"Mr","lastname":"Lai","firstname":"Chi Leung","companyname":"","email":"stncllai@gmail.com","tel":"90909262","address":"Flat F, 16\/F, Block 2, Marina Habitat, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2058.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-15","renew_room_key":"076,29311","renew_remark":"1 months contract. Storage rental paid by bank transfer on January 7, 2020. Storage deposit $2058 transferred from agreement A14-CT196577 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT206898, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"47","order_discount":[],"order_room":[{"room_id":"421","room_code":"J03","retail_price":"2058.0","discounted_price":"2058.00","location_id":"2"}],"roughly_size":"28","total_retail_price":2058,"total_discounted_price":2058,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":4116,"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-03-14","delivery_service":"0","remark":"2 months contract. Storage rental paid by bank transfer on February 18, 2020. Storage deposit $2058 transferred from agreement A14-CT206898 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4116,"final_order_total":4116,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,29311","order_product":[],"pass":true}},"first_order_id":"4505","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> J03 <\/td>\r\n\t\t\t\t\t 4X7X8 <\/td>\r\n\t\t\t\t\t $2058.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":"28","total_discounted_price":"2058.00","deposit":"0.00","total_retail_price":"2058.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:55:39","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",1213,"NEW","A14-CT207221",2058,2058,0,0,"2","2",4116,4116,4116,"2020-02-18 15:55:39","0",null,null,null,"2020-01-15","2020-03-14","2 months contract. Storage rental paid by bank transfer on February 18, 2020. Storage deposit $2058 transferred from agreement A14-CT206898 to this agreement.\r\n","2020-01-15","28",0,null,0,"0","2","2020-02-18 15:55:39","2","2020-02-18 15:55:39","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,29311","C191213","PERSONAL","Mr","YHO9lR4lqOinRR0Xuvx6GQ==","lzx0GiXnrd0waIhp6oozpQ==","","epq2EMNVqnrSImwJRTcdnw2CHWw10ygMMBpAt77nlPddtfyEsXACwT2aMxYbyEJsCa3lf0v5S\/ALrV0zfovOLg==","5+ZDtxq474AT888WIcgBDQ==","DnhYj4sh2SVkNhDCs31R8YYc2LVQWdEbeyjdGnSC39g=","j4fRluAlfK8sfp67hqNgSw==",null,1,"4505"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:55:39","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":["7221","421","2058.0","2058.00","2","2020-02-18 15:55:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:55:39","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-03-14","421"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-18 15:55:39","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":["7221",1213,"SETTLED","A14-I207549","2020-02-18 15:55:39","2020-01-15","2","2020-02-18 15:55:39","2","2020-02-18 15:55:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:55:39","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":["7549","RENT","\u9810\u7e73\u79df\u91d1",1,2058,"MO","1",2058,"2","2020-02-18 15:55:39","2","2020-02-18 15:55:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:55:39","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":["7549","RENT","\u9810\u7e73\u79df\u91d1",2,2058,"MO","1",2058,"2","2020-02-18 15:55:39","2","2020-02-18 15:55:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:55:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4116,0,"7549"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-18 15:55:39","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":[1213,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207197","2020-02-18 15:55:39",4116,"2","2020-02-18 15:55:39","2","2020-02-18 15:55:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:55:39","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":["7197","DEPOSIT",null,"PAID","2020-02-18 15:55:39",0,"2","2020-02-18 15:55:39","2","2020-02-18 15:55:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:55:39","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":["7197","INVOICE","7549","PAID","2020-02-18 15:55:39",4116,"2","2020-02-18 15:55:39","2","2020-02-18 15:55:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 15:59:59","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1427&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":924,"customer_code":"C180924","identity_type":"BUSINESS","identity_id":"07143465","title":"Ms","lastname":"Tang","firstname":"Tina","companyname":"Chuang","email":"tinatang@chuangs.com.hk","tel":"25329194","address":"25\/F, Alexandra House, 18 Chater Road Central, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1091.0","renew_rent_month":"12","renew_warehousing_date":"2020-02-10","renew_room_key":"0012385364,0012422238,0012422304,0012422179","renew_remark":"12 months contract. Storage rental paid by cheque on February 13, 2019. Storage deposit $2,796 transferred from agreement B01-CT182884 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT194352, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"142","order_discount":[{"master_room_discount_id":"343","master_room_id":"142","discount_type":"%","price":"1398.00","disocunted_price":"910.00","discount":"34.91","monthly_deduct":488.0418,"room_id":"1270","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1270","room_code":"B01-080","retail_price":"1398.0","discounted_price":910,"location_id":"5"}],"roughly_size":"22","total_retail_price":1398,"total_discounted_price":1091,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":13092,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-10","rent_from":"2020-02-10","rent_to":"2021-02-09","delivery_service":"0","remark":"12 months contract. Storage rental paid by cheque deposit on Feb 17,2020. Storage deposit $2,796 transferred from agreement B01-CT194352 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":13092,"final_order_total":13092,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0012385364,0012422238,0012422304,0012422179","order_product":[],"pass":true}},"first_order_id":4352,"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> B01-080 <\/td>\r\n\t\t\t\t\t 4X5.5X7 <\/td>\r\n\t\t\t\t\t $1398.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":"22","total_discounted_price":"1091.0","deposit":"0","total_retail_price":"1398.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:00:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","2","5",924,"NEW","B01-CT207222",1398,1091,0,0,"12","12",13092,13092,13092,"2020-02-18 16:00:00","0",null,null,null,"2020-02-10","2021-02-09","12 months contract. Storage rental paid by cheque deposit on Feb 17,2020. Storage deposit $2,796 transferred from agreement B01-CT194352 to this agreement.","2020-02-10","22",0,null,0,"0","2","2020-02-18 15:59:59","2","2020-02-18 15:59:59","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012385364,0012422238,0012422304,0012422179","C180924","BUSINESS","Ms","4Vd7tfpTKgQyD0S5kvZFxA==","M7CfcmE2OSMlZOkNgaoDmQ==","Chuang","mqohXZFgx0yzyTqs2uE6kYBQEzNb+MJCf\/GWSv14poEjr9IbIhIL20DLqtF1gVh18xp8J+P4DY3R8fWBiRwc+g==","hZDfDE\/v0fkPBj2TL6VWrw==","tiNyFS3txWQw7E1IAQCbaVxOrKflZ8sQjk24pcdbqJ8=",null,"DTKTk\/\/VJ8nDX7EUIp3FHw==",1,4352]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:00:00","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":["7222","343","142","1270","%","34.91",488.0418,"2","2020-02-18 15:59:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:00:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7222","1270","1398.0",910,"2","2020-02-18 15:59:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:00:00","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-10","2021-02-09","1270"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-18 16:00:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7222",924,"SETTLED","B01-I207550","2020-02-18 15:59:59","2020-02-10","2","2020-02-18 15:59:59","2","2020-02-18 15:59:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:00:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7550","RENT","\u9810\u7e73\u79df\u91d1",1,1091,"MO","1",1091,"2","2020-02-18 15:59:59","2","2020-02-18 15:59:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:00:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7550","RENT","\u9810\u7e73\u79df\u91d1",2,1091,"MO","1",1091,"2","2020-02-18 15:59:59","2","2020-02-18 15:59:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:00:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7550","RENT","\u9810\u7e73\u79df\u91d1",3,1091,"MO","1",1091,"2","2020-02-18 15:59:59","2","2020-02-18 15:59:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:00:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7550","RENT","\u9810\u7e73\u79df\u91d1",4,1091,"MO","1",1091,"2","2020-02-18 15:59:59","2","2020-02-18 15:59:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:00:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7550","RENT","\u9810\u7e73\u79df\u91d1",5,1091,"MO","1",1091,"2","2020-02-18 15:59:59","2","2020-02-18 15:59:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:00:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7550","RENT","\u9810\u7e73\u79df\u91d1",6,1091,"MO","1",1091,"2","2020-02-18 15:59:59","2","2020-02-18 15:59:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:00:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7550","RENT","\u9810\u7e73\u79df\u91d1",7,1091,"MO","1",1091,"2","2020-02-18 15:59:59","2","2020-02-18 15:59:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:00:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7550","RENT","\u9810\u7e73\u79df\u91d1",8,1091,"MO","1",1091,"2","2020-02-18 15:59:59","2","2020-02-18 15:59:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:00:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7550","RENT","\u9810\u7e73\u79df\u91d1",9,1091,"MO","1",1091,"2","2020-02-18 15:59:59","2","2020-02-18 15:59:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:00:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7550","RENT","\u9810\u7e73\u79df\u91d1",10,1091,"MO","1",1091,"2","2020-02-18 15:59:59","2","2020-02-18 15:59:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:00:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7550","RENT","\u9810\u7e73\u79df\u91d1",11,1091,"MO","1",1091,"2","2020-02-18 15:59:59","2","2020-02-18 15:59:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:00:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7550","RENT","\u9810\u7e73\u79df\u91d1",12,1091,"MO","1",1091,"2","2020-02-18 15:59:59","2","2020-02-18 15:59:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:00:00","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13092,0,"7550"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-18 16:00:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[924,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207198","2020-02-18 15:59:59",13092,"2","2020-02-18 15:59:59","2","2020-02-18 15:59:59","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:00:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7198","DEPOSIT",null,"PAID","2020-02-18 15:59:59",0,"2","2020-02-18 15:59:59","2","2020-02-18 15:59:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:00:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7198","INVOICE","7550","PAID","2020-02-18 15:59:59",13092,"2","2020-02-18 15:59:59","2","2020-02-18 15:59:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:13:38","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=1000&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&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":[{"room_id":"1102","master_room_id":"112","room_code":"A05-100"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":759,"customer_code":"C180759","identity_type":"PERSONAL","identity_id":"E725787(6)","title":"Mr","lastname":"Li","firstname":"Wai Chung","companyname":"","email":"yuppiedad@gmail.com","tel":"51683460","address":"Room D, 9\/F, Block 13, Chi Fu Fa Yuen, Pok Fu Lam, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1208.0","renew_rent_month":"6","renew_warehousing_date":"2020-02-10","renew_room_key":"055,40339","renew_remark":"6 months contract. Storage rental paid by bank transfer on August 12, 2019. Storage deposit transferred from agreement A14-CT194355 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195703, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"68","order_discount":[],"order_room":[{"room_id":"542","room_code":"L20(\u670d\u88dd\u5009)","retail_price":"1342.0","discounted_price":"1342.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1342,"total_discounted_price":1342,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1342,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-10","rent_from":"2020-02-10","rent_to":"2020-03-09","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on February 17, 2020. Storage deposit transferred from agreement A14-CT195703 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1342,"final_order_total":1342,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,40339","order_product":[],"pass":true}},"first_order_id":"4355","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> L20(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1342.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1342.00","deposit":"0.00","total_retail_price":"1342.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:13:38","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",759,"NEW","A14-CT207223",1342,1342,0,0,"1","1",1342,1342,1342,"2020-02-18 16:13:38","0",null,null,null,"2020-02-10","2020-03-09","1 month contract. Storage rental paid by bank transfer on February 17, 2020. Storage deposit transferred from agreement A14-CT195703 to this agreement.","2020-02-10","16",0,null,0,"0","2","2020-02-18 16:13:38","2","2020-02-18 16:13:38","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,40339","C180759","PERSONAL","Mr","Ynjpl8I3tZ++XpAECdNy8Q==","7KCehmxbvwRMb+U8lHGoVA==","","66cskWYypQHv60+\/GQVlPuizWjoPvnqEwr8r8zomaCnCOjNREiGJJVVi4LjSgRITum\/JHx+8NpKFYWoAXqB4Eg==","RF9EjEdNBYBpC0Mdx651WQ==","8y9PMGv35tRYLfkOJq8L7FsIMQZvnspgSxtWXml67uY=","EUPrhGL\/9mPduz3bVVEfqQ==",null,1,"4355"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:13:38","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":["7223","542","1342.0","1342.00","2","2020-02-18 16:13:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:13:38","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-10","2020-03-09","542"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-18 16:13:38","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":["7223",759,"SETTLED","A14-I207551","2020-02-18 16:13:38","2020-02-10","2","2020-02-18 16:13:38","2","2020-02-18 16:13:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:13:38","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":["7551","RENT","\u9810\u7e73\u79df\u91d1",1,1342,"MO","1",1342,"2","2020-02-18 16:13:38","2","2020-02-18 16:13:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:13:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1342,0,"7551"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-18 16:13:38","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":[759,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207199","2020-02-18 16:13:38",1342,"2","2020-02-18 16:13:38","2","2020-02-18 16:13:38","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:13:38","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":["7199","DEPOSIT",null,"PAID","2020-02-18 16:13:38",0,"2","2020-02-18 16:13:38","2","2020-02-18 16:13:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 16:13:38","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":["7199","INVOICE","7551","PAID","2020-02-18 16:13:38",1342,"2","2020-02-18 16:13:38","2","2020-02-18 16:13:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-18 19:01:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****