{"created_at":"2020-07-28 10:06:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 10:19:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 10:35:09","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","076,49779","1 month contact. Storage rental paid by bank transfer on April 7, 2020. Storage deposit $4376 transferred from agreement A14-CT207618 to this agreement. \r\n","2020-07-28 10:35:09","2","vCxOlXQuvOQaoL822H2o\/Q==","ksGbPh21wXxn8OkaY6lLfw==","xymPZ9tGDPharD71TGnWbw==","5LxpXhLiPD2WSK4Uthz9ZguOwD3uISNO\/bHbCtYORGGqf+NrT1VVRVXl3hOjxM0EWwptox0+0GANo7EzFCARudS+BCU3VcsM6kJM+VZKL0U=",7797]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 10:35:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 10:35:47","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","076,49779","2\u500b\u6708\u5408\u7d04. \u79df\u91d1\u57282020\u5e744\u67088\u65e5\u4ee5\u73fe\u91d1\u7e73\u4ed8.\u820a\u5408\u7d04\u7de8\u865f: A14-CT206882, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $4376.0\r\n2 months contract. Storage rental paid by cash on April 8, 2020. Storage deposit $4376 transferred from agreement A14-CT206882 to this agreement.\r\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT206882, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","2020-07-28 10:35:47","2","vCxOlXQuvOQaoL822H2o\/Q==","ksGbPh21wXxn8OkaY6lLfw==","xymPZ9tGDPharD71TGnWbw==","5LxpXhLiPD2WSK4Uthz9ZguOwD3uISNO\/bHbCtYORGGqf+NrT1VVRVXl3hOjxM0EWwptox0+0GANo7EzFCARudS+BCU3VcsM6kJM+VZKL0U=",7618]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 10:38:11","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 11:07:48","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","floor_plan_rent_room":[{"room_id":"1033","master_room_id":"108","room_code":"A05-031"}],"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>
A05-031 <\/td>\r\n\t\t\t\t\t	3X3X7 <\/td>\r\n\t\t\t\t\t	$1006.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"C434315(6)","title":"Mr","lastname":"LEUNG","firstname":"Wai Chuen","companyname":"","email":"raymmce@yahoo.co.jp","tel":"98610831","address":"OI FAI HOUSE 1009, YAU OI ESTATE, TUEN MUN, N.T.","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"231","master_room_id":"108","discount_type":"%","price":"1006.00","disocunted_price":"905.40","discount":"10.00","monthly_deduct":100.6,"room_id":"1033","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1033","room_code":"A05-031","retail_price":"1006.0","discounted_price":905.4,"location_id":"4"}],"roughly_size":"9","total_retail_price":1006,"total_discounted_price":906,"deposit":2012,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6239,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1209.00","warehousing_date":"2020-08-10","rent_from":"2020-08-10","rent_to":"2021-02-09","delivery_service":"0","remark":"6 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit $2012 paid by EPS on Jul 28, 2020. Smart card and padlock provided on the same day.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":1209,"order_total":7448,"final_order_total":6239,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0012375851","order_product":[],"pass":true}},"roughly_size":"9","total_discounted_price":"906.00","deposit":"2012.00","total_retail_price":"1006.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 11:07:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201692","PERSONAL","Mr","cLpFdlAWANk1IQAd4a0hHQ==","yXKc2lCF323ApRADrjNaSg==","","3dV1Ff7fK2dgJw\/6LMxaJw==","Uh9tf+RkHxyXvgHKJYb9FWc9lOPREy+0wRKAYNnDAu0=","ECywDWa4UO3FppFx5NGtRlMcz\/lqbcslR7PgEp\/74baekne5alOWpjGI9jzJ0iD3I9j3raqtS+Av279Trt0HPA==","yuR9rwyHR2uwP9mJx8uSGA==",null,"Uh9tf+RkHxyXvgHKJYb9FWc9lOPREy+0wRKAYNnDAu0=","uHs+TJ6OL9UpzBvFgAtAgQ==","2","2020-07-28 11:07:48","2","2020-07-28 11:07:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 11:07:50","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","4",1692,"NEW","A05-CT208480",1006,906,2012,0,"6","6",6239,7448,6239,"2020-07-28 11:07:50","0",null,null,null,"2020-08-10","2021-02-09","6 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit $2012 paid by EPS on Jul 28, 2020. Smart card and padlock provided on the same day.","2020-08-10","9",0,null,1209,"1209.00","2","2020-07-28 11:07:48","2","2020-07-28 11:07:48","EPS","","","","EPS","","","",null,0,"'0012375851","C201692","PERSONAL","Mr","cLpFdlAWANk1IQAd4a0hHQ==","yXKc2lCF323ApRADrjNaSg==","","ECywDWa4UO3FppFx5NGtRlMcz\/lqbcslR7PgEp\/74baekne5alOWpjGI9jzJ0iD3I9j3raqtS+Av279Trt0HPA==","3dV1Ff7fK2dgJw\/6LMxaJw==","Uh9tf+RkHxyXvgHKJYb9FWc9lOPREy+0wRKAYNnDAu0=","yuR9rwyHR2uwP9mJx8uSGA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 11:07:50","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":["8480","231","108","1033","%","10.00",100.6,"2","2020-07-28 11:07:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 11:07:50","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":["8480","1033","1006.0",905.4,"2","2020-07-28 11:07:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 11:07:50","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-08-10","2021-02-09","1033"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-28 11:07:50","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":["8480","A05-D205575","PAID",2012,0,"2021-02-09","2020-07-28 11:07:48","2020-07-28 11:07:48","2","2020-07-28 11:07:48","2","2020-07-28 11:07:48",1692]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 11:07:50","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":["8480",1692,"SETTLED","A05-I208809","2020-07-28 11:07:48","2020-08-10","2","2020-07-28 11:07:48","2","2020-07-28 11:07:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 11:07:50","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":["8809","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-07-28 11:07:48","2","2020-07-28 11:07:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 11:07:50","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":["8809","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,603,"MO","1",603,"2","2020-07-28 11:07:48","2","2020-07-28 11:07:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 11:07:50","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":["8809","RENT","\u9810\u7e73\u79df\u91d1",3,906,"MO","1",906,"2","2020-07-28 11:07:48","2","2020-07-28 11:07:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 11:07:50","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":["8809","RENT","\u9810\u7e73\u79df\u91d1",4,906,"MO","1",906,"2","2020-07-28 11:07:48","2","2020-07-28 11:07:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 11:07:50","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":["8809","RENT","\u9810\u7e73\u79df\u91d1",5,906,"MO","1",906,"2","2020-07-28 11:07:48","2","2020-07-28 11:07:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 11:07:50","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":["8809","RENT","\u9810\u7e73\u79df\u91d1",6,906,"MO","1",906,"2","2020-07-28 11:07:48","2","2020-07-28 11:07:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 11:07:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4227,0,"8809"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-28 11:07:50","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":[1692,"EPS","","","","EPS","","","","PAID","P208452","2020-07-28 11:07:48",6239,"2","2020-07-28 11:07:48","2","2020-07-28 11:07:48","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 11:07:50","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":["8452","DEPOSIT","5575","PAID","2020-07-28 11:07:48",2012,"2","2020-07-28 11:07:48","2","2020-07-28 11:07:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 11:07:50","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":["8452","INVOICE","8809","PAID","2020-07-28 11:07:48",4227,"2","2020-07-28 11:07:48","2","2020-07-28 11:07:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 12:19:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 12:19:48","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 12:21:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 12:31:18","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 14:42:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 14:55:51","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 15:01:09","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","0005023985","3 months contract. Storage rental paid by bank transfer on July 5, 2019. Storage deposit transferred from agreement A05-CT195088 to this agreement.","2020-07-28 15:01:09","2","pxHPaJw0GdFrs4nn\/MH1Gw==","qIXB5hqnTN8z1QolDr\/79rOh9a5c4yb50dwbn+3PB3Q=","pnWUkmmclGMfCTT8WKc7XA==","e+fBbnu358aXtd45CicivEOl2q1z7G\/UAAgzgXOUxPWXe0kaEWblPY15Aq8uDQvXa+t+jz+eHir0ukAeQ07G0yw9W\/B+LkyKTKdzMkUBTCdjZ42LGishpXgAnp81PioX",5388]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 15:43:21","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"57","master_room_id":"10","room_code":"B05"}],"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> U05 <\/td>\r\n\t\t\t\t\t 4X5X7 <\/td>\r\n\t\t\t\t\t $1605.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":717,"customer_code":"C180717","identity_type":"PERSONAL","identity_id":"Y323150(8)","title":"Mr","lastname":"Amerine","firstname":"Julian Steven Anthony","companyname":"","email":"julian.amerine@gmail.com","tel":"97302001","address":"Flat 503, Wah Oi House, Wah Kwai Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1605.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-14","renew_room_key":"055,16508","renew_remark":"1 month contract. Storage rental paid by bank transfer on May 31, 2020. Storage deposit transferred from agreement A18-CT207727 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207998, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"78","order_discount":[],"order_room":[{"room_id":"904","room_code":"U05","retail_price":"1605.0","discounted_price":"1605.00","location_id":"3"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1605,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1605,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-14","rent_from":"2020-06-14","rent_to":"2020-07-13","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Jul 28, 2020. Storage deposit transferred from agreement A18-CT207998 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1605,"final_order_total":1605,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,16508","order_product":[],"pass":true}},"first_order_id":"4839","roughly_size":"20","total_discounted_price":"1605.0","deposit":"0","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 15:43:22","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",717,"NEW","A18-CT208481",1605,1605,0,0,"1","1",1605,1605,1605,"2020-07-28 15:43:22","0",null,null,null,"2020-06-14","2020-07-13","1 month contract. Storage rental paid by bank transfer on Jul 28, 2020. Storage deposit transferred from agreement A18-CT207998 to this agreement.\r\n","2020-06-14","20",0,null,0,"0","2","2020-07-28 15:43:21","2","2020-07-28 15:43:21","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,16508","C180717","PERSONAL","Mr","ilVMtNKmhMv6VE7c5KYxeztG+MwYykSvCMt0zdIzHQ8=","jMvdnb6vnm7OQ3LZeY9TvA==","","tbf9qMYQ0X2kmdqBrxFeo3U2\/AVNuE51tDZAfcqBDrxcDLMrKjPy\/OI6UJNDPcMlekQpWPiGcb3Vf3oPzlvW8g==","mgiBsvordu5SgovUygNEdQ==","oplb81J2vLHxZ4GCh7eLLYvnbYcLrPelLzmcVjcZCTA=","o+ttpCoGmWwr+zclHXAYFQ==",null,1,"4839"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 15:43:22","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":["8481","904","1605.0","1605.00","2","2020-07-28 15:43:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 15:43:22","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-06-14","2020-07-13","904"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-28 15:43:22","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":["8481",717,"SETTLED","A18-I208810","2020-07-28 15:43:21","2020-06-14","2","2020-07-28 15:43:21","2","2020-07-28 15:43:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 15:43:22","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":["8810","RENT","\u9810\u7e73\u79df\u91d1",1,1605,"MO","1",1605,"2","2020-07-28 15:43:21","2","2020-07-28 15:43:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 15:43:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1605,0,"8810"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-28 15:43:22","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":[717,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208453","2020-07-28 15:43:21",1605,"2","2020-07-28 15:43:21","2","2020-07-28 15:43:21","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 15:43:22","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":["8453","DEPOSIT",null,"PAID","2020-07-28 15:43:21",0,"2","2020-07-28 15:43:21","2","2020-07-28 15:43:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 15:43:22","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":["8453","INVOICE","8810","PAID","2020-07-28 15:43:21",1605,"2","2020-07-28 15:43:21","2","2020-07-28 15:43:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 15:45:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 16:04:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 16:24:10","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"57","master_room_id":"10","room_code":"B05"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":193,"customer_code":"C160193","identity_type":"PERSONAL","identity_id":"K727396(7)","title":"Mr","lastname":"Lau","firstname":"Wing Kan","companyname":"","email":null,"tel":"63488822","address":"\u9d28\u8137\u6d32\u5229\u6771\u90a8\u6771\u5e73\u6a13417\u5ba4","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1286.0","renew_rent_month":"1","renew_warehousing_date":"2020-07-19","renew_room_key":"190,40484","renew_remark":"1 month contract. Storage rental paid by cash on Jun 29, 2020. Storage deposit transferred from agreement A12-CT208013 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT208235, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"371","room_code":"G12","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-07-19","rent_from":"2020-07-19","rent_to":"2020-08-18","delivery_service":"0","remark":"1 month contract. Storage rental paid by cash on Jul 28, 2020. Storage deposit transferred from agreement A12-CT208235 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":1286,"final_order_total":1286,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190,40484","order_product":[],"pass":true}},"first_order_id":"4777","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> G12 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1286.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 16:24:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",193,"NEW","A12-CT208482",1528,1286,0,0,"1","1",1286,1286,1286,"2020-07-28 16:24:10","0",null,null,null,"2020-07-19","2020-08-18","1 month contract. Storage rental paid by cash on Jul 28, 2020. Storage deposit transferred from agreement A12-CT208235 to this agreement.\r\n","2020-07-19","20",0,null,0,"0","2","2020-07-28 16:24:10","2","2020-07-28 16:24:10","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"190,40484","C160193","PERSONAL","Mr","6PbxGXCeHIo\/MzWTc4fcRg==","oe4emdjBwqJ3qUpOcI17hw==","","JP4Rs\/ygk7B5+4qY1O\/77n4G4SUpGWQ1R+59le4zwir8onzHxmiKA5kLXAeJHhuO","3GH4gAMvtTCKkEWDOO\/eWw==",null,"m393lxqgH7t7KDeHWstXmg==",null,1,"4777"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 16:24: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":["8482","371","1528.0","1528.00","2","2020-07-28 16:24:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 16:24: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-07-19","2020-08-18","371"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-28 16:24: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":["8482",193,"SETTLED","A12-I208811","2020-07-28 16:24:10","2020-07-19","2","2020-07-28 16:24:10","2","2020-07-28 16:24:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 16:24: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":["8811","RENT","\u9810\u7e73\u79df\u91d1",1,1286,"MO","1",1286,"2","2020-07-28 16:24:10","2","2020-07-28 16:24:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 16:24:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1286,0,"8811"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-28 16:24: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":[193,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P208454","2020-07-28 16:24:10",1286,"2","2020-07-28 16:24:10","2","2020-07-28 16:24:10","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 16:24: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":["8454","DEPOSIT",null,"PAID","2020-07-28 16:24:10",0,"2","2020-07-28 16:24:10","2","2020-07-28 16:24:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 16:24: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":["8454","INVOICE","8811","PAID","2020-07-28 16:24:10",1286,"2","2020-07-28 16:24:10","2","2020-07-28 16:24:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 16:52:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 16:53:33","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","056,01969\/054,50297\/136,39278","6 months contract. Storage rental paid by PPS on June 30, 2019. Storage deposit transferred from agreement A14-CT194311 to this agreement.","2020-07-28 16:53:33","2","thtRZ5CDeQ9OOuodTdr1ng==","\/ZlnrrWgpen7zUAgYYQhAw==","e4xWqTyidJ9wZ0dGddQU4Q==","9RyhEwQ\/vQdGbbE4uEasZ7+UVSLD2li3\/pv4hHPaTiMwzV5MxMn\/aWc80iWO4+TL",5298]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 16:57:47","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","055,42838","3 months contract. Storage rental paid by bank transfer on August 12, 2019. Storage deposit transferred from agreement A12-CT195073 to this agreement.","2020-07-28 16:57:47","2","1Vh+KziHIDjQvyfVH7mCDw==","JKD5od+\/tz0iEPRXlEtfSA==","+anuJ0myqs96\/ne+Su\/Hcw==","AkpAs+YY7z6eTCtjTGdTXr4gQKuZTlfJz5+C0D9cEhU=",5698]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 16:58:48","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` = ? where id = ?","parameters":["VOID","0005796719","2 months contract. Storage rental paid by bank transfer on August 20, 2019. Storage deposit transferred from agreement A05-CT195092 to this agreement.","2020-07-28 16:58:48","2","vCxOlXQuvOQaoL822H2o\/Q==","zQ3iyxg59h+uE5WOCBiORg==","gf5j1W4FSvZL\/KDmf685CcuwykOXX9mK5mpOa8pQWsg=","sF6OzZ76dGhOxdRpB0PTTg==","oi8lbbUyPaJKyMywk\/m4QkQaqxSiAQI2Wb7BvmjgZHsQt+Q8\/NKfbmIjl00k25Yi1Cf4ZcEHmJqBhsdA0e2C\/zfWaVs3HAzyHShXZdy7aH8=",5748]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:02:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:05:41","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":[null,"0005023985","3 months contract. Storage rental will paid by bank transfer on or before July 10, 2020. Storage deposit transferred from agreement A05-CT195088 to this agreement.","2020-07-28 17:05:41","2","pxHPaJw0GdFrs4nn\/MH1Gw==","qIXB5hqnTN8z1QolDr\/79rOh9a5c4yb50dwbn+3PB3Q=","pnWUkmmclGMfCTT8WKc7XA==","e+fBbnu358aXtd45CicivEOl2q1z7G\/UAAgzgXOUxPWXe0kaEWblPY15Aq8uDQvXa+t+jz+eHir0ukAeQ07G0yw9W\/B+LkyKTKdzMkUBTCdjZ42LGishpXgAnp81PioX",5388]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:06:56","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","0005023985","3 months contract. Storage rental will paid by bank transfer on or before July 10, 2019\r\n. Storage deposit transferred from agreement A05-CT195088 to this agreement.","2020-07-28 17:06:56","2","pxHPaJw0GdFrs4nn\/MH1Gw==","qIXB5hqnTN8z1QolDr\/79rOh9a5c4yb50dwbn+3PB3Q=","pnWUkmmclGMfCTT8WKc7XA==","e+fBbnu358aXtd45CicivEOl2q1z7G\/UAAgzgXOUxPWXe0kaEWblPY15Aq8uDQvXa+t+jz+eHir0ukAeQ07G0yw9W\/B+LkyKTKdzMkUBTCdjZ42LGishpXgAnp81PioX",5388]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:21:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:21:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:21:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:22:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:47:39","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=246&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"57","master_room_id":"10","room_code":"B05"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":246,"customer_code":"C160246","identity_type":"PERSONAL","identity_id":"E669410(5)","title":"Ms","lastname":"Wong","firstname":"Yin Ping","companyname":"","email":"julianawyp@Yahoo.com.hk","tel":"90323387","address":"Flat H,5\/F Block 17,Mei Fai Court South Horizons, Ap Lei Chau","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"6","renew_warehousing_date":"2020-07-22","renew_room_key":"052,34362","renew_remark":"6 months contract. Storage rental paid by PPS on January 21, 2020. Storage deposit transferred from agreement A12-CT195547 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207033, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"66","room_code":"B14","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-07-22","rent_from":"2020-07-22","rent_to":"2020-08-21","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on Jul 21, 2020. Storage deposit transferred from agreement A12-CT207033 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"052,34362","order_product":[],"pass":true}},"first_order_id":"4191","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> B14 <\/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.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:47:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",246,"NEW","A12-CT208483",1098,1038,0,0,"1","1",1038,1038,1038,"2020-07-28 17:47:40","0",null,null,null,"2020-07-22","2020-08-21","1 month contract. Storage rental paid by PPS on Jul 21, 2020. Storage deposit transferred from agreement A12-CT207033 to this agreement.","2020-07-22","16",0,null,0,"0","2","2020-07-28 17:47:39","2","2020-07-28 17:47:39","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"052,34362","C160246","PERSONAL","Ms","LCid1COB1tg1mUcapCB6rQ==","hULSwM2MvFtpeV9\/z+er8Q==","","mIObWhb+7J95Mma1wUdAxoEb8M1GhMGp+3ltd6fEdjXnp1Ej3W+y+RlXRHD43h49kFRl88dNpK7qn8uKBVI1Aw==","yUxNpsMAehInxJPXm3Rl+w==","3ehLEnyTfV7S1FEVZ79XrDueuYsRx3WCndmjcVkU8ng=","5TdeaNCK8VIoKrSgD46SvA==",null,1,"4191"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:47:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8483","66","1098.0","1098.00","2","2020-07-28 17:47:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:47:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-22","2020-08-21","66"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-28 17:47:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8483",246,"SETTLED","A12-I208812","2020-07-28 17:47:39","2020-07-22","2","2020-07-28 17:47:39","2","2020-07-28 17:47:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:47:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8812","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-07-28 17:47:39","2","2020-07-28 17:47:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:47:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"8812"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-28 17:47:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[246,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208455","2020-07-28 17:47:39",1038,"2","2020-07-28 17:47:39","2","2020-07-28 17:47:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:47:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8455","DEPOSIT",null,"PAID","2020-07-28 17:47:39",0,"2","2020-07-28 17:47:39","2","2020-07-28 17:47:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:47:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8455","INVOICE","8812","PAID","2020-07-28 17:47:39",1038,"2","2020-07-28 17:47:39","2","2020-07-28 17:47:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:49:33","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=246&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"57","master_room_id":"10","room_code":"B05"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":246,"customer_code":"C160246","identity_type":"PERSONAL","identity_id":"E669410(5)","title":"Ms","lastname":"Wong","firstname":"Yin Ping","companyname":"","email":"julianawyp@Yahoo.com.hk","tel":"90323387","address":"Flat H,5\/F Block 17,Mei Fai Court South Horizons, Ap Lei Chau","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1788.0","renew_rent_month":"6","renew_warehousing_date":"2020-07-22","renew_room_key":"052,34362","renew_remark":"6 months contract. Storage rental paid by PPS on January 21, 2020. Storage deposit transferred from agreement A12-CT195548 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207034, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"188","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"177","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"177","room_code":"C53","retail_price":"1098.0","discounted_price":989,"location_id":"1"},{"room_id":"188","room_code":"C64","retail_price":"1098.0","discounted_price":989,"location_id":"1"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":1788,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":10728,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-22","rent_from":"2020-07-22","rent_to":"2021-01-21","delivery_service":"0","remark":"6 months contract. Storage rental paid by PPS on Jul 21, 2020. Storage deposit transferred from agreement A12-CT207034 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":10728,"final_order_total":10728,"location_id":"1","branch_id":"1","company_id":"1","room_key":"052,34362","order_product":[],"pass":true}},"first_order_id":"4190","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> C53 <\/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> C64 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"1788.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:49:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",246,"NEW","A12-CT208484",2196,1788,0,0,"6","6",10728,10728,10728,"2020-07-28 17:49:34","0",null,null,null,"2020-07-22","2021-01-21","6 months contract. Storage rental paid by PPS on Jul 21, 2020. Storage deposit transferred from agreement A12-CT207034 to this agreement.\r\n","2020-07-22","32",0,null,0,"0","2","2020-07-28 17:49:33","2","2020-07-28 17:49:33","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"052,34362","C160246","PERSONAL","Ms","LCid1COB1tg1mUcapCB6rQ==","hULSwM2MvFtpeV9\/z+er8Q==","","mIObWhb+7J95Mma1wUdAxoEb8M1GhMGp+3ltd6fEdjXnp1Ej3W+y+RlXRHD43h49kFRl88dNpK7qn8uKBVI1Aw==","yUxNpsMAehInxJPXm3Rl+w==","3ehLEnyTfV7S1FEVZ79XrDueuYsRx3WCndmjcVkU8ng=","5TdeaNCK8VIoKrSgD46SvA==",null,1,"4190"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:49:34","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":["8484","72","8","188","%","9.93",109.0314,"2","2020-07-28 17:49:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:49:34","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":["8484","72","8","177","%","9.93",109.0314,"2","2020-07-28 17:49:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:49:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8484","177","1098.0",989,"2","2020-07-28 17:49:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:49:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-22","2021-01-21","177"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-28 17:49:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8484","188","1098.0",989,"2","2020-07-28 17:49:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:49:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-22","2021-01-21","188"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-28 17:49:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8484",246,"SETTLED","A12-I208813","2020-07-28 17:49:33","2020-07-22","2","2020-07-28 17:49:33","2","2020-07-28 17:49:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:49:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8813","RENT","\u9810\u7e73\u79df\u91d1",1,1788,"MO","1",1788,"2","2020-07-28 17:49:33","2","2020-07-28 17:49:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:49:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8813","RENT","\u9810\u7e73\u79df\u91d1",2,1788,"MO","1",1788,"2","2020-07-28 17:49:33","2","2020-07-28 17:49:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:49:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8813","RENT","\u9810\u7e73\u79df\u91d1",3,1788,"MO","1",1788,"2","2020-07-28 17:49:33","2","2020-07-28 17:49:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:49:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8813","RENT","\u9810\u7e73\u79df\u91d1",4,1788,"MO","1",1788,"2","2020-07-28 17:49:33","2","2020-07-28 17:49:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:49:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8813","RENT","\u9810\u7e73\u79df\u91d1",5,1788,"MO","1",1788,"2","2020-07-28 17:49:33","2","2020-07-28 17:49:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:49:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8813","RENT","\u9810\u7e73\u79df\u91d1",6,1788,"MO","1",1788,"2","2020-07-28 17:49:33","2","2020-07-28 17:49:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:49:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10728,0,"8813"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-28 17:49:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[246,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208456","2020-07-28 17:49:33",10728,"2","2020-07-28 17:49:33","2","2020-07-28 17:49:33","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:49:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8456","DEPOSIT",null,"PAID","2020-07-28 17:49:33",0,"2","2020-07-28 17:49:33","2","2020-07-28 17:49:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:49:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8456","INVOICE","8813","PAID","2020-07-28 17:49:33",10728,"2","2020-07-28 17:49:33","2","2020-07-28 17:49:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:52:48","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=1&filter2=246&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":"57","master_room_id":"10","room_code":"B05"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1615,"customer_code":"C201615","identity_type":"PERSONAL","identity_id":"R763837(9)","title":"Ms","lastname":"Zhao","firstname":"yaru rya","companyname":"","email":null,"tel":"61904030","address":"Flat A, 28\/f, Pol Fu Lam Terrace, no.8 Wah Fu Road","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"13","renew_warehousing_date":"2021-07-11","renew_room_key":"191,03248; 191,05539","renew_remark":"13 months contract. Special offer renewal price list 50% off for the first 3 months and the 13th month free. Deposit $500 paid by PayMe on June 09,2020. The balance of storage rental and deposit $11548 paid by cash on 11JUNE2020. Smart card will provide later. Padlock provided on 11JUNE2020.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT208106, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2076.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"863","room_code":"T07","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1290,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2021-07-11","rent_from":"2021-07-11","rent_to":"2021-08-10","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on Jul 21, 2020. Storage deposit $2076 transferred from agreement A18-CT208106 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"3","branch_id":"1","company_id":"1","room_key":"191,03248; 191,05539","order_product":[],"pass":true}},"first_order_id":8106,"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> T07 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1290.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:52:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",1615,"NEW","A18-CT208485",1290,1290,0,0,"1","1",1290,1290,1290,"2020-07-28 17:52:48","0",null,null,null,"2021-07-11","2021-08-10","1 month contract. Storage rental paid by PPS on Jul 21, 2020. Storage deposit $2076 transferred from agreement A18-CT208106 to this agreement.\r\n","2021-07-11","16",0,null,0,"0","2","2020-07-28 17:52:48","2","2020-07-28 17:52:48","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"191,03248; 191,05539","C201615","PERSONAL","Ms","tnBXsw2iRVZmC7agW3nxRw==","iAKb9Y+6DFOZKg+8+iuRrA==","","WAeDQGyJs5GONb+7AH7S3+poCGWF1+fb+lVhrBHyBjm+j6zrUiqt3Wr6M+U+ocXuHAokHb5SnGVVm7hU6w8HTw==","f0RgO2mVVUDM\/nLFDmD8xA==",null,"PCjntCeNxYSbRGoWlh4wXA==",null,1,8106]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:52:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8485","863","1290.0","1290.00","2","2020-07-28 17:52:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:52:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2021-07-11","2021-08-10","863"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-28 17:52:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8485",1615,"SETTLED","A18-I208814","2020-07-28 17:52:48","2021-07-11","2","2020-07-28 17:52:48","2","2020-07-28 17:52:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:52:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8814","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-07-28 17:52:48","2","2020-07-28 17:52:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:52:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"8814"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-28 17:52:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1615,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208457","2020-07-28 17:52:48",1290,"2","2020-07-28 17:52:48","2","2020-07-28 17:52:48","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:52:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8457","DEPOSIT",null,"PAID","2020-07-28 17:52:48",0,"2","2020-07-28 17:52:48","2","2020-07-28 17:52:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:52:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8457","INVOICE","8814","PAID","2020-07-28 17:52:48",1290,"2","2020-07-28 17:52:48","2","2020-07-28 17:52:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:53:25","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=1595&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":533,"customer_code":"C170533","identity_type":"PERSONAL","identity_id":"D702226(2)","title":"Mr","lastname":"Leung","firstname":"Ming Fai","companyname":"","email":"leungmingfai@hotmail.com","tel":"62805618","address":"Flat G,9\/F, Kam Fung Mansion, 171 Aberdeen Main Rd, Aberdeen ","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-06-18","renew_room_key":"136,58083","renew_remark":"1 month contract. Storage rental paid by bank transfer on JUNE 17, 2020. Storage deposit transferred from agreement A14-CT207834 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT208178, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"754","room_code":"O30","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"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-06-18","rent_from":"2020-06-18","rent_to":"2020-07-17","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Jul 16, 2020. Storage deposit transferred from agreement A14-CT208178 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"2","branch_id":"1","company_id":"1","room_key":"136,58083","order_product":[],"pass":true,"paymethod_other2":""}},"first_order_id":"4566","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> O30 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","_payment_type":"INVOICE","roughly_size":"12","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:53:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",533,"NEW","A14-CT208486",998,1038,0,0,"1","1",1038,1038,1038,"2020-07-28 17:53:25","0",null,null,null,"2020-06-18","2020-07-17","1 month contract. Storage rental paid by bank transfer on Jul 16, 2020. Storage deposit transferred from agreement A14-CT208178 to this agreement.","2020-06-18","12",0,null,0,"0","2","2020-07-28 17:53:25","2","2020-07-28 17:53:25","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,58083","C170533","PERSONAL","Mr","ltCiTyDjJ0Gdz4KiVHpL3w==","xEf2h2aoyRQ71ZVgBH+9WQ==","","oxxB92pGHSI9I6dk86NeV50fIKbJm7OHBHlNQ0XlFwdi0YrCU3uueNLGwLXtYZ27jc2ffcQTK04oDV5uyRKmsw==","65I9HJH8Lb0dMm8MBuRKKw==","UoHdQ18xnvupRvjCY9wtS6MZZ24DKjVuPgYYyCDQhRU=","IiBGQKIxd9Yo4PXXqWkRIg==",null,1,"4566"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:53:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8486","754","998.0","998.00","2","2020-07-28 17:53:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:53:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-18","2020-07-17","754"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-28 17:53:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8486",533,"SETTLED","A14-I208815","2020-07-28 17:53:25","2020-06-18","2","2020-07-28 17:53:25","2","2020-07-28 17:53:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:53:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8815","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-07-28 17:53:25","2","2020-07-28 17:53:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:53:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"8815"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-28 17:53:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[533,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208458","2020-07-28 17:53:25",1038,"2","2020-07-28 17:53:25","2","2020-07-28 17:53:25","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:53:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8458","DEPOSIT",null,"PAID","2020-07-28 17:53:25",0,"2","2020-07-28 17:53:25","2","2020-07-28 17:53:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:53:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8458","INVOICE","8815","PAID","2020-07-28 17:53:25",1038,"2","2020-07-28 17:53:25","2","2020-07-28 17:53:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:54:55","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=1&filter2=246&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":"57","master_room_id":"10","room_code":"B05"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":739,"customer_code":"C180739","identity_type":"PERSONAL","identity_id":"Z061795(5)","title":"Mr","lastname":"Cheung","firstname":"Yuk Lun","companyname":"","email":"elvischeung80@yahoo.com.hk","tel":"97070457","address":"Room 3005, Wah Yin House, Wah Kwai Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"934.0","renew_rent_month":"6","renew_warehousing_date":"2020-07-22","renew_room_key":"055,42856,052,24316","renew_remark":"6 months contract. Storage rental paid by bank transfer on January 21, 2020. Storage deposit transferred from agreement A14-CT195544 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207016, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"673","room_code":"M84","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"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-07-22","rent_from":"2020-07-22","rent_to":"2020-08-21","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on Jul 21, 2020. Storage deposit transferred from agreement A14-CT207016 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,42856,052,24316","order_product":[],"pass":true}},"first_order_id":"4222","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> M84 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"1038.00","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:54:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",739,"NEW","A14-CT208487",998,1038,0,0,"1","1",1038,1038,1038,"2020-07-28 17:54:55","0",null,null,null,"2020-07-22","2020-08-21","1 month contract. Storage rental paid by PPS on Jul 21, 2020. Storage deposit transferred from agreement A14-CT207016 to this agreement.\r\n","2020-07-22","12",0,null,0,"0","2","2020-07-28 17:54:55","2","2020-07-28 17:54:55","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,42856,052,24316","C180739","PERSONAL","Mr","3Hy9inFozmBHJhsTlEv3Ag==","vCxOlXQuvOQaoL822H2o\/Q==","","rfxjO2+Fhpa0IfdGPcG7hJoMZrLBdVMhasfIzXMjp4ERjy4rW5XbCarWIkQKUr3jiXr31kDYg7oOIonxBd6brQ==","yy5D5ICBlG\/Qxr1kFgHMGA==","q\/sof54IpR4ELzObcRARE8GYv9uRp63G2SKQj8Qb45s=","4zsr\/oZVkk5hWdQTRkNW8g==",null,1,"4222"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:54:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8487","673","998.0","998.00","2","2020-07-28 17:54:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:54:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-22","2020-08-21","673"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-28 17:54:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8487",739,"SETTLED","A14-I208816","2020-07-28 17:54:55","2020-07-22","2","2020-07-28 17:54:55","2","2020-07-28 17:54:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:54:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8816","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-07-28 17:54:55","2","2020-07-28 17:54:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:54:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"8816"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-28 17:54:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[739,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208459","2020-07-28 17:54:55",1038,"2","2020-07-28 17:54:55","2","2020-07-28 17:54:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:54:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8459","DEPOSIT",null,"PAID","2020-07-28 17:54:55",0,"2","2020-07-28 17:54:55","2","2020-07-28 17:54:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 17:54:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8459","INVOICE","8816","PAID","2020-07-28 17:54:55",1038,"2","2020-07-28 17:54:55","2","2020-07-28 17:54:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:08:00","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=1&filter2=246&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":"57","master_room_id":"10","room_code":"B05"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":769,"customer_code":"C180769","identity_type":"PERSONAL","identity_id":"D088050(8)","title":"Mr","lastname":"Cheung","firstname":"Siu Fan","companyname":"","email":null,"tel":"91681533","address":"Flat 705, 7\/F, Block E, King Fai House, Yue Fai Court, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"6","renew_warehousing_date":"2020-08-10","renew_room_key":"053,54550","renew_remark":"6 months contract. Storage rental paid by bank transfer on February 6, 2020. Storage deposit transferred from agreement A14-CT195784 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207127, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"698","room_code":"N15","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-08-10","rent_from":"2020-08-10","rent_to":"2021-02-09","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on Jul 28, 2020. Storage deposit transferred from agreement A14-CT207127 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"2","branch_id":"1","company_id":"1","room_key":"053,54550","order_product":[],"pass":true}},"first_order_id":"4320","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> N15 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"538.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:08:01","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",769,"NEW","A14-CT208488",598,538,0,0,"6","6",3228,3228,3228,"2020-07-28 18:08:01","0",null,null,null,"2020-08-10","2021-02-09","6 months contract. Storage rental paid by bank transfer on Jul 28, 2020. Storage deposit transferred from agreement A14-CT207127 to this agreement.\r\n","2020-08-10","12",0,null,0,"0","2","2020-07-28 18:08:00","2","2020-07-28 18:08:00","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"053,54550","C180769","PERSONAL","Mr","EgDrVb9kbM\/5uhxbua2s4A==","vCxOlXQuvOQaoL822H2o\/Q==","","E61AlapXAo403HwMcQtgQWomcQs21VY6pkeUvDEQDIXoLkgu5xWwHapucihmbmf4jCa9QmVN2XhvF\/\/QWzRA8asXfc4KWWDJ76pcc7rZJd8=","MnsuH6E00DD7eeeO3MCgBg==",null,"KeBBDl+hYM8GhX1uRVuMTw==",null,1,"4320"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:08:01","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":["8488","698","598.0","598.00","2","2020-07-28 18:08:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:08:01","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-08-10","2021-02-09","698"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-28 18:08:01","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":["8488",769,"SETTLED","A14-I208817","2020-07-28 18:08:00","2020-08-10","2","2020-07-28 18:08:00","2","2020-07-28 18:08:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:08:01","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":["8817","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-07-28 18:08:00","2","2020-07-28 18:08:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:08:01","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":["8817","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-07-28 18:08:00","2","2020-07-28 18:08:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:08:01","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":["8817","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-07-28 18:08:00","2","2020-07-28 18:08:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:08:01","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":["8817","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-07-28 18:08:00","2","2020-07-28 18:08:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:08:01","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":["8817","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-07-28 18:08:00","2","2020-07-28 18:08:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:08:01","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":["8817","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-07-28 18:08:00","2","2020-07-28 18:08:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:08:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"8817"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-28 18:08:01","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":[769,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208460","2020-07-28 18:08:00",3228,"2","2020-07-28 18:08:00","2","2020-07-28 18:08:00","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:08:01","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":["8460","DEPOSIT",null,"PAID","2020-07-28 18:08:00",0,"2","2020-07-28 18:08:00","2","2020-07-28 18:08:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:08:01","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":["8460","INVOICE","8817","PAID","2020-07-28 18:08:00",3228,"2","2020-07-28 18:08:00","2","2020-07-28 18:08:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:08:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:09:10","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","0005023985","3 months contract. Storage rental will paid by bank transfer on or before July 10, 2019\r\n. Storage deposit transferred from agreement A05-CT195088 to this agreement.","2020-07-28 18:09:10","2","pxHPaJw0GdFrs4nn\/MH1Gw==","qIXB5hqnTN8z1QolDr\/79rOh9a5c4yb50dwbn+3PB3Q=","pnWUkmmclGMfCTT8WKc7XA==","e+fBbnu358aXtd45CicivEOl2q1z7G\/UAAgzgXOUxPWXe0kaEWblPY15Aq8uDQvXa+t+jz+eHir0ukAeQ07G0yw9W\/B+LkyKTKdzMkUBTCdjZ42LGishpXgAnp81PioX",5388]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:09:58","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1595&filter3=undefined&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":371,"customer_code":"C170371","identity_type":"PERSONAL","identity_id":"K478697(1)","title":"Ms","lastname":"Lo","firstname":"Pui Sze Percy","companyname":"","email":"percy1130@yahoo.com.hk","tel":"97005393","address":"Flat 4,Floor 4,Kong Tai Court,Aberdeen Centre,Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1286.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-26","renew_room_key":"022,43967","renew_remark":"1 month contract. Storage rental paid by bank transfer on May 30, 2020. Storage deposit transferred from agreement A14-CT207755 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT208342, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"38","order_discount":[],"order_room":[{"room_id":"431","room_code":"J13","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1286,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":2572,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-26","rent_from":"2020-06-26","rent_to":"2020-08-25","delivery_service":"0","remark":"2 months contract. Storage rental paid by bank transfer on Jul 28, 2020. Storage deposit transferred from agreement A14-CT208342 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2572,"final_order_total":2572,"location_id":"2","branch_id":"1","company_id":"1","room_key":"022,43967","order_product":[],"pass":true}},"first_order_id":"4690","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> J13 <\/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> <\/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-07-28 18:09:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",371,"NEW","A14-CT208489",1528,1286,0,0,"2","2",2572,2572,2572,"2020-07-28 18:09:59","0",null,null,null,"2020-06-26","2020-08-25","2 months contract. Storage rental paid by bank transfer on Jul 28, 2020. Storage deposit transferred from agreement A14-CT208342 to this agreement.","2020-06-26","20",0,null,0,"0","2","2020-07-28 18:09:58","2","2020-07-28 18:09:58","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"022,43967","C170371","PERSONAL","Ms","B\/tdI8SvtJ2XkpuhaqFRHg==","4w4biS+jM\/Q3DAzxHdf3pA==","","2hmhWBGvkZIoHzGPbhzhSV6dSCxka+bMmL61\/e5rYZ6q+VIutsM4dRc02qnIl242Nc1Cz9+dp5H16cfhITISeg==","kdkzIc7hmXA6w1V4sk35iQ==","egNDm5Rzw1wK2LSqnrwi\/s0PIzZXIWm1\/8FqKLRyLEw=","872ubrLnQzXtn1bx6f+nkg==",null,1,"4690"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:09:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8489","431","1528.0","1528.00","2","2020-07-28 18:09:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:09:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-26","2020-08-25","431"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-28 18:09:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8489",371,"SETTLED","A14-I208818","2020-07-28 18:09:58","2020-06-26","2","2020-07-28 18:09:58","2","2020-07-28 18:09:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:09:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8818","RENT","\u9810\u7e73\u79df\u91d1",1,1286,"MO","1",1286,"2","2020-07-28 18:09:58","2","2020-07-28 18:09:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:09:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8818","RENT","\u9810\u7e73\u79df\u91d1",2,1286,"MO","1",1286,"2","2020-07-28 18:09:58","2","2020-07-28 18:09:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:09:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2572,0,"8818"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-28 18:09:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[371,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208461","2020-07-28 18:09:58",2572,"2","2020-07-28 18:09:58","2","2020-07-28 18:09:58","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:09:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8461","DEPOSIT",null,"PAID","2020-07-28 18:09:58",0,"2","2020-07-28 18:09:58","2","2020-07-28 18:09:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:09:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8461","INVOICE","8818","PAID","2020-07-28 18:09:58",2572,"2","2020-07-28 18:09:58","2","2020-07-28 18:09:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:36:21","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=3&filter2=2020-07-22&filter3=2020-08-15","floor_plan_rent_room":[{"room_id":"1308","master_room_id":"164","room_code":"C15-002"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-002 <\/td>\r\n\t\t\t\t\t 4X2.5X6.5 <\/td>\r\n\t\t\t\t\t $773.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"D659903(7)","title":"Mr","lastname":"Hui","firstname":"Kam Chuen Alex","companyname":"","email":"","tel":"67717554","address":"Flat Rm4, Ti Fung Building, No.36 Hoi Kwong Street, Quarry Bay, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1308","room_code":"C15-002","retail_price":"773.0","discounted_price":"773.00","location_id":"6"}],"roughly_size":"10","total_retail_price":773,"total_discounted_price":773,"deposit":773,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1546,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-25","rent_from":"2020-07-25","rent_to":"2020-08-24","delivery_service":"0","remark":"1 Month contract. Storage rental and deposit paid by bank transfer on Jul 25, 2020. Smart Card provided by mail on Jul 28, 2020. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1606,"final_order_total":1606,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012462721","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"pass":true}},"roughly_size":"10","total_discounted_price":"773.00","deposit":"773.00","total_retail_price":"773.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:36:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201693","PERSONAL","Mr","nKulPHVADQf0J0Z4ESqcrA==","Uu\/X0ZeZROrQW5FJIWd7Ww==","","f20CVhG42d5HHSCGrEPkzw==",null,"eXJ8jE8DtSzhIXCr5wKJT9JhQRuI7gKSSA8FxaIa5B+SCuR\/cFOJm7HY1ntC6a7C\/4ZEQimicMh1UvVsXFVSJfNnwH9QhYWg2jgn6lnt87Q=","Bf1d+y0GwZM1Le\/0zGExpw==",null,null,"c2ZNxB6vr\/MgmtZb8ew7nQ==","2","2020-07-28 18:36:21","2","2020-07-28 18:36:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:36:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","3","6",1693,"NEW","C15-CT208490",773,773,773,0,"1","1",1546,1606,1606,"2020-07-28 18:36:24","0",null,null,null,"2020-07-25","2020-08-24","1 Month contract. Storage rental and deposit paid by bank transfer on Jul 25, 2020. Smart Card provided by mail on Jul 28, 2020. ","2020-07-25","10",0,null,0,"0","2","2020-07-28 18:36:21","2","2020-07-28 18:36:21","BANKIN","","","","BANKIN","","","",null,0,"'0012462721","C201693","PERSONAL","Mr","nKulPHVADQf0J0Z4ESqcrA==","Uu\/X0ZeZROrQW5FJIWd7Ww==","","eXJ8jE8DtSzhIXCr5wKJT9JhQRuI7gKSSA8FxaIa5B+SCuR\/cFOJm7HY1ntC6a7C\/4ZEQimicMh1UvVsXFVSJfNnwH9QhYWg2jgn6lnt87Q=","f20CVhG42d5HHSCGrEPkzw==",null,"Bf1d+y0GwZM1Le\/0zGExpw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:36:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8490",1693,"11","1","60.0",60,"2","2020-07-28 18:36:21","2","2020-07-28 18:36:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:36:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"8490"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-07-28 18:36:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8490","1308","773.0","773.00","2","2020-07-28 18:36:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:36:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-25","2020-08-24","1308"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-28 18:36:24","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":["8490","C15-D205576","PAID",773,0,"2020-08-24","2020-07-28 18:36:21","2020-07-28 18:36:21","2","2020-07-28 18:36:21","2","2020-07-28 18:36:21",1693]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:36:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8490",1693,"SETTLED","C15-I208819","2020-07-28 18:36:21","2020-07-25","2","2020-07-28 18:36:21","2","2020-07-28 18:36:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:36:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8819","RENT","\u9810\u7e73\u79df\u91d1",1,773,"MO","1",773,"2","2020-07-28 18:36:21","2","2020-07-28 18:36:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:36:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8819","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-07-28 18:36:21","2","2020-07-28 18:36:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:36:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[833,0,"8819"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-28 18:36:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1693,"BANKIN","","","","BANKIN","","","","PAID","P208462","2020-07-28 18:36:21",1606,"2","2020-07-28 18:36:21","2","2020-07-28 18:36:21","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:36:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8462","DEPOSIT","5576","PAID","2020-07-28 18:36:21",773,"2","2020-07-28 18:36:21","2","2020-07-28 18:36:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:36:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8462","INVOICE","8819","PAID","2020-07-28 18:36:21",833,"2","2020-07-28 18:36:21","2","2020-07-28 18:36:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:36:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:41:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-28 18:52:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****