\n\t\t\t\t\tA16-147 4X7X7 $2161.00 - <\/td> <\/td> \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"28","total_discounted_price":"2053.00","deposit":"4322.00","total_retail_price":"2161.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 10:58:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7","707","NEW","A16-CT208113",2161,2053,4322,0,"3","3",10481,10481,10481,"2020-06-12 10:58:35","0",null,null,null,"2020-06-15","2020-09-14","3 months contract. Storage rental and deposit paid by cheque on June 12,2020. Smart card and padlock provided on the same day.","2020-06-15","28",0,null,0,"0","2","2020-06-12 10:58:35","2","2020-06-12 10:58:35","CHEQUE","","","","CHEQUE","","","",null,0,"190, 38678","C180707","PERSONAL","Mr","SR2Z5I9sPVu5xacQHgTyIg==","9DTHDCdI0o\/83sM4ct1LPg==","","K5\/5N+Bn0vBxmk8zM4MdOaD5g\/ggASRq4gDh8rMA\/2x+pfaHe8CKVVwOGqDLCKD7DoW+N1f1zYdDvubF4CXfuQ6ylZO+RwDnmiiRHP0oIxI=","WRDWXos0JwYitaPzwd6RNg==","FyADBuQi8RzCieNDaLsYH5ya+4WM9cySJMcy8\/2CqiE=","WhxmmwJ+NlhISvFFctqMCA==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 10:58:35","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":["8113","1638","2161.0","2161.00","2","2020-06-12 10:58:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 10:58:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-15","2020-09-14","1638"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-12 10:58:35","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":["8113","A16-D205462","PAID",4322,0,"2020-09-14","2020-06-12 10:58:35","2020-06-12 10:58:35","2","2020-06-12 10:58:35","2","2020-06-12 10:58:35","707"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 10:58:35","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":["8113","707","SETTLED","A16-I208442","2020-06-12 10:58:35","2020-06-15","2","2020-06-12 10:58:35","2","2020-06-12 10:58:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 10:58:35","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":["8442","RENT","\u9810\u7e73\u79df\u91d1",1,2053,"MO","1",2053,"2","2020-06-12 10:58:35","2","2020-06-12 10:58:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 10:58:35","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":["8442","RENT","\u9810\u7e73\u79df\u91d1",2,2053,"MO","1",2053,"2","2020-06-12 10:58:35","2","2020-06-12 10:58:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 10:58:35","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":["8442","RENT","\u9810\u7e73\u79df\u91d1",3,2053,"MO","1",2053,"2","2020-06-12 10:58:35","2","2020-06-12 10:58:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 10:58:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6159,0,"8442"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-12 10:58:35","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":["707","CHEQUE","","","","CHEQUE","","","","PAID","P208085","2020-06-12 10:58:35",10481,"2","2020-06-12 10:58:35","2","2020-06-12 10:58:35","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 10:58:35","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":["8085","DEPOSIT","5462","PAID","2020-06-12 10:58:35",4322,"2","2020-06-12 10:58:35","2","2020-06-12 10:58:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 10:58:35","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":["8085","INVOICE","8442","PAID","2020-06-12 10:58:35",6159,"2","2020-06-12 10:58:35","2","2020-06-12 10:58:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:01:39","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","190, 38678","3 months contract. Storage rental and deposit paid by cheque on June 12,2020. Smart card and padlock provided on the same day.","2020-06-12 11:01:39","2","9DTHDCdI0o\/83sM4ct1LPg==","SR2Z5I9sPVu5xacQHgTyIg==","FyADBuQi8RzCieNDaLsYH5ya+4WM9cySJMcy8\/2CqiE=","WRDWXos0JwYitaPzwd6RNg==","K5\/5N+Bn0vBxmk8zM4MdOaD5g\/ggASRq4gDh8rMA\/2x+pfaHe8CKVVwOGqDLCKD7DoW+N1f1zYdDvubF4CXfuQ6ylZO+RwDnmiiRHP0oIxI=",8113]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:02:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:05:10","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","floor_plan_rent_room":[],"_payment_type":"INVOICE","warehousing":{"1":{"new_customer":"1","identity_type":"BUSINESS","identity_id":"20775378","title":"Mr","lastname":"Figueiras","firstname":"Julio Alberto","companyname":"Shankland Cox Asia Limited","email":"scaljf@yahoo.com","tel":"90490864","address":"Flat\/Rm 603, 6\/F, Chinachem Hollywood Centre, 1-13 Hollywood Road, Central, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1638","room_code":"A16-147","retail_price":"2161.0","discounted_price":"2161.00","location_id":"7"}],"roughly_size":"28","total_retail_price":2161,"total_discounted_price":2053,"deposit":4322,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":10481,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-15","rent_from":"2020-06-15","rent_to":"2020-09-14","delivery_service":"0","remark":"3 months contract. Storage rental and deposit paid by cheque on June 12,2020. Smart card and padlock provided on the same day.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":10481,"final_order_total":10481,"location_id":"7","branch_id":"1","company_id":"1","room_key":"190,38678","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> \n\t\t\t\t\tA16-147 4X7X7 $2161.00 - <\/td> <\/td> \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"28","total_discounted_price":"2053.00","deposit":"4322.00","total_retail_price":"2161.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:05:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201617","BUSINESS","Mr","SR2Z5I9sPVu5xacQHgTyIg==","9DTHDCdI0o\/83sM4ct1LPg==","Shankland Cox Asia Limited","WRDWXos0JwYitaPzwd6RNg==","FyADBuQi8RzCieNDaLsYH5ya+4WM9cySJMcy8\/2CqiE=","liF1PesM9SMB7kEeCukGpjyo6hB8W1\/ZiZSxyM3H3OIHoCpTq+OxNsQbN7KJUweq+MqZfHPOfOZ7vvdNlOgys4qawApGjmA2AgDuGeWBEvY=",null,"vVQGg0ozjIQteL2Q9ADtbw==","FyADBuQi8RzCieNDaLsYH5ya+4WM9cySJMcy8\/2CqiE=","Ai5k8yRPXVSibc2DdguORw==","2","2020-06-12 11:05:10","2","2020-06-12 11:05:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:05:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7",1617,"NEW","A16-CT208114",2161,2053,4322,0,"3","3",10481,10481,10481,"2020-06-12 11:05:12","0",null,null,null,"2020-06-15","2020-09-14","3 months contract. Storage rental and deposit paid by cheque on June 12,2020. Smart card and padlock provided on the same day.","2020-06-15","28",0,null,0,"0","2","2020-06-12 11:05:10","2","2020-06-12 11:05:10","CHEQUE","","","","CHEQUE","","","",null,0,"190,38678","C201617","BUSINESS","Mr","SR2Z5I9sPVu5xacQHgTyIg==","9DTHDCdI0o\/83sM4ct1LPg==","Shankland Cox Asia Limited","liF1PesM9SMB7kEeCukGpjyo6hB8W1\/ZiZSxyM3H3OIHoCpTq+OxNsQbN7KJUweq+MqZfHPOfOZ7vvdNlOgys4qawApGjmA2AgDuGeWBEvY=","WRDWXos0JwYitaPzwd6RNg==","FyADBuQi8RzCieNDaLsYH5ya+4WM9cySJMcy8\/2CqiE=",null,"vVQGg0ozjIQteL2Q9ADtbw=="]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:05:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8114","1638","2161.0","2161.00","2","2020-06-12 11:05:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:05:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-15","2020-09-14","1638"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-12 11:05:12","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":["8114","A16-D205463","PAID",4322,0,"2020-09-14","2020-06-12 11:05:10","2020-06-12 11:05:10","2","2020-06-12 11:05:10","2","2020-06-12 11:05:10",1617]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:05:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8114",1617,"SETTLED","A16-I208443","2020-06-12 11:05:10","2020-06-15","2","2020-06-12 11:05:10","2","2020-06-12 11:05:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:05:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8443","RENT","\u9810\u7e73\u79df\u91d1",1,2053,"MO","1",2053,"2","2020-06-12 11:05:10","2","2020-06-12 11:05:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:05:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8443","RENT","\u9810\u7e73\u79df\u91d1",2,2053,"MO","1",2053,"2","2020-06-12 11:05:10","2","2020-06-12 11:05:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:05:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8443","RENT","\u9810\u7e73\u79df\u91d1",3,2053,"MO","1",2053,"2","2020-06-12 11:05:10","2","2020-06-12 11:05:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:05:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6159,0,"8443"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-12 11:05:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1617,"CHEQUE","","","","CHEQUE","","","","PAID","P208086","2020-06-12 11:05:10",10481,"2","2020-06-12 11:05:10","2","2020-06-12 11:05:10","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:05:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8086","DEPOSIT","5463","PAID","2020-06-12 11:05:10",4322,"2","2020-06-12 11:05:10","2","2020-06-12 11:05:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:05:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8086","INVOICE","8443","PAID","2020-06-12 11:05:10",6159,"2","2020-06-12 11:05:10","2","2020-06-12 11:05:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:16:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:19:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:24:59","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","floor_plan_rent_room":[{"room_id":"1709","master_room_id":"205","room_code":"A16-218"}],"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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tA16-218 4X6X7 $1857.00 N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"R702369(2)","title":"Mr","lastname":"SUN","firstname":"Bei Jessica","companyname":"","email":"Jessicasun106@yahoo.com.hk","tel":"67071236","address":"20B, Visalia Garden, 48 Macdonnell Road, Mid-Level, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1709","room_code":"A16-218","retail_price":"1857.0","discounted_price":"1857.00","location_id":"7"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1655,"deposit":3676,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":11398,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2208.00","warehousing_date":"2020-06-15","rent_from":"2020-06-15","rent_to":"2020-12-14","delivery_service":"0","remark":"6 months contract. Special offer the first 3 months 50% off. Free access card for \u201cRent Now\u201d offer. Storage rental and deposit paid by EPS on June 12, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":2208,"order_total":13606,"final_order_total":11398,"location_id":"7","branch_id":"1","company_id":"1","room_key":"076,29508","order_product":[],"pass":true}},"roughly_size":"24","total_discounted_price":"1655.00","deposit":"3676.00","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:25:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201618","PERSONAL","Mr","5GHrEhnItHFdKwpaXlWddA==","KQFRNa2i9\/MYxWP9oxfpBQ==","","35BtLQEOwbxhBWrLVWtyUw==","pM6MSVVXEYiYt1Z9M+rc2NLtljBixhxA6bSI9lk+UR0=","6HfL7gx6WtU8NEqIPlnOSNc3\/VxC\/D995MpesBM\/teOeYT5PpimjWMkPkafKQFX5gNwrEwxkM6qgvwpM0euu9w==","eYqwkdWnGMf9l0Q8ypqGRQ==",null,"pM6MSVVXEYiYt1Z9M+rc2NLtljBixhxA6bSI9lk+UR0=","ot+76LGQ9JS+Cwmb1++mKg==","2","2020-06-12 11:24:59","2","2020-06-12 11:24:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:25:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7",1618,"NEW","A16-CT208115",1857,1655,3676,0,"6","6",11398,13606,11398,"2020-06-12 11:25:01","0",null,null,null,"2020-06-15","2020-12-14","6 months contract. Special offer the first 3 months 50% off. Free access card for \u201cRent Now\u201d offer. Storage rental and deposit paid by EPS on June 12, 2020. ","2020-06-15","24",0,null,2208,"2208.00","2","2020-06-12 11:24:59","2","2020-06-12 11:24:59","EPS","","","","EPS","","","",null,0,"076,29508","C201618","PERSONAL","Mr","5GHrEhnItHFdKwpaXlWddA==","KQFRNa2i9\/MYxWP9oxfpBQ==","","6HfL7gx6WtU8NEqIPlnOSNc3\/VxC\/D995MpesBM\/teOeYT5PpimjWMkPkafKQFX5gNwrEwxkM6qgvwpM0euu9w==","35BtLQEOwbxhBWrLVWtyUw==","pM6MSVVXEYiYt1Z9M+rc2NLtljBixhxA6bSI9lk+UR0=","eYqwkdWnGMf9l0Q8ypqGRQ==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:25:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8115","1709","1857.0","1857.00","2","2020-06-12 11:24:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:25:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-15","2020-12-14","1709"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-12 11:25:01","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":["8115","A16-D205464","PAID",3676,0,"2020-12-14","2020-06-12 11:24:59","2020-06-12 11:24:59","2","2020-06-12 11:24:59","2","2020-06-12 11:24:59",1618]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:25:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8115",1618,"SETTLED","A16-I208444","2020-06-12 11:24:59","2020-06-15","2","2020-06-12 11:24:59","2","2020-06-12 11:24:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:25:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8444","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-12 11:24:59","2","2020-06-12 11:24:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:25:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8444","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1102,"MO","1",1102,"2","2020-06-12 11:24:59","2","2020-06-12 11:24:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:25:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8444","RENT","\u9810\u7e73\u79df\u91d1",3,1655,"MO","1",1655,"2","2020-06-12 11:24:59","2","2020-06-12 11:24:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:25:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8444","RENT","\u9810\u7e73\u79df\u91d1",4,1655,"MO","1",1655,"2","2020-06-12 11:24:59","2","2020-06-12 11:24:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:25:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8444","RENT","\u9810\u7e73\u79df\u91d1",5,1655,"MO","1",1655,"2","2020-06-12 11:24:59","2","2020-06-12 11:24:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:25:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8444","RENT","\u9810\u7e73\u79df\u91d1",6,1655,"MO","1",1655,"2","2020-06-12 11:24:59","2","2020-06-12 11:24:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:25:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7722,0,"8444"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-12 11:25:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1618,"EPS","","","","EPS","","","","PAID","P208087","2020-06-12 11:24:59",11398,"2","2020-06-12 11:24:59","2","2020-06-12 11:24:59","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:25:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8087","DEPOSIT","5464","PAID","2020-06-12 11:24:59",3676,"2","2020-06-12 11:24:59","2","2020-06-12 11:24:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:25:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8087","INVOICE","8444","PAID","2020-06-12 11:24:59",7722,"2","2020-06-12 11:24:59","2","2020-06-12 11:24:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 11:45:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:08:08","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"D388859(3)","title":"Ms","lastname":"WONG","firstname":"Lak See","companyname":"","email":"lakseewong@yahoo.com","tel":"90162101","address":"Flat C, 19\/F, Blk 33, South Horizons, Aberdeen","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"560","room_code":"L38","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":989,"deposit":2196,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":13476,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1577.00","warehousing_date":"2020-06-22","rent_from":"2020-06-22","rent_to":"2021-07-21","delivery_service":"0","remark":"13 months contract. Special offer 5% 'rent now' offer and the 13th month free for the first contract. Storage rental and deposit paid by cheque on June 12,2020. Smart card and padlock provided on the same day.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":1577,"order_total":15053,"final_order_total":13476,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,47780","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> \n\t\t\t\t\tL38 4X4X8 $1098.00 - <\/td> \u9810\u4ed83\u500b\u6708 \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"16","total_discounted_price":"989.00","deposit":"2196.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:08:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201619","PERSONAL","Ms","u4YBlulP3G6PvMVyhFTfmQ==","ddrfzAYTmkL\/QNu3psjONQ==","","ISimqCIGY5ig4utkxRE8Tw==","ZHaJ14EE5dLR0LMOf2hveL9UIyE4ItJQ95KlilGi8ds=","HNgzcgm0Loj\/wXiJm9q7AXWj7Vy1kFuaxcdfBROXWdDMpilUH8+4MSy\/EFg0e1gi","bqBafA+NVkNO2nf\/MQPWFg==",null,"ZHaJ14EE5dLR0LMOf2hveL9UIyE4ItJQ95KlilGi8ds=","ucwQjCf7av7WlKE+AwO35w==","2","2020-06-12 12:08:08","2","2020-06-12 12:08:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:08: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` = ?","parameters":["1","1","2",1619,"NEW","A14-CT208116",1098,989,2196,0,"13","13",13476,15053,13476,"2020-06-12 12:08:10","0",null,null,null,"2020-06-22","2021-07-21","13 months contract. Special offer 5% 'rent now' offer and the 13th month free for the first contract. Storage rental and deposit paid by cheque on June 12,2020. Smart card and padlock provided on the same day.","2020-06-22","16",0,null,1577,"1577.00","2","2020-06-12 12:08:08","2","2020-06-12 12:08:08","CHEQUE","","","","CHEQUE","","","",null,0,"076,47780","C201619","PERSONAL","Ms","u4YBlulP3G6PvMVyhFTfmQ==","ddrfzAYTmkL\/QNu3psjONQ==","","HNgzcgm0Loj\/wXiJm9q7AXWj7Vy1kFuaxcdfBROXWdDMpilUH8+4MSy\/EFg0e1gi","ISimqCIGY5ig4utkxRE8Tw==","ZHaJ14EE5dLR0LMOf2hveL9UIyE4ItJQ95KlilGi8ds=","bqBafA+NVkNO2nf\/MQPWFg==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:08: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":["8116","560","1098.0","1098.00","2","2020-06-12 12:08:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:08: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-06-22","2021-07-21","560"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-12 12:08: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":["8116","A14-D205465","PAID",2196,0,"2021-07-21","2020-06-12 12:08:08","2020-06-12 12:08:08","2","2020-06-12 12:08:08","2","2020-06-12 12:08:08",1619]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:08: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":["8116",1619,"SETTLED","A14-I208445","2020-06-12 12:08:08","2020-06-22","2","2020-06-12 12:08:08","2","2020-06-12 12:08:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:08: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":["8445","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-12 12:08:08","2","2020-06-12 12:08:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:08: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":["8445","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,401,"MO","1",401,"2","2020-06-12 12:08:08","2","2020-06-12 12:08:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:08: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":["8445","RENT","\u9810\u7e73\u79df\u91d1",3,989,"MO","1",989,"2","2020-06-12 12:08:08","2","2020-06-12 12:08:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:08: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":["8445","RENT","\u9810\u7e73\u79df\u91d1",4,989,"MO","1",989,"2","2020-06-12 12:08:08","2","2020-06-12 12:08:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:08: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":["8445","RENT","\u9810\u7e73\u79df\u91d1",5,989,"MO","1",989,"2","2020-06-12 12:08:08","2","2020-06-12 12:08:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:08: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":["8445","RENT","\u9810\u7e73\u79df\u91d1",6,989,"MO","1",989,"2","2020-06-12 12:08:08","2","2020-06-12 12:08:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:08: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":["8445","RENT","\u9810\u7e73\u79df\u91d1",7,989,"MO","1",989,"2","2020-06-12 12:08:08","2","2020-06-12 12:08:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:08: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":["8445","RENT","\u9810\u7e73\u79df\u91d1",8,989,"MO","1",989,"2","2020-06-12 12:08:08","2","2020-06-12 12:08:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:08: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":["8445","RENT","\u9810\u7e73\u79df\u91d1",9,989,"MO","1",989,"2","2020-06-12 12:08:08","2","2020-06-12 12:08:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:08: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":["8445","RENT","\u9810\u7e73\u79df\u91d1",10,989,"MO","1",989,"2","2020-06-12 12:08:08","2","2020-06-12 12:08:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:08: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":["8445","RENT","\u9810\u7e73\u79df\u91d1",11,989,"MO","1",989,"2","2020-06-12 12:08:08","2","2020-06-12 12:08:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:08: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":["8445","RENT","\u9810\u7e73\u79df\u91d1",12,989,"MO","1",989,"2","2020-06-12 12:08:08","2","2020-06-12 12:08:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:08: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":["8445","RENT","\u9810\u7e73\u79df\u91d1",13,989,"MO","1",989,"2","2020-06-12 12:08:08","2","2020-06-12 12:08:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:08:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11280,0,"8445"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-12 12:08: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":[1619,"CHEQUE","","","","CHEQUE","","","","PAID","P208088","2020-06-12 12:08:08",13476,"2","2020-06-12 12:08:08","2","2020-06-12 12:08:08","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:08: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":["8088","DEPOSIT","5465","PAID","2020-06-12 12:08:08",2196,"2","2020-06-12 12:08:08","2","2020-06-12 12:08:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:08: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":["8088","INVOICE","8445","PAID","2020-06-12 12:08:08",11280,"2","2020-06-12 12:08:08","2","2020-06-12 12:08:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:38:39","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"1710","master_room_id":"205","room_code":"A16-219"}],"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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tA16-219 4X6X7 $1857.00 N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"BUSINESS","identity_id":"67151642","title":"Ms","lastname":"DAMPSEY TOM LEDDEL","firstname":"Sharon","companyname":"Riverview Hill Limited","email":"Tomtom@tomasinadesigns.com","tel":"90102521","address":"#23123 Wan Chai Post Office Box, 2\/F, Wuchung House, Wanchai, H.K.","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1710","room_code":"A16-219","retail_price":"1857.0","discounted_price":"1857.00","location_id":"7"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":4718,"deposit":9436,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":16513,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"7077.00","warehousing_date":"2020-06-13","rent_from":"2020-06-13","rent_to":"2020-09-12","delivery_service":"0","remark":"3 months contract. Special offer the first 3months 50%off. Storage rental and deposit paid by post-dated cheque on June 12, 2020. Smart card provided on June 12, 2020. ","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":7077,"order_total":23590,"final_order_total":16513,"location_id":"7","branch_id":"1","company_id":"1","room_key":"076, 32588","order_product":[],"pass":true}},"roughly_size":"24","total_discounted_price":"4718.00","deposit":"9436.00","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:38:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201620","BUSINESS","Ms","0617evtUu23ydgHgD1bPZw==","g+bY8H5UkIJVFvJGYQkNBjJYlJG2kkhryT\/5dLA1N5Q=","Riverview Hill Limited","evYImDqXoyv2Up+hlxvv6g==","eM2frcGYPdFrZR7clRaGLFjKAk9WCKmiqPgj0UkuZbM=","r2tIQ\/5pVSeUoNSBBSFlFkevDKOVbWugw5pKBdVv9D\/O4lXui8Rl24JLh\/DSXgiw+QEzckKuf8j1N1WJw6B+F7i9wKXCP0hJlryDMCqF8mE=",null,"qxKr7KLnRQpoekO4+G0agA==","eM2frcGYPdFrZR7clRaGLFjKAk9WCKmiqPgj0UkuZbM=","EH3KNmgHK8CTaaDx49\/pZw==","2","2020-06-12 12:38:39","2","2020-06-12 12:38:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:38: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` = ?","parameters":["1","1","7",1620,"NEW","A16-CT208117",1857,4718,9436,0,"3","3",16513,23590,16513,"2020-06-12 12:38:41","0",null,null,null,"2020-06-13","2020-09-12","3 months contract. Special offer the first 3months 50%off. Storage rental and deposit paid by post-dated cheque on June 12, 2020. Smart card provided on June 12, 2020. ","2020-06-13","24",0,null,7077,"7077.00","2","2020-06-12 12:38:39","2","2020-06-12 12:38:39","CHEQUE","","","","CHEQUE","","","",null,0,"076, 32588","C201620","BUSINESS","Ms","0617evtUu23ydgHgD1bPZw==","g+bY8H5UkIJVFvJGYQkNBjJYlJG2kkhryT\/5dLA1N5Q=","Riverview Hill Limited","r2tIQ\/5pVSeUoNSBBSFlFkevDKOVbWugw5pKBdVv9D\/O4lXui8Rl24JLh\/DSXgiw+QEzckKuf8j1N1WJw6B+F7i9wKXCP0hJlryDMCqF8mE=","evYImDqXoyv2Up+hlxvv6g==","eM2frcGYPdFrZR7clRaGLFjKAk9WCKmiqPgj0UkuZbM=",null,"qxKr7KLnRQpoekO4+G0agA=="]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:38: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":["8117","1710","1857.0","1857.00","2","2020-06-12 12:38:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:38: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-06-13","2020-09-12","1710"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-12 12:38:41","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":["8117","A16-D205466","PAID",9436,0,"2020-09-12","2020-06-12 12:38:39","2020-06-12 12:38:39","2","2020-06-12 12:38:39","2","2020-06-12 12:38:39",1620]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:38: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":["8117",1620,"SETTLED","A16-I208446","2020-06-12 12:38:39","2020-06-13","2","2020-06-12 12:38:39","2","2020-06-12 12:38:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:38: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":["8446","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-12 12:38:39","2","2020-06-12 12:38:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:38: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":["8446","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,2359,"MO","1",2359,"2","2020-06-12 12:38:39","2","2020-06-12 12:38:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:38: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":["8446","RENT","\u9810\u7e73\u79df\u91d1",3,4718,"MO","1",4718,"2","2020-06-12 12:38:39","2","2020-06-12 12:38:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:38:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7077,0,"8446"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-12 12:38: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":[1620,"CHEQUE","","","","CHEQUE","","","","PAID","P208089","2020-06-12 12:38:39",16513,"2","2020-06-12 12:38:39","2","2020-06-12 12:38:39","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:38: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":["8089","DEPOSIT","5466","PAID","2020-06-12 12:38:39",9436,"2","2020-06-12 12:38:39","2","2020-06-12 12:38:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 12:38: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":["8089","INVOICE","8446","PAID","2020-06-12 12:38:39",7077,"2","2020-06-12 12:38:39","2","2020-06-12 12:38:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 13:15:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 13:15:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 14:19:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 14:29:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 14:48:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 14:53:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 15:42:57","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=INVOICE&filter1=0&filter2=1548&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1217,"customer_code":"C191217","identity_type":"PERSONAL","identity_id":"D447759(7)","title":"Ms","lastname":"HUI","firstname":"Mei Ying","companyname":"","email":"florahui23@gmail.com","tel":"91760388","address":"21B, Kam Fat Bldg, 145 Lee Chi Rd, Apleichau, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-14","renew_room_key":"'0006047753","renew_remark":"1 month contract. Storage rental paid by bank transfer on May 9, 2020. Storage deposit transferred from agreement A05-CT207596 to this agreement.\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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tA05-008 4X4X7 $1290.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 15:42:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1217,"NEW","A05-CT208118",1290,1290,0,0,"1","1",1290,1290,1290,"2020-06-12 15:42:57","0",null,null,null,"2020-06-14","2020-07-13","1 month contract. Storage rental paid by bank transfer on June 12, 2020. Storage deposit transferred from agreement A05-CT207813 to this agreement.","2020-06-14","16",0,null,0,"0","2","2020-06-12 15:42:57","2","2020-06-12 15:42:57","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0006047753","C191217","PERSONAL","Ms","itB3q7EVO34a2hxkwiPhKw==","SLPJ+c2smshjwdK17xoj0w==","","ueCxoUZm7SuNCZWvZfej2KDREwW7lwoKDTTNZzTAoaO5sqnLfLBRCkfNGM8f7yinGogt7bT6sVG5LxuicUK9\/w==","6zI+PZPtByw9BmzFx6tCzA==","YTLujwAtYb1\/RI+1mL1DaVX7TvWW5ErARjMcxpk9WYA=","vm7DP84yeg7qminXe9MP\/Q==",null,1,"4509"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 15:42:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8118","1010","1290.0","1290.00","2","2020-06-12 15:42:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 15:42:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-14","2020-07-13","1010"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-12 15:42:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8118",1217,"SETTLED","A05-I208447","2020-06-12 15:42:57","2020-06-14","2","2020-06-12 15:42:57","2","2020-06-12 15:42:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 15:42:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8447","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-06-12 15:42:57","2","2020-06-12 15:42:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 15:42:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"8447"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-12 15:42:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1217,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208090","2020-06-12 15:42:57",1290,"2","2020-06-12 15:42:57","2","2020-06-12 15:42:57","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 15:42:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8090","DEPOSIT",null,"PAID","2020-06-12 15:42:57",0,"2","2020-06-12 15:42:57","2","2020-06-12 15:42:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 15:42:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8090","INVOICE","8447","PAID","2020-06-12 15:42:57",1290,"2","2020-06-12 15:42:57","2","2020-06-12 15:42:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 15:45:42","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&filter1=0&filter2=1548&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":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":599,"customer_code":"C170599","identity_type":"PERSONAL","identity_id":"D752295(A)","title":"Ms","lastname":"Hu","firstname":"Yim Ching","companyname":"","email":"mandy2038@hotmail.com","tel":"51334649","address":"503, 5\/F, Hau Fook Building, 568 Queen's Road West, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1358.0","renew_rent_month":"6","renew_warehousing_date":"2020-06-18","renew_room_key":"055,40585","renew_remark":"6 months contract. Storage rental paid by bank transfer on December 12, 2019. Storage deposit transferred from agreement A12-CT195195 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196680, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"11","order_discount":[{"master_room_discount_id":"80","master_room_id":"11","discount_type":"%","price":"1768.00","disocunted_price":"1592.10","discount":"9.95","monthly_deduct":175.916,"room_id":"369","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"369","room_code":"G10","retail_price":"1768.0","discounted_price":1592.1,"location_id":"1"}],"roughly_size":"24","total_retail_price":1768,"total_discounted_price":1358,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":8148,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-18","rent_from":"2020-06-18","rent_to":"2020-12-17","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on June 12,2020. Storage deposit transferred from agreement A12-CT196680 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":8148,"final_order_total":8148,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,40585","order_product":[],"pass":true}},"first_order_id":"3894","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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tG10 4X6X8 $1768.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1358.0","deposit":"0","total_retail_price":"1768.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 15:45:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",599,"NEW","A12-CT208119",1768,1358,0,0,"6","6",8148,8148,8148,"2020-06-12 15:45:42","0",null,null,null,"2020-06-18","2020-12-17","6 months contract. Storage rental paid by bank transfer on June 12,2020. Storage deposit transferred from agreement A12-CT196680 to this agreement.","2020-06-18","24",0,null,0,"0","2","2020-06-12 15:45:42","2","2020-06-12 15:45:42","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,40585","C170599","PERSONAL","Ms","1\/vhbAcwmPVjlslJR+krjQ==","1SgtGWDiwr0mMX41giA8mQ==","","9Eq\/MXIQjVIuEDPKfCoMHg+u2wm\/PXXPCdQS32+mxnO9A05Um9ARNQ2EUGh5ZVKK29Hnip+byGGif0Y9qn42Lg==","Lph2rEQrerG1dLdFKg6mCA==","M3mIBLmuqgJ9+tlHgMEU8q\/0xPJzf4camXreHagrWp4=","65a1SZhHICHKAqTN2aWveQ==",null,1,"3894"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 15:45:42","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":["8119","80","11","369","%","9.95",175.916,"2","2020-06-12 15:45:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 15:45:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8119","369","1768.0",1592.1,"2","2020-06-12 15:45:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 15:45:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-18","2020-12-17","369"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-12 15:45:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8119",599,"SETTLED","A12-I208448","2020-06-12 15:45:42","2020-06-18","2","2020-06-12 15:45:42","2","2020-06-12 15:45:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 15:45:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8448","RENT","\u9810\u7e73\u79df\u91d1",1,1358,"MO","1",1358,"2","2020-06-12 15:45:42","2","2020-06-12 15:45:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 15:45:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8448","RENT","\u9810\u7e73\u79df\u91d1",2,1358,"MO","1",1358,"2","2020-06-12 15:45:42","2","2020-06-12 15:45:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 15:45:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8448","RENT","\u9810\u7e73\u79df\u91d1",3,1358,"MO","1",1358,"2","2020-06-12 15:45:42","2","2020-06-12 15:45:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 15:45:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8448","RENT","\u9810\u7e73\u79df\u91d1",4,1358,"MO","1",1358,"2","2020-06-12 15:45:42","2","2020-06-12 15:45:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 15:45:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8448","RENT","\u9810\u7e73\u79df\u91d1",5,1358,"MO","1",1358,"2","2020-06-12 15:45:42","2","2020-06-12 15:45:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 15:45:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8448","RENT","\u9810\u7e73\u79df\u91d1",6,1358,"MO","1",1358,"2","2020-06-12 15:45:42","2","2020-06-12 15:45:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 15:45:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8148,0,"8448"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-12 15:45:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[599,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208091","2020-06-12 15:45:42",8148,"2","2020-06-12 15:45:42","2","2020-06-12 15:45:42","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 15:45:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8091","DEPOSIT",null,"PAID","2020-06-12 15:45:42",0,"2","2020-06-12 15:45:42","2","2020-06-12 15:45:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 15:45:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8091","INVOICE","8448","PAID","2020-06-12 15:45:42",8148,"2","2020-06-12 15:45:42","2","2020-06-12 15:45:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 16:10:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 16:48:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 17:09:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 17:10:11","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&filter1=0&filter2=1548&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":[],"_payment_type":"INVOICE","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"G270474(8)","title":"Mr","lastname":"LAI","firstname":"Kwan Lik Raymond","companyname":"","email":"raymond.lai@gmail.com","tel":"67701733","address":"Flat B, 3\/F, Block 8, South Horizons, Ap Lei Chau","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1650","room_code":"A16-159","retail_price":"1090.0","discounted_price":"1090.00","location_id":"7"},{"room_id":"1652","room_code":"A16-161","retail_price":"5038.0","discounted_price":"5038.00","location_id":"7"}],"roughly_size":"76","total_retail_price":6128,"total_discounted_price":4862,"deposit":9724,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":17017,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"7293.00","warehousing_date":"2020-06-15","rent_from":"2020-06-15","rent_to":"2020-09-14","delivery_service":"0","remark":"3 months contract. Special offer 50% off for the first 3 months based on the original price in renewal price list. Storage rental and deposit paid by EPS on June 12,2020. Smart card and padlock provided on the same day.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":7293,"order_total":24310,"final_order_total":17017,"location_id":"7","branch_id":"1","company_id":"1","room_key":"189,63729","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> \n\t\t\t\t\tA16-159 4X3X7 $1090.00 - <\/td> <\/td> \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\t\t\t\t\tA16-161 8X8X7 $5038.00 - <\/td> \u9810\u4ed812\u500b\u6708 \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"76","total_discounted_price":"4862.00","deposit":"9724.00","total_retail_price":"6128.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 17:10:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201621","PERSONAL","Mr","ck+exO\/VmBBs\/38U8HLbn9oBQqB8X8PH75uv7rwtsjw=","8hiEOuVVoOMleTEBdtujcw==","","u+qfUCXmiXE6JX5Prpy5Cw==","WtkdljxdhYOncZruSAGu6YTKYRtCwc58vut+QHW\/fFk=","JLpc7at18rZk4H15apx0a+dUoEjGj3schJNhrqcquAK5JJX9j9vD9BMQNG6m45+6G20nWKJKOEVN\/O7mKO793g==","AdAeuYBxFFZFztIItqXaYg==",null,"WtkdljxdhYOncZruSAGu6YTKYRtCwc58vut+QHW\/fFk=","4bdGwfsZFu3ICtQAMLqlTw==","2","2020-06-12 17:10:11","2","2020-06-12 17:10:11"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 17:10:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7",1621,"NEW","A16-CT208120",6128,4862,9724,0,"3","3",17017,24310,17017,"2020-06-12 17:10:12","0",null,null,null,"2020-06-15","2020-09-14","3 months contract. Special offer 50% off for the first 3 months based on the original price in renewal price list. Storage rental and deposit paid by EPS on June 12,2020. Smart card and padlock provided on the same day.","2020-06-15","76",0,null,7293,"7293.00","2","2020-06-12 17:10:11","2","2020-06-12 17:10:11","EPS","","","","EPS","","","",null,0,"189,63729","C201621","PERSONAL","Mr","ck+exO\/VmBBs\/38U8HLbn9oBQqB8X8PH75uv7rwtsjw=","8hiEOuVVoOMleTEBdtujcw==","","JLpc7at18rZk4H15apx0a+dUoEjGj3schJNhrqcquAK5JJX9j9vD9BMQNG6m45+6G20nWKJKOEVN\/O7mKO793g==","u+qfUCXmiXE6JX5Prpy5Cw==","WtkdljxdhYOncZruSAGu6YTKYRtCwc58vut+QHW\/fFk=","AdAeuYBxFFZFztIItqXaYg==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 17:10:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8120","1650","1090.0","1090.00","2","2020-06-12 17:10:11"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 17:10:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-15","2020-09-14","1650"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-12 17:10:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8120","1652","5038.0","5038.00","2","2020-06-12 17:10:11"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 17:10:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-15","2020-09-14","1652"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-12 17:10:12","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":["8120","A16-D205467","PAID",9724,0,"2020-09-14","2020-06-12 17:10:11","2020-06-12 17:10:11","2","2020-06-12 17:10:11","2","2020-06-12 17:10:11",1621]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 17:10:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8120",1621,"SETTLED","A16-I208449","2020-06-12 17:10:11","2020-06-15","2","2020-06-12 17:10:11","2","2020-06-12 17:10:11"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 17:10:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8449","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-12 17:10:11","2","2020-06-12 17:10:11"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 17:10:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8449","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,2431,"MO","1",2431,"2","2020-06-12 17:10:11","2","2020-06-12 17:10:11"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 17:10:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8449","RENT","\u9810\u7e73\u79df\u91d1",3,4862,"MO","1",4862,"2","2020-06-12 17:10:11","2","2020-06-12 17:10:11"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 17:10:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7293,0,"8449"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-12 17:10:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1621,"EPS","","","","EPS","","","","PAID","P208092","2020-06-12 17:10:11",17017,"2","2020-06-12 17:10:11","2","2020-06-12 17:10:11","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 17:10:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8092","DEPOSIT","5467","PAID","2020-06-12 17:10:11",9724,"2","2020-06-12 17:10:11","2","2020-06-12 17:10:11"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 17:10:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8092","INVOICE","8449","PAID","2020-06-12 17:10:11",7293,"2","2020-06-12 17:10:11","2","2020-06-12 17:10:11"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 17:11:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 17:18:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 17:40:45","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 17:44:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 17:49:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 17:50:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 17:50:54","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","'0012522650","12 months contract. Special offer 50% off for the first 3 months and the 11th & 12th months free for the first contract. Storage rental and deposit paid by bank transfer on June 05,2020. Smart card and padlock paid on the same day.","2020-06-12 17:50:54","2","BfbwRFgXcXfr1bciP\/Bldg==","hyN5\/h7JzFo++OquXZzInSASxbDCbJ\/SZO9VOLcd8pQ=","TpsVfG6TRmESVE8Ld40twF3YfnHeiOw2xU7MU\/5P8gw=","NYLur5T\/CFerDStJz2L3pg==","SdKDHVV80KEKdMraxsG12aBFsdLVTpUihFJYoCcZ5XqOWg6fDAtO6pZINnapCEdRPkXiiHFep1AMP2DL0rL9RZTCryRzQRX094UzieyxZK0=",8070]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 18:09:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 18:10:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 18:10:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 18:14:07","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=0&filter2=7198&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1134,"customer_code":"C181134","identity_type":"PERSONAL","identity_id":"Z017853(6)","title":"Mr","lastname":"Leung","firstname":"Wai Tat","companyname":"","email":"victorleung345@gmail.com","tel":"52255418","address":"Flat 06, 2\/F Yuet Chui Court 9, Yan Tsui St, Chai Wan, HK","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"356.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-10","renew_room_key":"0012472672","renew_remark":"1 month contract. Storage rental paid by PPS on May 11, 2020. Storage deposit transferred from agreement C15-CT207667 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT207832, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"158","order_discount":[],"order_room":[{"room_id":"1452","room_code":"C15-146","retail_price":"510.0","discounted_price":"510.00","location_id":"6"}],"roughly_size":"8.1","total_retail_price":510,"total_discounted_price":356,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":356,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-10","rent_from":"2020-06-10","rent_to":"2020-07-09","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on June 10, 2020. Storage deposit transferred from agreement C15-CT207832 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":356,"final_order_total":356,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012472672","order_product":[],"pass":true}},"first_order_id":"4805","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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tC15-146 3X2.7X3 $510.00 N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"8.1","total_discounted_price":"356.0","deposit":"0","total_retail_price":"510.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 18:14:08","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",1134,"NEW","C15-CT208121",510,356,0,0,"1","1",356,356,356,"2020-06-12 18:14:08","0",null,null,null,"2020-06-10","2020-07-09","1 month contract. Storage rental paid by PPS on June 10, 2020. Storage deposit transferred from agreement C15-CT207832 to this agreement.","2020-06-10","8.1",0,null,0,"0","2","2020-06-12 18:14:07","2","2020-06-12 18:14:07","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0012472672","C181134","PERSONAL","Mr","S1eQwXaAsUdtzc1Ymck8Jg==","xEf2h2aoyRQ71ZVgBH+9WQ==","","596Kcg0kSfbD85GNFxMa7h8CY7zKszjQ7hj4A6ucjRZeYl+TO11xTTCVesXiaJ\/pTZeIYxCHmr9rgYiIkihiFg==","50+huvkYI7Tn4ZAWxVwcPw==","FRHJOJDYd5XByaT89nynmQawjlXgI0AS4R5zIEqR4E0=","XQVqohimdZ7JoGvCaH2ATQ==",null,1,"4805"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 18:14:08","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":["8121","1452","510.0","510.00","2","2020-06-12 18:14:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 18:14:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-10","2020-07-09","1452"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-12 18:14:08","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":["8121",1134,"SETTLED","C15-I208450","2020-06-12 18:14:07","2020-06-10","2","2020-06-12 18:14:07","2","2020-06-12 18:14:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 18:14:08","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":["8450","RENT","\u9810\u7e73\u79df\u91d1",1,356,"MO","1",356,"2","2020-06-12 18:14:07","2","2020-06-12 18:14:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 18:14:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[356,0,"8450"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-12 18:14:08","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":[1134,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208093","2020-06-12 18:14:07",356,"2","2020-06-12 18:14:07","2","2020-06-12 18:14:07","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 18:14:08","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":["8093","DEPOSIT",null,"PAID","2020-06-12 18:14:07",0,"2","2020-06-12 18:14:07","2","2020-06-12 18:14:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 18:14:08","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":["8093","INVOICE","8450","PAID","2020-06-12 18:14:07",356,"2","2020-06-12 18:14:07","2","2020-06-12 18:14:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 18:46:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 18:55:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-12 18:57:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****