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

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

\u5009\u5eab\u7de8\u865f<\/td>\n	\u5c3a\u5bf8<\/td>\n	\u539f\u50f9(\u6708)<\/td>\n	\u512a\u60e0\u50f9(\u6708)<\/td>\n	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n	\u50f9\u683c<\/td>\n	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n	<\/td>\n <\/tr>
F02 <\/td>\n\t\t\t\t\t	4X3X8 <\/td>\n\t\t\t\t\t	$998.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>
F01 <\/td>\n\t\t\t\t\t	4X3X8 <\/td>\n\t\t\t\t\t	$998.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>
F13 <\/td>\n\t\t\t\t\t	4X4X8 <\/td>\n\t\t\t\t\t	$1098.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>
F12 <\/td>\n\t\t\t\t\t	4X4X8 <\/td>\n\t\t\t\t\t	$1098.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"56","total_discounted_price":"4138.00","deposit":"8276.00","total_retail_price":"4192.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 15:48:07","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":["C201624","PERSONAL","Mr","b8Q\/\/MN9YZXl3XD3LuyRXw==","Z\/P5RghDgz0XwoQL70fUUQ==","","znFY9109F10l0qpHfa92+Q==",null,"alxeJsd\/0rA+oQPk5VFKcgDu4ypCjQg4YeQyA6lpHbYUN8jmJMSfpoEe6zL5y\/H0","cqCk0ikw8+JsO0apyaArOg==",null,null,"zag3neEgoKh3c62GWBpeIA==","2","2020-06-15 15:48:05","2","2020-06-15 15:48:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 15:48:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1",1624,"NEW","A12-CT208132",4192,4138,8276,0,"4","4",18621,24828,18621,"2020-06-15 15:48:07","0",null,null,null,"2020-07-02","2020-11-01","4 months contract. Special offer 50% off for the first 3 months based on the original price. Storage rental and deposit paid by cheque on June 15,2020. Smart card provided on the same day.","2020-07-02","56",0,null,6207,"6207.00","2","2020-06-15 15:48:05","2","2020-06-15 15:48:05","CHEQUE","","","","CHEQUE","","","",null,0,"088,29644","C201624","PERSONAL","Mr","b8Q\/\/MN9YZXl3XD3LuyRXw==","Z\/P5RghDgz0XwoQL70fUUQ==","","alxeJsd\/0rA+oQPk5VFKcgDu4ypCjQg4YeQyA6lpHbYUN8jmJMSfpoEe6zL5y\/H0","znFY9109F10l0qpHfa92+Q==",null,"cqCk0ikw8+JsO0apyaArOg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 15:48:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8132","317","998.0","998.00","2","2020-06-15 15:48:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 15:48:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-02","2020-11-01","317"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-15 15:48:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8132","316","998.0","998.00","2","2020-06-15 15:48:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 15:48:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-02","2020-11-01","316"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-15 15:48:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8132","328","1098.0","1098.00","2","2020-06-15 15:48:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 15:48:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-02","2020-11-01","328"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-15 15:48:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8132","327","1098.0","1098.00","2","2020-06-15 15:48:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 15:48:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-02","2020-11-01","327"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-15 15:48:07","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":["8132","A12-D205471","PAID",8276,0,"2020-11-01","2020-06-15 15:48:05","2020-06-15 15:48:05","2","2020-06-15 15:48:05","2","2020-06-15 15:48:05",1624]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 15:48:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8132",1624,"SETTLED","A12-I208461","2020-06-15 15:48:05","2020-07-02","2","2020-06-15 15:48:05","2","2020-06-15 15:48:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 15:48:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8461","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-15 15:48:05","2","2020-06-15 15:48:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 15:48:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8461","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,2069,"MO","1",2069,"2","2020-06-15 15:48:05","2","2020-06-15 15:48:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 15:48:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8461","RENT","\u9810\u7e73\u79df\u91d1",3,4138,"MO","1",4138,"2","2020-06-15 15:48:05","2","2020-06-15 15:48:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 15:48:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8461","RENT","\u9810\u7e73\u79df\u91d1",4,4138,"MO","1",4138,"2","2020-06-15 15:48:05","2","2020-06-15 15:48:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 15:48:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10345,0,"8461"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-15 15:48:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1624,"CHEQUE","","","","CHEQUE","","","","PAID","P208104","2020-06-15 15:48:05",18621,"2","2020-06-15 15:48:05","2","2020-06-15 15:48:05","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 15:48:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8104","DEPOSIT","5471","PAID","2020-06-15 15:48:05",8276,"2","2020-06-15 15:48:05","2","2020-06-15 15:48:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 15:48:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8104","INVOICE","8461","PAID","2020-06-15 15:48:05",10345,"2","2020-06-15 15:48:05","2","2020-06-15 15:48:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 15:48:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:00: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=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1488,"customer_code":"C201488","identity_type":"PERSONAL","identity_id":"Z088839(8)","title":"Mr","lastname":"HO","firstname":"Ka Yu","companyname":"","email":"ofayyeung@gmail.com","tel":"66922831","address":"Flat %, 3\/F, Kong Fu Court, Aberdeen Centre, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"737.0","renew_rent_month":"3","renew_warehousing_date":"2020-06-14","renew_room_key":"'0012415172","renew_remark":"3 months contract. Storage rental paid by EPS on Mar 17,2020. Storage deposit $1550 transferred from agreement A05-CT207167 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207422, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"108","order_discount":[{"master_room_discount_id":"231","master_room_id":"108","discount_type":"%","price":"1006.00","disocunted_price":"905.40","discount":"10.00","monthly_deduct":100.6,"room_id":"1063","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1063","room_code":"A05-061","retail_price":"1006.0","discounted_price":905.4,"location_id":"4"}],"roughly_size":"9","total_retail_price":1006,"total_discounted_price":698,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":4188,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-14","rent_from":"2020-06-14","rent_to":"2020-12-13","delivery_service":"0","remark":"6 months contract. Storage rental paid by EPS on June 15,2020. Storage deposit $1550 transferred from agreement A05-CT207422 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":4188,"final_order_total":4188,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0012415172","order_product":[],"pass":true}},"first_order_id":"6953","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-061 <\/td>\r\n\t\t\t\t\t 3X3X7 <\/td>\r\n\t\t\t\t\t $1006.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":"9","total_discounted_price":"698.00","deposit":"0.00","total_retail_price":"1006.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:00:18","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",1488,"NEW","A05-CT208133",1006,698,0,0,"6","6",4188,4188,4188,"2020-06-15 16:00:18","0",null,null,null,"2020-06-14","2020-12-13","6 months contract. Storage rental paid by EPS on June 15,2020. Storage deposit $1550 transferred from agreement A05-CT207422 to this agreement. ","2020-06-14","9",0,null,0,"0","2","2020-06-15 16:00:17","2","2020-06-15 16:00:17","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"'0012415172","C201488","PERSONAL","Mr","f8XYjME4S7bFUqbGMta6lQ==","Zzv1eRCimQisUlUlw\/fpjg==","","G0DqRe7qjhKPGx\/xBTTOfkZj9PK2cXtWpGQaKEp9drmf1mJDIa4T67yQK6PXaGroPKe1kXil+G7i0kRQHfNH8Q==","JtEwh55Nke4GFrfYfJpr1Q==","AZDu+wknFwhYjI7GQSWpRWhCL1yTRGiLRIyDoNojrDM=","7QBn2SNCjVe7w65Aiokifg==",null,1,"6953"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:00:18","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":["8133","231","108","1063","%","10.00",100.6,"2","2020-06-15 16:00:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:00:18","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":["8133","1063","1006.0",905.4,"2","2020-06-15 16:00:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:00:18","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-14","2020-12-13","1063"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-15 16:00:18","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":["8133",1488,"SETTLED","A05-I208462","2020-06-15 16:00:17","2020-06-14","2","2020-06-15 16:00:17","2","2020-06-15 16:00:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:00:18","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":["8462","RENT","\u9810\u7e73\u79df\u91d1",1,698,"MO","1",698,"2","2020-06-15 16:00:17","2","2020-06-15 16:00:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:00:18","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":["8462","RENT","\u9810\u7e73\u79df\u91d1",2,698,"MO","1",698,"2","2020-06-15 16:00:17","2","2020-06-15 16:00:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:00:18","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":["8462","RENT","\u9810\u7e73\u79df\u91d1",3,698,"MO","1",698,"2","2020-06-15 16:00:17","2","2020-06-15 16:00:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:00:18","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":["8462","RENT","\u9810\u7e73\u79df\u91d1",4,698,"MO","1",698,"2","2020-06-15 16:00:17","2","2020-06-15 16:00:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:00:18","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":["8462","RENT","\u9810\u7e73\u79df\u91d1",5,698,"MO","1",698,"2","2020-06-15 16:00:17","2","2020-06-15 16:00:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:00:18","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":["8462","RENT","\u9810\u7e73\u79df\u91d1",6,698,"MO","1",698,"2","2020-06-15 16:00:17","2","2020-06-15 16:00:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:00:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4188,0,"8462"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-15 16:00:18","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":[1488,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P208105","2020-06-15 16:00:17",4188,"2","2020-06-15 16:00:17","2","2020-06-15 16:00:17","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:00:18","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":["8105","DEPOSIT",null,"PAID","2020-06-15 16:00:17",0,"2","2020-06-15 16:00:17","2","2020-06-15 16:00:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:00:18","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":["8105","INVOICE","8462","PAID","2020-06-15 16:00:17",4188,"2","2020-06-15 16:00:17","2","2020-06-15 16:00:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:29:44","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","'0012415172","6 months contract. Storage rental paid by EPS on June 15,2020. Storage deposit $1550 transferred from agreement A05-CT207422 to this agreement. ","2020-06-15 16:29:44","2","Zzv1eRCimQisUlUlw\/fpjg==","f8XYjME4S7bFUqbGMta6lQ==","AZDu+wknFwhYjI7GQSWpRWhCL1yTRGiLRIyDoNojrDM=","JtEwh55Nke4GFrfYfJpr1Q==","G0DqRe7qjhKPGx\/xBTTOfkZj9PK2cXtWpGQaKEp9drmf1mJDIa4T67yQK6PXaGroPKe1kXil+G7i0kRQHfNH8Q==",8133]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:30:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:30:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:30:45","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:33:37","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=1&filter2=1488&filter3=undefined","floor_plan_rent_room":[],"_payment_type":"INVOICE","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"Z088839(8)","title":"Mr","lastname":"HO","firstname":"Ka Yu","companyname":"","email":"ofayyeung@gmail.com","tel":"66922831","address":"Flat %, 3\/F, Kong Fu Court, Aberdeen Centre, Hong Kong","pass":true,"customer_id":"1488","customer_code":"C201488","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"231 available_room_list_input","master_room_id":"108","discount_type":"%","price":"1006.00","disocunted_price":"905.40","discount":"10.00","monthly_deduct":100.6,"room_id":"1063","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1063","room_code":"A05-061","retail_price":"1006.0","discounted_price":905.4,"location_id":"4"}],"roughly_size":"9","total_retail_price":1006,"total_discounted_price":737,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":4422,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-14","rent_from":"2020-06-14","rent_to":"2020-12-13","delivery_service":"0","remark":"6 months contract. Storage rental paid by EPS on June 15,2020. Storage deposit $1550 transferred from agreement A05-CT207422 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":4422,"final_order_total":4422,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0012415172","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n\n \n \n \n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> A05-061 <\/td>\n\t\t\t\t\t 3X3X7 <\/td>\n\t\t\t\t\t $1006.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"9","total_discounted_price":"737.00","deposit":"0.00","total_retail_price":"1006.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:33:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","4","1488","NEW","A05-CT208134",1006,737,0,0,"6","6",4422,4422,4422,"2020-06-15 16:33:38","0",null,null,null,"2020-06-14","2020-12-13","6 months contract. Storage rental paid by EPS on June 15,2020. Storage deposit $1550 transferred from agreement A05-CT207422 to this agreement. ","2020-06-14","9",0,null,0,"0","2","2020-06-15 16:33:37","2","2020-06-15 16:33:37","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"'0012415172","C201488","PERSONAL","Mr","f8XYjME4S7bFUqbGMta6lQ==","Zzv1eRCimQisUlUlw\/fpjg==","","G0DqRe7qjhKPGx\/xBTTOfkZj9PK2cXtWpGQaKEp9drmf1mJDIa4T67yQK6PXaGroPKe1kXil+G7i0kRQHfNH8Q==","JtEwh55Nke4GFrfYfJpr1Q==","AZDu+wknFwhYjI7GQSWpRWhCL1yTRGiLRIyDoNojrDM=","7QBn2SNCjVe7w65Aiokifg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:33:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["8134","231 available_room_list_input","108","1063","%","10.00",100.6,"2","2020-06-15 16:33:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:33:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8134","1063","1006.0",905.4,"2","2020-06-15 16:33:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:33:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-14","2020-12-13","1063"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-15 16:33:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8134","1488","SETTLED","A05-I208463","2020-06-15 16:33:37","2020-06-14","2","2020-06-15 16:33:37","2","2020-06-15 16:33:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:33:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8463","RENT","\u9810\u7e73\u79df\u91d1",1,737,"MO","1",737,"2","2020-06-15 16:33:37","2","2020-06-15 16:33:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:33:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8463","RENT","\u9810\u7e73\u79df\u91d1",2,737,"MO","1",737,"2","2020-06-15 16:33:37","2","2020-06-15 16:33:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:33:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8463","RENT","\u9810\u7e73\u79df\u91d1",3,737,"MO","1",737,"2","2020-06-15 16:33:37","2","2020-06-15 16:33:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:33:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8463","RENT","\u9810\u7e73\u79df\u91d1",4,737,"MO","1",737,"2","2020-06-15 16:33:37","2","2020-06-15 16:33:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:33:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8463","RENT","\u9810\u7e73\u79df\u91d1",5,737,"MO","1",737,"2","2020-06-15 16:33:37","2","2020-06-15 16:33:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:33:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8463","RENT","\u9810\u7e73\u79df\u91d1",6,737,"MO","1",737,"2","2020-06-15 16:33:37","2","2020-06-15 16:33:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:33:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4422,0,"8463"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-15 16:33:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1488","NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P208106","2020-06-15 16:33:37",4422,"2","2020-06-15 16:33:37","2","2020-06-15 16:33:37","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:33:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8106","DEPOSIT",null,"PAID","2020-06-15 16:33:37",0,"2","2020-06-15 16:33:37","2","2020-06-15 16:33:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:33:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8106","INVOICE","8463","PAID","2020-06-15 16:33:37",4422,"2","2020-06-15 16:33:37","2","2020-06-15 16:33:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:38:14","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","'0012415172","6 months contract. Storage rental paid by EPS on June 15,2020. Storage deposit $1550 transferred from agreement A05-CT207422 to this agreement. ","2020-06-15 16:38:14","2","Zzv1eRCimQisUlUlw\/fpjg==","f8XYjME4S7bFUqbGMta6lQ==","AZDu+wknFwhYjI7GQSWpRWhCL1yTRGiLRIyDoNojrDM=","JtEwh55Nke4GFrfYfJpr1Q==","G0DqRe7qjhKPGx\/xBTTOfkZj9PK2cXtWpGQaKEp9drmf1mJDIa4T67yQK6PXaGroPKe1kXil+G7i0kRQHfNH8Q==",8134]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:38:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:39:45","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":"","floor_plan_rent_room":[{"room_id":"1063","master_room_id":"108","room_code":"A05-061"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-061 <\/td>\r\n\t\t\t\t\t 3X3X7 <\/td>\r\n\t\t\t\t\t $1006.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":"Z088839(8)","title":"Mr","lastname":"HO","firstname":"Ka Yu","companyname":"","email":"ofayyeung@gmail.com","tel":"66922831","address":"Flat %, 3\/F, Kong Fu Court, Aberdeen Centre, Hong Kong","pass":true,"customer_id":"1488","customer_code":"C201488","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"231","master_room_id":"108","discount_type":"%","price":"1006.00","disocunted_price":"905.40","discount":"10.00","monthly_deduct":100.6,"room_id":"1063","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1063","room_code":"A05-061","retail_price":"1006.0","discounted_price":905.4,"location_id":"4"}],"roughly_size":"9","total_retail_price":1006,"total_discounted_price":698,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":4188,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-14","rent_from":"2020-06-14","rent_to":"2020-12-13","delivery_service":"0","remark":"6 months contract. Storage rental paid by EPS on June 15,2020. Storage deposit $1550 transferred from agreement A05-CT207422 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":4188,"final_order_total":4188,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0012415172","order_product":[],"pass":true}},"roughly_size":"9","total_discounted_price":"698.00","deposit":"0.00","total_retail_price":"1006.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:39:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","4","1488","NEW","A05-CT208135",1006,698,0,0,"6","6",4188,4188,4188,"2020-06-15 16:39:46","0",null,null,null,"2020-06-14","2020-12-13","6 months contract. Storage rental paid by EPS on June 15,2020. Storage deposit $1550 transferred from agreement A05-CT207422 to this agreement. ","2020-06-14","9",0,null,0,"0","2","2020-06-15 16:39:45","2","2020-06-15 16:39:45","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"'0012415172","C201488","PERSONAL","Mr","f8XYjME4S7bFUqbGMta6lQ==","Zzv1eRCimQisUlUlw\/fpjg==","","G0DqRe7qjhKPGx\/xBTTOfkZj9PK2cXtWpGQaKEp9drmf1mJDIa4T67yQK6PXaGroPKe1kXil+G7i0kRQHfNH8Q==","JtEwh55Nke4GFrfYfJpr1Q==","AZDu+wknFwhYjI7GQSWpRWhCL1yTRGiLRIyDoNojrDM=","7QBn2SNCjVe7w65Aiokifg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:39:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["8135","231","108","1063","%","10.00",100.6,"2","2020-06-15 16:39:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:39:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8135","1063","1006.0",905.4,"2","2020-06-15 16:39:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:39:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-14","2020-12-13","1063"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-15 16:39:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8135","1488","SETTLED","A05-I208464","2020-06-15 16:39:45","2020-06-14","2","2020-06-15 16:39:45","2","2020-06-15 16:39:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:39:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8464","RENT","\u9810\u7e73\u79df\u91d1",1,698,"MO","1",698,"2","2020-06-15 16:39:45","2","2020-06-15 16:39:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:39:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8464","RENT","\u9810\u7e73\u79df\u91d1",2,698,"MO","1",698,"2","2020-06-15 16:39:45","2","2020-06-15 16:39:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:39:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8464","RENT","\u9810\u7e73\u79df\u91d1",3,698,"MO","1",698,"2","2020-06-15 16:39:45","2","2020-06-15 16:39:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:39:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8464","RENT","\u9810\u7e73\u79df\u91d1",4,698,"MO","1",698,"2","2020-06-15 16:39:45","2","2020-06-15 16:39:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:39:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8464","RENT","\u9810\u7e73\u79df\u91d1",5,698,"MO","1",698,"2","2020-06-15 16:39:45","2","2020-06-15 16:39:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:39:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8464","RENT","\u9810\u7e73\u79df\u91d1",6,698,"MO","1",698,"2","2020-06-15 16:39:45","2","2020-06-15 16:39:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:39:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4188,0,"8464"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-15 16:39:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1488","NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P208107","2020-06-15 16:39:45",4188,"2","2020-06-15 16:39:45","2","2020-06-15 16:39:45","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:39:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8107","DEPOSIT",null,"PAID","2020-06-15 16:39:45",0,"2","2020-06-15 16:39:45","2","2020-06-15 16:39:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:39:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8107","INVOICE","8464","PAID","2020-06-15 16:39:45",4188,"2","2020-06-15 16:39:45","2","2020-06-15 16:39:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:41:13","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","088,29644","4 months contract. Special offer 50% off for the first 3 months based on the original price. Storage rental and deposit paid by cheque on June 15,2020. Smart card provided on the same day.","2020-06-15 16:41:13","2","Z\/P5RghDgz0XwoQL70fUUQ==","b8Q\/\/MN9YZXl3XD3LuyRXw==","znFY9109F10l0qpHfa92+Q==","alxeJsd\/0rA+oQPk5VFKcgDu4ypCjQg4YeQyA6lpHbYUN8jmJMSfpoEe6zL5y\/H0",8132]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:44:06","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":"","floor_plan_rent_room":[{"room_id":"327","master_room_id":"8","room_code":"F12"}],"_payment_type":"INVOICE","selected_room_tr":"\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n\t\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\t\t\t \n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> F02 <\/td>\n\t\t\t\t\t 4X3X8 <\/td>\n\t\t\t\t\t $998.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr> F01 <\/td>\n\t\t\t\t\t 4X3X8 <\/td>\n\t\t\t\t\t $998.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr> F13 <\/td>\n\t\t\t\t\t 4X4X8 <\/td>\n\t\t\t\t\t $1098.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr> F12 <\/td>\n\t\t\t\t\t 4X4X8 <\/td>\n\t\t\t\t\t $1098.00 <\/td>\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"A741122(A)","title":"Mr","lastname":"YUEN","firstname":"Chi Wing","companyname":"","email":"","tel":"98469558","address":"Flat D, 12\/F, Blk 1, Ocean Court, Aberdeen, HK","pass":true,"customer_id":"1624","customer_code":"C201624","customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"317","room_code":"F02","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"316","room_code":"F01","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"328","room_code":"F13","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"},{"room_id":"327","room_code":"F12","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"56","total_retail_price":4192,"total_discounted_price":4138,"deposit":8276,"rent_month":"4","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"4","prepaid_amount":18414,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"6414.00","warehousing_date":"2020-07-02","rent_from":"2020-07-02","rent_to":"2020-11-01","delivery_service":"0","remark":"4 months contract. Special offer 50% off for the first 3 months based on the original price. Storage rental and deposit paid by cheque on June 15,2020. Smart card provided on the same day.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":6414,"order_total":24828,"final_order_total":18414,"location_id":"1","branch_id":"1","company_id":"1","room_key":"088,29644","order_product":[],"pass":true}},"roughly_size":"56","total_discounted_price":"4138.00","deposit":"8276.00","total_retail_price":"4192.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:44:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1","1624","NEW","A12-CT208136",4192,4138,8276,0,"4","4",18414,24828,18414,"2020-06-15 16:44:07","0",null,null,null,"2020-07-02","2020-11-01","4 months contract. Special offer 50% off for the first 3 months based on the original price. Storage rental and deposit paid by cheque on June 15,2020. Smart card provided on the same day.","2020-07-02","56",0,null,6414,"6414.00","2","2020-06-15 16:44:06","2","2020-06-15 16:44:06","CHEQUE","","","","CHEQUE","","","",null,0,"088,29644","C201624","PERSONAL","Mr","b8Q\/\/MN9YZXl3XD3LuyRXw==","Z\/P5RghDgz0XwoQL70fUUQ==","","alxeJsd\/0rA+oQPk5VFKcgDu4ypCjQg4YeQyA6lpHbYUN8jmJMSfpoEe6zL5y\/H0","znFY9109F10l0qpHfa92+Q==",null,"cqCk0ikw8+JsO0apyaArOg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:44:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8136","317","998.0","998.00","2","2020-06-15 16:44:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:44:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-02","2020-11-01","317"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-15 16:44:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8136","316","998.0","998.00","2","2020-06-15 16:44:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:44:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-02","2020-11-01","316"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-15 16:44:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8136","328","1098.0","1098.00","2","2020-06-15 16:44:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:44:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-02","2020-11-01","328"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-15 16:44:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8136","327","1098.0","1098.00","2","2020-06-15 16:44:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:44:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-02","2020-11-01","327"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-15 16:44:07","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":["8136","A12-D205472","PAID",8276,0,"2020-11-01","2020-06-15 16:44:06","2020-06-15 16:44:06","2","2020-06-15 16:44:06","2","2020-06-15 16:44:06","1624"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:44:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8136","1624","SETTLED","A12-I208465","2020-06-15 16:44:06","2020-07-02","2","2020-06-15 16:44:06","2","2020-06-15 16:44:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:44:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8465","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-15 16:44:06","2","2020-06-15 16:44:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:44:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8465","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1862,"MO","1",1862,"2","2020-06-15 16:44:06","2","2020-06-15 16:44:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:44:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8465","RENT","\u9810\u7e73\u79df\u91d1",3,4138,"MO","1",4138,"2","2020-06-15 16:44:06","2","2020-06-15 16:44:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:44:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8465","RENT","\u9810\u7e73\u79df\u91d1",4,4138,"MO","1",4138,"2","2020-06-15 16:44:06","2","2020-06-15 16:44:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:44:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10138,0,"8465"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-15 16:44:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1624","CHEQUE","","","","CHEQUE","","","","PAID","P208108","2020-06-15 16:44:06",18414,"2","2020-06-15 16:44:06","2","2020-06-15 16:44:06","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:44:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8108","DEPOSIT","5472","PAID","2020-06-15 16:44:06",8276,"2","2020-06-15 16:44:06","2","2020-06-15 16:44:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 16:44:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8108","INVOICE","8465","PAID","2020-06-15 16:44:06",10138,"2","2020-06-15 16:44:06","2","2020-06-15 16:44:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 17:18:51","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 17:20:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:03:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:10:53","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":"","floor_plan_rent_room":[{"room_id":"1482","master_room_id":"172","room_code":"C15-176"}],"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> C15-176 <\/td>\r\n\t\t\t\t\t 4X5X6.5 <\/td>\r\n\t\t\t\t\t $1115.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":"1","identity_type":"PERSONAL","identity_id":"K581142(2)","title":"Mr","lastname":"MOK","firstname":"Yu King","companyname":"","email":"","tel":"60188296","address":"Room 1113, Wah Lim House, Wah Kwai Estate, Aberdeen, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1482","room_code":"C15-176","retail_price":"1115.0","discounted_price":"1115.00","location_id":"6"}],"roughly_size":"20","total_retail_price":1115,"total_discounted_price":1115,"deposit":1115,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2175,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"55.00","warehousing_date":"2020-06-20","rent_from":"2020-06-20","rent_to":"2020-07-19","delivery_service":"0","remark":"1 month contract. Spacial offer 5% \"rent now\" discount. Storage rental and deposit paid by cash on June 15, 2020. Smartcard paid by cash on June 15, 2020. ","paymethod":"CASH","paymethod2":"CASH","discount_deduct":55,"order_total":2290,"final_order_total":2235,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012385527","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"pass":true}},"roughly_size":"20","total_discounted_price":"1115.00","deposit":"1115.00","total_retail_price":"1115.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:10:54","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":["C201625","PERSONAL","Mr","JI9KGFZ4hZbC\/Ycj+PsvPQ==","q0MdcWcu88smVrmTzq+u8Q==","","5oIulHD3qb\/+coGPm+CwqQ==",null,"GUZCw\/Ps1TVfEUMG8s3VKQ2IBHvWn9kHM4O0\/dJe8JG7TUtrhME2oKEVMlsz8lb5IWXjPTRe5Ccw8aVfbDDeHw==","4kKW0YPDwkYUaAPIHPxrDQ==",null,null,"ekXNs4EcHdli0CuQ3S9Ojg==","2","2020-06-15 18:10:53","2","2020-06-15 18:10:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:10:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","3","6",1625,"NEW","C15-CT208137",1115,1115,1115,0,"1","1",2175,2290,2235,"2020-06-15 18:10:55","0",null,null,null,"2020-06-20","2020-07-19","1 month contract. Spacial offer 5% \"rent now\" discount. Storage rental and deposit paid by cash on June 15, 2020. Smartcard paid by cash on June 15, 2020. ","2020-06-20","20",0,null,55,"55.00","2","2020-06-15 18:10:53","2","2020-06-15 18:10:53","CASH","","","","CASH","","","",null,0,"'0012385527","C201625","PERSONAL","Mr","JI9KGFZ4hZbC\/Ycj+PsvPQ==","q0MdcWcu88smVrmTzq+u8Q==","","GUZCw\/Ps1TVfEUMG8s3VKQ2IBHvWn9kHM4O0\/dJe8JG7TUtrhME2oKEVMlsz8lb5IWXjPTRe5Ccw8aVfbDDeHw==","5oIulHD3qb\/+coGPm+CwqQ==",null,"4kKW0YPDwkYUaAPIHPxrDQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:10:55","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":["8137",1625,"11","1","60.0",60,"2","2020-06-15 18:10:53","2","2020-06-15 18:10:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:10:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"8137"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-06-15 18:10:55","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":["8137","1482","1115.0","1115.00","2","2020-06-15 18:10:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:10:55","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-20","2020-07-19","1482"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-15 18:10:55","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":["8137","C15-D205473","PAID",1115,0,"2020-07-19","2020-06-15 18:10:53","2020-06-15 18:10:53","2","2020-06-15 18:10:53","2","2020-06-15 18:10:53",1625]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:10:55","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":["8137",1625,"SETTLED","C15-I208466","2020-06-15 18:10:53","2020-06-20","2","2020-06-15 18:10:53","2","2020-06-15 18:10:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:10:55","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":["8466","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,1060,"MO","1",1060,"2","2020-06-15 18:10:53","2","2020-06-15 18:10:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:10:55","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":["8466","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-06-15 18:10:53","2","2020-06-15 18:10:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:10:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1120,0,"8466"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-15 18:10:55","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":[1625,"CASH","","","","CASH","","","","PAID","P208109","2020-06-15 18:10:53",2235,"2","2020-06-15 18:10:53","2","2020-06-15 18:10:53","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:10:55","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":["8109","DEPOSIT","5473","PAID","2020-06-15 18:10:53",1115,"2","2020-06-15 18:10:53","2","2020-06-15 18:10:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:10:55","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":["8109","INVOICE","8466","PAID","2020-06-15 18:10:53",1120,"2","2020-06-15 18:10:53","2","2020-06-15 18:10:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:14: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":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1303,"customer_code":"C191303","identity_type":"PERSONAL","identity_id":"Z701011(8)","title":"Mr","lastname":"CHAN ","firstname":"YIU FUNG","companyname":"","email":null,"tel":"98782175","address":"Rm 1616, Sau Fung House, Fung Wah Estate, Chai Wai","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1004.0","renew_rent_month":"12","renew_warehousing_date":"2020-06-16","renew_room_key":"0005796001,0005763930","renew_remark":"12 months contract. special offer 5% "rent now", storage rental and deposit paid by cash on 15 June, 2019. smartcard provided on 15 June,2019.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT195237, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1115.0","renew_master_room_id":"172","order_discount":[],"order_room":[{"room_id":"1339","room_code":"C15-033","retail_price":"1115.0","discounted_price":"1115.00","location_id":"6"}],"roughly_size":"20","total_retail_price":1115,"total_discounted_price":1004,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":12048,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-16","rent_from":"2020-06-16","rent_to":"2021-06-15","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on June 15,2020. Storage deposit $1115 transferred from agreement C15-CT195237 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":12048,"final_order_total":12048,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0005796001,0005763930","order_product":[],"pass":true}},"first_order_id":5237,"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-033 <\/td>\r\n\t\t\t\t\t 4X5X6.5 <\/td>\r\n\t\t\t\t\t $1115.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":"20","total_discounted_price":"1004.0","deposit":"0","total_retail_price":"1115.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:14:33","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",1303,"NEW","C15-CT208138",1115,1004,0,0,"12","12",12048,12048,12048,"2020-06-15 18:14:33","0",null,null,null,"2020-06-16","2021-06-15","12 months contract. Storage rental paid by bank transfer on June 15,2020. Storage deposit $1115 transferred from agreement C15-CT195237 to this agreement.","2020-06-16","20",0,null,0,"0","2","2020-06-15 18:14:32","2","2020-06-15 18:14:32","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005796001,0005763930","C191303","PERSONAL","Mr","WII+XxKW7TQ1HMEU73cQvA==","0K\/ETRMCgbsMtZHiL99m2Q==","","z575tXRzmY5+XHoFeH2JAqjSCcnoYfrCuPfFnbTnz1d0TbarCJS3OOjeHSdoQrB76w2P5hoLarkIyXFkXOL7Mw==","1RBWKUlISektdMfN\/JUtMQ==",null,"BFadAv8qR3t\/d06Q086TBQ==",null,1,5237]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:14:33","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":["8138","1339","1115.0","1115.00","2","2020-06-15 18:14:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:14:33","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-16","2021-06-15","1339"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-15 18:14:33","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":["8138",1303,"SETTLED","C15-I208467","2020-06-15 18:14:32","2020-06-16","2","2020-06-15 18:14:32","2","2020-06-15 18:14:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:14:33","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":["8467","RENT","\u9810\u7e73\u79df\u91d1",1,1004,"MO","1",1004,"2","2020-06-15 18:14:32","2","2020-06-15 18:14:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:14:33","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":["8467","RENT","\u9810\u7e73\u79df\u91d1",2,1004,"MO","1",1004,"2","2020-06-15 18:14:32","2","2020-06-15 18:14:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:14:33","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":["8467","RENT","\u9810\u7e73\u79df\u91d1",3,1004,"MO","1",1004,"2","2020-06-15 18:14:32","2","2020-06-15 18:14:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:14:33","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":["8467","RENT","\u9810\u7e73\u79df\u91d1",4,1004,"MO","1",1004,"2","2020-06-15 18:14:32","2","2020-06-15 18:14:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:14:33","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":["8467","RENT","\u9810\u7e73\u79df\u91d1",5,1004,"MO","1",1004,"2","2020-06-15 18:14:32","2","2020-06-15 18:14:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:14:33","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":["8467","RENT","\u9810\u7e73\u79df\u91d1",6,1004,"MO","1",1004,"2","2020-06-15 18:14:32","2","2020-06-15 18:14:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:14:33","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":["8467","RENT","\u9810\u7e73\u79df\u91d1",7,1004,"MO","1",1004,"2","2020-06-15 18:14:32","2","2020-06-15 18:14:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:14:33","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":["8467","RENT","\u9810\u7e73\u79df\u91d1",8,1004,"MO","1",1004,"2","2020-06-15 18:14:32","2","2020-06-15 18:14:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:14:33","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":["8467","RENT","\u9810\u7e73\u79df\u91d1",9,1004,"MO","1",1004,"2","2020-06-15 18:14:32","2","2020-06-15 18:14:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:14:33","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":["8467","RENT","\u9810\u7e73\u79df\u91d1",10,1004,"MO","1",1004,"2","2020-06-15 18:14:32","2","2020-06-15 18:14:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:14:33","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":["8467","RENT","\u9810\u7e73\u79df\u91d1",11,1004,"MO","1",1004,"2","2020-06-15 18:14:32","2","2020-06-15 18:14:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:14:33","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":["8467","RENT","\u9810\u7e73\u79df\u91d1",12,1004,"MO","1",1004,"2","2020-06-15 18:14:32","2","2020-06-15 18:14:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:14:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[12048,0,"8467"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-15 18:14:33","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":[1303,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208110","2020-06-15 18:14:32",12048,"2","2020-06-15 18:14:32","2","2020-06-15 18:14:32","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:14:33","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":["8110","DEPOSIT",null,"PAID","2020-06-15 18:14:32",0,"2","2020-06-15 18:14:32","2","2020-06-15 18:14:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:14:33","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":["8110","INVOICE","8467","PAID","2020-06-15 18:14:32",12048,"2","2020-06-15 18:14:32","2","2020-06-15 18:14:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:14:35","login_id":"1","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:25:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:31:06","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1539,"customer_code":"C201539","identity_type":"PERSONAL","identity_id":"Y064298(1)","title":"Ms","lastname":"TONG","firstname":"Ka Ming","companyname":"","email":"kaming.tong928@gmail.com","tel":"60266931","address":"\u5c07\u8ecd\u6fb3\u539a\u5fb7\u6751\u5fb7\u88d5\u6a1337\u6a134\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3058.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-17","renew_room_key":"0005795970","renew_remark":"1 month contract. Storage rental paid by bank transfer on May 15, 2020. Storage deposit $6116 transfered from agreement B01-CT207611 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT207855, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"143","order_discount":[],"order_room":[{"room_id":"1213","room_code":"B01-023","retail_price":"1838.0","discounted_price":"1838.00","location_id":"5"},{"room_id":"1214","room_code":"B01-024","retail_price":"1488.0","discounted_price":"1488.00","location_id":"5"}],"roughly_size":"54","total_retail_price":3326,"total_discounted_price":3058,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":3058,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-17","rent_from":"2020-06-17","rent_to":"2020-07-16","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Jun 15, 2020. Storage deposit $6116 transfered from agreement B01-CT207855 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3058,"final_order_total":3058,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0005795970","order_product":[],"pass":true}},"first_order_id":"7430","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> B01-023 <\/td>\r\n\t\t\t\t\t 5X6X7 <\/td>\r\n\t\t\t\t\t $1838.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> B01-024 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1488.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"54","total_discounted_price":"3058.0","deposit":"0","total_retail_price":"3326.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:31:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","2","5",1539,"NEW","B01-CT208139",3326,3058,0,0,"1","1",3058,3058,3058,"2020-06-15 18:31:06","0",null,null,null,"2020-06-17","2020-07-16","1 month contract. Storage rental paid by bank transfer on Jun 15, 2020. Storage deposit $6116 transfered from agreement B01-CT207855 to this agreement.","2020-06-17","54",0,null,0,"0","2","2020-06-15 18:31:06","2","2020-06-15 18:31:06","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005795970","C201539","PERSONAL","Ms","emjjkRBZVUSRLbEK77SFEw==","gXED7wniUUNHTT8LsF+fbg==","","bNlP7L7RLt8Fl8B\/yay2q\/dmX7vl9M\/ct23uQR74gJmaO+DCNAZgg0xupPoXF2Hi","rzzpVRFrFmmseYl9vvbFwA==","YSHrDxAftHtY\/YX7L1PEr5QDC4wwmDjJTX59NG9kGk0=","0ux6P2R1VhDModzCYtVS5A==",null,1,"7430"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:31:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8139","1213","1838.0","1838.00","2","2020-06-15 18:31:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:31:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-17","2020-07-16","1213"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-15 18:31:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8139","1214","1488.0","1488.00","2","2020-06-15 18:31:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:31:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-17","2020-07-16","1214"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-15 18:31:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8139",1539,"SETTLED","B01-I208468","2020-06-15 18:31:06","2020-06-17","2","2020-06-15 18:31:06","2","2020-06-15 18:31:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:31:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8468","RENT","\u9810\u7e73\u79df\u91d1",1,3058,"MO","1",3058,"2","2020-06-15 18:31:06","2","2020-06-15 18:31:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:31:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3058,0,"8468"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-15 18:31:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1539,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208111","2020-06-15 18:31:06",3058,"2","2020-06-15 18:31:06","2","2020-06-15 18:31:06","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:31:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8111","DEPOSIT",null,"PAID","2020-06-15 18:31:06",0,"2","2020-06-15 18:31:06","2","2020-06-15 18:31:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:31:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8111","INVOICE","8468","PAID","2020-06-15 18:31:06",3058,"2","2020-06-15 18:31:06","2","2020-06-15 18:31:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:32:30","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":{"1":{"room_id":"1477","master_room_id":"173","room_code":"C15-171"}},"selected_room_tr":"\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n\t\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\t\t\t \n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-171 <\/td>\n\t\t\t\t\t 4X6X6.5 <\/td>\n\t\t\t\t\t $1322.00 <\/td>\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\u522a\u9664<\/button>\n\t\t\t\t\t<\/td><\/tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"D542702(A)","title":"Ms","lastname":"CHEUNG","firstname":"FUNG SIN","companyname":"","email":"","tel":"90724818","address":"Flat 17A, New Jade Garden Block A, Chai Wan, H.K","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1477","room_code":"C15-171","retail_price":"1322.0","discounted_price":"1322.00","location_id":"6"}],"roughly_size":"24","total_retail_price":1322,"total_discounted_price":1190,"deposit":1322,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":14834,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"768.00","warehousing_date":"2020-06-20","rent_from":"2020-06-20","rent_to":"2021-06-19","delivery_service":"0","remark":"12 months contract. Special offer 5% for 'rent now'. Storage rental and deposit paid by cheque on June 15,2020. Smart card provided on June 15,2020.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":768,"order_total":15662,"final_order_total":14894,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012385346","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"pass":true}},"roughly_size":"24","total_discounted_price":"1190.00","deposit":"1322.00","total_retail_price":"1322.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:32:31","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":["C201626","PERSONAL","Ms","mWWXXorE9n1X9Th1dKhoxA==","ts1WQ6NWxfSAyKGz8YWojw==","","b4rXw1j4fORuYnXgWQx6mw==",null,"AS2vRF9UPUxod0AkI0bWo8bsxUw+DVUK7UNPmg48E2n50BSrP\/jxj6IIuMuQkf4C1yQyHMTOg+DgijXrosRWzQ==","ThQPqDvRJeWvnBgAsobCXQ==",null,null,"Tj1k68N\/3hFDf\/vbjlmePw==","2","2020-06-15 18:32:30","2","2020-06-15 18:32:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:32: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` = ?","parameters":["1","3","6",1626,"NEW","C15-CT208140",1322,1190,1322,0,"12","12",14834,15662,14894,"2020-06-15 18:32:32","0",null,null,null,"2020-06-20","2021-06-19","12 months contract. Special offer 5% for 'rent now'. Storage rental and deposit paid by cheque on June 15,2020. Smart card provided on June 15,2020.","2020-06-20","24",0,null,768,"768.00","2","2020-06-15 18:32:30","2","2020-06-15 18:32:30","CHEQUE","","","","CHEQUE","","","",null,0,"'0012385346","C201626","PERSONAL","Ms","mWWXXorE9n1X9Th1dKhoxA==","ts1WQ6NWxfSAyKGz8YWojw==","","AS2vRF9UPUxod0AkI0bWo8bsxUw+DVUK7UNPmg48E2n50BSrP\/jxj6IIuMuQkf4C1yQyHMTOg+DgijXrosRWzQ==","b4rXw1j4fORuYnXgWQx6mw==",null,"ThQPqDvRJeWvnBgAsobCXQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:32:32","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":["8140",1626,"11","1","60.0",60,"2","2020-06-15 18:32:30","2","2020-06-15 18:32:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:32:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"8140"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-06-15 18:32: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":["8140","1477","1322.0","1322.00","2","2020-06-15 18:32:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:32: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-06-20","2021-06-19","1477"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-15 18:32:32","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":["8140","C15-D205474","PAID",1322,0,"2021-06-19","2020-06-15 18:32:30","2020-06-15 18:32:30","2","2020-06-15 18:32:30","2","2020-06-15 18:32:30",1626]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:32: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":["8140",1626,"SETTLED","C15-I208469","2020-06-15 18:32:30","2020-06-20","2","2020-06-15 18:32:30","2","2020-06-15 18:32:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:32: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":["8469","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,422,"MO","1",422,"2","2020-06-15 18:32:30","2","2020-06-15 18:32:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:32: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":["8469","RENT","\u9810\u7e73\u79df\u91d1",2,1190,"MO","1",1190,"2","2020-06-15 18:32:30","2","2020-06-15 18:32:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:32: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":["8469","RENT","\u9810\u7e73\u79df\u91d1",3,1190,"MO","1",1190,"2","2020-06-15 18:32:30","2","2020-06-15 18:32:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:32: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":["8469","RENT","\u9810\u7e73\u79df\u91d1",4,1190,"MO","1",1190,"2","2020-06-15 18:32:30","2","2020-06-15 18:32:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:32: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":["8469","RENT","\u9810\u7e73\u79df\u91d1",5,1190,"MO","1",1190,"2","2020-06-15 18:32:30","2","2020-06-15 18:32:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:32: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":["8469","RENT","\u9810\u7e73\u79df\u91d1",6,1190,"MO","1",1190,"2","2020-06-15 18:32:30","2","2020-06-15 18:32:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:32: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":["8469","RENT","\u9810\u7e73\u79df\u91d1",7,1190,"MO","1",1190,"2","2020-06-15 18:32:30","2","2020-06-15 18:32:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:32: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":["8469","RENT","\u9810\u7e73\u79df\u91d1",8,1190,"MO","1",1190,"2","2020-06-15 18:32:30","2","2020-06-15 18:32:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:32: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":["8469","RENT","\u9810\u7e73\u79df\u91d1",9,1190,"MO","1",1190,"2","2020-06-15 18:32:30","2","2020-06-15 18:32:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:32: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":["8469","RENT","\u9810\u7e73\u79df\u91d1",10,1190,"MO","1",1190,"2","2020-06-15 18:32:30","2","2020-06-15 18:32:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:32: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":["8469","RENT","\u9810\u7e73\u79df\u91d1",11,1190,"MO","1",1190,"2","2020-06-15 18:32:30","2","2020-06-15 18:32:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:32: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":["8469","RENT","\u9810\u7e73\u79df\u91d1",12,1190,"MO","1",1190,"2","2020-06-15 18:32:30","2","2020-06-15 18:32:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:32:32","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":["8469","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-06-15 18:32:30","2","2020-06-15 18:32:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:32:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13572,0,"8469"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-15 18:32: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":[1626,"CHEQUE","","","","CHEQUE","","","","PAID","P208112","2020-06-15 18:32:30",14894,"2","2020-06-15 18:32:30","2","2020-06-15 18:32:30","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:32: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":["8112","DEPOSIT","5474","PAID","2020-06-15 18:32:30",1322,"2","2020-06-15 18:32:30","2","2020-06-15 18:32:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:32: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":["8112","INVOICE","8469","PAID","2020-06-15 18:32:30",13572,"2","2020-06-15 18:32:30","2","2020-06-15 18:32:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:34: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":"type=INVOICE&filter1=0&filter2=1539&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1146,"customer_code":"C181146","identity_type":"PERSONAL","identity_id":"D103036(2)","title":"Ms","lastname":"Leung ","firstname":"Lai Yee","companyname":"","email":null,"tel":"93069953","address":"28\/C , Block 10 , Nam Fung Sun Cheun, Quarry Bay","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1798.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-11","renew_room_key":"0012403799","renew_remark":"1 month contract. Storage rental paid by cheque on May 28,2020. Deposit transferred from agreement C15-CT207675 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT207984, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"170","order_discount":[],"order_room":[{"room_id":"1354","room_code":"C15-048","retail_price":"1108.0","discounted_price":"1108.00","location_id":"6"},{"room_id":"1353","room_code":"C15-047","retail_price":"1108.0","discounted_price":"1108.00","location_id":"6"}],"roughly_size":"32","total_retail_price":2216,"total_discounted_price":1798,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1798,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-11","rent_from":"2020-06-11","rent_to":"2020-07-10","delivery_service":"0","remark":"1 month contract. Storage rental paid by cheque on June 16,2020. Deposit transferred from agreement C15-CT207984 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":1798,"final_order_total":1798,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012403799","order_product":[],"pass":true}},"first_order_id":"4293","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> C15-048 <\/td>\r\n\t\t\t\t\t 4X4X6.5 <\/td>\r\n\t\t\t\t\t $1108.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> C15-047 <\/td>\r\n\t\t\t\t\t 4X4X6.5 <\/td>\r\n\t\t\t\t\t $1108.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":"32","total_discounted_price":"1798.0","deposit":"0","total_retail_price":"2216.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:34:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1146,"NEW","C15-CT208141",2216,1798,0,0,"1","1",1798,1798,1798,"2020-06-15 18:34:13","0",null,null,null,"2020-06-11","2020-07-10","1 month contract. Storage rental paid by cheque on June 16,2020. Deposit transferred from agreement C15-CT207984 to this agreement.","2020-06-11","32",0,null,0,"0","2","2020-06-15 18:34:12","2","2020-06-15 18:34:12","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"0012403799","C181146","PERSONAL","Ms","gjSpyhqyAa7WiwccZ+QVeQ==","EU9enA5\/vY58OMUDrd7sSw==","","dX+zJ458tDKiugVFVeBzNhNApFHtw42VR0\/lPFKhmiYTCTEHyOZIjDuovvRjZrW6gZiRuj2LsbRWS9nBvW\/ZuQ==","iaEkitfo+RiWiRQ1VJ1bPg==",null,"S1RRDrlG6v7bZDT0Ztugpw==",null,1,"4293"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:34: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":["8141","1354","1108.0","1108.00","2","2020-06-15 18:34:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:34:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-11","2020-07-10","1354"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-15 18:34: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":["8141","1353","1108.0","1108.00","2","2020-06-15 18:34:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:34:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-11","2020-07-10","1353"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-15 18:34: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":["8141",1146,"SETTLED","C15-I208470","2020-06-15 18:34:12","2020-06-11","2","2020-06-15 18:34:12","2","2020-06-15 18:34:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:34: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":["8470","RENT","\u9810\u7e73\u79df\u91d1",1,1798,"MO","1",1798,"2","2020-06-15 18:34:12","2","2020-06-15 18:34:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:34:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1798,0,"8470"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-15 18:34: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":[1146,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P208113","2020-06-15 18:34:12",1798,"2","2020-06-15 18:34:12","2","2020-06-15 18:34:12","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:34: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":["8113","DEPOSIT",null,"PAID","2020-06-15 18:34:12",0,"2","2020-06-15 18:34:12","2","2020-06-15 18:34:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 18:34: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":["8113","INVOICE","8470","PAID","2020-06-15 18:34:12",1798,"2","2020-06-15 18:34:12","2","2020-06-15 18:34:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 19:23:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 19:31:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 20:04:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-15 20:33:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****