{"created_at":"2020-04-08 11:20:57","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1231,"customer_code":"C191231","identity_type":"BUSINESS","identity_id":"63137444-000-04-19-9","title":"Mr","lastname":"LEUNG","firstname":"Siu Hung","companyname":"E-Board Construction Limited","email":"hung91940040@yahoo.com.hk","tel":"91940040","address":"Room 606, Tsui Ning House, Tsui Wan Estate, Chai Wan, Hong Kong.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"684.0","renew_rent_month":"3","renew_warehousing_date":"2020-03-26","renew_room_key":"'0012465782","renew_remark":"3 months contract. Storage rental paid by bank transfer on Jan 21,2020. Deposit $720 transferred from agreement C15-CT196474 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT207019, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"159","order_discount":[{"master_room_discount_id":"411","master_room_id":"159","discount_type":"%","price":"720.00","disocunted_price":"684.00","discount":"5.00","monthly_deduct":36,"room_id":"1400","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1400","room_code":"C15-094","retail_price":"720.0","discounted_price":684,"location_id":"6"}],"roughly_size":"9","total_retail_price":720,"total_discounted_price":684,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2052,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-26","rent_from":"2020-03-26","rent_to":"2020-06-25","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on Apr 08,2020. Deposit $720 transferred from agreement C15-CT207019 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2052,"final_order_total":2052,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012465782","order_product":[],"pass":true}},"first_order_id":"4648","selected_room_tr":"\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t

---

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

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

