\r\n\t\t\t\t\tC65 4X4X8 $1098.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":"16","total_discounted_price":"989.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:51:48","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",1264,"NEW","A12-CT208034",1098,989,0,0,"13","13",12857,12857,12857,"2020-06-03 10:51:48","0",null,null,null,"2020-06-09","2021-07-08","13 months contract. Special offer the 13th month free. Storage rental and paid by cash on June 3, 2020. Storage deposit $2196 transferred from agreement A12-CT194934 to this agreement. \r\n","2020-06-09","16",0,null,0,"0","2","2020-06-03 10:51:48","2","2020-06-03 10:51:48","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"111, 36172","C191264","PERSONAL","Mr","BquI3AaSQeVyobAZD+G9xA==","8hiEOuVVoOMleTEBdtujcw==","","294qqMdiRYHxKs8CkKGH\/6YMF8zBduUVeiSAtIO3GROqUdAUPgc\/kKr8YwFjABxsOHckv4+KrHB+68YlwJmafooYB4C6mPTAPRcUvR4zadc=","S6hrwK4xrYwlbyHT68d3cg==",null,"Il\/t6jT291N8hOgJ86GYsg==",null,1,4934]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:51:48","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":["8034","189","1098.0","1098.00","2","2020-06-03 10:51:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:51:48","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-09","2021-07-08","189"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 10:51:48","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":["8034",1264,"SETTLED","A12-I208363","2020-06-03 10:51:48","2020-06-09","2","2020-06-03 10:51:48","2","2020-06-03 10:51:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:51:48","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":["8363","RENT","\u9810\u7e73\u79df\u91d1",1,989,"MO","1",989,"2","2020-06-03 10:51:48","2","2020-06-03 10:51:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:51:48","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":["8363","RENT","\u9810\u7e73\u79df\u91d1",2,989,"MO","1",989,"2","2020-06-03 10:51:48","2","2020-06-03 10:51:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:51:48","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":["8363","RENT","\u9810\u7e73\u79df\u91d1",3,989,"MO","1",989,"2","2020-06-03 10:51:48","2","2020-06-03 10:51:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:51:48","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":["8363","RENT","\u9810\u7e73\u79df\u91d1",4,989,"MO","1",989,"2","2020-06-03 10:51:48","2","2020-06-03 10:51:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:51:48","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":["8363","RENT","\u9810\u7e73\u79df\u91d1",5,989,"MO","1",989,"2","2020-06-03 10:51:48","2","2020-06-03 10:51:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:51:48","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":["8363","RENT","\u9810\u7e73\u79df\u91d1",6,989,"MO","1",989,"2","2020-06-03 10:51:48","2","2020-06-03 10:51:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:51:48","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":["8363","RENT","\u9810\u7e73\u79df\u91d1",7,989,"MO","1",989,"2","2020-06-03 10:51:48","2","2020-06-03 10:51:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:51:48","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":["8363","RENT","\u9810\u7e73\u79df\u91d1",8,989,"MO","1",989,"2","2020-06-03 10:51:48","2","2020-06-03 10:51:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:51:48","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":["8363","RENT","\u9810\u7e73\u79df\u91d1",9,989,"MO","1",989,"2","2020-06-03 10:51:48","2","2020-06-03 10:51:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:51:48","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":["8363","RENT","\u9810\u7e73\u79df\u91d1",10,989,"MO","1",989,"2","2020-06-03 10:51:48","2","2020-06-03 10:51:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:51:48","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":["8363","RENT","\u9810\u7e73\u79df\u91d1",11,989,"MO","1",989,"2","2020-06-03 10:51:48","2","2020-06-03 10:51:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:51:48","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":["8363","RENT","\u9810\u7e73\u79df\u91d1",12,989,"MO","1",989,"2","2020-06-03 10:51:48","2","2020-06-03 10:51:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:51:48","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":["8363","RENT","\u9810\u7e73\u79df\u91d1",13,989,"MO","1",989,"2","2020-06-03 10:51:48","2","2020-06-03 10:51:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:51:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[12857,0,"8363"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-03 10:51:48","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":[1264,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P208007","2020-06-03 10:51:48",12857,"2","2020-06-03 10:51:48","2","2020-06-03 10:51:48","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:51:48","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":["8007","DEPOSIT",null,"PAID","2020-06-03 10:51:48",0,"2","2020-06-03 10:51:48","2","2020-06-03 10:51:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:51:48","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":["8007","INVOICE","8363","PAID","2020-06-03 10:51:48",12857,"2","2020-06-03 10:51:48","2","2020-06-03 10:51:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:52:51","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","111, 36172","13 months contract. Special offer the 13th month free. Storage rental and paid by cash on June 3, 2020. Storage deposit $2196 transferred from agreement A12-CT194934 to this agreement. \r\n","2020-06-03 10:52:51","2","8hiEOuVVoOMleTEBdtujcw==","BquI3AaSQeVyobAZD+G9xA==","S6hrwK4xrYwlbyHT68d3cg==","294qqMdiRYHxKs8CkKGH\/6YMF8zBduUVeiSAtIO3GROqUdAUPgc\/kKr8YwFjABxsOHckv4+KrHB+68YlwJmafooYB4C6mPTAPRcUvR4zadc=",8034]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:54:34","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","floor_plan_rent_room":[{"room_id":"189","master_room_id":"8","room_code":"C65"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\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\tC65 4X4X8 $1098.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","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"D357771(7)","title":"Mr","lastname":"LAI","firstname":"Sai Cheung","companyname":"","email":"","tel":"51120078","address":"Room 1515, 15\/F, Pick Shan House, Shek Pai Wan Estate, Aberdeen, Hong Kong","pass":true,"customer_id":"1264","customer_code":"C191264","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"189","room_code":"C65","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":989,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":11868,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"989.00","warehousing_date":"2020-06-09","rent_from":"2020-06-09","rent_to":"2021-07-08","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental and paid by cash on June 3, 2020. Storage deposit $2196 transferred from agreement A12-CT194934 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":989,"order_total":12857,"final_order_total":11868,"location_id":"1","branch_id":"1","company_id":"1","room_key":"111, 36172","order_product":[],"pass":true}},"roughly_size":"16","total_discounted_price":"989.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:54: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","1","1264","NEW","A12-CT208035",1098,989,0,0,"13","13",11868,12857,11868,"2020-06-03 10:54:35","0",null,null,null,"2020-06-09","2021-07-08","13 months contract. Special offer the 13th month free. Storage rental and paid by cash on June 3, 2020. Storage deposit $2196 transferred from agreement A12-CT194934 to this agreement. \r\n","2020-06-09","16",0,null,989,"989.00","2","2020-06-03 10:54:34","2","2020-06-03 10:54:34","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"111, 36172","C191264","PERSONAL","Mr","BquI3AaSQeVyobAZD+G9xA==","8hiEOuVVoOMleTEBdtujcw==","","294qqMdiRYHxKs8CkKGH\/6YMF8zBduUVeiSAtIO3GROqUdAUPgc\/kKr8YwFjABxsOHckv4+KrHB+68YlwJmafooYB4C6mPTAPRcUvR4zadc=","S6hrwK4xrYwlbyHT68d3cg==",null,"Il\/t6jT291N8hOgJ86GYsg==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:54: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":["8035","189","1098.0","1098.00","2","2020-06-03 10:54:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:54: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-09","2021-07-08","189"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 10:54: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":["8035","1264","SETTLED","A12-I208364","2020-06-03 10:54:34","2020-06-09","2","2020-06-03 10:54:34","2","2020-06-03 10:54:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:54: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":["8364","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,989,"MO","1",989,"2","2020-06-03 10:54:34","2","2020-06-03 10:54:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:54: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":["8364","RENT","\u9810\u7e73\u79df\u91d1",3,989,"MO","1",989,"2","2020-06-03 10:54:34","2","2020-06-03 10:54:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:54: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":["8364","RENT","\u9810\u7e73\u79df\u91d1",4,989,"MO","1",989,"2","2020-06-03 10:54:34","2","2020-06-03 10:54:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:54: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":["8364","RENT","\u9810\u7e73\u79df\u91d1",5,989,"MO","1",989,"2","2020-06-03 10:54:34","2","2020-06-03 10:54:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:54: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":["8364","RENT","\u9810\u7e73\u79df\u91d1",6,989,"MO","1",989,"2","2020-06-03 10:54:34","2","2020-06-03 10:54:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:54: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":["8364","RENT","\u9810\u7e73\u79df\u91d1",7,989,"MO","1",989,"2","2020-06-03 10:54:34","2","2020-06-03 10:54:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:54: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":["8364","RENT","\u9810\u7e73\u79df\u91d1",8,989,"MO","1",989,"2","2020-06-03 10:54:34","2","2020-06-03 10:54:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:54: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":["8364","RENT","\u9810\u7e73\u79df\u91d1",9,989,"MO","1",989,"2","2020-06-03 10:54:34","2","2020-06-03 10:54:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:54: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":["8364","RENT","\u9810\u7e73\u79df\u91d1",10,989,"MO","1",989,"2","2020-06-03 10:54:34","2","2020-06-03 10:54:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:54: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":["8364","RENT","\u9810\u7e73\u79df\u91d1",11,989,"MO","1",989,"2","2020-06-03 10:54:34","2","2020-06-03 10:54:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:54: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":["8364","RENT","\u9810\u7e73\u79df\u91d1",12,989,"MO","1",989,"2","2020-06-03 10:54:34","2","2020-06-03 10:54:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:54: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":["8364","RENT","\u9810\u7e73\u79df\u91d1",13,989,"MO","1",989,"2","2020-06-03 10:54:34","2","2020-06-03 10:54:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:54:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11868,0,"8364"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-03 10:54: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":["1264","NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P208008","2020-06-03 10:54:34",11868,"2","2020-06-03 10:54:34","2","2020-06-03 10:54:34","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:54: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":["8008","DEPOSIT",null,"PAID","2020-06-03 10:54:34",0,"2","2020-06-03 10:54:34","2","2020-06-03 10:54:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:54: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":["8008","INVOICE","8364","PAID","2020-06-03 10:54:34",11868,"2","2020-06-03 10:54:34","2","2020-06-03 10:54:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:58:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:58:31","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"189","master_room_id":"8","room_code":"C65"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1264,"customer_code":"C191264","identity_type":"PERSONAL","identity_id":"D357771(7)","title":"Mr","lastname":"LAI","firstname":"Sai Cheung","companyname":"","email":null,"tel":"51120078","address":"Room 1515, 15\/F, Pick Shan House, Shek Pai Wan Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"899.0","renew_rent_month":"13","renew_warehousing_date":"2020-08-07","renew_room_key":"111, 36172","renew_remark":"13 months contract. Special offer Prepay 12 months, the 13th month free. Storage rental and deposit paid by cash on July 6, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195416, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1996.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"273","room_code":"D77","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":899,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":10788,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"899.00","warehousing_date":"2020-08-07","rent_from":"2020-08-07","rent_to":"2021-09-06","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by cash on June 3, 2020. Storage deposit $1996 transferred from agreement A12-CT195416 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":899,"order_total":11687,"final_order_total":10788,"location_id":"1","branch_id":"1","company_id":"1","room_key":"111, 36172","order_product":[],"pass":true}},"first_order_id":5416,"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\tD77 4X3X8 $998.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":"12","total_discounted_price":"899.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:58:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",1264,"NEW","A12-CT208036",998,899,0,0,"13","13",10788,11687,10788,"2020-06-03 10:58:31","0",null,null,null,"2020-08-07","2021-09-06","13 months contract. Special offer the 13th month free. Storage rental paid by cash on June 3, 2020. Storage deposit $1996 transferred from agreement A12-CT195416 to this agreement. \r\n","2020-08-07","12",0,null,899,"899.00","2","2020-06-03 10:58:31","2","2020-06-03 10:58:31","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"111, 36172","C191264","PERSONAL","Mr","BquI3AaSQeVyobAZD+G9xA==","8hiEOuVVoOMleTEBdtujcw==","","294qqMdiRYHxKs8CkKGH\/6YMF8zBduUVeiSAtIO3GROqUdAUPgc\/kKr8YwFjABxsOHckv4+KrHB+68YlwJmafooYB4C6mPTAPRcUvR4zadc=","S6hrwK4xrYwlbyHT68d3cg==",null,"Il\/t6jT291N8hOgJ86GYsg==",null,1,5416]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:58:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8036","273","998.0","998.00","2","2020-06-03 10:58:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:58:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-07","2021-09-06","273"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 10:58:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8036",1264,"SETTLED","A12-I208365","2020-06-03 10:58:31","2020-08-07","2","2020-06-03 10:58:31","2","2020-06-03 10:58:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:58:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8365","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,899,"MO","1",899,"2","2020-06-03 10:58:31","2","2020-06-03 10:58:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:58:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8365","RENT","\u9810\u7e73\u79df\u91d1",3,899,"MO","1",899,"2","2020-06-03 10:58:31","2","2020-06-03 10:58:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:58:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8365","RENT","\u9810\u7e73\u79df\u91d1",4,899,"MO","1",899,"2","2020-06-03 10:58:31","2","2020-06-03 10:58:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:58:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8365","RENT","\u9810\u7e73\u79df\u91d1",5,899,"MO","1",899,"2","2020-06-03 10:58:31","2","2020-06-03 10:58:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:58:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8365","RENT","\u9810\u7e73\u79df\u91d1",6,899,"MO","1",899,"2","2020-06-03 10:58:31","2","2020-06-03 10:58:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:58:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8365","RENT","\u9810\u7e73\u79df\u91d1",7,899,"MO","1",899,"2","2020-06-03 10:58:31","2","2020-06-03 10:58:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:58:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8365","RENT","\u9810\u7e73\u79df\u91d1",8,899,"MO","1",899,"2","2020-06-03 10:58:31","2","2020-06-03 10:58:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:58:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8365","RENT","\u9810\u7e73\u79df\u91d1",9,899,"MO","1",899,"2","2020-06-03 10:58:31","2","2020-06-03 10:58:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:58:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8365","RENT","\u9810\u7e73\u79df\u91d1",10,899,"MO","1",899,"2","2020-06-03 10:58:31","2","2020-06-03 10:58:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:58:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8365","RENT","\u9810\u7e73\u79df\u91d1",11,899,"MO","1",899,"2","2020-06-03 10:58:31","2","2020-06-03 10:58:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:58:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8365","RENT","\u9810\u7e73\u79df\u91d1",12,899,"MO","1",899,"2","2020-06-03 10:58:31","2","2020-06-03 10:58:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:58:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8365","RENT","\u9810\u7e73\u79df\u91d1",13,899,"MO","1",899,"2","2020-06-03 10:58:31","2","2020-06-03 10:58:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:58:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10788,0,"8365"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-03 10:58:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1264,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P208009","2020-06-03 10:58:31",10788,"2","2020-06-03 10:58:31","2","2020-06-03 10:58:31","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:58:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8009","DEPOSIT",null,"PAID","2020-06-03 10:58:31",0,"2","2020-06-03 10:58:31","2","2020-06-03 10:58:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 10:58:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8009","INVOICE","8365","PAID","2020-06-03 10:58:31",10788,"2","2020-06-03 10:58:31","2","2020-06-03 10:58:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 11:30:57","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1133","master_room_id":"114","room_code":"A05-131"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\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-131 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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"K731711(5)","title":"Ms","lastname":"YU","firstname":"Mei Fun","companyname":"","email":"","tel":"90844102","address":"Flat 9E, Block 14, Chi Fu Fa Yuen, Pok Fu Lam, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"249","master_room_id":"114","discount_type":"%","price":"1290.00","disocunted_price":"1225.90","discount":"4.97","monthly_deduct":64.113,"room_id":"1133","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1133","room_code":"A05-131","retail_price":"1290.0","discounted_price":1225.9,"location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1038,"deposit":2076,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3633,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1557.00","warehousing_date":"2020-06-03","rent_from":"2020-06-03","rent_to":"2020-09-02","delivery_service":"0","remark":"3 months contract. Special offer first 3 months 50% off. Storage rental and deposit paid by cash on June 3, 2020. Smartcard and padlock provided on June 3, 2020. ","paymethod":"CASH","paymethod2":"CASH","discount_deduct":1557,"order_total":5190,"final_order_total":3633,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0005013582","order_product":[],"pass":true}},"roughly_size":"16","total_discounted_price":"1038.00","deposit":"2076.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 11:30:59","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":["C201603","PERSONAL","Ms","04zZr7K0spkP+0Pr+vpBzA==","4sZhlLfrmxrYN8eefiQ6Rg==","","3NwfSNnmNT55V2BSwgQEkQ==",null,"hX5d2tca0NeVecAsKzqssOcxgQ7E2iu4jSq0KVXBmWyd\/gUDQPlpOHaxJpZsvsg0E2BWqKoFYlOfhm226csA0w==","qDRImy9LbyMrzu0E4cd2CA==",null,null,"usuM4CKyp7fJEr4FA7bTzg==","2","2020-06-03 11:30:57","2","2020-06-03 11:30:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 11:30:59","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","4",1603,"NEW","A05-CT208037",1290,1038,2076,0,"3","3",3633,5190,3633,"2020-06-03 11:30:59","0",null,null,null,"2020-06-03","2020-09-02","3 months contract. Special offer first 3 months 50% off. Storage rental and deposit paid by cash on June 3, 2020. Smartcard and padlock provided on June 3, 2020. ","2020-06-03","16",0,null,1557,"1557.00","2","2020-06-03 11:30:57","2","2020-06-03 11:30:57","CASH","","","","CASH","","","",null,0,"'0005013582","C201603","PERSONAL","Ms","04zZr7K0spkP+0Pr+vpBzA==","4sZhlLfrmxrYN8eefiQ6Rg==","","hX5d2tca0NeVecAsKzqssOcxgQ7E2iu4jSq0KVXBmWyd\/gUDQPlpOHaxJpZsvsg0E2BWqKoFYlOfhm226csA0w==","3NwfSNnmNT55V2BSwgQEkQ==",null,"qDRImy9LbyMrzu0E4cd2CA==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 11:30:59","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":["8037","249","114","1133","%","4.97",64.113,"2","2020-06-03 11:30:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 11:30:59","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":["8037","1133","1290.0",1225.9,"2","2020-06-03 11:30:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 11:30:59","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-03","2020-09-02","1133"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 11:30:59","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":["8037","A05-D205448","PAID",2076,0,"2020-09-02","2020-06-03 11:30:57","2020-06-03 11:30:57","2","2020-06-03 11:30:57","2","2020-06-03 11:30:57",1603]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 11:30:59","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":["8037",1603,"SETTLED","A05-I208366","2020-06-03 11:30:57","2020-06-03","2","2020-06-03 11:30:57","2","2020-06-03 11:30:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 11:30:59","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":["8366","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-03 11:30:57","2","2020-06-03 11:30:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 11:30:59","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":["8366","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,519,"MO","1",519,"2","2020-06-03 11:30:57","2","2020-06-03 11:30:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 11:30:59","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":["8366","RENT","\u9810\u7e73\u79df\u91d1",3,1038,"MO","1",1038,"2","2020-06-03 11:30:57","2","2020-06-03 11:30:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 11:30:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1557,0,"8366"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-03 11:30:59","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":[1603,"CASH","","","","CASH","","","","PAID","P208010","2020-06-03 11:30:57",3633,"2","2020-06-03 11:30:57","2","2020-06-03 11:30:57","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 11:30:59","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":["8010","DEPOSIT","5448","PAID","2020-06-03 11:30:57",2076,"2","2020-06-03 11:30:57","2","2020-06-03 11:30:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 11:30:59","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":["8010","INVOICE","8366","PAID","2020-06-03 11:30:57",1557,"2","2020-06-03 11:30:57","2","2020-06-03 11:30:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 12:00:32","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","_payment_type":"INVOICE","floor_plan_rent_room":[],"warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"Z621009(1)","title":"Ms","lastname":"CHOI","firstname":"Tsz Mei","companyname":"","email":"cecilia_choi_2000@hotmail.com","tel":"66206005","address":"Flat A, 3\/F, Tower 8, South Horizons, Ap Lei Chau, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"839","room_code":"R13","retail_price":"6800.0","discounted_price":"6800.00","location_id":"3"}],"roughly_size":"85","total_retail_price":6800,"total_discounted_price":5388,"deposit":10776,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":18858,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"8082.00","warehousing_date":"2020-07-25","rent_from":"2020-07-25","rent_to":"2020-10-24","delivery_service":"0","remark":"3 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit paid by cheque on Jun 03,2020. Smartcard and padlock provided on the same day.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":8082,"order_total":26940,"final_order_total":18858,"location_id":"3","branch_id":"1","company_id":"1","room_key":"076,32380","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\tR13 8.5X10X7 $6800.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":"85","total_discounted_price":"5388.00","deposit":"10776.00","total_retail_price":"6800.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 12:00:33","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":["C201604","PERSONAL","Ms","1kLTX0y+9bRLX9pAKcFlng==","U3iGX7U0CkjAKcdgZ04K6A==","","scYkgRS9mU4XNHgM03uYAw==","6M6yEOgK0vlziFkHzfKtPHC18YNYpEkRHqqIqMJspDg=","aMzil9pAr+xngbkwVP0iCtcSbziABAG4GQc2Hj+muX61Bf6ADgW8+D3oMmCFKS74KhjZbmtu1GX4ZCVX1mhP9Q==","83D8qghloarq4EP0Noe2+w==",null,"6M6yEOgK0vlziFkHzfKtPHC18YNYpEkRHqqIqMJspDg=","JhIyS+bswmkg0ajOo1gvgw==","2","2020-06-03 12:00:32","2","2020-06-03 12:00:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 12:00:34","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","3",1604,"NEW","A18-CT208038",6800,5388,10776,0,"3","3",18858,26940,18858,"2020-06-03 12:00:34","0",null,null,null,"2020-07-25","2020-10-24","3 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit paid by cheque on Jun 03,2020. Smartcard and padlock provided on the same day.","2020-07-25","85",0,null,8082,"8082.00","2","2020-06-03 12:00:32","2","2020-06-03 12:00:32","CHEQUE","","","","CHEQUE","","","",null,0,"076,32380","C201604","PERSONAL","Ms","1kLTX0y+9bRLX9pAKcFlng==","U3iGX7U0CkjAKcdgZ04K6A==","","aMzil9pAr+xngbkwVP0iCtcSbziABAG4GQc2Hj+muX61Bf6ADgW8+D3oMmCFKS74KhjZbmtu1GX4ZCVX1mhP9Q==","scYkgRS9mU4XNHgM03uYAw==","6M6yEOgK0vlziFkHzfKtPHC18YNYpEkRHqqIqMJspDg=","83D8qghloarq4EP0Noe2+w==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 12:00:34","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":["8038","839","6800.0","6800.00","2","2020-06-03 12:00:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 12:00:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-25","2020-10-24","839"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 12:00:34","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":["8038","A18-D205449","PAID",10776,0,"2020-10-24","2020-06-03 12:00:32","2020-06-03 12:00:32","2","2020-06-03 12:00:32","2","2020-06-03 12:00:32",1604]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 12:00:34","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":["8038",1604,"SETTLED","A18-I208367","2020-06-03 12:00:32","2020-07-25","2","2020-06-03 12:00:32","2","2020-06-03 12:00:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 12:00:34","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":["8367","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-03 12:00:32","2","2020-06-03 12:00:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 12:00:34","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":["8367","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,2694,"MO","1",2694,"2","2020-06-03 12:00:32","2","2020-06-03 12:00:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 12:00:34","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":["8367","RENT","\u9810\u7e73\u79df\u91d1",3,5388,"MO","1",5388,"2","2020-06-03 12:00:32","2","2020-06-03 12:00:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 12:00:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8082,0,"8367"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-03 12:00:34","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":[1604,"CHEQUE","","","","CHEQUE","","","","PAID","P208011","2020-06-03 12:00:32",18858,"2","2020-06-03 12:00:32","2","2020-06-03 12:00:32","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 12:00:34","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":["8011","DEPOSIT","5449","PAID","2020-06-03 12:00:32",10776,"2","2020-06-03 12:00:32","2","2020-06-03 12:00:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 12:00:34","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":["8011","INVOICE","8367","PAID","2020-06-03 12:00:32",8082,"2","2020-06-03 12:00:32","2","2020-06-03 12:00:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 12:24:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 12:25:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 12:33:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 12:33:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 12:53:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 12:53:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 13:33:11","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 13:41: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","_payment_type":"INVOICE","floor_plan_rent_room":[],"warehousing":{"1":{"new_customer":"1","identity_type":"BUSINESS","identity_id":"68595948","title":"Ms","lastname":"WONG","firstname":"Ms","companyname":"Loyal Wealthy International Limited","email":"xjqxjq988@gmail.com","tel":"31112602","address":"Flat\/Rm A, 31\/F, The Signature, No. 8 Chun Fai Terrace Tai Hang, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"341 available_room_list_input","master_room_id":"140","discount_type":"%","price":"1112.00","disocunted_price":"723.90","discount":"34.90","monthly_deduct":388.088,"room_id":"1196","is_final_discount":"0","payment_term":"PREPAID_12_MO"},{"master_room_discount_id":"341 available_room_list_input","master_room_id":"140","discount_type":"%","price":"1112.00","disocunted_price":"723.90","discount":"34.90","monthly_deduct":388.088,"room_id":"1197","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1197","room_code":"B01-007","retail_price":"1112.0","discounted_price":723.9,"location_id":"5"},{"room_id":"1196","room_code":"B01-006","retail_price":"1112.0","discounted_price":723.9,"location_id":"5"}],"roughly_size":"32","total_retail_price":2224,"total_discounted_price":1543,"deposit":1978,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":16638,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3856.00","warehousing_date":"2020-06-05","rent_from":"2020-06-05","rent_to":"2021-06-04","delivery_service":"0","remark":"12 months contract. Special offer 5% 'rent now' discount and the 11th & 12th months free for the first contract. Storage rental and 1 month deposit paid by bank transfer on Jun 02,2020. Smart card mailed out on Jun 03,2020.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":3856,"order_total":20494,"final_order_total":16638,"location_id":"5","branch_id":"2","company_id":"1","room_key":"'0012492375","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\tB01-007 4X4X7 $1112.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\t\t\t\t\tB01-006 4X4X7 $1112.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":"32","total_discounted_price":"1543.00","deposit":"1978.00","total_retail_price":"2224.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 13:41: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":["C201605","BUSINESS","Ms","VEr4RtjrPyCEI5wmpFKxTA==","ddrfzAYTmkL\/QNu3psjONQ==","Loyal Wealthy International Limited","6vVhnNE9a+WnP+kudBnf9Q==","T38ux9tVoBcPpsL1ss6dhL+yW0JF1s9l1wQtsfOhtkE=","urZDlkMzi3W864NQ1HCOntXrGDYosJzAOUvv3DSywj1VV+NOyg9Jj01seoMxUI03ipZiFGNMLbwR7C9TUPEAT2PVhOtMxoAvobd569J5nac=",null,"+JbWCAHyu3pTd+hjr7jzrw==","T38ux9tVoBcPpsL1ss6dhL+yW0JF1s9l1wQtsfOhtkE=","6moczrmEcgrWVPYp2SusHQ==","2","2020-06-03 13:41:08","2","2020-06-03 13:41:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 13:41:09","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","2","5",1605,"NEW","B01-CT208039",2224,1543,1978,0,"12","12",16638,20494,16638,"2020-06-03 13:41:09","0",null,null,null,"2020-06-05","2021-06-04","12 months contract. Special offer 5% 'rent now' discount and the 11th & 12th months free for the first contract. Storage rental and 1 month deposit paid by bank transfer on Jun 02,2020. Smart card mailed out on Jun 03,2020.","2020-06-05","32",0,null,3856,"3856.00","2","2020-06-03 13:41:08","2","2020-06-03 13:41:08","BANKIN","","","","BANKIN","","","",null,0,"'0012492375","C201605","BUSINESS","Ms","VEr4RtjrPyCEI5wmpFKxTA==","ddrfzAYTmkL\/QNu3psjONQ==","Loyal Wealthy International Limited","urZDlkMzi3W864NQ1HCOntXrGDYosJzAOUvv3DSywj1VV+NOyg9Jj01seoMxUI03ipZiFGNMLbwR7C9TUPEAT2PVhOtMxoAvobd569J5nac=","6vVhnNE9a+WnP+kudBnf9Q==","T38ux9tVoBcPpsL1ss6dhL+yW0JF1s9l1wQtsfOhtkE=",null,"+JbWCAHyu3pTd+hjr7jzrw=="]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 13:41:09","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":["8039","341 available_room_list_input","140","1196","%","34.90",388.088,"2","2020-06-03 13:41:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 13:41:09","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":["8039","341 available_room_list_input","140","1197","%","34.90",388.088,"2","2020-06-03 13:41:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 13:41:09","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":["8039","1197","1112.0",723.9,"2","2020-06-03 13:41:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 13:41:09","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-05","2021-06-04","1197"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 13:41:09","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":["8039","1196","1112.0",723.9,"2","2020-06-03 13:41:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 13:41:09","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-05","2021-06-04","1196"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 13:41:09","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":["8039","B01-D205450","PAID",1978,0,"2021-06-04","2020-06-03 13:41:08","2020-06-03 13:41:08","2","2020-06-03 13:41:08","2","2020-06-03 13:41:08",1605]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 13:41:09","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":["8039",1605,"SETTLED","B01-I208368","2020-06-03 13:41:08","2020-06-05","2","2020-06-03 13:41:08","2","2020-06-03 13:41:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 13:41:09","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":["8368","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-03 13:41:08","2","2020-06-03 13:41:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 13:41:09","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":["8368","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-06-03 13:41:08","2","2020-06-03 13:41:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 13:41:09","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":["8368","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,773,"MO","1",773,"2","2020-06-03 13:41:08","2","2020-06-03 13:41:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 13:41:09","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":["8368","RENT","\u9810\u7e73\u79df\u91d1",4,1543,"MO","1",1543,"2","2020-06-03 13:41:08","2","2020-06-03 13:41:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 13:41:09","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":["8368","RENT","\u9810\u7e73\u79df\u91d1",5,1543,"MO","1",1543,"2","2020-06-03 13:41:08","2","2020-06-03 13:41:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 13:41:09","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":["8368","RENT","\u9810\u7e73\u79df\u91d1",6,1543,"MO","1",1543,"2","2020-06-03 13:41:08","2","2020-06-03 13:41:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 13:41:09","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":["8368","RENT","\u9810\u7e73\u79df\u91d1",7,1543,"MO","1",1543,"2","2020-06-03 13:41:08","2","2020-06-03 13:41:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 13:41:09","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":["8368","RENT","\u9810\u7e73\u79df\u91d1",8,1543,"MO","1",1543,"2","2020-06-03 13:41:08","2","2020-06-03 13:41:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 13:41:09","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":["8368","RENT","\u9810\u7e73\u79df\u91d1",9,1543,"MO","1",1543,"2","2020-06-03 13:41:08","2","2020-06-03 13:41:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 13:41:09","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":["8368","RENT","\u9810\u7e73\u79df\u91d1",10,1543,"MO","1",1543,"2","2020-06-03 13:41:08","2","2020-06-03 13:41:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 13:41:09","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":["8368","RENT","\u9810\u7e73\u79df\u91d1",11,1543,"MO","1",1543,"2","2020-06-03 13:41:08","2","2020-06-03 13:41:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 13:41:09","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":["8368","RENT","\u9810\u7e73\u79df\u91d1",12,1543,"MO","1",1543,"2","2020-06-03 13:41:08","2","2020-06-03 13:41:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 13:41:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[14660,0,"8368"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-03 13:41:09","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":[1605,"BANKIN","","","","BANKIN","","","","PAID","P208012","2020-06-03 13:41:08",16638,"2","2020-06-03 13:41:08","2","2020-06-03 13:41:08","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 13:41:09","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":["8012","DEPOSIT","5450","PAID","2020-06-03 13:41:08",1978,"2","2020-06-03 13:41:08","2","2020-06-03 13:41:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 13:41:09","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":["8012","INVOICE","8368","PAID","2020-06-03 13:41:08",14660,"2","2020-06-03 13:41:08","2","2020-06-03 13:41:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 15:04:54","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1133","master_room_id":"114","room_code":"A05-131"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1119,"customer_code":"C181119","identity_type":"PERSONAL","identity_id":"D826898(4)","title":"Mr","lastname":"Chiu","firstname":"Sung Hei","companyname":"","email":"milk1083@yahoo.com","tel":"64773817","address":"Flat D, 8\/F, Fortune Mansion, 20 Hung Shing Street, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"6","renew_warehousing_date":"2020-06-02","renew_room_key":"0012476535","renew_remark":"6 months contract. Storage rental paid by bank transfer on December 3, 2019. Storage deposit $1196 transferred from agreement A05-CT183732 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196599, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"110","order_discount":[],"order_room":[{"room_id":"1078","room_code":"A05-076","retail_price":"598.0","discounted_price":"598.00","location_id":"4"}],"roughly_size":"8","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-02","rent_from":"2020-06-02","rent_to":"2020-12-01","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on May 27, 2020. Storage deposit $1196 transferred from agreement A05-CT196599 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012476535","order_product":[],"pass":true}},"first_order_id":"3732","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\tA05-076 4X2X3.5 $598.00 N\/A <\/td> \u9810\u4ed812\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":"8","total_discounted_price":"538.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 15:04:55","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",1119,"NEW","A05-CT208040",598,538,0,0,"6","6",3228,3228,3228,"2020-06-03 15:04:55","0",null,null,null,"2020-06-02","2020-12-01","6 months contract. Storage rental paid by bank transfer on May 27, 2020. Storage deposit $1196 transferred from agreement A05-CT196599 to this agreement.\r\n","2020-06-02","8",0,null,0,"0","2","2020-06-03 15:04:54","2","2020-06-03 15:04:54","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012476535","C181119","PERSONAL","Mr","MuZt1lYgrMpypgbMsIt8Lg==","sQFQFKDK2lCJDg4WUvEEAw==","","h9FsxQ4+y6tmkXXSf28JN+\/+fESDd1YBpOIM5j\/ZGlSxIgSaYj6ZyF1PjRqum+WKF9Eap9myr+tDMrNsbQIOfoW7I62uXvJ1upAUTlBDwHE=","e5kgt1YGSyJD\/M7FfyYOEw==","JxGuC86ZykblJcqi+nR5I5jLNd3SjVegJ2PfsLL40zg=","DS+B4iq5I2pIT9W8mSYlzw==",null,1,"3732"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 15:04:55","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":["8040","1078","598.0","598.00","2","2020-06-03 15:04:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 15:04:55","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-02","2020-12-01","1078"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 15:04:55","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":["8040",1119,"SETTLED","A05-I208369","2020-06-03 15:04:54","2020-06-02","2","2020-06-03 15:04:54","2","2020-06-03 15:04:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 15:04:55","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":["8369","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-06-03 15:04:54","2","2020-06-03 15:04:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 15:04:55","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":["8369","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-06-03 15:04:54","2","2020-06-03 15:04:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 15:04:55","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":["8369","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-06-03 15:04:54","2","2020-06-03 15:04:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 15:04:55","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":["8369","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-06-03 15:04:54","2","2020-06-03 15:04:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 15:04:55","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":["8369","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-06-03 15:04:54","2","2020-06-03 15:04:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 15:04:55","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":["8369","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-06-03 15:04:54","2","2020-06-03 15:04:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 15:04:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"8369"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-03 15:04:55","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":[1119,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208013","2020-06-03 15:04:54",3228,"2","2020-06-03 15:04:54","2","2020-06-03 15:04:54","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 15:04:55","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":["8013","DEPOSIT",null,"PAID","2020-06-03 15:04:54",0,"2","2020-06-03 15:04:54","2","2020-06-03 15:04:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 15:04:55","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":["8013","INVOICE","8369","PAID","2020-06-03 15:04:54",3228,"2","2020-06-03 15:04:54","2","2020-06-03 15:04:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 15:22: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":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1133","master_room_id":"114","room_code":"A05-131"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":950,"customer_code":"C180950","identity_type":"PERSONAL","identity_id":"M096081(6)","title":"Mr","lastname":"Vincelli","firstname":"Stefano","companyname":"","email":"sabiobra@hotmail.com","tel":"95652114","address":"35 Happy View Terrace, Happy Valley, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4116.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-03","renew_room_key":"076,29154","renew_remark":"1 month contract. Storage rental paid by bank transfer on March, 2020. Storage deposit transferred from agreement A14-CT207398 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\tI08 4X4X8 $1098.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\tJ06 5X8X8 $2888.00 N\/A <\/td> \u9810\u4ed812\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":"56","total_discounted_price":"4116.0","deposit":"0","total_retail_price":"3986.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 15:22:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",950,"NEW","A14-CT208041",3986,4116,0,0,"1","1",4116,4116,4116,"2020-06-03 15:22:43","0",null,null,null,"2020-05-03","2020-06-02","1 month contract. Storage rental paid by bank transfer on May 20, 2020. Storage deposit transferred from agreement A14-CT207787 to this agreement.\r\n","2020-05-03","56",0,null,0,"0","2","2020-06-03 15:22:42","2","2020-06-03 15:22:42","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,29154","C180950","PERSONAL","Mr","kBtwICYFFgkwWiGlHlA7Vg==","J9AQQ+eusxRuMi9Uwswx2w==","","xpCmz6ayhnKM9CeubIeX46ST4OH8jL8leoh\/7rF5LKq0NI4lQzsUw3z+sKEaA2Q2","HMxniP6OLhRLykg\/y72g1w==","G2oqjsMfynuJ5hF7HR+cYPuapiwUrw6QQkLUvHZtFiE=","LjEwev8Vn2pWAe0zRvbXAw==",null,1,"4680"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 15:22:43","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":["8041","417","1098.0","1098.00","2","2020-06-03 15:22:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 15:22:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-03","2020-06-02","417"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 15:22:43","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":["8041","424","2888.0","2888.00","2","2020-06-03 15:22:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 15:22:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-03","2020-06-02","424"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 15:22:43","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":["8041",950,"SETTLED","A14-I208370","2020-06-03 15:22:42","2020-05-03","2","2020-06-03 15:22:42","2","2020-06-03 15:22:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 15:22:43","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":["8370","RENT","\u9810\u7e73\u79df\u91d1",1,4116,"MO","1",4116,"2","2020-06-03 15:22:42","2","2020-06-03 15:22:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 15:22:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4116,0,"8370"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-03 15:22:43","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":[950,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208014","2020-06-03 15:22:42",4116,"2","2020-06-03 15:22:42","2","2020-06-03 15:22:42","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 15:22:43","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":["8014","DEPOSIT",null,"PAID","2020-06-03 15:22:42",0,"2","2020-06-03 15:22:42","2","2020-06-03 15:22:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 15:22:43","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":["8014","INVOICE","8370","PAID","2020-06-03 15:22:42",4116,"2","2020-06-03 15:22:42","2","2020-06-03 15:22:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 15:37:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 17:05:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 17:54:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 17:57:31","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":["C201606","PERSONAL","Mr","KJ0pwbxt\/WHGiUp+lmu8wA==","6TydFXvfMgmWkOQeoAAhkg==","","74IldhViOvOsLkz\/Txd08A==","z\/lam6o8vc3u5ezCrs6dbaRnnVQtJDoj54hvLQEv5iY=","WG2LekUsDmfQnO6Ps\/V5K4oz40mw1jEm7vTJLfpRzGsPc2ieqAEQDP\/0MAZtvEiODdweYLqr1GUjzz9gpC+T5Q==","01SEs23J00P84DHk4kccgA==","","z\/lam6o8vc3u5ezCrs6dbaRnnVQtJDoj54hvLQEv5iY=","ytlXlreUIQIzdmGZm4aYWw==","2","2020-06-03 17:57:28","2","2020-06-03 17:57:28"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:13:13","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=%E6%96%B0%E5%A2%9E%E6%88%90%E5%8A","_payment_type":"INVOICE","floor_plan_rent_room":[],"warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"M039923(5)","title":"Mr","lastname":"SPARROW","firstname":"Charles Harry","companyname":"","email":"chsparrow@hotmail.com","tel":"92267393","address":"2701, 27\/F, The Central Plaza, 18 Harbour Road, Wan Chai","pass":true,"customer_id":"1606","customer_code":"C201606","customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1692","room_code":"A16-201","retail_price":"2161.0","discounted_price":"2161.00","location_id":"7"},{"room_id":"1691","room_code":"A16-200","retail_price":"2161.0","discounted_price":"2161.00","location_id":"7"},{"room_id":"1690","room_code":"A16-199","retail_price":"2655.0","discounted_price":"2655.00","location_id":"7"},{"room_id":"1701","room_code":"A16-210","retail_price":"2434.0","discounted_price":"2434.00","location_id":"7"},{"room_id":"1700","room_code":"A16-209","retail_price":"2434.0","discounted_price":"2434.00","location_id":"7"},{"room_id":"1705","room_code":"A16-214","retail_price":"1290.0","discounted_price":"1290.00","location_id":"7"},{"room_id":"1699","room_code":"A16-208","retail_price":"1290.0","discounted_price":"1290.00","location_id":"7"},{"room_id":"1704","room_code":"A16-213","retail_price":"1290.0","discounted_price":"1290.00","location_id":"7"},{"room_id":"1698","room_code":"A16-207","retail_price":"1290.0","discounted_price":"1290.00","location_id":"7"},{"room_id":"1703","room_code":"A16-212","retail_price":"1290.0","discounted_price":"1290.00","location_id":"7"},{"room_id":"1697","room_code":"A16-206","retail_price":"1290.0","discounted_price":"1290.00","location_id":"7"},{"room_id":"1702","room_code":"A16-211","retail_price":"1605.0","discounted_price":"1605.00","location_id":"7"},{"room_id":"1696","room_code":"A16-205","retail_price":"1605.0","discounted_price":"1605.00","location_id":"7"}],"roughly_size":"300","total_retail_price":22795,"total_discounted_price":7350,"deposit":14700,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":22050,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-29","rent_from":"2020-06-29","rent_to":"2020-07-28","delivery_service":"0","remark":"1 month contract. Special offer $7350\/month for 300 sq.ft storage area. Storage rental $7350; Storage deposit $14700; Transportation $24500\/ trip and extra 3% credit card charge $2132 (total:$73182) will pay by credit card.","paymethod":"UNPAID","paymethod2":"UNPAID","discount_deduct":0,"order_total":22050,"final_order_total":22050,"location_id":"7","branch_id":"1","company_id":"1","room_key":"189,51979","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-201 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\t\t\t\t\tA16-200 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\t\t\t\t\tA16-199 5X7X7 $2655.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\t\t\t\t\tA16-210 4X8X7 $2434.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-209 4X8X7 $2434.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-214 4X4X7 $1290.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-208 4X4X7 $1290.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-213 4X4X7 $1290.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-207 4X4X7 $1290.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-212 4X4X7 $1290.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-206 4X4X7 $1290.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-211 5X4X7 $1605.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-205 5X4X7 $1605.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":"300","total_discounted_price":"7350.00","deposit":"14700.00","total_retail_price":"22795.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7","1606","NEW","A16-CT208042",22795,7350,14700,0,"1","1",22050,22050,22050,"2020-06-03 18:13:14","0",null,null,null,"2020-06-29","2020-07-28","1 month contract. Special offer $7350\/month for 300 sq.ft storage area. Storage rental $7350; Storage deposit $14700; Transportation $24500\/ trip and extra 3% credit card charge $2132 (total:$73182) will pay by credit card.","2020-06-29","300",0,null,0,"0","2","2020-06-03 18:13:13","2","2020-06-03 18:13:13","UNPAID","","","","UNPAID","","","",null,0,"189,51979","C201606","PERSONAL","Mr","KJ0pwbxt\/WHGiUp+lmu8wA==","6TydFXvfMgmWkOQeoAAhkg==","","WG2LekUsDmfQnO6Ps\/V5K4oz40mw1jEm7vTJLfpRzGsPc2ieqAEQDP\/0MAZtvEiODdweYLqr1GUjzz9gpC+T5Q==","74IldhViOvOsLkz\/Txd08A==","z\/lam6o8vc3u5ezCrs6dbaRnnVQtJDoj54hvLQEv5iY=","01SEs23J00P84DHk4kccgA==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8042","1692","2161.0","2161.00","2","2020-06-03 18:13:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-29","2020-07-28","1692"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8042","1691","2161.0","2161.00","2","2020-06-03 18:13:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-29","2020-07-28","1691"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8042","1690","2655.0","2655.00","2","2020-06-03 18:13:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-29","2020-07-28","1690"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8042","1701","2434.0","2434.00","2","2020-06-03 18:13:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-29","2020-07-28","1701"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8042","1700","2434.0","2434.00","2","2020-06-03 18:13:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-29","2020-07-28","1700"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8042","1705","1290.0","1290.00","2","2020-06-03 18:13:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-29","2020-07-28","1705"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8042","1699","1290.0","1290.00","2","2020-06-03 18:13:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-29","2020-07-28","1699"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8042","1704","1290.0","1290.00","2","2020-06-03 18:13:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-29","2020-07-28","1704"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8042","1698","1290.0","1290.00","2","2020-06-03 18:13:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-29","2020-07-28","1698"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8042","1703","1290.0","1290.00","2","2020-06-03 18:13:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-29","2020-07-28","1703"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8042","1697","1290.0","1290.00","2","2020-06-03 18:13:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-29","2020-07-28","1697"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8042","1702","1605.0","1605.00","2","2020-06-03 18:13:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-29","2020-07-28","1702"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8042","1696","1605.0","1605.00","2","2020-06-03 18:13:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-29","2020-07-28","1696"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 18:13:14","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":["8042","A16-D205451","NEW",14700,14700,"2020-07-28","2020-06-03 18:13:13","2020-06-03 18:13:13","2","2020-06-03 18:13:13","2","2020-06-03 18:13:13","1606"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8042","1606","NEW","A16-I208371","2020-06-03 18:13:13","2020-06-29","2","2020-06-03 18:13:13","2","2020-06-03 18:13:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8371","RENT","\u9810\u7e73\u79df\u91d1",1,7350,"MO","1",7350,"2","2020-06-03 18:13:13","2","2020-06-03 18:13:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:13:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7350,7350,"8371"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-03 18:18:12","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1133","master_room_id":"114","room_code":"A05-131"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":688,"customer_code":"C180688","identity_type":"PERSONAL","identity_id":"K122210(4)","title":"Mr","lastname":"Cheung","firstname":"Wai Yung","companyname":"","email":"yung912@gmail.com","tel":"92637806","address":"Rm A, 20\/F, Block 20, Mei Cheung Court, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1090.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-08","renew_room_key":"054,60450","renew_remark":"1 month contract. Storage rental paid by PPS on May 4, 2020. Storage deposit transferred from agreement A18-CT207565 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\tQ10 3X4X7 $1090.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":"12","total_discounted_price":"1090.0","deposit":"0","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:18:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",688,"NEW","A18-CT208043",1090,1090,0,0,"1","1",1090,1090,1090,"2020-06-03 18:18:13","0",null,null,null,"2020-06-08","2020-07-07","1 month contract. Storage rental paid by PPS on June 2, 2020. Storage deposit transferred from agreement A18-CT207779 to this agreement.\r\n","2020-06-08","12",0,null,0,"0","2","2020-06-03 18:18:12","2","2020-06-03 18:18:12","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,60450","C180688","PERSONAL","Mr","w+3oxtOYocerQ225PhLj2Q==","vCxOlXQuvOQaoL822H2o\/Q==","","QvNFWPnZK2SY5iOuJxtofiF6G+A71It3PRUQIo0auvIWzvBTZRm2wfB\/VYgB4L2eWR9M0rvXLhbVNAUw9JyOPpQPVCto6YLfO\/ESHYYW+OA=","+JEnloGcmAHQH7QI0dDDrg==","KssyFPR1OHCnH1SYGPPT\/JDvr7I47++6Ndv+5eVj1fE=","OGIBS1CZsN25WARbNGD97w==",null,1,"4769"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:18:13","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":["8043","813","1090.0","1090.00","2","2020-06-03 18:18:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:18:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-08","2020-07-07","813"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 18:18:13","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":["8043",688,"SETTLED","A18-I208372","2020-06-03 18:18:12","2020-06-08","2","2020-06-03 18:18:12","2","2020-06-03 18:18:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:18:13","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":["8372","RENT","\u9810\u7e73\u79df\u91d1",1,1090,"MO","1",1090,"2","2020-06-03 18:18:12","2","2020-06-03 18:18:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:18:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1090,0,"8372"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-03 18:18:13","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":[688,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208015","2020-06-03 18:18:12",1090,"2","2020-06-03 18:18:12","2","2020-06-03 18:18:12","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:18:13","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":["8015","DEPOSIT",null,"PAID","2020-06-03 18:18:12",0,"2","2020-06-03 18:18:12","2","2020-06-03 18:18:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:18:13","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":["8015","INVOICE","8372","PAID","2020-06-03 18:18:12",1090,"2","2020-06-03 18:18:12","2","2020-06-03 18:18:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:24:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:36:18","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1133","master_room_id":"114","room_code":"A05-131"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1053,"customer_code":"C181053","identity_type":"PERSONAL","identity_id":"D531166(8)","title":"Ms","lastname":"Cheng","firstname":"Yee Ming","companyname":"","email":"fannycheng10@yahoo.com.hk","tel":"94986376","address":"Flat 2, 13\/F, Hoi Ying Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"981.0","renew_rent_month":"6","renew_warehousing_date":"2020-06-01","renew_room_key":"0012401490","renew_remark":"6 months contract. Storage rental paid by PPS on December 2, 2019. Storage deposit $2180 transferred from agreement A05-CT193548 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196594, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"113","order_discount":[{"master_room_discount_id":"245","master_room_id":"113","discount_type":"%","price":"1090.00","disocunted_price":"981.00","discount":"10.00","monthly_deduct":109,"room_id":"1039","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1039","room_code":"A05-037","retail_price":"1090.0","discounted_price":981,"location_id":"4"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":981,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5886,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-01","rent_from":"2020-06-01","rent_to":"2020-11-30","delivery_service":"0","remark":"6 months contract. Storage rental paid by PPS on June 2, 2020. Storage deposit $2180 transferred from agreement A05-CT196594 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":5886,"final_order_total":5886,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012401490","order_product":[],"pass":true}},"first_order_id":"3548","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\tA05-037 4X3X7 $1090.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":"12","total_discounted_price":"981.0","deposit":"0","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:36:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1053,"NEW","A05-CT208044",1090,981,0,0,"6","6",5886,5886,5886,"2020-06-03 18:36:18","0",null,null,null,"2020-06-01","2020-11-30","6 months contract. Storage rental paid by PPS on June 2, 2020. Storage deposit $2180 transferred from agreement A05-CT196594 to this agreement.\r\n","2020-06-01","12",0,null,0,"0","2","2020-06-03 18:36:18","2","2020-06-03 18:36:18","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0012401490","C181053","PERSONAL","Ms","HInrOpGVBtZsPNUdSll3xQ==","UCPBCXrBLI9U7KKsPqgmNA==","","cfrA4NKkFA9dbJComGGCWONIzpGOz33rOvaKVw9an686nK60hJlkk4cYwp5OxAl3UDd498H1UytAm+ymjBTs6yD47WtVjepGYZY4zrfn\/mk=","noAk7lJ3Yld5zbOQyQMXbA==","VMdwqPGWP6OwXw49Q7zCd8IIdHLENU\/hwmudzRPFV5Y=","bz5Z\/HERn3puKYlEBjSWDA==",null,1,"3548"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:36:18","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":["8044","245","113","1039","%","10.00",109,"2","2020-06-03 18:36:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:36:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8044","1039","1090.0",981,"2","2020-06-03 18:36:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:36:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-11-30","1039"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 18:36:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8044",1053,"SETTLED","A05-I208373","2020-06-03 18:36:18","2020-06-01","2","2020-06-03 18:36:18","2","2020-06-03 18:36:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:36:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8373","RENT","\u9810\u7e73\u79df\u91d1",1,981,"MO","1",981,"2","2020-06-03 18:36:18","2","2020-06-03 18:36:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:36:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8373","RENT","\u9810\u7e73\u79df\u91d1",2,981,"MO","1",981,"2","2020-06-03 18:36:18","2","2020-06-03 18:36:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:36:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8373","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2020-06-03 18:36:18","2","2020-06-03 18:36:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:36:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8373","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2020-06-03 18:36:18","2","2020-06-03 18:36:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:36:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8373","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2020-06-03 18:36:18","2","2020-06-03 18:36:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:36:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8373","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2020-06-03 18:36:18","2","2020-06-03 18:36:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:36:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5886,0,"8373"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-03 18:36:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1053,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208016","2020-06-03 18:36:18",5886,"2","2020-06-03 18:36:18","2","2020-06-03 18:36:18","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:36:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8016","DEPOSIT",null,"PAID","2020-06-03 18:36:18",0,"2","2020-06-03 18:36:18","2","2020-06-03 18:36:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:36:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8016","INVOICE","8373","PAID","2020-06-03 18:36:18",5886,"2","2020-06-03 18:36:18","2","2020-06-03 18:36:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:38:54","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1133","master_room_id":"114","room_code":"A05-131"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1053,"customer_code":"C181053","identity_type":"PERSONAL","identity_id":"D531166(8)","title":"Ms","lastname":"Cheng","firstname":"Yee Ming","companyname":"","email":"fannycheng10@yahoo.com.hk","tel":"94986376","address":"Flat 2, 13\/F, Hoi Ying Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"953.0","renew_rent_month":"6","renew_warehousing_date":"2020-06-01","renew_room_key":"0012401490","renew_remark":"6 months contract. Storage rental $5886 paid by PPS on December 2, 2019. Outstanding $168 will be transferred to next agreement. Storage deposit transferred from agreement A05-CT195115 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-101(\u670d\u88dd\u5009) 4X2.5X7 $1058.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":"10","total_discounted_price":"953.0","deposit":"0","total_retail_price":"1058.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:38:55","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",1053,"NEW","A05-CT208045",1058,953,0,0,"6","6",5718,5718,5718,"2020-06-03 18:38:55","0",null,null,null,"2020-06-01","2020-11-30","6 months contract. Storage rental $5500 paid by PPS on June 2, 2020. Storage deposit and rental $168 transferred from agreement A05-CT196595 to this agreement.\r\n","2020-06-01","10",0,null,0,"0","2","2020-06-03 18:38:54","2","2020-06-03 18:38:54","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0012401490","C181053","PERSONAL","Ms","HInrOpGVBtZsPNUdSll3xQ==","UCPBCXrBLI9U7KKsPqgmNA==","","cfrA4NKkFA9dbJComGGCWONIzpGOz33rOvaKVw9an686nK60hJlkk4cYwp5OxAl3UDd498H1UytAm+ymjBTs6yD47WtVjepGYZY4zrfn\/mk=","noAk7lJ3Yld5zbOQyQMXbA==","VMdwqPGWP6OwXw49Q7zCd8IIdHLENU\/hwmudzRPFV5Y=","bz5Z\/HERn3puKYlEBjSWDA==",null,1,"3786"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:38:55","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":["8045","243","112","1103","%","10.00",105.8,"2","2020-06-03 18:38:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:38:55","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":["8045","1103","1058.0",952.2,"2","2020-06-03 18:38:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:38:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-11-30","1103"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 18:38:55","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":["8045",1053,"SETTLED","A05-I208374","2020-06-03 18:38:54","2020-06-01","2","2020-06-03 18:38:54","2","2020-06-03 18:38:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:38:55","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":["8374","RENT","\u9810\u7e73\u79df\u91d1",1,953,"MO","1",953,"2","2020-06-03 18:38:54","2","2020-06-03 18:38:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:38:55","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":["8374","RENT","\u9810\u7e73\u79df\u91d1",2,953,"MO","1",953,"2","2020-06-03 18:38:54","2","2020-06-03 18:38:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:38:55","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":["8374","RENT","\u9810\u7e73\u79df\u91d1",3,953,"MO","1",953,"2","2020-06-03 18:38:54","2","2020-06-03 18:38:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:38:55","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":["8374","RENT","\u9810\u7e73\u79df\u91d1",4,953,"MO","1",953,"2","2020-06-03 18:38:54","2","2020-06-03 18:38:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:38:55","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":["8374","RENT","\u9810\u7e73\u79df\u91d1",5,953,"MO","1",953,"2","2020-06-03 18:38:54","2","2020-06-03 18:38:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:38:55","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":["8374","RENT","\u9810\u7e73\u79df\u91d1",6,953,"MO","1",953,"2","2020-06-03 18:38:54","2","2020-06-03 18:38:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:38:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5718,0,"8374"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-03 18:38:55","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":[1053,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208017","2020-06-03 18:38:54",5718,"2","2020-06-03 18:38:54","2","2020-06-03 18:38:54","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:38:55","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":["8017","DEPOSIT",null,"PAID","2020-06-03 18:38:54",0,"2","2020-06-03 18:38:54","2","2020-06-03 18:38:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:38:55","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":["8017","INVOICE","8374","PAID","2020-06-03 18:38:54",5718,"2","2020-06-03 18:38:54","2","2020-06-03 18:38:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:48:34","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1133","master_room_id":"114","room_code":"A05-131"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":807,"customer_code":"C180807","identity_type":"PERSONAL","identity_id":"K546620(2)","title":"Mr","lastname":"Choy","firstname":"Chung Kit","companyname":"","email":"chung.greatoo@gmail.com","tel":"65722444","address":"Flat F, 17\/F, Pokfulam Gardens, Pok Fu Lam, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1342.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-26","renew_room_key":"072,57038","renew_remark":"1 month contract. Storage rental paid by PPS on May 4, 2020. Storage deposit transferred from agreement A14-CT207533 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\tL04(\u670d\u88dd\u5009) 4X4X8 $1342.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":"16","total_discounted_price":"1342.0","deposit":"0","total_retail_price":"1342.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:48: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",807,"NEW","A14-CT208046",1342,1342,0,0,"1","1",1342,1342,1342,"2020-06-03 18:48:35","0",null,null,null,"2020-05-26","2020-06-25","1 month contract. Storage rental paid by PPS on June 3, 2020. Storage deposit transferred from agreement A14-CT207780 to this agreement.\r\n","2020-05-26","16",0,null,0,"0","2","2020-06-03 18:48:34","2","2020-06-03 18:48:34","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"072,57038","C180807","PERSONAL","Mr","UrB+L8vaPiEMZevupuoWEA==","UrsMAvfb5x9QBcnJ8435JA==","","ME0hoxN9uZ9kGpx7EDhDMplFp1dDf6LAd2zTCgZuVMA07NK1aBM+okfJHxxQhQeMEGMyIA8TbBMZxd3bYkNlpA==","yzkFlVLEWHluqrSaK6I+5w==","D5Tn0rsTf6KebW06OoCf5+7qkW80yY20kTJlXh0yutU=","SXzqecVFjMModfNH2tMtyQ==",null,1,"4859"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:48: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":["8046","526","1342.0","1342.00","2","2020-06-03 18:48:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:48: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-05-26","2020-06-25","526"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 18:48: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":["8046",807,"SETTLED","A14-I208375","2020-06-03 18:48:34","2020-05-26","2","2020-06-03 18:48:34","2","2020-06-03 18:48:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:48: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":["8375","RENT","\u9810\u7e73\u79df\u91d1",1,1342,"MO","1",1342,"2","2020-06-03 18:48:34","2","2020-06-03 18:48:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:48:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1342,0,"8375"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-03 18:48: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":[807,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208018","2020-06-03 18:48:34",1342,"2","2020-06-03 18:48:34","2","2020-06-03 18:48:34","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:48: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":["8018","DEPOSIT",null,"PAID","2020-06-03 18:48:34",0,"2","2020-06-03 18:48:34","2","2020-06-03 18:48:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:48: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":["8018","INVOICE","8375","PAID","2020-06-03 18:48:34",1342,"2","2020-06-03 18:48:34","2","2020-06-03 18:48:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:52:52","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1133","master_room_id":"114","room_code":"A05-131"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":513,"customer_code":"C170513","identity_type":"PERSONAL","identity_id":"D269682(8)","title":"Ms","lastname":"Chiu","firstname":"Yet Chin Belinda","companyname":"","email":null,"tel":"97761188","address":"28H, Broadview Court, 11 Sham Wan Road, Wong Chuk Hang, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1139.0","renew_rent_month":"6","renew_warehousing_date":"2020-04-20","renew_room_key":"054,44133","renew_remark":"6 months contract. Storage rental paid by bank transfer on October 14, 2019. Storage deposit transferred from agreement A14-CT195728 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196138, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"38","order_discount":[],"order_room":[{"room_id":"451","room_code":"J33","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1205,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3615,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-20","rent_from":"2020-04-20","rent_to":"2020-07-19","delivery_service":"0","remark":"3 months contract. Storage rental paid by PPS on June 2, 2020. Storage deposit transferred from agreement A14-CT196138 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":3615,"final_order_total":3615,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,44133","order_product":[],"pass":true}},"first_order_id":"3489","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\tJ33 4X5X8 $1528.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":"20","total_discounted_price":"1205.00","deposit":"0.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:52:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",513,"NEW","A14-CT208047",1528,1205,0,0,"3","3",3615,3615,3615,"2020-06-03 18:52:52","0",null,null,null,"2020-04-20","2020-07-19","3 months contract. Storage rental paid by PPS on June 2, 2020. Storage deposit transferred from agreement A14-CT196138 to this agreement.\r\n","2020-04-20","20",0,null,0,"0","2","2020-06-03 18:52:52","2","2020-06-03 18:52:52","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,44133","C170513","PERSONAL","Ms","v\/Qvl9+XxAQsoJ9I8VZFglLuKMVFitS22fWLgguDCGg=","sQFQFKDK2lCJDg4WUvEEAw==","","S6KaLgwd6FIlkqrQSiSPL+IYlikFLCNUw20GE3KjhDt8Znv8Np\/jaej2kjTZHxT\/OgG3D6oi+44Rp80x4X8Hvg==","gwjQ9wZ2d8gLVTxS2ti48w==",null,"XSSpdC9kSPuo5jiWm9QheA==",null,1,"3489"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:52:52","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":["8047","451","1528.0","1528.00","2","2020-06-03 18:52:52"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:52:52","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-20","2020-07-19","451"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 18:52:52","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":["8047",513,"SETTLED","A14-I208376","2020-06-03 18:52:52","2020-04-20","2","2020-06-03 18:52:52","2","2020-06-03 18:52:52"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:52:52","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":["8376","RENT","\u9810\u7e73\u79df\u91d1",1,1205,"MO","1",1205,"2","2020-06-03 18:52:52","2","2020-06-03 18:52:52"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:52:52","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":["8376","RENT","\u9810\u7e73\u79df\u91d1",2,1205,"MO","1",1205,"2","2020-06-03 18:52:52","2","2020-06-03 18:52:52"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:52:52","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":["8376","RENT","\u9810\u7e73\u79df\u91d1",3,1205,"MO","1",1205,"2","2020-06-03 18:52:52","2","2020-06-03 18:52:52"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:52:52","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3615,0,"8376"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-03 18:52:52","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":[513,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208019","2020-06-03 18:52:52",3615,"2","2020-06-03 18:52:52","2","2020-06-03 18:52:52","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:52:52","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":["8019","DEPOSIT",null,"PAID","2020-06-03 18:52:52",0,"2","2020-06-03 18:52:52","2","2020-06-03 18:52:52"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 18:52:52","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":["8019","INVOICE","8376","PAID","2020-06-03 18:52:52",3615,"2","2020-06-03 18:52:52","2","2020-06-03 18:52:52"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 19:22:00","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1133","master_room_id":"114","room_code":"A05-131"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":741,"customer_code":"C180741","identity_type":"PERSONAL","identity_id":"Z622893(4)","title":"Ms","lastname":"Cheung","firstname":"Yuk Ling","companyname":"","email":"tanyacheung.designer2016@gmail.com","tel":"96363298","address":"Flat F, 19\/F, Coble Court, 129 Main Street, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"2","renew_warehousing_date":"2020-03-29","renew_room_key":"055,40308","renew_remark":"2 months contract. Storage rental paid by bank transfer on March 12, 2020. Storage deposit transferred from agreement A18-CT195636 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207391, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[{"master_room_discount_id":"248","master_room_id":"91","discount_type":"%","price":"1290.00","disocunted_price":"1225.90","discount":"4.97","monthly_deduct":64.113,"room_id":"947","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"947","room_code":"V21","retail_price":"1290.0","discounted_price":1225.9,"location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3870,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-29","rent_from":"2020-03-29","rent_to":"2020-06-28","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on June 3, 2020. Storage deposit transferred from agreement A18-CT207391 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3870,"final_order_total":3870,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,40308","order_product":[],"pass":true}},"first_order_id":"4638","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\tV21 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.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 19:22:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",741,"NEW","A18-CT208048",1290,1290,0,0,"3","3",3870,3870,3870,"2020-06-03 19:22:00","0",null,null,null,"2020-03-29","2020-06-28","3 months contract. Storage rental paid by bank transfer on June 3, 2020. Storage deposit transferred from agreement A18-CT207391 to this agreement.\r\n","2020-03-29","16",0,null,0,"0","2","2020-06-03 19:22:00","2","2020-06-03 19:22:00","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,40308","C180741","PERSONAL","Ms","ZzRtsket6p7WIKEqrfiAQw==","vCxOlXQuvOQaoL822H2o\/Q==","","yDYdX75kPKR4h\/gYs3BYJcJobIZypCc6KDWaulXh9iC7\/8poXjgUbAlck\/ycmA1gcP\/UhsJZyApxazyvlJtyCBK2\/uqGCn9LbAHsuK91+GA=","Na16j9m2d0V89RhVftbEpQ==","plAC52phWS0ywiVvxgdktlSZxJNjClLZggqIQskk\/F01jxqEL1gr\/cVBokSBHyue","+DpQJBg1w6vmawvzQNj5JA==",null,1,"4638"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 19:22:00","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":["8048","248","91","947","%","4.97",64.113,"2","2020-06-03 19:22:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 19:22:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8048","947","1290.0",1225.9,"2","2020-06-03 19:22:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 19:22:00","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-29","2020-06-28","947"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-03 19:22:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8048",741,"SETTLED","A18-I208377","2020-06-03 19:22:00","2020-03-29","2","2020-06-03 19:22:00","2","2020-06-03 19:22:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 19:22:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8377","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-06-03 19:22:00","2","2020-06-03 19:22:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 19:22:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8377","RENT","\u9810\u7e73\u79df\u91d1",2,1290,"MO","1",1290,"2","2020-06-03 19:22:00","2","2020-06-03 19:22:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 19:22:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8377","RENT","\u9810\u7e73\u79df\u91d1",3,1290,"MO","1",1290,"2","2020-06-03 19:22:00","2","2020-06-03 19:22:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 19:22:00","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3870,0,"8377"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-03 19:22:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[741,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208020","2020-06-03 19:22:00",3870,"2","2020-06-03 19:22:00","2","2020-06-03 19:22:00","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 19:22:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8020","DEPOSIT",null,"PAID","2020-06-03 19:22:00",0,"2","2020-06-03 19:22:00","2","2020-06-03 19:22:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-03 19:22:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8020","INVOICE","8377","PAID","2020-06-03 19:22:00",3870,"2","2020-06-03 19:22:00","2","2020-06-03 19:22:00"]},"data_before":[],"data_after":[],"step":1}
*****