\r\n\t\t\t\t\tB63 4X5X8 $1528.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\tB62 4X5X8 $1528.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\tB54 4X5X8 $1528.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\tB53 4X5X8 $1528.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":"80","total_discounted_price":"5098.0","deposit":"0","total_retail_price":"6112.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 10:14:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",392,"NEW","A12-CT207316",6112,5098,0,0,"1","1",5098,5098,5098,"2020-03-04 10:14:41","0",null,null,null,"2020-03-01","2020-03-31","1 month contract. Storage rental paid by PPS on March 4, 2020. Storage deposit transferred from agreement A12-CT207104 to this agreement. \r\n","2020-03-01","80",0,null,0,"0","2","2020-03-04 10:14:40","2","2020-03-04 10:14:40","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"138,17024","C170392","PERSONAL","Mr","BEeVus+G60XJp0DLlFrw5Q==","kiriEIqhcx866RNZiMXdKQ==","","VBX\/XdmRdgqhOmFZK5ALSyxeI8iku\/iH07d+anuZyhubwt\/HaXR\/HjzcA3Wmmw6VBgIGznHH4FxYZNbCfAjNaYs6u2AtWPKHmRXPxCIWvd4=","u2w9koTKJQGsIdFvv8jAeA==","L4egO5Mnnt0ETYeC+58eDoCS0BetZV+b23ZS6nqWBBs=","1A9B3kdXJoFpDPdlSZGM4g==",null,1,"3904"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 10:14:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7316","115","1528.0","1528.00","2","2020-03-04 10:14:40"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 10:14:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-01","2020-03-31","115"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-04 10:14:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7316","114","1528.0","1528.00","2","2020-03-04 10:14:40"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 10:14:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-01","2020-03-31","114"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-04 10:14:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7316","106","1528.0","1528.00","2","2020-03-04 10:14:40"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 10:14:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-01","2020-03-31","106"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-04 10:14:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7316","105","1528.0","1528.00","2","2020-03-04 10:14:40"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 10:14:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-01","2020-03-31","105"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-04 10:14:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7316",392,"SETTLED","A12-I207644","2020-03-04 10:14:40","2020-03-01","2","2020-03-04 10:14:40","2","2020-03-04 10:14:40"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 10:14:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7644","RENT","\u9810\u7e73\u79df\u91d1",1,5098,"MO","1",5098,"2","2020-03-04 10:14:40","2","2020-03-04 10:14:40"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 10:14:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5098,0,"7644"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-04 10:14:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[392,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207292","2020-03-04 10:14:40",5098,"2","2020-03-04 10:14:40","2","2020-03-04 10:14:40","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 10:14:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7292","DEPOSIT",null,"PAID","2020-03-04 10:14:40",0,"2","2020-03-04 10:14:40","2","2020-03-04 10:14:40"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 10:14:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7292","INVOICE","7644","PAID","2020-03-04 10:14:40",5098,"2","2020-03-04 10:14:40","2","2020-03-04 10:14:40"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 10:25:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 10:35:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 10:35:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 10:38: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":"&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1063,"customer_code":"C181063","identity_type":"PERSONAL","identity_id":"P150061(2)","title":"Ms","lastname":"HASKINS","firstname":"Eileen Mary","companyname":"","email":"eimart@netvigator.com","tel":"92769708","address":"House 20A Pok Kok Tsven","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-13","renew_room_key":"'0012435080","renew_remark":"1 month contract. Storage rental paid by bank transfer on February 13, 2020. Storage deposit $2580 transferred from agreement A05-CT206955 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207182, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"114","order_discount":[],"order_room":[{"room_id":"1126","room_code":"A05-124","retail_price":"1290.0","discounted_price":"1290.00","location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1290,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-13","rent_from":"2020-02-13","rent_to":"2020-03-12","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on March 4, 2020. Storage deposit $2580 transferred from agreement A05-CT207182 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0012435080","order_product":[],"pass":true}},"first_order_id":"3560","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-124 4X4X7 $1290.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 10:38:32","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",1063,"NEW","A05-CT207317",1290,1290,0,0,"1","1",1290,1290,1290,"2020-03-04 10:38:32","0",null,null,null,"2020-02-13","2020-03-12","1 month contract. Storage rental paid by bank transfer on March 4, 2020. Storage deposit $2580 transferred from agreement A05-CT207182 to this agreement.\r\n","2020-02-13","16",0,null,0,"0","2","2020-03-04 10:38:32","2","2020-03-04 10:38:32","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0012435080","C181063","PERSONAL","Ms","N2dL4uJnRUVt3pWxZbjoPA==","gBCfCDjxN1soEZ6ASSV8CQ==","","WxFMz3JMJw0zIWOLHcLgDzylG1NdowDT02leCzTzNHk=","9LmyvpD23mCmBchshNAO0w==","WMY4NPSZuxSFljp7Sz0XPINva+8MxbIjoBMZ02LKzdU=","UcXhFM2zM7eIpbzXOGUfvA==",null,1,"3560"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 10:38:32","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":["7317","1126","1290.0","1290.00","2","2020-03-04 10:38:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 10:38:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-13","2020-03-12","1126"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-04 10:38:32","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":["7317",1063,"SETTLED","A05-I207645","2020-03-04 10:38:32","2020-02-13","2","2020-03-04 10:38:32","2","2020-03-04 10:38:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 10:38:32","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":["7645","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-03-04 10:38:32","2","2020-03-04 10:38:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 10:38:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"7645"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-04 10:38:32","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":[1063,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207293","2020-03-04 10:38:32",1290,"2","2020-03-04 10:38:32","2","2020-03-04 10:38:32","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 10:38:32","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":["7293","DEPOSIT",null,"PAID","2020-03-04 10:38:32",0,"2","2020-03-04 10:38:32","2","2020-03-04 10:38:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 10:38:32","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":["7293","INVOICE","7645","PAID","2020-03-04 10:38:32",1290,"2","2020-03-04 10:38:32","2","2020-03-04 10:38:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 10:50:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 10:50:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 10:51:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 10:51:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 11:32:47","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 11:34:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 11:34:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 11:51:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:05:35","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=982&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":755,"customer_code":"C180755","identity_type":"PERSONAL","identity_id":"D674816(4)","title":"Ms","lastname":"Lee","firstname":"Kam Mui","companyname":"","email":null,"tel":"54998807","address":"Flat F, 25\/F, Kam Fat Building, 145 Lee Chi Road, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-06","renew_room_key":"136,32469","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 31, 2020. Storage deposit transferred from agreement A14-CT206876 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\tM39 4X3X4 $598.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":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:05: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",755,"NEW","A14-CT207318",598,598,0,0,"1","1",598,598,598,"2020-03-04 12:05:35","0",null,null,null,"2020-03-06","2020-04-05","1 month contract. Storage rental paid by bank transfer on March 3, 2020. Storage deposit transferred from agreement A14-CT207078 to this agreement.","2020-03-06","12",0,null,0,"0","2","2020-03-04 12:05:35","2","2020-03-04 12:05:35","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,32469","C180755","PERSONAL","Ms","Bz\/rX4ASIpNafqhGM12E+g==","kiriEIqhcx866RNZiMXdKQ==","","J+qxNwNZZDybuSy0bJS1H3QTc7\/evdtOLUtQc4ivvsWPxn+cqVkhkN\/TohPrTXWpxmb7Nhoov\/XjNXxhd0djX6hEDvZ74IuDZYu9myZVwCs=","uTqJ0Kzbi8lcDPgXUMT73Q==",null,"fFKAofifZnWz0Rnx1R5aUA==",null,1,"4693"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:05: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":["7318","628","598.0","598.00","2","2020-03-04 12:05:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:05: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-03-06","2020-04-05","628"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-04 12:05: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":["7318",755,"SETTLED","A14-I207646","2020-03-04 12:05:35","2020-03-06","2","2020-03-04 12:05:35","2","2020-03-04 12:05:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:05: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":["7646","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-03-04 12:05:35","2","2020-03-04 12:05:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:05:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7646"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-04 12:05: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":[755,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207294","2020-03-04 12:05:35",598,"2","2020-03-04 12:05:35","2","2020-03-04 12:05:35","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:05: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":["7294","DEPOSIT",null,"PAID","2020-03-04 12:05:35",0,"2","2020-03-04 12:05:35","2","2020-03-04 12:05:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:05: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":["7294","INVOICE","7646","PAID","2020-03-04 12:05:35",598,"2","2020-03-04 12:05:35","2","2020-03-04 12:05:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:10:28","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:15:32","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=982&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","warehousing":{"2":{"order_discount":[],"order_room":[{"room_id":"968","room_code":"W13","retail_price":"2434.0","discounted_price":"2434.00","location_id":"3"},{"room_id":"967","room_code":"W12","retail_price":"2434.0","discounted_price":"2434.00","location_id":"3"},{"room_id":"965","room_code":"W10","retail_price":"3033.0","discounted_price":"3033.00","location_id":"3"}],"roughly_size":"104","total_retail_price":7901,"total_discounted_price":7264,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":87168,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-11","rent_from":"2020-03-11","rent_to":"2021-03-10","delivery_service":"0","remark":"12 months contract. Storage rental paid by cheque. Storage deposit transferred from agreement A18-CT194857 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":87168,"final_order_total":87168,"location_id":"3","branch_id":"1","company_id":"1","room_key":"188,64602","order_product":[],"pass":true,"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"7264.0","renew_rent_month":"12","renew_warehousing_date":"2020-03-11","renew_room_key":"188,64602","renew_remark":"12 months contract. Part of storage rental paid by bank transfer on ($23001) March 8, 2019, ($16000) March 18, 2019 and ($48167) on April 11, 2019. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT194857, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $16142.0","renew_master_room_id":"99"},"1":{"new_customer":0,"customer_id":1215,"customer_code":"C191215","identity_type":"BUSINESS","identity_id":"NIL","title":"Ms","lastname":"Cheng","firstname":"Rebekah","companyname":"Consulate General of the State of Kuwait","email":"kuconshk@netvigator.com","tel":"28327866","address":"Unit 2, 45\/F, Office Tower, Convention Plaza, 1 Harbour Road, Wanchai, Hong Kong","pass":true}},"renew":1,"first_order_id":4857,"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\tW13 8X4X7 $2434.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\tW12 8X4X7 $2434.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\tW10 5X8X7 $3033.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":"104","total_discounted_price":"7264.0","deposit":"0","total_retail_price":"7901.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:15:32","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",1215,"NEW","A18-CT207319",7901,7264,0,0,"12","12",87168,87168,87168,"2020-03-04 12:15:32","0",null,null,null,"2020-03-11","2021-03-10","12 months contract. Storage rental paid by cheque. Storage deposit transferred from agreement A18-CT194857 to this agreement.","2020-03-11","104",0,null,0,"0","2","2020-03-04 12:15:32","2","2020-03-04 12:15:32","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"188,64602","C191215","BUSINESS","Ms","UROt7CAnuITigow4H3WDcw==","UCPBCXrBLI9U7KKsPqgmNA==","Consulate General of the State of Kuwait","ok6xPSmFt23M\/3JkLdIf1oeVOfTkkx\/EEoMn0G8sSjRUsK32Wxb+oynSxBddIi8uQLqm48HnJT8cYU6N3vQN2qKog3XXRQI\/GCsbtm3LR5PgOSuMttJ3Vzzgg9Rh6h53","tRTzj7FNT\/IU4l684mWE1g==","ULwNQb\/P1gldudIinN0uXPec+2Jt7qTayLdxNi8lyOg=",null,"EJK4UaCQEL3EvTMZxUgDvg==",1,4857]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:15:32","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":["7319","968","2434.0","2434.00","2","2020-03-04 12:15:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:15:32","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-11","2021-03-10","968"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-04 12:15:32","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":["7319","967","2434.0","2434.00","2","2020-03-04 12:15:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:15:32","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-11","2021-03-10","967"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-04 12:15:32","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":["7319","965","3033.0","3033.00","2","2020-03-04 12:15:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:15:32","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-11","2021-03-10","965"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-04 12:15:32","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":["7319",1215,"SETTLED","A18-I207647","2020-03-04 12:15:32","2020-03-11","2","2020-03-04 12:15:32","2","2020-03-04 12:15:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:15:32","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":["7647","RENT","\u9810\u7e73\u79df\u91d1",1,7264,"MO","1",7264,"2","2020-03-04 12:15:32","2","2020-03-04 12:15:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:15:32","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":["7647","RENT","\u9810\u7e73\u79df\u91d1",2,7264,"MO","1",7264,"2","2020-03-04 12:15:32","2","2020-03-04 12:15:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:15:32","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":["7647","RENT","\u9810\u7e73\u79df\u91d1",3,7264,"MO","1",7264,"2","2020-03-04 12:15:32","2","2020-03-04 12:15:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:15:32","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":["7647","RENT","\u9810\u7e73\u79df\u91d1",4,7264,"MO","1",7264,"2","2020-03-04 12:15:32","2","2020-03-04 12:15:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:15:32","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":["7647","RENT","\u9810\u7e73\u79df\u91d1",5,7264,"MO","1",7264,"2","2020-03-04 12:15:32","2","2020-03-04 12:15:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:15:32","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":["7647","RENT","\u9810\u7e73\u79df\u91d1",6,7264,"MO","1",7264,"2","2020-03-04 12:15:32","2","2020-03-04 12:15:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:15:32","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":["7647","RENT","\u9810\u7e73\u79df\u91d1",7,7264,"MO","1",7264,"2","2020-03-04 12:15:32","2","2020-03-04 12:15:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:15:32","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":["7647","RENT","\u9810\u7e73\u79df\u91d1",8,7264,"MO","1",7264,"2","2020-03-04 12:15:32","2","2020-03-04 12:15:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:15:32","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":["7647","RENT","\u9810\u7e73\u79df\u91d1",9,7264,"MO","1",7264,"2","2020-03-04 12:15:32","2","2020-03-04 12:15:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:15:32","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":["7647","RENT","\u9810\u7e73\u79df\u91d1",10,7264,"MO","1",7264,"2","2020-03-04 12:15:32","2","2020-03-04 12:15:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:15:32","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":["7647","RENT","\u9810\u7e73\u79df\u91d1",11,7264,"MO","1",7264,"2","2020-03-04 12:15:32","2","2020-03-04 12:15:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:15:32","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":["7647","RENT","\u9810\u7e73\u79df\u91d1",12,7264,"MO","1",7264,"2","2020-03-04 12:15:32","2","2020-03-04 12:15:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:15:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[87168,0,"7647"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-04 12:15:32","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":[1215,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207295","2020-03-04 12:15:32",87168,"2","2020-03-04 12:15:32","2","2020-03-04 12:15:32","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:15:32","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":["7295","DEPOSIT",null,"PAID","2020-03-04 12:15:32",0,"2","2020-03-04 12:15:32","2","2020-03-04 12:15:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 12:15:32","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":["7295","INVOICE","7647","PAID","2020-03-04 12:15:32",87168,"2","2020-03-04 12:15:32","2","2020-03-04 12:15:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 13:28:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 16:44:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 16:55:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 16:59:25","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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":249,"customer_code":"C160249","identity_type":"PERSONAL","identity_id":"D102452(4)","title":"Ms","lastname":"Tsao","firstname":"Wai Yin","companyname":"","email":null,"tel":"95719208","address":"\u9999\u6e2f\u9d28\u8137\u6d32\u6d77\u6021\u534a\u5cf6\uff0b\u4e09\u5ea7\u4e8c\uff0b\u4e94\u6a13F\u5ba4","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1139.0","renew_rent_month":"12","renew_warehousing_date":"2020-03-02","renew_room_key":"055,03673","renew_remark":"12 months contract. Storage rental paid by cheque on Feb 27, 2019. Storage deposit transferred from agreement A12-CT183033 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT194455, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[{"master_room_discount_id":"77","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1271.00","discount":"16.82","monthly_deduct":257.0096,"room_id":"63","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"63","room_code":"B11","retail_price":"1528.0","discounted_price":1271,"location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1139,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":13668,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-02","rent_from":"2020-03-02","rent_to":"2021-03-01","delivery_service":"0","remark":"12 months contract. Storage rental paid by cheque on Mar 4, 2020. Storage deposit transferred from agreement A12-CT194455 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":13668,"final_order_total":13668,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,03673","order_product":[],"pass":true}},"first_order_id":4455,"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\tB11 4X5X8 $1528.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":"20","total_discounted_price":"1139.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 16:59:25","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",249,"NEW","A12-CT207320",1528,1139,0,0,"12","12",13668,13668,13668,"2020-03-04 16:59:25","0",null,null,null,"2020-03-02","2021-03-01","12 months contract. Storage rental paid by cheque on Mar 4, 2020. Storage deposit transferred from agreement A12-CT194455 to this agreement.\r\n","2020-03-02","20",0,null,0,"0","2","2020-03-04 16:59:25","2","2020-03-04 16:59:25","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"055,03673","C160249","PERSONAL","Ms","eYp7wkZVr\/ESATj9g0Yeww==","PfVsMI23M5\/xFC1FQxJikg==","","kPp6q6TlAQRNluMi8NITvvYlNcl6YYecoPAE3kjt3\/CTYBga43+HFQ\/0+sFGgZpfeQYk2UhHKlzI+Ta0\/EX6kQ==","5H1ciwQuMFZsM3TYI47ILA==",null,"iueUsU1z6hIzxIWqeYILRQ==",null,1,4455]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 16:59:25","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":["7320","77","10","63","%","16.82",257.0096,"2","2020-03-04 16:59:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 16:59:25","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":["7320","63","1528.0",1271,"2","2020-03-04 16:59:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 16:59:25","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-02","2021-03-01","63"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-04 16:59:25","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":["7320",249,"SETTLED","A12-I207648","2020-03-04 16:59:25","2020-03-02","2","2020-03-04 16:59:25","2","2020-03-04 16:59:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 16:59:25","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":["7648","RENT","\u9810\u7e73\u79df\u91d1",1,1139,"MO","1",1139,"2","2020-03-04 16:59:25","2","2020-03-04 16:59:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 16:59:25","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":["7648","RENT","\u9810\u7e73\u79df\u91d1",2,1139,"MO","1",1139,"2","2020-03-04 16:59:25","2","2020-03-04 16:59:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 16:59:25","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":["7648","RENT","\u9810\u7e73\u79df\u91d1",3,1139,"MO","1",1139,"2","2020-03-04 16:59:25","2","2020-03-04 16:59:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 16:59:25","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":["7648","RENT","\u9810\u7e73\u79df\u91d1",4,1139,"MO","1",1139,"2","2020-03-04 16:59:25","2","2020-03-04 16:59:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 16:59:25","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":["7648","RENT","\u9810\u7e73\u79df\u91d1",5,1139,"MO","1",1139,"2","2020-03-04 16:59:25","2","2020-03-04 16:59:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 16:59:25","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":["7648","RENT","\u9810\u7e73\u79df\u91d1",6,1139,"MO","1",1139,"2","2020-03-04 16:59:25","2","2020-03-04 16:59:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 16:59:25","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":["7648","RENT","\u9810\u7e73\u79df\u91d1",7,1139,"MO","1",1139,"2","2020-03-04 16:59:25","2","2020-03-04 16:59:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 16:59:25","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":["7648","RENT","\u9810\u7e73\u79df\u91d1",8,1139,"MO","1",1139,"2","2020-03-04 16:59:25","2","2020-03-04 16:59:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 16:59:25","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":["7648","RENT","\u9810\u7e73\u79df\u91d1",9,1139,"MO","1",1139,"2","2020-03-04 16:59:25","2","2020-03-04 16:59:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 16:59:25","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":["7648","RENT","\u9810\u7e73\u79df\u91d1",10,1139,"MO","1",1139,"2","2020-03-04 16:59:25","2","2020-03-04 16:59:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 16:59:25","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":["7648","RENT","\u9810\u7e73\u79df\u91d1",11,1139,"MO","1",1139,"2","2020-03-04 16:59:25","2","2020-03-04 16:59:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 16:59:25","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":["7648","RENT","\u9810\u7e73\u79df\u91d1",12,1139,"MO","1",1139,"2","2020-03-04 16:59:25","2","2020-03-04 16:59:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 16:59:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13668,0,"7648"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-04 16:59:25","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":[249,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207296","2020-03-04 16:59:25",13668,"2","2020-03-04 16:59:25","2","2020-03-04 16:59:25","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 16:59:25","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":["7296","DEPOSIT",null,"PAID","2020-03-04 16:59:25",0,"2","2020-03-04 16:59:25","2","2020-03-04 16:59:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 16:59:25","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":["7296","INVOICE","7648","PAID","2020-03-04 16:59:25",13668,"2","2020-03-04 16:59:25","2","2020-03-04 16:59:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 17:18:45","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:49:45","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1328&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","warehousing":{"1":{"new_customer":0,"identity_type":"PERSONAL","identity_id":"E819548(3)","title":"Mr","lastname":"CHEUNG","firstname":"TAT HANGS","companyname":"","email":"thcheung888@hotmail.com","tel":"61983103","address":"FLAT D, 20\/F, Tower A, Hollywood Terrace, 268 Queen's Road, Central, HK","pass":true,"customer_id":1198,"customer_code":"C191198","customer_first_order":false},"2":{"order_discount":[],"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"729.0","renew_rent_month":"13","renew_warehousing_date":"2020-03-13","renew_room_key":"0012385365","renew_remark":"13 months contract, replace contract C15-CT194322. Storage deposit $935 transferred from C15-CT194322.\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> \r\n\t\t\t\t\tC15-016 4X3X6.5 $810.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":"713.00","deposit":"0.00","total_retail_price":"810.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:49:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1198,"NEW","C15-CT207321",810,713,0,0,"12","12",8556,8556,8556,"2020-03-04 18:49:46","0",null,null,null,"2020-03-13","2021-03-12","12 months contract, Storage rental paid by bank transfer on March 4, 2020. Storage deposit transferred from C15-CT194336 to this agreement.\r\n","2020-03-13","12",0,null,0,"0","2","2020-03-04 18:49:45","2","2020-03-04 18:49:45","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012385365","C191198","PERSONAL","Mr","aoif98WXGg69q9tqSJEpOg==","ts1WQ6NWxfSAyKGz8YWojw==","","AFYz27f6+fbr2x8nolJR1ciGViPppX8JfN50eAT4LyYkmxBPZ0T3ddB2lnqDWRmjSY4KfIosPMv9riSek\/8wFG\/tax4+R2e4OZKCTTjoP+w=","gdBE4a3ag+29Q+tj2wOxXQ==","Qn2df0BC6sxl2qAyAmCVOHx2Rud1fKa4hCXNJBJOCac=","Xd1OJ0r0lfn5gCEnvgpYDg==",null,1,4336]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:49:46","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":["7321","1322","810.0","810.00","2","2020-03-04 18:49:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:49:46","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-13","2021-03-12","1322"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-04 18:49:46","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":["7321",1198,"SETTLED","C15-I207649","2020-03-04 18:49:45","2020-03-13","2","2020-03-04 18:49:45","2","2020-03-04 18:49:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:49:46","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":["7649","RENT","\u9810\u7e73\u79df\u91d1",1,713,"MO","1",713,"2","2020-03-04 18:49:45","2","2020-03-04 18:49:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:49:46","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":["7649","RENT","\u9810\u7e73\u79df\u91d1",2,713,"MO","1",713,"2","2020-03-04 18:49:45","2","2020-03-04 18:49:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:49:46","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":["7649","RENT","\u9810\u7e73\u79df\u91d1",3,713,"MO","1",713,"2","2020-03-04 18:49:45","2","2020-03-04 18:49:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:49:46","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":["7649","RENT","\u9810\u7e73\u79df\u91d1",4,713,"MO","1",713,"2","2020-03-04 18:49:45","2","2020-03-04 18:49:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:49:46","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":["7649","RENT","\u9810\u7e73\u79df\u91d1",5,713,"MO","1",713,"2","2020-03-04 18:49:45","2","2020-03-04 18:49:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:49:46","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":["7649","RENT","\u9810\u7e73\u79df\u91d1",6,713,"MO","1",713,"2","2020-03-04 18:49:45","2","2020-03-04 18:49:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:49:46","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":["7649","RENT","\u9810\u7e73\u79df\u91d1",7,713,"MO","1",713,"2","2020-03-04 18:49:45","2","2020-03-04 18:49:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:49:46","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":["7649","RENT","\u9810\u7e73\u79df\u91d1",8,713,"MO","1",713,"2","2020-03-04 18:49:45","2","2020-03-04 18:49:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:49:46","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":["7649","RENT","\u9810\u7e73\u79df\u91d1",9,713,"MO","1",713,"2","2020-03-04 18:49:45","2","2020-03-04 18:49:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:49:46","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":["7649","RENT","\u9810\u7e73\u79df\u91d1",10,713,"MO","1",713,"2","2020-03-04 18:49:45","2","2020-03-04 18:49:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:49:46","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":["7649","RENT","\u9810\u7e73\u79df\u91d1",11,713,"MO","1",713,"2","2020-03-04 18:49:45","2","2020-03-04 18:49:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:49:46","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":["7649","RENT","\u9810\u7e73\u79df\u91d1",12,713,"MO","1",713,"2","2020-03-04 18:49:45","2","2020-03-04 18:49:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:49:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8556,0,"7649"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-04 18:49:46","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":[1198,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207297","2020-03-04 18:49:45",8556,"2","2020-03-04 18:49:45","2","2020-03-04 18:49:45","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:49:46","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":["7297","DEPOSIT",null,"PAID","2020-03-04 18:49:45",0,"2","2020-03-04 18:49:45","2","2020-03-04 18:49:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:49:46","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":["7297","INVOICE","7649","PAID","2020-03-04 18:49:45",8556,"2","2020-03-04 18:49:45","2","2020-03-04 18:49:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:56:27","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1328&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1217,"customer_code":"C191217","identity_type":"PERSONAL","identity_id":"D447759(7)","title":"Ms","lastname":"HUI","firstname":"Mei Ying","companyname":"","email":"florahui23@gmail.com","tel":"91760388","address":"21B, Kam Fat Bldg, 145 Lee Chi Rd, Apleichau, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-14","renew_room_key":"'0006047753","renew_remark":"1 month contract. Storage rental paid by bank transfer on February 3, 2020. Storage deposit $2580 transferred from agreement A05-CT206858 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207097, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"114","order_discount":[],"order_room":[{"room_id":"1010","room_code":"A05-008","retail_price":"1290.0","discounted_price":"1290.00","location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1290,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-14","rent_from":"2020-03-14","rent_to":"2020-04-13","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on March 4, 2020. Storage deposit transferred from agreement A05-CT207097 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0006047753","order_product":[],"pass":true}},"first_order_id":"4509","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-008 4X4X7 $1290.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:56:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1217,"NEW","A05-CT207322",1290,1290,0,0,"1","1",1290,1290,1290,"2020-03-04 18:56:27","0",null,null,null,"2020-03-14","2020-04-13","1 month contract. Storage rental paid by bank transfer on March 4, 2020. Storage deposit transferred from agreement A05-CT207097 to this agreement.","2020-03-14","16",0,null,0,"0","2","2020-03-04 18:56:27","2","2020-03-04 18:56:27","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0006047753","C191217","PERSONAL","Ms","itB3q7EVO34a2hxkwiPhKw==","SLPJ+c2smshjwdK17xoj0w==","","ueCxoUZm7SuNCZWvZfej2KDREwW7lwoKDTTNZzTAoaO5sqnLfLBRCkfNGM8f7yinGogt7bT6sVG5LxuicUK9\/w==","6zI+PZPtByw9BmzFx6tCzA==","YTLujwAtYb1\/RI+1mL1DaVX7TvWW5ErARjMcxpk9WYA=","vm7DP84yeg7qminXe9MP\/Q==",null,1,"4509"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:56:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7322","1010","1290.0","1290.00","2","2020-03-04 18:56:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:56:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-14","2020-04-13","1010"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-04 18:56:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7322",1217,"SETTLED","A05-I207650","2020-03-04 18:56:27","2020-03-14","2","2020-03-04 18:56:27","2","2020-03-04 18:56:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:56:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7650","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-03-04 18:56:27","2","2020-03-04 18:56:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:56:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"7650"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-04 18:56:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1217,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207298","2020-03-04 18:56:27",1290,"2","2020-03-04 18:56:27","2","2020-03-04 18:56:27","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:56:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7298","DEPOSIT",null,"PAID","2020-03-04 18:56:27",0,"2","2020-03-04 18:56:27","2","2020-03-04 18:56:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 18:56:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7298","INVOICE","7650","PAID","2020-03-04 18:56:27",1290,"2","2020-03-04 18:56:27","2","2020-03-04 18:56:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 19:00:25","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1328&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":724,"customer_code":"C180724","identity_type":"PERSONAL","identity_id":"D488390(0)","title":"Mr","lastname":"Chan","firstname":"Kai Ming Johnny","companyname":"","email":"ckmjohnny@gmail.com","tel":"92855920","address":"Room 922, Wah Cheong House, Wah Fu Estate, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2058.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-05","renew_room_key":"054,32853","renew_remark":"1 month contract. Storage rental paid by PPS on February 3, 2020. Storage deposit transferred from agreement A12-CT206862 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\tF06 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\tF17 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":"28","total_discounted_price":"2058.0","deposit":"0","total_retail_price":"2096.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 19:00:26","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",724,"NEW","A12-CT207323",2096,2058,0,0,"1","1",2058,2058,2058,"2020-03-04 19:00:26","0",null,null,null,"2020-03-05","2020-04-04","1 month contract. Storage rental paid by PPS on February 3, 2020. Storage deposit transferred from agreement A12-CT207092 to this agreement.\r\n","2020-03-05","28",0,null,0,"0","2","2020-03-04 19:00:25","2","2020-03-04 19:00:25","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,32853","C180724","PERSONAL","Mr","S2Y\/+hrua6snugCiRVXC+g==","U9yoE9KqV1v8YlRkf7Q2yg==","","k+e0QYxm9l5HuoQuXakgBNnw8UW4n+ZLcCG9eEWYCG3GGUVs8OcyHqJxZXBRIAQ7e4G25Jwv46TjFMKIeqmD6Q==","uIJTfVK37Ukw\/PebwnT1DA==","HVGIbYlde5F3OKyLRPpR9QsuoR+xNkr5wlpbBQugV6E=","tHG2eMtIkTmRjccZ2JJ3PQ==",null,1,"4888"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 19:00:26","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":["7323","321","998.0","998.00","2","2020-03-04 19:00:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 19:00:26","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-05","2020-04-04","321"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-04 19:00:26","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":["7323","332","1098.0","1098.00","2","2020-03-04 19:00:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 19:00:26","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-05","2020-04-04","332"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-04 19:00:26","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":["7323",724,"SETTLED","A12-I207651","2020-03-04 19:00:25","2020-03-05","2","2020-03-04 19:00:25","2","2020-03-04 19:00:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 19:00:26","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":["7651","RENT","\u9810\u7e73\u79df\u91d1",1,2058,"MO","1",2058,"2","2020-03-04 19:00:25","2","2020-03-04 19:00:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 19:00:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2058,0,"7651"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-04 19:00:26","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":[724,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207299","2020-03-04 19:00:25",2058,"2","2020-03-04 19:00:25","2","2020-03-04 19:00:25","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 19:00:26","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":["7299","DEPOSIT",null,"PAID","2020-03-04 19:00:25",0,"2","2020-03-04 19:00:25","2","2020-03-04 19:00:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-04 19:00:26","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":["7299","INVOICE","7651","PAID","2020-03-04 19:00:25",2058,"2","2020-03-04 19:00:25","2","2020-03-04 19:00:25"]},"data_before":[],"data_after":[],"step":1}
*****