\r\n\t\t\t\t\tC15-028 4X8X6.5 $1798.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":"32","total_discounted_price":"1709","deposit":"0.00","total_retail_price":"1798.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 10:13:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1028,"NEW","C15-CT206917",1798,1709,0,0,"4","4",6836,6836,6836,"2020-01-10 10:13:57","0",null,null,null,"2019-11-09","2020-03-08","4 months contract. Storage rental paid by bank transfer on 10 Jan 2020. Storage deposit $3596 transferred from agreement C15-CT183501 to this agreement. \r\n\r\n","2019-11-09","32",0,null,0,"0","2","2020-01-10 10:13:56","2","2020-01-10 10:13:56","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0012469943","C181028","PERSONAL","Mr","Z47KBKMfrUFOYZIXrfc3vg==","oe4emdjBwqJ3qUpOcI17hw==","","huCsJ1Z\/6+uPRSM+jlsqCgEc5MpkJAFG+IbgMU1UloDr+bQ+Ah18x4dH8gSnuW7mSw4B8lYAycTU8F9ruymN7A==","UpTDawqOu8bBv1mRJuVTSA==","wP4h5Qj6EXMVQ2TH0nZJOP5TERDr5tP09PrMyRHFvWI=","mV2es2FO+t8Ad2akC7hJFg==",null,1,3501]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 10:13:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6917","1334","1798.0","1798.00","2","2020-01-10 10:13:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 10:13:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-11-09","2020-03-08","1334"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 10:13:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6917",1028,"SETTLED","C15-I207245","2020-01-10 10:13:56","2019-11-09","2","2020-01-10 10:13:56","2","2020-01-10 10:13:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 10:13:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7245","RENT","\u9810\u7e73\u79df\u91d1",1,1709,"MO","1",1709,"2","2020-01-10 10:13:56","2","2020-01-10 10:13:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 10:13:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7245","RENT","\u9810\u7e73\u79df\u91d1",2,1709,"MO","1",1709,"2","2020-01-10 10:13:56","2","2020-01-10 10:13:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 10:13:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7245","RENT","\u9810\u7e73\u79df\u91d1",3,1709,"MO","1",1709,"2","2020-01-10 10:13:56","2","2020-01-10 10:13:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 10:13:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7245","RENT","\u9810\u7e73\u79df\u91d1",4,1709,"MO","1",1709,"2","2020-01-10 10:13:56","2","2020-01-10 10:13:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 10:13:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6836,0,"7245"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-10 10:13:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1028,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206895","2020-01-10 10:13:56",6836,"2","2020-01-10 10:13:56","2","2020-01-10 10:13:56","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 10:13:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6895","DEPOSIT",null,"PAID","2020-01-10 10:13:56",0,"2","2020-01-10 10:13:56","2","2020-01-10 10:13:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 10:13:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6895","INVOICE","7245","PAID","2020-01-10 10:13:56",6836,"2","2020-01-10 10:13:56","2","2020-01-10 10:13:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 10:33:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 10:33:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 10:39:26","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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":422,"customer_code":"C170422","identity_type":"PERSONAL","identity_id":"D707882(0)","title":"Ms","lastname":"Lun","firstname":"Kin Ting, Jennifer","companyname":"","email":"jenniferlun@netvigator.com","tel":"94601114","address":"13\/F, Flat D, 58 Aberdeen Main Road, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1887.0","renew_rent_month":"3","renew_warehousing_date":"2019-12-06","renew_room_key":"054,60331,054,46800","renew_remark":"3 months contract. Storage rental paid by bank transfer on September 25, 2019. Storage deposit transferred from agreement A14-CT195314 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\tL49 4X4X8 $1098.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\tL48 4X4X8 $1098.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\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":"32","total_discounted_price":"1887.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 10:39:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",422,"NEW","A14-CT206918",2196,1887,0,0,"3","3",5661,5661,5661,"2020-01-10 10:39:26","0",null,null,null,"2019-12-06","2020-03-05","3 months contract. Storage rental paid by bank transfer on January 10, 2020. Storage deposit transferred from agreement A14-CT196018 to this agreement.\r\n\r\n","2019-12-06","32",0,null,0,"0","2","2020-01-10 10:39:26","2","2020-01-10 10:39:26","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,60331,054,46800","C170422","PERSONAL","Ms","xYi2pwRevSHfV5czTkolJ7KAgbpNCBYwTee28I\/M54o=","AmePxSuzgSRLGutACC9bnA==","","FJ9ZDY8\/7kA8A+te5iy9YqoyRYpOU3Bmu0epfxVEGBZDwhm\/CmuQLqsktSokLLwP","8XqrRRnMV+GmztFyZOdQwA==","PLmzzbYEBFtGoiJmp\/XL7iWspjMaTej8bBZte\/60rbY=","NE7TBy05SBIIdbS3hOb6DQ==",null,1,"4885"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 10:39:26","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":["6918","434","35","570","%","4.97",54.5706,"2","2020-01-10 10:39:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 10:39:26","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":["6918","434","35","571","%","4.97",54.5706,"2","2020-01-10 10:39:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 10:39:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6918","571","1098.0",1043.4,"2","2020-01-10 10:39:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 10:39:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-06","2020-03-05","571"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 10:39:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6918","570","1098.0",1043.4,"2","2020-01-10 10:39:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 10:39:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-06","2020-03-05","570"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 10:39:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6918",422,"SETTLED","A14-I207246","2020-01-10 10:39:26","2019-12-06","2","2020-01-10 10:39:26","2","2020-01-10 10:39:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 10:39:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7246","RENT","\u9810\u7e73\u79df\u91d1",1,1887,"MO","1",1887,"2","2020-01-10 10:39:26","2","2020-01-10 10:39:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 10:39:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7246","RENT","\u9810\u7e73\u79df\u91d1",2,1887,"MO","1",1887,"2","2020-01-10 10:39:26","2","2020-01-10 10:39:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 10:39:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7246","RENT","\u9810\u7e73\u79df\u91d1",3,1887,"MO","1",1887,"2","2020-01-10 10:39:26","2","2020-01-10 10:39:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 10:39:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5661,0,"7246"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-10 10:39:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[422,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206896","2020-01-10 10:39:26",5661,"2","2020-01-10 10:39:26","2","2020-01-10 10:39:26","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 10:39:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6896","DEPOSIT",null,"PAID","2020-01-10 10:39:26",0,"2","2020-01-10 10:39:26","2","2020-01-10 10:39:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 10:39:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6896","INVOICE","7246","PAID","2020-01-10 10:39:26",5661,"2","2020-01-10 10:39:26","2","2020-01-10 10:39:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 11:00:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 11:04:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 11:11:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 11:11:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 11:17:17","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":"1008","customer_code":"C181008","identity_type":"PERSONAL","identity_id":"K700926(7)","title":"Ms","lastname":"Cheng","firstname":"King","companyname":"","email":"dumpling_jing@hotmail.com","tel":"90989956","address":"FT F 60\/F Tower 2 , 38 Tai Hong Street, Grand Promenade , Sai Wan Ho, Hong Kong","pass":true,"customer_first_order":false},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1310.0","renew_rent_month":"12","renew_warehousing_date":"2019-11-09","renew_room_key":"'0012469943","renew_remark":"12 months contract. Special promotion extra 3 % discount offered, 2 months free of charge. Storage rental and deposit paid by EPS on 8 Nov 2018.1 pcs Smartcard provided on 8 Nov 2018. \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-102 4X5X6.5 $1115.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","floor_plan_rent_room":[{"room_id":"1408","master_room_id":"172","room_code":"C15-102"}],"roughly_size":"20","total_discounted_price":"1115.00","deposit":"2230.00","total_retail_price":"1115.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 11:17:17","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","1008","NEW","C15-CT206919",1115,1115,2230,0,"1","1",1049,3345,1049,"2020-01-10 11:17:17","0",null,null,null,"2020-01-10","2020-02-09","1 month contract. Change unit from C15-018 to C15-012. Deposit $1796 and remaining rental $500 transferred from agreement C15-CT206842 to this agreement. Remaining balance $1049 paid by PPS on Jan 08,2020.","2020-01-10","20",0,null,2296,"2296.00","2","2020-01-10 11:17:17","2","2020-01-10 11:17:17","PPS","","","","PPS","","","",null,0,"0005796877","C181008","PERSONAL","Ms","pyScVxHN1bAPGGa\/Bucd1Q==","UCPBCXrBLI9U7KKsPqgmNA==","","LoTfAY\/7hsJ5LMg1lxRl5U61+y\/bHOn3mXXs4ZtLiTsKgr3U0XtRwxPFeprq+NiHAM+QrB+m5+WZ7R14dzMxe+z0ciqodfk7L3bAksKmsSI=","ODUJ\/sh5I9t4EANm7+m4qQ==","IK6uRSfHgYDvM30SfvOBrVdAXD9E++uXhp1WOnqnMIk=","0n\/HYQ\/ulfaXU7JBtiiVDg==",null,1,3501]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 11:17:17","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":["6919","1408","1115.0","1115.00","2","2020-01-10 11:17:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 11:17:17","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-01-10","2020-02-09","1408"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 11:17:17","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":["6919","C15-D205244","PAID",2230,0,"2020-02-09","2020-01-10 11:17:17","2020-01-10 11:17:17","2","2020-01-10 11:17:17","2","2020-01-10 11:17:17","1008"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 11:17:17","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":["6919","1008","SETTLED","C15-I207247","2020-01-10 11:17:17","2020-01-10","2","2020-01-10 11:17:17","2","2020-01-10 11:17:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 11:17:17","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":["7247","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-01-10 11:17:17","2","2020-01-10 11:17:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 11:17:17","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[0,0,"7247"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-10 11:17:17","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":["1008","PPS","","","","PPS","","","","PAID","P206897","2020-01-10 11:17:17",2230,"2","2020-01-10 11:17:17","2","2020-01-10 11:17:17","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 11:17:17","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":["6897","DEPOSIT","5244","PAID","2020-01-10 11:17:17",2230,"2","2020-01-10 11:17:17","2","2020-01-10 11:17:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 11:17:17","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":["6897","INVOICE","7247","PAID","2020-01-10 11:17:17",0,"2","2020-01-10 11:17:17","2","2020-01-10 11:17:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 11:19:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 11:19:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 12:13:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 12:24:51","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 12:36:56","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[],"index_url_parameter":"filter1=2&filter2=1470&filter3=undefined","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":"0","customer_id":"653","customer_code":"C170653","identity_type":"PERSONAL","identity_id":"K322524(0)","title":"Mrs","lastname":"Wong ","firstname":"Siu Chun ","companyname":"","email":"jacscwong@gmail.com","tel":"98311166","address":"Flat 2, 4\/F, Kong Wing Court, 15 Nam Ning Street, Aberdeen ","pass":true,"customer_first_order":false},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"6","renew_warehousing_date":"2019-11-18","renew_room_key":"054,03671,055,13304","renew_remark":"6 months contract. Storage rental paid by cheque deposit on May 22, 2019. Storage deposit $1856 transferred from agreement A12-CT183590 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195057, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"1501","room_code":"A16-010","retail_price":"738.0","discounted_price":"738.00","location_id":"7"}],"roughly_size":"15","total_retail_price":738,"total_discounted_price":665,"deposit":1476,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":9456,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"665.00","warehousing_date":"2020-01-09","rent_from":"2020-01-09","rent_to":"2021-02-08","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by EPS on September 28, 2019. Smartcard and padlock provided on Jan 09,2020.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":665,"order_total":10121,"final_order_total":9456,"location_id":"7","branch_id":"1","company_id":"1","room_key":"076,32259; 052,25988","order_product":[],"pass":true}},"first_order_id":"3590","selected_room_tr":"\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\t\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\t\t\t\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>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> \n\t\t\t\t\tA16-010 5X3X3.5 $738.00 - <\/td> <\/td> \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"15","total_discounted_price":"665.00","deposit":"1476.00","total_retail_price":"738.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 12:36:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","7","653","NEW","A16-CT206920",738,665,1476,0,"13","13",9456,10121,9456,"2020-01-10 12:36:57","0",null,null,null,"2020-01-09","2021-02-08","13 months contract. Special offer the 13th month free. Storage rental paid by EPS on September 28, 2019. Smartcard and padlock provided on Jan 09,2020.","2020-01-09","15",0,null,665,"665.00","2","2020-01-10 12:36:56","2","2020-01-10 12:36:56","EPS","","","","EPS","","","",null,0,"076,32259; 052,25988","C170653","PERSONAL","Mrs","XYmGo+kQrfrGc4ybK\/\/4XA==","DgLsCGM4faTvgwjKBW9M0A==","","F+zb0OMs9N0Pw3e2u97v+tX5cMubCMB+j5IDqMef6hCbDiS6\/dXSqNIwjRENAqFJbhk9KB\/ZnzBjxz4N6Ng71Q==","wis2r1rRtEjXeyH1F2CqyA==","LFWYOrP+Ym\/Ttzfyc03PPoB10k99Wn+qh837HbkgLsY=","ebVUszbiOmN0CDPJ\/S0uNw==",null,1,"3590"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 12:36:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6920","1501","738.0","738.00","2","2020-01-10 12:36:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 12:36:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-09","2021-02-08","1501"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 12:36:57","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":["6920","A16-D205245","PAID",1476,0,"2021-02-08","2020-01-10 12:36:56","2020-01-10 12:36:56","2","2020-01-10 12:36:56","2","2020-01-10 12:36:56","653"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 12:36:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6920","653","SETTLED","A16-I207248","2020-01-10 12:36:56","2020-01-09","2","2020-01-10 12:36:56","2","2020-01-10 12:36:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 12:36:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7248","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,665,"MO","1",665,"2","2020-01-10 12:36:56","2","2020-01-10 12:36:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 12:36:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7248","RENT","\u9810\u7e73\u79df\u91d1",3,665,"MO","1",665,"2","2020-01-10 12:36:56","2","2020-01-10 12:36:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 12:36:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7248","RENT","\u9810\u7e73\u79df\u91d1",4,665,"MO","1",665,"2","2020-01-10 12:36:56","2","2020-01-10 12:36:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 12:36:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7248","RENT","\u9810\u7e73\u79df\u91d1",5,665,"MO","1",665,"2","2020-01-10 12:36:56","2","2020-01-10 12:36:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 12:36:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7248","RENT","\u9810\u7e73\u79df\u91d1",6,665,"MO","1",665,"2","2020-01-10 12:36:56","2","2020-01-10 12:36:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 12:36:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7248","RENT","\u9810\u7e73\u79df\u91d1",7,665,"MO","1",665,"2","2020-01-10 12:36:56","2","2020-01-10 12:36:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 12:36:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7248","RENT","\u9810\u7e73\u79df\u91d1",8,665,"MO","1",665,"2","2020-01-10 12:36:56","2","2020-01-10 12:36:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 12:36:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7248","RENT","\u9810\u7e73\u79df\u91d1",9,665,"MO","1",665,"2","2020-01-10 12:36:56","2","2020-01-10 12:36:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 12:36:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7248","RENT","\u9810\u7e73\u79df\u91d1",10,665,"MO","1",665,"2","2020-01-10 12:36:56","2","2020-01-10 12:36:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 12:36:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7248","RENT","\u9810\u7e73\u79df\u91d1",11,665,"MO","1",665,"2","2020-01-10 12:36:56","2","2020-01-10 12:36:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 12:36:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7248","RENT","\u9810\u7e73\u79df\u91d1",12,665,"MO","1",665,"2","2020-01-10 12:36:56","2","2020-01-10 12:36:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 12:36:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7248","RENT","\u9810\u7e73\u79df\u91d1",13,665,"MO","1",665,"2","2020-01-10 12:36:56","2","2020-01-10 12:36:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 12:36:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7980,0,"7248"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-10 12:36:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["653","EPS","","","","EPS","","","","PAID","P206898","2020-01-10 12:36:56",9456,"2","2020-01-10 12:36:56","2","2020-01-10 12:36:56","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 12:36:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6898","DEPOSIT","5245","PAID","2020-01-10 12:36:56",1476,"2","2020-01-10 12:36:56","2","2020-01-10 12:36:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 12:36:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6898","INVOICE","7248","PAID","2020-01-10 12:36:56",7980,"2","2020-01-10 12:36:56","2","2020-01-10 12:36:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 12:53:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 13:50:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 14:04:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 14:33:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 15:01:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 15:54:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:06:16","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ?, `customer_companyname` = ? where id = ?","parameters":["NEW","137,07952,055,49193","12 months contract. Storage rental paid by cheque deposit on January 27, 2019. Storage deposit transferred from agreement \tA18-CT182640 to this agreement. ","2020-01-10 16:06:16","2","7MHQbmSTFbHQHzh6p6CV5Q==","OrQj931TQBCDCPDic8UrYkjjgfIL+DO5MspqMw2Mf\/Q=","RKEw9xvsOWuqVLEVNo9RJg==","GdPhbDbjcMCV5J0cntY459hJPhgyRhRW2DRQbwDffXQ0fDAZ36\/u13OeOZrlNaY18I5au3aFANcWvtJLQtWdqQ==","Johnny Medical Service Company Limited",4257]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:09:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:32:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:34","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":97,"customer_code":"C160097","identity_type":"PERSONAL","identity_id":"Y063651(5)","title":"Mr","lastname":"Choi","firstname":"Andrew","companyname":"","email":"andrewsfchoi@gmail.com","tel":"91020791","address":"20B, 37 Braemar Hill Road, North Point, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"15200.0","renew_rent_month":"4","renew_warehousing_date":"2019-10-18","renew_room_key":"043,20603,137,03387,055,6448","renew_remark":"4 months contract. Storage rental paid by bank transfer on September 6, 2019. Storage deposit transferred from agreement A12-CT195042 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195896, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"272","room_code":"D76","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"271","room_code":"D75","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"270","room_code":"D74","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"269","room_code":"D73","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"268","room_code":"D72","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"267","room_code":"D71","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"266","room_code":"D70","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"265","room_code":"D69","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"264","room_code":"D68","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"263","room_code":"D67","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"261","room_code":"D65","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"260","room_code":"D64","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"259","room_code":"D63","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"258","room_code":"D62","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"257","room_code":"D61","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"256","room_code":"D60","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"255","room_code":"D59","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"254","room_code":"D58","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"253","room_code":"D57","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"252","room_code":"D56","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"240","total_retail_price":19960,"total_discounted_price":15200,"deposit":0,"rent_month":"4","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"4","prepaid_amount":60800,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-10-18","rent_from":"2019-10-18","rent_to":"2020-02-17","delivery_service":"0","remark":"4 months contract. Storage rental paid by bank transfer on January 8 and 10 2020. Storage deposit transferred from agreement A12-CT195896 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":60800,"final_order_total":60800,"location_id":"1","branch_id":"1","company_id":"1","room_key":"043,20603,137,03387,055,6448","order_product":[],"pass":true}},"first_order_id":"4130","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\tD76 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\tD75 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\tD74 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\tD73 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\tD72 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\tD71 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\tD70 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\tD69 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\tD68 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\tD67 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\tD65 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\tD64 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\tD63 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\tD62 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\tD61 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\tD60 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\tD59 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\tD58 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\tD57 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\tD56 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":"240","total_discounted_price":"15200.0","deposit":"0","total_retail_price":"19960.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",97,"NEW","A12-CT206921",19960,15200,0,0,"4","4",60800,60800,60800,"2020-01-10 16:45:35","0",null,null,null,"2019-10-18","2020-02-17","4 months contract. Storage rental paid by bank transfer on January 8 and 10 2020. Storage deposit transferred from agreement A12-CT195896 to this agreement.\r\n","2019-10-18","240",0,null,0,"0","2","2020-01-10 16:45:34","2","2020-01-10 16:45:34","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"043,20603,137,03387,055,6448","C160097","PERSONAL","Mr","2FxALZl389hi2eIQ+u33ig==","CjNWoAe1K\/KTKwcji6SOMg==","","i4L8z+rv3JjyiIv2LYYfFaOJ4dqV1lw2r9Kp4WhgCsBRUV1Ck7hyWkNSsohbarfN","H2cTR3+cOfJjWRrw2IG3hg==","5WYwf2j8jjfvxTL8q0ig5ZlqK4mxm1Z+Ubiqy0xvAt4=","ad09OO\/i1v3fLxe7sXwbDg==",null,1,"4130"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6921","272","998.0","998.00","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-18","2020-02-17","272"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6921","271","998.0","998.00","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-18","2020-02-17","271"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6921","270","998.0","998.00","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-18","2020-02-17","270"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6921","269","998.0","998.00","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-18","2020-02-17","269"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6921","268","998.0","998.00","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-18","2020-02-17","268"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6921","267","998.0","998.00","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-18","2020-02-17","267"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6921","266","998.0","998.00","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-18","2020-02-17","266"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6921","265","998.0","998.00","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-18","2020-02-17","265"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6921","264","998.0","998.00","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-18","2020-02-17","264"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6921","263","998.0","998.00","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-18","2020-02-17","263"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6921","261","998.0","998.00","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-18","2020-02-17","261"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6921","260","998.0","998.00","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-18","2020-02-17","260"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6921","259","998.0","998.00","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-18","2020-02-17","259"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6921","258","998.0","998.00","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-18","2020-02-17","258"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6921","257","998.0","998.00","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-18","2020-02-17","257"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6921","256","998.0","998.00","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-18","2020-02-17","256"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6921","255","998.0","998.00","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-18","2020-02-17","255"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6921","254","998.0","998.00","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-18","2020-02-17","254"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6921","253","998.0","998.00","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-18","2020-02-17","253"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6921","252","998.0","998.00","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-18","2020-02-17","252"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6921",97,"SETTLED","A12-I207249","2020-01-10 16:45:34","2019-10-18","2","2020-01-10 16:45:34","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7249","RENT","\u9810\u7e73\u79df\u91d1",1,15200,"MO","1",15200,"2","2020-01-10 16:45:34","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7249","RENT","\u9810\u7e73\u79df\u91d1",2,15200,"MO","1",15200,"2","2020-01-10 16:45:34","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7249","RENT","\u9810\u7e73\u79df\u91d1",3,15200,"MO","1",15200,"2","2020-01-10 16:45:34","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7249","RENT","\u9810\u7e73\u79df\u91d1",4,15200,"MO","1",15200,"2","2020-01-10 16:45:34","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[60800,0,"7249"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[97,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206899","2020-01-10 16:45:34",60800,"2","2020-01-10 16:45:34","2","2020-01-10 16:45:34","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6899","DEPOSIT",null,"PAID","2020-01-10 16:45:34",0,"2","2020-01-10 16:45:34","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:45:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6899","INVOICE","7249","PAID","2020-01-10 16:45:34",60800,"2","2020-01-10 16:45:34","2","2020-01-10 16:45:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:49:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:51:47","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"filter1=1&filter2=651&filter3=undefined","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":651,"customer_code":"C170651","identity_type":"PERSONAL","identity_id":"K519984(0)","title":"Ms","lastname":"Kwok","firstname":"Yuk Yu","companyname":"","email":"phillisk@gmail.com","tel":"93395942","address":"Room 3, 33\/F, Block A, Abba House, 225 Aberdeen Main Road, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1136.0","renew_rent_month":"3","renew_warehousing_date":"2020-01-02","renew_room_key":"054,63071","renew_remark":"3 months contract. Storage rental paid by PPS on October 8, 2019. Storage deposit transferred from agreement A18-CT195408 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196099, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"88","order_discount":[],"order_room":[{"room_id":"944","room_code":"V18","retail_price":"1195.0","discounted_price":"1195.00","location_id":"3"}],"roughly_size":"15","total_retail_price":1195,"total_discounted_price":1136,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3408,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-02","rent_from":"2020-01-02","rent_to":"2020-04-01","delivery_service":"0","remark":"3 months contract. Storage rental paid by PPS on January 7, 2020. Storage deposit transferred from agreement A18-CT196099 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":3408,"final_order_total":3408,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,63071","order_product":[],"pass":true}},"first_order_id":"4729","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\tV18 5X3X7 $1195.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":"15","total_discounted_price":"1136.0","deposit":"0","total_retail_price":"1195.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:51:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",651,"NEW","A18-CT206922",1195,1136,0,0,"3","3",3408,3408,3408,"2020-01-10 16:51:48","0",null,null,null,"2020-01-02","2020-04-01","3 months contract. Storage rental paid by PPS on January 7, 2020. Storage deposit transferred from agreement A18-CT196099 to this agreement.","2020-01-02","15",0,null,0,"0","2","2020-01-10 16:51:47","2","2020-01-10 16:51:47","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,63071","C170651","PERSONAL","Ms","KZJPt0a6ls06m3jANRPDag==","+pNULpsInm3siHASV0hIrg==","","ovdzTCl8ZT584Np6tXtWHH0fRRp2MtMGwMM6YPyMF5c2Xw73+iacny9xWMAJzClitBD1418rgUMR\/4Q11Llqtp\/k1\/VZhf9zRkPgwZ9Nicc=","cqEgjeLlReqC0f1a1G04zQ==","yjm\/29FoIMR\/RuPM9wJOS3\/RCUdB09Onez5uqRINt6c=","Ogzk1vJWu2rjycascXXiGw==",null,1,"4729"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:51:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6922","944","1195.0","1195.00","2","2020-01-10 16:51:47"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:51:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-02","2020-04-01","944"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 16:51:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6922",651,"SETTLED","A18-I207250","2020-01-10 16:51:47","2020-01-02","2","2020-01-10 16:51:47","2","2020-01-10 16:51:47"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:51:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7250","RENT","\u9810\u7e73\u79df\u91d1",1,1136,"MO","1",1136,"2","2020-01-10 16:51:47","2","2020-01-10 16:51:47"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:51:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7250","RENT","\u9810\u7e73\u79df\u91d1",2,1136,"MO","1",1136,"2","2020-01-10 16:51:47","2","2020-01-10 16:51:47"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:51:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7250","RENT","\u9810\u7e73\u79df\u91d1",3,1136,"MO","1",1136,"2","2020-01-10 16:51:47","2","2020-01-10 16:51:47"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:51:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3408,0,"7250"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-10 16:51:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[651,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P206900","2020-01-10 16:51:47",3408,"2","2020-01-10 16:51:47","2","2020-01-10 16:51:47","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:51:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6900","DEPOSIT",null,"PAID","2020-01-10 16:51:47",0,"2","2020-01-10 16:51:47","2","2020-01-10 16:51:47"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:51:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6900","INVOICE","7250","PAID","2020-01-10 16:51:47",3408,"2","2020-01-10 16:51:47","2","2020-01-10 16:51:47"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:57:22","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"filter1=1&filter2=651&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1369,"customer_code":"C191369","identity_type":"PERSONAL","identity_id":"K168595(3)","title":"Ms","lastname":"Lam","firstname":"Chak Yan Jessie Teresa","companyname":"","email":"jessielam98@yahoo.com","tel":"90249982","address":"Flat G, 39\/F, Block 10, Park Central, 9 Tong Tak St, Tseung Kwan O, New Territories","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1636.0","renew_rent_month":"3","renew_warehousing_date":"2019-11-17","renew_room_key":"0012400828","renew_remark":"3 months contract. Storage rental and deposit paid by cash on August 17, 2019. Smartcard provided on August 17, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT195735, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $3444.0","renew_master_room_id":"144","order_discount":[{"master_room_discount_id":"321","master_room_id":"144","discount_type":"%","price":"1722.00","disocunted_price":"1635.90","discount":"5.00","monthly_deduct":86.1,"room_id":"1245","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1245","room_code":"B01-055","retail_price":"1722.0","discounted_price":1635.9,"location_id":"5"}],"roughly_size":"28","total_retail_price":1722,"total_discounted_price":1636,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":4908,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-17","rent_from":"2019-11-17","rent_to":"2020-02-16","delivery_service":"0","remark":"3 months contract. Storage rental paid by PPS on January 7, 2020. Storage deposit $3444 transferred from agreement B01-CT195735 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":4908,"final_order_total":4908,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0012400828","order_product":[],"pass":true}},"first_order_id":5735,"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\tB01-055 4X7X7 $1722.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":"1636.0","deposit":"0","total_retail_price":"1722.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:57:23","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","2","5",1369,"NEW","B01-CT206923",1722,1636,0,0,"3","3",4908,4908,4908,"2020-01-10 16:57:23","0",null,null,null,"2019-11-17","2020-02-16","3 months contract. Storage rental paid by PPS on January 7, 2020. Storage deposit $3444 transferred from agreement B01-CT195735 to this agreement. ","2019-11-17","28",0,null,0,"0","2","2020-01-10 16:57:22","2","2020-01-10 16:57:22","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0012400828","C191369","PERSONAL","Ms","jK0sLQIokMTYV3ZXRP7RRXDjgJo6nAphSESGZHss\/8U=","0JxYUqbNPOvgfMwVa0l0NA==","","pTmVYn+9+08jSfjkrAQ930uwUJzZ7GoK3+66lfew+t\/0fxR9nqTrYogXakd2cb9Sk2zdmyu\/qWeMNreBPl1p7XP\/HNblMsLwTfHvYfY+z2iPqem7sllCAATFp9Gnw3Iz","oV5+sNO0lE615GWj8tpo0Q==","kejhjXk8xC0HdcA9K5VT+zQSSUKUT3H1mkDxQhBuRjw=","VerPwfNhcgk\/G01dKO+a8A==",null,1,5735]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:57:23","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":["6923","321","144","1245","%","5.00",86.1,"2","2020-01-10 16:57:22"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:57:23","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":["6923","1245","1722.0",1635.9,"2","2020-01-10 16:57:22"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:57:23","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":["2019-11-17","2020-02-16","1245"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 16:57:23","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":["6923",1369,"SETTLED","B01-I207251","2020-01-10 16:57:22","2019-11-17","2","2020-01-10 16:57:22","2","2020-01-10 16:57:22"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:57:23","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":["7251","RENT","\u9810\u7e73\u79df\u91d1",1,1636,"MO","1",1636,"2","2020-01-10 16:57:22","2","2020-01-10 16:57:22"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:57:23","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":["7251","RENT","\u9810\u7e73\u79df\u91d1",2,1636,"MO","1",1636,"2","2020-01-10 16:57:22","2","2020-01-10 16:57:22"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:57:23","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":["7251","RENT","\u9810\u7e73\u79df\u91d1",3,1636,"MO","1",1636,"2","2020-01-10 16:57:22","2","2020-01-10 16:57:22"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:57:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4908,0,"7251"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-10 16:57:23","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":[1369,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P206901","2020-01-10 16:57:22",4908,"2","2020-01-10 16:57:22","2","2020-01-10 16:57:22","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:57:23","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":["6901","DEPOSIT",null,"PAID","2020-01-10 16:57:22",0,"2","2020-01-10 16:57:22","2","2020-01-10 16:57:22"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 16:57:23","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":["6901","INVOICE","7251","PAID","2020-01-10 16:57:22",4908,"2","2020-01-10 16:57:22","2","2020-01-10 16:57:22"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:01:07","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1272,"customer_code":"C191272","identity_type":"PERSONAL","identity_id":"D037112(3)","title":"Mr","lastname":"Wen","firstname":"Kung Kit","companyname":"","email":"alanw@berkswick.com.hk","tel":"94841155","address":"8\/F, Jade House, 47C Stubbs Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"7965.0","renew_rent_month":"2","renew_warehousing_date":"2020-01-22","renew_room_key":"076,32309,076,34777","renew_remark":"2 months deposit. Storage rental paid by bank transfer on November 29, 2019. Storage deposit $15930 transferred from agreement A16-CT195001 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT196766, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"215","order_discount":[],"order_room":[{"room_id":"1640","room_code":"A16-149","retail_price":"2655.0","discounted_price":"2655.00","location_id":"7"},{"room_id":"1639","room_code":"A16-148","retail_price":"2655.0","discounted_price":"2655.00","location_id":"7"},{"room_id":"1637","room_code":"A16-146","retail_price":"2655.0","discounted_price":"2655.00","location_id":"7"}],"roughly_size":"105","total_retail_price":7965,"total_discounted_price":7965,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":7965,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-22","rent_from":"2020-01-22","rent_to":"2020-02-21","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 10, 2020. Storage deposit $15930 transferred from agreement A16-CT196766 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":7965,"final_order_total":7965,"location_id":"7","branch_id":"1","company_id":"1","room_key":"076,32309,076,34777","order_product":[],"pass":true}},"first_order_id":"5001","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\tA16-149 5X7X7 $2655.00 N\/A <\/td> \u9810\u4ed812\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\tA16-148 5X7X7 $2655.00 N\/A <\/td> \u9810\u4ed812\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\tA16-146 5X7X7 $2655.00 N\/A <\/td> \u9810\u4ed812\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"105","total_discounted_price":"7965.00","deposit":"0.00","total_retail_price":"7965.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:01:07","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","7",1272,"NEW","A16-CT206924",7965,7965,0,0,"1","1",7965,7965,7965,"2020-01-10 17:01:07","0",null,null,null,"2020-01-22","2020-02-21","1 month contract. Storage rental paid by bank transfer on January 10, 2020. Storage deposit $15930 transferred from agreement A16-CT196766 to this agreement. \r\n","2020-01-22","105",0,null,0,"0","2","2020-01-10 17:01:07","2","2020-01-10 17:01:07","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,32309,076,34777","C191272","PERSONAL","Mr","5yHI1OrI3jP1fHk6WMQJzQ==","p4JywTf1\/0TJX08VPtGmtA==","","auQltLH+RaRzeqbXMpVO9q3a8pWRYuoNR711jhONrrJgy8Hl3NzJwzVu2+7bgGOw","FIJj6HVSEufhFOUGXjlfgA==","wPVw2D2eb7Y+t\/KyTQ8Kw8rTyyU2\/csMiv1Qy+fvDVA=","83nBRHGiDiwO\/0E4dwcPKQ==",null,1,"5001"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:01:07","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":["6924","1640","2655.0","2655.00","2","2020-01-10 17:01:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:01:07","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-01-22","2020-02-21","1640"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 17:01:07","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":["6924","1639","2655.0","2655.00","2","2020-01-10 17:01:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:01:07","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-01-22","2020-02-21","1639"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 17:01:07","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":["6924","1637","2655.0","2655.00","2","2020-01-10 17:01:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:01:07","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-01-22","2020-02-21","1637"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 17:01:07","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":["6924",1272,"SETTLED","A16-I207252","2020-01-10 17:01:07","2020-01-22","2","2020-01-10 17:01:07","2","2020-01-10 17:01:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:01:07","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":["7252","RENT","\u9810\u7e73\u79df\u91d1",1,7965,"MO","1",7965,"2","2020-01-10 17:01:07","2","2020-01-10 17:01:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:01:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7965,0,"7252"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-10 17:01:07","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":[1272,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206902","2020-01-10 17:01:07",7965,"2","2020-01-10 17:01:07","2","2020-01-10 17:01:07","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:01:07","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":["6902","DEPOSIT",null,"PAID","2020-01-10 17:01:07",0,"2","2020-01-10 17:01:07","2","2020-01-10 17:01:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:01:07","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":["6902","INVOICE","7252","PAID","2020-01-10 17:01:07",7965,"2","2020-01-10 17:01:07","2","2020-01-10 17:01:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:06:39","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"filter1=1&filter2=651&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1157,"customer_code":"C181157","identity_type":"PERSONAL","identity_id":"G699464","title":"Ms","lastname":"Chan","firstname":"Hou Kiu","companyname":"","email":"qc_chan@yahoo.com.hk","tel":"92211121","address":"Flat 13H, Kwun Fung Mansion , Lei King Wan , 51 Tai Hong Street","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"608.0","renew_rent_month":"12","renew_warehousing_date":"2020-01-16","renew_room_key":"'0006046698","renew_remark":"12 months contract. Special promotion offered, 2 months free of charge and \u8f49\u5009\u512a\u60e0-$400 .Storage rental and deposit paid by EPS on 22 Dec 2018. 1 pcs Free Smartcard provided on 22 Dec 2018. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT183976, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $810.0","renew_master_room_id":"167","order_discount":[{"master_room_discount_id":"407","master_room_id":"167","discount_type":"%","price":"810.00","disocunted_price":"608.80","discount":"24.84","monthly_deduct":201.204,"room_id":"1327","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1327","room_code":"C15-021","retail_price":"810.0","discounted_price":608.8,"location_id":"6"}],"roughly_size":"12","total_retail_price":810,"total_discounted_price":729,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":4374,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-16","rent_from":"2020-01-16","rent_to":"2020-07-15","delivery_service":"0","remark":"6 months contract. Storage rental paid by PPS on January 9, 2020. Storage deposit $810 transferred from agreement C15-CT183976 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":4374,"final_order_total":4374,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0006046698","order_product":[],"pass":true}},"first_order_id":3976,"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-021 4X3X6.5 $810.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"729.00","deposit":"0.00","total_retail_price":"810.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:06:39","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",1157,"NEW","C15-CT206925",810,729,0,0,"6","6",4374,4374,4374,"2020-01-10 17:06:39","0",null,null,null,"2020-01-16","2020-07-15","6 months contract. Storage rental paid by PPS on January 9, 2020. Storage deposit $810 transferred from agreement C15-CT183976 to this agreement. \r\n","2020-01-16","12",0,null,0,"0","2","2020-01-10 17:06:39","2","2020-01-10 17:06:39","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"'0006046698","C181157","PERSONAL","Ms","\/9Y9q9Vjm8r37vnUk907rw==","U9yoE9KqV1v8YlRkf7Q2yg==","","0ggGwUHn6ZEpZgGnnZ7cjw16Lz4cWOSDblsk417YNILFGhlHChvUGbRDi3J7aTewgdngyUP\/SdaSqvoWwJQ75A==","H\/j32m92QFVsyaRlh34lJg==","zvHHd\/L1hbB8JR0Hgx+vu8AeEb31l2NE8YAMUieL0+0=","6PCLYmU7IEsQj8K\/igQJ7Q==",null,1,3976]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:06:39","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":["6925","407","167","1327","%","24.84",201.204,"2","2020-01-10 17:06:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:06:39","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":["6925","1327","810.0",608.8,"2","2020-01-10 17:06:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:06:39","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-01-16","2020-07-15","1327"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 17:06:39","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":["6925",1157,"SETTLED","C15-I207253","2020-01-10 17:06:39","2020-01-16","2","2020-01-10 17:06:39","2","2020-01-10 17:06:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:06:39","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":["7253","RENT","\u9810\u7e73\u79df\u91d1",1,729,"MO","1",729,"2","2020-01-10 17:06:39","2","2020-01-10 17:06:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:06:39","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":["7253","RENT","\u9810\u7e73\u79df\u91d1",2,729,"MO","1",729,"2","2020-01-10 17:06:39","2","2020-01-10 17:06:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:06:39","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":["7253","RENT","\u9810\u7e73\u79df\u91d1",3,729,"MO","1",729,"2","2020-01-10 17:06:39","2","2020-01-10 17:06:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:06:39","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":["7253","RENT","\u9810\u7e73\u79df\u91d1",4,729,"MO","1",729,"2","2020-01-10 17:06:39","2","2020-01-10 17:06:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:06:39","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":["7253","RENT","\u9810\u7e73\u79df\u91d1",5,729,"MO","1",729,"2","2020-01-10 17:06:39","2","2020-01-10 17:06:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:06:39","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":["7253","RENT","\u9810\u7e73\u79df\u91d1",6,729,"MO","1",729,"2","2020-01-10 17:06:39","2","2020-01-10 17:06:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:06:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4374,0,"7253"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-10 17:06:39","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":[1157,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P206903","2020-01-10 17:06:39",4374,"2","2020-01-10 17:06:39","2","2020-01-10 17:06:39","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:06:39","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":["6903","DEPOSIT",null,"PAID","2020-01-10 17:06:39",0,"2","2020-01-10 17:06:39","2","2020-01-10 17:06:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:06:39","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":["6903","INVOICE","7253","PAID","2020-01-10 17:06:39",4374,"2","2020-01-10 17:06:39","2","2020-01-10 17:06:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:08:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:14:56","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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1272,"customer_code":"C191272","identity_type":"PERSONAL","identity_id":"D037112(3)","title":"Mr","lastname":"Wen","firstname":"Kung Kit","companyname":"","email":"alanw@berkswick.com.hk","tel":"94841155","address":"8\/F, Jade House, 47C Stubbs Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3180.0","renew_rent_month":"2","renew_warehousing_date":"2020-01-22","renew_room_key":"076,32309,076,34777","renew_remark":"2 months contact. Storage rental paid by bank transfer on November 29, 2019. Storage deposit $6360 transferred from agreement A16-CT195065 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT196764, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"220","order_discount":[],"order_room":[{"room_id":"1641","room_code":"A16-150","retail_price":"3180.0","discounted_price":"3180.00","location_id":"7"}],"roughly_size":"42","total_retail_price":3180,"total_discounted_price":3180,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":3180,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-22","rent_from":"2020-01-22","rent_to":"2020-02-21","delivery_service":"0","remark":"1 months contact. Storage rental paid by bank transfer on January 10, 2020. Storage deposit $6360 transferred from agreement A16-CT196764 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3180,"final_order_total":3180,"location_id":"7","branch_id":"1","company_id":"1","room_key":"076,32309,076,34777","order_product":[],"pass":true}},"first_order_id":"5065","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\tA16-150 6X7X7 $3180.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":"42","total_discounted_price":"3180.00","deposit":"0.00","total_retail_price":"3180.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:14:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","7",1272,"NEW","A16-CT206926",3180,3180,0,0,"1","1",3180,3180,3180,"2020-01-10 17:14:57","0",null,null,null,"2020-01-22","2020-02-21","1 months contact. Storage rental paid by bank transfer on January 10, 2020. Storage deposit $6360 transferred from agreement A16-CT196764 to this agreement. ","2020-01-22","42",0,null,0,"0","2","2020-01-10 17:14:56","2","2020-01-10 17:14:56","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,32309,076,34777","C191272","PERSONAL","Mr","5yHI1OrI3jP1fHk6WMQJzQ==","p4JywTf1\/0TJX08VPtGmtA==","","auQltLH+RaRzeqbXMpVO9q3a8pWRYuoNR711jhONrrJgy8Hl3NzJwzVu2+7bgGOw","FIJj6HVSEufhFOUGXjlfgA==","wPVw2D2eb7Y+t\/KyTQ8Kw8rTyyU2\/csMiv1Qy+fvDVA=","83nBRHGiDiwO\/0E4dwcPKQ==",null,1,"5065"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:14:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6926","1641","3180.0","3180.00","2","2020-01-10 17:14:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:14:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-22","2020-02-21","1641"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 17:14:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6926",1272,"SETTLED","A16-I207254","2020-01-10 17:14:56","2020-01-22","2","2020-01-10 17:14:56","2","2020-01-10 17:14:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:14:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7254","RENT","\u9810\u7e73\u79df\u91d1",1,3180,"MO","1",3180,"2","2020-01-10 17:14:56","2","2020-01-10 17:14:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:14:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3180,0,"7254"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-10 17:14:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1272,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206904","2020-01-10 17:14:56",3180,"2","2020-01-10 17:14:56","2","2020-01-10 17:14:56","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:14:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6904","DEPOSIT",null,"PAID","2020-01-10 17:14:56",0,"2","2020-01-10 17:14:56","2","2020-01-10 17:14:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:14:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6904","INVOICE","7254","PAID","2020-01-10 17:14:56",3180,"2","2020-01-10 17:14:56","2","2020-01-10 17:14:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:19:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:28:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 17:46:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 18:41:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 19:02:46","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"type=INVOICE","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1274,"customer_code":"C191274","identity_type":"PERSONAL","identity_id":"K628182(6)","title":"Mr","lastname":"WONG","firstname":"Ho Fung Alastair","companyname":"","email":"kworca2@yahoo.com.hk","tel":"93886951","address":"Flat 1707, Block 9, Heng Fa Chuen, Chai Wan, HK","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1053.0","renew_rent_month":"3","renew_warehousing_date":"2019-12-01","renew_room_key":"'0012387151","renew_remark":"3 months contract. Storage rental paid by cash on September 18, 2019. Storage deposit $1108 transferred from agreement C15-CT195040 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT195976, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"170","order_discount":[],"order_room":[{"room_id":"1355","room_code":"C15-049","retail_price":"1108.0","discounted_price":"1108.00","location_id":"6"}],"roughly_size":"16","total_retail_price":1108,"total_discounted_price":1108,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":2216,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-01","rent_from":"2019-12-01","rent_to":"2020-01-31","delivery_service":"0","remark":"2 months contract. Storage rental paid by cash on January 10, 2020. Storage deposit $1108 transferred from agreement C15-CT195976 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":2216,"final_order_total":2216,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012387151","order_product":[],"pass":true}},"first_order_id":"5040","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-049 4X4X6.5 $1108.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":"1108.00","deposit":"0.00","total_retail_price":"1108.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 19:02:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1274,"NEW","C15-CT206927",1108,1108,0,0,"2","2",2216,2216,2216,"2020-01-10 19:02:46","0",null,null,null,"2019-12-01","2020-01-31","2 months contract. Storage rental paid by cash on January 10, 2020. Storage deposit $1108 transferred from agreement C15-CT195976 to this agreement.","2019-12-01","16",0,null,0,"0","2","2020-01-10 19:02:46","2","2020-01-10 19:02:46","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"'0012387151","C191274","PERSONAL","Mr","vVW1z8GZlxuG7uBwhPoAB+LQf8j\/vSFoHdbqoY3SwDo=","ddrfzAYTmkL\/QNu3psjONQ==","","UycQTH9zCSoPKTvTvIsbf5ABu8M0uPs1S829Rlpymn+TfepzS\/z\/IIsXxdrBPRAC","q6xzCvHViDJ5kezBmImvsA==","O26+D0wug4NA7bff7KsT\/LtBPTVdXq+ptB1lo71O0DU=","cjeBGrcluVIUBb5SnqNvbA==",null,1,"5040"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 19:02: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":["6927","1355","1108.0","1108.00","2","2020-01-10 19:02:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 19:02: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":["2019-12-01","2020-01-31","1355"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 19:02: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":["6927",1274,"SETTLED","C15-I207255","2020-01-10 19:02:46","2019-12-01","2","2020-01-10 19:02:46","2","2020-01-10 19:02:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 19:02: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":["7255","RENT","\u9810\u7e73\u79df\u91d1",1,1108,"MO","1",1108,"2","2020-01-10 19:02:46","2","2020-01-10 19:02:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 19:02: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":["7255","RENT","\u9810\u7e73\u79df\u91d1",2,1108,"MO","1",1108,"2","2020-01-10 19:02:46","2","2020-01-10 19:02:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 19:02:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2216,0,"7255"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-10 19:02: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":[1274,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P206905","2020-01-10 19:02:46",2216,"2","2020-01-10 19:02:46","2","2020-01-10 19:02:46","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 19:02: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":["6905","DEPOSIT",null,"PAID","2020-01-10 19:02:46",0,"2","2020-01-10 19:02:46","2","2020-01-10 19:02:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 19:02: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":["6905","INVOICE","7255","PAID","2020-01-10 19:02:46",2216,"2","2020-01-10 19:02:46","2","2020-01-10 19:02:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 19:03:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 19:07:49","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"type=INVOICE&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1351","master_room_id":"177","room_code":"C15-045"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> \r\n\t\t\t\t\tC15-045 4.5X4X6.5 $1108.00 N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"K628182(6)","title":"Mr","lastname":"WONG","firstname":"Ho Fung Alastair","companyname":"","email":"kworca2@yahoo.com.hk","tel":"93886951","address":"Flat 1707, Block 9, Heng Fa Chuen, Chai Wan, HK","pass":true,"customer_id":"1274","customer_code":"C191274","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1351","room_code":"C15-045","retail_price":"1108.0","discounted_price":"1108.00","location_id":"6"}],"roughly_size":"18","total_retail_price":1108,"total_discounted_price":1053,"deposit":1108,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2865,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1402.00","warehousing_date":"2020-01-23","rent_from":"2020-01-23","rent_to":"2020-04-22","delivery_service":"0","remark":"3 months contract. Change unit from C15-049 to C15-045. Storage rental $294 and storage deposit $1108 to this agreement. Remaining balance $2865 paid by cash on January 10, 2020. ","paymethod":"CASH","paymethod2":"CASH","discount_deduct":1402,"order_total":4267,"final_order_total":2865,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012387151","order_product":[],"pass":true}},"roughly_size":"18","total_discounted_price":"1053.00","deposit":"1108.00","total_retail_price":"1108.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 19:07:49","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","1274","NEW","C15-CT206928",1108,1053,1108,0,"3","3",2865,4267,2865,"2020-01-10 19:07:49","0",null,null,null,"2020-01-23","2020-04-22","3 months contract. Change unit from C15-049 to C15-045. Storage rental $294 and storage deposit $1108 to this agreement. Remaining balance $2865 paid by cash on January 10, 2020. ","2020-01-23","18",0,null,1402,"1402.00","2","2020-01-10 19:07:49","2","2020-01-10 19:07:49","CASH","","","","CASH","","","",null,0,"'0012387151","C191274","PERSONAL","Mr","vVW1z8GZlxuG7uBwhPoAB+LQf8j\/vSFoHdbqoY3SwDo=","ddrfzAYTmkL\/QNu3psjONQ==","","UycQTH9zCSoPKTvTvIsbf5ABu8M0uPs1S829Rlpymn+TfepzS\/z\/IIsXxdrBPRAC","q6xzCvHViDJ5kezBmImvsA==","O26+D0wug4NA7bff7KsT\/LtBPTVdXq+ptB1lo71O0DU=","cjeBGrcluVIUBb5SnqNvbA==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 19:07:49","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":["6928","1351","1108.0","1108.00","2","2020-01-10 19:07:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 19:07:49","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-01-23","2020-04-22","1351"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-10 19:07:49","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":["6928","C15-D205246","PAID",1108,0,"2020-04-22","2020-01-10 19:07:49","2020-01-10 19:07:49","2","2020-01-10 19:07:49","2","2020-01-10 19:07:49","1274"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 19:07:49","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":["6928","1274","SETTLED","C15-I207256","2020-01-10 19:07:49","2020-01-23","2","2020-01-10 19:07:49","2","2020-01-10 19:07:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 19:07:49","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":["7256","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-01-10 19:07:49","2","2020-01-10 19:07:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 19:07:49","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":["7256","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,704,"MO","1",704,"2","2020-01-10 19:07:49","2","2020-01-10 19:07:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 19:07:49","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":["7256","RENT","\u9810\u7e73\u79df\u91d1",3,1053,"MO","1",1053,"2","2020-01-10 19:07:49","2","2020-01-10 19:07:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 19:07:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1757,0,"7256"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-10 19:07:49","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":["1274","CASH","","","","CASH","","","","PAID","P206906","2020-01-10 19:07:49",2865,"2","2020-01-10 19:07:49","2","2020-01-10 19:07:49","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 19:07:49","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":["6906","DEPOSIT","5246","PAID","2020-01-10 19:07:49",1108,"2","2020-01-10 19:07:49","2","2020-01-10 19:07:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 19:07:49","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":["6906","INVOICE","7256","PAID","2020-01-10 19:07:49",1757,"2","2020-01-10 19:07:49","2","2020-01-10 19:07:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-10 19:25:31","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****