{"created_at":"2020-02-08 11:00:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 12:34:12","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1448&filter3=undefined","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":445,"customer_code":"C170445","identity_type":"PERSONAL","identity_id":"K738319(3)","title":"Mr","lastname":"Sin","firstname":"Dai Chuen Sunny","companyname":"","email":"sindaichuen@netvigator.com","tel":"93632429","address":"\u9999\u6e2f\u4ed4\u4e2d\u5fc3K\u5ea7\u6d77\u6676\u95a313\u6a134\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1198.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-10","renew_room_key":"054,60440","renew_remark":"1 month contract. Storage rental paid by bank transfer on Jan 07,2020. Storage deposit transferred from agreement A14-CT196627 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT206892, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"70","order_discount":[],"order_room":[{"room_id":"722","room_code":"N39","retail_price":"1318.0","discounted_price":"1318.00","location_id":"2"}],"roughly_size":"18","total_retail_price":1318,"total_discounted_price":1198,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1198,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-10","rent_from":"2020-02-10","rent_to":"2020-03-09","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on February 7,2020. Storage deposit transferred from agreement A14-CT206892 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1198,"final_order_total":1198,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,60440","order_product":[],"pass":true}},"first_order_id":"4712","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>
N39 <\/td>\r\n\t\t\t\t\t	3X6X8 <\/td>\r\n\t\t\t\t\t	$1318.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":"18","total_discounted_price":"1198.0","deposit":"0","total_retail_price":"1318.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 12:34:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",445,"NEW","A14-CT207145",1318,1198,0,0,"1","1",1198,1198,1198,"2020-02-08 12:34:12","0",null,null,null,"2020-02-10","2020-03-09","1 month contract. Storage rental paid by bank transfer on February 7,2020. Storage deposit transferred from agreement A14-CT206892 to this agreement.\r\n","2020-02-10","18",0,null,0,"0","2","2020-02-08 12:34:12","2","2020-02-08 12:34:12","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,60440","C170445","PERSONAL","Mr","9L2K7wn1Opvr3WQ4vJABDA==","995YTEe316mZ2NiY\/8o00g==","","mvDoTgHRyEEzx3aiSCEV4DxQZHD5YYGgvyNzPm1QCr\/nAPIFPb3QfWTpiQPnxKX2","QrHnF9IXwKZ9qN6l8eYD5g==","A+zYSJpoRkceQYWowNFQUv3ec39gnccN6z82YnuKfNw=","d5o++GGoW7Lf\/yZcJ7PGQw==",null,1,"4712"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 12:34:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7145","722","1318.0","1318.00","2","2020-02-08 12:34:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 12:34:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-10","2020-03-09","722"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-08 12:34:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7145",445,"SETTLED","A14-I207473","2020-02-08 12:34:12","2020-02-10","2","2020-02-08 12:34:12","2","2020-02-08 12:34:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 12:34:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7473","RENT","\u9810\u7e73\u79df\u91d1",1,1198,"MO","1",1198,"2","2020-02-08 12:34:12","2","2020-02-08 12:34:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 12:34:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1198,0,"7473"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-08 12:34:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[445,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207121","2020-02-08 12:34:12",1198,"2","2020-02-08 12:34:12","2","2020-02-08 12:34:12","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 12:34:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7121","DEPOSIT",null,"PAID","2020-02-08 12:34:12",0,"2","2020-02-08 12:34:12","2","2020-02-08 12:34:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 12:34:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7121","INVOICE","7473","PAID","2020-02-08 12:34:12",1198,"2","2020-02-08 12:34:12","2","2020-02-08 12:34:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 12:37: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=2&filter2=1448&filter3=undefined&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1301,"customer_code":"C191301","identity_type":"PERSONAL","identity_id":"K08388(5)","title":"Ms","lastname":"Kwan","firstname":"Yuen Yee Amy","companyname":"","email":"akyyhk@yahoo.com","tel":"92750360","address":"Flat L, 9\/F, Blk 5, Hong Sing Garden, Tseung Kwan O, N.T.","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-16","renew_room_key":"111,40893","renew_remark":"1 month contract. Storage rental paid by PPS on January 14, 2019. Storage deposit transferred from agreement A16-CT196719 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT206971, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"202","order_discount":[],"order_room":[{"room_id":"1519","room_code":"A16-028","retail_price":"1290.0","discounted_price":"1290.00","location_id":"7"}],"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":"2020-02-16","rent_from":"2020-02-16","rent_to":"2020-03-15","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on February 7, 2020. Storage deposit transferred from agreement A16-CT206971 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"7","branch_id":"1","company_id":"1","room_key":"111,40893","order_product":[],"pass":true}},"first_order_id":"5235","selected_room_tr":"	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A16-028 <\/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> <\/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.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 12:37:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","7",1301,"NEW","A16-CT207146",1290,1290,0,0,"1","1",1290,1290,1290,"2020-02-08 12:37:56","0",null,null,null,"2020-02-16","2020-03-15","1 month contract. Storage rental paid by PPS on February 7, 2020. Storage deposit transferred from agreement A16-CT206971 to this agreement.\r\n","2020-02-16","16",0,null,0,"0","2","2020-02-08 12:37:55","2","2020-02-08 12:37:55","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"111,40893","C191301","PERSONAL","Ms","5wigC8kzb56lGRRSAEYGsw==","iNwdG3Dj3OBaAQ6MRfBM1w==","","\/Ewh1holgp6WSTJa\/JHYhYvoqKRvnYtpL3yQk4vYZf\/xWDWin6QHzWL6hMnAUJ4T8XbSzfh5jMoFXOktD1XRYw==","YESwwapoFqF3cRsBQ+uG6A==","G8w9ZbnhyRcx0XoYCRwUCjIw8+4PSVsFNffrrS+i8x4=","kt7RlFLP4CUDPa9sfSXSrg==",null,1,"5235"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 12:37:56","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":["7146","1519","1290.0","1290.00","2","2020-02-08 12:37:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 12:37:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-16","2020-03-15","1519"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-08 12:37:56","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":["7146",1301,"SETTLED","A16-I207474","2020-02-08 12:37:55","2020-02-16","2","2020-02-08 12:37:55","2","2020-02-08 12:37:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 12:37:56","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":["7474","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-02-08 12:37:55","2","2020-02-08 12:37:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 12:37:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"7474"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-08 12:37:56","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":[1301,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207122","2020-02-08 12:37:55",1290,"2","2020-02-08 12:37:55","2","2020-02-08 12:37:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 12:37:56","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":["7122","DEPOSIT",null,"PAID","2020-02-08 12:37:55",0,"2","2020-02-08 12:37:55","2","2020-02-08 12:37:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 12:37:56","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":["7122","INVOICE","7474","PAID","2020-02-08 12:37:55",1290,"2","2020-02-08 12:37:55","2","2020-02-08 12:37:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 13:07:41","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=1010&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1186,"customer_code":"C191186","identity_type":"PERSONAL","identity_id":"D697903(4)","title":"Ms","lastname":"CHAN","firstname":"Kit Ming Cindy","companyname":"","email":"muimuilachatte@gmail.com","tel":"52116215","address":"19G, Block 4, Broadview Court, 11 Shum Wan Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"953.0","renew_rent_month":"12","renew_warehousing_date":"2020-02-26","renew_room_key":"190,13864 , 190,22286","renew_remark":"12 month contract. Storage rental paid by EPS on January 30, 2019. Storage deposit $2116 transferred from agreement A18-CT194244 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT194271, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"101","order_discount":[],"order_room":[{"room_id":"937","room_code":"V11(\u670d\u88dd\u5009)","retail_price":"1058.0","discounted_price":"1058.00","location_id":"3"}],"roughly_size":"9.6","total_retail_price":1058,"total_discounted_price":953,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":11436,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"953.00","warehousing_date":"2020-02-26","rent_from":"2020-02-26","rent_to":"2021-03-25","delivery_service":"0","remark":"13 months contract. Special renewal offer the 13th month free. Storage rental paid by EPS on Feb 08,2020. Storage deposit $2116 transferred from agreement A18-CT194271 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":953,"order_total":12389,"final_order_total":11436,"location_id":"3","branch_id":"1","company_id":"1","room_key":"190,13864 , 190,22286","order_product":[],"pass":true}},"first_order_id":4271,"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> V11(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X2.4X7 <\/td>\r\n\t\t\t\t\t $1058.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"9.6","total_discounted_price":"953.00","deposit":"0.00","total_retail_price":"1058.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 13:07:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",1186,"NEW","A18-CT207147",1058,953,0,0,"13","13",11436,12389,11436,"2020-02-08 13:07:42","0",null,null,null,"2020-02-26","2021-03-25","13 months contract. Special renewal offer the 13th month free. Storage rental paid by EPS on Feb 08,2020. Storage deposit $2116 transferred from agreement A18-CT194271 to this agreement.","2020-02-26","9.6",0,null,953,"953.00","2","2020-02-08 13:07:41","2","2020-02-08 13:07:41","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"190,13864 , 190,22286","C191186","PERSONAL","Ms","5xhHMy9GVD6iInJLlBgGZw==","8BEgNhGpCR8jGkzUtrIcXg==","","gWzLXjoQvFFUQHL+qPQUSBffskBnEREAAwW4QhaRQ5hEvs3TxU8eLyhx9\/hDNtwyst1k2eOa2Z5YmI79ZoMwiA==","AIKCFYjDeIN\/eJ+R8JLxaw==","mjlNkSJSsVc2mlYiM7A0WPwj6mw9+ABnj3kcEQIzTY4=","elC5vXg614t9tJTczex\/YQ==",null,1,4271]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 13:07:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7147","937","1058.0","1058.00","2","2020-02-08 13:07:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 13:07:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-26","2021-03-25","937"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-08 13:07:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7147",1186,"SETTLED","A18-I207475","2020-02-08 13:07:41","2020-02-26","2","2020-02-08 13:07:41","2","2020-02-08 13:07:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 13:07:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7475","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,953,"MO","1",953,"2","2020-02-08 13:07:41","2","2020-02-08 13:07:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 13:07:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7475","RENT","\u9810\u7e73\u79df\u91d1",3,953,"MO","1",953,"2","2020-02-08 13:07:41","2","2020-02-08 13:07:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 13:07:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7475","RENT","\u9810\u7e73\u79df\u91d1",4,953,"MO","1",953,"2","2020-02-08 13:07:41","2","2020-02-08 13:07:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 13:07:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7475","RENT","\u9810\u7e73\u79df\u91d1",5,953,"MO","1",953,"2","2020-02-08 13:07:41","2","2020-02-08 13:07:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 13:07:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7475","RENT","\u9810\u7e73\u79df\u91d1",6,953,"MO","1",953,"2","2020-02-08 13:07:41","2","2020-02-08 13:07:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 13:07:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7475","RENT","\u9810\u7e73\u79df\u91d1",7,953,"MO","1",953,"2","2020-02-08 13:07:41","2","2020-02-08 13:07:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 13:07:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7475","RENT","\u9810\u7e73\u79df\u91d1",8,953,"MO","1",953,"2","2020-02-08 13:07:41","2","2020-02-08 13:07:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 13:07:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7475","RENT","\u9810\u7e73\u79df\u91d1",9,953,"MO","1",953,"2","2020-02-08 13:07:41","2","2020-02-08 13:07:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 13:07:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7475","RENT","\u9810\u7e73\u79df\u91d1",10,953,"MO","1",953,"2","2020-02-08 13:07:41","2","2020-02-08 13:07:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 13:07:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7475","RENT","\u9810\u7e73\u79df\u91d1",11,953,"MO","1",953,"2","2020-02-08 13:07:41","2","2020-02-08 13:07:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 13:07:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7475","RENT","\u9810\u7e73\u79df\u91d1",12,953,"MO","1",953,"2","2020-02-08 13:07:41","2","2020-02-08 13:07:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 13:07:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7475","RENT","\u9810\u7e73\u79df\u91d1",13,953,"MO","1",953,"2","2020-02-08 13:07:41","2","2020-02-08 13:07:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 13:07:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11436,0,"7475"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-08 13:07:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1186,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207123","2020-02-08 13:07:41",11436,"2","2020-02-08 13:07:41","2","2020-02-08 13:07:41","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 13:07:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7123","DEPOSIT",null,"PAID","2020-02-08 13:07:41",0,"2","2020-02-08 13:07:41","2","2020-02-08 13:07:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-08 13:07:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7123","INVOICE","7475","PAID","2020-02-08 13:07:41",11436,"2","2020-02-08 13:07:41","2","2020-02-08 13:07:41"]},"data_before":[],"data_after":[],"step":1} *****