\r\n\t\t\t\t\tA05-155(\u670d\u88dd\u5009) 4X4X7 $1410.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":"1410.00","deposit":"0.00","total_retail_price":"1410.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:04:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1195,"NEW","A05-CT207997",1410,1410,0,0,"1","1",1410,1410,1410,"2020-06-01 10:04:42","0",null,null,null,"2020-04-04","2020-05-03","1 month contract. Storage rental paid by bank transfer on May 31, 2020. Storage deposit $2820 transferred from A05-CT207485 to this agreement.\r\n","2020-04-04","16",0,null,0,"0","2","2020-06-01 10:04:42","2","2020-06-01 10:04:42","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0012521494","C191195","PERSONAL","Ms","cSUqGWHC\/68ybP6W2f0HTeRI19xTcRSN4KHdd8lUrrE=","oe4emdjBwqJ3qUpOcI17hw==","","MJ8n0gP4JnU1c+J2pyaIIc4+mrmiGDDBfqYqYpTFaH8LTSnfnqQz2H9kTfGN9ykw9wgD8Hp63MeJR7IghtRlXQ==","HBKEeOOgSr3ILC7RQLlL1w==","PdyUwKPQexO32ZMwf1ZZORvOARdYMIXK7XwrqBcoZtM=","N3OcSFA9W1M\/ULEzkfIyGQ==",null,1,"4292"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:04:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7997","1157","1410.0","1410.00","2","2020-06-01 10:04:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:04:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-04","2020-05-03","1157"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-01 10:04: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":["7997",1195,"SETTLED","A05-I208326","2020-06-01 10:04:42","2020-04-04","2","2020-06-01 10:04:42","2","2020-06-01 10:04:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:04: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":["8326","RENT","\u9810\u7e73\u79df\u91d1",1,1410,"MO","1",1410,"2","2020-06-01 10:04:42","2","2020-06-01 10:04:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:04:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1410,0,"8326"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-01 10:04: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":[1195,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207970","2020-06-01 10:04:42",1410,"2","2020-06-01 10:04:42","2","2020-06-01 10:04:42","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:04: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":["7970","DEPOSIT",null,"PAID","2020-06-01 10:04:42",0,"2","2020-06-01 10:04:42","2","2020-06-01 10:04:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:04: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":["7970","INVOICE","8326","PAID","2020-06-01 10:04:42",1410,"2","2020-06-01 10:04:42","2","2020-06-01 10:04:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:08:08","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1597","master_room_id":"202","room_code":"A16-106"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":717,"customer_code":"C180717","identity_type":"PERSONAL","identity_id":"Y323150(8)","title":"Mr","lastname":"Amerine","firstname":"Julian Steven Anthony","companyname":"","email":"julian.amerine@gmail.com","tel":"97302001","address":"Flat 503, Wah Oi House, Wah Kwai Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1605.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-14","renew_room_key":"055,16508","renew_remark":"1 month contract. Storage rental paid by bank transfer on April 26, 2020. Storage deposit transferred from agreement A18-CT207516 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\tU05 4X5X7 $1605.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":"20","total_discounted_price":"1605.0","deposit":"0","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:08: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",717,"NEW","A18-CT207998",1605,1605,0,0,"1","1",1605,1605,1605,"2020-06-01 10:08:09","0",null,null,null,"2020-05-14","2020-06-13","1 month contract. Storage rental paid by bank transfer on May 31, 2020. Storage deposit transferred from agreement A18-CT207727 to this agreement.\r\n","2020-05-14","20",0,null,0,"0","2","2020-06-01 10:08:08","2","2020-06-01 10:08:08","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,16508","C180717","PERSONAL","Mr","ilVMtNKmhMv6VE7c5KYxeztG+MwYykSvCMt0zdIzHQ8=","jMvdnb6vnm7OQ3LZeY9TvA==","","tbf9qMYQ0X2kmdqBrxFeo3U2\/AVNuE51tDZAfcqBDrxcDLMrKjPy\/OI6UJNDPcMlekQpWPiGcb3Vf3oPzlvW8g==","mgiBsvordu5SgovUygNEdQ==","oplb81J2vLHxZ4GCh7eLLYvnbYcLrPelLzmcVjcZCTA=","o+ttpCoGmWwr+zclHXAYFQ==",null,1,"4839"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:08: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":["7998","904","1605.0","1605.00","2","2020-06-01 10:08:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:08: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-05-14","2020-06-13","904"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-01 10:08: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":["7998",717,"SETTLED","A18-I208327","2020-06-01 10:08:08","2020-05-14","2","2020-06-01 10:08:08","2","2020-06-01 10:08:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:08: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":["8327","RENT","\u9810\u7e73\u79df\u91d1",1,1605,"MO","1",1605,"2","2020-06-01 10:08:08","2","2020-06-01 10:08:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:08:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1605,0,"8327"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-01 10:08: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":[717,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207971","2020-06-01 10:08:08",1605,"2","2020-06-01 10:08:08","2","2020-06-01 10:08:08","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:08: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":["7971","DEPOSIT",null,"PAID","2020-06-01 10:08:08",0,"2","2020-06-01 10:08:08","2","2020-06-01 10:08:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:08: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":["7971","INVOICE","8327","PAID","2020-06-01 10:08:08",1605,"2","2020-06-01 10:08:08","2","2020-06-01 10:08:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:14:14","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1207","master_room_id":"140","room_code":"B01-017"},{"room_id":"1208","master_room_id":"140","room_code":"B01-018"}],"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\tB01-017 4X4X7 $1112.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\tB01-018 4X4X7 $1112.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":"0","identity_type":"PERSONAL","identity_id":"D557515(0)","title":"Ms","lastname":"CHAN","firstname":"Tsui Ping","companyname":"","email":"","tel":"93059121","address":"Flat E, 21\/F, Block 2, Cheerful Garden, Siu Sai Wan, Hong Kong","pass":true,"customer_id":"1598","customer_code":"C201598","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"314","master_room_id":"140","discount_type":"%","price":"1112.00","disocunted_price":"1057.00","discount":"4.95","monthly_deduct":55.044,"room_id":"1208","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"314","master_room_id":"140","discount_type":"%","price":"1112.00","disocunted_price":"1057.00","discount":"4.95","monthly_deduct":55.044,"room_id":"1207","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1207","room_code":"B01-017","retail_price":"1112.0","discounted_price":1057,"location_id":"5"},{"room_id":"1208","room_code":"B01-018","retail_price":"1112.0","discounted_price":1057,"location_id":"5"}],"roughly_size":"32","total_retail_price":2224,"total_discounted_price":1978,"deposit":3956,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":6923,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2967.00","warehousing_date":"2020-06-01","rent_from":"2020-06-01","rent_to":"2020-08-31","delivery_service":"0","remark":"3 months contract. Special offer first 3 months 50% off. Storage rental and deposit $4893 paid by bank transfer on May 29, 2020. Remaining balance $2090 paid by bank transfer on May 31, 2020. Smartcard mails on May 29, 2020. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":2967,"order_total":9950,"final_order_total":6983,"location_id":"5","branch_id":"2","company_id":"1","room_key":"'0012415117","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"pass":true}},"roughly_size":"32","total_discounted_price":"1978.00","deposit":"3956.00","total_retail_price":"2224.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:14: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","2","5","1598","NEW","B01-CT207999",2224,1978,3956,0,"3","3",6923,9950,6983,"2020-06-01 10:14:14","0",null,null,null,"2020-06-01","2020-08-31","3 months contract. Special offer first 3 months 50% off. Storage rental and deposit $4893 paid by bank transfer on May 29, 2020. Remaining balance $2090 paid by bank transfer on May 31, 2020. Smartcard mails on May 29, 2020. ","2020-06-01","32",0,null,2967,"2967.00","2","2020-06-01 10:14:14","2","2020-06-01 10:14:14","BANKIN","","","","BANKIN","","","",null,0,"'0012415117","C201598","PERSONAL","Ms","vXGdTNy9LvwX04wnIqWpkA==","8BEgNhGpCR8jGkzUtrIcXg==","","raL9mQIdPGGwWsIuGBAHNmPBT8S4upMWPFVQNnXp0GCnN1LtR+CcK0yT2TbpMBlszikNQTVbrVF\/Fs5dqIAKNQ==","PZmnfiJYWeWxoAH0DzfB+g==",null,"L3GdH0wCX1Q8+8ucB43nlw==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:14:14","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":["7999","314","140","1208","%","4.95",55.044,"2","2020-06-01 10:14:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:14:14","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":["7999","314","140","1207","%","4.95",55.044,"2","2020-06-01 10:14:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:14:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7999","1598","11","1","60.0",60,"2","2020-06-01 10:14:14","2","2020-06-01 10:14:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:14:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"7999"]},"data_before":[],"data_after":[],"step":4}
*****
{"created_at":"2020-06-01 10:14: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":["7999","1207","1112.0",1057,"2","2020-06-01 10:14:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:14: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-01","2020-08-31","1207"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-01 10:14: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":["7999","1208","1112.0",1057,"2","2020-06-01 10:14:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:14: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-01","2020-08-31","1208"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-01 10:14: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":["7999","B01-D205442","PAID",3956,0,"2020-08-31","2020-06-01 10:14:14","2020-06-01 10:14:14","2","2020-06-01 10:14:14","2","2020-06-01 10:14:14","1598"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:14: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":["7999","1598","SETTLED","B01-I208328","2020-06-01 10:14:14","2020-06-01","2","2020-06-01 10:14:14","2","2020-06-01 10:14:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:14: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":["8328","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-01 10:14:14","2","2020-06-01 10:14:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:14: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":["8328","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,989,"MO","1",989,"2","2020-06-01 10:14:14","2","2020-06-01 10:14:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:14: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":["8328","RENT","\u9810\u7e73\u79df\u91d1",3,1978,"MO","1",1978,"2","2020-06-01 10:14:14","2","2020-06-01 10:14:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:14:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8328","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-06-01 10:14:14","2","2020-06-01 10:14:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:14:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3027,0,"8328"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-01 10:14:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1598","BANKIN","","","","BANKIN","","","","PAID","P207972","2020-06-01 10:14:14",6983,"2","2020-06-01 10:14:14","2","2020-06-01 10:14:14","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:14:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7972","DEPOSIT","5442","PAID","2020-06-01 10:14:14",3956,"2","2020-06-01 10:14:14","2","2020-06-01 10:14:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:14:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7972","INVOICE","8328","PAID","2020-06-01 10:14:14",3027,"2","2020-06-01 10:14:14","2","2020-06-01 10:14:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:16:47","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&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1207","master_room_id":"140","room_code":"B01-017"},{"room_id":"1208","master_room_id":"140","room_code":"B01-018"}],"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-06-06","renew_room_key":"136,32469","renew_remark":"1 month contract. Storage rental paid by bank transfer on April 30, 2020. Storage deposit transferred from agreement A14-CT207568 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-06-01 10:16: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","2",755,"NEW","A14-CT208000",598,598,0,0,"1","1",598,598,598,"2020-06-01 10:16:48","0",null,null,null,"2020-06-06","2020-07-05","1 month contract. Storage rental paid by bank transfer on May 31, 2020. Storage deposit transferred from agreement A14-CT207753 to this agreement.\r\n","2020-06-06","12",0,null,0,"0","2","2020-06-01 10:16:47","2","2020-06-01 10:16:47","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-06-01 10:16: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":["8000","628","598.0","598.00","2","2020-06-01 10:16:47"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:16: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-06","2020-07-05","628"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-01 10:16: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":["8000",755,"SETTLED","A14-I208329","2020-06-01 10:16:47","2020-06-06","2","2020-06-01 10:16:47","2","2020-06-01 10:16:47"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:16: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":["8329","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-06-01 10:16:47","2","2020-06-01 10:16:47"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:16:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8329"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-01 10:16: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":[755,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207973","2020-06-01 10:16:47",598,"2","2020-06-01 10:16:47","2","2020-06-01 10:16:47","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:16: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":["7973","DEPOSIT",null,"PAID","2020-06-01 10:16:47",0,"2","2020-06-01 10:16:47","2","2020-06-01 10:16:47"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:16: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":["7973","INVOICE","8329","PAID","2020-06-01 10:16:47",598,"2","2020-06-01 10:16:47","2","2020-06-01 10:16:47"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:37:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:44:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:56:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:58:05","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1058,"customer_code":"C181058","identity_type":"PERSONAL","identity_id":"E794015(0)","title":"Mr","lastname":"Lee","firstname":"Wah Tong","companyname":"","email":"alfredwtlee@hotmail.com","tel":"94163813","address":"Rm 6, 22\/F ,Kong Shing Court, Aberdeen Centre, Aberdeen","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1445.0","renew_rent_month":"6","renew_warehousing_date":"2020-06-01","renew_room_key":"0006005424","renew_remark":"6 months contract, storage rental paid by EPS on November 29, 2019. Storage rental $3210 transferred from agreement A05-CT183554 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-048 4X5X7 $1605.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":"20","total_discounted_price":"1445.0","deposit":"0","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:58:05","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",1058,"NEW","A05-CT208001",1605,1445,0,0,"6","6",8670,8670,8670,"2020-06-01 10:58:05","0",null,null,null,"2020-06-01","2020-11-30","6 months contract, storage rental paid by cheque on June 1, 2020. Storage rental $3210 transferred from agreement A05-CT196545 to this agreement. \r\n","2020-06-01","20",0,null,0,"0","2","2020-06-01 10:58:05","2","2020-06-01 10:58:05","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"0006005424","C181058","PERSONAL","Mr","G\/DG91wr5I0UqfEbzF0YlA==","kiriEIqhcx866RNZiMXdKQ==","","QUmMn0UvFlJGGoKkbBn4\/G3M0w5bjYS5yrWcWVcPB9h4Ddf0P7CciyUdmd0UQp34PVlrkZIznM0cEFKWl5QQlw==","jMJjrFW6FIU89qFvAy2kNQ==","oLnBlMmV9jWlahwHMt1AwKBdnahNe843BDRE7Va\/foM=","7Seq\/9le9FLyaCz929ICjg==",null,1,"3554"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:58:05","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":["8001","255","116","1050","%","10.00",160.5,"2","2020-06-01 10:58:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:58:05","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":["8001","1050","1605.0",1444.5,"2","2020-06-01 10:58:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:58:05","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","1050"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-01 10:58:05","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":["8001",1058,"SETTLED","A05-I208330","2020-06-01 10:58:05","2020-06-01","2","2020-06-01 10:58:05","2","2020-06-01 10:58:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:58:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8330","RENT","\u9810\u7e73\u79df\u91d1",1,1445,"MO","1",1445,"2","2020-06-01 10:58:05","2","2020-06-01 10:58:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:58:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8330","RENT","\u9810\u7e73\u79df\u91d1",2,1445,"MO","1",1445,"2","2020-06-01 10:58:05","2","2020-06-01 10:58:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:58:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8330","RENT","\u9810\u7e73\u79df\u91d1",3,1445,"MO","1",1445,"2","2020-06-01 10:58:05","2","2020-06-01 10:58:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:58:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8330","RENT","\u9810\u7e73\u79df\u91d1",4,1445,"MO","1",1445,"2","2020-06-01 10:58:05","2","2020-06-01 10:58:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:58:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8330","RENT","\u9810\u7e73\u79df\u91d1",5,1445,"MO","1",1445,"2","2020-06-01 10:58:05","2","2020-06-01 10:58:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:58:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8330","RENT","\u9810\u7e73\u79df\u91d1",6,1445,"MO","1",1445,"2","2020-06-01 10:58:05","2","2020-06-01 10:58:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:58:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8670,0,"8330"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-01 10:58:05","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":[1058,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207974","2020-06-01 10:58:05",8670,"2","2020-06-01 10:58:05","2","2020-06-01 10:58:05","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:58:05","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":["7974","DEPOSIT",null,"PAID","2020-06-01 10:58:05",0,"2","2020-06-01 10:58:05","2","2020-06-01 10:58:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 10:58:05","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":["7974","INVOICE","8330","PAID","2020-06-01 10:58:05",8670,"2","2020-06-01 10:58:05","2","2020-06-01 10:58:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:01:47","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","'0012415117","3 months contract. Special offer first 3 months 50% off. Storage rental and deposit $4893 paid by bank transfer on May 29, 2020. Remaining balance $2090 paid by bank transfer on May 31, 2020. Smartcard mails on May 29, 2020. ","2020-06-01 11:01:47","2","8BEgNhGpCR8jGkzUtrIcXg==","vXGdTNy9LvwX04wnIqWpkA==","PZmnfiJYWeWxoAH0DzfB+g==","raL9mQIdPGGwWsIuGBAHNmPBT8S4upMWPFVQNnXp0GCnN1LtR+CcK0yT2TbpMBlszikNQTVbrVF\/Fs5dqIAKNQ==",7999]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:05:51","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":"1207","master_room_id":"140","room_code":"B01-017"},{"room_id":"1208","master_room_id":"140","room_code":"B01-018"}],"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\tB01-017 4X4X7 $1112.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\tB01-018 4X4X7 $1112.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":"0","identity_type":"PERSONAL","identity_id":"D557515(0)","title":"Ms","lastname":"CHAN","firstname":"Tsui Ping","companyname":"","email":"","tel":"93059121","address":"Flat E, 21\/F, Block 2, Cheerful Garden, Siu Sai Wan, Hong Kong","pass":true,"customer_id":"1598","customer_code":"C201598","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"314","master_room_id":"140","discount_type":"%","price":"1112.00","disocunted_price":"1057.00","discount":"4.95","monthly_deduct":55.044,"room_id":"1208","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"314","master_room_id":"140","discount_type":"%","price":"1112.00","disocunted_price":"1057.00","discount":"4.95","monthly_deduct":55.044,"room_id":"1207","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1207","room_code":"B01-017","retail_price":"1112.0","discounted_price":1057,"location_id":"5"},{"room_id":"1208","room_code":"B01-018","retail_price":"1112.0","discounted_price":1057,"location_id":"5"}],"roughly_size":"32","total_retail_price":2224,"total_discounted_price":1978,"deposit":3956,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":6923,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2967.00","warehousing_date":"2020-06-06","rent_from":"2020-06-06","rent_to":"2020-09-05","delivery_service":"0","remark":"3 months contract. Special offer first 3 months 50% off. Storage rental and deposit $4893 paid by bank transfer on May 29, 2020. Remaining balance $2090 paid by bank transfer on May 31, 2020. Smartcard mails on May 29, 2020. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":2967,"order_total":9950,"final_order_total":6983,"location_id":"5","branch_id":"2","company_id":"1","room_key":"'0012415117","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"pass":true}},"roughly_size":"32","total_discounted_price":"1978.00","deposit":"3956.00","total_retail_price":"2224.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:05: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` = ?","parameters":["1","2","5","1598","NEW","B01-CT208002",2224,1978,3956,0,"3","3",6923,9950,6983,"2020-06-01 11:05:52","0",null,null,null,"2020-06-06","2020-09-05","3 months contract. Special offer first 3 months 50% off. Storage rental and deposit $4893 paid by bank transfer on May 29, 2020. Remaining balance $2090 paid by bank transfer on May 31, 2020. Smartcard mails on May 29, 2020. ","2020-06-06","32",0,null,2967,"2967.00","2","2020-06-01 11:05:51","2","2020-06-01 11:05:51","BANKIN","","","","BANKIN","","","",null,0,"'0012415117","C201598","PERSONAL","Ms","vXGdTNy9LvwX04wnIqWpkA==","8BEgNhGpCR8jGkzUtrIcXg==","","raL9mQIdPGGwWsIuGBAHNmPBT8S4upMWPFVQNnXp0GCnN1LtR+CcK0yT2TbpMBlszikNQTVbrVF\/Fs5dqIAKNQ==","PZmnfiJYWeWxoAH0DzfB+g==",null,"L3GdH0wCX1Q8+8ucB43nlw==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:05:52","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":["8002","314","140","1208","%","4.95",55.044,"2","2020-06-01 11:05:51"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:05:52","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":["8002","314","140","1207","%","4.95",55.044,"2","2020-06-01 11:05:51"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:05:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8002","1598","11","1","60.0",60,"2","2020-06-01 11:05:51","2","2020-06-01 11:05:51"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:05:52","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"8002"]},"data_before":[],"data_after":[],"step":4}
*****
{"created_at":"2020-06-01 11:05: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":["8002","1207","1112.0",1057,"2","2020-06-01 11:05:51"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:05: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-06-06","2020-09-05","1207"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-01 11:05: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":["8002","1208","1112.0",1057,"2","2020-06-01 11:05:51"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:05: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-06-06","2020-09-05","1208"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-01 11:05:52","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":["8002","B01-D205443","PAID",3956,0,"2020-09-05","2020-06-01 11:05:51","2020-06-01 11:05:51","2","2020-06-01 11:05:51","2","2020-06-01 11:05:51","1598"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:05: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":["8002","1598","SETTLED","B01-I208331","2020-06-01 11:05:51","2020-06-06","2","2020-06-01 11:05:51","2","2020-06-01 11:05:51"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:05: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":["8331","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-01 11:05:51","2","2020-06-01 11:05:51"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:05: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":["8331","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,989,"MO","1",989,"2","2020-06-01 11:05:51","2","2020-06-01 11:05:51"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:05: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":["8331","RENT","\u9810\u7e73\u79df\u91d1",3,1978,"MO","1",1978,"2","2020-06-01 11:05:51","2","2020-06-01 11:05:51"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:05:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8331","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-06-01 11:05:51","2","2020-06-01 11:05:51"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:05:52","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3027,0,"8331"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-01 11:05: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":["1598","BANKIN","","","","BANKIN","","","","PAID","P207975","2020-06-01 11:05:51",6983,"2","2020-06-01 11:05:51","2","2020-06-01 11:05:51","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:05: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":["7975","DEPOSIT","5443","PAID","2020-06-01 11:05:51",3956,"2","2020-06-01 11:05:51","2","2020-06-01 11:05:51"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:05: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":["7975","INVOICE","8331","PAID","2020-06-01 11:05:51",3027,"2","2020-06-01 11:05:51","2","2020-06-01 11:05:51"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:34:59","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","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":"1207","master_room_id":"140","room_code":"B01-017"},{"room_id":"1208","master_room_id":"140","room_code":"B01-018"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":685,"customer_code":"C180685","identity_type":"PERSONAL","identity_id":"Z136565(8)","title":"Mr","lastname":"Tam","firstname":"Wai Hung","companyname":"","email":null,"tel":"61102922","address":"Room 210, Wah Lai House, Wah Kwai Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2298.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-01","renew_room_key":"053,56239","renew_remark":"1 month contract. Storage rental $2300 paid by bank transfer on May 4, 2020. Storage deposit transferred from agreement A18-CT207556 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\tT01 5X6X7 $2298.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":"30","total_discounted_price":"2298.0","deposit":"0","total_retail_price":"2298.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:34: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",685,"NEW","A18-CT208003",2298,2298,0,0,"1","1",2298,2298,2298,"2020-06-01 11:34:59","0",null,null,null,"2020-06-01","2020-06-30","1 month contract. Storage rental $2300 paid by cash on June 1, 2020. Storage deposit transferred from agreement A18-CT207767 to this agreement.\r\n","2020-06-01","30",0,null,0,"0","2","2020-06-01 11:34:59","2","2020-06-01 11:34:59","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"053,56239","C180685","PERSONAL","Mr","Vy30hO8KRRcWAyFHMj+GkQ==","RAqogkelEKt1q5b\/6Neu\/g==","","T1rrupXx2a84nbfDVVe7dRZNixC4wynq7dBDu6A1cSJX7dG0wQgUJ6ZUu1fBgxwDKFNAcVyti6Of6RFkiuBYCg==","\/abipioEOeirm5gkDUnYEA==",null,"HSRQWr1h55jzD6yUUsYl4g==",null,1,"4879"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:34: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":["8003","857","2298.0","2298.00","2","2020-06-01 11:34:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:34: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-01","2020-06-30","857"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-01 11:34: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":["8003",685,"SETTLED","A18-I208332","2020-06-01 11:34:59","2020-06-01","2","2020-06-01 11:34:59","2","2020-06-01 11:34:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:34: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":["8332","RENT","\u9810\u7e73\u79df\u91d1",1,2298,"MO","1",2298,"2","2020-06-01 11:34:59","2","2020-06-01 11:34:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:34:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2298,0,"8332"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-01 11:34: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":[685,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207976","2020-06-01 11:34:59",2298,"2","2020-06-01 11:34:59","2","2020-06-01 11:34:59","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:34: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":["7976","DEPOSIT",null,"PAID","2020-06-01 11:34:59",0,"2","2020-06-01 11:34:59","2","2020-06-01 11:34:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:34: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":["7976","INVOICE","8332","PAID","2020-06-01 11:34:59",2298,"2","2020-06-01 11:34:59","2","2020-06-01 11:34:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:40:43","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"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":"1207","master_room_id":"140","room_code":"B01-017"},{"room_id":"1208","master_room_id":"140","room_code":"B01-018"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":330,"customer_code":"C170330","identity_type":"BUSINESS","identity_id":"56281393","title":"Mr","lastname":"Kwok","firstname":"Chi Leung Carman","companyname":"6C FACULTY","email":null,"tel":"90193071","address":"Flat 4, 8\/F, Block A, Abba House, 225 Aberdeen Main Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2668.0","renew_rent_month":"6","renew_warehousing_date":"2020-06-09","renew_room_key":"134,18163","renew_remark":"6 months contract. Storage rental paid by cheque on December 4, 2019. Storage deposit transferred from agreement A14-CT195179 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196603, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"65","order_discount":[],"order_room":[{"room_id":"770","room_code":"P04","retail_price":"3036.0","discounted_price":"3036.00","location_id":"2"}],"roughly_size":"50","total_retail_price":3036,"total_discounted_price":2668,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":16008,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-09","rent_from":"2020-06-09","rent_to":"2020-12-08","delivery_service":"0","remark":"6 months contract. Storage rental paid by cheque on June 1. Storage deposit transferred from agreement A14-CT196603 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":16008,"final_order_total":16008,"location_id":"2","branch_id":"1","company_id":"1","room_key":"134,18163","order_product":[],"pass":true}},"first_order_id":"3807","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\tP04 5X10X8 $3036.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":"50","total_discounted_price":"2668.0","deposit":"0","total_retail_price":"3036.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:40: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",330,"NEW","A14-CT208004",3036,2668,0,0,"6","6",16008,16008,16008,"2020-06-01 11:40:43","0",null,null,null,"2020-06-09","2020-12-08","6 months contract. Storage rental paid by cheque on June 1. Storage deposit transferred from agreement A14-CT196603 to this agreement.","2020-06-09","50",0,null,0,"0","2","2020-06-01 11:40:43","2","2020-06-01 11:40:43","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"134,18163","C170330","BUSINESS","Mr","E1aVyTjeHneQ0gLvBy0nv3Uuay5OpDX6nYd+BsxJntQ=","+pNULpsInm3siHASV0hIrg==","6C FACULTY","8wlMgWEt7UT5rg3k7JVZtXIvOMZ4hq49ZDKKjjLULiTACaS\/fc48EUwK4WFuEHAD6sFAUpQXITHsm2tZxghBSRZMJVzX71OGUWiT10gqiCU=","2MGnNxo0zRYEyOPXY0T54A==",null,null,"CqX2UEuDQrBjcukR9EVB7w==",1,"3807"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:40: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":["8004","770","3036.0","3036.00","2","2020-06-01 11:40:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:40: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-06-09","2020-12-08","770"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-01 11:40: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":["8004",330,"SETTLED","A14-I208333","2020-06-01 11:40:43","2020-06-09","2","2020-06-01 11:40:43","2","2020-06-01 11:40:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:40: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":["8333","RENT","\u9810\u7e73\u79df\u91d1",1,2668,"MO","1",2668,"2","2020-06-01 11:40:43","2","2020-06-01 11:40:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:40: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":["8333","RENT","\u9810\u7e73\u79df\u91d1",2,2668,"MO","1",2668,"2","2020-06-01 11:40:43","2","2020-06-01 11:40:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:40: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":["8333","RENT","\u9810\u7e73\u79df\u91d1",3,2668,"MO","1",2668,"2","2020-06-01 11:40:43","2","2020-06-01 11:40:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:40: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":["8333","RENT","\u9810\u7e73\u79df\u91d1",4,2668,"MO","1",2668,"2","2020-06-01 11:40:43","2","2020-06-01 11:40:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:40: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":["8333","RENT","\u9810\u7e73\u79df\u91d1",5,2668,"MO","1",2668,"2","2020-06-01 11:40:43","2","2020-06-01 11:40:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:40: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":["8333","RENT","\u9810\u7e73\u79df\u91d1",6,2668,"MO","1",2668,"2","2020-06-01 11:40:43","2","2020-06-01 11:40:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:40:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[16008,0,"8333"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-01 11:40: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":[330,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207977","2020-06-01 11:40:43",16008,"2","2020-06-01 11:40:43","2","2020-06-01 11:40:43","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:40: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":["7977","DEPOSIT",null,"PAID","2020-06-01 11:40:43",0,"2","2020-06-01 11:40:43","2","2020-06-01 11:40:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 11:40: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":["7977","INVOICE","8333","PAID","2020-06-01 11:40:43",16008,"2","2020-06-01 11:40:43","2","2020-06-01 11:40:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 12:04:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 12:05:14","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","189, 29075","6 months contract. Special 5% discount. Storage rental and deposit paid by bank transfer on November 27, 2019. Smartcard and padlock provided on the move-in day.","2020-06-01 12:05:14","2","yXKLXTtbNpECaRVTZxF\/Rw==","u5M1NXJIjztdYYHk7Vwmrg==","Ix2RqwSBh1pzBx1iOJIOXWu1ithJmZO4mn9wAKLDA\/4=","DfAQeHiWAVT275THMMrYDQ==","VyosBZbHxUyibrHLH6bhD20BAGdAxBSzkyi1qGhMnKwRfQTyLlnfPGb7lRtM3ea5NQk4EhLu2xRo9r4oj6ACf2RPGm7Q5Zl7uZTStEYZ0yQ=",6518]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 15:21:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 15:51:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 16:13:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 16:15:58","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":1076,"customer_code":"C181076","identity_type":"PERSONAL","identity_id":"D367728(2)","title":"Mr","lastname":"Tsui ","firstname":"Lai Yin, Ricky","companyname":"","email":"rickylytsui@yahoo.com.hk","tel":"56111196","address":"35H, Pokfulam Village, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"6","renew_warehousing_date":"2020-06-01","renew_room_key":"0012415211","renew_remark":"6 months contract. Storage rental paid by EPS on Dec 10,2019. Deposit $2580 transferred from agreement A05-CT183575 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196666, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"114","order_discount":[{"master_room_discount_id":"251","master_room_id":"114","discount_type":"%","price":"1290.00","disocunted_price":"1161.00","discount":"10.00","monthly_deduct":129,"room_id":"1136","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1136","room_code":"A05-134","retail_price":"1290.0","discounted_price":1161,"location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6972,"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 EPS on Jun 01,2020. Deposit $2580 transferred from agreement A05-CT196666 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":6972,"final_order_total":6972,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012415211","order_product":[],"pass":true}},"first_order_id":"3575","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-134 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":"1162.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 16:15: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1076,"NEW","A05-CT208005",1290,1162,0,0,"6","6",6972,6972,6972,"2020-06-01 16:15:59","0",null,null,null,"2020-06-01","2020-11-30","6 months contract. Storage rental paid by EPS on Jun 01,2020. Deposit $2580 transferred from agreement A05-CT196666 to this agreement.","2020-06-01","16",0,null,0,"0","2","2020-06-01 16:15:58","2","2020-06-01 16:15:58","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"0012415211","C181076","PERSONAL","Mr","8D1uLEOXtfHEgH0L7b+I6A==","JYuKNGzB9R7B9ggiMi1thg==","","KZL+9+tGA9K99yCUyPH6xehY269kOG0KsUODz8mEjNfg0VAbTVV1OJrUMhPfvuOM","I5Y7CXsRiY4dHshwP3wjFQ==","XFYTvA5+2boJNHqO313hBCouzb2kChGH21YnZdVIbNw=","sI8qxLSGP\/CHYru0QEJ1vA==",null,1,"3575"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 16:15: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":["8005","251","114","1136","%","10.00",129,"2","2020-06-01 16:15:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 16:15: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":["8005","1136","1290.0",1161,"2","2020-06-01 16:15:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 16:15: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-01","2020-11-30","1136"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-01 16:15: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":["8005",1076,"SETTLED","A05-I208334","2020-06-01 16:15:58","2020-06-01","2","2020-06-01 16:15:58","2","2020-06-01 16:15:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 16:15: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":["8334","RENT","\u9810\u7e73\u79df\u91d1",1,1162,"MO","1",1162,"2","2020-06-01 16:15:58","2","2020-06-01 16:15:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 16:15: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":["8334","RENT","\u9810\u7e73\u79df\u91d1",2,1162,"MO","1",1162,"2","2020-06-01 16:15:58","2","2020-06-01 16:15:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 16:15: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":["8334","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-06-01 16:15:58","2","2020-06-01 16:15:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 16:15: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":["8334","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-06-01 16:15:58","2","2020-06-01 16:15:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 16:15: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":["8334","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-06-01 16:15:58","2","2020-06-01 16:15:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 16:15: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":["8334","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-06-01 16:15:58","2","2020-06-01 16:15:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 16:15:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6972,0,"8334"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-01 16:15: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":[1076,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207978","2020-06-01 16:15:58",6972,"2","2020-06-01 16:15:58","2","2020-06-01 16:15:58","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 16:15: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":["7978","DEPOSIT",null,"PAID","2020-06-01 16:15:58",0,"2","2020-06-01 16:15:58","2","2020-06-01 16:15:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 16:15: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":["7978","INVOICE","8334","PAID","2020-06-01 16:15:58",6972,"2","2020-06-01 16:15:58","2","2020-06-01 16:15:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 16:28:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 18:04:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 18:11:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:21:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:26: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":"type=INVOICE&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1438","master_room_id":"166","room_code":"C15-132"}],"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\tC15-132 4X3X3 $566.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":"1","identity_type":"PERSONAL","identity_id":"C253387(A)","title":"Ms","lastname":"HUI","firstname":"Sau Ying","companyname":"","email":"hmandysy@yahoo.com.hk","tel":"92103386","address":"Rm 3019, Shin Kwan House, Fu Shin Estate, Tai Po, N.T","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"405","master_room_id":"166","discount_type":"%","price":"566.00","disocunted_price":"510.10","discount":"9.88","monthly_deduct":55.9208,"room_id":"1438","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1438","room_code":"C15-132","retail_price":"566.0","discounted_price":510.1,"location_id":"6"}],"roughly_size":"12","total_retail_price":566,"total_discounted_price":510,"deposit":566,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3626,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-28","rent_from":"2020-06-28","rent_to":"2020-12-27","delivery_service":"0","remark":"6 months contract. Storage rental and deposit, smart card paid by bank transfer on Jun 01,2020. Smart card mailed out on the same day.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3686,"final_order_total":3686,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012522666","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"pass":true}},"roughly_size":"12","total_discounted_price":"510.00","deposit":"566.00","total_retail_price":"566.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:26:56","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":["C201601","PERSONAL","Ms","yANzfeHOhYehhNPJXy6BjA==","SLPJ+c2smshjwdK17xoj0w==","","desOfu2ZjBghntFAO8JBUA==","UKfG0XI\/377XXojv28P6q\/xTS84v2kjrtBVip\/w7Mic=","lAF0AAJ3AqNty+pBAU7EbCRJzFa1XH9hWRBtQCFFmXpkKJf+0SZspW+TnjfGNiaJ3YaUbYQ22GsAX9HvYjzRTg==","0gjoYj55Iz\/5DK\/YfGu9Fw==",null,"UKfG0XI\/377XXojv28P6q\/xTS84v2kjrtBVip\/w7Mic=","aegrmM2LptkJX+OgUOIVpw==","2","2020-06-01 19:26:54","2","2020-06-01 19:26:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:26:56","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","3","6",1601,"NEW","C15-CT208006",566,510,566,0,"6","6",3626,3686,3686,"2020-06-01 19:26:56","0",null,null,null,"2020-06-28","2020-12-27","6 months contract. Storage rental and deposit, smart card paid by bank transfer on Jun 01,2020. Smart card mailed out on the same day.","2020-06-28","12",0,null,0,"0","2","2020-06-01 19:26:54","2","2020-06-01 19:26:54","BANKIN","","","","BANKIN","","","",null,0,"'0012522666","C201601","PERSONAL","Ms","yANzfeHOhYehhNPJXy6BjA==","SLPJ+c2smshjwdK17xoj0w==","","lAF0AAJ3AqNty+pBAU7EbCRJzFa1XH9hWRBtQCFFmXpkKJf+0SZspW+TnjfGNiaJ3YaUbYQ22GsAX9HvYjzRTg==","desOfu2ZjBghntFAO8JBUA==","UKfG0XI\/377XXojv28P6q\/xTS84v2kjrtBVip\/w7Mic=","0gjoYj55Iz\/5DK\/YfGu9Fw==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:26:56","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":["8006","405","166","1438","%","9.88",55.9208,"2","2020-06-01 19:26:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:26:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8006",1601,"11","1","60.0",60,"2","2020-06-01 19:26:54","2","2020-06-01 19:26:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:26:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"8006"]},"data_before":[],"data_after":[],"step":4}
*****
{"created_at":"2020-06-01 19:26:56","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":["8006","1438","566.0",510.1,"2","2020-06-01 19:26:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:26:56","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-28","2020-12-27","1438"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-01 19:26:56","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":["8006","C15-D205444","PAID",566,0,"2020-12-27","2020-06-01 19:26:54","2020-06-01 19:26:54","2","2020-06-01 19:26:54","2","2020-06-01 19:26:54",1601]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:26:56","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":["8006",1601,"SETTLED","C15-I208335","2020-06-01 19:26:54","2020-06-28","2","2020-06-01 19:26:54","2","2020-06-01 19:26:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:26:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8335","RENT","\u9810\u7e73\u79df\u91d1",1,510,"MO","1",510,"2","2020-06-01 19:26:54","2","2020-06-01 19:26:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:26:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8335","RENT","\u9810\u7e73\u79df\u91d1",2,510,"MO","1",510,"2","2020-06-01 19:26:54","2","2020-06-01 19:26:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:26:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8335","RENT","\u9810\u7e73\u79df\u91d1",3,510,"MO","1",510,"2","2020-06-01 19:26:54","2","2020-06-01 19:26:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:26:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8335","RENT","\u9810\u7e73\u79df\u91d1",4,510,"MO","1",510,"2","2020-06-01 19:26:54","2","2020-06-01 19:26:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:26:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8335","RENT","\u9810\u7e73\u79df\u91d1",5,510,"MO","1",510,"2","2020-06-01 19:26:54","2","2020-06-01 19:26:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:26:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8335","RENT","\u9810\u7e73\u79df\u91d1",6,510,"MO","1",510,"2","2020-06-01 19:26:54","2","2020-06-01 19:26:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:26:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8335","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-06-01 19:26:54","2","2020-06-01 19:26:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:26:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3120,0,"8335"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-01 19:26:56","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":[1601,"BANKIN","","","","BANKIN","","","","PAID","P207979","2020-06-01 19:26:54",3686,"2","2020-06-01 19:26:54","2","2020-06-01 19:26:54","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:26:56","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":["7979","DEPOSIT","5444","PAID","2020-06-01 19:26:54",566,"2","2020-06-01 19:26:54","2","2020-06-01 19:26:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:26:56","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":["7979","INVOICE","8335","PAID","2020-06-01 19:26:54",3120,"2","2020-06-01 19:26:54","2","2020-06-01 19:26:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:36: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":"","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1438","master_room_id":"166","room_code":"C15-132"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1266,"customer_code":"C191266","identity_type":"PERSONAL","identity_id":"D834680(2)","title":"Ms","lastname":"CHOI","firstname":"Sau Ying","companyname":"","email":"gtdenise@gmail.com","tel":"91876355","address":"Rm 804, Block M, Kornhill, Quarry Bay, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1511.0","renew_rent_month":"12","renew_warehousing_date":"2020-06-01","renew_room_key":"0012385473","renew_remark":"12 months contracts. Special offer 2 months free and $400 for change storage. Storage deposit paid by EPS on May 11, 2019. Storage rental will be paid before the starting day. Smartcard provided on May 11, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT194952, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1678.0","renew_master_room_id":"174","order_discount":[],"order_room":[{"room_id":"1480","room_code":"C15-174","retail_price":"1678.0","discounted_price":"1678.00","location_id":"6"}],"roughly_size":"28","total_retail_price":1678,"total_discounted_price":1511,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":18132,"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":"2021-05-31","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on May 31,2020. Storage deposit $1678 transferred from agreement C15-CT194952 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":18132,"final_order_total":18132,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012385473","order_product":[],"pass":true}},"first_order_id":4952,"selected_room_tr":"\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> \r\n\t\t\t\t\tC15-174 4X7X6.5 $1678.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":"28","total_discounted_price":"1511.0","deposit":"0","total_retail_price":"1678.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:36: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","3","6",1266,"NEW","C15-CT208007",1678,1511,0,0,"12","12",18132,18132,18132,"2020-06-01 19:36:13","0",null,null,null,"2020-06-01","2021-05-31","12 months contract. Storage rental paid by bank transfer on May 31,2020. Storage deposit $1678 transferred from agreement C15-CT194952 to this agreement.","2020-06-01","28",0,null,0,"0","2","2020-06-01 19:36:12","2","2020-06-01 19:36:12","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012385473","C191266","PERSONAL","Ms","yANzfeHOhYehhNPJXy6BjA==","U3iGX7U0CkjAKcdgZ04K6A==","","hrcCsrtxkfs\/VBjrsvTsKXYjDRbRzCqW3NT7CsGSj+eT6a3d4Id8GVIC5HkJfy6+","saNRLs4wFJmgATtUAdDeKg==","r\/TIjDtYe09fYKurrqAEHm5Kd16Gf1+09g9TryjGitE=","pbQhyRzGqDJBQgM48SNK9A==",null,1,4952]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:36: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":["8007","1480","1678.0","1678.00","2","2020-06-01 19:36:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:36: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-01","2021-05-31","1480"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-01 19:36: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":["8007",1266,"SETTLED","C15-I208336","2020-06-01 19:36:12","2020-06-01","2","2020-06-01 19:36:12","2","2020-06-01 19:36:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:36: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":["8336","RENT","\u9810\u7e73\u79df\u91d1",1,1511,"MO","1",1511,"2","2020-06-01 19:36:12","2","2020-06-01 19:36:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:36: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":["8336","RENT","\u9810\u7e73\u79df\u91d1",2,1511,"MO","1",1511,"2","2020-06-01 19:36:12","2","2020-06-01 19:36:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:36: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":["8336","RENT","\u9810\u7e73\u79df\u91d1",3,1511,"MO","1",1511,"2","2020-06-01 19:36:12","2","2020-06-01 19:36:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:36: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":["8336","RENT","\u9810\u7e73\u79df\u91d1",4,1511,"MO","1",1511,"2","2020-06-01 19:36:12","2","2020-06-01 19:36:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:36: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":["8336","RENT","\u9810\u7e73\u79df\u91d1",5,1511,"MO","1",1511,"2","2020-06-01 19:36:12","2","2020-06-01 19:36:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:36: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":["8336","RENT","\u9810\u7e73\u79df\u91d1",6,1511,"MO","1",1511,"2","2020-06-01 19:36:12","2","2020-06-01 19:36:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:36: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":["8336","RENT","\u9810\u7e73\u79df\u91d1",7,1511,"MO","1",1511,"2","2020-06-01 19:36:12","2","2020-06-01 19:36:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:36: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":["8336","RENT","\u9810\u7e73\u79df\u91d1",8,1511,"MO","1",1511,"2","2020-06-01 19:36:12","2","2020-06-01 19:36:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:36: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":["8336","RENT","\u9810\u7e73\u79df\u91d1",9,1511,"MO","1",1511,"2","2020-06-01 19:36:12","2","2020-06-01 19:36:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:36: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":["8336","RENT","\u9810\u7e73\u79df\u91d1",10,1511,"MO","1",1511,"2","2020-06-01 19:36:12","2","2020-06-01 19:36:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:36: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":["8336","RENT","\u9810\u7e73\u79df\u91d1",11,1511,"MO","1",1511,"2","2020-06-01 19:36:12","2","2020-06-01 19:36:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:36: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":["8336","RENT","\u9810\u7e73\u79df\u91d1",12,1511,"MO","1",1511,"2","2020-06-01 19:36:12","2","2020-06-01 19:36:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:36:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[18132,0,"8336"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-01 19:36: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":[1266,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207980","2020-06-01 19:36:12",18132,"2","2020-06-01 19:36:12","2","2020-06-01 19:36:12","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:36: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":["7980","DEPOSIT",null,"PAID","2020-06-01 19:36:12",0,"2","2020-06-01 19:36:12","2","2020-06-01 19:36:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:36: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":["7980","INVOICE","8336","PAID","2020-06-01 19:36:12",18132,"2","2020-06-01 19:36:12","2","2020-06-01 19:36:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:39:54","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","'0012522666","6 months contract. Storage rental and deposit, smart card paid by bank transfer on Jun 01,2020. Smart card mailed out on the same day.","2020-06-01 19:39:54","2","SLPJ+c2smshjwdK17xoj0w==","yANzfeHOhYehhNPJXy6BjA==","UKfG0XI\/377XXojv28P6q\/xTS84v2kjrtBVip\/w7Mic=","desOfu2ZjBghntFAO8JBUA==","lAF0AAJ3AqNty+pBAU7EbCRJzFa1XH9hWRBtQCFFmXpkKJf+0SZspW+TnjfGNiaJ3YaUbYQ22GsAX9HvYjzRTg==",8006]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:41:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:41:46","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":"0","identity_type":"PERSONAL","identity_id":"C253387(A)","title":"Ms","lastname":"HUI","firstname":"Sau Ying","companyname":"","email":"hmandysy@yahoo.com.hk","tel":"92103386","address":"Rm 3019, Shin Kwan House, Fu Shin Estate, Tai Po, N.T","pass":true,"customer_id":"1601","customer_code":"C201601","customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"405 available_room_list_input","master_room_id":"166","discount_type":"%","price":"566.00","disocunted_price":"510.10","discount":"9.88","monthly_deduct":55.9208,"room_id":"1436","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1436","room_code":"C15-130","retail_price":"566.0","discounted_price":510.1,"location_id":"6"}],"roughly_size":"12","total_retail_price":566,"total_discounted_price":510,"deposit":566,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3626,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-28","rent_from":"2020-06-28","rent_to":"2020-12-27","delivery_service":"0","remark":"6 months contract. Storage rental and deposit, smart card paid by bank transfer on Jun 01,2020. Smart card mailed out on the same day.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3686,"final_order_total":3686,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012522666","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"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\tC15-130 4X3X3 $566.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":"12","total_discounted_price":"510.00","deposit":"566.00","total_retail_price":"566.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:41: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` = ?","parameters":["1","3","6","1601","NEW","C15-CT208008",566,510,566,0,"6","6",3626,3686,3686,"2020-06-01 19:41:46","0",null,null,null,"2020-06-28","2020-12-27","6 months contract. Storage rental and deposit, smart card paid by bank transfer on Jun 01,2020. Smart card mailed out on the same day.","2020-06-28","12",0,null,0,"0","2","2020-06-01 19:41:46","2","2020-06-01 19:41:46","BANKIN","","","","BANKIN","","","",null,0,"'0012522666","C201601","PERSONAL","Ms","yANzfeHOhYehhNPJXy6BjA==","SLPJ+c2smshjwdK17xoj0w==","","lAF0AAJ3AqNty+pBAU7EbCRJzFa1XH9hWRBtQCFFmXpkKJf+0SZspW+TnjfGNiaJ3YaUbYQ22GsAX9HvYjzRTg==","desOfu2ZjBghntFAO8JBUA==","UKfG0XI\/377XXojv28P6q\/xTS84v2kjrtBVip\/w7Mic=","0gjoYj55Iz\/5DK\/YfGu9Fw==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:41:46","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":["8008","405 available_room_list_input","166","1436","%","9.88",55.9208,"2","2020-06-01 19:41:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:41:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8008","1601","11","1","60.0",60,"2","2020-06-01 19:41:46","2","2020-06-01 19:41:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:41:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"8008"]},"data_before":[],"data_after":[],"step":4}
*****
{"created_at":"2020-06-01 19:41: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":["8008","1436","566.0",510.1,"2","2020-06-01 19:41:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:41: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-06-28","2020-12-27","1436"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-01 19:41:46","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":["8008","C15-D205445","PAID",566,0,"2020-12-27","2020-06-01 19:41:46","2020-06-01 19:41:46","2","2020-06-01 19:41:46","2","2020-06-01 19:41:46","1601"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:41: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":["8008","1601","SETTLED","C15-I208337","2020-06-01 19:41:46","2020-06-28","2","2020-06-01 19:41:46","2","2020-06-01 19:41:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:41: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":["8337","RENT","\u9810\u7e73\u79df\u91d1",1,510,"MO","1",510,"2","2020-06-01 19:41:46","2","2020-06-01 19:41:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:41: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":["8337","RENT","\u9810\u7e73\u79df\u91d1",2,510,"MO","1",510,"2","2020-06-01 19:41:46","2","2020-06-01 19:41:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:41: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":["8337","RENT","\u9810\u7e73\u79df\u91d1",3,510,"MO","1",510,"2","2020-06-01 19:41:46","2","2020-06-01 19:41:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:41: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":["8337","RENT","\u9810\u7e73\u79df\u91d1",4,510,"MO","1",510,"2","2020-06-01 19:41:46","2","2020-06-01 19:41:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:41: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":["8337","RENT","\u9810\u7e73\u79df\u91d1",5,510,"MO","1",510,"2","2020-06-01 19:41:46","2","2020-06-01 19:41:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:41: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":["8337","RENT","\u9810\u7e73\u79df\u91d1",6,510,"MO","1",510,"2","2020-06-01 19:41:46","2","2020-06-01 19:41:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:41:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8337","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-06-01 19:41:46","2","2020-06-01 19:41:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:41:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3120,0,"8337"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-01 19:41: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":["1601","BANKIN","","","","BANKIN","","","","PAID","P207981","2020-06-01 19:41:46",3686,"2","2020-06-01 19:41:46","2","2020-06-01 19:41:46","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:41: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":["7981","DEPOSIT","5445","PAID","2020-06-01 19:41:46",566,"2","2020-06-01 19:41:46","2","2020-06-01 19:41:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 19:41: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":["7981","INVOICE","8337","PAID","2020-06-01 19:41:46",3120,"2","2020-06-01 19:41:46","2","2020-06-01 19:41:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-01 20:13:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****