{"created_at":"2020-07-18 10:26:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 11:47:28","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 11:52:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 12:07:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 13:23:18","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","floor_plan_rent_room":{"1":{"room_id":"206","master_room_id":"1","room_code":"D10"}},"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1349,"customer_code":"C191349","identity_type":"PERSONAL","identity_id":"K373744(6)","title":"Mr","lastname":"Dev Kumar","firstname":"Sharma","companyname":"","email":"dev.grandltd@gmail.com","tel":"61882674","address":"807, 8\/F, Harbour Crystal Centre, Tsim Sha Tsui East, Kowloon","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1565.0","renew_rent_month":"12","renew_warehousing_date":"2020-07-28","renew_room_key":"188,64565","renew_remark":"12 months contract. 2 months free. Special offer, 5% off and $200 switch to us offer. Storage rental and deposit paid by EPS on July 28, 2019. Smartcard and padlock keys provided on July 28, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT195567, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1738.0","renew_master_room_id":"183","order_discount":[],"order_room":[{"room_id":"1470","room_code":"C15-164","retail_price":"1738.0","discounted_price":"1738.00","location_id":"6"}],"roughly_size":"30","total_retail_price":1738,"total_discounted_price":1652,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":4956,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-28","rent_from":"2020-07-28","rent_to":"2020-10-27","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on July 16, 2020. Storage deposit $1738 transferred from agreement C15-CT195567 to this agreement. Smartcard and padlock keys provided on July 28, 2019. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4956,"final_order_total":4956,"location_id":"6","branch_id":"3","company_id":"1","room_key":"188,64565","order_product":[],"pass":true}},"first_order_id":5567,"selected_room_tr":"\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t

---

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

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

