\r\n\t\t\t\t\tE30 4X3X8 $998.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\tE29 4X3X8 $998.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1358.00","deposit":"0.00","total_retail_price":"1996.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 13:21:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",440,"NEW","A12-CT207809",1996,1358,0,0,"12","12",16296,16296,16296,"2020-05-09 13:21:03","0",null,null,null,"2020-05-14","2021-05-13","12 months contract. Special offer $300 Maxim's voucher and 2 renewal gifts. Storage rental paid by EPS on May 9, 2020. Storage deposit transferred from agreement A12-CT196481 to this agreement.\r\n","2020-05-14","24",0,null,0,"0","2","2020-05-09 13:21:03","2","2020-05-09 13:21:03","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"072,35230","C170440","PERSONAL","Mr","65Q0F0t5QXC2HsLR\/DxA3g==","bGWftO7QHB1VrLc6D5WiAA==","","hyzqrzwywRnvgAruzm80EP59LKp1WrHQdsmUCz+BbZpXRjTgKED1S8mHqbbtWS5fRucQ1M\/F\/bpMTbKM8heMeA==","NBzW6gnUKO5pYvfEPwsSBg==","5JtP5k2aSao6SrVHFpD6JYI4GpV5FoP5d6nvqtdVYQ0=","cvQHrR2PzpYB+tZ4ERQIZA==",null,1,"3599"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 13:21:04","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":["7809","71","6","303","%","16.84",168.0632,"2","2020-05-09 13:21:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 13:21:04","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":["7809","71","6","302","%","16.84",168.0632,"2","2020-05-09 13:21:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 13:21:04","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":["7809","303","998.0",829.9,"2","2020-05-09 13:21:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 13:21:04","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","2021-05-13","303"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-05-09 13:21:04","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":["7809","302","998.0",829.9,"2","2020-05-09 13:21:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 13:21:04","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","2021-05-13","302"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-05-09 13:21:04","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":["7809",440,"SETTLED","A12-I208138","2020-05-09 13:21:03","2020-05-14","2","2020-05-09 13:21:03","2","2020-05-09 13:21:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 13:21:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8138","RENT","\u9810\u7e73\u79df\u91d1",1,1358,"MO","1",1358,"2","2020-05-09 13:21:03","2","2020-05-09 13:21:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 13:21:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8138","RENT","\u9810\u7e73\u79df\u91d1",2,1358,"MO","1",1358,"2","2020-05-09 13:21:03","2","2020-05-09 13:21:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 13:21:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8138","RENT","\u9810\u7e73\u79df\u91d1",3,1358,"MO","1",1358,"2","2020-05-09 13:21:03","2","2020-05-09 13:21:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 13:21:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8138","RENT","\u9810\u7e73\u79df\u91d1",4,1358,"MO","1",1358,"2","2020-05-09 13:21:03","2","2020-05-09 13:21:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 13:21:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8138","RENT","\u9810\u7e73\u79df\u91d1",5,1358,"MO","1",1358,"2","2020-05-09 13:21:03","2","2020-05-09 13:21:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 13:21:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8138","RENT","\u9810\u7e73\u79df\u91d1",6,1358,"MO","1",1358,"2","2020-05-09 13:21:03","2","2020-05-09 13:21:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 13:21:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8138","RENT","\u9810\u7e73\u79df\u91d1",7,1358,"MO","1",1358,"2","2020-05-09 13:21:03","2","2020-05-09 13:21:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 13:21:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8138","RENT","\u9810\u7e73\u79df\u91d1",8,1358,"MO","1",1358,"2","2020-05-09 13:21:03","2","2020-05-09 13:21:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 13:21:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8138","RENT","\u9810\u7e73\u79df\u91d1",9,1358,"MO","1",1358,"2","2020-05-09 13:21:03","2","2020-05-09 13:21:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 13:21:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8138","RENT","\u9810\u7e73\u79df\u91d1",10,1358,"MO","1",1358,"2","2020-05-09 13:21:03","2","2020-05-09 13:21:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 13:21:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8138","RENT","\u9810\u7e73\u79df\u91d1",11,1358,"MO","1",1358,"2","2020-05-09 13:21:03","2","2020-05-09 13:21:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 13:21:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8138","RENT","\u9810\u7e73\u79df\u91d1",12,1358,"MO","1",1358,"2","2020-05-09 13:21:03","2","2020-05-09 13:21:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 13:21:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[16296,0,"8138"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-05-09 13:21:04","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":[440,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207783","2020-05-09 13:21:03",16296,"2","2020-05-09 13:21:03","2","2020-05-09 13:21:03","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 13:21:04","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":["7783","DEPOSIT",null,"PAID","2020-05-09 13:21:03",0,"2","2020-05-09 13:21:03","2","2020-05-09 13:21:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 13:21:04","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":["7783","INVOICE","8138","PAID","2020-05-09 13:21:03",16296,"2","2020-05-09 13:21:03","2","2020-05-09 13:21:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 13:26:46","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","072,35230, 190,26381","12 months contract. Special offer $300 Maxim's voucher and 2 renewal gifts. Storage rental paid by EPS on May 9, 2020. Storage deposit transferred from agreement A12-CT196481 to this agreement.\r\n","2020-05-09 13:26:46","2","bGWftO7QHB1VrLc6D5WiAA==","65Q0F0t5QXC2HsLR\/DxA3g==","5JtP5k2aSao6SrVHFpD6JYI4GpV5FoP5d6nvqtdVYQ0=","NBzW6gnUKO5pYvfEPwsSBg==","hyzqrzwywRnvgAruzm80EP59LKp1WrHQdsmUCz+BbZpXRjTgKED1S8mHqbbtWS5fRucQ1M\/F\/bpMTbKM8heMeA==",7809]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 14:10: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","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1045,"customer_code":"C181045","identity_type":"PERSONAL","identity_id":"Z141369(5)","title":"Ms","lastname":"Ng","firstname":"Ting Ting","companyname":"","email":"tingtingnghk@outlook.com","tel":"91263325","address":"Flat 4, 10\/F, Block D, Hoi Wu Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-18","renew_room_key":"0012477352","renew_remark":"6 months contract. Storage rental paid by cheque on November 12, 2019. Storage deposit $2580 transferred from agreement A05-CT183535 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196381, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"114","order_discount":[],"order_room":[{"room_id":"1149","room_code":"A05-147","retail_price":"1290.0","discounted_price":"1290.00","location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":13944,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1162.00","warehousing_date":"2020-05-18","rent_from":"2020-05-18","rent_to":"2021-06-17","delivery_service":"0","remark":"13 months contract. Two special renewal gift provided on May 9, 2020. Storage rental paid by cheque on May 9, 2020. Storage deposit $2580 transferred from agreement A05-CT196381 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":1162,"order_total":15106,"final_order_total":13944,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012477352","order_product":[],"pass":true}},"first_order_id":"3535","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-147 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.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 14:10:06","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",1045,"NEW","A05-CT207810",1290,1162,0,0,"13","13",13944,15106,13944,"2020-05-09 14:10:06","0",null,null,null,"2020-05-18","2021-06-17","13 months contract. Two special renewal gift provided on May 9, 2020. Storage rental paid by cheque on May 9, 2020. Storage deposit $2580 transferred from agreement A05-CT196381 to this agreement. ","2020-05-18","16",0,null,1162,"1162.00","2","2020-05-09 14:10:05","2","2020-05-09 14:10:05","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"0012477352","C181045","PERSONAL","Ms","I33v1nYpmo2W\/6rzKboBXg==","cxr02xsD1tXvJ4ihJHZKWw==","","cjhYP2kcta91OUINqwSH2B5\/ZKF\/HizCv\/6Gw70uFqAdFez0XZmhIawWMeI5M5S2qVDNlnVwRn8FGjEe8VQHLbF9i07jkKyatWWcwQdokUI=","V02JpXQxFEOhKET35+37LA==","9e3ST7j7LPaKFgE\/Zahr7CMe4SSN\/hLS1HVzS4502io=","EOEPM1wsMywRY+AbIJAIWA==",null,1,"3535"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 14:10:06","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":["7810","1149","1290.0","1290.00","2","2020-05-09 14:10:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 14:10:06","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-18","2021-06-17","1149"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-05-09 14:10:06","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":["7810",1045,"SETTLED","A05-I208139","2020-05-09 14:10:05","2020-05-18","2","2020-05-09 14:10:05","2","2020-05-09 14:10:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 14:10:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8139","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1162,"MO","1",1162,"2","2020-05-09 14:10:05","2","2020-05-09 14:10:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 14:10:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8139","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-05-09 14:10:05","2","2020-05-09 14:10:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 14:10:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8139","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-05-09 14:10:05","2","2020-05-09 14:10:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 14:10:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8139","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-05-09 14:10:05","2","2020-05-09 14:10:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 14:10:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8139","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-05-09 14:10:05","2","2020-05-09 14:10:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 14:10:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8139","RENT","\u9810\u7e73\u79df\u91d1",7,1162,"MO","1",1162,"2","2020-05-09 14:10:05","2","2020-05-09 14:10:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 14:10:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8139","RENT","\u9810\u7e73\u79df\u91d1",8,1162,"MO","1",1162,"2","2020-05-09 14:10:05","2","2020-05-09 14:10:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 14:10:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8139","RENT","\u9810\u7e73\u79df\u91d1",9,1162,"MO","1",1162,"2","2020-05-09 14:10:05","2","2020-05-09 14:10:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 14:10:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8139","RENT","\u9810\u7e73\u79df\u91d1",10,1162,"MO","1",1162,"2","2020-05-09 14:10:05","2","2020-05-09 14:10:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 14:10:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8139","RENT","\u9810\u7e73\u79df\u91d1",11,1162,"MO","1",1162,"2","2020-05-09 14:10:05","2","2020-05-09 14:10:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 14:10:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8139","RENT","\u9810\u7e73\u79df\u91d1",12,1162,"MO","1",1162,"2","2020-05-09 14:10:05","2","2020-05-09 14:10:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 14:10:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8139","RENT","\u9810\u7e73\u79df\u91d1",13,1162,"MO","1",1162,"2","2020-05-09 14:10:05","2","2020-05-09 14:10:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 14:10:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13944,0,"8139"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-05-09 14:10:06","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":[1045,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207784","2020-05-09 14:10:05",13944,"2","2020-05-09 14:10:05","2","2020-05-09 14:10:05","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 14:10:06","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":["7784","DEPOSIT",null,"PAID","2020-05-09 14:10:05",0,"2","2020-05-09 14:10:05","2","2020-05-09 14:10:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 14:10:06","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":["7784","INVOICE","8139","PAID","2020-05-09 14:10:05",13944,"2","2020-05-09 14:10:05","2","2020-05-09 14:10:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-09 14:47:19","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","055, 25829, 076, 32317","12 months contract. Special offer $300 Maxim's coupon. Storage rental paid by bank transfer on December 9, 2019. Storage deposit transferred from agreement A14-CT195165 to this agreement.","2020-05-09 14:47:19","2","TXvO5dZhVvXkdspfvdLgcA==","rxWAqXjEh9oAFAKWpzdjVA==","v6PhOtEl9uQrlYXtRF24YJqWvsfQDXgwdbwez5ScEnU=","mbXKD+aktNtPT8cH3Hqurg==","2Cwrnow\/Aa0\/2h\/MRqpekeAjt7NwOiKuLdElE2iaCTMTJOyKjA5NtgJofIEkRraBmoBaxWUqbN3qYAxtzYJwkAzjLOKxEtuWpAKrey1MBYM=",6650]},"data_before":[],"data_after":[],"step":1}
*****