\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>
C07 <\/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":"16","total_discounted_price":"1098.00","deposit":"2196.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 11:54:36","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":["C201697","PERSONAL","Mr","Go1v1hjRcxVBkQ6zBU3YeA==","brgGVGuPrfoSjI4k+kLGow==","","WyOeBlaYT1LkqmahwzeTmQ==","wlI56lDh4cXZ7PFWMtG45z1ZWIV5VYZyBmXP\/niOUiI=","g5xjB5uBWPWRV63oJwpPKYM+OLU6zbdJ9dQ7nwM\/N\/EMeD1G\/ea+XeMvAsTDiROOBcfVM3++hByh2gPu0hWXag==","I767rTCG2uy2VIToj+EDZQ==",null,"wlI56lDh4cXZ7PFWMtG45z1ZWIV5VYZyBmXP\/niOUiI=","JdZf7hCWHm1K89kAb\/6Yaw==","2","2020-08-01 11:54:35","2","2020-08-01 11:54:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 11:54:37","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",1697,"NEW","A12-CT208536",1098,1098,2196,0,"3","3",3843,5490,3843,"2020-08-01 11:54:37","0",null,null,null,"2020-08-01","2020-10-31","3 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit paid by cash on Aug 1, 2020. Smart card and padlock provided on the same day.","2020-08-01","16",0,null,1647,"1647.00","2","2020-08-01 11:54:35","2","2020-08-01 11:54:35","CASH","","","","CASH","","","",null,0,"190, 39716","C201697","PERSONAL","Mr","Go1v1hjRcxVBkQ6zBU3YeA==","brgGVGuPrfoSjI4k+kLGow==","","g5xjB5uBWPWRV63oJwpPKYM+OLU6zbdJ9dQ7nwM\/N\/EMeD1G\/ea+XeMvAsTDiROOBcfVM3++hByh2gPu0hWXag==","WyOeBlaYT1LkqmahwzeTmQ==","wlI56lDh4cXZ7PFWMtG45z1ZWIV5VYZyBmXP\/niOUiI=","I767rTCG2uy2VIToj+EDZQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 11:54:37","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":["8536","131","1098.0","1098.00","2","2020-08-01 11:54:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 11:54:37","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-08-01","2020-10-31","131"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-01 11:54:37","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":["8536","A12-D205582","PAID",2196,0,"2020-10-31","2020-08-01 11:54:35","2020-08-01 11:54:35","2","2020-08-01 11:54:35","2","2020-08-01 11:54:35",1697]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 11:54:37","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":["8536",1697,"SETTLED","A12-I208865","2020-08-01 11:54:35","2020-08-01","2","2020-08-01 11:54:35","2","2020-08-01 11:54:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 11:54:37","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":["8865","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-08-01 11:54:35","2","2020-08-01 11:54:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 11:54:37","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":["8865","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,549,"MO","1",549,"2","2020-08-01 11:54:35","2","2020-08-01 11:54:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 11:54:37","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":["8865","RENT","\u9810\u7e73\u79df\u91d1",3,1098,"MO","1",1098,"2","2020-08-01 11:54:35","2","2020-08-01 11:54:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 11:54:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1647,0,"8865"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-01 11:54:37","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":[1697,"CASH","","","","CASH","","","","PAID","P208508","2020-08-01 11:54:35",3843,"2","2020-08-01 11:54:35","2","2020-08-01 11:54:35","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 11:54:37","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":["8508","DEPOSIT","5582","PAID","2020-08-01 11:54:35",2196,"2","2020-08-01 11:54:35","2","2020-08-01 11:54:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 11:54:37","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":["8508","INVOICE","8865","PAID","2020-08-01 11:54:35",1647,"2","2020-08-01 11:54:35","2","2020-08-01 11:54:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:09:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:10:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:21:57","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","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":560,"customer_code":"C170560","identity_type":"PERSONAL","identity_id":"C454277(9)","title":"Mr","lastname":"Li","firstname":"Kwok Choi","companyname":"","email":"benjaminkcli@gmail.com","tel":"91211868","address":"Tower 20-D,34\/F,South Horizons,Apleichau,HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1860.0","renew_rent_month":"1","renew_warehousing_date":"2020-08-01","renew_room_key":"054,16918","renew_remark":"1 month contract. Storage rental paid by bank transfer on July 1, 2020. Storage deposit transferred from agreement A12-CT208012 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT208266, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"335","room_code":"F20","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"},{"room_id":"324","room_code":"F09","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"28","total_retail_price":2096,"total_discounted_price":1860,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1860,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-08-01","rent_from":"2020-08-01","rent_to":"2020-08-31","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Jul 31, 2020. Storage deposit transferred from agreement A12-CT208266 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1860,"final_order_total":1860,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,16918","order_product":[],"pass":true}},"first_order_id":"4811","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> F20 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> F09 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"28","total_discounted_price":"1860.0","deposit":"0","total_retail_price":"2096.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:21:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",560,"NEW","A12-CT208537",2096,1860,0,0,"1","1",1860,1860,1860,"2020-08-01 12:21:57","0",null,null,null,"2020-08-01","2020-08-31","1 month contract. Storage rental paid by bank transfer on Jul 31, 2020. Storage deposit transferred from agreement A12-CT208266 to this agreement.","2020-08-01","28",0,null,0,"0","2","2020-08-01 12:21:57","2","2020-08-01 12:21:57","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,16918","C170560","PERSONAL","Mr","K1x\/9w0o0rKJd7wz8qK7pg==","7KCehmxbvwRMb+U8lHGoVA==","","FtBAyqdJB9YVbXi504FRZc\/Jt3mzCqv\/xe\/RY0+A7wVOOPyXv8dxE4H5XZLFEXzC","4QMR+NS4lG0kYGIev9anRw==","ZR5GFjUu0SZOy4e7QYAXd00ul0qCow7bN10OYhy9E+I=","Yd8HrzCK1iQ9KWTKpSyu0w==",null,1,"4811"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:21:58","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":["8537","335","1098.0","1098.00","2","2020-08-01 12:21:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:21:58","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-08-01","2020-08-31","335"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-01 12:21:58","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":["8537","324","998.0","998.00","2","2020-08-01 12:21:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:21:58","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-08-01","2020-08-31","324"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-01 12:21:58","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":["8537",560,"SETTLED","A12-I208866","2020-08-01 12:21:57","2020-08-01","2","2020-08-01 12:21:57","2","2020-08-01 12:21:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:21:58","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":["8866","RENT","\u9810\u7e73\u79df\u91d1",1,1860,"MO","1",1860,"2","2020-08-01 12:21:57","2","2020-08-01 12:21:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:21:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1860,0,"8866"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-01 12:21:58","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":[560,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208509","2020-08-01 12:21:57",1860,"2","2020-08-01 12:21:57","2","2020-08-01 12:21:57","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:21:58","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":["8509","DEPOSIT",null,"PAID","2020-08-01 12:21:57",0,"2","2020-08-01 12:21:57","2","2020-08-01 12:21:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:21:58","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":["8509","INVOICE","8866","PAID","2020-08-01 12:21:57",1860,"2","2020-08-01 12:21:57","2","2020-08-01 12:21:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:28:16","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","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1435,"customer_code":"C191435","identity_type":"PERSONAL","identity_id":"Z600823(3)","title":"Ms","lastname":"SO","firstname":"Ching Man","companyname":"","email":"manman_615@gmail.com","tel":"66857798","address":"\u9d28\u8137\u6d32\u5229\u6771\u90a8\u6771\u5e73\u6a133209\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"2","renew_warehousing_date":"2020-08-05","renew_room_key":"190,25713","renew_remark":"2 months contract. Storage rental paid by bank transfer on Jul 23, 2020. Storage deposit $1996 transferred from agreement A14-CT207986 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT208456, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"562","room_code":"L40","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":998,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-08-05","rent_from":"2020-08-05","rent_to":"2020-09-04","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Jul 31, 2020. Storage deposit $1996 transferred from agreement A14-CT208456 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":998,"final_order_total":998,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190,25713","order_product":[],"pass":true}},"first_order_id":"6294","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> L40 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"998.00","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:28:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",1435,"NEW","A14-CT208538",998,998,0,0,"1","1",998,998,998,"2020-08-01 12:28:17","0",null,null,null,"2020-08-05","2020-09-04","1 month contract. Storage rental paid by bank transfer on Jul 31, 2020. Storage deposit $1996 transferred from agreement A14-CT208456 to this agreement.","2020-08-05","12",0,null,0,"0","2","2020-08-01 12:28:16","2","2020-08-01 12:28:16","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190,25713","C191435","PERSONAL","Ms","knZMm9GAZID7Lv+9MLc5ZA==","mOWsGT2TzOPDdjq14yV0zw==","","JP4Rs\/ygk7B5+4qY1O\/77mUgOqLhOV7RAed2ioH8C+7gkcorV\/Bk82G90L53vhh8","95CDSt30lRyCZEH4n270nw==","bE\/Jfb0PyFebKTBoaLQMLuSWgoH2ygJQ\/KlmIxPGGno=","v8f4b0Nv2Vl1ElMKQ09dDQ==",null,1,"6294"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:28:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8538","562","998.0","998.00","2","2020-08-01 12:28:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:28:17","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-05","2020-09-04","562"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-01 12:28:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8538",1435,"SETTLED","A14-I208867","2020-08-01 12:28:16","2020-08-05","2","2020-08-01 12:28:16","2","2020-08-01 12:28:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:28:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8867","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-08-01 12:28:16","2","2020-08-01 12:28:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:28:17","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"8867"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-01 12:28:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1435,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208510","2020-08-01 12:28:16",998,"2","2020-08-01 12:28:16","2","2020-08-01 12:28:16","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:28:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8510","DEPOSIT",null,"PAID","2020-08-01 12:28:16",0,"2","2020-08-01 12:28:16","2","2020-08-01 12:28:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:28:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8510","INVOICE","8867","PAID","2020-08-01 12:28:16",998,"2","2020-08-01 12:28:16","2","2020-08-01 12:28:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:29:59","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","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":649,"customer_code":"C170649","identity_type":"PERSONAL","identity_id":"D658788(8)","title":"Mr","lastname":"Wong","firstname":"Shing Kwan Gordon ","companyname":"","email":"gq1310@yahoo.com.hk","tel":"53030469","address":"\u9999\u6e2f\u4ed4\u9038\u6e2f\u5c451\u5ea74\u6a13D\u5ea7","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1525.0","renew_rent_month":"3","renew_warehousing_date":"2020-06-28","renew_room_key":"133,32874","renew_remark":"3 months contract. Storage rental paid by bank transfer on May 6, 2020. Storage deposit transferred from agreement A18-CT207192 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207794, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"78","order_discount":[],"order_room":[{"room_id":"940","room_code":"V14","retail_price":"1605.0","discounted_price":"1605.00","location_id":"3"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1605,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":3210,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-28","rent_from":"2020-06-28","rent_to":"2020-08-27","delivery_service":"0","remark":"2 months contract. Storage rental paid by bank transfer on Jul 31, 2020. Storage deposit transferred from agreement A18-CT207794 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3210,"final_order_total":3210,"location_id":"3","branch_id":"1","company_id":"1","room_key":"133,32874","order_product":[],"pass":true}},"first_order_id":"4409","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> V14 <\/td>\r\n\t\t\t\t\t 4X5X7 <\/td>\r\n\t\t\t\t\t $1605.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":"1605.00","deposit":"0.00","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:30:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",649,"NEW","A18-CT208539",1605,1605,0,0,"2","2",3210,3210,3210,"2020-08-01 12:30:00","0",null,null,null,"2020-06-28","2020-08-27","2 months contract. Storage rental paid by bank transfer on Jul 31, 2020. Storage deposit transferred from agreement A18-CT207794 to this agreement.","2020-06-28","20",0,null,0,"0","2","2020-08-01 12:29:59","2","2020-08-01 12:29:59","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"133,32874","C170649","PERSONAL","Mr","v4dwfZbWgztWwOO0+DKLqvngLlMYAWBIg5hFuO5UkcI=","hULSwM2MvFtpeV9\/z+er8Q==","","MzIxaThTlSRnM0LX9AJI\/z2u9jCD1+Cmf\/ICago4BP8=","DUwkHg2aCYBYFtwLlrWQSw==","0sqIy\/hJ4IVsR5jpqD48Fg3uig8eD35E9eH8wPbBohA=","wDbeWC0+yorX7t2b+1ST5g==",null,1,"4409"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:30:00","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":["8539","940","1605.0","1605.00","2","2020-08-01 12:29:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:30:00","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-28","2020-08-27","940"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-01 12:30:00","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":["8539",649,"SETTLED","A18-I208868","2020-08-01 12:29:59","2020-06-28","2","2020-08-01 12:29:59","2","2020-08-01 12:29:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:30:00","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":["8868","RENT","\u9810\u7e73\u79df\u91d1",1,1605,"MO","1",1605,"2","2020-08-01 12:29:59","2","2020-08-01 12:29:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:30:00","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":["8868","RENT","\u9810\u7e73\u79df\u91d1",2,1605,"MO","1",1605,"2","2020-08-01 12:29:59","2","2020-08-01 12:29:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:30:00","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3210,0,"8868"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-01 12:30:00","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":[649,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208511","2020-08-01 12:29:59",3210,"2","2020-08-01 12:29:59","2","2020-08-01 12:29:59","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:30:00","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":["8511","DEPOSIT",null,"PAID","2020-08-01 12:29:59",0,"2","2020-08-01 12:29:59","2","2020-08-01 12:29:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:30:00","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":["8511","INVOICE","8868","PAID","2020-08-01 12:29:59",3210,"2","2020-08-01 12:29:59","2","2020-08-01 12:29:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 12:45:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 13:07:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 13:32:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 13:36:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 13:46:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 13:55:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 13:56:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 14:01:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 14:03:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 14:05:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 14:15:25","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[],"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> Q18 <\/td>\r\n\t\t\t\t\t 5X3X7 <\/td>\r\n\t\t\t\t\t $1195.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"G341809(9)","title":"Ms","lastname":"TSUI","firstname":"Wan Ching","companyname":"","email":"chingleungwong@yahoo.com.hk","tel":"63893203","address":"Block B, 2\/F, Sun On Building, 490 Queens Road West, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"821","room_code":"Q18","retail_price":"1195.0","discounted_price":"1195.00","location_id":"3"}],"roughly_size":"15","total_retail_price":1195,"total_discounted_price":1097,"deposit":2436,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":14952,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1745.00","warehousing_date":"2020-08-10","rent_from":"2020-08-10","rent_to":"2021-09-09","delivery_service":"0","remark":"13 months contract. Special \u201crent now\u201d 5% off offer and the 13th month free. Storage rental and deposit paid by cheque on Aug 1, 2020. Smart card provided on the same day.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":1745,"order_total":16697,"final_order_total":14952,"location_id":"3","branch_id":"1","company_id":"1","room_key":"076,46510","order_product":[],"pass":true}},"roughly_size":"15","total_discounted_price":"1097.00","deposit":"2436.00","total_retail_price":"1195.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 14:15:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201698","PERSONAL","Ms","fjL3h59UAXO5BUDqmD2JbQ==","4zek2V6v+muRHEsNI7xEHw==","","osiqjLHfs5vwa52+adSjgQ==","EkcK3O4jH2cneYkXuJsaZFaswG7F3U3VjMluYqW8Hfw=","cbfFqsY1j1KiQza1aues3SFAdh0iDcUznGcrmQqKkrOJIp\/Z86vXUBZNk4Yxoy51C25vaqOAaqRRWNDWyb3qfQ==","vNM1A0Oa5xaSJkx4mcxVwA==",null,"EkcK3O4jH2cneYkXuJsaZFaswG7F3U3VjMluYqW8Hfw=","eOhhFBesRL7OaqBTpdxfvA==","2","2020-08-01 14:15:25","2","2020-08-01 14:15:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 14:15:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","3",1698,"NEW","A18-CT208540",1195,1097,2436,0,"13","13",14952,16697,14952,"2020-08-01 14:15:26","0",null,null,null,"2020-08-10","2021-09-09","13 months contract. Special \u201crent now\u201d 5% off offer and the 13th month free. Storage rental and deposit paid by cheque on Aug 1, 2020. Smart card provided on the same day.","2020-08-10","15",0,null,1745,"1745.00","2","2020-08-01 14:15:25","2","2020-08-01 14:15:25","CHEQUE","","","","CHEQUE","","","",null,0,"076,46510","C201698","PERSONAL","Ms","fjL3h59UAXO5BUDqmD2JbQ==","4zek2V6v+muRHEsNI7xEHw==","","cbfFqsY1j1KiQza1aues3SFAdh0iDcUznGcrmQqKkrOJIp\/Z86vXUBZNk4Yxoy51C25vaqOAaqRRWNDWyb3qfQ==","osiqjLHfs5vwa52+adSjgQ==","EkcK3O4jH2cneYkXuJsaZFaswG7F3U3VjMluYqW8Hfw=","vNM1A0Oa5xaSJkx4mcxVwA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 14:15:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8540","821","1195.0","1195.00","2","2020-08-01 14:15:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 14:15:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-10","2021-09-09","821"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-01 14:15:26","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":["8540","A18-D205583","PAID",2436,0,"2021-09-09","2020-08-01 14:15:25","2020-08-01 14:15:25","2","2020-08-01 14:15:25","2","2020-08-01 14:15:25",1698]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 14:15:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8540",1698,"SETTLED","A18-I208869","2020-08-01 14:15:25","2020-08-10","2","2020-08-01 14:15:25","2","2020-08-01 14:15:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 14:15:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8869","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-08-01 14:15:25","2","2020-08-01 14:15:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 14:15:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8869","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,449,"MO","1",449,"2","2020-08-01 14:15:25","2","2020-08-01 14:15:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 14:15:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8869","RENT","\u9810\u7e73\u79df\u91d1",3,1097,"MO","1",1097,"2","2020-08-01 14:15:25","2","2020-08-01 14:15:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 14:15:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8869","RENT","\u9810\u7e73\u79df\u91d1",4,1097,"MO","1",1097,"2","2020-08-01 14:15:25","2","2020-08-01 14:15:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 14:15:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8869","RENT","\u9810\u7e73\u79df\u91d1",5,1097,"MO","1",1097,"2","2020-08-01 14:15:25","2","2020-08-01 14:15:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 14:15:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8869","RENT","\u9810\u7e73\u79df\u91d1",6,1097,"MO","1",1097,"2","2020-08-01 14:15:25","2","2020-08-01 14:15:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 14:15:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8869","RENT","\u9810\u7e73\u79df\u91d1",7,1097,"MO","1",1097,"2","2020-08-01 14:15:25","2","2020-08-01 14:15:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 14:15:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8869","RENT","\u9810\u7e73\u79df\u91d1",8,1097,"MO","1",1097,"2","2020-08-01 14:15:25","2","2020-08-01 14:15:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 14:15:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8869","RENT","\u9810\u7e73\u79df\u91d1",9,1097,"MO","1",1097,"2","2020-08-01 14:15:25","2","2020-08-01 14:15:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 14:15:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8869","RENT","\u9810\u7e73\u79df\u91d1",10,1097,"MO","1",1097,"2","2020-08-01 14:15:25","2","2020-08-01 14:15:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 14:15:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8869","RENT","\u9810\u7e73\u79df\u91d1",11,1097,"MO","1",1097,"2","2020-08-01 14:15:25","2","2020-08-01 14:15:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 14:15:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8869","RENT","\u9810\u7e73\u79df\u91d1",12,1097,"MO","1",1097,"2","2020-08-01 14:15:25","2","2020-08-01 14:15:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 14:15:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8869","RENT","\u9810\u7e73\u79df\u91d1",13,1097,"MO","1",1097,"2","2020-08-01 14:15:25","2","2020-08-01 14:15:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 14:15:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[12516,0,"8869"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-01 14:15:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1698,"CHEQUE","","","","CHEQUE","","","","PAID","P208512","2020-08-01 14:15:25",14952,"2","2020-08-01 14:15:25","2","2020-08-01 14:15:25","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 14:15:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8512","DEPOSIT","5583","PAID","2020-08-01 14:15:25",2436,"2","2020-08-01 14:15:25","2","2020-08-01 14:15:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 14:15:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8512","INVOICE","8869","PAID","2020-08-01 14:15:25",12516,"2","2020-08-01 14:15:25","2","2020-08-01 14:15:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-01 15:57:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****