\n \n \n\t\t\t\t\t

\u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n

\u5009\u5eab\u7de8\u865f<\/td>\n	\u5c3a\u5bf8<\/td>\n	\u539f\u50f9(\u6708)<\/td>\n	\u512a\u60e0\u50f9(\u6708)<\/td>\n	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n	\u50f9\u683c<\/td>\n	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n	<\/td>\n <\/tr>
A05-107 <\/td>\n\t\t\t\t\t	3X3X7 <\/td>\n\t\t\t\t\t	$1006.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"9","total_discounted_price":"775.00","deposit":"1550.00","total_retail_price":"1006.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:04:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201591","PERSONAL","Ms","ZzRtsket6p7WIKEqrfiAQw==","4zek2V6v+muRHEsNI7xEHw==","","tkk7JipvkALBtbkRIQYUNQ==",null,"GU0WdWCrYKPK486volxslnWZqyr77neYCAd3nV9wTMre7VqyAlyo0kSV4EyTmQvdeizJchNEWJgDXXOgcXOT0LE361GcEmWgnZYdnrz5iGA=","98R+Bul9n51nghJgWEZm6Q==",null,null,"tiagavflDhemfzmZG4rO6Q==","2","2020-05-25 16:04:51","2","2020-05-25 16:04:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:04:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","4",1591,"NEW","A05-CT207950",1006,775,1550,0,"13","13",9689,11625,9689,"2020-05-25 16:04:52","0",null,null,null,"2020-06-01","2021-06-30","13 months contract. Special offer the first 3 months 50% off and the 13th month Free. Storage rental and deposit paid by EPS on May 25, 2020. Smartcard and padlock provided on May 25, 2020. ","2020-06-01","9",0,null,1936,"1936.00","2","2020-05-25 16:04:51","2","2020-05-25 16:04:51","EPS","","","","EPS","","","",null,0,"'0005015309","C201591","PERSONAL","Ms","ZzRtsket6p7WIKEqrfiAQw==","4zek2V6v+muRHEsNI7xEHw==","","GU0WdWCrYKPK486volxslnWZqyr77neYCAd3nV9wTMre7VqyAlyo0kSV4EyTmQvdeizJchNEWJgDXXOgcXOT0LE361GcEmWgnZYdnrz5iGA=","tkk7JipvkALBtbkRIQYUNQ==",null,"98R+Bul9n51nghJgWEZm6Q==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:04:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7950","1109","1006.0","1006.00","2","2020-05-25 16:04:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:04:52","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2021-06-30","1109"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-25 16:04:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["7950","A05-D205427","PAID",1550,0,"2021-06-30","2020-05-25 16:04:51","2020-05-25 16:04:51","2","2020-05-25 16:04:51","2","2020-05-25 16:04:51",1591]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:04:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7950",1591,"SETTLED","A05-I208279","2020-05-25 16:04:51","2020-06-01","2","2020-05-25 16:04:51","2","2020-05-25 16:04:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:04:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8279","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-25 16:04:51","2","2020-05-25 16:04:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:04:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8279","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-05-25 16:04:51","2","2020-05-25 16:04:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:04:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8279","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,389,"MO","1",389,"2","2020-05-25 16:04:51","2","2020-05-25 16:04:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:04:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8279","RENT","\u9810\u7e73\u79df\u91d1",4,775,"MO","1",775,"2","2020-05-25 16:04:51","2","2020-05-25 16:04:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:04:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8279","RENT","\u9810\u7e73\u79df\u91d1",5,775,"MO","1",775,"2","2020-05-25 16:04:51","2","2020-05-25 16:04:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:04:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8279","RENT","\u9810\u7e73\u79df\u91d1",6,775,"MO","1",775,"2","2020-05-25 16:04:51","2","2020-05-25 16:04:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:04:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8279","RENT","\u9810\u7e73\u79df\u91d1",7,775,"MO","1",775,"2","2020-05-25 16:04:51","2","2020-05-25 16:04:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:04:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8279","RENT","\u9810\u7e73\u79df\u91d1",8,775,"MO","1",775,"2","2020-05-25 16:04:51","2","2020-05-25 16:04:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:04:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8279","RENT","\u9810\u7e73\u79df\u91d1",9,775,"MO","1",775,"2","2020-05-25 16:04:51","2","2020-05-25 16:04:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:04:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8279","RENT","\u9810\u7e73\u79df\u91d1",10,775,"MO","1",775,"2","2020-05-25 16:04:51","2","2020-05-25 16:04:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:04:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8279","RENT","\u9810\u7e73\u79df\u91d1",11,775,"MO","1",775,"2","2020-05-25 16:04:51","2","2020-05-25 16:04:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:04:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8279","RENT","\u9810\u7e73\u79df\u91d1",12,775,"MO","1",775,"2","2020-05-25 16:04:51","2","2020-05-25 16:04:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:04:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8279","RENT","\u9810\u7e73\u79df\u91d1",13,775,"MO","1",775,"2","2020-05-25 16:04:51","2","2020-05-25 16:04:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:04:52","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8139,0,"8279"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-25 16:04:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1591,"EPS","","","","EPS","","","","PAID","P207923","2020-05-25 16:04:51",9689,"2","2020-05-25 16:04:51","2","2020-05-25 16:04:51","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:04:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7923","DEPOSIT","5427","PAID","2020-05-25 16:04:51",1550,"2","2020-05-25 16:04:51","2","2020-05-25 16:04:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:04:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7923","INVOICE","8279","PAID","2020-05-25 16:04:51",8139,"2","2020-05-25 16:04:51","2","2020-05-25 16:04:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:23:44","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":"&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"Y633138(4)","title":"Mr","lastname":"FUNG","firstname":"Lok Hin","companyname":"","email":"tommyfung@live.hk","tel":"92615559","address":"Flat C, 18\/F, Block 6, Sun Tuen Mun Centre, Tuen Mun.","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"409 available_room_list_input","master_room_id":"162","discount_type":"%","price":"692.00","disocunted_price":"658.00","discount":"4.92","monthly_deduct":34.0464,"room_id":"1370","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1370","room_code":"C15-064","retail_price":"692.0","discounted_price":658,"location_id":"6"}],"roughly_size":"8","total_retail_price":692,"total_discounted_price":692,"deposit":692,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":1730,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1038.00","warehousing_date":"2020-06-10","rent_from":"2020-06-10","rent_to":"2020-09-09","delivery_service":"0","remark":"3 months contract. Special offer 50% off for the first contract. Storage rental, deposit and smartcard paid by bank transfer on May 25,2020.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":1038,"order_total":2828,"final_order_total":1790,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'191,03204","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"pass":true}},"selected_room_tr":"\n	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n	\n \n\n \n \n \n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> C15-064 <\/td>\n\t\t\t\t\t 4X2X6.5 <\/td>\n\t\t\t\t\t $692.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"8","total_discounted_price":"692.00","deposit":"692.00","total_retail_price":"692.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:23:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201592","PERSONAL","Mr","S5xItTrycw2fZBQdazUdXw==","cyZbjLKMtXmsqxQPpU0UpA==","","dAFn\/GpuYfOQfBoOT3SS+g==","4QY2lCqg1QB0APATQCRY9Ca7dPOIsA4YCSBkq0TXOjI=","W6q\/Ie4NTnXfb8CTwQtRDs\/2EsejF0oYQFKHICWpXKyjoA8SS8GIcjuCdPYDJGMR3EQs68sQv2mDcsHfH5u7nA==","uYMFDFwN0tfFU\/JYVvlYMw==",null,"4QY2lCqg1QB0APATQCRY9Ca7dPOIsA4YCSBkq0TXOjI=","6rnKZULa8EIg8kGjHU0uIg==","2","2020-05-25 16:23:44","2","2020-05-25 16:23:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:23:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","3","6",1592,"NEW","C15-CT207951",692,692,692,0,"3","3",1730,2828,1790,"2020-05-25 16:23:46","0",null,null,null,"2020-06-10","2020-09-09","3 months contract. Special offer 50% off for the first contract. Storage rental, deposit and smartcard paid by bank transfer on May 25,2020.","2020-06-10","8",0,null,1038,"1038.00","2","2020-05-25 16:23:44","2","2020-05-25 16:23:44","BANKIN","","","","BANKIN","","","",null,0,"'191,03204","C201592","PERSONAL","Mr","S5xItTrycw2fZBQdazUdXw==","cyZbjLKMtXmsqxQPpU0UpA==","","W6q\/Ie4NTnXfb8CTwQtRDs\/2EsejF0oYQFKHICWpXKyjoA8SS8GIcjuCdPYDJGMR3EQs68sQv2mDcsHfH5u7nA==","dAFn\/GpuYfOQfBoOT3SS+g==","4QY2lCqg1QB0APATQCRY9Ca7dPOIsA4YCSBkq0TXOjI=","uYMFDFwN0tfFU\/JYVvlYMw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:23:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["7951","409 available_room_list_input","162","1370","%","4.92",34.0464,"2","2020-05-25 16:23:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:23:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7951",1592,"11","1","60.0",60,"2","2020-05-25 16:23:44","2","2020-05-25 16:23:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:23:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"7951"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-05-25 16:23: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":["7951","1370","692.0",658,"2","2020-05-25 16:23:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:23:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-10","2020-09-09","1370"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-25 16:23:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["7951","C15-D205428","PAID",692,0,"2020-09-09","2020-05-25 16:23:44","2020-05-25 16:23:44","2","2020-05-25 16:23:44","2","2020-05-25 16:23:44",1592]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:23: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":["7951",1592,"SETTLED","C15-I208280","2020-05-25 16:23:44","2020-06-10","2","2020-05-25 16:23:44","2","2020-05-25 16:23:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:23: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":["8280","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-25 16:23:44","2","2020-05-25 16:23:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:23: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":["8280","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,346,"MO","1",346,"2","2020-05-25 16:23:44","2","2020-05-25 16:23:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:23: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":["8280","RENT","\u9810\u7e73\u79df\u91d1",3,692,"MO","1",692,"2","2020-05-25 16:23:44","2","2020-05-25 16:23:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:23:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8280","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-05-25 16:23:44","2","2020-05-25 16:23:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:23:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1098,0,"8280"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-25 16:23: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":[1592,"BANKIN","","","","BANKIN","","","","PAID","P207924","2020-05-25 16:23:44",1790,"2","2020-05-25 16:23:44","2","2020-05-25 16:23:44","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:23: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":["7924","DEPOSIT","5428","PAID","2020-05-25 16:23:44",692,"2","2020-05-25 16:23:44","2","2020-05-25 16:23:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:23: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":["7924","INVOICE","8280","PAID","2020-05-25 16:23:44",1098,"2","2020-05-25 16:23:44","2","2020-05-25 16:23:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 16:49:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 17:49:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 17:59:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 18:39: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":"filter1=2&filter2=1117&filter3=undefined","floor_plan_rent_room":[{"room_id":"919","master_room_id":"104","room_code":"U20"}],"_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\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\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\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 \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> U20 <\/td>\r\n\t\t\t\t\t 5X5X7 <\/td>\r\n\t\t\t\t\t $1930.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"K534935(4)","title":"Ms","lastname":"YEUNG","firstname":"Jenny Y.","companyname":"","email":"","tel":"91992981","address":"49 Seymour Road, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"919","room_code":"U20","retail_price":"1930.0","discounted_price":"1930.00","location_id":"3"}],"roughly_size":"25","total_retail_price":1930,"total_discounted_price":1610,"deposit":3220,"rent_month":"5","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"5","prepaid_amount":8855,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2415.00","warehousing_date":"2020-05-25","rent_from":"2020-05-25","rent_to":"2020-10-24","delivery_service":"0","remark":"5 months contract. Special offer the first 3 months 50% off. Storage deposit and rental paid by EPS on May 25, 2020.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":2415,"order_total":11270,"final_order_total":8855,"location_id":"3","branch_id":"1","company_id":"1","room_key":"076, 26141","order_product":[],"pass":true}},"roughly_size":"25","total_discounted_price":"1610.00","deposit":"3220.00","total_retail_price":"1930.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 18:39:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201593","PERSONAL","Ms","Sfe37aa7HKb6e6CYytAtrA==","cehTPCv0LSZ1f3zKZGLhBA==","","i9WBQSrsdapJV+oXgsD0ZQ==",null,"XLTmE33L+Rtp79976S177f33VWXhBGHC7IGjXX65vgc=","AycLT2AiiPL0sDp09olcwQ==",null,null,"W+81VGqsRgFBdyh3pBP1Gg==","2","2020-05-25 18:39:34","2","2020-05-25 18:39:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 18:39:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","3",1593,"NEW","A18-CT207952",1930,1610,3220,0,"5","5",8855,11270,8855,"2020-05-25 18:39:35","0",null,null,null,"2020-05-25","2020-10-24","5 months contract. Special offer the first 3 months 50% off. Storage deposit and rental paid by EPS on May 25, 2020.","2020-05-25","25",0,null,2415,"2415.00","2","2020-05-25 18:39:34","2","2020-05-25 18:39:34","EPS","","","","EPS","","","",null,0,"076, 26141","C201593","PERSONAL","Ms","Sfe37aa7HKb6e6CYytAtrA==","cehTPCv0LSZ1f3zKZGLhBA==","","XLTmE33L+Rtp79976S177f33VWXhBGHC7IGjXX65vgc=","i9WBQSrsdapJV+oXgsD0ZQ==",null,"AycLT2AiiPL0sDp09olcwQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 18:39: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":["7952","919","1930.0","1930.00","2","2020-05-25 18:39:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 18:39:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-25","2020-10-24","919"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-25 18:39:35","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":["7952","A18-D205429","PAID",3220,0,"2020-10-24","2020-05-25 18:39:34","2020-05-25 18:39:34","2","2020-05-25 18:39:34","2","2020-05-25 18:39:34",1593]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 18:39: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":["7952",1593,"SETTLED","A18-I208281","2020-05-25 18:39:34","2020-05-25","2","2020-05-25 18:39:34","2","2020-05-25 18:39:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 18:39: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":["8281","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-25 18:39:34","2","2020-05-25 18:39:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 18:39: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":["8281","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,805,"MO","1",805,"2","2020-05-25 18:39:34","2","2020-05-25 18:39:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 18:39: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":["8281","RENT","\u9810\u7e73\u79df\u91d1",3,1610,"MO","1",1610,"2","2020-05-25 18:39:34","2","2020-05-25 18:39:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 18:39: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":["8281","RENT","\u9810\u7e73\u79df\u91d1",4,1610,"MO","1",1610,"2","2020-05-25 18:39:34","2","2020-05-25 18:39:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 18:39: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":["8281","RENT","\u9810\u7e73\u79df\u91d1",5,1610,"MO","1",1610,"2","2020-05-25 18:39:34","2","2020-05-25 18:39:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 18:39:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5635,0,"8281"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-25 18:39: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":[1593,"EPS","","","","EPS","","","","PAID","P207925","2020-05-25 18:39:34",8855,"2","2020-05-25 18:39:34","2","2020-05-25 18:39:34","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 18:39: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":["7925","DEPOSIT","5429","PAID","2020-05-25 18:39:34",3220,"2","2020-05-25 18:39:34","2","2020-05-25 18:39:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 18:39: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":["7925","INVOICE","8281","PAID","2020-05-25 18:39:34",5635,"2","2020-05-25 18:39:34","2","2020-05-25 18:39:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 19:00:38","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":"&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":180,"customer_code":"C160180","identity_type":"PERSONAL","identity_id":"D455052(9)","title":"Ms","lastname":"Hong","firstname":"Lau Sui","companyname":"","email":"sandyaaa10@yahoo.com.hk","tel":"94141760","address":"\u5f69\u8679\u576a\u77f3\u6751\u9ec3\u77f3\u6a132029\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1231.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-25","renew_room_key":"0003611329","renew_remark":"6 months contract. Storage rental paid by bank transfer on Nov 22, 2019. Storage deposit $2796 transferred from agreement B01-CT195075 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT196495, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"143","order_discount":[{"master_room_discount_id":"325","master_room_id":"143","discount_type":"%","price":"1488.00","disocunted_price":"1091.90","discount":"26.62","monthly_deduct":396.1056,"room_id":"1265","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1265","room_code":"B01-075","retail_price":"1488.0","discounted_price":1091.9,"location_id":"5"}],"roughly_size":"24","total_retail_price":1488,"total_discounted_price":1231,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":7386,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-25","rent_from":"2020-05-25","rent_to":"2020-11-24","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on May 23,2020. Storage deposit $2796 transferred from agreement B01-CT196495 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":7386,"final_order_total":7386,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0003611329","order_product":[],"pass":true}},"first_order_id":"3657","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\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\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\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 \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> B01-075 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1488.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1231.0","deposit":"0","total_retail_price":"1488.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 19:00:38","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",180,"NEW","B01-CT207953",1488,1231,0,0,"6","6",7386,7386,7386,"2020-05-25 19:00:38","0",null,null,null,"2020-05-25","2020-11-24","6 months contract. Storage rental paid by bank transfer on May 23,2020. Storage deposit $2796 transferred from agreement B01-CT196495 to this agreement. ","2020-05-25","24",0,null,0,"0","2","2020-05-25 19:00:38","2","2020-05-25 19:00:38","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0003611329","C160180","PERSONAL","Ms","ERqx\/PkgUskw5\/ImaUW7GQ==","J7AHnwLqFVSF7LcuxIPXIg==","","mMYiAdWzYhb2raaIAajqA7IFDfoW7EgHeFQaIqHLk2c=","zOzvXeUzGXZI1Xu+gzeekQ==","hrPM5UzMYVDSKfENWURu5ZKk0KR+YnXFSUsiFwir\/6s=","w5ihmQ7AOcxj1hcRpdS7ig==",null,1,"3657"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 19:00:38","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":["7953","325","143","1265","%","26.62",396.1056,"2","2020-05-25 19:00:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 19:00:38","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":["7953","1265","1488.0",1091.9,"2","2020-05-25 19:00:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 19:00:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-25","2020-11-24","1265"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-25 19:00:38","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":["7953",180,"SETTLED","B01-I208282","2020-05-25 19:00:38","2020-05-25","2","2020-05-25 19:00:38","2","2020-05-25 19:00:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 19:00:38","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":["8282","RENT","\u9810\u7e73\u79df\u91d1",1,1231,"MO","1",1231,"2","2020-05-25 19:00:38","2","2020-05-25 19:00:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 19:00:38","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":["8282","RENT","\u9810\u7e73\u79df\u91d1",2,1231,"MO","1",1231,"2","2020-05-25 19:00:38","2","2020-05-25 19:00:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 19:00:38","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":["8282","RENT","\u9810\u7e73\u79df\u91d1",3,1231,"MO","1",1231,"2","2020-05-25 19:00:38","2","2020-05-25 19:00:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 19:00:38","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":["8282","RENT","\u9810\u7e73\u79df\u91d1",4,1231,"MO","1",1231,"2","2020-05-25 19:00:38","2","2020-05-25 19:00:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 19:00:38","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":["8282","RENT","\u9810\u7e73\u79df\u91d1",5,1231,"MO","1",1231,"2","2020-05-25 19:00:38","2","2020-05-25 19:00:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 19:00:38","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":["8282","RENT","\u9810\u7e73\u79df\u91d1",6,1231,"MO","1",1231,"2","2020-05-25 19:00:38","2","2020-05-25 19:00:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 19:00:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7386,0,"8282"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-25 19:00:38","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":[180,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207926","2020-05-25 19:00:38",7386,"2","2020-05-25 19:00:38","2","2020-05-25 19:00:38","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 19:00:38","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":["7926","DEPOSIT",null,"PAID","2020-05-25 19:00:38",0,"2","2020-05-25 19:00:38","2","2020-05-25 19:00:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 19:00:38","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":["7926","INVOICE","8282","PAID","2020-05-25 19:00:38",7386,"2","2020-05-25 19:00:38","2","2020-05-25 19:00:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 19:16:09","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1117&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"919","master_room_id":"104","room_code":"U20"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":835,"customer_code":"C180835","identity_type":"PERSONAL","identity_id":"Z785866(4)","title":"Mr","lastname":"Wong","firstname":"Ka Hei","companyname":"","email":"sai_56@hotmail.com","tel":"61288759","address":"Room 2501, Hoi Tsing Court, Aberdeen Centre, Aberdeen, Hong Kong ","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"986.0","renew_rent_month":"3","renew_warehousing_date":"2020-04-27","renew_room_key":"089,52338","renew_remark":"3 months contract. Storage rental paid by bank transfer on March 5, 2020. Storage deposit transferred from agreement A14-CT196641 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207335, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"728","room_code":"O04","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-27","rent_from":"2020-04-27","rent_to":"2020-05-26","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on May 25, 2020. Storage deposit transferred from agreement A14-CT207335 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"2","branch_id":"1","company_id":"1","room_key":"089,52338","order_product":[],"pass":true}},"first_order_id":"4316","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\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\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\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 \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> O04 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \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":"1038.00","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 19:16:10","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",835,"NEW","A14-CT207954",998,1038,0,0,"1","1",1038,1038,1038,"2020-05-25 19:16:10","0",null,null,null,"2020-04-27","2020-05-26","1 month contract. Storage rental paid by bank transfer on May 25, 2020. Storage deposit transferred from agreement A14-CT207335 to this agreement.\r\n","2020-04-27","12",0,null,0,"0","2","2020-05-25 19:16:09","2","2020-05-25 19:16:09","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"089,52338","C180835","PERSONAL","Mr","LFqFMec3FCZ8GhmGz5D8+g==","hULSwM2MvFtpeV9\/z+er8Q==","","YGGMv9qKSb2ZjuAc\/sccX3viQczI4UQgTDR1vnw1jZr1IsHI46aAzj8FoOEvmFBf3xid\/KPjKyMskq8nOAaxJP+T1Hiw+JblMx6sijbULuU=","WWWWtU89uJSFycKhvaRqjg==","ZsJ+TIjyArNzTB8u3qB6S4HXPjhNu85zzCV3p8sv97U=","+cVFuhdEwVJmEcDzIH6zTg==",null,1,"4316"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 19:16:10","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":["7954","728","998.0","998.00","2","2020-05-25 19:16:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 19:16:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-27","2020-05-26","728"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-25 19:16:10","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":["7954",835,"SETTLED","A14-I208283","2020-05-25 19:16:09","2020-04-27","2","2020-05-25 19:16:09","2","2020-05-25 19:16:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 19:16:10","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":["8283","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-05-25 19:16:09","2","2020-05-25 19:16:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 19:16:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"8283"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-25 19:16:10","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":[835,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207927","2020-05-25 19:16:09",1038,"2","2020-05-25 19:16:09","2","2020-05-25 19:16:09","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 19:16:10","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":["7927","DEPOSIT",null,"PAID","2020-05-25 19:16:09",0,"2","2020-05-25 19:16:09","2","2020-05-25 19:16:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-25 19:16:10","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":["7927","INVOICE","8283","PAID","2020-05-25 19:16:09",1038,"2","2020-05-25 19:16:09","2","2020-05-25 19:16:09"]},"data_before":[],"data_after":[],"step":1} *****