{"created_at":"2020-05-27 09:49:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 12:06:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 12:10: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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":372,"customer_code":"C170372","identity_type":"PERSONAL","identity_id":"K171150(4)","title":"Mr","lastname":"Wong","firstname":"Ka Ho","companyname":"","email":null,"tel":"96530381","address":"Flat 3, 28\/F,Block H,Aberdeen Centre","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2206.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-25","renew_room_key":"053,55322","renew_remark":"6 months contract. Storage rental paid by EPS on Nov 23, 2019. Storage deposit transferred from agreement A14-CT195077 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196490, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"38","order_discount":[],"order_room":[{"room_id":"439","room_code":"J21","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"},{"room_id":"438","room_code":"J20","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"}],"roughly_size":"40","total_retail_price":3056,"total_discounted_price":2206,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":13236,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-25","rent_from":"2020-05-25","rent_to":"2020-11-24","delivery_service":"0","remark":"6 months contract. Storage rental paid by EPS on May 27, 2020. Storage deposit transferred from agreement A14-CT196490 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":13236,"final_order_total":13236,"location_id":"2","branch_id":"1","company_id":"1","room_key":"053,55322","order_product":[],"pass":true}},"first_order_id":"4437","selected_room_tr":"\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t

---

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

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

\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>
J21 <\/td>\r\n\t\t\t\t\t	4X5X8 <\/td>\r\n\t\t\t\t\t	$1528.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>
J20 <\/td>\r\n\t\t\t\t\t	4X5X8 <\/td>\r\n\t\t\t\t\t	$1528.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"40","total_discounted_price":"2206.0","deposit":"0","total_retail_price":"3056.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 12:10: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",372,"NEW","A14-CT207966",3056,2206,0,0,"6","6",13236,13236,13236,"2020-05-27 12:10:37","0",null,null,null,"2020-05-25","2020-11-24","6 months contract. Storage rental paid by EPS on May 27, 2020. Storage deposit transferred from agreement A14-CT196490 to this agreement.\r\n","2020-05-25","40",0,null,0,"0","2","2020-05-27 12:10:36","2","2020-05-27 12:10:36","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"053,55322","C170372","PERSONAL","Mr","tX4nEvQhpn+beYTpttDsYw==","hULSwM2MvFtpeV9\/z+er8Q==","","RXvAhM80s\/O7+D0Do2T54ERLNs+xga+REZoMhCWujP+Tv2VtkxzcU6bLBfl2YOWn","AKDn31kqQWl80f4\/h7o9Zw==",null,"DQ2zqkT8h3T7t0cA3NDcYw==",null,1,"4437"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 12:10: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":["7966","439","1528.0","1528.00","2","2020-05-27 12:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 12:10: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-05-25","2020-11-24","439"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-27 12:10: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":["7966","438","1528.0","1528.00","2","2020-05-27 12:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 12:10: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-05-25","2020-11-24","438"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-27 12:10: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":["7966",372,"SETTLED","A14-I208295","2020-05-27 12:10:36","2020-05-25","2","2020-05-27 12:10:36","2","2020-05-27 12:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 12:10: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":["8295","RENT","\u9810\u7e73\u79df\u91d1",1,2206,"MO","1",2206,"2","2020-05-27 12:10:36","2","2020-05-27 12:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 12:10: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":["8295","RENT","\u9810\u7e73\u79df\u91d1",2,2206,"MO","1",2206,"2","2020-05-27 12:10:36","2","2020-05-27 12:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 12:10: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":["8295","RENT","\u9810\u7e73\u79df\u91d1",3,2206,"MO","1",2206,"2","2020-05-27 12:10:36","2","2020-05-27 12:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 12:10: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":["8295","RENT","\u9810\u7e73\u79df\u91d1",4,2206,"MO","1",2206,"2","2020-05-27 12:10:36","2","2020-05-27 12:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 12:10: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":["8295","RENT","\u9810\u7e73\u79df\u91d1",5,2206,"MO","1",2206,"2","2020-05-27 12:10:36","2","2020-05-27 12:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 12:10: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":["8295","RENT","\u9810\u7e73\u79df\u91d1",6,2206,"MO","1",2206,"2","2020-05-27 12:10:36","2","2020-05-27 12:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 12:10:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13236,0,"8295"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-27 12:10: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":[372,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207939","2020-05-27 12:10:36",13236,"2","2020-05-27 12:10:36","2","2020-05-27 12:10:36","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 12:10: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":["7939","DEPOSIT",null,"PAID","2020-05-27 12:10:36",0,"2","2020-05-27 12:10:36","2","2020-05-27 12:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 12:10: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":["7939","INVOICE","8295","PAID","2020-05-27 12:10:36",13236,"2","2020-05-27 12:10:36","2","2020-05-27 12:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 12:38:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 14:10:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 16:13:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 16:30:09","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1467&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1062","master_room_id":"108","room_code":"A05-060"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":840,"customer_code":"C180840","identity_type":"PERSONAL","identity_id":"A705793(0)","title":"Mr","lastname":"Kam","firstname":"Chow","companyname":"","email":null,"tel":"93279952","address":"Room 1706, Ka Sing House, Ka Lung Court, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"13","renew_warehousing_date":"2020-07-01","renew_room_key":"189,02144","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by bank transfer on May 17, 2019. Storage deposit transferred from agreement A14-CT183766 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195004, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"697","room_code":"N14","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":1196,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":7652,"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":"2021-06-30","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on May 27, 2020. Storage deposit transferred from agreement A14-CT195004to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":7652,"final_order_total":7652,"location_id":"2","branch_id":"1","company_id":"1","room_key":"189,02144","order_product":[],"pass":true}},"first_order_id":"3766","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> N14 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"538.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 16:30:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",840,"NEW","A14-CT207967",598,538,1196,0,"12","12",7652,7652,7652,"2020-05-27 16:30:09","0",null,null,null,"2020-07-01","2021-06-30","12 months contract. Storage rental paid by bank transfer on May 27, 2020. Storage deposit transferred from agreement A14-CT195004to this agreement.\r\n","2020-07-01","12",0,null,0,"0","2","2020-05-27 16:30:09","2","2020-05-27 16:30:09","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"189,02144","C180840","PERSONAL","Mr","anq5M29vFb7FteUGD1jgrQ==","23wCRdcybxUEHt5OHLfIwQ==","","iWJAKwphsQIJ0QxJ5Gtuu+6xdRtdn3TXA11ye1DWvN9rEUHtFIt\/OuKk\/RdRIVmWe5R6kvFOkJdE2psPrJgYSw==","44HV2RFm2K\/vF6X+fl0eNw==",null,"7zi+39sbBDCfxRMh+7fABQ==",null,1,"3766"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 16:30:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7967","697","598.0","598.00","2","2020-05-27 16:30:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 16:30:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-01","2021-06-30","697"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-27 16:30:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["7967","A14-D205433","PAID",1196,0,"2021-06-30","2020-05-27 16:30:09","2020-05-27 16:30:09","2","2020-05-27 16:30:09","2","2020-05-27 16:30:09",840]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 16:30:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7967",840,"SETTLED","A14-I208296","2020-05-27 16:30:09","2020-07-01","2","2020-05-27 16:30:09","2","2020-05-27 16:30:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 16:30:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8296","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-05-27 16:30:09","2","2020-05-27 16:30:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 16:30:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8296","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-05-27 16:30:09","2","2020-05-27 16:30:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 16:30:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8296","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-05-27 16:30:09","2","2020-05-27 16:30:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 16:30:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8296","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-05-27 16:30:09","2","2020-05-27 16:30:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 16:30:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8296","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-05-27 16:30:09","2","2020-05-27 16:30:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 16:30:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8296","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-05-27 16:30:09","2","2020-05-27 16:30:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 16:30:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8296","RENT","\u9810\u7e73\u79df\u91d1",7,538,"MO","1",538,"2","2020-05-27 16:30:09","2","2020-05-27 16:30:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 16:30:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8296","RENT","\u9810\u7e73\u79df\u91d1",8,538,"MO","1",538,"2","2020-05-27 16:30:09","2","2020-05-27 16:30:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 16:30:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8296","RENT","\u9810\u7e73\u79df\u91d1",9,538,"MO","1",538,"2","2020-05-27 16:30:09","2","2020-05-27 16:30:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 16:30:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8296","RENT","\u9810\u7e73\u79df\u91d1",10,538,"MO","1",538,"2","2020-05-27 16:30:09","2","2020-05-27 16:30:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 16:30:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8296","RENT","\u9810\u7e73\u79df\u91d1",11,538,"MO","1",538,"2","2020-05-27 16:30:09","2","2020-05-27 16:30:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 16:30:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8296","RENT","\u9810\u7e73\u79df\u91d1",12,538,"MO","1",538,"2","2020-05-27 16:30:09","2","2020-05-27 16:30:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 16:30:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6456,0,"8296"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-27 16:30:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[840,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207940","2020-05-27 16:30:09",7652,"2","2020-05-27 16:30:09","2","2020-05-27 16:30:09","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 16:30:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7940","DEPOSIT","5433","PAID","2020-05-27 16:30:09",1196,"2","2020-05-27 16:30:09","2","2020-05-27 16:30:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 16:30:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7940","INVOICE","8296","PAID","2020-05-27 16:30:09",6456,"2","2020-05-27 16:30:09","2","2020-05-27 16:30:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 17:28:22","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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":254,"customer_code":"C160254","identity_type":"PERSONAL","identity_id":"D278564(2)","title":"Ms","lastname":"Mok","firstname":"Chui Ling Grace","companyname":"","email":"gracemok2011@gmail.com","tel":"91207972","address":"23D,Tower 4,South Horizons,Ap Lei Chau,Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1607.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-24","renew_room_key":"055,06737","renew_remark":"6 months contract. Storage rental paid by EPS on Dec 5, 2019. Storage deposit transferred from agreement A12-CT195026 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196613, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[{"master_room_discount_id":"70","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"898.60","discount":"9.96","monthly_deduct":99.4008,"room_id":"340","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"351","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"351","room_code":"F36","retail_price":"1098.0","discounted_price":989,"location_id":"1"},{"room_id":"340","room_code":"F25","retail_price":"998.0","discounted_price":898.6,"location_id":"1"}],"roughly_size":"28","total_retail_price":2096,"total_discounted_price":1607,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":9642,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-24","rent_from":"2020-05-24","rent_to":"2020-11-23","delivery_service":"0","remark":"6 months contract. Storage rental paid by EPS on May 25,2020. Storage deposit transferred from agreement A12-CT196613 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":9642,"final_order_total":9642,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,06737","order_product":[],"pass":true}},"first_order_id":"4406","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> F36 <\/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> F25 <\/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":"28","total_discounted_price":"1607.0","deposit":"0","total_retail_price":"2096.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 17:28:23","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",254,"NEW","A12-CT207968",2096,1607,0,0,"6","6",9642,9642,9642,"2020-05-27 17:28:23","0",null,null,null,"2020-05-24","2020-11-23","6 months contract. Storage rental paid by EPS on May 25,2020. Storage deposit transferred from agreement A12-CT196613 to this agreement.","2020-05-24","28",0,null,0,"0","2","2020-05-27 17:28:22","2","2020-05-27 17:28:22","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"055,06737","C160254","PERSONAL","Ms","E9yLbHbvUbaKvKbn2VOUrg==","ELGiy8l3QksCSVYDm2XBjg==","","VA+KhjDIaiSimAryPmW8lg6CikfhN+knH6xDLzQ9T7HlBEfHxsB6VsGzQhOoup\/rA+9oIFAIeedkQQnfWRA4oA==","BSgqDazfObIr2RH3Js3gUw==","gVOr3ZQ5k2Pr7Xy88sFPHIHXgZFX895640X4\/Lor25U=","M0T75rBnlqFfw0+9iFl60A==",null,1,"4406"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 17:28:23","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":["7968","70","6","340","%","9.96",99.4008,"2","2020-05-27 17:28:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 17:28:23","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":["7968","72","8","351","%","9.93",109.0314,"2","2020-05-27 17:28:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 17:28:23","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":["7968","351","1098.0",989,"2","2020-05-27 17:28:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 17:28:23","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-05-24","2020-11-23","351"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-27 17:28:23","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":["7968","340","998.0",898.6,"2","2020-05-27 17:28:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 17:28:23","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-05-24","2020-11-23","340"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-27 17:28:23","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":["7968",254,"SETTLED","A12-I208297","2020-05-27 17:28:22","2020-05-24","2","2020-05-27 17:28:22","2","2020-05-27 17:28:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 17:28:23","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":["8297","RENT","\u9810\u7e73\u79df\u91d1",1,1607,"MO","1",1607,"2","2020-05-27 17:28:22","2","2020-05-27 17:28:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 17:28:23","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":["8297","RENT","\u9810\u7e73\u79df\u91d1",2,1607,"MO","1",1607,"2","2020-05-27 17:28:22","2","2020-05-27 17:28:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 17:28:23","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":["8297","RENT","\u9810\u7e73\u79df\u91d1",3,1607,"MO","1",1607,"2","2020-05-27 17:28:22","2","2020-05-27 17:28:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 17:28:23","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":["8297","RENT","\u9810\u7e73\u79df\u91d1",4,1607,"MO","1",1607,"2","2020-05-27 17:28:22","2","2020-05-27 17:28:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 17:28:23","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":["8297","RENT","\u9810\u7e73\u79df\u91d1",5,1607,"MO","1",1607,"2","2020-05-27 17:28:22","2","2020-05-27 17:28:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 17:28:23","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":["8297","RENT","\u9810\u7e73\u79df\u91d1",6,1607,"MO","1",1607,"2","2020-05-27 17:28:22","2","2020-05-27 17:28:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 17:28:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[9642,0,"8297"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-27 17:28:23","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":[254,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207941","2020-05-27 17:28:22",9642,"2","2020-05-27 17:28:22","2","2020-05-27 17:28:22","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 17:28:23","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":["7941","DEPOSIT",null,"PAID","2020-05-27 17:28:22",0,"2","2020-05-27 17:28:22","2","2020-05-27 17:28:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 17:28:23","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":["7941","INVOICE","8297","PAID","2020-05-27 17:28:22",9642,"2","2020-05-27 17:28:22","2","2020-05-27 17:28:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:11:14","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1467&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1062","master_room_id":"108","room_code":"A05-060"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":284,"customer_code":"C170284","identity_type":"PERSONAL","identity_id":"R589291(A)","title":"Ms","lastname":"Perkins","firstname":"Emma Archer ","companyname":"","email":"emmaarcherperkins@gmail.com","tel":"65016839","address":"11A Four Winds, 4 Mount Davis Rd, Pokfulam","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-07","renew_room_key":"055,37962","renew_remark":"1 month contract. Storage rental paid by bank transfer on March 3, 2020. Storage deposit transferred from agreement A12-CT206904 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207555, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"372","room_code":"G13","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1038,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":2076,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-07","rent_from":"2020-04-07","rent_to":"2020-06-06","delivery_service":"0","remark":"2 month contract. Storage rental paid by bank transfer on May 27, 2020. Storage deposit transferred from agreement A12-CT207555 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2076,"final_order_total":2076,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,37962","order_product":[],"pass":true}},"first_order_id":"4414","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> G13 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1038.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:11:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",284,"NEW","A12-CT207969",1098,1038,0,0,"2","2",2076,2076,2076,"2020-05-27 18:11:14","0",null,null,null,"2020-04-07","2020-06-06","2 month contract. Storage rental paid by bank transfer on May 27, 2020. Storage deposit transferred from agreement A12-CT207555 to this agreement.\r\n","2020-04-07","16",0,null,0,"0","2","2020-05-27 18:11:14","2","2020-05-27 18:11:14","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,37962","C170284","PERSONAL","Ms","UAfRQnWL2QeUohvM1+Pnag==","bJnB4wyZfyZ0dcp78AFERg==","","O68VSwRWrJAUG6yGXqfyEMxog9sNgTPqsQsoIw+2pyazFPCZK+YyWvzvzWWHdo+n","d8hmdnJ8jOPns+D4R3b6RA==","jqVImduaZ5H0FE2TEWpPBxgxBWX3bTcsWAbQMZ6\/ZlU=","WrsOcxmhiIiD44RY9MDcBQ==",null,1,"4414"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:11:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7969","372","1098.0","1098.00","2","2020-05-27 18:11:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:11:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-07","2020-06-06","372"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-27 18:11:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7969",284,"SETTLED","A12-I208298","2020-05-27 18:11:14","2020-04-07","2","2020-05-27 18:11:14","2","2020-05-27 18:11:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:11:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8298","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-05-27 18:11:14","2","2020-05-27 18:11:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:11:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8298","RENT","\u9810\u7e73\u79df\u91d1",2,1038,"MO","1",1038,"2","2020-05-27 18:11:14","2","2020-05-27 18:11:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:11:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2076,0,"8298"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-27 18:11:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[284,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207942","2020-05-27 18:11:14",2076,"2","2020-05-27 18:11:14","2","2020-05-27 18:11:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:11:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7942","DEPOSIT",null,"PAID","2020-05-27 18:11:14",0,"2","2020-05-27 18:11:14","2","2020-05-27 18:11:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:11:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7942","INVOICE","8298","PAID","2020-05-27 18:11:14",2076,"2","2020-05-27 18:11:14","2","2020-05-27 18:11:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:14:06","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1467&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1062","master_room_id":"108","room_code":"A05-060"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":57,"customer_code":"C160057","identity_type":"PERSONAL","identity_id":"D381525(1)","title":"Mr","lastname":"\u9127","firstname":"\u8000\u660e","companyname":"","email":null,"tel":"68489863","address":"\u9d28\u8137\u6d32\u5229\u6771\u90a8\u6771\u5e73\u645f1110\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1286.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-27","renew_room_key":"052,49830","renew_remark":"1 month contract. Storage rental paid by bank transfer on April 29, 2020. Storage deposit transferred from agreement A12-CT207515 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207743, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"362","room_code":"G03","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1286,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1286,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-27","rent_from":"2020-05-27","rent_to":"2020-06-26","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on May 27, 2020. Storage deposit transferred from agreement A12-CT207743 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1286,"final_order_total":1286,"location_id":"1","branch_id":"1","company_id":"1","room_key":"052,49830","order_product":[],"pass":true}},"first_order_id":"4668","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> G03 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1286.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:14:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",57,"NEW","A12-CT207970",1528,1286,0,0,"1","1",1286,1286,1286,"2020-05-27 18:14:07","0",null,null,null,"2020-05-27","2020-06-26","1 month contract. Storage rental paid by bank transfer on May 27, 2020. Storage deposit transferred from agreement A12-CT207743 to this agreement.\r\n","2020-05-27","20",0,null,0,"0","2","2020-05-27 18:14:06","2","2020-05-27 18:14:06","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,49830","C160057","PERSONAL","Mr","GHEZv6RA43AKRnpR7gdqTA==","ftyCfj5J4cq7h24D9vkkBg==","","JP4Rs\/ygk7B5+4qY1O\/77gceoVCmBBEAI1MNVkcYqRQaD8gtNd7xtSE8vzgCel7k","OOTdNyqzZ+qPxvEtd7WOtg==",null,"o7k6DvJxqJphRuRJvr6JDg==",null,1,"4668"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:14: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":["7970","362","1528.0","1528.00","2","2020-05-27 18:14:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:14: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-05-27","2020-06-26","362"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-27 18:14: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":["7970",57,"SETTLED","A12-I208299","2020-05-27 18:14:06","2020-05-27","2","2020-05-27 18:14:06","2","2020-05-27 18:14:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:14: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":["8299","RENT","\u9810\u7e73\u79df\u91d1",1,1286,"MO","1",1286,"2","2020-05-27 18:14:06","2","2020-05-27 18:14:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:14:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1286,0,"8299"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-27 18:14: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":[57,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207943","2020-05-27 18:14:06",1286,"2","2020-05-27 18:14:06","2","2020-05-27 18:14:06","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:14: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":["7943","DEPOSIT",null,"PAID","2020-05-27 18:14:06",0,"2","2020-05-27 18:14:06","2","2020-05-27 18:14:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:14: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":["7943","INVOICE","8299","PAID","2020-05-27 18:14:06",1286,"2","2020-05-27 18:14:06","2","2020-05-27 18:14:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:18:23","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=INVOICE&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1527,"customer_code":"C201527","identity_type":"PERSONAL","identity_id":"M552436(4)","title":"Mr","lastname":"JONES","firstname":"Dustin","companyname":"","email":"alice@unifiedcommercegroup.com","tel":"91689733","address":"TBC","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"5638.0","renew_rent_month":"3","renew_warehousing_date":"2020-05-28","renew_room_key":"0012488874","renew_remark":"3 months contract. Special offer $5638\/month. $1000 deposit paid on Feb 21,2020. The balance of storage rental and deposit paid by bank transfer on Feb 28,2020. Smart card mailed out on Feb 28,2020.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT207273, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $5955.0","renew_master_room_id":"190","order_discount":[],"order_room":[{"room_id":"1384","room_code":"C15-078","retail_price":"810.0","discounted_price":"810.00","location_id":"6"},{"room_id":"1383","room_code":"C15-077","retail_price":"810.0","discounted_price":"810.00","location_id":"6"},{"room_id":"1382","room_code":"C15-076","retail_price":"810.0","discounted_price":"810.00","location_id":"6"},{"room_id":"1381","room_code":"C15-075","retail_price":"810.0","discounted_price":"810.00","location_id":"6"},{"room_id":"1376","room_code":"C15-070","retail_price":"938.0","discounted_price":"938.00","location_id":"6"},{"room_id":"1375","room_code":"C15-069","retail_price":"938.0","discounted_price":"938.00","location_id":"6"},{"room_id":"1374","room_code":"C15-068","retail_price":"1678.0","discounted_price":"1678.00","location_id":"6"}],"roughly_size":"107.19999999999999","total_retail_price":6794,"total_discounted_price":5658,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":11316,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-28","rent_from":"2020-05-28","rent_to":"2020-07-27","delivery_service":"0","remark":"2 months contract. Special offer $5658\/month. Storage rental paid by bank transfer on May 26,2020. Storage deposit $5955 transferred from agreement C15-CT207273 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":11316,"final_order_total":11316,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012488874","order_product":[],"pass":true}},"first_order_id":7273,"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\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-078 <\/td>\r\n\t\t\t\t\t 4X3X6.5 <\/td>\r\n\t\t\t\t\t $810.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\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> C15-077 <\/td>\r\n\t\t\t\t\t 4X3X6.5 <\/td>\r\n\t\t\t\t\t $810.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\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> C15-076 <\/td>\r\n\t\t\t\t\t 4X3X6.5 <\/td>\r\n\t\t\t\t\t $810.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\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> C15-075 <\/td>\r\n\t\t\t\t\t 4X3X6.5 <\/td>\r\n\t\t\t\t\t $810.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\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> C15-070 <\/td>\r\n\t\t\t\t\t 4X3.7X6.5 <\/td>\r\n\t\t\t\t\t $938.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> C15-069 <\/td>\r\n\t\t\t\t\t 4X3.7X6.5 <\/td>\r\n\t\t\t\t\t $938.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> C15-068 <\/td>\r\n\t\t\t\t\t 8X3.7X6.5 <\/td>\r\n\t\t\t\t\t $1678.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":"107.19999999999999","total_discounted_price":"5658.00","deposit":"0.00","total_retail_price":"6794.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:18:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1527,"NEW","C15-CT207971",6794,5658,0,0,"2","2",11316,11316,11316,"2020-05-27 18:18:24","0",null,null,null,"2020-05-28","2020-07-27","2 months contract. Special offer $5658\/month. Storage rental paid by bank transfer on May 26,2020. Storage deposit $5955 transferred from agreement C15-CT207273 to this agreement.","2020-05-28","107.19999999999999",0,null,0,"0","2","2020-05-27 18:18:23","2","2020-05-27 18:18:23","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012488874","C201527","PERSONAL","Mr","v2BX+mjdA2aaaXILtDpd2w==","ATQh2m7sYJgeNyjTRRusJQ==","","6F88GPSmmnGXsPk2ZyJKWg==","fuNqlbfJMi6ZKr9QrM5uYg==","KTz\/ce5VPXucGVxvMyRSYZP7MQI0HIXkuvcyqUuYvYE=","cd7wH0Mayh7s5WVPAqrd7Q==",null,1,7273]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:18:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7971","1384","810.0","810.00","2","2020-05-27 18:18:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:18:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-28","2020-07-27","1384"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-27 18:18:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7971","1383","810.0","810.00","2","2020-05-27 18:18:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:18:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-28","2020-07-27","1383"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-27 18:18:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7971","1382","810.0","810.00","2","2020-05-27 18:18:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:18:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-28","2020-07-27","1382"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-27 18:18:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7971","1381","810.0","810.00","2","2020-05-27 18:18:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:18:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-28","2020-07-27","1381"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-27 18:18:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7971","1376","938.0","938.00","2","2020-05-27 18:18:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:18:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-28","2020-07-27","1376"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-27 18:18:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7971","1375","938.0","938.00","2","2020-05-27 18:18:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:18:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-28","2020-07-27","1375"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-27 18:18:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7971","1374","1678.0","1678.00","2","2020-05-27 18:18:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:18:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-28","2020-07-27","1374"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-27 18:18:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7971",1527,"SETTLED","C15-I208300","2020-05-27 18:18:23","2020-05-28","2","2020-05-27 18:18:23","2","2020-05-27 18:18:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:18:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8300","RENT","\u9810\u7e73\u79df\u91d1",1,5658,"MO","1",5658,"2","2020-05-27 18:18:23","2","2020-05-27 18:18:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:18:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8300","RENT","\u9810\u7e73\u79df\u91d1",2,5658,"MO","1",5658,"2","2020-05-27 18:18:23","2","2020-05-27 18:18:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:18:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11316,0,"8300"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-27 18:18:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1527,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207944","2020-05-27 18:18:23",11316,"2","2020-05-27 18:18:23","2","2020-05-27 18:18:23","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:18:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7944","DEPOSIT",null,"PAID","2020-05-27 18:18:23",0,"2","2020-05-27 18:18:23","2","2020-05-27 18:18:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:18:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7944","INVOICE","8300","PAID","2020-05-27 18:18:23",11316,"2","2020-05-27 18:18:23","2","2020-05-27 18:18:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:19:50","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1467&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1062","master_room_id":"108","room_code":"A05-060"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":461,"customer_code":"C170461","identity_type":"PERSONAL","identity_id":"D551156(A)","title":"Ms","lastname":"Chang","firstname":"Nai Hwa Patsy","companyname":"","email":"patsychanglau@hotmail.com","tel":"95039948","address":"Flat 35, 6FL, BLK C&D,High Street ","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2328.0","renew_rent_month":"3","renew_warehousing_date":"2020-05-28","renew_room_key":"053,35042","renew_remark":"3 months contract. Storage rental paid by bank transfer on March 26, 2020. Storage deposit transferred from agreement A14-CT195946 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207497, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"38","order_discount":[],"order_room":[{"room_id":"436","room_code":"J18","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"},{"room_id":"435","room_code":"J17","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"}],"roughly_size":"40","total_retail_price":3056,"total_discounted_price":2206,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":13236,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-28","rent_from":"2020-05-28","rent_to":"2020-11-27","delivery_service":"0","remark":"6 months contract. Special offer one renewal gift. Storage rental paid by bank transfer on May 27, 2020. Storage deposit transferred from agreement A14-CT207497 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":13236,"final_order_total":13236,"location_id":"2","branch_id":"1","company_id":"1","room_key":"053,35042","order_product":[],"pass":true}},"first_order_id":"3676","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> J18 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> J17 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"40","total_discounted_price":"2206.00","deposit":"0.00","total_retail_price":"3056.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:19:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",461,"NEW","A14-CT207972",3056,2206,0,0,"6","6",13236,13236,13236,"2020-05-27 18:19:50","0",null,null,null,"2020-05-28","2020-11-27","6 months contract. Special offer one renewal gift. Storage rental paid by bank transfer on May 27, 2020. Storage deposit transferred from agreement A14-CT207497 to this agreement.\r\n","2020-05-28","40",0,null,0,"0","2","2020-05-27 18:19:50","2","2020-05-27 18:19:50","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"053,35042","C170461","PERSONAL","Ms","iOLOVFk2xy+Y5cUO4STirw==","8biuvROOyoUh0fK62hac9A==","","6c55ivNHEsh4FDZHAscCeNaHrwiqmKBuSmcA4ZzFhM4ogOYVKi+IV6dQuE+9tV5Z","ZicxqO9CvUZeDs9DzNfASg==","etU4spI1gGhRHwRXJT\/HUGzALfrxJvVb\/kH7\/Dpt\/rs=","qSx1lAoxSiXUDpaEfGpQYw==",null,1,"3676"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:19:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7972","436","1528.0","1528.00","2","2020-05-27 18:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:19:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-28","2020-11-27","436"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-27 18:19:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7972","435","1528.0","1528.00","2","2020-05-27 18:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:19:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-28","2020-11-27","435"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-27 18:19:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7972",461,"SETTLED","A14-I208301","2020-05-27 18:19:50","2020-05-28","2","2020-05-27 18:19:50","2","2020-05-27 18:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:19:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8301","RENT","\u9810\u7e73\u79df\u91d1",1,2206,"MO","1",2206,"2","2020-05-27 18:19:50","2","2020-05-27 18:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:19:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8301","RENT","\u9810\u7e73\u79df\u91d1",2,2206,"MO","1",2206,"2","2020-05-27 18:19:50","2","2020-05-27 18:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:19:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8301","RENT","\u9810\u7e73\u79df\u91d1",3,2206,"MO","1",2206,"2","2020-05-27 18:19:50","2","2020-05-27 18:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:19:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8301","RENT","\u9810\u7e73\u79df\u91d1",4,2206,"MO","1",2206,"2","2020-05-27 18:19:50","2","2020-05-27 18:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:19:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8301","RENT","\u9810\u7e73\u79df\u91d1",5,2206,"MO","1",2206,"2","2020-05-27 18:19:50","2","2020-05-27 18:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:19:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8301","RENT","\u9810\u7e73\u79df\u91d1",6,2206,"MO","1",2206,"2","2020-05-27 18:19:50","2","2020-05-27 18:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:19:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13236,0,"8301"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-27 18:19:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[461,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207945","2020-05-27 18:19:50",13236,"2","2020-05-27 18:19:50","2","2020-05-27 18:19:50","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:19:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7945","DEPOSIT",null,"PAID","2020-05-27 18:19:50",0,"2","2020-05-27 18:19:50","2","2020-05-27 18:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:19:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7945","INVOICE","8301","PAID","2020-05-27 18:19:50",13236,"2","2020-05-27 18:19:50","2","2020-05-27 18:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:45: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":"filter1=2&filter2=1467&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1062","master_room_id":"108","room_code":"A05-060"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":744,"customer_code":"C180744","identity_type":"PERSONAL","identity_id":"P048772(8)","title":"Ms","lastname":"Ho","firstname":"Mo Ching Cathy","companyname":"","email":"mchooo@gmail.com","tel":"93554406","address":"Flat C, 33\/F, Bayshore Apartment, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"824.0","renew_rent_month":"3","renew_warehousing_date":"2020-05-27","renew_room_key":"055,17315","renew_remark":"3 months contract. Storage rental paid by bank transfer on Mar 31, 2020. Storage deposit transferred from agreement A18-CT207055 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207540, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"100","order_discount":[],"order_room":[{"room_id":"928","room_code":"V02(\u670d\u88dd\u5009)","retail_price":"867.0","discounted_price":"867.00","location_id":"3"}],"roughly_size":"7.2","total_retail_price":867,"total_discounted_price":824,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2472,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-27","rent_from":"2020-05-27","rent_to":"2020-08-26","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on May 26, 2020. Storage deposit transferred from agreement A18-CT207540 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2472,"final_order_total":2472,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,17315","order_product":[],"pass":true}},"first_order_id":"4189","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> V02(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 3X2.4X7 <\/td>\r\n\t\t\t\t\t $867.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"7.2","total_discounted_price":"824.0","deposit":"0","total_retail_price":"867.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:45: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",744,"NEW","A18-CT207973",867,824,0,0,"3","3",2472,2472,2472,"2020-05-27 18:45:45","0",null,null,null,"2020-05-27","2020-08-26","3 months contract. Storage rental paid by bank transfer on May 26, 2020. Storage deposit transferred from agreement A18-CT207540 to this agreement.\r\n","2020-05-27","7.2",0,null,0,"0","2","2020-05-27 18:45:44","2","2020-05-27 18:45:44","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,17315","C180744","PERSONAL","Ms","EUjkCpsubVvF1qfSw9fseg==","D\/skxQ5s\/L5yyRWaDK\/iSg==","","t3z\/tBJVx9zUBsPV2QLEKP\/AqBedWM1pqHTyFCmhZMxE9j81xPq6zAWG2opPZD62551Q3nqkNQ4SQQVLAi\/ebQ==","nLgH3bybWamCUHRAkIxQVw==","Uhq9I4m8wi2lpFRkgjzbiBcMCEEf9\/MkY3ZKL8CyO+Q=","wH9Lv4oBE\/XdyEdxYi0AIQ==",null,1,"4189"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:45: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":["7973","928","867.0","867.00","2","2020-05-27 18:45:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:45: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-05-27","2020-08-26","928"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-27 18:45: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":["7973",744,"SETTLED","A18-I208302","2020-05-27 18:45:44","2020-05-27","2","2020-05-27 18:45:44","2","2020-05-27 18:45:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:45: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":["8302","RENT","\u9810\u7e73\u79df\u91d1",1,824,"MO","1",824,"2","2020-05-27 18:45:44","2","2020-05-27 18:45:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:45: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":["8302","RENT","\u9810\u7e73\u79df\u91d1",2,824,"MO","1",824,"2","2020-05-27 18:45:44","2","2020-05-27 18:45:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:45: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":["8302","RENT","\u9810\u7e73\u79df\u91d1",3,824,"MO","1",824,"2","2020-05-27 18:45:44","2","2020-05-27 18:45:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:45:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2472,0,"8302"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-27 18:45: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":[744,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207946","2020-05-27 18:45:44",2472,"2","2020-05-27 18:45:44","2","2020-05-27 18:45:44","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:45: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":["7946","DEPOSIT",null,"PAID","2020-05-27 18:45:44",0,"2","2020-05-27 18:45:44","2","2020-05-27 18:45:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:45: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":["7946","INVOICE","8302","PAID","2020-05-27 18:45:44",2472,"2","2020-05-27 18:45:44","2","2020-05-27 18:45:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:52:41","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1467&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1062","master_room_id":"108","room_code":"A05-060"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":826,"customer_code":"C180826","identity_type":"PERSONAL","identity_id":"V120085(2)","title":"Ms","lastname":"Wong","firstname":"Lai Wing","companyname":"","email":"aslinnlaiwing@gmail.com","tel":"60823501","address":"Flat B, 23\/F, Yee Wan Court, South Horizons, 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-05-21","renew_room_key":"052,37309","renew_remark":"1 month contract. Storage rental paid by bank transfer on April 26, 2020. Storage deposit transferred from agreement A12-CT207501 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207728, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"1","order_discount":[],"order_room":[{"room_id":"207","room_code":"D11","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"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","warehousing_date":"2020-05-21","rent_from":"2020-05-21","rent_to":"2020-06-20","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on May 26, 2020. Storage deposit transferred from agreement A12-CT207728 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":"1","branch_id":"1","company_id":"1","room_key":"052,37309","order_product":[],"pass":true}},"first_order_id":"4840","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> D11 <\/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","roughly_size":"12","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:52:41","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",826,"NEW","A12-CT207974",598,598,0,0,"1","1",598,598,598,"2020-05-27 18:52:41","0",null,null,null,"2020-05-21","2020-06-20","1 month contract. Storage rental paid by bank transfer on May 26, 2020. Storage deposit transferred from agreement A12-CT207728 to this agreement.\r\n","2020-05-21","12",0,null,0,"0","2","2020-05-27 18:52:41","2","2020-05-27 18:52:41","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,37309","C180826","PERSONAL","Ms","AVQEhVbkdf0QwgZhPqTuvQ==","hULSwM2MvFtpeV9\/z+er8Q==","","VYTecHlXsAq2HU\/SK2vg0HE0ESjbB0AIG1TtdkNrHvzSOFADaqlQfFPEOwNTSSdXg5YSZtYVVGLVGFZuRQfF9AxsFxu92jPjM0q+fUqGSyI=","M\/mMkpABptC23N0qOMtMOA==","I+DcTUTCSlvqwNtqcfOhWkdyXo7XLnfkUFX2VHxYh3c=","d\/8HRqfi7sBcCF03ucfekg==",null,1,"4840"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:52:41","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":["7974","207","598.0","598.00","2","2020-05-27 18:52:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:52:41","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-05-21","2020-06-20","207"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-27 18:52:41","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":["7974",826,"SETTLED","A12-I208303","2020-05-27 18:52:41","2020-05-21","2","2020-05-27 18:52:41","2","2020-05-27 18:52:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:52:41","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":["8303","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-05-27 18:52:41","2","2020-05-27 18:52:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:52:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8303"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-27 18:52:41","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":[826,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207947","2020-05-27 18:52:41",598,"2","2020-05-27 18:52:41","2","2020-05-27 18:52:41","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:52:41","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":["7947","DEPOSIT",null,"PAID","2020-05-27 18:52:41",0,"2","2020-05-27 18:52:41","2","2020-05-27 18:52:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 18:52:41","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":["7947","INVOICE","8303","PAID","2020-05-27 18:52:41",598,"2","2020-05-27 18:52:41","2","2020-05-27 18:52:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:08:56","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","189,02144","12 months contract. Storage rental paid by bank transfer on May 27, 2020. Storage deposit transferred from agreement A14-CT195004to this agreement.\r\n","2020-05-27 19:08:56","2","23wCRdcybxUEHt5OHLfIwQ==","anq5M29vFb7FteUGD1jgrQ==","44HV2RFm2K\/vF6X+fl0eNw==","iWJAKwphsQIJ0QxJ5Gtuu+6xdRtdn3TXA11ye1DWvN9rEUHtFIt\/OuKk\/RdRIVmWe5R6kvFOkJdE2psPrJgYSw==",7967]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:13:48","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"all=1","floor_plan_rent_room":[{"room_id":"697","master_room_id":"28","room_code":"N14"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> N14 <\/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","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"A705793(0)","title":"Mr","lastname":"Kam","firstname":"Chow","companyname":"","email":"","tel":"93279952","address":"Room 1706, Ka Sing House, Ka Lung Court, Aberdeen, Hong Kong","pass":true,"customer_id":"840","customer_code":"C180840","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"697","room_code":"N14","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":6456,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-27","rent_from":"2020-05-27","rent_to":"2021-05-26","delivery_service":"0","remark":"12 months contract. Storage rental paid by Cheque on May 27, 2020. Storage deposit transferred from agreement A14-CT195004to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":6456,"final_order_total":6456,"location_id":"2","branch_id":"1","company_id":"1","room_key":"189,02144","order_product":[],"pass":true}},"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-05-27 19:13:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2","840","NEW","A14-CT207975",598,538,0,0,"12","12",6456,6456,6456,"2020-05-27 19:13:49","0",null,null,null,"2020-05-27","2021-05-26","12 months contract. Storage rental paid by Cheque on May 27, 2020. Storage deposit transferred from agreement A14-CT195004to this agreement.\r\n","2020-05-27","12",0,null,0,"0","2","2020-05-27 19:13:48","2","2020-05-27 19:13:48","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"189,02144","C180840","PERSONAL","Mr","anq5M29vFb7FteUGD1jgrQ==","23wCRdcybxUEHt5OHLfIwQ==","","iWJAKwphsQIJ0QxJ5Gtuu+6xdRtdn3TXA11ye1DWvN9rEUHtFIt\/OuKk\/RdRIVmWe5R6kvFOkJdE2psPrJgYSw==","44HV2RFm2K\/vF6X+fl0eNw==",null,"7zi+39sbBDCfxRMh+7fABQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:13:49","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":["7975","697","598.0","598.00","2","2020-05-27 19:13:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:13:49","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-05-27","2021-05-26","697"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-27 19:13:49","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":["7975","840","SETTLED","A14-I208304","2020-05-27 19:13:48","2020-05-27","2","2020-05-27 19:13:48","2","2020-05-27 19:13:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:13:49","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":["8304","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-05-27 19:13:48","2","2020-05-27 19:13:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:13:49","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":["8304","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-05-27 19:13:48","2","2020-05-27 19:13:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:13:49","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":["8304","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-05-27 19:13:48","2","2020-05-27 19:13:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:13:49","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":["8304","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-05-27 19:13:48","2","2020-05-27 19:13:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:13:49","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":["8304","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-05-27 19:13:48","2","2020-05-27 19:13:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:13:49","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":["8304","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-05-27 19:13:48","2","2020-05-27 19:13:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:13:49","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":["8304","RENT","\u9810\u7e73\u79df\u91d1",7,538,"MO","1",538,"2","2020-05-27 19:13:48","2","2020-05-27 19:13:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:13:49","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":["8304","RENT","\u9810\u7e73\u79df\u91d1",8,538,"MO","1",538,"2","2020-05-27 19:13:48","2","2020-05-27 19:13:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:13:49","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":["8304","RENT","\u9810\u7e73\u79df\u91d1",9,538,"MO","1",538,"2","2020-05-27 19:13:48","2","2020-05-27 19:13:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:13:49","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":["8304","RENT","\u9810\u7e73\u79df\u91d1",10,538,"MO","1",538,"2","2020-05-27 19:13:48","2","2020-05-27 19:13:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:13:49","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":["8304","RENT","\u9810\u7e73\u79df\u91d1",11,538,"MO","1",538,"2","2020-05-27 19:13:48","2","2020-05-27 19:13:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:13:49","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":["8304","RENT","\u9810\u7e73\u79df\u91d1",12,538,"MO","1",538,"2","2020-05-27 19:13:48","2","2020-05-27 19:13:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:13:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6456,0,"8304"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-27 19:13:49","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":["840","NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207948","2020-05-27 19:13:48",6456,"2","2020-05-27 19:13:48","2","2020-05-27 19:13:48","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:13:49","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":["7948","DEPOSIT",null,"PAID","2020-05-27 19:13:48",0,"2","2020-05-27 19:13:48","2","2020-05-27 19:13:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:13:49","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":["7948","INVOICE","8304","PAID","2020-05-27 19:13:48",6456,"2","2020-05-27 19:13:48","2","2020-05-27 19:13:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:21:14","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","floor_plan_rent_room":[{"room_id":"697","master_room_id":"28","room_code":"N14"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":467,"customer_code":"C170467","identity_type":"PERSONAL","identity_id":"K228968(7)","title":"Ms","lastname":"Tang","firstname":"Hok Wan Wendy","companyname":"","email":null,"tel":"93887546","address":"Flat H,1\/F , Tower 11,South Horizons, Apleichau ,HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-24","renew_room_key":"054,28050","renew_remark":"6 months contract. Storage rental paid by bank transfer on January 5, 2020. Storage deposit transferred from agreement A14-CT195136 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT206869, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"631","room_code":"M42","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-24","rent_from":"2020-05-24","rent_to":"2020-11-23","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on May 26, 2020. Storage deposit transferred from agreement A14-CT206869 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,28050","order_product":[],"pass":true}},"first_order_id":"3819","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> M42 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"538.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:21:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",467,"NEW","A14-CT207976",598,538,0,0,"6","6",3228,3228,3228,"2020-05-27 19:21:14","0",null,null,null,"2020-05-24","2020-11-23","6 months contract. Storage rental paid by bank transfer on May 26, 2020. Storage deposit transferred from agreement A14-CT206869 to this agreement.\r\n","2020-05-24","12",0,null,0,"0","2","2020-05-27 19:21:14","2","2020-05-27 19:21:14","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,28050","C170467","PERSONAL","Ms","rp+CRHd3q27YBSGVkpKFJw==","M7CfcmE2OSMlZOkNgaoDmQ==","","WwdsUaXJdCyQS4zYpdyuOVjUNMKmyKrdBODcznhrf+t5NpCofkZQBw1Qjazwv\/2U+jo6JWKS1nWqDh\/KyHmMPQ==","oQPnXzlgWqYAR5qCetSjIg==",null,"2KF8ygyfFTr1R1qVr4x5gA==",null,1,"3819"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:21:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7976","631","598.0","598.00","2","2020-05-27 19:21:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:21:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-24","2020-11-23","631"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-27 19:21:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7976",467,"SETTLED","A14-I208305","2020-05-27 19:21:14","2020-05-24","2","2020-05-27 19:21:14","2","2020-05-27 19:21:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:21:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8305","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-05-27 19:21:14","2","2020-05-27 19:21:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:21:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8305","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-05-27 19:21:14","2","2020-05-27 19:21:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:21:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8305","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-05-27 19:21:14","2","2020-05-27 19:21:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:21:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8305","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-05-27 19:21:14","2","2020-05-27 19:21:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:21:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8305","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-05-27 19:21:14","2","2020-05-27 19:21:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:21:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8305","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-05-27 19:21:14","2","2020-05-27 19:21:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:21:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"8305"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-27 19:21:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[467,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207949","2020-05-27 19:21:14",3228,"2","2020-05-27 19:21:14","2","2020-05-27 19:21:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:21:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7949","DEPOSIT",null,"PAID","2020-05-27 19:21:14",0,"2","2020-05-27 19:21:14","2","2020-05-27 19:21:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-27 19:21:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7949","INVOICE","8305","PAID","2020-05-27 19:21:14",3228,"2","2020-05-27 19:21:14","2","2020-05-27 19:21:14"]},"data_before":[],"data_after":[],"step":1} *****