{"created_at":"2020-01-16 09:54:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:05:43","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1137,"customer_code":"C181137","identity_type":"PERSONAL","identity_id":"D511733(0)","title":"Ms","lastname":"Cheung","firstname":"Mei Ping","companyname":"","email":null,"tel":"54034230","address":"Flat 3, 23\/F, Block Q, Mei Fai Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-08","renew_room_key":"0007305364","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 20, 2019. Storage deposit transferred from agreement A05-CT196382 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT206890, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"110","order_discount":[],"order_room":[{"room_id":"1087","room_code":"A05-085","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-01-08","rent_from":"2020-01-08","rent_to":"2020-02-07","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 15, 2020. Storage deposit transferred from agreement A05-CT206890 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0007305364","order_product":[],"pass":true}},"first_order_id":"4717","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-085 <\/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-01-16 10:05:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1137,"NEW","A05-CT206972",598,598,0,0,"1","1",598,598,598,"2020-01-16 10:05:44","0",null,null,null,"2020-01-08","2020-02-07","1 month contract. Storage rental paid by bank transfer on January 15, 2020. Storage deposit transferred from agreement A05-CT206890 to this agreement.\r\n","2020-01-08","8",0,null,0,"0","2","2020-01-16 10:05:43","2","2020-01-16 10:05:43","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0007305364","C181137","PERSONAL","Ms","ov4itGGMhitaTATk31YbvA==","vCxOlXQuvOQaoL822H2o\/Q==","","E1vSnV3\/zTD\/COo0L4lGPzFMAscGCZXb3LMO+qHc4+tCAMOAjpkWSa444NxIRpkUETecgSZwbVUPrOe8jXLqvSR8eOGI+jndWcBFCAJnBXs=","pvHbwmM2tVjF9UsDRGbtTQ==",null,"itJoZuSGBd5W3YULMxGxDQ==",null,1,"4717"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:05:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6972","1087","598.0","598.00","2","2020-01-16 10:05:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:05:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-08","2020-02-07","1087"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-16 10:05:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6972",1137,"SETTLED","A05-I207300","2020-01-16 10:05:43","2020-01-08","2","2020-01-16 10:05:43","2","2020-01-16 10:05:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:05:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7300","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-01-16 10:05:43","2","2020-01-16 10:05:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:05:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7300"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-16 10:05:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1137,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206949","2020-01-16 10:05:43",598,"2","2020-01-16 10:05:43","2","2020-01-16 10:05:43","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:05:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6949","DEPOSIT",null,"PAID","2020-01-16 10:05:43",0,"2","2020-01-16 10:05:43","2","2020-01-16 10:05:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:05:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6949","INVOICE","7300","PAID","2020-01-16 10:05:43",598,"2","2020-01-16 10:05:43","2","2020-01-16 10:05:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:07:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:11:32","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":775,"customer_code":"C180775","identity_type":"BUSINESS","identity_id":"34020046-001-09-17-5","title":"Ms","lastname":"Chan","firstname":"MC","companyname":"MC Cleaning Services Company","email":null,"tel":"94628318","address":"Room 01, 10\/F, 9 Chiu Lung Street, Central, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1342.0","renew_rent_month":"3","renew_warehousing_date":"2019-11-26","renew_room_key":"054,58836","renew_remark":"3 months contract. Storage rental paid by bank transfer on Nov 19,2019. Storage deposit $2684 transferred from agreement A14-CT194463 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196442, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"68","order_discount":[],"order_room":[{"room_id":"465","room_code":"K02(\u670d\u88dd\u5009)","retail_price":"1342.0","discounted_price":"1342.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1342,"total_discounted_price":1208,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":7248,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-26","rent_from":"2019-11-26","rent_to":"2020-05-25","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on January 15,2020. Storage deposit $2684 transferred from agreement A14-CT196442 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":7248,"final_order_total":7248,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,58836","order_product":[],"pass":true}},"first_order_id":"4463","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> K02(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1342.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1208","deposit":"0.00","total_retail_price":"1342.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:11:32","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",775,"NEW","A14-CT206973",1342,1208,0,0,"6","6",7248,7248,7248,"2020-01-16 10:11:32","0",null,null,null,"2019-11-26","2020-05-25","6 months contract. Storage rental paid by bank transfer on January 15,2020. Storage deposit $2684 transferred from agreement A14-CT196442 to this agreement.\r\n","2019-11-26","16",0,null,0,"0","2","2020-01-16 10:11:32","2","2020-01-16 10:11:32","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,58836","C180775","BUSINESS","Ms","KN0o4Y+a7D9eBYyol0+ToA==","U9yoE9KqV1v8YlRkf7Q2yg==","MC Cleaning Services Company","fQhTAe4pdA7ZW9T8RsaKdOwHzXFpF35Zujz1Ua5Ghh+FCnid73jlbGNC8fl9hppmzuJNVGyEo7kMX9B7Fum3ZQ==","Yw0RvxsqQXgLnMCpW9bMfA==",null,null,"1oSWGzyXVxdl\/ayzcZJQZwXIXyD3\/USiwt2sl6ZwQkg=",1,"4463"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:11:32","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":["6973","465","1342.0","1342.00","2","2020-01-16 10:11:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:11:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-11-26","2020-05-25","465"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-16 10:11:32","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":["6973",775,"SETTLED","A14-I207301","2020-01-16 10:11:32","2019-11-26","2","2020-01-16 10:11:32","2","2020-01-16 10:11:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:11:32","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":["7301","RENT","\u9810\u7e73\u79df\u91d1",1,1208,"MO","1",1208,"2","2020-01-16 10:11:32","2","2020-01-16 10:11:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:11:32","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":["7301","RENT","\u9810\u7e73\u79df\u91d1",2,1208,"MO","1",1208,"2","2020-01-16 10:11:32","2","2020-01-16 10:11:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:11:32","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":["7301","RENT","\u9810\u7e73\u79df\u91d1",3,1208,"MO","1",1208,"2","2020-01-16 10:11:32","2","2020-01-16 10:11:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:11:32","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":["7301","RENT","\u9810\u7e73\u79df\u91d1",4,1208,"MO","1",1208,"2","2020-01-16 10:11:32","2","2020-01-16 10:11:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:11:32","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":["7301","RENT","\u9810\u7e73\u79df\u91d1",5,1208,"MO","1",1208,"2","2020-01-16 10:11:32","2","2020-01-16 10:11:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:11:32","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":["7301","RENT","\u9810\u7e73\u79df\u91d1",6,1208,"MO","1",1208,"2","2020-01-16 10:11:32","2","2020-01-16 10:11:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:11:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7248,0,"7301"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-16 10:11:32","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":[775,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206950","2020-01-16 10:11:32",7248,"2","2020-01-16 10:11:32","2","2020-01-16 10:11:32","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:11:32","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":["6950","DEPOSIT",null,"PAID","2020-01-16 10:11:32",0,"2","2020-01-16 10:11:32","2","2020-01-16 10:11:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:11:32","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":["6950","INVOICE","7301","PAID","2020-01-16 10:11:32",7248,"2","2020-01-16 10:11:32","2","2020-01-16 10:11:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:16:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:17: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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":708,"customer_code":"C180708","identity_type":"PERSONAL","identity_id":"P208633(A)","title":"Mr","lastname":"Lam","firstname":"Henry Hang Ling","companyname":"","email":"henrylam@email.com","tel":"62300702","address":"16D, Goldwin Heights, 2 Seymour Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2434.0","renew_rent_month":"2","renew_warehousing_date":"2019-12-14","renew_room_key":"054,60414","renew_remark":"2 months contract. Storage rental paid by bank transfer on November 13, 2019. Storage deposit transferred from agreement A18-CT196028 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196386, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"868","room_code":"T12","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"},{"room_id":"867","room_code":"T11","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"32","total_retail_price":2580,"total_discounted_price":2434,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":4868,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-14","rent_from":"2019-12-14","rent_to":"2020-02-13","delivery_service":"0","remark":"2 months contract. Storage rental $4900 paid by bank transfer on January 15, 2020. Outstanding $32 will transfer to next contract. Storage deposit transferred from agreement A18-CT196386 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4868,"final_order_total":4868,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,60414","order_product":[],"pass":true}},"first_order_id":"4723","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> T12 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> T11 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"2434.0","deposit":"0","total_retail_price":"2580.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:17:18","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",708,"NEW","A18-CT206974",2580,2434,0,0,"2","2",4868,4868,4868,"2020-01-16 10:17:18","0",null,null,null,"2019-12-14","2020-02-13","2 months contract. Storage rental $4900 paid by bank transfer on January 15, 2020. Outstanding $32 will transfer to next contract. Storage deposit transferred from agreement A18-CT196386 to this agreement.\r\n","2019-12-14","32",0,null,0,"0","2","2020-01-16 10:17:18","2","2020-01-16 10:17:18","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,60414","C180708","PERSONAL","Mr","PTa9TkkuKfu4jwNnLRl7bA==","0JxYUqbNPOvgfMwVa0l0NA==","","FqEbl\/Vqia+apcWATmy0qI1jVSPGOQv+s8CLECBrdrOwYgMK2yudpo3PYRdJhmZi","NGbsOMu\/dtiprozEMsHWzw==","jy7Rom83Y2MCQ+LKg3+jO+YsY98Vm1g+iOp8lmmscAc=","ZEEfmQxu1lN8ppqH8XvTbg==",null,1,"4723"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:17:18","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":["6974","868","1290.0","1290.00","2","2020-01-16 10:17:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:17:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-14","2020-02-13","868"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-16 10:17:18","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":["6974","867","1290.0","1290.00","2","2020-01-16 10:17:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:17:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-14","2020-02-13","867"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-16 10:17:18","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":["6974",708,"SETTLED","A18-I207302","2020-01-16 10:17:18","2019-12-14","2","2020-01-16 10:17:18","2","2020-01-16 10:17:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:17:18","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":["7302","RENT","\u9810\u7e73\u79df\u91d1",1,2434,"MO","1",2434,"2","2020-01-16 10:17:18","2","2020-01-16 10:17:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:17:18","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":["7302","RENT","\u9810\u7e73\u79df\u91d1",2,2434,"MO","1",2434,"2","2020-01-16 10:17:18","2","2020-01-16 10:17:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:17:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4868,0,"7302"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-16 10:17:18","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":[708,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206951","2020-01-16 10:17:18",4868,"2","2020-01-16 10:17:18","2","2020-01-16 10:17:18","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:17:18","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":["6951","DEPOSIT",null,"PAID","2020-01-16 10:17:18",0,"2","2020-01-16 10:17:18","2","2020-01-16 10:17:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:17:18","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":["6951","INVOICE","7302","PAID","2020-01-16 10:17:18",4868,"2","2020-01-16 10:17:18","2","2020-01-16 10:17:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:20:29","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":28,"customer_code":"C150028","identity_type":"PERSONAL","identity_id":"Y095353(7)","title":"Mr","lastname":"To ","firstname":"Wai Lun","companyname":"","email":"cola73177@gmail.com","tel":"68288688","address":"Flat 1 5\/F Block B,138 Lee Chi Rd, Ap Lei Chau, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-06","renew_room_key":"055,09203","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 10, 2019. Storage deposit transferred from agreement A12-CT196265 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196654, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"28","room_code":"A28","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-06","rent_from":"2020-01-06","rent_to":"2020-02-05","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 16, 2020. Storage deposit transferred from agreement A12-CT196654 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,09203","order_product":[],"pass":true}},"first_order_id":"4760","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> A28 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:20:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",28,"NEW","A12-CT206975",1098,1038,0,0,"1","1",1038,1038,1038,"2020-01-16 10:20:29","0",null,null,null,"2020-01-06","2020-02-05","1 month contract. Storage rental paid by bank transfer on January 16, 2020. Storage deposit transferred from agreement A12-CT196654 to this agreement.\r\n","2020-01-06","16",0,null,0,"0","2","2020-01-16 10:20:29","2","2020-01-16 10:20:29","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,09203","C150028","PERSONAL","Mr","AAE9jdBh7PgsPRXGZOiUIg==","tAIAlFp2vgOGNFu\/xZc8JQ==","","13wMvUOHAYIQOl9QhDAfTbyaRJriUovwBZqC8mfSvX+GXQQxT+ZW3C\/kwUoFMflqDYYBAaV1Xkxn8PK38jLKDQ==","W9K8+8Yyeyys53D1i65fQg==","ewBy12ViY22Kmqy99fNazffSQtOA35qmZqobYk5kHUg=","o3fK6M6cHbhLBnqA0xTjOQ==",null,1,"4760"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:20:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6975","28","1098.0","1098.00","2","2020-01-16 10:20:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:20:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-06","2020-02-05","28"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-16 10:20:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6975",28,"SETTLED","A12-I207303","2020-01-16 10:20:29","2020-01-06","2","2020-01-16 10:20:29","2","2020-01-16 10:20:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:20:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7303","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-01-16 10:20:29","2","2020-01-16 10:20:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:20:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"7303"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-16 10:20:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[28,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206952","2020-01-16 10:20:29",1038,"2","2020-01-16 10:20:29","2","2020-01-16 10:20:29","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:20:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6952","DEPOSIT",null,"PAID","2020-01-16 10:20:29",0,"2","2020-01-16 10:20:29","2","2020-01-16 10:20:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 10:20:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6952","INVOICE","7303","PAID","2020-01-16 10:20:29",1038,"2","2020-01-16 10:20:29","2","2020-01-16 10:20:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:36:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:44:22","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ?, `customer_companyname` = ? where id = ?","parameters":["NEW","133,442998(Lost), 189,63749","12 months contract. Special renewal offer, $300 Maxim's Cake Voucher offered. Storage rental paid by bank transfer on September 14, 2019. Storage deposit transferred from agreement A14-CT194520 to this agreement.","2020-01-16 11:44:22","2","RAqogkelEKt1q5b\/6Neu\/g==","pSEeIFe8p9ERVZ3YPdE+Mw==","rzbP3QsigHoVB\/fz46Ev5djcLdfvXSmZ58YtWbSnh3g=","7f\/uU8u4IECXqLgP0l704Q==","1MKb\/XtmSktBlboC5PdFZAp7BVj5oFu0BsjEDCmTA9Om+T\/gIWT2lImBAZ04QKTlqA7QjOawGyI\/rKhkCgzLVA==","Hong Kong Harmonica Association Ltd",5996]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:49:31","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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":905,"customer_code":"C180905","identity_type":"PERSONAL","identity_id":"Z705900(1)","title":"Ms","lastname":"Tennant","firstname":"Michelle Gar Wai","companyname":"","email":"michelleandandy@andyknight.asia","tel":"93059523","address":"17A Garley Building, 45-53A Graham Street, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"981.0","renew_rent_month":"12","renew_warehousing_date":"2020-01-22","renew_room_key":"0005895097","renew_remark":"12 months contract. Storage rental and deposit paid by bank transfer on January 3, 2019. Storage deposit transferred from agreement A05-CT182744 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT194082, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"113","order_discount":[],"order_room":[{"room_id":"1040","room_code":"A05-038","retail_price":"1090.0","discounted_price":"1090.00","location_id":"4"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":981,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":11772,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"981","warehousing_date":"2020-01-22","rent_from":"2020-01-22","rent_to":"2021-02-21","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental and deposit paid by bank transfer on January 16, 2020. Storage deposit transferred from agreement A05-CT194082 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":981,"order_total":12753,"final_order_total":11772,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0005895097","order_product":[],"pass":true}},"first_order_id":4082,"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-038 <\/td>\r\n\t\t\t\t\t 4X3X7 <\/td>\r\n\t\t\t\t\t $1090.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":"12","total_discounted_price":"981","deposit":"0.00","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:49:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",905,"NEW","A05-CT206976",1090,981,0,0,"13","13",11772,12753,11772,"2020-01-16 11:49:31","0",null,null,null,"2020-01-22","2021-02-21","13 months contract. Special offer the 13th month free. Storage rental and deposit paid by bank transfer on January 16, 2020. Storage deposit transferred from agreement A05-CT194082 to this agreement.\r\n","2020-01-22","12",0,null,981,"981","2","2020-01-16 11:49:31","2","2020-01-16 11:49:31","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005895097","C180905","PERSONAL","Ms","PlkG8mvgCSE+Hu2jXNuwdEsHDtYEiVt+E248mdxg2Jw=","vkquzAveRo\/FCet0i9pHBg==","","eZENa2Djcd0FxBiLLmODkP8Fu4dIuDv93E2aK8BP6KPStYi\/19wtWs1LcBap5HkBa531Zt+PPX6DT1NtzX7dsg==","IXc6qneuHzyVurkZXqUwHA==","QDVDZX2rPutdYvXASm4SJSCiwvLgewCdI84OdsJWXxU=","0fyyTakx4nHwvYcx8QzTpw==",null,1,4082]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:49:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6976","1040","1090.0","1090.00","2","2020-01-16 11:49:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:49:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-22","2021-02-21","1040"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-16 11:49:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6976",905,"SETTLED","A05-I207304","2020-01-16 11:49:31","2020-01-22","2","2020-01-16 11:49:31","2","2020-01-16 11:49:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:49:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7304","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,981,"MO","1",981,"2","2020-01-16 11:49:31","2","2020-01-16 11:49:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:49:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7304","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2020-01-16 11:49:31","2","2020-01-16 11:49:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:49:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7304","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2020-01-16 11:49:31","2","2020-01-16 11:49:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:49:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7304","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2020-01-16 11:49:31","2","2020-01-16 11:49:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:49:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7304","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2020-01-16 11:49:31","2","2020-01-16 11:49:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:49:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7304","RENT","\u9810\u7e73\u79df\u91d1",7,981,"MO","1",981,"2","2020-01-16 11:49:31","2","2020-01-16 11:49:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:49:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7304","RENT","\u9810\u7e73\u79df\u91d1",8,981,"MO","1",981,"2","2020-01-16 11:49:31","2","2020-01-16 11:49:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:49:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7304","RENT","\u9810\u7e73\u79df\u91d1",9,981,"MO","1",981,"2","2020-01-16 11:49:31","2","2020-01-16 11:49:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:49:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7304","RENT","\u9810\u7e73\u79df\u91d1",10,981,"MO","1",981,"2","2020-01-16 11:49:31","2","2020-01-16 11:49:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:49:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7304","RENT","\u9810\u7e73\u79df\u91d1",11,981,"MO","1",981,"2","2020-01-16 11:49:31","2","2020-01-16 11:49:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:49:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7304","RENT","\u9810\u7e73\u79df\u91d1",12,981,"MO","1",981,"2","2020-01-16 11:49:31","2","2020-01-16 11:49:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:49:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7304","RENT","\u9810\u7e73\u79df\u91d1",13,981,"MO","1",981,"2","2020-01-16 11:49:31","2","2020-01-16 11:49:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:49:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11772,0,"7304"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-16 11:49:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[905,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206953","2020-01-16 11:49:31",11772,"2","2020-01-16 11:49:31","2","2020-01-16 11:49:31","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:49:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6953","DEPOSIT",null,"PAID","2020-01-16 11:49:31",0,"2","2020-01-16 11:49:31","2","2020-01-16 11:49:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:49:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6953","INVOICE","7304","PAID","2020-01-16 11:49:31",11772,"2","2020-01-16 11:49:31","2","2020-01-16 11:49:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:56:54","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=438&filter3=undefined","floor_plan_rent_room":[{"room_id":"644","master_room_id":"30","room_code":"M55"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \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> M55 <\/td>\r\n\t\t\t\t\t 3X3X8 <\/td>\r\n\t\t\t\t\t $775.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"BUSINESS","identity_id":"P489618(5)","title":"Ms","lastname":"Pak ","firstname":"Ah Mei","companyname":"Yu On Curtain Co","email":"","tel":"25530398","address":"\u9999\u6e2f\u4ed4\u5927\u9053201\u865f\u73cd\u5bf6\u5546\u58343\/F,20\u81f321\u865f\u92ea","pass":true,"customer_id":"438","customer_code":"C170438","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"644","room_code":"M55","retail_price":"775.0","discounted_price":"775.00","location_id":"2"}],"roughly_size":"9","total_retail_price":775,"total_discounted_price":775,"deposit":1550,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2287,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"38.00","warehousing_date":"2020-01-17","rent_from":"2020-01-17","rent_to":"2020-02-16","delivery_service":"0","remark":"1 months contract. Special offer 5% \"Rent Now\" discount. Storage rental and depoist paid by cash on January 16, 2020. Smartcard provided on January 16, 2020. ","paymethod":"CASH","paymethod2":"CASH","discount_deduct":38,"order_total":2325,"final_order_total":2287,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190, 26687","order_product":[],"pass":true}},"roughly_size":"9","total_discounted_price":"775.00","deposit":"1550.00","total_retail_price":"775.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:56:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2","438","NEW","A14-CT206977",775,775,1550,0,"1","1",2287,2325,2287,"2020-01-16 11:56:54","0",null,null,null,"2020-01-17","2020-02-16","1 months contract. Special offer 5% \"Rent Now\" discount. Storage rental and depoist paid by cash on January 16, 2020. Smartcard provided on January 16, 2020. ","2020-01-17","9",0,null,38,"38.00","2","2020-01-16 11:56:54","2","2020-01-16 11:56:54","CASH","","","","CASH","","","",null,0,"190, 26687","C170438","BUSINESS","Ms","9puP0hhCGTyWjmLYbsvUTQ==","h4sjD32CyEMKjSkmXqz3Ug==","Yu On Curtain Co","+UJOG4CCqRbsW8fPhm6qoyVCv1u\/KXfyy6WyeSzTZJQmCZ3bl2Z7kOuIsPqzvth1h6vWhWW4wqfuT\/GfLKUOBA==","l+1soRDGYfvFqU80LabDMQ==",null,null,"9eoivOG0E5N1gaVezyKwNA=="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:56:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6977","644","775.0","775.00","2","2020-01-16 11:56:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:56:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-17","2020-02-16","644"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-16 11:56:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["6977","A14-D205254","PAID",1550,0,"2020-02-16","2020-01-16 11:56:54","2020-01-16 11:56:54","2","2020-01-16 11:56:54","2","2020-01-16 11:56:54","438"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:56:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6977","438","SETTLED","A14-I207305","2020-01-16 11:56:54","2020-01-17","2","2020-01-16 11:56:54","2","2020-01-16 11:56:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:56:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7305","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,737,"MO","1",737,"2","2020-01-16 11:56:54","2","2020-01-16 11:56:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:56:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[737,0,"7305"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-16 11:56:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["438","CASH","","","","CASH","","","","PAID","P206954","2020-01-16 11:56:54",2287,"2","2020-01-16 11:56:54","2","2020-01-16 11:56:54","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:56:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6954","DEPOSIT","5254","PAID","2020-01-16 11:56:54",1550,"2","2020-01-16 11:56:54","2","2020-01-16 11:56:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 11:56:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6954","INVOICE","7305","PAID","2020-01-16 11:56:54",737,"2","2020-01-16 11:56:54","2","2020-01-16 11:56:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 12:22:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 12:50:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 13:01:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 14:22:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 14:28:07","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1449&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"644","master_room_id":"30","room_code":"M55"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1189,"customer_code":"C191189","identity_type":"PERSONAL","identity_id":"K071791(6)","title":"Mr","lastname":"LEUNG","firstname":"Wing Sun","companyname":"","email":null,"tel":"94692446","address":"Rm 1005, Tung Cheong HSE, Lei Tung Estate, Ap Lei Chau, H.K.","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1043.0","renew_rent_month":"3","renew_warehousing_date":"2019-12-01","renew_room_key":"087,62387","renew_remark":"3 months contract. Storage rental paid by cash on Oct 26, 2019. Storage deposit transferred from agreement A12-CT195552 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196226, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"433","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"8","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"8","room_code":"A08","retail_price":"1098.0","discounted_price":1043.4,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1043,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3129,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-01","rent_from":"2019-12-01","rent_to":"2020-02-29","delivery_service":"0","remark":"3 months contract. Storage rental paid by cash on January 16, 2020. Storage deposit transferred from agreement A12-CT196226 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":3129,"final_order_total":3129,"location_id":"1","branch_id":"1","company_id":"1","room_key":"087,62387","order_product":[],"pass":true}},"first_order_id":"4770","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> A08 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1043.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 14:28:07","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",1189,"NEW","A12-CT206978",1098,1043,0,0,"3","3",3129,3129,3129,"2020-01-16 14:28:07","0",null,null,null,"2019-12-01","2020-02-29","3 months contract. Storage rental paid by cash on January 16, 2020. Storage deposit transferred from agreement A12-CT196226 to this agreement.","2019-12-01","16",0,null,0,"0","2","2020-01-16 14:28:07","2","2020-01-16 14:28:07","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"087,62387","C191189","PERSONAL","Mr","EjsWd\/EiwjEkCIXHJjBD5Q==","yXKc2lCF323ApRADrjNaSg==","","xKLuiq\/VjqZXfN2hMI3Sb2oU1J125te0UL6koWQvbLUOxLwDFI4X0601DYDHPBf1\/4zd2nKH+Kw+fNjwu5qwNQ==","O2uJzrdPT3sfj2Ey0Pw2uQ==",null,"21WbSDJ2tQwDEgbOvdVyvg==",null,1,"4770"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 14:28:07","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":["6978","433","8","8","%","4.97",54.5706,"2","2020-01-16 14:28:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 14:28:07","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":["6978","8","1098.0",1043.4,"2","2020-01-16 14:28:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 14:28:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-01","2020-02-29","8"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-16 14:28:07","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":["6978",1189,"SETTLED","A12-I207306","2020-01-16 14:28:07","2019-12-01","2","2020-01-16 14:28:07","2","2020-01-16 14:28:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 14:28:07","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":["7306","RENT","\u9810\u7e73\u79df\u91d1",1,1043,"MO","1",1043,"2","2020-01-16 14:28:07","2","2020-01-16 14:28:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 14:28:07","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":["7306","RENT","\u9810\u7e73\u79df\u91d1",2,1043,"MO","1",1043,"2","2020-01-16 14:28:07","2","2020-01-16 14:28:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 14:28:07","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":["7306","RENT","\u9810\u7e73\u79df\u91d1",3,1043,"MO","1",1043,"2","2020-01-16 14:28:07","2","2020-01-16 14:28:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 14:28:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3129,0,"7306"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-16 14:28:07","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":[1189,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P206955","2020-01-16 14:28:07",3129,"2","2020-01-16 14:28:07","2","2020-01-16 14:28:07","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 14:28:07","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":["6955","DEPOSIT",null,"PAID","2020-01-16 14:28:07",0,"2","2020-01-16 14:28:07","2","2020-01-16 14:28:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 14:28:07","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":["6955","INVOICE","7306","PAID","2020-01-16 14:28:07",3129,"2","2020-01-16 14:28:07","2","2020-01-16 14:28:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 14:59:28","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1449&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"644","master_room_id":"30","room_code":"M55"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":506,"customer_code":"C170506","identity_type":"PERSONAL","identity_id":"D435016(3)","title":"Mr","lastname":"Kwok","firstname":"Chi Kong","companyname":"","email":"kwokchikong@gmail.com","tel":"91520880","address":"\u9d28\u8137\u6d32\u5229\u679d\u9053145\u865f\u91d1\u767c\u5927\u5ec85\u6a13F\u5ba4","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1139.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-17","renew_room_key":"054,46844","renew_remark":"6 months contract. Storage rental paid by PPS on July 15, 2019. Storage deposit transferred from agreement A12-CT194179 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195485, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"113","room_code":"B61","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1286,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1286,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-17","rent_from":"2020-01-17","rent_to":"2020-02-16","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on January 15, 2020. Storage deposit transferred from agreement A12-CT195485 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1286,"final_order_total":1286,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,46844","order_product":[],"pass":true}},"first_order_id":"4179","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> B61 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/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":"20","total_discounted_price":"1286.00","deposit":"0.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 14:59:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",506,"NEW","A12-CT206979",1528,1286,0,0,"1","1",1286,1286,1286,"2020-01-16 14:59:28","0",null,null,null,"2020-01-17","2020-02-16","1 month contract. Storage rental paid by PPS on January 15, 2020. Storage deposit transferred from agreement A12-CT195485 to this agreement.\r\n","2020-01-17","20",0,null,0,"0","2","2020-01-16 14:59:28","2","2020-01-16 14:59:28","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,46844","C170506","PERSONAL","Mr","m+azv2CUGWm2lPm4xNx9sA==","+pNULpsInm3siHASV0hIrg==","","LwVAteVJ0ZkV+zmR7qIDhOZ88Sc7Q+u3tsoHaiRzz2YCnm7wtowmDZcdUdskzm9A","22F8u0roh3XfvK0e6+ag3g==","WR6bE6RUwKqp5feySv5edgfk8AMEkZpUrE0\/8O+jORg=","Rmwt5dKGhWq\/pC\/sJ3hH+A==",null,1,"4179"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 14:59:28","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":["6979","113","1528.0","1528.00","2","2020-01-16 14:59:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 14:59:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-17","2020-02-16","113"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-16 14:59:28","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":["6979",506,"SETTLED","A12-I207307","2020-01-16 14:59:28","2020-01-17","2","2020-01-16 14:59:28","2","2020-01-16 14:59:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 14:59:28","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":["7307","RENT","\u9810\u7e73\u79df\u91d1",1,1286,"MO","1",1286,"2","2020-01-16 14:59:28","2","2020-01-16 14:59:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 14:59:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1286,0,"7307"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-16 14:59:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[506,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P206956","2020-01-16 14:59:28",1286,"2","2020-01-16 14:59:28","2","2020-01-16 14:59:28","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 14:59:28","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":["6956","DEPOSIT",null,"PAID","2020-01-16 14:59:28",0,"2","2020-01-16 14:59:28","2","2020-01-16 14:59:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 14:59:28","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":["6956","INVOICE","7307","PAID","2020-01-16 14:59:28",1286,"2","2020-01-16 14:59:28","2","2020-01-16 14:59:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:03:14","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1449&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"644","master_room_id":"30","room_code":"M55"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":506,"customer_code":"C170506","identity_type":"PERSONAL","identity_id":"D435016(3)","title":"Mr","lastname":"Kwok","firstname":"Chi Kong","companyname":"","email":"kwokchikong@gmail.com","tel":"91520880","address":"\u9d28\u8137\u6d32\u5229\u679d\u9053145\u865f\u91d1\u767c\u5927\u5ec85\u6a13F\u5ba4","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-15","renew_room_key":"054,46844","renew_remark":"1 month contract. Storage rental paid by PPS on December 18, 2019. Storage deposit transferred from agreement A12-CT196446 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196744, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"243","room_code":"D47","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":998,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-15","rent_from":"2020-01-15","rent_to":"2020-02-14","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on January 15, 2020. Storage deposit transferred from agreement A12-CT196744 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":998,"final_order_total":998,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,46844","order_product":[],"pass":true}},"first_order_id":"4192","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> D47 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"998.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:03:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",506,"NEW","A12-CT206980",998,998,0,0,"1","1",998,998,998,"2020-01-16 15:03:15","0",null,null,null,"2020-01-15","2020-02-14","1 month contract. Storage rental paid by PPS on January 15, 2020. Storage deposit transferred from agreement A12-CT196744 to this agreement.","2020-01-15","12",0,null,0,"0","2","2020-01-16 15:03:14","2","2020-01-16 15:03:14","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,46844","C170506","PERSONAL","Mr","m+azv2CUGWm2lPm4xNx9sA==","+pNULpsInm3siHASV0hIrg==","","LwVAteVJ0ZkV+zmR7qIDhOZ88Sc7Q+u3tsoHaiRzz2YCnm7wtowmDZcdUdskzm9A","22F8u0roh3XfvK0e6+ag3g==","WR6bE6RUwKqp5feySv5edgfk8AMEkZpUrE0\/8O+jORg=","Rmwt5dKGhWq\/pC\/sJ3hH+A==",null,1,"4192"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:03:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6980","243","998.0","998.00","2","2020-01-16 15:03:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:03:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-15","2020-02-14","243"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-16 15:03:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6980",506,"SETTLED","A12-I207308","2020-01-16 15:03:14","2020-01-15","2","2020-01-16 15:03:14","2","2020-01-16 15:03:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:03:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7308","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-01-16 15:03:14","2","2020-01-16 15:03:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:03:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"7308"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-16 15:03:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[506,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P206957","2020-01-16 15:03:14",998,"2","2020-01-16 15:03:14","2","2020-01-16 15:03:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:03:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6957","DEPOSIT",null,"PAID","2020-01-16 15:03:14",0,"2","2020-01-16 15:03:14","2","2020-01-16 15:03:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:03:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6957","INVOICE","7308","PAID","2020-01-16 15:03:14",998,"2","2020-01-16 15:03:14","2","2020-01-16 15:03:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:08:05","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1449&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"644","master_room_id":"30","room_code":"M55"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":716,"customer_code":"C180716","identity_type":"PERSONAL","identity_id":"D392231(7)","title":"Mr","lastname":"Yip","firstname":"Andrew","companyname":"","email":"andrewyip77@gmail.com","tel":"94016146","address":"Room 1203, Block G, Aberdeen Centre, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1857.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-18","renew_room_key":"055,30147","renew_remark":"6 months contract. Storage rental paid by bank transfer on July 09, 2019. Storage deposit transferred from agreement A18-CT194090 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195437, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"100","order_discount":[],"order_room":[{"room_id":"838","room_code":"R12","retail_price":"1195.0","discounted_price":"1195.00","location_id":"3"},{"room_id":"934","room_code":"V08(\u670d\u88dd\u5009)","retail_price":"867.0","discounted_price":"867.00","location_id":"3"}],"roughly_size":"22.2","total_retail_price":2062,"total_discounted_price":1959,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":5877,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-18","rent_from":"2020-01-18","rent_to":"2020-04-17","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on January 16, 2020. Storage deposit transferred from agreement A18-CT195437 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5877,"final_order_total":5877,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,30147","order_product":[],"pass":true}},"first_order_id":"4090","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> R12 <\/td>\r\n\t\t\t\t\t 5X3X7 <\/td>\r\n\t\t\t\t\t $1195.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> V08(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 3X2.4X7 <\/td>\r\n\t\t\t\t\t $867.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":"22.2","total_discounted_price":"1959.00","deposit":"0.00","total_retail_price":"2062.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:08:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",716,"NEW","A18-CT206981",2062,1959,0,0,"3","3",5877,5877,5877,"2020-01-16 15:08:05","0",null,null,null,"2020-01-18","2020-04-17","3 months contract. Storage rental paid by bank transfer on January 16, 2020. Storage deposit transferred from agreement A18-CT195437 to this agreement.\r\n","2020-01-18","22.2",0,null,0,"0","2","2020-01-16 15:08:05","2","2020-01-16 15:08:05","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,30147","C180716","PERSONAL","Mr","2FxALZl389hi2eIQ+u33ig==","H9gmHz05\/Te4s1\/V+q8XVg==","","LvSBVhWHClo8X0SdpQ\/z0Vm9cH3uPu2n5RZa\/ZWk+vBEJb0O4ILpKVsbWgeeI3OwnHoFjJAJpDiXz4q4Zg2+SQ==","4bi0BNJiTnlPHH7nNkjZ5Q==","e0KfDu\/Fq2XUSMSGHnzxHWZwwhnNrGeoaLxny8k9SRs=","LRvWqFR3Fluggivc72H9+Q==",null,1,"4090"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:08:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6981","838","1195.0","1195.00","2","2020-01-16 15:08:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:08:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-18","2020-04-17","838"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-16 15:08:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6981","934","867.0","867.00","2","2020-01-16 15:08:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:08:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-18","2020-04-17","934"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-16 15:08:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6981",716,"SETTLED","A18-I207309","2020-01-16 15:08:05","2020-01-18","2","2020-01-16 15:08:05","2","2020-01-16 15:08:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:08:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7309","RENT","\u9810\u7e73\u79df\u91d1",1,1959,"MO","1",1959,"2","2020-01-16 15:08:05","2","2020-01-16 15:08:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:08:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7309","RENT","\u9810\u7e73\u79df\u91d1",2,1959,"MO","1",1959,"2","2020-01-16 15:08:05","2","2020-01-16 15:08:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:08:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7309","RENT","\u9810\u7e73\u79df\u91d1",3,1959,"MO","1",1959,"2","2020-01-16 15:08:05","2","2020-01-16 15:08:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:08:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5877,0,"7309"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-16 15:08:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[716,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206958","2020-01-16 15:08:05",5877,"2","2020-01-16 15:08:05","2","2020-01-16 15:08:05","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:08:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6958","DEPOSIT",null,"PAID","2020-01-16 15:08:05",0,"2","2020-01-16 15:08:05","2","2020-01-16 15:08:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:08:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6958","INVOICE","7309","PAID","2020-01-16 15:08:05",5877,"2","2020-01-16 15:08:05","2","2020-01-16 15:08:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:10:02","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1449&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"644","master_room_id":"30","room_code":"M55"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":705,"customer_code":"C180705","identity_type":"PERSONAL","identity_id":"D634371(7)","title":"Ms","lastname":"Chui","firstname":"Lai Yung","companyname":"","email":"phyllis_chui@hotmail.com","tel":"91736789","address":"Flat 2210, 22\/F, Ka Sing House, Ka Lung Court, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"568.0","renew_rent_month":"3","renew_warehousing_date":"2019-12-08","renew_room_key":"052,47598","renew_remark":"3 months contract. Storage rental paid by bank transfer on October 8, 2019. Storage deposit transferred from agreement A14-CT195854 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196098, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"604","room_code":"M15","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":568,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":1704,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-08","rent_from":"2019-12-08","rent_to":"2020-03-07","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on January 16, 2020. Storage deposit transferred from agreement A14-CT196098 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1704,"final_order_total":1704,"location_id":"2","branch_id":"1","company_id":"1","room_key":"052,47598","order_product":[],"pass":true}},"first_order_id":"4834","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> M15 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"568.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:10:03","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",705,"NEW","A14-CT206982",598,568,0,0,"3","3",1704,1704,1704,"2020-01-16 15:10:03","0",null,null,null,"2019-12-08","2020-03-07","3 months contract. Storage rental paid by bank transfer on January 16, 2020. Storage deposit transferred from agreement A14-CT196098 to this agreement.\r\n","2019-12-08","12",0,null,0,"0","2","2020-01-16 15:10:02","2","2020-01-16 15:10:02","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,47598","C180705","PERSONAL","Ms","DSDoIJdA1iSvaQSFEMLkrQ==","ZaJ4WWFpE1BIKwbxOgpKQw==","","Ibpoa9KDqfayvnfwHSfrRExsnqOwwA02EXh1FMBszbs6nHnsdgdQ\/DAKgp0c26652gxYpikPF9cm8gWWhheXmLBH2vNrWkJqKzumRd07a4g=","JWYsADtdQzjREaQitSWwoQ==","710wSNxhpYoauRyFH3TC2ALh4TQwdVsdy3wW3+fclqI=","CxjZrzHq1acE1R9XAnqEug==",null,1,"4834"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:10:03","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":["6982","604","598.0","598.00","2","2020-01-16 15:10:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:10:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-08","2020-03-07","604"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-16 15:10:03","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":["6982",705,"SETTLED","A14-I207310","2020-01-16 15:10:02","2019-12-08","2","2020-01-16 15:10:02","2","2020-01-16 15:10:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:10:03","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":["7310","RENT","\u9810\u7e73\u79df\u91d1",1,568,"MO","1",568,"2","2020-01-16 15:10:02","2","2020-01-16 15:10:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:10:03","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":["7310","RENT","\u9810\u7e73\u79df\u91d1",2,568,"MO","1",568,"2","2020-01-16 15:10:02","2","2020-01-16 15:10:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:10:03","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":["7310","RENT","\u9810\u7e73\u79df\u91d1",3,568,"MO","1",568,"2","2020-01-16 15:10:02","2","2020-01-16 15:10:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:10:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1704,0,"7310"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-16 15:10:03","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":[705,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206959","2020-01-16 15:10:02",1704,"2","2020-01-16 15:10:02","2","2020-01-16 15:10:02","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:10:03","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":["6959","DEPOSIT",null,"PAID","2020-01-16 15:10:02",0,"2","2020-01-16 15:10:02","2","2020-01-16 15:10:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:10:03","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":["6959","INVOICE","7310","PAID","2020-01-16 15:10:02",1704,"2","2020-01-16 15:10:02","2","2020-01-16 15:10:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:20:47","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1449&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"644","master_room_id":"30","room_code":"M55"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1276,"customer_code":"C191276","identity_type":"BUSINESS","identity_id":"67226140-002-02-19-5","title":"Ms","lastname":"Kwok","firstname":"Wancie","companyname":"Happy Concepts Asia Limited","email":"wancie@happy-concepts.com","tel":"92420692","address":"Room 2107, 21\/F, Fullagar Ind Building, 234 Aberdeen Main Road, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2161.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-27","renew_room_key":"076,47844","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 2, 2019. Storage deposit $4322 transferred form agreement A16-CT196322 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT196598, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"206","order_discount":[],"order_room":[{"room_id":"1645","room_code":"A16-154","retail_price":"2161.0","discounted_price":"2161.00","location_id":"7"}],"roughly_size":"28","total_retail_price":2161,"total_discounted_price":2161,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2161,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-27","rent_from":"2019-12-27","rent_to":"2020-01-26","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 15, 2020. Storage deposit $4322 transferred form agreement A16-CT196598 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2161,"final_order_total":2161,"location_id":"7","branch_id":"1","company_id":"1","room_key":"076,47844","order_product":[],"pass":true}},"first_order_id":"5067","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A16-154 <\/td>\r\n\t\t\t\t\t 4X7X7 <\/td>\r\n\t\t\t\t\t $2161.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"28","total_discounted_price":"2161.0","deposit":"0","total_retail_price":"2161.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:20:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","7",1276,"NEW","A16-CT206983",2161,2161,0,0,"1","1",2161,2161,2161,"2020-01-16 15:20:47","0",null,null,null,"2019-12-27","2020-01-26","1 month contract. Storage rental paid by bank transfer on January 15, 2020. Storage deposit $4322 transferred form agreement A16-CT196598 to this agreement. \r\n","2019-12-27","28",0,null,0,"0","2","2020-01-16 15:20:47","2","2020-01-16 15:20:47","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,47844","C191276","BUSINESS","Ms","UnAuVv7vF8jhvFzl3xSCmg==","+pNULpsInm3siHASV0hIrg==","Happy Concepts Asia Limited","Vz2ejyARH5zcH5e4QlFSq51bZp23xF3kJ5RJpCNl57lAk8+AWULPwqnFcIQcG5ZBdUxERR9syaCIcEtZgd+HqAaztaF6lZ3cM+VjkllU2B0=","Gfho0rh19G9JYZxq3cLhUw==","YWYp2e5RTnHURnlliiVCoZfRQjqOlQ4Jschx6rAjv1w=",null,"emH+RX7ttsZFOmRnXIxwP9GHFJD2VTz2ibaI3AjX2ZU=",1,"5067"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:20:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6983","1645","2161.0","2161.00","2","2020-01-16 15:20:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:20:47","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-27","2020-01-26","1645"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-16 15:20:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6983",1276,"SETTLED","A16-I207311","2020-01-16 15:20:47","2019-12-27","2","2020-01-16 15:20:47","2","2020-01-16 15:20:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:20:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7311","RENT","\u9810\u7e73\u79df\u91d1",1,2161,"MO","1",2161,"2","2020-01-16 15:20:47","2","2020-01-16 15:20:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:20:47","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2161,0,"7311"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-16 15:20:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1276,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206960","2020-01-16 15:20:47",2161,"2","2020-01-16 15:20:47","2","2020-01-16 15:20:47","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:20:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6960","DEPOSIT",null,"PAID","2020-01-16 15:20:47",0,"2","2020-01-16 15:20:47","2","2020-01-16 15:20:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:20:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6960","INVOICE","7311","PAID","2020-01-16 15:20:47",2161,"2","2020-01-16 15:20:47","2","2020-01-16 15:20:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:54:09","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1449&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"543","master_room_id":"68","room_code":"L21"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \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> L21(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1342.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"K332829(5)","title":"Ms","lastname":"POON","firstname":"Wai Fong","companyname":"","email":"vanessalamwy@hotmail.com","tel":"67126261","address":"Room 5, 15\/F, Kong Cheung Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true,"customer_id":"1481","customer_code":"C191481","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"543","room_code":"L21(\u670d\u88dd\u5009)","retail_price":"1342.0","discounted_price":"1342.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1342,"total_discounted_price":1208,"deposit":2684,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":16460,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1928.00","warehousing_date":"2020-01-06","rent_from":"2020-01-06","rent_to":"2021-02-05","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free and 5% \"Rent Now\" discount. Storage rental and deposit paid by EPS on December 30, 2019. Smartcard and padlock provided on December 30, 2019. \r\nAll payment transferred from A14-CT196809. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":1928,"order_total":18388,"final_order_total":16460,"location_id":"2","branch_id":"1","company_id":"1","room_key":"189,28747","order_product":[],"pass":true}},"roughly_size":"16","total_discounted_price":"1208.00","deposit":"2684.00","total_retail_price":"1342.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:54:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2","1481","NEW","A14-CT206984",1342,1208,2684,0,"13","13",16460,18388,16460,"2020-01-16 15:54:10","0",null,null,null,"2020-01-06","2021-02-05","13 months contract. Special offer the 13th month free and 5% \"Rent Now\" discount. Storage rental and deposit paid by EPS on December 30, 2019. Smartcard and padlock provided on December 30, 2019. \r\nAll payment transferred from A14-CT196809. ","2020-01-06","16",0,null,1928,"1928.00","2","2020-01-16 15:54:09","2","2020-01-16 15:54:09","EPS","","","","EPS","","","",null,0,"189,28747","C191481","PERSONAL","Ms","nTGfHLdEIudAzJAvttiE\/g==","nQ0P3urF7MQlYHXgjzt5kA==","","yxS3w8ydgZH0MWUcw0HMqoJCtRPPlhXlEKRtNR7F1r1PLmJ4\/ebuwJvX17ubYKoICaFjR99rfrmzd8DDq47z0kNveYzH4BEwVPzFM7tlzEw=","F22NhsX0kJs0Lq\/6E61WEQ==","w6nqbYp32KQPR9iltH1kvGq1dJJ1F8pYDVS81YkNHVM=","5geghcdcQB0F29vF5+CGiA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:54:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6984","543","1342.0","1342.00","2","2020-01-16 15:54:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:54:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-06","2021-02-05","543"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-16 15:54:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["6984","A14-D205255","PAID",2684,0,"2021-02-05","2020-01-16 15:54:09","2020-01-16 15:54:09","2","2020-01-16 15:54:09","2","2020-01-16 15:54:09","1481"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:54:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6984","1481","SETTLED","A14-I207312","2020-01-16 15:54:09","2020-01-06","2","2020-01-16 15:54:09","2","2020-01-16 15:54:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:54:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7312","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-01-16 15:54:09","2","2020-01-16 15:54:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:54:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7312","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,488,"MO","1",488,"2","2020-01-16 15:54:09","2","2020-01-16 15:54:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:54:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7312","RENT","\u9810\u7e73\u79df\u91d1",3,1208,"MO","1",1208,"2","2020-01-16 15:54:09","2","2020-01-16 15:54:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:54:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7312","RENT","\u9810\u7e73\u79df\u91d1",4,1208,"MO","1",1208,"2","2020-01-16 15:54:09","2","2020-01-16 15:54:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:54:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7312","RENT","\u9810\u7e73\u79df\u91d1",5,1208,"MO","1",1208,"2","2020-01-16 15:54:09","2","2020-01-16 15:54:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:54:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7312","RENT","\u9810\u7e73\u79df\u91d1",6,1208,"MO","1",1208,"2","2020-01-16 15:54:09","2","2020-01-16 15:54:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:54:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7312","RENT","\u9810\u7e73\u79df\u91d1",7,1208,"MO","1",1208,"2","2020-01-16 15:54:09","2","2020-01-16 15:54:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:54:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7312","RENT","\u9810\u7e73\u79df\u91d1",8,1208,"MO","1",1208,"2","2020-01-16 15:54:09","2","2020-01-16 15:54:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:54:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7312","RENT","\u9810\u7e73\u79df\u91d1",9,1208,"MO","1",1208,"2","2020-01-16 15:54:09","2","2020-01-16 15:54:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:54:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7312","RENT","\u9810\u7e73\u79df\u91d1",10,1208,"MO","1",1208,"2","2020-01-16 15:54:09","2","2020-01-16 15:54:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:54:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7312","RENT","\u9810\u7e73\u79df\u91d1",11,1208,"MO","1",1208,"2","2020-01-16 15:54:09","2","2020-01-16 15:54:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:54:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7312","RENT","\u9810\u7e73\u79df\u91d1",12,1208,"MO","1",1208,"2","2020-01-16 15:54:09","2","2020-01-16 15:54:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:54:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7312","RENT","\u9810\u7e73\u79df\u91d1",13,1208,"MO","1",1208,"2","2020-01-16 15:54:09","2","2020-01-16 15:54:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:54:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13776,0,"7312"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-16 15:54:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1481","EPS","","","","EPS","","","","PAID","P206961","2020-01-16 15:54:09",16460,"2","2020-01-16 15:54:09","2","2020-01-16 15:54:09","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:54:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6961","DEPOSIT","5255","PAID","2020-01-16 15:54:09",2684,"2","2020-01-16 15:54:09","2","2020-01-16 15:54:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 15:54:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6961","INVOICE","7312","PAID","2020-01-16 15:54:09",13776,"2","2020-01-16 15:54:09","2","2020-01-16 15:54:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 16:11:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 16:30:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 16:55:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 17:00:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 17:05:50","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1021&filter3=undefined","floor_plan_rent_room":[{"room_id":"543","master_room_id":"68","room_code":"L21"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":823,"customer_code":"C180823","identity_type":"BUSINESS","identity_id":"39661261","title":"Mr","lastname":"Milan Martinez","firstname":"Alejandro","companyname":"La Nao Group Limited","email":"a.milan@la-nao.com","tel":"90212010","address":"13A, Trust Tower, 68 Johnston Road, Wanchai, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2318.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-13","renew_room_key":"055,09251","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 16, 2019. Storage deposit transferred from agreement A14-CT196505 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196706, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"794","room_code":"K60","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"515","room_code":"K52","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":2318,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2318,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-13","rent_from":"2019-12-13","rent_to":"2020-01-12","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 16, 2020. Storage deposit transferred from agreement A14-CT196706 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2318,"final_order_total":2318,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,09251","order_product":[],"pass":true}},"first_order_id":"4785","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> K60 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> K52 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"2318.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 17:05:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",823,"NEW","A14-CT206985",2196,2318,0,0,"1","1",2318,2318,2318,"2020-01-16 17:05:51","0",null,null,null,"2019-12-13","2020-01-12","1 month contract. Storage rental paid by bank transfer on January 16, 2020. Storage deposit transferred from agreement A14-CT196706 to this agreement.","2019-12-13","32",0,null,0,"0","2","2020-01-16 17:05:50","2","2020-01-16 17:05:50","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,09251","C180823","BUSINESS","Mr","Ltuw0GNYtUHvg5xq\/qUHZw==","B0t4iVfZVAQdLpfngFJQ9g==","La Nao Group Limited","ogXiJSz6bxnQX1arPQzS4HtoujvXU7DtPI6iXMqgmibwYxgUDD+7IDSdp7zHKT1WsucqNnxkVRDDkoVXniYCDA==","oMTdQIHVXIpTgMmFZOwTlA==","toRvij1IyfmFV4d7mZnp4cg+UZM6Nv9c2C6kHmvTa8c=",null,"mWmgEjucdLaH5rglf7tExg==",1,"4785"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 17:05:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6985","794","1098.0","1098.00","2","2020-01-16 17:05:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 17:05:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-13","2020-01-12","794"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-16 17:05:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6985","515","1098.0","1098.00","2","2020-01-16 17:05:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 17:05:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-13","2020-01-12","515"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-16 17:05:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6985",823,"SETTLED","A14-I207313","2020-01-16 17:05:50","2019-12-13","2","2020-01-16 17:05:50","2","2020-01-16 17:05:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 17:05:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7313","RENT","\u9810\u7e73\u79df\u91d1",1,2318,"MO","1",2318,"2","2020-01-16 17:05:50","2","2020-01-16 17:05:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 17:05:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2318,0,"7313"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-16 17:05:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[823,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206962","2020-01-16 17:05:50",2318,"2","2020-01-16 17:05:50","2","2020-01-16 17:05:50","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 17:05:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6962","DEPOSIT",null,"PAID","2020-01-16 17:05:50",0,"2","2020-01-16 17:05:50","2","2020-01-16 17:05:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 17:05:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6962","INVOICE","7313","PAID","2020-01-16 17:05:50",2318,"2","2020-01-16 17:05:50","2","2020-01-16 17:05:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-16 17:26:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****