{"created_at":"2020-05-12 10:04:21","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":"all=1","floor_plan_rent_room":[{"room_id":"769","master_room_id":"52","room_code":"P03"},{"room_id":"778","master_room_id":"57","room_code":"P12"},{"room_id":"787","master_room_id":"63","room_code":"P21"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":57,"customer_code":"C160057","identity_type":"PERSONAL","identity_id":"D381525(1)","title":"Mr","lastname":"\u9127","firstname":"\u8000\u660e","companyname":"","email":null,"tel":"68489863","address":"\u9d28\u8137\u6d32\u5229\u6771\u90a8\u6771\u5e73\u645f1110\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-09","renew_room_key":"052,49830,076,49433","renew_remark":"1 month contract. Storage rental paid by bank transfer on April 11, 2020. Storage deposit transferred from agreement A14-CT207402 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207615, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"602","room_code":"M13","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-09","rent_from":"2020-06-09","rent_to":"2020-07-08","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on May 11, 2020. Storage deposit transferred from agreement A14-CT207615 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"052,49830,076,49433","order_product":[],"pass":true}},"first_order_id":"4958","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>
M13 <\/td>\r\n\t\t\t\t\t	4X3X4 <\/td>\r\n\t\t\t\t\t	$598.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	<\/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":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:04:22","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",57,"NEW","A14-CT207820",598,598,0,0,"1","1",598,598,598,"2020-05-12 10:04:22","0",null,null,null,"2020-06-09","2020-07-08","1 month contract. Storage rental paid by bank transfer on May 11, 2020. Storage deposit transferred from agreement A14-CT207615 to this agreement.\r\n","2020-06-09","12",0,null,0,"0","2","2020-05-12 10:04:21","2","2020-05-12 10:04:21","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,49830,076,49433","C160057","PERSONAL","Mr","GHEZv6RA43AKRnpR7gdqTA==","ftyCfj5J4cq7h24D9vkkBg==","","JP4Rs\/ygk7B5+4qY1O\/77gceoVCmBBEAI1MNVkcYqRQaD8gtNd7xtSE8vzgCel7k","OOTdNyqzZ+qPxvEtd7WOtg==",null,"o7k6DvJxqJphRuRJvr6JDg==",null,1,"4958"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:04:22","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":["7820","602","598.0","598.00","2","2020-05-12 10:04:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:04:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-09","2020-07-08","602"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-12 10:04:22","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":["7820",57,"SETTLED","A14-I208149","2020-05-12 10:04:21","2020-06-09","2","2020-05-12 10:04:21","2","2020-05-12 10:04:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:04:22","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":["8149","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-05-12 10:04:21","2","2020-05-12 10:04:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:04:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8149"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-12 10:04:22","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":[57,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207794","2020-05-12 10:04:21",598,"2","2020-05-12 10:04:21","2","2020-05-12 10:04:21","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:04:22","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":["7794","DEPOSIT",null,"PAID","2020-05-12 10:04:21",0,"2","2020-05-12 10:04:21","2","2020-05-12 10:04:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:04:22","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":["7794","INVOICE","8149","PAID","2020-05-12 10:04:21",598,"2","2020-05-12 10:04:21","2","2020-05-12 10:04:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:27:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:49:51","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1177&filter3=undefined","floor_plan_rent_room":[{"room_id":"769","master_room_id":"52","room_code":"P03"},{"room_id":"778","master_room_id":"57","room_code":"P12"},{"room_id":"787","master_room_id":"63","room_code":"P21"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1117,"customer_code":"C181117","identity_type":"PERSONAL","identity_id":"K061226(A)","title":"Mr","lastname":"CHONG","firstname":"Kai Lam","companyname":"","email":"erickl338@yahoo.com.hk","tel":"90974815","address":"\u9999\u6e2f\u83ef\u5bcc\u6751\u83ef\u666f\u6a13833\u5ba4","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"981.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-24","renew_room_key":"12436996","renew_remark":"6 months contract. Storage rental paid by PPS on November 22, 2019. Storage deposit $2180 transferred from agreement A05-CT193727 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196537, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"113","order_discount":[],"order_room":[{"room_id":"1187","room_code":"A05-185","retail_price":"1090.0","discounted_price":"1090.00","location_id":"4"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":981,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":11772,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"981.00","warehousing_date":"2020-05-24","rent_from":"2020-05-24","rent_to":"2021-06-23","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. And 2 renew gifts. Storage rental paid by bank transfer on May 12, 2020. Storage deposit $2180 transferred from agreement A05-CT196537 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":981,"order_total":12753,"final_order_total":11772,"location_id":"4","branch_id":"1","company_id":"1","room_key":"12436996","order_product":[],"pass":true}},"first_order_id":"3727","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> A05-185 <\/td>\r\n\t\t\t\t\t 4X3X7 <\/td>\r\n\t\t\t\t\t $1090.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\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":"981.00","deposit":"0.00","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:49: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1117,"NEW","A05-CT207821",1090,981,0,0,"13","13",11772,12753,11772,"2020-05-12 10:49:52","0",null,null,null,"2020-05-24","2021-06-23","13 months contract. Special offer the 13th month free. And 2 renew gifts. Storage rental paid by bank transfer on May 12, 2020. Storage deposit $2180 transferred from agreement A05-CT196537 to this agreement.","2020-05-24","12",0,null,981,"981.00","2","2020-05-12 10:49:51","2","2020-05-12 10:49:51","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"12436996","C181117","PERSONAL","Mr","55KHmuViTOO5LirUV1iH1g==","sFvIMVuF8ZsYisXFtwlNOg==","","572XCp38d\/hIqoieJsOKyefBHa3BUrdpv2pNQJR9LvI=","972zEoF+wKqFDZSVSue+UQ==","nfpwx2jN6mr19jM4Ltsb85x297mvo\/kUERDrp0jAbo8=","pDfobFZjSe9jFdb3yxsRoA==",null,1,"3727"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:49: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":["7821","1187","1090.0","1090.00","2","2020-05-12 10:49:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:49: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-05-24","2021-06-23","1187"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-12 10:49: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":["7821",1117,"SETTLED","A05-I208150","2020-05-12 10:49:51","2020-05-24","2","2020-05-12 10:49:51","2","2020-05-12 10:49:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:49: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":["8150","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,981,"MO","1",981,"2","2020-05-12 10:49:51","2","2020-05-12 10:49:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:49: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":["8150","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2020-05-12 10:49:51","2","2020-05-12 10:49:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:49: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":["8150","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2020-05-12 10:49:51","2","2020-05-12 10:49:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:49: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":["8150","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2020-05-12 10:49:51","2","2020-05-12 10:49:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:49: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":["8150","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2020-05-12 10:49:51","2","2020-05-12 10:49:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:49: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":["8150","RENT","\u9810\u7e73\u79df\u91d1",7,981,"MO","1",981,"2","2020-05-12 10:49:51","2","2020-05-12 10:49:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:49: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":["8150","RENT","\u9810\u7e73\u79df\u91d1",8,981,"MO","1",981,"2","2020-05-12 10:49:51","2","2020-05-12 10:49:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:49: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":["8150","RENT","\u9810\u7e73\u79df\u91d1",9,981,"MO","1",981,"2","2020-05-12 10:49:51","2","2020-05-12 10:49:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:49: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":["8150","RENT","\u9810\u7e73\u79df\u91d1",10,981,"MO","1",981,"2","2020-05-12 10:49:51","2","2020-05-12 10:49:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:49: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":["8150","RENT","\u9810\u7e73\u79df\u91d1",11,981,"MO","1",981,"2","2020-05-12 10:49:51","2","2020-05-12 10:49:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:49: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":["8150","RENT","\u9810\u7e73\u79df\u91d1",12,981,"MO","1",981,"2","2020-05-12 10:49:51","2","2020-05-12 10:49:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:49: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":["8150","RENT","\u9810\u7e73\u79df\u91d1",13,981,"MO","1",981,"2","2020-05-12 10:49:51","2","2020-05-12 10:49:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:49:52","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11772,0,"8150"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-12 10:49: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":[1117,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207795","2020-05-12 10:49:51",11772,"2","2020-05-12 10:49:51","2","2020-05-12 10:49:51","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:49: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":["7795","DEPOSIT",null,"PAID","2020-05-12 10:49:51",0,"2","2020-05-12 10:49:51","2","2020-05-12 10:49:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 10:49: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":["7795","INVOICE","8150","PAID","2020-05-12 10:49:51",11772,"2","2020-05-12 10:49:51","2","2020-05-12 10:49:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 11:24:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 11:57:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 12:44:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 13:56:28","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 14:19:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 15:26:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 15:28:25","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"1225","master_room_id":"141","room_code":"B01-035"}],"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> B01-035 <\/td>\r\n\t\t\t\t\t 4X5X7 <\/td>\r\n\t\t\t\t\t $1308.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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"R829660(9)","title":"Ms","lastname":"LI","firstname":"Wen Jie","companyname":"","email":"wenjie.li@hotmail.com","tel":"91626313","address":"21A, Charming Court, 55-61 First Street, Sai Ying Pun","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"342","master_room_id":"141","discount_type":"%","price":"1308.00","disocunted_price":"851.00","discount":"34.94","monthly_deduct":457.0152,"room_id":"1225","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1225","room_code":"B01-035","retail_price":"1308.0","discounted_price":851,"location_id":"5"}],"roughly_size":"20","total_retail_price":1308,"total_discounted_price":1021,"deposit":2616,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":11724,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3144.00","warehousing_date":"2020-05-19","rent_from":"2020-05-19","rent_to":"2021-05-18","delivery_service":"0","remark":"12 months contract. Special offer the 11th, 12th months free and 50% off for the first 3 months. Storage rental and deposit paid by promissory note on May 12,2020. Smart card paid and provided on the same day.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":3144,"order_total":14928,"final_order_total":11784,"location_id":"5","branch_id":"2","company_id":"1","room_key":"'0005763860","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"pass":true}},"roughly_size":"20","total_discounted_price":"1021.00","deposit":"2616.00","total_retail_price":"1308.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 15:28:26","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":["C201580","PERSONAL","Ms","jDYW6nPtauCMjAer+13qcw==","hbkan9PC5SCnBxQh2lhA4w==","","CUYGFu0XB8CaUzgc52Ln+A==","MfEmZjAhxgQzt2+mJVI2TgNkFcE1z17lG3jabxaBvPU=","UTWvBF5hO3wtZ3NpfoEKH2teWeuSmUkewWkzWPF8O0ZLiwMkYF6UbpPo8jGnFkbXKkqJAnJEwk0oUbHjb63m7w==","dU1xfdAK0TXMycnFlABNzw==",null,"MfEmZjAhxgQzt2+mJVI2TgNkFcE1z17lG3jabxaBvPU=","HPAS1AL7b92bhTCX3dyvRg==","2","2020-05-12 15:28:24","2","2020-05-12 15:28:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 15:28:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","2","5",1580,"NEW","B01-CT207822",1308,1021,2616,0,"12","12",11724,14928,11784,"2020-05-12 15:28:27","0",null,null,null,"2020-05-19","2021-05-18","12 months contract. Special offer the 11th, 12th months free and 50% off for the first 3 months. Storage rental and deposit paid by promissory note on May 12,2020. Smart card paid and provided on the same day.","2020-05-19","20",0,null,3144,"3144.00","2","2020-05-12 15:28:24","2","2020-05-12 15:28:24","CHEQUE","","","","CHEQUE","","","",null,0,"'0005763860","C201580","PERSONAL","Ms","jDYW6nPtauCMjAer+13qcw==","hbkan9PC5SCnBxQh2lhA4w==","","UTWvBF5hO3wtZ3NpfoEKH2teWeuSmUkewWkzWPF8O0ZLiwMkYF6UbpPo8jGnFkbXKkqJAnJEwk0oUbHjb63m7w==","CUYGFu0XB8CaUzgc52Ln+A==","MfEmZjAhxgQzt2+mJVI2TgNkFcE1z17lG3jabxaBvPU=","dU1xfdAK0TXMycnFlABNzw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 15:28:27","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":["7822","342","141","1225","%","34.94",457.0152,"2","2020-05-12 15:28:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 15:28:27","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":["7822",1580,"11","1","60.0",60,"2","2020-05-12 15:28:24","2","2020-05-12 15:28:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 15:28:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"7822"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-05-12 15:28:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7822","1225","1308.0",851,"2","2020-05-12 15:28:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 15:28:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-19","2021-05-18","1225"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-12 15:28:27","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":["7822","B01-D205405","PAID",2616,0,"2021-05-18","2020-05-12 15:28:24","2020-05-12 15:28:24","2","2020-05-12 15:28:24","2","2020-05-12 15:28:24",1580]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 15:28:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7822",1580,"SETTLED","B01-I208151","2020-05-12 15:28:24","2020-05-19","2","2020-05-12 15:28:24","2","2020-05-12 15:28:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 15:28:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8151","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-12 15:28:24","2","2020-05-12 15:28:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 15:28:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8151","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-05-12 15:28:24","2","2020-05-12 15:28:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 15:28:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8151","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,0,"MO","1",0,"2","2020-05-12 15:28:24","2","2020-05-12 15:28:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 15:28:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8151","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",4,940,"MO","1",940,"2","2020-05-12 15:28:24","2","2020-05-12 15:28:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 15:28:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8151","RENT","\u9810\u7e73\u79df\u91d1",5,1021,"MO","1",1021,"2","2020-05-12 15:28:24","2","2020-05-12 15:28:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 15:28:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8151","RENT","\u9810\u7e73\u79df\u91d1",6,1021,"MO","1",1021,"2","2020-05-12 15:28:24","2","2020-05-12 15:28:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 15:28:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8151","RENT","\u9810\u7e73\u79df\u91d1",7,1021,"MO","1",1021,"2","2020-05-12 15:28:24","2","2020-05-12 15:28:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 15:28:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8151","RENT","\u9810\u7e73\u79df\u91d1",8,1021,"MO","1",1021,"2","2020-05-12 15:28:24","2","2020-05-12 15:28:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 15:28:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8151","RENT","\u9810\u7e73\u79df\u91d1",9,1021,"MO","1",1021,"2","2020-05-12 15:28:24","2","2020-05-12 15:28:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 15:28:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8151","RENT","\u9810\u7e73\u79df\u91d1",10,1021,"MO","1",1021,"2","2020-05-12 15:28:24","2","2020-05-12 15:28:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 15:28:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8151","RENT","\u9810\u7e73\u79df\u91d1",11,1021,"MO","1",1021,"2","2020-05-12 15:28:24","2","2020-05-12 15:28:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 15:28:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8151","RENT","\u9810\u7e73\u79df\u91d1",12,1021,"MO","1",1021,"2","2020-05-12 15:28:24","2","2020-05-12 15:28:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 15:28:27","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":["8151","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-05-12 15:28:24","2","2020-05-12 15:28:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 15:28:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[9168,0,"8151"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-12 15:28:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1580,"CHEQUE","","","","CHEQUE","","","","PAID","P207796","2020-05-12 15:28:24",11784,"2","2020-05-12 15:28:24","2","2020-05-12 15:28:24","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 15:28:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7796","DEPOSIT","5405","PAID","2020-05-12 15:28:24",2616,"2","2020-05-12 15:28:24","2","2020-05-12 15:28:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 15:28:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7796","INVOICE","8151","PAID","2020-05-12 15:28:24",9168,"2","2020-05-12 15:28:24","2","2020-05-12 15:28:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 15:44:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:15:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:29:49","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":"all=1&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1121","master_room_id":"114","room_code":"A05-119"},{"room_id":"1120","master_room_id":"114","room_code":"A05-118"},{"room_id":"1127","master_room_id":"114","room_code":"A05-125"},{"room_id":"1128","master_room_id":"114","room_code":"A05-126"}],"_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\r\n\t\t\t\t\t\r\n\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> A05-119 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\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> A05-118 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\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> A05-125 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\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> A05-126 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\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":"0","identity_type":"PERSONAL","identity_id":"P030927(7)","title":"Ms","lastname":"Chia","firstname":"Jacqueline Brigitte","companyname":"","email":"jackie_tjia@hotmail.com","tel":"97552210","address":"G\/F, Flat A, Albany Court, 5`1-53 Bisney Rd, Pok Fu Lam","pass":true,"customer_id":"780","customer_code":"C180780","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"251","master_room_id":"114","discount_type":"%","price":"1290.00","disocunted_price":"1161.00","discount":"10.00","monthly_deduct":129,"room_id":"1128","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"251","master_room_id":"114","discount_type":"%","price":"1290.00","disocunted_price":"1161.00","discount":"10.00","monthly_deduct":129,"room_id":"1127","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"251","master_room_id":"114","discount_type":"%","price":"1290.00","disocunted_price":"1161.00","discount":"10.00","monthly_deduct":129,"room_id":"1120","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"251","master_room_id":"114","discount_type":"%","price":"1290.00","disocunted_price":"1161.00","discount":"10.00","monthly_deduct":129,"room_id":"1121","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1121","room_code":"A05-119","retail_price":"1290.0","discounted_price":1161,"location_id":"4"},{"room_id":"1120","room_code":"A05-118","retail_price":"1290.0","discounted_price":1161,"location_id":"4"},{"room_id":"1127","room_code":"A05-125","retail_price":"1290.0","discounted_price":1161,"location_id":"4"},{"room_id":"1128","room_code":"A05-126","retail_price":"1290.0","discounted_price":1161,"location_id":"4"}],"roughly_size":"64","total_retail_price":5160,"total_discounted_price":3478,"deposit":7728,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":27552,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1044.00","warehousing_date":"2020-05-12","rent_from":"2020-05-12","rent_to":"2020-11-11","delivery_service":"0","remark":"6 months contract. Special offer 5% \"Rent Now\" discount. Storage rental and deposit paid by EPS on May 12, 2020. Smartcard provided on May 12, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":1044,"order_total":28596,"final_order_total":27552,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0005010159","order_product":[],"pass":true}},"roughly_size":"64","total_discounted_price":"3478.00","deposit":"7728.00","total_retail_price":"5160.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:29: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","1","4","780","NEW","A05-CT207823",5160,3478,7728,0,"6","6",27552,28596,27552,"2020-05-12 16:29:49","0",null,null,null,"2020-05-12","2020-11-11","6 months contract. Special offer 5% \"Rent Now\" discount. Storage rental and deposit paid by EPS on May 12, 2020. Smartcard provided on May 12, 2020. ","2020-05-12","64",0,null,1044,"1044.00","2","2020-05-12 16:29:49","2","2020-05-12 16:29:49","EPS","","","","EPS","","","",null,0,"'0005010159","C180780","PERSONAL","Ms","1p7bDYDtTmM07v7ySaTkXOrEUVbL32JckPPqsCIbv\/w=","gqpBPhMXyxdjxQDjxaJzUw==","","vHATtF\/CIkXJXwV7irRZIMik8cgv4FFFjnDOP9GLR95qpvw7qcrDzBySpWQmcW5kAPLAacaoCktKa2J57XXg+A==","\/cSBTdAZw3bbIY7dhadNDA==","EBpA6lMjhOOSeSc7CI4FDz7o0RRi+YJRUiB6C6GSE\/M=","2VksV5Z1w1U+T3QEB+uYFQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:29:49","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":["7823","251","114","1128","%","10.00",129,"2","2020-05-12 16:29:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:29:49","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":["7823","251","114","1127","%","10.00",129,"2","2020-05-12 16:29:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:29:49","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":["7823","251","114","1120","%","10.00",129,"2","2020-05-12 16:29:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:29:49","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":["7823","251","114","1121","%","10.00",129,"2","2020-05-12 16:29:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:29: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":["7823","1121","1290.0",1161,"2","2020-05-12 16:29:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:29: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-05-12","2020-11-11","1121"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-12 16:29: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":["7823","1120","1290.0",1161,"2","2020-05-12 16:29:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:29: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-05-12","2020-11-11","1120"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-12 16:29: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":["7823","1127","1290.0",1161,"2","2020-05-12 16:29:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:29: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-05-12","2020-11-11","1127"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-12 16:29: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":["7823","1128","1290.0",1161,"2","2020-05-12 16:29:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:29: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-05-12","2020-11-11","1128"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-12 16:29: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":["7823","A05-D205406","PAID",7728,0,"2020-11-11","2020-05-12 16:29:49","2020-05-12 16:29:49","2","2020-05-12 16:29:49","2","2020-05-12 16:29:49","780"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:29: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":["7823","780","SETTLED","A05-I208152","2020-05-12 16:29:49","2020-05-12","2","2020-05-12 16:29:49","2","2020-05-12 16:29:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:29: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":["8152","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,2434,"MO","1",2434,"2","2020-05-12 16:29:49","2","2020-05-12 16:29:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:29: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":["8152","RENT","\u9810\u7e73\u79df\u91d1",2,3478,"MO","1",3478,"2","2020-05-12 16:29:49","2","2020-05-12 16:29:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:29: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":["8152","RENT","\u9810\u7e73\u79df\u91d1",3,3478,"MO","1",3478,"2","2020-05-12 16:29:49","2","2020-05-12 16:29:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:29: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":["8152","RENT","\u9810\u7e73\u79df\u91d1",4,3478,"MO","1",3478,"2","2020-05-12 16:29:49","2","2020-05-12 16:29:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:29: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":["8152","RENT","\u9810\u7e73\u79df\u91d1",5,3478,"MO","1",3478,"2","2020-05-12 16:29:49","2","2020-05-12 16:29:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:29: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":["8152","RENT","\u9810\u7e73\u79df\u91d1",6,3478,"MO","1",3478,"2","2020-05-12 16:29:49","2","2020-05-12 16:29:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:29:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[19824,0,"8152"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-12 16:29: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":["780","EPS","","","","EPS","","","","PAID","P207797","2020-05-12 16:29:49",27552,"2","2020-05-12 16:29:49","2","2020-05-12 16:29:49","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:29: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":["7797","DEPOSIT","5406","PAID","2020-05-12 16:29:49",7728,"2","2020-05-12 16:29:49","2","2020-05-12 16:29:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:29: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":["7797","INVOICE","8152","PAID","2020-05-12 16:29:49",19824,"2","2020-05-12 16:29:49","2","2020-05-12 16:29:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:51:48","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:56:10","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","'0005010159","6 months contract. Special offer 5% \"Rent Now\" discount. Storage rental and deposit paid by EPS on May 12, 2020. Smartcard provided on May 12, 2020. ","2020-05-12 16:56:10","2","gqpBPhMXyxdjxQDjxaJzUw==","1p7bDYDtTmM07v7ySaTkXOrEUVbL32JckPPqsCIbv\/w=","EBpA6lMjhOOSeSc7CI4FDz7o0RRi+YJRUiB6C6GSE\/M=","\/cSBTdAZw3bbIY7dhadNDA==","vHATtF\/CIkXJXwV7irRZIMik8cgv4FFFjnDOP9GLR95qpvw7qcrDzBySpWQmcW5kAPLAacaoCktKa2J57XXg+A==",7823]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:57:31","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","floor_plan_rent_room":[{"room_id":"1121","master_room_id":"114","room_code":"A05-119"},{"room_id":"1120","master_room_id":"114","room_code":"A05-118"},{"room_id":"1127","master_room_id":"114","room_code":"A05-125"},{"room_id":"1128","master_room_id":"114","room_code":"A05-126"}],"_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\r\n\t\t\t\t\t\r\n\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> A05-119 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\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> A05-118 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\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> A05-125 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\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> A05-126 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\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":"0","identity_type":"PERSONAL","identity_id":"P030927(7)","title":"Ms","lastname":"Chia","firstname":"Jacqueline Brigitte","companyname":"","email":"jackie_tjia@hotmail.com","tel":"97552210","address":"G\/F, Flat A, Albany Court, 5`1-53 Bisney Rd, Pok Fu Lam","pass":true,"customer_id":"780","customer_code":"C180780","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"251","master_room_id":"114","discount_type":"%","price":"1290.00","disocunted_price":"1161.00","discount":"10.00","monthly_deduct":129,"room_id":"1128","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"251","master_room_id":"114","discount_type":"%","price":"1290.00","disocunted_price":"1161.00","discount":"10.00","monthly_deduct":129,"room_id":"1127","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"251","master_room_id":"114","discount_type":"%","price":"1290.00","disocunted_price":"1161.00","discount":"10.00","monthly_deduct":129,"room_id":"1120","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"251","master_room_id":"114","discount_type":"%","price":"1290.00","disocunted_price":"1161.00","discount":"10.00","monthly_deduct":129,"room_id":"1121","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1121","room_code":"A05-119","retail_price":"1290.0","discounted_price":1161,"location_id":"4"},{"room_id":"1120","room_code":"A05-118","retail_price":"1290.0","discounted_price":1161,"location_id":"4"},{"room_id":"1127","room_code":"A05-125","retail_price":"1290.0","discounted_price":1161,"location_id":"4"},{"room_id":"1128","room_code":"A05-126","retail_price":"1290.0","discounted_price":1161,"location_id":"4"}],"roughly_size":"64","total_retail_price":5160,"total_discounted_price":3478,"deposit":7728,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":27552,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1044.00","warehousing_date":"2020-06-24","rent_from":"2020-06-24","rent_to":"2020-12-23","delivery_service":"0","remark":"6 months contract. Special offer 5% \"Rent Now\" discount. Storage rental and deposit paid by EPS on May 12, 2020. Smartcard provided on May 12, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":1044,"order_total":28596,"final_order_total":27552,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0005010159","order_product":[],"pass":true}},"roughly_size":"64","total_discounted_price":"3478.00","deposit":"7728.00","total_retail_price":"5160.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:57:31","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","780","NEW","A05-CT207824",5160,3478,7728,0,"6","6",27552,28596,27552,"2020-05-12 16:57:31","0",null,null,null,"2020-06-24","2020-12-23","6 months contract. Special offer 5% \"Rent Now\" discount. Storage rental and deposit paid by EPS on May 12, 2020. Smartcard provided on May 12, 2020. ","2020-06-24","64",0,null,1044,"1044.00","2","2020-05-12 16:57:31","2","2020-05-12 16:57:31","EPS","","","","EPS","","","",null,0,"'0005010159","C180780","PERSONAL","Ms","1p7bDYDtTmM07v7ySaTkXOrEUVbL32JckPPqsCIbv\/w=","gqpBPhMXyxdjxQDjxaJzUw==","","vHATtF\/CIkXJXwV7irRZIMik8cgv4FFFjnDOP9GLR95qpvw7qcrDzBySpWQmcW5kAPLAacaoCktKa2J57XXg+A==","\/cSBTdAZw3bbIY7dhadNDA==","EBpA6lMjhOOSeSc7CI4FDz7o0RRi+YJRUiB6C6GSE\/M=","2VksV5Z1w1U+T3QEB+uYFQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:57:31","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":["7824","251","114","1128","%","10.00",129,"2","2020-05-12 16:57:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:57:31","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":["7824","251","114","1127","%","10.00",129,"2","2020-05-12 16:57:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:57:31","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":["7824","251","114","1120","%","10.00",129,"2","2020-05-12 16:57:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:57:31","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":["7824","251","114","1121","%","10.00",129,"2","2020-05-12 16:57:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:57:31","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":["7824","1121","1290.0",1161,"2","2020-05-12 16:57:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:57:31","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-24","2020-12-23","1121"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-12 16:57:31","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":["7824","1120","1290.0",1161,"2","2020-05-12 16:57:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:57:31","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-24","2020-12-23","1120"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-12 16:57:31","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":["7824","1127","1290.0",1161,"2","2020-05-12 16:57:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:57:31","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-24","2020-12-23","1127"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-12 16:57:31","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":["7824","1128","1290.0",1161,"2","2020-05-12 16:57:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:57:31","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-24","2020-12-23","1128"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-12 16:57:31","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":["7824","A05-D205407","PAID",7728,0,"2020-12-23","2020-05-12 16:57:31","2020-05-12 16:57:31","2","2020-05-12 16:57:31","2","2020-05-12 16:57:31","780"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:57:31","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":["7824","780","SETTLED","A05-I208153","2020-05-12 16:57:31","2020-06-24","2","2020-05-12 16:57:31","2","2020-05-12 16:57:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:57:31","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":["8153","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,2434,"MO","1",2434,"2","2020-05-12 16:57:31","2","2020-05-12 16:57:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:57:31","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":["8153","RENT","\u9810\u7e73\u79df\u91d1",2,3478,"MO","1",3478,"2","2020-05-12 16:57:31","2","2020-05-12 16:57:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:57:31","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":["8153","RENT","\u9810\u7e73\u79df\u91d1",3,3478,"MO","1",3478,"2","2020-05-12 16:57:31","2","2020-05-12 16:57:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:57:31","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":["8153","RENT","\u9810\u7e73\u79df\u91d1",4,3478,"MO","1",3478,"2","2020-05-12 16:57:31","2","2020-05-12 16:57:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:57:31","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":["8153","RENT","\u9810\u7e73\u79df\u91d1",5,3478,"MO","1",3478,"2","2020-05-12 16:57:31","2","2020-05-12 16:57:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:57:31","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":["8153","RENT","\u9810\u7e73\u79df\u91d1",6,3478,"MO","1",3478,"2","2020-05-12 16:57:31","2","2020-05-12 16:57:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:57:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[19824,0,"8153"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-12 16:57:31","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":["780","EPS","","","","EPS","","","","PAID","P207798","2020-05-12 16:57:31",27552,"2","2020-05-12 16:57:31","2","2020-05-12 16:57:31","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:57:31","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":["7798","DEPOSIT","5407","PAID","2020-05-12 16:57:31",7728,"2","2020-05-12 16:57:31","2","2020-05-12 16:57:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 16:57:31","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":["7798","INVOICE","8153","PAID","2020-05-12 16:57:31",19824,"2","2020-05-12 16:57:31","2","2020-05-12 16:57:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 17:31:28","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 17:44:31","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1121","master_room_id":"114","room_code":"A05-119"},{"room_id":"1120","master_room_id":"114","room_code":"A05-118"},{"room_id":"1127","master_room_id":"114","room_code":"A05-125"},{"room_id":"1128","master_room_id":"114","room_code":"A05-126"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":447,"customer_code":"C170447","identity_type":"PERSONAL","identity_id":"D525073(1)","title":"Ms","lastname":"Wu ","firstname":"Wing Yee","companyname":"","email":null,"tel":"94178991","address":"Rm C,6\/F,Block 33,South Horizons,Apleichau,HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-15","renew_room_key":"053,32277","renew_remark":"6 months contract. Storage rental paid by cheque on Nov 18, 2019. Storage deposit transferred from agreement A14-CT195049 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196432, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"550","room_code":"L28","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":935,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5610,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-15","rent_from":"2020-05-15","rent_to":"2020-11-14","delivery_service":"0","remark":"6 months contract. Storage rental paid by cheque on May 12, 2020. Storage deposit transferred from agreement A14-CT196432 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":5610,"final_order_total":5610,"location_id":"2","branch_id":"1","company_id":"1","room_key":"053,32277","order_product":[],"pass":true}},"first_order_id":"3637","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> L28 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.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":"16","total_discounted_price":"935.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 17:44:31","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",447,"NEW","A14-CT207825",1098,935,0,0,"6","6",5610,5610,5610,"2020-05-12 17:44:31","0",null,null,null,"2020-05-15","2020-11-14","6 months contract. Storage rental paid by cheque on May 12, 2020. Storage deposit transferred from agreement A14-CT196432 to this agreement.","2020-05-15","16",0,null,0,"0","2","2020-05-12 17:44:31","2","2020-05-12 17:44:31","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"053,32277","C170447","PERSONAL","Ms","s8D8dueD7W\/UxDSnTEXmrw==","s7f6wNoBn49GUnYogkOSUg==","","IoW9JMXFx\/kdEXM1BfuOQKyah5c6TzggO5DMNgzp2ydHu4ZGZMvelB7\/5\/nTECBa","Tw2ZPiDypZSy7BbhBCNZnw==",null,"6ojjaDCZqJzc0+63qgiQYQ==",null,1,"3637"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 17:44:31","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":["7825","550","1098.0","1098.00","2","2020-05-12 17:44:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 17:44:31","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-15","2020-11-14","550"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-12 17:44:31","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":["7825",447,"SETTLED","A14-I208154","2020-05-12 17:44:31","2020-05-15","2","2020-05-12 17:44:31","2","2020-05-12 17:44:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 17:44:31","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":["8154","RENT","\u9810\u7e73\u79df\u91d1",1,935,"MO","1",935,"2","2020-05-12 17:44:31","2","2020-05-12 17:44:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 17:44:31","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":["8154","RENT","\u9810\u7e73\u79df\u91d1",2,935,"MO","1",935,"2","2020-05-12 17:44:31","2","2020-05-12 17:44:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 17:44:31","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":["8154","RENT","\u9810\u7e73\u79df\u91d1",3,935,"MO","1",935,"2","2020-05-12 17:44:31","2","2020-05-12 17:44:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 17:44:31","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":["8154","RENT","\u9810\u7e73\u79df\u91d1",4,935,"MO","1",935,"2","2020-05-12 17:44:31","2","2020-05-12 17:44:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 17:44:31","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":["8154","RENT","\u9810\u7e73\u79df\u91d1",5,935,"MO","1",935,"2","2020-05-12 17:44:31","2","2020-05-12 17:44:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 17:44:31","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":["8154","RENT","\u9810\u7e73\u79df\u91d1",6,935,"MO","1",935,"2","2020-05-12 17:44:31","2","2020-05-12 17:44:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 17:44:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5610,0,"8154"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-12 17:44:31","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":[447,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207799","2020-05-12 17:44:31",5610,"2","2020-05-12 17:44:31","2","2020-05-12 17:44:31","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 17:44:31","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":["7799","DEPOSIT",null,"PAID","2020-05-12 17:44:31",0,"2","2020-05-12 17:44:31","2","2020-05-12 17:44:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 17:44:31","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":["7799","INVOICE","8154","PAID","2020-05-12 17:44:31",5610,"2","2020-05-12 17:44:31","2","2020-05-12 17:44:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 18:47:15","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1121","master_room_id":"114","room_code":"A05-119"},{"room_id":"1120","master_room_id":"114","room_code":"A05-118"},{"room_id":"1127","master_room_id":"114","room_code":"A05-125"},{"room_id":"1128","master_room_id":"114","room_code":"A05-126"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":570,"customer_code":"C170570","identity_type":"PERSONAL","identity_id":"K817823(2)","title":"Ms","lastname":"Yuen","firstname":"Sze Wan Cewan","companyname":"","email":"cewanyuen@yahoo.com.hk","tel":"93190159","address":"Flat E, 8\/F, Blk 8, Chi Fu Fa Yuen, Pok Fu Lam, Hong kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-01","renew_room_key":"137,17359","renew_remark":"1 month contract. Storage rental paid by bank transfer on March 3, 2020. Storage deposit transferred from agreement A12-CT207121 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207304, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"235","room_code":"D39","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":998,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-01","rent_from":"2020-04-01","rent_to":"2020-04-30","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on April 3, 2020. Storage deposit transferred from agreement A12-CT207304 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":998,"final_order_total":998,"location_id":"1","branch_id":"1","company_id":"1","room_key":"137,17359","order_product":[],"pass":true}},"first_order_id":"3800","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> D39 <\/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\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\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":"998.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 18:47:16","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",570,"NEW","A12-CT207826",998,998,0,0,"1","1",998,998,998,"2020-05-12 18:47:16","0",null,null,null,"2020-04-01","2020-04-30","1 month contract. Storage rental paid by bank transfer on April 3, 2020. Storage deposit transferred from agreement A12-CT207304 to this agreement.\r\n","2020-04-01","12",0,null,0,"0","2","2020-05-12 18:47:15","2","2020-05-12 18:47:15","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"137,17359","C170570","PERSONAL","Ms","cOVHZvoCSVf6Uh6Fd\/Oh2w==","DtbrOSvE4C7BOu5x4dBFtg==","","Av+ADiyvjVRBgUo03h3p6hpp6mcXgDaDJDvSxXwfQQosUJ1or1G3FIymGt9ddzamhEKDZyddjvFbjz9Eecftvg==","1l5cJvjJNKc2QtotYjeiiQ==","Lg+q8UB1y8C7eQ5vqzRcDiz\/WuEjcTUgxi3gM++AjHw=","CDRdPp1CIDhlh0eK\/Rafuw==",null,1,"3800"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 18:47:16","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":["7826","235","998.0","998.00","2","2020-05-12 18:47:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 18:47:16","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-01","2020-04-30","235"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-12 18:47:16","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":["7826",570,"SETTLED","A12-I208155","2020-05-12 18:47:15","2020-04-01","2","2020-05-12 18:47:15","2","2020-05-12 18:47:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 18:47:16","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":["8155","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-05-12 18:47:15","2","2020-05-12 18:47:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 18:47:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"8155"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-12 18:47:16","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":[570,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207800","2020-05-12 18:47:15",998,"2","2020-05-12 18:47:15","2","2020-05-12 18:47:15","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 18:47:16","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":["7800","DEPOSIT",null,"PAID","2020-05-12 18:47:15",0,"2","2020-05-12 18:47:15","2","2020-05-12 18:47:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 18:47:16","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":["7800","INVOICE","8155","PAID","2020-05-12 18:47:15",998,"2","2020-05-12 18:47:15","2","2020-05-12 18:47:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 18:49: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","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1121","master_room_id":"114","room_code":"A05-119"},{"room_id":"1120","master_room_id":"114","room_code":"A05-118"},{"room_id":"1127","master_room_id":"114","room_code":"A05-125"},{"room_id":"1128","master_room_id":"114","room_code":"A05-126"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":503,"customer_code":"C170503","identity_type":"PERSONAL","identity_id":"D571796(6)","title":"Ms","lastname":"Cheng","firstname":"Mei Lan Brenda","companyname":"","email":"brendacheng.ml@gmail.com","tel":"94678787","address":"\u6085\u6d77\u88573\u865f\u6085\u6d77\u83ef\u5ead3\u5ea743\u5b57\u6a13 B\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"6","renew_warehousing_date":"2020-04-03","renew_room_key":"136,54649","renew_remark":"6 months contract. Storage rental paid by bank transfer on December 11, 2019. Storage deposit transferred from agreement A12-CT194944 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196679, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"391","room_code":"H01","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"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-03","rent_from":"2020-04-03","rent_to":"2020-05-02","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on May 13, 2019. Storage deposit transferred from agreement A12-CT196679 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"136,54649","order_product":[],"pass":true}},"first_order_id":"3699","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> H01 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\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":"16","total_discounted_price":"1038.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 18:49: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","1","1",503,"NEW","A12-CT207827",1098,1038,0,0,"1","1",1038,1038,1038,"2020-05-12 18:49:17","0",null,null,null,"2020-04-03","2020-05-02","6 months contract. Storage rental paid by bank transfer on May 13, 2019. Storage deposit transferred from agreement A12-CT196679 to this agreement.","2020-04-03","16",0,null,0,"0","2","2020-05-12 18:49:17","2","2020-05-12 18:49:17","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,54649","C170503","PERSONAL","Ms","Rh6PQC0IyieQPVR6gkmXSA==","UCPBCXrBLI9U7KKsPqgmNA==","","64ZGloW9cfuZ2bXYW1nWwp09xqvN1r4BoOKsP50lvEE5JwL3RcAappX1n5fvy2Vo","gw05XeVsROKlh03tYi7NgA==","1p05h8uR\/c4iMfkXKYIaxHLeaeUXyT3\/eDb0o28AV5E=","vmOX49GKDeumL4rI9rkV4Q==",null,1,"3699"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 18:49: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":["7827","391","1098.0","1098.00","2","2020-05-12 18:49:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 18:49: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-04-03","2020-05-02","391"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-12 18:49: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":["7827",503,"SETTLED","A12-I208156","2020-05-12 18:49:17","2020-04-03","2","2020-05-12 18:49:17","2","2020-05-12 18:49:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 18:49: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":["8156","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-05-12 18:49:17","2","2020-05-12 18:49:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 18:49:17","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"8156"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-12 18:49: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":[503,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207801","2020-05-12 18:49:17",1038,"2","2020-05-12 18:49:17","2","2020-05-12 18:49:17","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 18:49: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":["7801","DEPOSIT",null,"PAID","2020-05-12 18:49:17",0,"2","2020-05-12 18:49:17","2","2020-05-12 18:49:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 18:49: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":["7801","INVOICE","8156","PAID","2020-05-12 18:49:17",1038,"2","2020-05-12 18:49:17","2","2020-05-12 18:49:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:16: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&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1121","master_room_id":"114","room_code":"A05-119"},{"room_id":"1120","master_room_id":"114","room_code":"A05-118"},{"room_id":"1127","master_room_id":"114","room_code":"A05-125"},{"room_id":"1128","master_room_id":"114","room_code":"A05-126"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":448,"customer_code":"C170448","identity_type":"PERSONAL","identity_id":"Z011806(1)","title":"Mr","lastname":"Hau","firstname":"Hil Yeung","companyname":"","email":"hermannhau@gmail.com","tel":"97139457","address":"Flat H,2\/F,Block 2,Chi Fu Fa Yuen,Pok Fu Lam,Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2022.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-24","renew_room_key":"053,46811","renew_remark":"1 month contract. Special offer $2022\/month. Storage rental $2022 paid by PPS on April 14, 2020. Storage deposit $4636 transferred from agreement A14-CT207481 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207634, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"535","room_code":"L13","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"536","room_code":"L14","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":2022,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2022,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-24","rent_from":"2020-05-24","rent_to":"2020-06-23","delivery_service":"0","remark":"1 month contract. Special offer $2022\/month. Storage rental $2022 paid by PPS on May 11, 2020. Storage deposit $4636 transferred from agreement A14-CT207634 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":2022,"final_order_total":2022,"location_id":"2","branch_id":"1","company_id":"1","room_key":"053,46811","order_product":[],"pass":true}},"first_order_id":"7481","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\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> L13 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.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> L14 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.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":"32","total_discounted_price":"2022.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:16:34","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",448,"NEW","A14-CT207828",2196,2022,0,0,"1","1",2022,2022,2022,"2020-05-12 19:16:34","0",null,null,null,"2020-05-24","2020-06-23","1 month contract. Special offer $2022\/month. Storage rental $2022 paid by PPS on May 11, 2020. Storage deposit $4636 transferred from agreement A14-CT207634 to this agreement.\r\n","2020-05-24","32",0,null,0,"0","2","2020-05-12 19:16:34","2","2020-05-12 19:16:34","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"053,46811","C170448","PERSONAL","Mr","NVv9pRh+D1VmYB2XsurgEQ==","8OcLe\/VzxU\/Xek1BNlpsfQ==","","0QpZaBXqoW5CgaBIwDwpjWtY5YJYGo9YtwWqdo6IK1Fg9YHW9ZmtiUF11gEm1OcOe3VhZDJuL+H\/IV+pZmf2Kw==","tujHTZIsGcqjKeaOnttAvg==","jGafPuxpS3yTCisx0O3a7o2TE03wjvCrNp2lr0gCkFw=","y4ZDYxl9X3dwkt7\/dDApww==",null,1,"7481"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:16:34","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":["7828","535","1098.0","1098.00","2","2020-05-12 19:16:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:16:34","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-24","2020-06-23","535"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-12 19:16:34","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":["7828","536","1098.0","1098.00","2","2020-05-12 19:16:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:16:34","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-24","2020-06-23","536"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-12 19:16:34","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":["7828",448,"SETTLED","A14-I208157","2020-05-12 19:16:34","2020-05-24","2","2020-05-12 19:16:34","2","2020-05-12 19:16:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:16:34","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":["8157","RENT","\u9810\u7e73\u79df\u91d1",1,2022,"MO","1",2022,"2","2020-05-12 19:16:34","2","2020-05-12 19:16:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:16:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2022,0,"8157"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-12 19:16:34","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":[448,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207802","2020-05-12 19:16:34",2022,"2","2020-05-12 19:16:34","2","2020-05-12 19:16:34","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:16:34","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":["7802","DEPOSIT",null,"PAID","2020-05-12 19:16:34",0,"2","2020-05-12 19:16:34","2","2020-05-12 19:16:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:16:34","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":["7802","INVOICE","8157","PAID","2020-05-12 19:16:34",2022,"2","2020-05-12 19:16:34","2","2020-05-12 19:16:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:18:12","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1121","master_room_id":"114","room_code":"A05-119"},{"room_id":"1120","master_room_id":"114","room_code":"A05-118"},{"room_id":"1127","master_room_id":"114","room_code":"A05-125"},{"room_id":"1128","master_room_id":"114","room_code":"A05-126"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":448,"customer_code":"C170448","identity_type":"PERSONAL","identity_id":"Z011806(1)","title":"Mr","lastname":"Hau","firstname":"Hil Yeung","companyname":"","email":"hermannhau@gmail.com","tel":"97139457","address":"Flat H,2\/F,Block 2,Chi Fu Fa Yuen,Pok Fu Lam,Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2022.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-15","renew_room_key":"053,46811","renew_remark":"1 month contract. Storage rental paid by PPS on April 14, 2020. Storage deposit transferred from agreement A14-CT207480 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207633, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"549","room_code":"L27","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"548","room_code":"L26","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":2022,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2022,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-15","rent_from":"2020-05-15","rent_to":"2020-06-14","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on May 11, 2020. Storage deposit transferred from agreement A14-CT207633 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":2022,"final_order_total":2022,"location_id":"2","branch_id":"1","company_id":"1","room_key":"053,46811","order_product":[],"pass":true}},"first_order_id":"4790","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\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> L27 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.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> L26 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.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":"32","total_discounted_price":"2022.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:18:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",448,"NEW","A14-CT207829",2196,2022,0,0,"1","1",2022,2022,2022,"2020-05-12 19:18:13","0",null,null,null,"2020-05-15","2020-06-14","1 month contract. Storage rental paid by PPS on May 11, 2020. Storage deposit transferred from agreement A14-CT207633 to this agreement.\r\n","2020-05-15","32",0,null,0,"0","2","2020-05-12 19:18:12","2","2020-05-12 19:18:12","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"053,46811","C170448","PERSONAL","Mr","NVv9pRh+D1VmYB2XsurgEQ==","8OcLe\/VzxU\/Xek1BNlpsfQ==","","0QpZaBXqoW5CgaBIwDwpjWtY5YJYGo9YtwWqdo6IK1Fg9YHW9ZmtiUF11gEm1OcOe3VhZDJuL+H\/IV+pZmf2Kw==","tujHTZIsGcqjKeaOnttAvg==","jGafPuxpS3yTCisx0O3a7o2TE03wjvCrNp2lr0gCkFw=","y4ZDYxl9X3dwkt7\/dDApww==",null,1,"4790"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:18:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7829","549","1098.0","1098.00","2","2020-05-12 19:18:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:18:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-15","2020-06-14","549"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-12 19:18:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7829","548","1098.0","1098.00","2","2020-05-12 19:18:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:18:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-15","2020-06-14","548"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-12 19:18:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7829",448,"SETTLED","A14-I208158","2020-05-12 19:18:12","2020-05-15","2","2020-05-12 19:18:12","2","2020-05-12 19:18:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:18:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8158","RENT","\u9810\u7e73\u79df\u91d1",1,2022,"MO","1",2022,"2","2020-05-12 19:18:12","2","2020-05-12 19:18:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:18:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2022,0,"8158"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-12 19:18:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[448,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207803","2020-05-12 19:18:12",2022,"2","2020-05-12 19:18:12","2","2020-05-12 19:18:12","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:18:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7803","DEPOSIT",null,"PAID","2020-05-12 19:18:12",0,"2","2020-05-12 19:18:12","2","2020-05-12 19:18:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:18:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7803","INVOICE","8158","PAID","2020-05-12 19:18:12",2022,"2","2020-05-12 19:18:12","2","2020-05-12 19:18:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:21: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&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1121","master_room_id":"114","room_code":"A05-119"},{"room_id":"1120","master_room_id":"114","room_code":"A05-118"},{"room_id":"1127","master_room_id":"114","room_code":"A05-125"},{"room_id":"1128","master_room_id":"114","room_code":"A05-126"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":448,"customer_code":"C170448","identity_type":"PERSONAL","identity_id":"Z011806(1)","title":"Mr","lastname":"Hau","firstname":"Hil Yeung","companyname":"","email":"hermannhau@gmail.com","tel":"97139457","address":"Flat H,2\/F,Block 2,Chi Fu Fa Yuen,Pok Fu Lam,Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-13","renew_room_key":"'0012469943","renew_remark":"1 month contract.Storage rental $598 paid by PPS on April 15, 2020. Storage deposit $1196 paid by PPS on April 15, 2020. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207602, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1196.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"685","room_code":"N02","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-13","rent_from":"2020-05-13","rent_to":"2020-06-12","delivery_service":"0","remark":"1 month contract.Storage rental $598 paid by PPS on May 11, 2020. Storage deposit $1196 Transferred from agreement A14-CT207602 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"'0012469943","order_product":[],"pass":true}},"first_order_id":7602,"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> N02 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/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":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:21:08","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",448,"NEW","A14-CT207830",598,598,0,0,"1","1",598,598,598,"2020-05-12 19:21:08","0",null,null,null,"2020-05-13","2020-06-12","1 month contract.Storage rental $598 paid by PPS on May 11, 2020. Storage deposit $1196 Transferred from agreement A14-CT207602 to this agreement. \r\n","2020-05-13","12",0,null,0,"0","2","2020-05-12 19:21:07","2","2020-05-12 19:21:07","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"'0012469943","C170448","PERSONAL","Mr","NVv9pRh+D1VmYB2XsurgEQ==","8OcLe\/VzxU\/Xek1BNlpsfQ==","","0QpZaBXqoW5CgaBIwDwpjWtY5YJYGo9YtwWqdo6IK1Fg9YHW9ZmtiUF11gEm1OcOe3VhZDJuL+H\/IV+pZmf2Kw==","tujHTZIsGcqjKeaOnttAvg==","jGafPuxpS3yTCisx0O3a7o2TE03wjvCrNp2lr0gCkFw=","y4ZDYxl9X3dwkt7\/dDApww==",null,1,7602]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:21:08","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":["7830","685","598.0","598.00","2","2020-05-12 19:21:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:21:08","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-13","2020-06-12","685"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-12 19:21:08","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":["7830",448,"SETTLED","A14-I208159","2020-05-12 19:21:07","2020-05-13","2","2020-05-12 19:21:07","2","2020-05-12 19:21:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:21:08","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":["8159","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-05-12 19:21:07","2","2020-05-12 19:21:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:21:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8159"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-12 19:21:08","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":[448,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207804","2020-05-12 19:21:07",598,"2","2020-05-12 19:21:07","2","2020-05-12 19:21:07","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:21:08","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":["7804","DEPOSIT",null,"PAID","2020-05-12 19:21:07",0,"2","2020-05-12 19:21:07","2","2020-05-12 19:21:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:21:08","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":["7804","INVOICE","8159","PAID","2020-05-12 19:21:07",598,"2","2020-05-12 19:21:07","2","2020-05-12 19:21:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:31:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:35:52","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":"all=1&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1121","master_room_id":"114","room_code":"A05-119"},{"room_id":"1120","master_room_id":"114","room_code":"A05-118"},{"room_id":"1127","master_room_id":"114","room_code":"A05-125"},{"room_id":"1128","master_room_id":"114","room_code":"A05-126"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":370,"customer_code":"C170370","identity_type":"BUSINESS","identity_id":"35768902","title":"Ms","lastname":"Athena","firstname":"Chiu","companyname":"Goddess Collections Limited","email":"athena@goddesscollections.com","tel":"95509565","address":"Flat B,7\/F,Eredine No.38 Mount Kenette Road,The Peak Hong Kong ","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2206.0","renew_rent_month":"13","renew_warehousing_date":"2020-05-19","renew_room_key":"055,31265","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by bank transfer on April 18, 2019. Storage deposit transferred from agreement A12-CT183396 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT194780, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[{"master_room_discount_id":"77","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1271.00","discount":"16.82","monthly_deduct":257.0096,"room_id":"82","is_final_discount":"0","payment_term":"PREPAID_12_MO"},{"master_room_discount_id":"77","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1271.00","discount":"16.82","monthly_deduct":257.0096,"room_id":"93","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"93","room_code":"B41","retail_price":"1528.0","discounted_price":1271,"location_id":"1"},{"room_id":"82","room_code":"B30","retail_price":"1528.0","discounted_price":1271,"location_id":"1"}],"roughly_size":"40","total_retail_price":3056,"total_discounted_price":2206,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":26472,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-19","rent_from":"2020-05-19","rent_to":"2021-05-18","delivery_service":"0","remark":"12 months contract. Special renewal offer $300 Maxim Voucher. Storage rental paid by PPS on May 11, 2020. Storage deposit transferred from agreement A12-CT194780 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":26472,"final_order_total":26472,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,31265","order_product":[],"pass":true}},"first_order_id":4780,"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\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> B41 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \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> B30 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \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":"40","total_discounted_price":"2206.00","deposit":"0.00","total_retail_price":"3056.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:35:53","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",370,"NEW","A12-CT207831",3056,2206,0,0,"12","12",26472,26472,26472,"2020-05-12 19:35:53","0",null,null,null,"2020-05-19","2021-05-18","12 months contract. Special renewal offer $300 Maxim Voucher. Storage rental paid by PPS on May 11, 2020. Storage deposit transferred from agreement A12-CT194780 to this agreement.","2020-05-19","40",0,null,0,"0","2","2020-05-12 19:35:52","2","2020-05-12 19:35:52","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,31265","C170370","BUSINESS","Ms","sQFQFKDK2lCJDg4WUvEEAw==","8oP8wBkL42DbNXXhu5WkRQ==","Goddess Collections Limited","1g6tpg\/7Ew9M3eoDQajTyyekiJya2HktN4\/2VPzI+n2viSmiYMEufPdsg3iOJFM+L2pJBnoCpjcQFR1zXrDinA==","Tr9t25C8MzXYt5UvpJu9\/A==","Fcv29SZw0FesfYQ2LTjLIILGrkAlax45IehrRsoU7oc=",null,"GuFMDjWnG680nmMKqRLKPw==",1,4780]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:35:53","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":["7831","77","10","82","%","16.82",257.0096,"2","2020-05-12 19:35:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:35:53","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":["7831","77","10","93","%","16.82",257.0096,"2","2020-05-12 19:35:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:35:53","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":["7831","93","1528.0",1271,"2","2020-05-12 19:35:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:35:53","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-19","2021-05-18","93"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-12 19:35:53","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":["7831","82","1528.0",1271,"2","2020-05-12 19:35:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:35:53","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-19","2021-05-18","82"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-12 19:35:53","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":["7831",370,"SETTLED","A12-I208160","2020-05-12 19:35:52","2020-05-19","2","2020-05-12 19:35:52","2","2020-05-12 19:35:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:35:53","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":["8160","RENT","\u9810\u7e73\u79df\u91d1",1,2206,"MO","1",2206,"2","2020-05-12 19:35:52","2","2020-05-12 19:35:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:35:53","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":["8160","RENT","\u9810\u7e73\u79df\u91d1",2,2206,"MO","1",2206,"2","2020-05-12 19:35:52","2","2020-05-12 19:35:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:35:53","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":["8160","RENT","\u9810\u7e73\u79df\u91d1",3,2206,"MO","1",2206,"2","2020-05-12 19:35:52","2","2020-05-12 19:35:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:35:53","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":["8160","RENT","\u9810\u7e73\u79df\u91d1",4,2206,"MO","1",2206,"2","2020-05-12 19:35:52","2","2020-05-12 19:35:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:35:53","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":["8160","RENT","\u9810\u7e73\u79df\u91d1",5,2206,"MO","1",2206,"2","2020-05-12 19:35:52","2","2020-05-12 19:35:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:35:53","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":["8160","RENT","\u9810\u7e73\u79df\u91d1",6,2206,"MO","1",2206,"2","2020-05-12 19:35:52","2","2020-05-12 19:35:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:35:53","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":["8160","RENT","\u9810\u7e73\u79df\u91d1",7,2206,"MO","1",2206,"2","2020-05-12 19:35:52","2","2020-05-12 19:35:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:35:53","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":["8160","RENT","\u9810\u7e73\u79df\u91d1",8,2206,"MO","1",2206,"2","2020-05-12 19:35:52","2","2020-05-12 19:35:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:35:53","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":["8160","RENT","\u9810\u7e73\u79df\u91d1",9,2206,"MO","1",2206,"2","2020-05-12 19:35:52","2","2020-05-12 19:35:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:35:53","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":["8160","RENT","\u9810\u7e73\u79df\u91d1",10,2206,"MO","1",2206,"2","2020-05-12 19:35:52","2","2020-05-12 19:35:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:35:53","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":["8160","RENT","\u9810\u7e73\u79df\u91d1",11,2206,"MO","1",2206,"2","2020-05-12 19:35:52","2","2020-05-12 19:35:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:35:53","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":["8160","RENT","\u9810\u7e73\u79df\u91d1",12,2206,"MO","1",2206,"2","2020-05-12 19:35:52","2","2020-05-12 19:35:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:35:53","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[26472,0,"8160"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-12 19:35:53","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":[370,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207805","2020-05-12 19:35:52",26472,"2","2020-05-12 19:35:52","2","2020-05-12 19:35:52","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:35:53","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":["7805","DEPOSIT",null,"PAID","2020-05-12 19:35:52",0,"2","2020-05-12 19:35:52","2","2020-05-12 19:35:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:35:53","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":["7805","INVOICE","8160","PAID","2020-05-12 19:35:52",26472,"2","2020-05-12 19:35:52","2","2020-05-12 19:35:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:38:32","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"all=1&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1121","master_room_id":"114","room_code":"A05-119"},{"room_id":"1120","master_room_id":"114","room_code":"A05-118"},{"room_id":"1127","master_room_id":"114","room_code":"A05-125"},{"room_id":"1128","master_room_id":"114","room_code":"A05-126"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1134,"customer_code":"C181134","identity_type":"PERSONAL","identity_id":"Z017853(6)","title":"Mr","lastname":"Leung","firstname":"Wai Tat","companyname":"","email":"victorleung345@gmail.com","tel":"52255418","address":"Flat 06, 2\/F Yuet Chui Court 9, Yan Tsui St, Chai Wan, HK","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"356.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-10","renew_room_key":"0012472672","renew_remark":"1 month contract. Storage rental paid by PPS on March 17, 2020. Storage deposit transferred from agreement C15-CT207383 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT207667, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"158","order_discount":[],"order_room":[{"room_id":"1452","room_code":"C15-146","retail_price":"510.0","discounted_price":"510.00","location_id":"6"}],"roughly_size":"8.1","total_retail_price":510,"total_discounted_price":356,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":356,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-10","rent_from":"2020-05-10","rent_to":"2020-06-09","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on May 11, 2020. Storage deposit transferred from agreement C15-CT207667 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":356,"final_order_total":356,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012472672","order_product":[],"pass":true}},"first_order_id":"4805","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> C15-146 <\/td>\r\n\t\t\t\t\t 3X2.7X3 <\/td>\r\n\t\t\t\t\t $510.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/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":"8.1","total_discounted_price":"356.0","deposit":"0","total_retail_price":"510.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:38:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1134,"NEW","C15-CT207832",510,356,0,0,"1","1",356,356,356,"2020-05-12 19:38:32","0",null,null,null,"2020-05-10","2020-06-09","1 month contract. Storage rental paid by PPS on May 11, 2020. Storage deposit transferred from agreement C15-CT207667 to this agreement.","2020-05-10","8.1",0,null,0,"0","2","2020-05-12 19:38:32","2","2020-05-12 19:38:32","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0012472672","C181134","PERSONAL","Mr","S1eQwXaAsUdtzc1Ymck8Jg==","xEf2h2aoyRQ71ZVgBH+9WQ==","","596Kcg0kSfbD85GNFxMa7h8CY7zKszjQ7hj4A6ucjRZeYl+TO11xTTCVesXiaJ\/pTZeIYxCHmr9rgYiIkihiFg==","50+huvkYI7Tn4ZAWxVwcPw==","FRHJOJDYd5XByaT89nynmQawjlXgI0AS4R5zIEqR4E0=","XQVqohimdZ7JoGvCaH2ATQ==",null,1,"4805"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:38:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7832","1452","510.0","510.00","2","2020-05-12 19:38:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:38:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-10","2020-06-09","1452"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-12 19:38:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7832",1134,"SETTLED","C15-I208161","2020-05-12 19:38:32","2020-05-10","2","2020-05-12 19:38:32","2","2020-05-12 19:38:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:38:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8161","RENT","\u9810\u7e73\u79df\u91d1",1,356,"MO","1",356,"2","2020-05-12 19:38:32","2","2020-05-12 19:38:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:38:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[356,0,"8161"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-12 19:38:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1134,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207806","2020-05-12 19:38:32",356,"2","2020-05-12 19:38:32","2","2020-05-12 19:38:32","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:38:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7806","DEPOSIT",null,"PAID","2020-05-12 19:38:32",0,"2","2020-05-12 19:38:32","2","2020-05-12 19:38:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-12 19:38:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7806","INVOICE","8161","PAID","2020-05-12 19:38:32",356,"2","2020-05-12 19:38:32","2","2020-05-12 19:38:32"]},"data_before":[],"data_after":[],"step":1} *****