\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>
C15-164 <\/td>\r\n\t\t\t\t\t	5X6X6.5 <\/td>\r\n\t\t\t\t\t	$1738.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":"30","total_discounted_price":"1652.00","deposit":"0.00","total_retail_price":"1738.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 13:23:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1349,"NEW","C15-CT208420",1738,1652,0,0,"3","3",4956,4956,4956,"2020-07-18 13:23:18","0",null,null,null,"2020-07-28","2020-10-27","3 months contract. Storage rental paid by bank transfer on July 16, 2020. Storage deposit $1738 transferred from agreement C15-CT195567 to this agreement. Smartcard and padlock keys provided on July 28, 2019. \r\n","2020-07-28","30",0,null,0,"0","2","2020-07-18 13:23:18","2","2020-07-18 13:23:18","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"188,64565","C191349","PERSONAL","Mr","fMS4bzBZg5S30gptSJrgpw==","\/vofxWThvbeS729TWu+vfg==","","KygKzxSiR0PnKk\/z9h7iG8PIGswVgpQyYVZOs\/jwluSha64nxmTICBa\/kNUzkez\/XbPEQ5bh23iplSAaKZi6og==","2byIpreDlHHmUaJll9gKrQ==","emo6BPOAfG6Co\/f81ZPYMRLg\/AMJycUqOgG0lg0HULE=","w3+jk\/2BoJBXU8ALP34Q5Q==",null,1,5567]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 13:23:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8420","1470","1738.0","1738.00","2","2020-07-18 13:23:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 13:23:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-28","2020-10-27","1470"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-18 13:23:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8420",1349,"SETTLED","C15-I208749","2020-07-18 13:23:18","2020-07-28","2","2020-07-18 13:23:18","2","2020-07-18 13:23:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 13:23:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8749","RENT","\u9810\u7e73\u79df\u91d1",1,1652,"MO","1",1652,"2","2020-07-18 13:23:18","2","2020-07-18 13:23:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 13:23:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8749","RENT","\u9810\u7e73\u79df\u91d1",2,1652,"MO","1",1652,"2","2020-07-18 13:23:18","2","2020-07-18 13:23:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 13:23:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8749","RENT","\u9810\u7e73\u79df\u91d1",3,1652,"MO","1",1652,"2","2020-07-18 13:23:18","2","2020-07-18 13:23:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 13:23:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4956,0,"8749"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-18 13:23:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1349,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208392","2020-07-18 13:23:18",4956,"2","2020-07-18 13:23:18","2","2020-07-18 13:23:18","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 13:23:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8392","DEPOSIT",null,"PAID","2020-07-18 13:23:18",0,"2","2020-07-18 13:23:18","2","2020-07-18 13:23:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 13:23:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8392","INVOICE","8749","PAID","2020-07-18 13:23:18",4956,"2","2020-07-18 13:23:18","2","2020-07-18 13:23:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 15:29:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 15:32:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:00:29","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=INVOICE&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1554","master_room_id":"198","room_code":"A16-063"}],"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> A16-063 <\/td>\r\n\t\t\t\t\t 4X2.5X7 <\/td>\r\n\t\t\t\t\t $1028.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":"Z909369(A)","title":"Mr","lastname":"LO","firstname":"Hok Sum","companyname":"","email":"pkchan827@gmail.com","tel":"92697416","address":"Flat C, 18\/F, 150 Ap Lei Chau Main Street, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1554","room_code":"A16-063","retail_price":"1028.0","discounted_price":"1028.00","location_id":"7"}],"roughly_size":"10","total_retail_price":1028,"total_discounted_price":1028,"deposit":2056,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":12616,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1776.00","warehousing_date":"2020-08-01","rent_from":"2020-08-01","rent_to":"2021-07-31","delivery_service":"0","remark":"12 months contract. Storage rental and deposit $2056 paid by EPS on Jul 18, 2020. Smart card and padlock provided on the same day.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":1776,"order_total":14392,"final_order_total":12616,"location_id":"7","branch_id":"1","company_id":"1","room_key":"190,26641","order_product":[],"pass":true}},"roughly_size":"10","total_discounted_price":"1028.00","deposit":"2056.00","total_retail_price":"1028.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:00:30","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":["C201676","PERSONAL","Mr","dTkriY78PqwkWcov6B3dHg==","DyZn7f2tPwMiXMp09gXvdg==","","A+23ola0++0D4GuMzvaX1w==","LrKAa3NpmvtFwoDet94rtW54ZMOHk\/dFWNjqv\/uo1us=","ps3wEl2kONy54qycmlecGMdNunE1JYyghSyXXwePWbufOMvrtjfWMVuXBkDagwt\/2BwV4JKtjunuuCz6J2+4Bw==","PyHz9TOVrJG9As4cBl5Axw==",null,"LrKAa3NpmvtFwoDet94rtW54ZMOHk\/dFWNjqv\/uo1us=","ufDzi3EUoCz4Un74LwmSow==","2","2020-07-18 16:00:29","2","2020-07-18 16:00:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:00:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7",1676,"NEW","A16-CT208421",1028,1028,2056,0,"12","12",12616,14392,12616,"2020-07-18 16:00:31","0",null,null,null,"2020-08-01","2021-07-31","12 months contract. Storage rental and deposit $2056 paid by EPS on Jul 18, 2020. Smart card and padlock provided on the same day.","2020-08-01","10",0,null,1776,"1776.00","2","2020-07-18 16:00:29","2","2020-07-18 16:00:29","EPS","","","","EPS","","","",null,0,"190,26641","C201676","PERSONAL","Mr","dTkriY78PqwkWcov6B3dHg==","DyZn7f2tPwMiXMp09gXvdg==","","ps3wEl2kONy54qycmlecGMdNunE1JYyghSyXXwePWbufOMvrtjfWMVuXBkDagwt\/2BwV4JKtjunuuCz6J2+4Bw==","A+23ola0++0D4GuMzvaX1w==","LrKAa3NpmvtFwoDet94rtW54ZMOHk\/dFWNjqv\/uo1us=","PyHz9TOVrJG9As4cBl5Axw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:00:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8421","1554","1028.0","1028.00","2","2020-07-18 16:00:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:00:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-01","2021-07-31","1554"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-18 16:00:31","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":["8421","A16-D205552","PAID",2056,0,"2021-07-31","2020-07-18 16:00:29","2020-07-18 16:00:29","2","2020-07-18 16:00:29","2","2020-07-18 16:00:29",1676]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:00:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8421",1676,"SETTLED","A16-I208750","2020-07-18 16:00:29","2020-08-01","2","2020-07-18 16:00:29","2","2020-07-18 16:00:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:00:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8750","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-07-18 16:00:29","2","2020-07-18 16:00:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:00:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8750","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,280,"MO","1",280,"2","2020-07-18 16:00:29","2","2020-07-18 16:00:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:00:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8750","RENT","\u9810\u7e73\u79df\u91d1",3,1028,"MO","1",1028,"2","2020-07-18 16:00:29","2","2020-07-18 16:00:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:00:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8750","RENT","\u9810\u7e73\u79df\u91d1",4,1028,"MO","1",1028,"2","2020-07-18 16:00:29","2","2020-07-18 16:00:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:00:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8750","RENT","\u9810\u7e73\u79df\u91d1",5,1028,"MO","1",1028,"2","2020-07-18 16:00:29","2","2020-07-18 16:00:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:00:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8750","RENT","\u9810\u7e73\u79df\u91d1",6,1028,"MO","1",1028,"2","2020-07-18 16:00:29","2","2020-07-18 16:00:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:00:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8750","RENT","\u9810\u7e73\u79df\u91d1",7,1028,"MO","1",1028,"2","2020-07-18 16:00:29","2","2020-07-18 16:00:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:00:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8750","RENT","\u9810\u7e73\u79df\u91d1",8,1028,"MO","1",1028,"2","2020-07-18 16:00:29","2","2020-07-18 16:00:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:00:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8750","RENT","\u9810\u7e73\u79df\u91d1",9,1028,"MO","1",1028,"2","2020-07-18 16:00:29","2","2020-07-18 16:00:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:00:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8750","RENT","\u9810\u7e73\u79df\u91d1",10,1028,"MO","1",1028,"2","2020-07-18 16:00:29","2","2020-07-18 16:00:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:00:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8750","RENT","\u9810\u7e73\u79df\u91d1",11,1028,"MO","1",1028,"2","2020-07-18 16:00:29","2","2020-07-18 16:00:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:00:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8750","RENT","\u9810\u7e73\u79df\u91d1",12,1028,"MO","1",1028,"2","2020-07-18 16:00:29","2","2020-07-18 16:00:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:00:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10560,0,"8750"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-18 16:00:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1676,"EPS","","","","EPS","","","","PAID","P208393","2020-07-18 16:00:29",12616,"2","2020-07-18 16:00:29","2","2020-07-18 16:00:29","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:00:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8393","DEPOSIT","5552","PAID","2020-07-18 16:00:29",2056,"2","2020-07-18 16:00:29","2","2020-07-18 16:00:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:00:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8393","INVOICE","8750","PAID","2020-07-18 16:00:29",10560,"2","2020-07-18 16:00:29","2","2020-07-18 16:00:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:21:14","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1433,"customer_code":"C191433","identity_type":"PERSONAL","identity_id":"K186942(6)","title":"Ms","lastname":"CHONG","firstname":"Hiu Sai Stephanie","companyname":"","email":"kaczorowski@netvigator.com","tel":"96159015","address":"Flat B, 18\/F, TWR 10, Larvotto, 8 Ap Lei Chau Praya Rd, Ap Lei Chau, HK.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4400.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-01","renew_room_key":"191,03185","renew_remark":"1 month contract. Storage rental paid by bank transfer on June 30, 2020. Deposit $4400 transferred from A14-CT208095 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT208252, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"579","room_code":"L57","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"578","room_code":"L56","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"577","room_code":"L55","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"589","room_code":"L67","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"588","room_code":"L66","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"587","room_code":"L65","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"96","total_retail_price":6588,"total_discounted_price":4400,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":4400,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-01","rent_from":"2020-06-01","rent_to":"2020-06-30","delivery_service":"0","remark":"1 month contract. Storage rental paid by EPS on July 18, 2020. Deposit $4400 transferred from A14-CT208252 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4400,"final_order_total":4400,"location_id":"2","branch_id":"1","company_id":"1","room_key":"191,03185","order_product":[],"pass":true}},"first_order_id":"6263","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\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> L57 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> L56 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> L55 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> L67 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> L66 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> L65 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"96","total_discounted_price":"4400.0","deposit":"0","total_retail_price":"6588.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:21:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",1433,"NEW","A14-CT208422",6588,4400,0,0,"1","1",4400,4400,4400,"2020-07-18 16:21:14","0",null,null,null,"2020-06-01","2020-06-30","1 month contract. Storage rental paid by EPS on July 18, 2020. Deposit $4400 transferred from A14-CT208252 to this agreement.\r\n","2020-06-01","96",0,null,0,"0","2","2020-07-18 16:21:14","2","2020-07-18 16:21:14","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"191,03185","C191433","PERSONAL","Ms","jvk7zrBnQZbXfX1dgEQlHe0RI1vs\/c8ofCzDIiHPduw=","sFvIMVuF8ZsYisXFtwlNOg==","","voDtSK9PGGTovDOARqXC4\/CqVs\/FW\/EFt+7Y8XgoNXnKX\/oYLjrZhZIszuJBDn5WLlxnxR+ombwIyw2An8MxBSJza\/jcybdtGn9ZStmQV6U=","WkO2u9lqQEjRnfUKLBy+6Q==","WfnjLYwTfgHTPaehcdhvGWTDmhNfxmwxxekvQ0TBxrg=","F4vjEMLSruInVObtV1LPJw==",null,1,"6263"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:21:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8422","579","1098.0","1098.00","2","2020-07-18 16:21:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:21:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-06-30","579"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-18 16:21:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8422","578","1098.0","1098.00","2","2020-07-18 16:21:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:21:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-06-30","578"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-18 16:21:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8422","577","1098.0","1098.00","2","2020-07-18 16:21:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:21:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-06-30","577"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-18 16:21:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8422","589","1098.0","1098.00","2","2020-07-18 16:21:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:21:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-06-30","589"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-18 16:21:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8422","588","1098.0","1098.00","2","2020-07-18 16:21:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:21:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-06-30","588"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-18 16:21:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8422","587","1098.0","1098.00","2","2020-07-18 16:21:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:21:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-06-30","587"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-18 16:21:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8422",1433,"SETTLED","A14-I208751","2020-07-18 16:21:14","2020-06-01","2","2020-07-18 16:21:14","2","2020-07-18 16:21:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:21:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8751","RENT","\u9810\u7e73\u79df\u91d1",1,4400,"MO","1",4400,"2","2020-07-18 16:21:14","2","2020-07-18 16:21:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:21:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4400,0,"8751"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-18 16:21:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1433,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208394","2020-07-18 16:21:14",4400,"2","2020-07-18 16:21:14","2","2020-07-18 16:21:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:21:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8394","DEPOSIT",null,"PAID","2020-07-18 16:21:14",0,"2","2020-07-18 16:21:14","2","2020-07-18 16:21:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:21:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8394","INVOICE","8751","PAID","2020-07-18 16:21:14",4400,"2","2020-07-18 16:21:14","2","2020-07-18 16:21:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:22:46","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1433,"customer_code":"C191433","identity_type":"PERSONAL","identity_id":"K186942(6)","title":"Ms","lastname":"CHONG","firstname":"Hiu Sai Stephanie","companyname":"","email":"kaczorowski@netvigator.com","tel":"96159015","address":"Flat B, 18\/F, TWR 10, Larvotto, 8 Ap Lei Chau Praya Rd, Ap Lei Chau, HK.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3920.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-01","renew_room_key":"191,03185","renew_remark":"1 month contract. Storage rental paid by bank transfer on June 30, 2020. Deposit $3920 transferred from agreement A14-CT208096 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT208253, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"683","room_code":"M94","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"682","room_code":"M93","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"681","room_code":"M92","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"672","room_code":"M83","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"671","room_code":"M82","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"670","room_code":"M81","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"72","total_retail_price":5988,"total_discounted_price":3920,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":3920,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-01","rent_from":"2020-06-01","rent_to":"2020-06-30","delivery_service":"0","remark":"1 month contract. Storage rental paid by EPS July 18, 2020. Deposit $3920 transferred from agreement A14-CT208253 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3920,"final_order_total":3920,"location_id":"2","branch_id":"1","company_id":"1","room_key":"191,03185","order_product":[],"pass":true}},"first_order_id":"6272","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\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> M94 <\/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> M93 <\/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> M92 <\/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> M83 <\/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> M82 <\/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> M81 <\/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":"72","total_discounted_price":"3920.0","deposit":"0","total_retail_price":"5988.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:22:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",1433,"NEW","A14-CT208423",5988,3920,0,0,"1","1",3920,3920,3920,"2020-07-18 16:22:47","0",null,null,null,"2020-06-01","2020-06-30","1 month contract. Storage rental paid by EPS July 18, 2020. Deposit $3920 transferred from agreement A14-CT208253 to this agreement.\r\n","2020-06-01","72",0,null,0,"0","2","2020-07-18 16:22:46","2","2020-07-18 16:22:46","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"191,03185","C191433","PERSONAL","Ms","jvk7zrBnQZbXfX1dgEQlHe0RI1vs\/c8ofCzDIiHPduw=","sFvIMVuF8ZsYisXFtwlNOg==","","voDtSK9PGGTovDOARqXC4\/CqVs\/FW\/EFt+7Y8XgoNXnKX\/oYLjrZhZIszuJBDn5WLlxnxR+ombwIyw2An8MxBSJza\/jcybdtGn9ZStmQV6U=","WkO2u9lqQEjRnfUKLBy+6Q==","WfnjLYwTfgHTPaehcdhvGWTDmhNfxmwxxekvQ0TBxrg=","F4vjEMLSruInVObtV1LPJw==",null,1,"6272"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:22:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8423","683","998.0","998.00","2","2020-07-18 16:22:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:22:47","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-06-30","683"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-18 16:22:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8423","682","998.0","998.00","2","2020-07-18 16:22:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:22:47","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-06-30","682"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-18 16:22:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8423","681","998.0","998.00","2","2020-07-18 16:22:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:22:47","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-06-30","681"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-18 16:22:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8423","672","998.0","998.00","2","2020-07-18 16:22:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:22:47","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-06-30","672"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-18 16:22:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8423","671","998.0","998.00","2","2020-07-18 16:22:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:22:47","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-06-30","671"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-18 16:22:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8423","670","998.0","998.00","2","2020-07-18 16:22:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:22:47","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-06-30","670"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-18 16:22:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8423",1433,"SETTLED","A14-I208752","2020-07-18 16:22:46","2020-06-01","2","2020-07-18 16:22:46","2","2020-07-18 16:22:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:22:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8752","RENT","\u9810\u7e73\u79df\u91d1",1,3920,"MO","1",3920,"2","2020-07-18 16:22:46","2","2020-07-18 16:22:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:22:47","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3920,0,"8752"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-18 16:22:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1433,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208395","2020-07-18 16:22:46",3920,"2","2020-07-18 16:22:46","2","2020-07-18 16:22:46","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:22:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8395","DEPOSIT",null,"PAID","2020-07-18 16:22:46",0,"2","2020-07-18 16:22:46","2","2020-07-18 16:22:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:22:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8395","INVOICE","8752","PAID","2020-07-18 16:22:46",3920,"2","2020-07-18 16:22:46","2","2020-07-18 16:22:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:36:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:37:06","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:43:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:43:30","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":["NEW","190,26641","12 months contract. Storage rental and deposit $2056 paid by EPS on Jul 18, 2020. Smart card and padlock provided on the same day.","2020-07-18 16:43:30","2","DyZn7f2tPwMiXMp09gXvdg==","dTkriY78PqwkWcov6B3dHg==","LrKAa3NpmvtFwoDet94rtW54ZMOHk\/dFWNjqv\/uo1us=","F8ylGqwMVmyRaPigiRX81Q==","ps3wEl2kONy54qycmlecGMdNunE1JYyghSyXXwePWbufOMvrtjfWMVuXBkDagwt\/2BwV4JKtjunuuCz6J2+4Bw==",8421]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:50:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:51:34","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","190,26641","12 months contract. Storage rental and deposit $2056 paid by EPS on Jul 18, 2020. Smart card and padlock provided on the same day.","2020-07-18 16:51:33","2","DyZn7f2tPwMiXMp09gXvdg==","dTkriY78PqwkWcov6B3dHg==","LrKAa3NpmvtFwoDet94rtW54ZMOHk\/dFWNjqv\/uo1us=","F8ylGqwMVmyRaPigiRX81Q==","ps3wEl2kONy54qycmlecGMdNunE1JYyghSyXXwePWbufOMvrtjfWMVuXBkDagwt\/2BwV4JKtjunuuCz6J2+4Bw==",8421]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:56:35","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","floor_plan_rent_room":{"2":{"room_id":"1554","master_room_id":"198","room_code":"A16-063"}},"selected_room_tr":"\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n\t\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\t\t\t \n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A16-063 <\/td>\n\t\t\t\t\t 4X2.5X7 <\/td>\n\t\t\t\t\t $1028.00 <\/td>\n\t\t\t\t N\/A <\/td> <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\u522a\u9664<\/button>\n\t\t\t\t\t<\/td><\/tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"Z909369(A)","title":"Mr","lastname":"LO","firstname":"Hok Sum","companyname":"","email":"pkchan827@gmail.com","tel":"62029102","address":"Flat C, 18\/F, 150 Ap Lei Chau Main Street, Hong Kong","pass":true,"customer_id":"1676","customer_code":"C201676","customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1554","room_code":"A16-063","retail_price":"1028.0","discounted_price":"1028.00","location_id":"7"}],"roughly_size":"10","total_retail_price":1028,"total_discounted_price":926,"deposit":2056,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":12616,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1478.00","warehousing_date":"2020-08-01","rent_from":"2020-08-01","rent_to":"2021-08-31","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental and deposit $2056 paid by EPS on Jul 18, 2020. Smart card provided on the same day.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":1478,"order_total":14094,"final_order_total":12616,"location_id":"7","branch_id":"1","company_id":"1","room_key":"190,26641","order_product":[],"pass":true}},"roughly_size":"10","total_discounted_price":"926.00","deposit":"2056.00","total_retail_price":"1028.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:56:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7","1676","NEW","A16-CT208424",1028,926,2056,0,"13","13",12616,14094,12616,"2020-07-18 16:56:36","0",null,null,null,"2020-08-01","2021-08-31","13 months contract. Special offer the 13th month free. Storage rental and deposit $2056 paid by EPS on Jul 18, 2020. Smart card provided on the same day.","2020-08-01","10",0,null,1478,"1478.00","2","2020-07-18 16:56:35","2","2020-07-18 16:56:35","EPS","","","","EPS","","","",null,0,"190,26641","C201676","PERSONAL","Mr","dTkriY78PqwkWcov6B3dHg==","DyZn7f2tPwMiXMp09gXvdg==","","ps3wEl2kONy54qycmlecGMdNunE1JYyghSyXXwePWbufOMvrtjfWMVuXBkDagwt\/2BwV4JKtjunuuCz6J2+4Bw==","F8ylGqwMVmyRaPigiRX81Q==","LrKAa3NpmvtFwoDet94rtW54ZMOHk\/dFWNjqv\/uo1us=","PyHz9TOVrJG9As4cBl5Axw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:56:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8424","1554","1028.0","1028.00","2","2020-07-18 16:56:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:56:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-01","2021-08-31","1554"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-18 16:56:36","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":["8424","A16-D205553","PAID",2056,0,"2021-08-31","2020-07-18 16:56:35","2020-07-18 16:56:35","2","2020-07-18 16:56:35","2","2020-07-18 16:56:35","1676"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:56:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8424","1676","SETTLED","A16-I208753","2020-07-18 16:56:35","2020-08-01","2","2020-07-18 16:56:35","2","2020-07-18 16:56:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:56:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8753","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-07-18 16:56:35","2","2020-07-18 16:56:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:56:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8753","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,374,"MO","1",374,"2","2020-07-18 16:56:35","2","2020-07-18 16:56:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:56:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8753","RENT","\u9810\u7e73\u79df\u91d1",3,926,"MO","1",926,"2","2020-07-18 16:56:35","2","2020-07-18 16:56:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:56:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8753","RENT","\u9810\u7e73\u79df\u91d1",4,926,"MO","1",926,"2","2020-07-18 16:56:35","2","2020-07-18 16:56:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:56:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8753","RENT","\u9810\u7e73\u79df\u91d1",5,926,"MO","1",926,"2","2020-07-18 16:56:35","2","2020-07-18 16:56:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:56:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8753","RENT","\u9810\u7e73\u79df\u91d1",6,926,"MO","1",926,"2","2020-07-18 16:56:35","2","2020-07-18 16:56:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:56:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8753","RENT","\u9810\u7e73\u79df\u91d1",7,926,"MO","1",926,"2","2020-07-18 16:56:35","2","2020-07-18 16:56:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:56:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8753","RENT","\u9810\u7e73\u79df\u91d1",8,926,"MO","1",926,"2","2020-07-18 16:56:35","2","2020-07-18 16:56:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:56:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8753","RENT","\u9810\u7e73\u79df\u91d1",9,926,"MO","1",926,"2","2020-07-18 16:56:35","2","2020-07-18 16:56:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:56:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8753","RENT","\u9810\u7e73\u79df\u91d1",10,926,"MO","1",926,"2","2020-07-18 16:56:35","2","2020-07-18 16:56:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:56:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8753","RENT","\u9810\u7e73\u79df\u91d1",11,926,"MO","1",926,"2","2020-07-18 16:56:35","2","2020-07-18 16:56:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:56:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8753","RENT","\u9810\u7e73\u79df\u91d1",12,926,"MO","1",926,"2","2020-07-18 16:56:35","2","2020-07-18 16:56:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:56:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8753","RENT","\u9810\u7e73\u79df\u91d1",13,926,"MO","1",926,"2","2020-07-18 16:56:35","2","2020-07-18 16:56:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:56:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10560,0,"8753"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-18 16:56:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1676","EPS","","","","EPS","","","","PAID","P208396","2020-07-18 16:56:35",12616,"2","2020-07-18 16:56:35","2","2020-07-18 16:56:35","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:56:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8396","DEPOSIT","5553","PAID","2020-07-18 16:56:35",2056,"2","2020-07-18 16:56:35","2","2020-07-18 16:56:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-18 16:56:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8396","INVOICE","8753","PAID","2020-07-18 16:56:35",10560,"2","2020-07-18 16:56:35","2","2020-07-18 16:56:35"]},"data_before":[],"data_after":[],"step":1} *****