{"created_at":"2020-08-03 10:05:06","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 10:07:33","login_id":"1","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 10:16:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 10:38:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:31:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:34:45","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:36:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:42:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:42:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:44:39","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=681&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":681,"customer_code":"C180681","identity_type":"PERSONAL","identity_id":"K087413(2)","title":"Mr","lastname":"Chung","firstname":"Ka Po","companyname":"","email":"patrickbobofamily@gmail.com","tel":"63336887","address":"3\/F, Siu Fung Hong Building, 239-241 Wing Lok Street, Sheung Wan, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"965.0","renew_rent_month":"1","renew_warehousing_date":"2020-08-02","renew_room_key":"056,05555","renew_remark":"1 month contract. Storage rental paid by PPS on June 30, 2020. Storage deposit transferred from agreement A18-CT208020 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT208248, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"103","order_discount":[],"order_room":[{"room_id":"906","room_code":"U07","retail_price":"965.0","discounted_price":"965.00","location_id":"3"}],"roughly_size":"8","total_retail_price":965,"total_discounted_price":965,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":965,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-08-02","rent_from":"2020-08-02","rent_to":"2020-09-01","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on Jul 31, 2020. Storage deposit transferred from agreement A18-CT208248 to this agreement.\r\n\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":965,"final_order_total":965,"location_id":"3","branch_id":"1","company_id":"1","room_key":"056,05555","order_product":[],"pass":true}},"first_order_id":"4704","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>
U07 <\/td>\r\n\t\t\t\t\t	2X4X7 <\/td>\r\n\t\t\t\t\t	$965.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":"8","total_discounted_price":"965.0","deposit":"0","total_retail_price":"965.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:44:39","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",681,"NEW","A18-CT208541",965,965,0,0,"1","1",965,965,965,"2020-08-03 11:44:39","0",null,null,null,"2020-08-02","2020-09-01","1 month contract. Storage rental paid by PPS on Jul 31, 2020. Storage deposit transferred from agreement A18-CT208248 to this agreement.\r\n\r\n","2020-08-02","8",0,null,0,"0","2","2020-08-03 11:44:39","2","2020-08-03 11:44:39","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"056,05555","C180681","PERSONAL","Mr","WpXUsGIV5ZMagl9ab+XsmA==","ThKwrAIcvgN3JqAg+7\/isg==","","MfbxfJxu6rnCI3QT7TKkp941rf6ZLqXK4FI5VbVzAJiJni8uQnXc2gGJQSsyflI200jM1kVIWfocMiR8ixEVuOtN59H0aUN3N6cpSW\/Zb8g=","uk+aBM1pdnZq7uENadbWLg==","AlXt3dY1\/1B81wXwqLajny8WQO2W1oXWizWY\/cvTtlY=","ikLrZy69X3qkMVAoKWXxnQ==",null,1,"4704"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:44:39","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":["8541","906","965.0","965.00","2","2020-08-03 11:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:44:39","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-02","2020-09-01","906"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-03 11:44:39","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":["8541",681,"SETTLED","A18-I208870","2020-08-03 11:44:39","2020-08-02","2","2020-08-03 11:44:39","2","2020-08-03 11:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:44:39","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":["8870","RENT","\u9810\u7e73\u79df\u91d1",1,965,"MO","1",965,"2","2020-08-03 11:44:39","2","2020-08-03 11:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:44:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[965,0,"8870"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-03 11:44:39","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":[681,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208513","2020-08-03 11:44:39",965,"2","2020-08-03 11:44:39","2","2020-08-03 11:44:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:44:39","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":["8513","DEPOSIT",null,"PAID","2020-08-03 11:44:39",0,"2","2020-08-03 11:44:39","2","2020-08-03 11:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:44:39","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":["8513","INVOICE","8870","PAID","2020-08-03 11:44:39",965,"2","2020-08-03 11:44:39","2","2020-08-03 11:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:51:00","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=681&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":619,"customer_code":"C170619","identity_type":"PERSONAL","identity_id":"K063939(7)","title":"Mr","lastname":"Kwok","firstname":"Siu Kai Chris","companyname":"","email":"chriskwok@hundredcity.com","tel":"51923422","address":"Room 2206, Wah Chui House, Wah Fu Estate, Aberdeen, Hong Kong","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-07-01","renew_room_key":"137,01453","renew_remark":"1 month contract. Storage rental paid by PPS on July 2, 2020. Storage deposit transferred from agreement A18-CT208027 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT208356, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"848","room_code":"S07","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1290,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-01","rent_from":"2020-07-01","rent_to":"2020-07-31","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on July 31, 2020. Storage deposit transferred from agreement A18-CT208356 to this agreement.\r\n\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"3","branch_id":"1","company_id":"1","room_key":"137,01453","order_product":[],"pass":true}},"first_order_id":"4713","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> S07 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:51:00","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",619,"NEW","A18-CT208542",1290,1290,0,0,"1","1",1290,1290,1290,"2020-08-03 11:51:00","0",null,null,null,"2020-07-01","2020-07-31","1 month contract. Storage rental paid by PPS on July 31, 2020. Storage deposit transferred from agreement A18-CT208356 to this agreement.\r\n\r\n","2020-07-01","16",0,null,0,"0","2","2020-08-03 11:51:00","2","2020-08-03 11:51:00","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"137,01453","C170619","PERSONAL","Mr","4CxzeWawe7YZzIDmhbEfuQ==","+pNULpsInm3siHASV0hIrg==","","NYkQtJJtV74MeVYTqgx0ztU\/N5b87j7Qp2UEsJ4OUX2W\/qfJLUUiDaAhXCDscVFsf696kppiP\/Svvt3NEV7dFw==","Y\/j3PHjWzTVUfnUyu6iRgg==","quK5iGTT3eQ2Z0bPiVPSOKKb9HSCQz7W9wX8cB2u8BQ=","0tB+oJUYD6OdlTawrAQuqw==",null,1,"4713"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:51:00","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":["8542","848","1290.0","1290.00","2","2020-08-03 11:51:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:51:00","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-01","2020-07-31","848"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-03 11:51:00","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":["8542",619,"SETTLED","A18-I208871","2020-08-03 11:51:00","2020-07-01","2","2020-08-03 11:51:00","2","2020-08-03 11:51:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:51:00","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":["8871","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-08-03 11:51:00","2","2020-08-03 11:51:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:51:00","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"8871"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-03 11:51:00","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":[619,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208514","2020-08-03 11:51:00",1290,"2","2020-08-03 11:51:00","2","2020-08-03 11:51:00","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:51:00","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":["8514","DEPOSIT",null,"PAID","2020-08-03 11:51:00",0,"2","2020-08-03 11:51:00","2","2020-08-03 11:51:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:51:00","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":["8514","INVOICE","8871","PAID","2020-08-03 11:51:00",1290,"2","2020-08-03 11:51:00","2","2020-08-03 11:51:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:52:57","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":630,"customer_code":"C170630","identity_type":"PERSONAL","identity_id":"G171920(2)","title":"Ms","lastname":"Sin","firstname":"Chiu Ying Sindia","companyname":"","email":"sindiasin@yahoo.com.hk","tel":"60569139","address":"Flat H, 31\/F, Tower 3, Marina Habitat, 3 Yuet Hoi Street, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2068.0","renew_rent_month":"13","renew_warehousing_date":"2020-08-02","renew_room_key":"055,20373","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by bank transfer on June 29, 2019. Storage deposit transferred from agreement A18-CT194038 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195384, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"81","order_discount":[],"order_room":[{"room_id":"828","room_code":"R02","retail_price":"2298.0","discounted_price":"2298.00","location_id":"3"}],"roughly_size":"30","total_retail_price":2298,"total_discounted_price":2068,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":24816,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-08-02","rent_from":"2020-08-02","rent_to":"2021-08-01","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on August 1, 2020. Storage deposit transferred from agreement A18-CT195384 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":24816,"final_order_total":24816,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,20373","order_product":[],"pass":true}},"first_order_id":"4038","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> R02 <\/td>\r\n\t\t\t\t\t 5X6X7 <\/td>\r\n\t\t\t\t\t $2298.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":"30","total_discounted_price":"2068.00","deposit":"0","total_retail_price":"2298.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:52:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",630,"NEW","A18-CT208543",2298,2068,0,0,"12","12",24816,24816,24816,"2020-08-03 11:52:57","0",null,null,null,"2020-08-02","2021-08-01","12 months contract. Storage rental paid by bank transfer on August 1, 2020. Storage deposit transferred from agreement A18-CT195384 to this agreement.\r\n","2020-08-02","30",0,null,0,"0","2","2020-08-03 11:52:57","2","2020-08-03 11:52:57","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,20373","C170630","PERSONAL","Ms","d9rtSeyHwmY4qFFBz5KPHfRgogW0a11+QdS4yifUfNE=","995YTEe316mZ2NiY\/8o00g==","","qrYC5xX+o0oHX\/qMrmK09NFhKWSWNZJn4a7QqJhOvvOFp6bOinHPC0\/JyUu50vaEDYB58NNX94tc6kIYa13L+szVQW7NuRJeK9zl6d4RnVs=","OLqmOMBNnzUH+f2PxFPMSw==","exO1OCjBa07qWFKul4LmsZRInq\/vkuRkRzPe7bGXihU=","8yyvJx1rktA4asuUKDoIvA==",null,1,"4038"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:52:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8543","828","2298.0","2298.00","2","2020-08-03 11:52:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:52:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-02","2021-08-01","828"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-03 11:52:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8543",630,"SETTLED","A18-I208872","2020-08-03 11:52:57","2020-08-02","2","2020-08-03 11:52:57","2","2020-08-03 11:52:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:52:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8872","RENT","\u9810\u7e73\u79df\u91d1",1,2068,"MO","1",2068,"2","2020-08-03 11:52:57","2","2020-08-03 11:52:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:52:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8872","RENT","\u9810\u7e73\u79df\u91d1",2,2068,"MO","1",2068,"2","2020-08-03 11:52:57","2","2020-08-03 11:52:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:52:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8872","RENT","\u9810\u7e73\u79df\u91d1",3,2068,"MO","1",2068,"2","2020-08-03 11:52:57","2","2020-08-03 11:52:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:52:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8872","RENT","\u9810\u7e73\u79df\u91d1",4,2068,"MO","1",2068,"2","2020-08-03 11:52:57","2","2020-08-03 11:52:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:52:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8872","RENT","\u9810\u7e73\u79df\u91d1",5,2068,"MO","1",2068,"2","2020-08-03 11:52:57","2","2020-08-03 11:52:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:52:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8872","RENT","\u9810\u7e73\u79df\u91d1",6,2068,"MO","1",2068,"2","2020-08-03 11:52:57","2","2020-08-03 11:52:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:52:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8872","RENT","\u9810\u7e73\u79df\u91d1",7,2068,"MO","1",2068,"2","2020-08-03 11:52:57","2","2020-08-03 11:52:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:52:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8872","RENT","\u9810\u7e73\u79df\u91d1",8,2068,"MO","1",2068,"2","2020-08-03 11:52:57","2","2020-08-03 11:52:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:52:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8872","RENT","\u9810\u7e73\u79df\u91d1",9,2068,"MO","1",2068,"2","2020-08-03 11:52:57","2","2020-08-03 11:52:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:52:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8872","RENT","\u9810\u7e73\u79df\u91d1",10,2068,"MO","1",2068,"2","2020-08-03 11:52:57","2","2020-08-03 11:52:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:52:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8872","RENT","\u9810\u7e73\u79df\u91d1",11,2068,"MO","1",2068,"2","2020-08-03 11:52:57","2","2020-08-03 11:52:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:52:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8872","RENT","\u9810\u7e73\u79df\u91d1",12,2068,"MO","1",2068,"2","2020-08-03 11:52:57","2","2020-08-03 11:52:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:52:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[24816,0,"8872"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-03 11:52:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[630,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208515","2020-08-03 11:52:57",24816,"2","2020-08-03 11:52:57","2","2020-08-03 11:52:57","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:52:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8515","DEPOSIT",null,"PAID","2020-08-03 11:52:57",0,"2","2020-08-03 11:52:57","2","2020-08-03 11:52:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 11:52:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8515","INVOICE","8872","PAID","2020-08-03 11:52:57",24816,"2","2020-08-03 11:52:57","2","2020-08-03 11:52:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:02:39","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":773,"customer_code":"C180773","identity_type":"PERSONAL","identity_id":"D373874(5)","title":"Ms","lastname":"Tung","firstname":"Wing Man Leon","companyname":"","email":"leontung3316@gmail.com","tel":"94519119","address":"\u9d28\u8137\u6d32\u5229\u6771\u90a8\u6771\u8302\u6a133316\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1106.0","renew_rent_month":"6","renew_warehousing_date":"2020-08-12","renew_room_key":"055,48999","renew_remark":"6 months contract. Storage rental paid by bank transfer on January 24, 2020. Storage deposit transferred from agreement A12-CT195693 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207051, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"176","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"176","room_code":"C52","retail_price":"1098.0","discounted_price":989,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1106,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6636,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-08-12","rent_from":"2020-08-12","rent_to":"2021-02-11","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on August 1, 2020. Storage deposit transferred from agreement A12-CT207051 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6636,"final_order_total":6636,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,48999","order_product":[],"pass":true}},"first_order_id":"4321","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> C52 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1106.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:02:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",773,"NEW","A12-CT208544",1098,1106,0,0,"6","6",6636,6636,6636,"2020-08-03 12:02:40","0",null,null,null,"2020-08-12","2021-02-11","6 months contract. Storage rental paid by bank transfer on August 1, 2020. Storage deposit transferred from agreement A12-CT207051 to this agreement.\r\n","2020-08-12","16",0,null,0,"0.00","2","2020-08-03 12:02:39","2","2020-08-03 12:02:39","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,48999","C180773","PERSONAL","Ms","nmwyYN7qyIuDF3uEG2nb+Q==","INIqO3p6N\/stXk+6gk8Omw==","","JP4Rs\/ygk7B5+4qY1O\/77r+Pkok3QgKRdcK1ujWYUCDF7Hm6br4NOIzZzbzk9QmS","Usn4HJwcx8OnBBfEeBjoig==","\/ak17E8PQ7Xm\/ov3TGy\/WQpItNrB0\/xsvpFV74jhn6I=","BcyXhXGePJg4Pz0Q8zP\/Uw==",null,1,"4321"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:02:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["8544","72","8","176","%","9.93",109.0314,"2","2020-08-03 12:02:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:02:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8544","176","1098.0",989,"2","2020-08-03 12:02:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:02:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-12","2021-02-11","176"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-03 12:02:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8544",773,"SETTLED","A12-I208873","2020-08-03 12:02:39","2020-08-12","2","2020-08-03 12:02:39","2","2020-08-03 12:02:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:02:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8873","RENT","\u9810\u7e73\u79df\u91d1",1,1106,"MO","1",1106,"2","2020-08-03 12:02:39","2","2020-08-03 12:02:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:02:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8873","RENT","\u9810\u7e73\u79df\u91d1",2,1106,"MO","1",1106,"2","2020-08-03 12:02:39","2","2020-08-03 12:02:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:02:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8873","RENT","\u9810\u7e73\u79df\u91d1",3,1106,"MO","1",1106,"2","2020-08-03 12:02:39","2","2020-08-03 12:02:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:02:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8873","RENT","\u9810\u7e73\u79df\u91d1",4,1106,"MO","1",1106,"2","2020-08-03 12:02:39","2","2020-08-03 12:02:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:02:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8873","RENT","\u9810\u7e73\u79df\u91d1",5,1106,"MO","1",1106,"2","2020-08-03 12:02:39","2","2020-08-03 12:02:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:02:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8873","RENT","\u9810\u7e73\u79df\u91d1",6,1106,"MO","1",1106,"2","2020-08-03 12:02:39","2","2020-08-03 12:02:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:02:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6636,0,"8873"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-03 12:02:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[773,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208516","2020-08-03 12:02:39",6636,"2","2020-08-03 12:02:39","2","2020-08-03 12:02:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:02:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8516","DEPOSIT",null,"PAID","2020-08-03 12:02:39",0,"2","2020-08-03 12:02:39","2","2020-08-03 12:02:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:02:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8516","INVOICE","8873","PAID","2020-08-03 12:02:39",6636,"2","2020-08-03 12:02:39","2","2020-08-03 12:02:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:09:17","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":570,"customer_code":"C170570","identity_type":"PERSONAL","identity_id":"K817823(2)","title":"Ms","lastname":"Yuen","firstname":"Sze Wan Cewan","companyname":"","email":"cewanyuen@yahoo.com.hk","tel":"93190159","address":"Flat E, 8\/F, Blk 8, Chi Fu Fa Yuen, Pok Fu Lam, Hong kong","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":"2","renew_warehousing_date":"2020-07-01","renew_room_key":"137,17359","renew_remark":"1 month contract. Storage rental paid by bank transfer on May 8 and June 7, 2020. Storage deposit transferred from agreement A12-CT207826 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT208074, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"235","room_code":"D39","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":998,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-07-01","rent_from":"2020-07-01","rent_to":"2020-07-31","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on JULY 31, 2020. Storage deposit transferred from agreement A12-CT208074 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":998,"final_order_total":998,"location_id":"1","branch_id":"1","company_id":"1","room_key":"137,17359","order_product":[],"pass":true}},"first_order_id":"3800","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> D39 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"998.00","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:09:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",570,"NEW","A12-CT208545",998,998,0,0,"1","1",998,998,998,"2020-08-03 12:09:18","0",null,null,null,"2020-07-01","2020-07-31","1 month contract. Storage rental paid by bank transfer on JULY 31, 2020. Storage deposit transferred from agreement A12-CT208074 to this agreement.\r\n","2020-07-01","12",0,null,0,"0.00","2","2020-08-03 12:09:17","2","2020-08-03 12:09:17","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"137,17359","C170570","PERSONAL","Ms","cOVHZvoCSVf6Uh6Fd\/Oh2w==","DtbrOSvE4C7BOu5x4dBFtg==","","Av+ADiyvjVRBgUo03h3p6hpp6mcXgDaDJDvSxXwfQQosUJ1or1G3FIymGt9ddzamhEKDZyddjvFbjz9Eecftvg==","1l5cJvjJNKc2QtotYjeiiQ==","Lg+q8UB1y8C7eQ5vqzRcDiz\/WuEjcTUgxi3gM++AjHw=","CDRdPp1CIDhlh0eK\/Rafuw==",null,1,"3800"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:09: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":["8545","235","998.0","998.00","2","2020-08-03 12:09:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:09: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-01","2020-07-31","235"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-03 12:09: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":["8545",570,"SETTLED","A12-I208874","2020-08-03 12:09:17","2020-07-01","2","2020-08-03 12:09:17","2","2020-08-03 12:09:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:09: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":["8874","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-08-03 12:09:17","2","2020-08-03 12:09:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:09:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"8874"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-03 12:09: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":[570,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208517","2020-08-03 12:09:17",998,"2","2020-08-03 12:09:17","2","2020-08-03 12:09:17","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:09: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":["8517","DEPOSIT",null,"PAID","2020-08-03 12:09:17",0,"2","2020-08-03 12:09:17","2","2020-08-03 12:09:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:09: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":["8517","INVOICE","8874","PAID","2020-08-03 12:09:17",998,"2","2020-08-03 12:09:17","2","2020-08-03 12:09:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:15:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:15:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:15:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:44:02","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":755,"customer_code":"C180755","identity_type":"PERSONAL","identity_id":"D674816(4)","title":"Ms","lastname":"Lee","firstname":"Kam Mui","companyname":"","email":null,"tel":"54998807","address":"Flat F, 25\/F, Kam Fat Building, 145 Lee Chi Road, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-08-06","renew_room_key":"136,32469","renew_remark":"1 month contract. Storage rental paid by bank transfer on Jul 03, 2020. Storage deposit transferred from agreement A14-CT208000 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT208283, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"628","room_code":"M39","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-08-06","rent_from":"2020-08-06","rent_to":"2020-09-05","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on August 02, 2020. Storage deposit transferred from agreement A14-CT208283 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"136,32469","order_product":[],"pass":true}},"first_order_id":"4693","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> M39 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:44:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",755,"NEW","A14-CT208546",598,598,0,0,"1","1",598,598,598,"2020-08-03 12:44:03","0",null,null,null,"2020-08-06","2020-09-05","1 month contract. Storage rental paid by bank transfer on August 02, 2020. Storage deposit transferred from agreement A14-CT208283 to this agreement.\r\n","2020-08-06","12",0,null,0,"0.00","2","2020-08-03 12:44:02","2","2020-08-03 12:44:02","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,32469","C180755","PERSONAL","Ms","Bz\/rX4ASIpNafqhGM12E+g==","kiriEIqhcx866RNZiMXdKQ==","","J+qxNwNZZDybuSy0bJS1H3QTc7\/evdtOLUtQc4ivvsWPxn+cqVkhkN\/TohPrTXWpxmb7Nhoov\/XjNXxhd0djX6hEDvZ74IuDZYu9myZVwCs=","uTqJ0Kzbi8lcDPgXUMT73Q==",null,"fFKAofifZnWz0Rnx1R5aUA==",null,1,"4693"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:44:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8546","628","598.0","598.00","2","2020-08-03 12:44:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:44:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-06","2020-09-05","628"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-03 12:44:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8546",755,"SETTLED","A14-I208875","2020-08-03 12:44:02","2020-08-06","2","2020-08-03 12:44:02","2","2020-08-03 12:44:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:44:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8875","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-08-03 12:44:02","2","2020-08-03 12:44:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:44:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8875"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-03 12:44:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[755,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208518","2020-08-03 12:44:02",598,"2","2020-08-03 12:44:02","2","2020-08-03 12:44:02","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:44:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8518","DEPOSIT",null,"PAID","2020-08-03 12:44:02",0,"2","2020-08-03 12:44:02","2","2020-08-03 12:44:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:44:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8518","INVOICE","8875","PAID","2020-08-03 12:44:02",598,"2","2020-08-03 12:44:02","2","2020-08-03 12:44:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:49:35","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:00:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:06:43","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1185,"customer_code":"C191185","identity_type":"PERSONAL","identity_id":"D522909(0)","title":"Mr","lastname":"Lui","firstname":"Cheuk Ho","companyname":"","email":null,"tel":"60381903","address":"Flat\/Rm B, Mei Lun House, 2~4 Mei Lun Street, Central, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1322.0","renew_rent_month":"1","renew_warehousing_date":"2020-08-01","renew_room_key":"0012516868","renew_remark":"1 month contract. Storage rental paid by bank transfer on Jul 04,2020. Storage deposit $1322 transferred from agreement C15-CT208058 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT208294, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"173","order_discount":[],"order_room":[{"room_id":"1421","room_code":"C15-115","retail_price":"1322.0","discounted_price":"1322.00","location_id":"6"}],"roughly_size":"24","total_retail_price":1322,"total_discounted_price":1322,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1322,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-08-01","rent_from":"2020-08-01","rent_to":"2020-08-31","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on August 01,2020. Storage deposit $1322 transferred from agreement C15-CT208294 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1322,"final_order_total":1322,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012516868","order_product":[],"pass":true}},"first_order_id":"4243","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-115 <\/td>\r\n\t\t\t\t\t 4X6X6.5 <\/td>\r\n\t\t\t\t\t $1322.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":"24","total_discounted_price":"1322.00","deposit":"0.00","total_retail_price":"1322.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:06:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1185,"NEW","C15-CT208547",1322,1322,0,0,"1","1",1322,1322,1322,"2020-08-03 13:06:44","0",null,null,null,"2020-08-01","2020-08-31","1 month contract. Storage rental paid by bank transfer on August 01,2020. Storage deposit $1322 transferred from agreement C15-CT208294 to this agreement.\r\n","2020-08-01","24",0,null,0,"0.00","2","2020-08-03 13:06:43","2","2020-08-03 13:06:43","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012516868","C191185","PERSONAL","Mr","\/JQwF1+M6FL7Yun0+bBCFg==","vyCKi4IYWx3VnCZylJM1yA==","","M40cxW4GMmuJRXhcXM+Wt7bO\/WDVLnPGUxgCIY4qYL\/XYrR2lvobKWJ1rPDsF3EoUQ75QxAufkpF6LMIzO2Rkg==","KUOWIMoqsVaNtCRfR6snnQ==",null,"QAJCjnmgSugLsyxdh+ZSuA==",null,1,"4243"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:06:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8547","1421","1322.0","1322.00","2","2020-08-03 13:06:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:06:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-01","2020-08-31","1421"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-03 13:06:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8547",1185,"SETTLED","C15-I208876","2020-08-03 13:06:43","2020-08-01","2","2020-08-03 13:06:43","2","2020-08-03 13:06:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:06:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8876","RENT","\u9810\u7e73\u79df\u91d1",1,1322,"MO","1",1322,"2","2020-08-03 13:06:43","2","2020-08-03 13:06:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:06:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1322,0,"8876"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-03 13:06:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1185,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208519","2020-08-03 13:06:43",1322,"2","2020-08-03 13:06:43","2","2020-08-03 13:06:43","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:06:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8519","DEPOSIT",null,"PAID","2020-08-03 13:06:43",0,"2","2020-08-03 13:06:43","2","2020-08-03 13:06:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:06:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8519","INVOICE","8876","PAID","2020-08-03 13:06:43",1322,"2","2020-08-03 13:06:43","2","2020-08-03 13:06:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:15:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:15:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:21:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:24:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:30:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:41:27","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=881&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1424,"customer_code":"C191424","identity_type":"PERSONAL","identity_id":"D148997(7)","title":"Ms","lastname":"SHEUNG","firstname":"Tsang Mui","companyname":"","email":null,"tel":"96102707","address":"Flat A, 13\/F, No 19 Greig Crescent, Quarry Bay, Hong Kong.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"735.0","renew_rent_month":"3","renew_warehousing_date":"2020-08-04","renew_room_key":"'0012489016","renew_remark":"3 months contract. Storage rental paid by bank transfer on May 06,2020. Deposit $773 transferred from agreement C15-CT207102 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT207788, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"164","order_discount":[],"order_room":[{"room_id":"1312","room_code":"C15-006","retail_price":"773.0","discounted_price":"773.00","location_id":"6"}],"roughly_size":"10","total_retail_price":773,"total_discounted_price":735,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2205,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-08-04","rent_from":"2020-08-04","rent_to":"2020-11-03","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on JULY 31,2020. Deposit $773 transferred from agreement C15-CT207788 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2205,"final_order_total":2205,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012489016","order_product":[],"pass":true}},"first_order_id":"6150","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-006 <\/td>\r\n\t\t\t\t\t 4X2.5X6.5 <\/td>\r\n\t\t\t\t\t $773.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"10","total_discounted_price":"735.00","deposit":"0.00","total_retail_price":"773.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:41:27","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",1424,"NEW","C15-CT208548",773,735,0,0,"3","3",2205,2205,2205,"2020-08-03 13:41:27","0",null,null,null,"2020-08-04","2020-11-03","3 months contract. Storage rental paid by bank transfer on JULY 31,2020. Deposit $773 transferred from agreement C15-CT207788 to this agreement.\r\n","2020-08-04","10",0,null,0,"0.00","2","2020-08-03 13:41:27","2","2020-08-03 13:41:27","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0012489016","C191424","PERSONAL","Ms","AAX9PhWQNYbujKJ0Pa5iWQ==","JKNOKuxB8y\/wxkNzxEIjjQ==","","8WYXZRvXIf\/ZXNnXiEVMrtm8XrHbFzF\/WqhOXIomMWGV8NDtfsTiZAwuDfasGmus+IPaMXgBboAgbQM2EkkEJw==","+EAg0QD+zYfhd+1wDAP9eA==",null,"ry2sS1VYP3hAQBXXwRrxmg==",null,1,"6150"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:41:27","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":["8548","1312","773.0","773.00","2","2020-08-03 13:41:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:41:27","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-04","2020-11-03","1312"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-03 13:41:27","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":["8548",1424,"SETTLED","C15-I208877","2020-08-03 13:41:27","2020-08-04","2","2020-08-03 13:41:27","2","2020-08-03 13:41:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:41:27","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":["8877","RENT","\u9810\u7e73\u79df\u91d1",1,735,"MO","1",735,"2","2020-08-03 13:41:27","2","2020-08-03 13:41:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:41:27","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":["8877","RENT","\u9810\u7e73\u79df\u91d1",2,735,"MO","1",735,"2","2020-08-03 13:41:27","2","2020-08-03 13:41:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:41:27","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":["8877","RENT","\u9810\u7e73\u79df\u91d1",3,735,"MO","1",735,"2","2020-08-03 13:41:27","2","2020-08-03 13:41:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:41:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2205,0,"8877"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-03 13:41:27","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":[1424,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208520","2020-08-03 13:41:27",2205,"2","2020-08-03 13:41:27","2","2020-08-03 13:41:27","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:41:27","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":["8520","DEPOSIT",null,"PAID","2020-08-03 13:41:27",0,"2","2020-08-03 13:41:27","2","2020-08-03 13:41:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:41:27","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":["8520","INVOICE","8877","PAID","2020-08-03 13:41:27",2205,"2","2020-08-03 13:41:27","2","2020-08-03 13:41:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:51:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:52:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:52:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:53:32","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=881&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1141,"customer_code":"C181141","identity_type":"BUSINESS","identity_id":"provide later","title":"Mr","lastname":"Yu","firstname":"Tak Kei Ringo","companyname":"Bravo Creative Management Ltd.","email":"ringoyu@bcmhk.com","tel":"98319468","address":"Flat A, 15\/F, Vulcan House, 21-23 Leighton Road, Causeway Bay, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"2","renew_warehousing_date":"2020-06-08","renew_room_key":"0007310873","renew_remark":"2 months contract. Storage rental paid by bank transfer on May 18, 2020. Storage deposit transferred from agreement A05-CT207293 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207881, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"114","order_discount":[{"master_room_discount_id":"249","master_room_id":"114","discount_type":"%","price":"1290.00","disocunted_price":"1225.90","discount":"4.97","monthly_deduct":64.113,"room_id":"1013","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1013","room_code":"A05-011","retail_price":"1290.0","discounted_price":1225.9,"location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3870,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-06-08","rent_from":"2020-06-08","rent_to":"2020-09-07","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on AUGUST 03, 2020. Storage deposit transferred from agreement A05-CT207881 to this agreement.\r\n\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3870,"final_order_total":3870,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0007310873","order_product":[],"pass":true}},"first_order_id":"4707","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-011 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1290.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:53:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1141,"NEW","A05-CT208549",1290,1290,0,0,"3","3",3870,3870,3870,"2020-08-03 13:53:33","0",null,null,null,"2020-06-08","2020-09-07","3 months contract. Storage rental paid by bank transfer on AUGUST 03, 2020. Storage deposit transferred from agreement A05-CT207881 to this agreement.\r\n\r\n","2020-06-08","16",0,null,0,"0.00","2","2020-08-03 13:53:32","2","2020-08-03 13:53:32","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0007310873","C181141","BUSINESS","Mr","fPB5szRfhQDoFF8+NzJXtQ==","thtRZ5CDeQ9OOuodTdr1ng==","Bravo Creative Management Ltd.","zRpRHQsd21YbfDCyj7QmRR2rWUvgcz1ErepmgH\/IZuJV4UWK1YsDIzEgQ04zpuMx7hUgPpyvnTMu7YjPItiQRBRESa5DBBzR9k9gj2Xffyo=","2+bteiJtKwBy5oyidhRx8g==","cbLUhb9OxZTeK4XARdQo4RVP7SlgpymFj2VFLAjuUQg=",null,"ghkNgPwuN3BPyR+G706E0w==",1,"4707"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:53:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["8549","249","114","1013","%","4.97",64.113,"2","2020-08-03 13:53:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:53:33","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":["8549","1013","1290.0",1225.9,"2","2020-08-03 13:53:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:53:33","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-08","2020-09-07","1013"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-03 13:53:33","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":["8549",1141,"SETTLED","A05-I208878","2020-08-03 13:53:32","2020-06-08","2","2020-08-03 13:53:32","2","2020-08-03 13:53:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:53:33","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":["8878","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-08-03 13:53:32","2","2020-08-03 13:53:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:53:33","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":["8878","RENT","\u9810\u7e73\u79df\u91d1",2,1290,"MO","1",1290,"2","2020-08-03 13:53:32","2","2020-08-03 13:53:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:53:33","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":["8878","RENT","\u9810\u7e73\u79df\u91d1",3,1290,"MO","1",1290,"2","2020-08-03 13:53:32","2","2020-08-03 13:53:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:53:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3870,0,"8878"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-03 13:53:33","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":[1141,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208521","2020-08-03 13:53:32",3870,"2","2020-08-03 13:53:32","2","2020-08-03 13:53:32","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:53:33","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":["8521","DEPOSIT",null,"PAID","2020-08-03 13:53:32",0,"2","2020-08-03 13:53:32","2","2020-08-03 13:53:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 13:53:33","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":["8521","INVOICE","8878","PAID","2020-08-03 13:53:32",3870,"2","2020-08-03 13:53:32","2","2020-08-03 13:53:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:36:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:37:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:43:03","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ?, `customer_companyname` = ? where id = ?","parameters":["NEW","0012438299","6 months contract. Storage rental $6972 paid by bank transfer on March 11, 2020. Extra $276.2 for agreement A05-CT196522. Storage deposit transferred from agreement A05-CT196522 to this agreement.","2020-08-03 14:43:03","2","olN5\/Q5aAg1whjEZQduEyg==","BwMzW1CaiEBOI0sLOAXC3A==","+rm7+x1NKVNvV7vBo3lUfVcudasKwTH6eMIhGSAe47V3yjl2URuA0N33ASXkjlrreW2xFoDyx0wB6Ls9SIduJw==","GZye1tNhcqO+\/ho\/T\/MS\/w==","0pqragv3w+r75IDnQ7c6qxTu+iPrIFZPsCQHwQID996MP50hYhUyYuN656X039Ab","Smiley APAC Limited",7442]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:56:18","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 15:50:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 15:59:07","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":685,"customer_code":"C180685","identity_type":"PERSONAL","identity_id":"Z136565(8)","title":"Mr","lastname":"Tam","firstname":"Wai Hung","companyname":"","email":null,"tel":"61102922","address":"Room 210, Wah Lai House, Wah Kwai Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2298.0","renew_rent_month":"1","renew_warehousing_date":"2020-08-01","renew_room_key":"053,56239","renew_remark":"1 month contract. Storage rental $2300 paid by bank transfer on June 02, 2020. Storage deposit transferred from agreement A18-CT208003 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT208275, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"81","order_discount":[],"order_room":[{"room_id":"857","room_code":"T01","retail_price":"2298.0","discounted_price":"2298.00","location_id":"3"}],"roughly_size":"30","total_retail_price":2298,"total_discounted_price":2300,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2300,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-08-01","rent_from":"2020-08-01","rent_to":"2020-08-31","delivery_service":"0","remark":"1 month contract. Storage rental $2300 paid by bank transfer on August 03, 2020. Storage deposit transferred from agreement A18-CT208275 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2300,"final_order_total":2300,"location_id":"3","branch_id":"1","company_id":"1","room_key":"053,56239","order_product":[],"pass":true}},"first_order_id":"4879","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> T01 <\/td>\r\n\t\t\t\t\t 5X6X7 <\/td>\r\n\t\t\t\t\t $2298.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":"30","total_discounted_price":"2300.00","deposit":"0.00","total_retail_price":"2298.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 15:59:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",685,"NEW","A18-CT208550",2298,2300,0,0,"1","1",2300,2300,2300,"2020-08-03 15:59:07","0",null,null,null,"2020-08-01","2020-08-31","1 month contract. Storage rental $2300 paid by bank transfer on August 03, 2020. Storage deposit transferred from agreement A18-CT208275 to this agreement.\r\n","2020-08-01","30",0,null,0,"0.00","2","2020-08-03 15:59:07","2","2020-08-03 15:59:07","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"053,56239","C180685","PERSONAL","Mr","Vy30hO8KRRcWAyFHMj+GkQ==","RAqogkelEKt1q5b\/6Neu\/g==","","T1rrupXx2a84nbfDVVe7dRZNixC4wynq7dBDu6A1cSJX7dG0wQgUJ6ZUu1fBgxwDKFNAcVyti6Of6RFkiuBYCg==","\/abipioEOeirm5gkDUnYEA==",null,"HSRQWr1h55jzD6yUUsYl4g==",null,1,"4879"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 15:59:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8550","857","2298.0","2298.00","2","2020-08-03 15:59:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 15:59:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-01","2020-08-31","857"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-03 15:59:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8550",685,"SETTLED","A18-I208879","2020-08-03 15:59:07","2020-08-01","2","2020-08-03 15:59:07","2","2020-08-03 15:59:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 15:59:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8879","RENT","\u9810\u7e73\u79df\u91d1",1,2300,"MO","1",2300,"2","2020-08-03 15:59:07","2","2020-08-03 15:59:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 15:59:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2300,0,"8879"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-03 15:59:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[685,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208522","2020-08-03 15:59:07",2300,"2","2020-08-03 15:59:07","2","2020-08-03 15:59:07","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 15:59:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8522","DEPOSIT",null,"PAID","2020-08-03 15:59:07",0,"2","2020-08-03 15:59:07","2","2020-08-03 15:59:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 15:59:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8522","INVOICE","8879","PAID","2020-08-03 15:59:07",2300,"2","2020-08-03 15:59:07","2","2020-08-03 15:59:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 16:11:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 16:31:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 16:32:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 16:33:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 16:46:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 16:48:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 16:49:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 16:50:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 16:50:53","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","053,56239","1 month contract. Storage rental $2300 paid by bank transfer on August 03, 2020. Storage deposit transferred from agreement A18-CT208275 to this agreement.\r\n","2020-08-03 16:50:52","2","RAqogkelEKt1q5b\/6Neu\/g==","Vy30hO8KRRcWAyFHMj+GkQ==","\/abipioEOeirm5gkDUnYEA==","T1rrupXx2a84nbfDVVe7dRZNixC4wynq7dBDu6A1cSJX7dG0wQgUJ6ZUu1fBgxwDKFNAcVyti6Of6RFkiuBYCg==",8550]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 16:53: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=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":685,"customer_code":"C180685","identity_type":"PERSONAL","identity_id":"Z136565(8)","title":"Mr","lastname":"Tam","firstname":"Wai Hung","companyname":"","email":null,"tel":"61102922","address":"Room 210, Wah Lai House, Wah Kwai Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2300.0","renew_rent_month":"1","renew_warehousing_date":"2020-09-01","renew_room_key":"053,56239","renew_remark":"1 month contract. Storage rental $2300 paid by bank transfer on August 03, 2020. Storage deposit transferred from agreement A18-CT208275 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT208550, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"81","order_discount":[],"order_room":[{"room_id":"857","room_code":"T01","retail_price":"2298.0","discounted_price":"2298.00","location_id":"3"}],"roughly_size":"30","total_retail_price":2298,"total_discounted_price":2298,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2298,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-08-01","rent_from":"2020-08-01","rent_to":"2020-08-31","delivery_service":"0","remark":"1 month contract. Storage rental $2300 paid by bank transfer on August 03, 2020. Storage deposit transferred from agreement A18-CT208275 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2298,"final_order_total":2298,"location_id":"3","branch_id":"1","company_id":"1","room_key":"053,56239","order_product":[],"pass":true}},"first_order_id":"4879","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> T01 <\/td>\r\n\t\t\t\t\t 5X6X7 <\/td>\r\n\t\t\t\t\t $2298.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","floor_plan_rent_room":[],"roughly_size":"30","total_discounted_price":"2298.00","deposit":"0.00","total_retail_price":"2298.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 16:53:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",685,"NEW","A18-CT208551",2298,2298,0,0,"1","1",2298,2298,2298,"2020-08-03 16:53:15","0",null,null,null,"2020-08-01","2020-08-31","1 month contract. Storage rental $2300 paid by bank transfer on August 03, 2020. Storage deposit transferred from agreement A18-CT208275 to this agreement.\r\n","2020-08-01","30",0,null,0,"0.00","2","2020-08-03 16:53:14","2","2020-08-03 16:53:14","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"053,56239","C180685","PERSONAL","Mr","Vy30hO8KRRcWAyFHMj+GkQ==","RAqogkelEKt1q5b\/6Neu\/g==","","T1rrupXx2a84nbfDVVe7dRZNixC4wynq7dBDu6A1cSJX7dG0wQgUJ6ZUu1fBgxwDKFNAcVyti6Of6RFkiuBYCg==","\/abipioEOeirm5gkDUnYEA==",null,"HSRQWr1h55jzD6yUUsYl4g==",null,1,"4879"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 16:53:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8551","857","2298.0","2298.00","2","2020-08-03 16:53:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 16:53:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-01","2020-08-31","857"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-03 16:53:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8551",685,"SETTLED","A18-I208880","2020-08-03 16:53:14","2020-08-01","2","2020-08-03 16:53:14","2","2020-08-03 16:53:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 16:53:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8880","RENT","\u9810\u7e73\u79df\u91d1",1,2298,"MO","1",2298,"2","2020-08-03 16:53:14","2","2020-08-03 16:53:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 16:53:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2298,0,"8880"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-03 16:53:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[685,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208523","2020-08-03 16:53:14",2298,"2","2020-08-03 16:53:14","2","2020-08-03 16:53:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 16:53:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8523","DEPOSIT",null,"PAID","2020-08-03 16:53:14",0,"2","2020-08-03 16:53:14","2","2020-08-03 16:53:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 16:53:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8523","INVOICE","8880","PAID","2020-08-03 16:53:14",2298,"2","2020-08-03 16:53:14","2","2020-08-03 16:53:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 16:53:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 17:05:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 17:42:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 17:59:07","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1285,"customer_code":"C191285","identity_type":"PERSONAL","identity_id":"D593953(5)","title":"Mr","lastname":"Chiu","firstname":"Chi Yeung John","companyname":"","email":"johnchiu99@gmail.com","tel":"93875676","address":"Block C, 10\/F, 6 Scenic Villa Drive, Pok Fu Lam, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1269.0","renew_rent_month":"13","renew_warehousing_date":"2020-07-04","renew_room_key":"076,43984","renew_remark":"13 months contract. Special offer, one month free. Storage rental and deposit paid by EPS on June 3, 2019. Smartcard provided on June 3, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT195141, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2820.0","renew_master_room_id":"203","order_discount":[],"order_room":[{"room_id":"1571","room_code":"A16-080(\u670d\u88dd\u5009)","retail_price":"1410.0","discounted_price":"1410.00","location_id":"7"}],"roughly_size":"16","total_retail_price":1410,"total_discounted_price":1339,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":0,"prepaid_amount":0,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-07-04","rent_from":"2020-07-04","rent_to":"2020-10-03","delivery_service":"0","remark":"3 months contract. Storage rental and deposit paid by EPS on JULY 09, 2020. Storage deposit transferred from agreement A16-CT195141 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":4017,"final_order_total":4017,"location_id":"7","branch_id":"1","company_id":"1","room_key":"076,43984","order_product":[],"pass":true}},"first_order_id":5141,"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-080(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1410.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":"1339.00","deposit":"0.00","total_retail_price":"1410.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 17:59:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","7",1285,"NEW","A16-CT208552",1410,1339,0,0,"3",0,0,4017,4017,"2020-08-03 17:59:07","0",null,null,null,"2020-07-04","2020-10-03","3 months contract. Storage rental and deposit paid by EPS on JULY 09, 2020. Storage deposit transferred from agreement A16-CT195141 to this agreement.\r\n","2020-07-04","16",0,null,0,"0.00","2","2020-08-03 17:59:07","2","2020-08-03 17:59:07","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"076,43984","C191285","PERSONAL","Mr","FR0aE3lsRYHwCsh7vTRF9A==","sQFQFKDK2lCJDg4WUvEEAw==","","m1pATs1zyqoM6dthU1yUytiigtoULF6e5ETtAK2KHn+HG9hKa1shHMQZWB8NoGVJ4+z89+BmIgytkcx3E1YQlQ==","4MOWbWbtvPJHjNQJG86YtA==","4C9S7TkIUP67Xb0vdsPKihFBiLXVFFIKcprul2DUaxc=","390P2Q+VeniYy5+xQDGN+g==",null,1,5141]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 17:59:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8552","1571","1410.0","1410.00","2","2020-08-03 17:59:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 17:59:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-04","2020-10-03","1571"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-03 17:59:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8552",1285,"SETTLED","A16-I208881","2020-08-03 17:59:07","2020-07-04","2","2020-08-03 17:59:07","2","2020-08-03 17:59:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 17:59:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8881","RENT","",1,1339,"MO","1",1339,"2","2020-08-03 17:59:07","2","2020-08-03 17:59:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 17:59:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1339,0,"8881"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-03 17:59:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1285,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P208524","2020-08-03 17:59:07",1339,"2","2020-08-03 17:59:07","2","2020-08-03 17:59:07","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 17:59:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8524","DEPOSIT",null,"PAID","2020-08-03 17:59:07",0,"2","2020-08-03 17:59:07","2","2020-08-03 17:59:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 17:59:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8524","INVOICE","8881","PAID","2020-08-03 17:59:07",1339,"2","2020-08-03 17:59:07","2","2020-08-03 17:59:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:00:24","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","'0005966491","6 months contract. Special offer 5% \"Rent Now\" Discount. Storage deposit and first month rent paid by EPS on April 14, 2020. The second month rental paid on ??. The third month rental $861 paid by bank transfer on June 30. The fourth month rental paid by bank transfer on Aug 03. Smartcard and padlock provided on April 14, 2020. ","2020-08-03 18:00:24","2","lzYHeN8huCtTtD2yf46tgA==","QUSfgMLAFUl2WGEt0iDylg==","svNA5KNaJY15HbgtuJVl9g==","5VH4hsU\/iJUlrqvFZkWOtn1mVRkx3FiDcTEX2\/\/iR9uD3uRRcE\/WH2CN9fLGZ6jraZmpBjuJNhDov1pjexKAVKyJZgoWvL6\/qVoZvOrw9qeYLWzTCnW9mrmI2QMDlbum",7607]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:02:44","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":677,"customer_code":"C180677","identity_type":"PERSONAL","identity_id":"D659149(4)","title":"Mr","lastname":"Man","firstname":"Sheung For","companyname":"","email":null,"tel":"92623590","address":"Flat 31E, Block 3, South Wave Court, 3 Shum Wan Road, Wong Chuk Hang, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"981.0","renew_rent_month":"6","renew_warehousing_date":"2020-07-03","renew_room_key":"055,10258","renew_remark":"6 months contract. Storage rental paid by cash on January 2, 2020. Storage deposit transferred from agreement A18-CT195374 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT206826, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"77","order_discount":[],"order_room":[{"room_id":"976","room_code":"X01","retail_price":"1090.0","discounted_price":"1090.00","location_id":"3"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":981,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5886,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-07-03","rent_from":"2020-07-03","rent_to":"2021-01-02","delivery_service":"0","remark":"6 months contract. Storage rental paid by cash on JULY 1, 2020. Storage deposit transferred from agreement A18-CT206826 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","discount_deduct":0,"order_total":5886,"final_order_total":5886,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,10258","order_product":[],"pass":true,"paymethod_other2":""}},"first_order_id":6826,"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> X01 <\/td>\r\n\t\t\t\t\t 3X4X7 <\/td>\r\n\t\t\t\t\t $1090.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"981.00","deposit":"0.00","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:02:45","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",677,"NEW","A18-CT208553",1090,981,0,0,"6","6",5886,5886,5886,"2020-08-03 18:02:45","0",null,null,null,"2020-07-03","2021-01-02","6 months contract. Storage rental paid by cash on JULY 1, 2020. Storage deposit transferred from agreement A18-CT206826 to this agreement.\r\n","2020-07-03","12",0,null,0,"0.00","2","2020-08-03 18:02:44","2","2020-08-03 18:02:44","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,10258","C180677","PERSONAL","Mr","bdbvURXhDzGec5LyFz5qZg==","1iB+Fi5mVPBhoP\/ei\/0Bag==","","K0Ap1tpRFk8d92PQMlS6iCIwlUU8OUp63O6yHT3BNM61oJlgYkNF1tEIEtGoGcVBZPgBYYDJg\/5d+BweDGu0i9DyslPfH+5qpRdFgJ+lI9E=","zH1u9g1iPEwvZeiniQTHgg==",null,"I21g9y1hVBZcy2tQN8KK\/A==",null,1,6826]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:02:45","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":["8553","976","1090.0","1090.00","2","2020-08-03 18:02:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:02:45","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-03","2021-01-02","976"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-03 18:02:45","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":["8553",677,"SETTLED","A18-I208882","2020-08-03 18:02:44","2020-07-03","2","2020-08-03 18:02:44","2","2020-08-03 18:02:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:02:45","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":["8882","RENT","\u9810\u7e73\u79df\u91d1",1,981,"MO","1",981,"2","2020-08-03 18:02:44","2","2020-08-03 18:02:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:02:45","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":["8882","RENT","\u9810\u7e73\u79df\u91d1",2,981,"MO","1",981,"2","2020-08-03 18:02:44","2","2020-08-03 18:02:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:02:45","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":["8882","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2020-08-03 18:02:44","2","2020-08-03 18:02:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:02:45","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":["8882","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2020-08-03 18:02:44","2","2020-08-03 18:02:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:02:45","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":["8882","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2020-08-03 18:02:44","2","2020-08-03 18:02:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:02:45","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":["8882","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2020-08-03 18:02:44","2","2020-08-03 18:02:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:02:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5886,0,"8882"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-03 18:02:45","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":[677,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208525","2020-08-03 18:02:44",5886,"2","2020-08-03 18:02:44","2","2020-08-03 18:02:44","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:02:45","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":["8525","DEPOSIT",null,"PAID","2020-08-03 18:02:44",0,"2","2020-08-03 18:02:44","2","2020-08-03 18:02:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:02:45","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":["8525","INVOICE","8882","PAID","2020-08-03 18:02:44",5886,"2","2020-08-03 18:02:44","2","2020-08-03 18:02:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:12:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:17:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:25:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:30:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:35:12","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","076,43984","3 months contract. Storage rental and deposit paid by EPS on JULY 09, 2020. Storage deposit transferred from agreement A16-CT195141 to this agreement.\r\n","2020-08-03 18:35:12","2","sQFQFKDK2lCJDg4WUvEEAw==","FR0aE3lsRYHwCsh7vTRF9A==","4C9S7TkIUP67Xb0vdsPKihFBiLXVFFIKcprul2DUaxc=","4MOWbWbtvPJHjNQJG86YtA==","m1pATs1zyqoM6dthU1yUytiigtoULF6e5ETtAK2KHn+HG9hKa1shHMQZWB8NoGVJ4+z89+BmIgytkcx3E1YQlQ==",8552]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:38:31","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:40:36","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":"","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1571","master_room_id":"203","room_code":"A16-080"}],"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-080(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1410.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"D593953(5)","title":"Mr","lastname":"Chiu","firstname":"Chi Yeung John","companyname":"","email":"johnchiu99@gmail.com","tel":"93875676","address":"Block C, 10\/F, 6 Scenic Villa Drive, Pok Fu Lam, Hong Kong","pass":true,"customer_id":"1285","customer_code":"C191285","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1571","room_code":"A16-080(\u670d\u88dd\u5009)","retail_price":"1410.0","discounted_price":"1410.00","location_id":"7"}],"roughly_size":"16","total_retail_price":1410,"total_discounted_price":1339,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":4017,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-07-04","rent_from":"2020-07-04","rent_to":"2020-10-03","delivery_service":"0","remark":"3 months contract. Storage rental and deposit paid by bank transfer on JULY 09, 2020. Storage deposit transferred from agreement A16-CT195141 to this agreement.","paymethod":"UNPAID","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4017,"final_order_total":4017,"location_id":"7","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"roughly_size":"16","total_discounted_price":"1339.00","deposit":"0.00","total_retail_price":"1410.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:40:37","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","1285","NEW","A16-CT208554",1410,1339,0,0,"3","3",4017,4017,4017,"2020-08-03 18:40:37","0",null,null,null,"2020-07-04","2020-10-03","3 months contract. Storage rental and deposit paid by bank transfer on JULY 09, 2020. Storage deposit transferred from agreement A16-CT195141 to this agreement.","2020-07-04","16",0,null,0,"0.00","2","2020-08-03 18:40:36","2","2020-08-03 18:40:36","UNPAID","","","","BANKIN","","","",null,0,"","C191285","PERSONAL","Mr","FR0aE3lsRYHwCsh7vTRF9A==","sQFQFKDK2lCJDg4WUvEEAw==","","m1pATs1zyqoM6dthU1yUytiigtoULF6e5ETtAK2KHn+HG9hKa1shHMQZWB8NoGVJ4+z89+BmIgytkcx3E1YQlQ==","4MOWbWbtvPJHjNQJG86YtA==","4C9S7TkIUP67Xb0vdsPKihFBiLXVFFIKcprul2DUaxc=","390P2Q+VeniYy5+xQDGN+g==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:40:37","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":["8554","1571","1410.0","1410.00","2","2020-08-03 18:40:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:40:37","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-04","2020-10-03","1571"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-03 18:40:37","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":["8554","1285","SETTLED","A16-I208883","2020-08-03 18:40:36","2020-07-04","2","2020-08-03 18:40:36","2","2020-08-03 18:40:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:40:37","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":["8883","RENT","\u9810\u7e73\u79df\u91d1",1,1339,"MO","1",1339,"2","2020-08-03 18:40:36","2","2020-08-03 18:40:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:40:37","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":["8883","RENT","\u9810\u7e73\u79df\u91d1",2,1339,"MO","1",1339,"2","2020-08-03 18:40:36","2","2020-08-03 18:40:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:40:37","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":["8883","RENT","\u9810\u7e73\u79df\u91d1",3,1339,"MO","1",1339,"2","2020-08-03 18:40:36","2","2020-08-03 18:40:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:40:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4017,0,"8883"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-03 18:40:37","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":["1285","UNPAID","","","","BANKIN","","","","PAID","P208526","2020-08-03 18:40:36",4017,"2","2020-08-03 18:40:36","2","2020-08-03 18:40:36","INVOICE"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:40:37","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":["8526","INVOICE","8883","PAID","2020-08-03 18:40:36",4017,"2","2020-08-03 18:40:36","2","2020-08-03 18:40:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:41:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:43:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:47:18","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:51: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=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"85","master_room_id":"10","room_code":"B33"}],"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> D03 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":0,"identity_type":"PERSONAL","identity_id":"G137660(7)","title":"Mr","lastname":"FUNG","firstname":"Ning Bor","companyname":"","email":null,"tel":"94870434","address":"Flat F, 16\/f, New Lucky House, 300 Nathan Road","pass":true,"customer_id":1193,"customer_code":"C191193","customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"68","master_room_id":"1","discount_type":"%","price":"598.00","disocunted_price":"538.20","discount":"10.00","monthly_deduct":59.8,"room_id":"199","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"12","renew_warehousing_date":"2020-08-05","renew_room_key":"08829670","renew_remark":"12 months contract. Special renewal offer, $300 Maxim's cake voucher offered. Storage rental paid by Cash on August 2, 2019. Storage deposit $1196 transferred from agreement A12-CT194289 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195609, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"1","order_room":[{"room_id":"199","room_code":"D03","retail_price":"598.0","discounted_price":538.2,"location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-08-05","rent_from":"2020-08-05","rent_to":"2021-02-04","delivery_service":"0","remark":"6 months contract. Storage rental paid by cash on Aug 03, 2020. Storage deposit $1196 transferred from agreement A12-CT195609 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"1","branch_id":"1","company_id":"1","room_key":"08829670","order_product":[],"pass":true}},"renew":1,"first_order_id":"4289","roughly_size":"12","total_discounted_price":"538.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:51:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",1193,"NEW","A12-CT208555",598,538,0,0,"6","6",3228,3228,3228,"2020-08-03 18:51:15","0",null,null,null,"2020-08-05","2021-02-04","6 months contract. Storage rental paid by cash on Aug 03, 2020. Storage deposit $1196 transferred from agreement A12-CT195609 to this agreement.","2020-08-05","12",0,null,0,"0","2","2020-08-03 18:51:14","2","2020-08-03 18:51:14","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"08829670","C191193","PERSONAL","Mr","dh8ZG+Dz1CE+KGF0K94w1Q==","cyZbjLKMtXmsqxQPpU0UpA==","","Jmwy8\/qygBY7U83EAdJZaSNkjOlWQXXMdoNCQFZXCrQrpCZDiF2ta\/zTF44zWSXY","tAdel36GDpocysgWqQB6Sg==",null,"wEVAcKdpxVM7jqbiMKi3HA==",null,1,"4289"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:51:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["8555","68","1","199","%","10.00",59.8,"2","2020-08-03 18:51:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:51:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8555","199","598.0",538.2,"2","2020-08-03 18:51:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:51:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-05","2021-02-04","199"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-03 18:51:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8555",1193,"SETTLED","A12-I208884","2020-08-03 18:51:14","2020-08-05","2","2020-08-03 18:51:14","2","2020-08-03 18:51:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:51:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8884","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-08-03 18:51:14","2","2020-08-03 18:51:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:51:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8884","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-08-03 18:51:14","2","2020-08-03 18:51:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:51:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8884","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-08-03 18:51:14","2","2020-08-03 18:51:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:51:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8884","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-08-03 18:51:14","2","2020-08-03 18:51:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:51:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8884","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-08-03 18:51:14","2","2020-08-03 18:51:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:51:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8884","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-08-03 18:51:14","2","2020-08-03 18:51:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:51:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"8884"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-03 18:51:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1193,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P208527","2020-08-03 18:51:14",3228,"2","2020-08-03 18:51:14","2","2020-08-03 18:51:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:51:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8527","DEPOSIT",null,"PAID","2020-08-03 18:51:14",0,"2","2020-08-03 18:51:14","2","2020-08-03 18:51:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:51:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8527","INVOICE","8884","PAID","2020-08-03 18:51:14",3228,"2","2020-08-03 18:51:14","2","2020-08-03 18:51:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:53:31","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 18:56:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 19:04:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****