\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>
C15-094 <\/td>\r\n\t\t\t\t\t	3X3X6.5 <\/td>\r\n\t\t\t\t\t	$720.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"9","total_discounted_price":"684.0","deposit":"0","total_retail_price":"720.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 11:20:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1231,"NEW","C15-CT207582",720,684,0,0,"3","3",2052,2052,2052,"2020-04-08 11:20:57","0",null,null,null,"2020-03-26","2020-06-25","3 months contract. Storage rental paid by bank transfer on Apr 08,2020. Deposit $720 transferred from agreement C15-CT207019 to this agreement.","2020-03-26","9",0,null,0,"0","2","2020-04-08 11:20:57","2","2020-04-08 11:20:57","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0012465782","C191231","BUSINESS","Mr","cKQuXkw+QX5W9kWyedDIMQ==","yXKc2lCF323ApRADrjNaSg==","E-Board Construction Limited","mUajGax6tlCJpSmxJm6NqFr6L52xbXs2tmmlNxzVvGLfYqKtndbhVPfWdP78Qr\/Kep+QxPBCaHSKiWPK7elr1iQMxnXx+e6KPIeRRwScI8Y=","AuUPgOiCb57sL53kxfWXZw==","neD4RJ9Xps0JfAJm4eyVSwJjZSuQzyU927SqmEYs2xE=",null,"r4Yf8AUupRy8x6rdET56NMVu61ggTOBt7kcj9DUHePc=",1,"4648"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 11:20:57","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":["7582","411","159","1400","%","5.00",36,"2","2020-04-08 11:20:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 11:20:57","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":["7582","1400","720.0",684,"2","2020-04-08 11:20:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 11:20:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-26","2020-06-25","1400"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-08 11:20:57","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":["7582",1231,"SETTLED","C15-I207910","2020-04-08 11:20:57","2020-03-26","2","2020-04-08 11:20:57","2","2020-04-08 11:20:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 11:20:57","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":["7910","RENT","\u9810\u7e73\u79df\u91d1",1,684,"MO","1",684,"2","2020-04-08 11:20:57","2","2020-04-08 11:20:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 11:20:57","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":["7910","RENT","\u9810\u7e73\u79df\u91d1",2,684,"MO","1",684,"2","2020-04-08 11:20:57","2","2020-04-08 11:20:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 11:20:57","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":["7910","RENT","\u9810\u7e73\u79df\u91d1",3,684,"MO","1",684,"2","2020-04-08 11:20:57","2","2020-04-08 11:20:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 11:20:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2052,0,"7910"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-08 11:20:57","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":[1231,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207557","2020-04-08 11:20:57",2052,"2","2020-04-08 11:20:57","2","2020-04-08 11:20:57","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 11:20:57","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":["7557","DEPOSIT",null,"PAID","2020-04-08 11:20:57",0,"2","2020-04-08 11:20:57","2","2020-04-08 11:20:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 11:20:57","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":["7557","INVOICE","7910","PAID","2020-04-08 11:20:57",2052,"2","2020-04-08 11:20:57","2","2020-04-08 11:20:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 12:16:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 13:03:35","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 14:26: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":"&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":629,"customer_code":"C170629","identity_type":"PERSONAL","identity_id":"D676258(2)","title":"Ms","lastname":"Chan","firstname":"Wai King Dicky","companyname":"","email":"kelly@tiptoptours.com.hk","tel":"91207071","address":"Flat C, 38\/F, Block 19, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1195.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-02","renew_room_key":"052,40523","renew_remark":"1 month contract. Storage rental paid by bank transfer on March 5, 2020. Storage deposit transferred from agreement A18-CT207178 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207339, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"107","order_discount":[],"order_room":[{"room_id":"815","room_code":"Q12","retail_price":"1195.0","discounted_price":"1195.00","location_id":"3"}],"roughly_size":"18","total_retail_price":1195,"total_discounted_price":1195,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1195,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-02","rent_from":"2020-04-02","rent_to":"2020-05-01","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on April 8, 2020. Storage deposit transferred from agreement A18-CT207339 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1195,"final_order_total":1195,"location_id":"3","branch_id":"1","company_id":"1","room_key":"052,40523","order_product":[],"pass":true}},"first_order_id":"4694","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> Q12 <\/td>\r\n\t\t\t\t\t 3X6X7 <\/td>\r\n\t\t\t\t\t $1195.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":"18","total_discounted_price":"1195.0","deposit":"0","total_retail_price":"1195.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 14:26:40","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",629,"NEW","A18-CT207583",1195,1195,0,0,"1","1",1195,1195,1195,"2020-04-08 14:26:40","0",null,null,null,"2020-04-02","2020-05-01","1 month contract. Storage rental paid by bank transfer on April 8, 2020. Storage deposit transferred from agreement A18-CT207339 to this agreement.\r\n","2020-04-02","18",0,null,0,"0","2","2020-04-08 14:26:39","2","2020-04-08 14:26:39","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,40523","C170629","PERSONAL","Ms","RpXGKsWvjdIh2zpNpZGQoQ==","U9yoE9KqV1v8YlRkf7Q2yg==","","36wRGpAjwc\/0wlF+nTn2W4D7sbMVDfrQcRaUEETc94CbdXOD165sYiJ4w9a0XWwUmn9HdLUPAL5jHBLCynFDtA==","c1f20bJNL7v6HlqVb6xwiw==","09G8cY6xfbNmNlWHMFOaw2MNgdv38UQbp6+QiEm\/fmg=","fShBvH+qXdfrGzN7M8+\/Eg==",null,1,"4694"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 14:26:40","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":["7583","815","1195.0","1195.00","2","2020-04-08 14:26:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 14:26:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-02","2020-05-01","815"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-08 14:26:40","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":["7583",629,"SETTLED","A18-I207911","2020-04-08 14:26:39","2020-04-02","2","2020-04-08 14:26:39","2","2020-04-08 14:26:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 14:26:40","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":["7911","RENT","\u9810\u7e73\u79df\u91d1",1,1195,"MO","1",1195,"2","2020-04-08 14:26:39","2","2020-04-08 14:26:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 14:26:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1195,0,"7911"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-08 14:26:40","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":[629,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207558","2020-04-08 14:26:39",1195,"2","2020-04-08 14:26:39","2","2020-04-08 14:26:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 14:26:40","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":["7558","DEPOSIT",null,"PAID","2020-04-08 14:26:39",0,"2","2020-04-08 14:26:39","2","2020-04-08 14:26:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 14:26:40","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":["7558","INVOICE","7911","PAID","2020-04-08 14:26:39",1195,"2","2020-04-08 14:26:39","2","2020-04-08 14:26:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 15:01:18","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":679,"customer_code":"C180679","identity_type":"BUSINESS","identity_id":"30490025","title":"Ms","lastname":"Chan","firstname":"Doris","companyname":"Hemandas Industrial Ltd.","email":"dorischan@esc.com.hk","tel":"92896007","address":"Unit 2243, 22\/F, Yan's Tower, 25-27 Wong Chuk Hang Rd, Wong Chuk Hang, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2728.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-03","renew_room_key":"055,56887","renew_remark":"1 month contract. Storage rental paid by bank transfer on March 5, 2020. Storage deposit transferred from agreement A18-CT207154 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207330, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"82","order_discount":[],"order_room":[{"room_id":"859","room_code":"T03","retail_price":"2728.0","discounted_price":"2728.00","location_id":"3"}],"roughly_size":"36","total_retail_price":2728,"total_discounted_price":2728,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2728,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-03","rent_from":"2020-04-03","rent_to":"2020-05-02","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on April 8, 2020. Storage deposit transferred from agreement A18-CT207330 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2728,"final_order_total":2728,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,56887","order_product":[],"pass":true}},"first_order_id":"4697","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> T03 <\/td>\r\n\t\t\t\t\t 6X6X7 <\/td>\r\n\t\t\t\t\t $2728.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":"36","total_discounted_price":"2728.0","deposit":"0","total_retail_price":"2728.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 15:01:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",679,"NEW","A18-CT207584",2728,2728,0,0,"1","1",2728,2728,2728,"2020-04-08 15:01:19","0",null,null,null,"2020-04-03","2020-05-02","1 month contract. Storage rental paid by bank transfer on April 8, 2020. Storage deposit transferred from agreement A18-CT207330 to this agreement.\r\n","2020-04-03","36",0,null,0,"0","2","2020-04-08 15:01:18","2","2020-04-08 15:01:18","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,56887","C180679","BUSINESS","Ms","1p0+HSxbHlPSeHnKL1+MnA==","U9yoE9KqV1v8YlRkf7Q2yg==","Hemandas Industrial Ltd.","NNq9wxs1efEwHG+GfiDv3WoHFlyl2ik9vc5ha7eicfoFr48wfjXwEVDp3r5jjcxqeRyrZaz+NALvMBTiKSrb1OMQJpkhkNMPCpwd2zTkR61b7UwwjxTbA4OPPOLfvpDG","gMEFsGZs7+56GFUaxLbplg==","Um3+ktI0eYcw3estHH8TQKxSuSRl+2j3b4bDI46i5yg=",null,"UeK5wwtn5\/PTJNB6lM3obw==",1,"4697"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 15:01:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7584","859","2728.0","2728.00","2","2020-04-08 15:01:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 15:01:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-03","2020-05-02","859"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-08 15:01:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7584",679,"SETTLED","A18-I207912","2020-04-08 15:01:18","2020-04-03","2","2020-04-08 15:01:18","2","2020-04-08 15:01:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 15:01:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7912","RENT","\u9810\u7e73\u79df\u91d1",1,2728,"MO","1",2728,"2","2020-04-08 15:01:18","2","2020-04-08 15:01:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 15:01:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2728,0,"7912"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-08 15:01:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[679,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207559","2020-04-08 15:01:18",2728,"2","2020-04-08 15:01:18","2","2020-04-08 15:01:18","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 15:01:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7559","DEPOSIT",null,"PAID","2020-04-08 15:01:18",0,"2","2020-04-08 15:01:18","2","2020-04-08 15:01:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 15:01:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7559","INVOICE","7912","PAID","2020-04-08 15:01:18",2728,"2","2020-04-08 15:01:18","2","2020-04-08 15:01:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 15:08:20","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1131,"customer_code":"C181131","identity_type":"PERSONAL","identity_id":"Z345376(7)","title":"Mr","lastname":"Chan","firstname":"Siu Cheung","companyname":"","email":"siucheung2004@yahoo.com.hk","tel":"98251393","address":"Room 2204, Tung On House, Lei Tung Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-03","renew_room_key":"0005012995","renew_remark":"1 month contract. Storage rental paid by PPS on March 6, 2020. Storage deposit transferred from agreement A05-CT207133 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207379, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"110","order_discount":[],"order_room":[{"room_id":"1077","room_code":"A05-075","retail_price":"598.0","discounted_price":"598.00","location_id":"4"}],"roughly_size":"8","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-04-03","rent_from":"2020-04-03","rent_to":"2020-05-02","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on April 3, 2020. Storage deposit transferred from agreement A05-CT207379 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0005012995","order_product":[],"pass":true}},"first_order_id":"4845","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-075 <\/td>\r\n\t\t\t\t\t 4X2X3.5 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \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":"8","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 15:08:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1131,"NEW","A05-CT207585",598,598,0,0,"1","1",598,598,598,"2020-04-08 15:08:20","0",null,null,null,"2020-04-03","2020-05-02","1 month contract. Storage rental paid by PPS on April 3, 2020. Storage deposit transferred from agreement A05-CT207379 to this agreement.\r\n","2020-04-03","8",0,null,0,"0","2","2020-04-08 15:08:20","2","2020-04-08 15:08:20","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0005012995","C181131","PERSONAL","Mr","fGcZizJCatuKFWu4ZRrKSA==","U9yoE9KqV1v8YlRkf7Q2yg==","","CQCYoAe3GOoadJVRzLyv+sNtTDGIle0HVMeR83McsJynyrP8tFX204cW64FCZ5NA5j\/z2cPdugPvlnA2Si9a8Q==","9k5P13X5Z+o0UYFE5+2bdg==","ApBLMJPz\/Z49uwpRoZz00ngQMrV7EI2jJmIQp3ku3DM=","EdsRFjojZ1QPZDY\/kWek4g==",null,1,"4845"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 15:08:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7585","1077","598.0","598.00","2","2020-04-08 15:08:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 15:08:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-03","2020-05-02","1077"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-08 15:08:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7585",1131,"SETTLED","A05-I207913","2020-04-08 15:08:20","2020-04-03","2","2020-04-08 15:08:20","2","2020-04-08 15:08:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 15:08:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7913","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-04-08 15:08:20","2","2020-04-08 15:08:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 15:08:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7913"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-08 15:08:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1131,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207560","2020-04-08 15:08:20",598,"2","2020-04-08 15:08:20","2","2020-04-08 15:08:20","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 15:08:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7560","DEPOSIT",null,"PAID","2020-04-08 15:08:20",0,"2","2020-04-08 15:08:20","2","2020-04-08 15:08:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 15:08:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7560","INVOICE","7913","PAID","2020-04-08 15:08:20",598,"2","2020-04-08 15:08:20","2","2020-04-08 15:08:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 15:11:20","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&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","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":"1488.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-06","renew_room_key":"0005763937","renew_remark":"1 month contract. Storage rental paid by PPS on March 4, 2020. Storage deposit $2976 transferred from agreement B01-CT207118 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT207327, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"143","order_discount":[],"order_room":[{"room_id":"1274","room_code":"B01-084","retail_price":"1488.0","discounted_price":"1488.00","location_id":"5"}],"roughly_size":"24","total_retail_price":1488,"total_discounted_price":1488,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1488,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-06","rent_from":"2020-04-06","rent_to":"2020-05-05","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on April 3, 2020. Storage deposit $2976 transferred from agreement B01-CT207327 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1488,"final_order_total":1488,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0005763937","order_product":[],"pass":true}},"first_order_id":"4797","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-084 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1488.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":"24","total_discounted_price":"1488.0","deposit":"0","total_retail_price":"1488.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 15:11:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","2","5",888,"NEW","B01-CT207586",1488,1488,0,0,"1","1",1488,1488,1488,"2020-04-08 15:11:21","0",null,null,null,"2020-04-06","2020-05-05","1 month contract. Storage rental paid by PPS on April 3, 2020. Storage deposit $2976 transferred from agreement B01-CT207327 to this agreement.\r\n","2020-04-06","24",0,null,0,"0","2","2020-04-08 15:11:20","2","2020-04-08 15:11:20","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,"4797"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 15:11:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7586","1274","1488.0","1488.00","2","2020-04-08 15:11:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 15:11:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-06","2020-05-05","1274"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-08 15:11:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7586",888,"SETTLED","B01-I207914","2020-04-08 15:11:20","2020-04-06","2","2020-04-08 15:11:20","2","2020-04-08 15:11:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 15:11:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7914","RENT","\u9810\u7e73\u79df\u91d1",1,1488,"MO","1",1488,"2","2020-04-08 15:11:20","2","2020-04-08 15:11:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 15:11:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1488,0,"7914"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-08 15:11:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[888,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207561","2020-04-08 15:11:20",1488,"2","2020-04-08 15:11:20","2","2020-04-08 15:11:20","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 15:11:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7561","DEPOSIT",null,"PAID","2020-04-08 15:11:20",0,"2","2020-04-08 15:11:20","2","2020-04-08 15:11:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 15:11:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7561","INVOICE","7914","PAID","2020-04-08 15:11:20",1488,"2","2020-04-08 15:11:20","2","2020-04-08 15:11:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:32:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:32:15","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":153,"customer_code":"C160153","identity_type":"PERSONAL","identity_id":"Z614380(7)","title":"Ms","lastname":"Au-Yeung","firstname":"Pik Kwan","companyname":"","email":"carol_85_2000@yahoo.com.hk","tel":"97502271","address":"\u9999\u6e2f\u77f3\u6392\u7063\u6751\u78a7\u8f1d\u6a137\u6a13706\u5ba4","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-20","renew_room_key":"053,63642","renew_remark":"1 month contract. Storage rental paid by PPS on March 2, 2020. Storage deposit transferred from agreement A12-CT207131 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207311, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"227","room_code":"D31","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":998,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-20","rent_from":"2020-03-20","rent_to":"2020-04-19","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on April 6, 2020. Storage deposit transferred from agreement A12-CT207311 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":998,"final_order_total":998,"location_id":"1","branch_id":"1","company_id":"1","room_key":"053,63642","order_product":[],"pass":true}},"first_order_id":"4883","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> D31 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"998.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:32: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","1","1",153,"NEW","A12-CT207587",998,998,0,0,"1","1",998,998,998,"2020-04-08 16:32:16","0",null,null,null,"2020-03-20","2020-04-19","1 month contract. Storage rental paid by PPS on April 6, 2020. Storage deposit transferred from agreement A12-CT207311 to this agreement.\r\n","2020-03-20","12",0,null,0,"0","2","2020-04-08 16:32:15","2","2020-04-08 16:32:15","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"053,63642","C160153","PERSONAL","Ms","KkrSDrQ1H2C7AHMXanK04g==","5c4M0ZQmSIw3LaJy30yaLQ==","","VydP8q4rzuZV5xu3JM4S94+vjANpX0mSGFwOYMOB853mNnGiX4hnOAOtYB32IPMF","G4ql4s\/qkLFXwmJNbU6cdQ==","2yv4BPlbG\/\/YEJETfEEfNB1ddarjnzyQnu7bGnobgMM=","N0BX828OAg4Z6rH9GAZdUA==",null,1,"4883"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:32: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":["7587","227","998.0","998.00","2","2020-04-08 16:32:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:32: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-03-20","2020-04-19","227"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-08 16:32: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":["7587",153,"SETTLED","A12-I207915","2020-04-08 16:32:15","2020-03-20","2","2020-04-08 16:32:15","2","2020-04-08 16:32:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:32: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":["7915","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-04-08 16:32:15","2","2020-04-08 16:32:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:32:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"7915"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-08 16:32: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":[153,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207562","2020-04-08 16:32:15",998,"2","2020-04-08 16:32:15","2","2020-04-08 16:32:15","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:32: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":["7562","DEPOSIT",null,"PAID","2020-04-08 16:32:15",0,"2","2020-04-08 16:32:15","2","2020-04-08 16:32:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:32: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":["7562","INVOICE","7915","PAID","2020-04-08 16:32:15",998,"2","2020-04-08 16:32:15","2","2020-04-08 16:32:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:37:42","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":650,"customer_code":"C170650","identity_type":"PERSONAL","identity_id":"Z603985(6)","title":"Mr","lastname":"Li","firstname":"Ka Man Carmen ","companyname":"","email":"licarmen120@outlook.com","tel":"60866005","address":"Flat 11D, Block 7, Chi Fu Fa Yuen, Pok Fu Lam ","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1857.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-01","renew_room_key":"053,30656","renew_remark":"1 month contract. Storage rental paid by PPS on March 9, 2020. Storage deposit transferred from agreement A18-CT207136 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207382, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"79","order_discount":[],"order_room":[{"room_id":"832","room_code":"R06","retail_price":"1857.0","discounted_price":"1857.00","location_id":"3"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1672,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":10032,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-01","rent_from":"2020-04-01","rent_to":"2020-09-30","delivery_service":"0","remark":"6 months contract. Storage rental paid by PPS on April 6, 2020. Storage deposit transferred from agreement A18-CT207382 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":10032,"final_order_total":10032,"location_id":"3","branch_id":"1","company_id":"1","room_key":"053,30656","order_product":[],"pass":true}},"first_order_id":"4117","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> R06 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1857.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":"24","total_discounted_price":"1672.00","deposit":"0.00","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:37:42","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",650,"NEW","A18-CT207588",1857,1672,0,0,"6","6",10032,10032,10032,"2020-04-08 16:37:42","0",null,null,null,"2020-04-01","2020-09-30","6 months contract. Storage rental paid by PPS on April 6, 2020. Storage deposit transferred from agreement A18-CT207382 to this agreement.\r\n","2020-04-01","24",0,null,0,"0","2","2020-04-08 16:37:42","2","2020-04-08 16:37:42","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"053,30656","C170650","PERSONAL","Mr","mqlU7HwzD2KcOzmXS2v+sA==","7KCehmxbvwRMb+U8lHGoVA==","","N1UMvJRIlBDaipk\/6myaA2yvOWbLAlcHBaBFvhn3ndwzx9gjypD9HQoLkbHY903D","j9uSn7lfecYNB\/L0v79ywg==","D\/P9IXVUbziIb70tKXH1egvc8mQBlMIAFVy1O5krGx4=","qJTrGPQQj78pb5tx0e8DHg==",null,1,"4117"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:37:42","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":["7588","832","1857.0","1857.00","2","2020-04-08 16:37:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:37:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-01","2020-09-30","832"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-08 16:37:42","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":["7588",650,"SETTLED","A18-I207916","2020-04-08 16:37:42","2020-04-01","2","2020-04-08 16:37:42","2","2020-04-08 16:37:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:37:42","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":["7916","RENT","\u9810\u7e73\u79df\u91d1",1,1672,"MO","1",1672,"2","2020-04-08 16:37:42","2","2020-04-08 16:37:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:37:42","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":["7916","RENT","\u9810\u7e73\u79df\u91d1",2,1672,"MO","1",1672,"2","2020-04-08 16:37:42","2","2020-04-08 16:37:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:37:42","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":["7916","RENT","\u9810\u7e73\u79df\u91d1",3,1672,"MO","1",1672,"2","2020-04-08 16:37:42","2","2020-04-08 16:37:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:37:42","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":["7916","RENT","\u9810\u7e73\u79df\u91d1",4,1672,"MO","1",1672,"2","2020-04-08 16:37:42","2","2020-04-08 16:37:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:37:42","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":["7916","RENT","\u9810\u7e73\u79df\u91d1",5,1672,"MO","1",1672,"2","2020-04-08 16:37:42","2","2020-04-08 16:37:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:37:42","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":["7916","RENT","\u9810\u7e73\u79df\u91d1",6,1672,"MO","1",1672,"2","2020-04-08 16:37:42","2","2020-04-08 16:37:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:37:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10032,0,"7916"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-08 16:37:42","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":[650,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207563","2020-04-08 16:37:42",10032,"2","2020-04-08 16:37:42","2","2020-04-08 16:37:42","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:37:42","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":["7563","DEPOSIT",null,"PAID","2020-04-08 16:37:42",0,"2","2020-04-08 16:37:42","2","2020-04-08 16:37:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:37:42","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":["7563","INVOICE","7916","PAID","2020-04-08 16:37:42",10032,"2","2020-04-08 16:37:42","2","2020-04-08 16:37:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:40:12","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":54,"customer_code":"C160054","identity_type":"PERSONAL","identity_id":"D339237(7)","title":"Mr","lastname":"Wong","firstname":"Siu Wai","companyname":"","email":"artsadvco@yahoo.com.hk","tel":"97588797","address":"\u9999\u6e2f\u4ed4\u6f01\u5149\u905345\u865f\u6f01\u6689\u82d1\u7f8e\u6689\u95a37\u5b57\u645f","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1286.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-15","renew_room_key":"138,29741","renew_remark":"1 month contract. Storage rental paid by PPS on March 1, 2020. Storage deposit transferred from agreement A12-CT196660 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207280, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"125","room_code":"C01","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1286,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1286,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-15","rent_from":"2020-03-15","rent_to":"2020-04-14","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on April 6, 2020. Storage deposit transferred from agreement A12-CT207280 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1286,"final_order_total":1286,"location_id":"1","branch_id":"1","company_id":"1","room_key":"138,29741","order_product":[],"pass":true}},"first_order_id":"4407","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> C01 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1286.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:40:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",54,"NEW","A12-CT207589",1528,1286,0,0,"1","1",1286,1286,1286,"2020-04-08 16:40:12","0",null,null,null,"2020-03-15","2020-04-14","1 month contract. Storage rental paid by PPS on April 6, 2020. Storage deposit transferred from agreement A12-CT207280 to this agreement.\r\n","2020-03-15","20",0,null,0,"0","2","2020-04-08 16:40:12","2","2020-04-08 16:40:12","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"138,29741","C160054","PERSONAL","Mr","mMV5J7Rfft6JJpDQA9XypQ==","hULSwM2MvFtpeV9\/z+er8Q==","","eD6tjqVeKfxAQSMYm9AHnBkJ5hIG+AW0TS9NTrTNPmy8sb4gGLrOVGrxrpyRxTO4GzKuKO8TvjuGMWhra7oPug==","uQre4vjMJEjZYCpftinh0Q==","oTJWSVWZRAKoy\/KSfvVPXM4ckwr7o\/yBdit4khJKFMc=","rD1nW9Kk4kNwxMXbuMBBAQ==",null,1,"4407"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:40:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7589","125","1528.0","1528.00","2","2020-04-08 16:40:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:40:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-15","2020-04-14","125"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-08 16:40:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7589",54,"SETTLED","A12-I207917","2020-04-08 16:40:12","2020-03-15","2","2020-04-08 16:40:12","2","2020-04-08 16:40:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:40:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7917","RENT","\u9810\u7e73\u79df\u91d1",1,1286,"MO","1",1286,"2","2020-04-08 16:40:12","2","2020-04-08 16:40:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:40:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1286,0,"7917"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-08 16:40:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[54,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207564","2020-04-08 16:40:12",1286,"2","2020-04-08 16:40:12","2","2020-04-08 16:40:12","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:40:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7564","DEPOSIT",null,"PAID","2020-04-08 16:40:12",0,"2","2020-04-08 16:40:12","2","2020-04-08 16:40:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:40:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7564","INVOICE","7917","PAID","2020-04-08 16:40:12",1286,"2","2020-04-08 16:40:12","2","2020-04-08 16:40:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:42:08","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":311,"customer_code":"C170311","identity_type":"PERSONAL","identity_id":"K465007(7)","title":"Mr","lastname":"Lo","firstname":"Ho Yin Owen","companyname":"","email":"aumanoh@gmail.com","tel":"94816466","address":"Rm 1, 15\/F, Kong Tai Court, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-18","renew_room_key":"054,46524","renew_remark":"1 month contract. Storage rental paid by PPS on March 5, 2020. Storage deposit $1396 transferred from agreement A14-CT207070 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207338, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"731","room_code":"O07","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":998,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-18","rent_from":"2020-03-18","rent_to":"2020-04-17","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on April 6, 2020. Storage deposit $1396 transferred from agreement A14-CT207338 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":998,"final_order_total":998,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,46524","order_product":[],"pass":true}},"first_order_id":"4521","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> O07 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"998.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:42:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",311,"NEW","A14-CT207590",998,998,0,0,"1","1",998,998,998,"2020-04-08 16:42:09","0",null,null,null,"2020-03-18","2020-04-17","1 month contract. Storage rental paid by PPS on April 6, 2020. Storage deposit $1396 transferred from agreement A14-CT207338 to this agreement.\r\n","2020-03-18","12",0,null,0,"0","2","2020-04-08 16:42:08","2","2020-04-08 16:42:08","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,46524","C170311","PERSONAL","Mr","rCN1lNVsvQUEIb4CpJx1nQ==","4w4biS+jM\/Q3DAzxHdf3pA==","","UucV8Ifr0A3QD8t\/j4UcOkwkrTPm33ceBZgTGHCMj6A\/O47vut2lT34hVu5UQZtV","jhz+YIyFB3NZsNn7IDpl4g==","BsQLPUdVMtvEb+TZbZnmUf9xqaiffRvcCnuR9msGho8=","1b5I8lCuen+0vvfOkqGOwA==",null,1,"4521"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:42: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":["7590","731","998.0","998.00","2","2020-04-08 16:42:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:42: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-03-18","2020-04-17","731"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-08 16:42: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":["7590",311,"SETTLED","A14-I207918","2020-04-08 16:42:08","2020-03-18","2","2020-04-08 16:42:08","2","2020-04-08 16:42:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:42: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":["7918","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-04-08 16:42:08","2","2020-04-08 16:42:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:42:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"7918"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-08 16:42: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":[311,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207565","2020-04-08 16:42:08",998,"2","2020-04-08 16:42:08","2","2020-04-08 16:42:08","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:42: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":["7565","DEPOSIT",null,"PAID","2020-04-08 16:42:08",0,"2","2020-04-08 16:42:08","2","2020-04-08 16:42:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:42: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":["7565","INVOICE","7918","PAID","2020-04-08 16:42:08",998,"2","2020-04-08 16:42:08","2","2020-04-08 16:42:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:47:13","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1233,"customer_code":"C191233","identity_type":"PERSONAL","identity_id":"K534534(0)","title":"Mr","lastname":"TSUI","firstname":"Ka Kit","companyname":"","email":"curry588@gmail.com","tel":"93151560","address":"Flat D, 18\/F, Blk 6, Fullview Garden, Siu Sai Wan, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"709.0","renew_rent_month":"12","renew_warehousing_date":"2020-03-27","renew_room_key":"'0012434997","renew_remark":"12 months contract. Special offer 2 months free and 5% off. Storage rental and deposit paid by EPS on March 26, 2019. Smartcard provided on March 26, 2019. \\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT194652, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1816.0","renew_master_room_id":"136","order_discount":[],"order_room":[{"room_id":"1285","room_code":"B01-095","retail_price":"908.0","discounted_price":"908.00","location_id":"5"}],"roughly_size":"12","total_retail_price":908,"total_discounted_price":709,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":8016,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"492.00","warehousing_date":"2020-03-27","rent_from":"2020-03-27","rent_to":"2021-03-26","delivery_service":"0","remark":"12 months contract. Special offer $668\/month. Storage rental paid by PPS on April 6, 2020. Storage deposit $1816 transferred from agreement B01-CT194652 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":492,"order_total":8508,"final_order_total":8016,"location_id":"5","branch_id":"2","company_id":"1","room_key":"'0012434997","order_product":[],"pass":true}},"first_order_id":4652,"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-095 <\/td>\r\n\t\t\t\t\t 3X4X7 <\/td>\r\n\t\t\t\t\t $908.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"709.0","deposit":"0","total_retail_price":"908.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:47:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","2","5",1233,"NEW","B01-CT207591",908,709,0,0,"12","12",8016,8508,8016,"2020-04-08 16:47:14","0",null,null,null,"2020-03-27","2021-03-26","12 months contract. Special offer $668\/month. Storage rental paid by PPS on April 6, 2020. Storage deposit $1816 transferred from agreement B01-CT194652 to this agreement. \r\n","2020-03-27","12",0,null,492,"492.00","2","2020-04-08 16:47:13","2","2020-04-08 16:47:13","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"'0012434997","C191233","PERSONAL","Mr","OmjEDhr4ZNInr6gOk9uuNw==","4zek2V6v+muRHEsNI7xEHw==","","v6rcnasqShSm36z5rKQUTqcaOP9nzUYEkBqpzdNdrDOfEDW7t49QWu4twFLd7wZtsjDGaMcgaJqkhPJCbaxZSA==","7hJCAHAm\/udvvgzjIeWHsw==","6EWAqkWWskmgj0yMRnO6XOgqRybOG9BgOhYXBkgN\/KA=","s9XEpcfn0bwXNkX\/ZkV7IA==",null,1,4652]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:47:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7591","1285","908.0","908.00","2","2020-04-08 16:47:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:47:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-27","2021-03-26","1285"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-08 16:47:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7591",1233,"SETTLED","B01-I207919","2020-04-08 16:47:13","2020-03-27","2","2020-04-08 16:47:13","2","2020-04-08 16:47:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:47:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7919","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,217,"MO","1",217,"2","2020-04-08 16:47:13","2","2020-04-08 16:47:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:47:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7919","RENT","\u9810\u7e73\u79df\u91d1",2,709,"MO","1",709,"2","2020-04-08 16:47:13","2","2020-04-08 16:47:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:47:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7919","RENT","\u9810\u7e73\u79df\u91d1",3,709,"MO","1",709,"2","2020-04-08 16:47:13","2","2020-04-08 16:47:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:47:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7919","RENT","\u9810\u7e73\u79df\u91d1",4,709,"MO","1",709,"2","2020-04-08 16:47:13","2","2020-04-08 16:47:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:47:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7919","RENT","\u9810\u7e73\u79df\u91d1",5,709,"MO","1",709,"2","2020-04-08 16:47:13","2","2020-04-08 16:47:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:47:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7919","RENT","\u9810\u7e73\u79df\u91d1",6,709,"MO","1",709,"2","2020-04-08 16:47:13","2","2020-04-08 16:47:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:47:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7919","RENT","\u9810\u7e73\u79df\u91d1",7,709,"MO","1",709,"2","2020-04-08 16:47:13","2","2020-04-08 16:47:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:47:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7919","RENT","\u9810\u7e73\u79df\u91d1",8,709,"MO","1",709,"2","2020-04-08 16:47:13","2","2020-04-08 16:47:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:47:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7919","RENT","\u9810\u7e73\u79df\u91d1",9,709,"MO","1",709,"2","2020-04-08 16:47:13","2","2020-04-08 16:47:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:47:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7919","RENT","\u9810\u7e73\u79df\u91d1",10,709,"MO","1",709,"2","2020-04-08 16:47:13","2","2020-04-08 16:47:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:47:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7919","RENT","\u9810\u7e73\u79df\u91d1",11,709,"MO","1",709,"2","2020-04-08 16:47:13","2","2020-04-08 16:47:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:47:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7919","RENT","\u9810\u7e73\u79df\u91d1",12,709,"MO","1",709,"2","2020-04-08 16:47:13","2","2020-04-08 16:47:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:47:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8016,0,"7919"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-08 16:47:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1233,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207566","2020-04-08 16:47:13",8016,"2","2020-04-08 16:47:13","2","2020-04-08 16:47:13","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:47:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7566","DEPOSIT",null,"PAID","2020-04-08 16:47:13",0,"2","2020-04-08 16:47:13","2","2020-04-08 16:47:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 16:47:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7566","INVOICE","7919","PAID","2020-04-08 16:47:13",8016,"2","2020-04-08 16:47:13","2","2020-04-08 16:47:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 18:09:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 18:59:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-08 19:46:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****