\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>
A01 <\/td>\n\t\t\t\t\t	4X7X8 <\/td>\n\t\t\t\t\t	$2058.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":"28","total_discounted_price":"1860.00","deposit":"3720.00","total_retail_price":"2058.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 12:07: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":["C201577","PERSONAL","Mr","6kEvdBg9zGg5TDeiYf4BKw==","8BEgNhGpCR8jGkzUtrIcXg==","","64CJiWOU8+ezsBxy6ixsqQ==",null,"CNXbyhTnNIapzro6icAF3DXHSd76KHIfZBj+ZcWHITTZYCD\/x952b5WgRniN5Oz3ALT3Z5X0cyNjSgnOIif3y\/pfiwMZ6En10VpSXKkUwi8=","G\/0ILeRr1sphHGWL2xqH6A==",null,null,"YqTY8eSUat9j4\/oqa+UztA==","2","2020-05-04 12:07:29","2","2020-05-04 12:07:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 12:07:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1",1577,"NEW","A12-CT207763",2058,1860,3720,0,"1","1",4650,5580,4650,"2020-05-04 12:07:31","0",null,null,null,"2020-05-06","2020-06-05","1 month contract. Special offer 50% off. Storage rental and deposit paid by cash on May 4, 2020. ","2020-05-06","28",0,null,930,"930.00","2","2020-05-04 12:07:29","2","2020-05-04 12:07:29","CASH","","","","CASH","","","",null,0,"190, 37118","C201577","PERSONAL","Mr","6kEvdBg9zGg5TDeiYf4BKw==","8BEgNhGpCR8jGkzUtrIcXg==","","CNXbyhTnNIapzro6icAF3DXHSd76KHIfZBj+ZcWHITTZYCD\/x952b5WgRniN5Oz3ALT3Z5X0cyNjSgnOIif3y\/pfiwMZ6En10VpSXKkUwi8=","64CJiWOU8+ezsBxy6ixsqQ==",null,"G\/0ILeRr1sphHGWL2xqH6A==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 12:07:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7763","1","2058.0","2058.00","2","2020-05-04 12:07:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 12:07:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-06","2020-06-05","1"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-04 12:07:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["7763","A12-D205397","PAID",3720,0,"2020-06-05","2020-05-04 12:07:29","2020-05-04 12:07:29","2","2020-05-04 12:07:29","2","2020-05-04 12:07:29",1577]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 12:07: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":["7763",1577,"SETTLED","A12-I208092","2020-05-04 12:07:29","2020-05-06","2","2020-05-04 12:07:29","2","2020-05-04 12:07:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 12:07: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":["8092","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,930,"MO","1",930,"2","2020-05-04 12:07:29","2","2020-05-04 12:07:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 12:07:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[930,0,"8092"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-04 12:07: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":[1577,"CASH","","","","CASH","","","","PAID","P207737","2020-05-04 12:07:29",4650,"2","2020-05-04 12:07:29","2","2020-05-04 12:07:29","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 12:07: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":["7737","DEPOSIT","5397","PAID","2020-05-04 12:07:29",3720,"2","2020-05-04 12:07:29","2","2020-05-04 12:07:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 12:07: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":["7737","INVOICE","8092","PAID","2020-05-04 12:07:29",930,"2","2020-05-04 12:07:29","2","2020-05-04 12:07:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 12:37:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 12:59:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 14:23:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 14:24: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=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":679,"customer_code":"C180679","identity_type":"BUSINESS","identity_id":"30490025","title":"Ms","lastname":"Chan","firstname":"Doris","companyname":"Hemandas Industrial Ltd.","email":"dorischan@esc.com.hk","tel":"92896007","address":"Unit 2243, 22\/F, Yan's Tower, 25-27 Wong Chuk Hang Rd, Wong Chuk Hang, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2728.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-03","renew_room_key":"055,56887","renew_remark":"1 month contract. Storage rental paid by bank transfer on April 8, 2020. Storage deposit transferred from agreement A18-CT207330 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207584, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"82","order_discount":[],"order_room":[{"room_id":"859","room_code":"T03","retail_price":"2728.0","discounted_price":"2728.00","location_id":"3"}],"roughly_size":"36","total_retail_price":2728,"total_discounted_price":2728,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2728,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-03","rent_from":"2020-05-03","rent_to":"2020-06-02","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on May 4, 2020. Storage deposit transferred from agreement A18-CT207584 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2728,"final_order_total":2728,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,56887","order_product":[],"pass":true}},"first_order_id":"4697","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> T03 <\/td>\r\n\t\t\t\t\t 6X6X7 <\/td>\r\n\t\t\t\t\t $2728.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":"36","total_discounted_price":"2728.0","deposit":"0","total_retail_price":"2728.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 14:24:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",679,"NEW","A18-CT207764",2728,2728,0,0,"1","1",2728,2728,2728,"2020-05-04 14:24:16","0",null,null,null,"2020-05-03","2020-06-02","1 month contract. Storage rental paid by bank transfer on May 4, 2020. Storage deposit transferred from agreement A18-CT207584 to this agreement.\r\n","2020-05-03","36",0,null,0,"0","2","2020-05-04 14:24:16","2","2020-05-04 14:24:16","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,56887","C180679","BUSINESS","Ms","1p0+HSxbHlPSeHnKL1+MnA==","U9yoE9KqV1v8YlRkf7Q2yg==","Hemandas Industrial Ltd.","NNq9wxs1efEwHG+GfiDv3WoHFlyl2ik9vc5ha7eicfoFr48wfjXwEVDp3r5jjcxqeRyrZaz+NALvMBTiKSrb1OMQJpkhkNMPCpwd2zTkR61b7UwwjxTbA4OPPOLfvpDG","gMEFsGZs7+56GFUaxLbplg==","Um3+ktI0eYcw3estHH8TQKxSuSRl+2j3b4bDI46i5yg=",null,"UeK5wwtn5\/PTJNB6lM3obw==",1,"4697"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 14:24:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7764","859","2728.0","2728.00","2","2020-05-04 14:24:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 14:24:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-03","2020-06-02","859"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-04 14:24:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7764",679,"SETTLED","A18-I208093","2020-05-04 14:24:16","2020-05-03","2","2020-05-04 14:24:16","2","2020-05-04 14:24:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 14:24:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8093","RENT","\u9810\u7e73\u79df\u91d1",1,2728,"MO","1",2728,"2","2020-05-04 14:24:16","2","2020-05-04 14:24:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 14:24:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2728,0,"8093"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-04 14:24:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[679,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207738","2020-05-04 14:24:16",2728,"2","2020-05-04 14:24:16","2","2020-05-04 14:24:16","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 14:24:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7738","DEPOSIT",null,"PAID","2020-05-04 14:24:16",0,"2","2020-05-04 14:24:16","2","2020-05-04 14:24:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 14:24:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7738","INVOICE","8093","PAID","2020-05-04 14:24:16",2728,"2","2020-05-04 14:24:16","2","2020-05-04 14:24:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:03:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:24:01","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:26:50","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=1520&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1520,"customer_code":"C201520","identity_type":"PERSONAL","identity_id":"K098864(2)","title":"Ms","lastname":"LAM","firstname":"Wan Ying","companyname":"","email":"vanessalamwy@hotmail.com","tel":"94236323","address":"Rm 5, 15\/F, Kong Cheung Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"798.0","renew_rent_month":"2","renew_warehousing_date":"2020-05-06","renew_room_key":"190, 39700","renew_remark":"2 months contract. Special offer 1 month free. Storage rental and deposit paid by cash on February 24, 2020. \\n\u820a\u5408\u7d04\u7de8\u865f: WC-CT207251, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1596.0","renew_master_room_id":"232","order_discount":[],"order_room":[{"room_id":"1753","room_code":"WC-16","retail_price":"798.0","discounted_price":"798.00","location_id":"8"}],"roughly_size":"6.25","total_retail_price":798,"total_discounted_price":798,"deposit":0,"rent_month":"14","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"14","prepaid_amount":9576,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1596.00","warehousing_date":"2020-05-06","rent_from":"2020-05-06","rent_to":"2021-07-05","delivery_service":"0","remark":"14 months contract. Special offer the 13th and 14th months free. Storage rental paid by EPS on May 4, 2020. Deposit $1596 transferred from agreement WC-CT207251 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":1596,"order_total":11172,"final_order_total":9576,"location_id":"8","branch_id":"1","company_id":"1","room_key":"190, 39700","order_product":[],"pass":true}},"first_order_id":7251,"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> WC-16 <\/td>\r\n\t\t\t\t\t 2.5X2.5X4 <\/td>\r\n\t\t\t\t\t $798.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"6.25","total_discounted_price":"798.00","deposit":"0.00","total_retail_price":"798.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:26:50","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","8",1520,"NEW","WC-CT207765",798,798,0,0,"14","14",9576,11172,9576,"2020-05-04 15:26:50","0",null,null,null,"2020-05-06","2021-07-05","14 months contract. Special offer the 13th and 14th months free. Storage rental paid by EPS on May 4, 2020. Deposit $1596 transferred from agreement WC-CT207251 to this agreement.","2020-05-06","6.25",0,null,1596,"1596.00","2","2020-05-04 15:26:50","2","2020-05-04 15:26:50","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"190, 39700","C201520","PERSONAL","Ms","l1F7kS6mgUFlXQCyBMQk3w==","BLxWt7e4owYJMFkn6\/eeMQ==","","R\/BnfOLjXQK0v5HtcaR8vb7DxGjTd6WLSAua8tylVS3\/xJMtttvrMEarmsUVOdcnMCUXsvorRkalbdBalwKvkjuzPg8Sg739PG4vDpkzXaA=","GP8xgOuzAmNhNqATiOalfg==","w6nqbYp32KQPR9iltH1kvGq1dJJ1F8pYDVS81YkNHVM=","myzDdWGXpkmpmlEpS5LrDg==",null,1,7251]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:26:50","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":["7765","1753","798.0","798.00","2","2020-05-04 15:26:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:26:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-06","2021-07-05","1753"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-04 15:26:50","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":["7765",1520,"SETTLED","WC-I208094","2020-05-04 15:26:50","2020-05-06","2","2020-05-04 15:26:50","2","2020-05-04 15:26:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:26:50","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":["8094","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-04 15:26:50","2","2020-05-04 15:26:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:26:50","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":["8094","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,798,"MO","1",798,"2","2020-05-04 15:26:50","2","2020-05-04 15:26:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:26:50","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":["8094","RENT","\u9810\u7e73\u79df\u91d1",4,798,"MO","1",798,"2","2020-05-04 15:26:50","2","2020-05-04 15:26:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:26:50","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":["8094","RENT","\u9810\u7e73\u79df\u91d1",5,798,"MO","1",798,"2","2020-05-04 15:26:50","2","2020-05-04 15:26:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:26:50","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":["8094","RENT","\u9810\u7e73\u79df\u91d1",6,798,"MO","1",798,"2","2020-05-04 15:26:50","2","2020-05-04 15:26:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:26:50","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":["8094","RENT","\u9810\u7e73\u79df\u91d1",7,798,"MO","1",798,"2","2020-05-04 15:26:50","2","2020-05-04 15:26:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:26:50","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":["8094","RENT","\u9810\u7e73\u79df\u91d1",8,798,"MO","1",798,"2","2020-05-04 15:26:50","2","2020-05-04 15:26:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:26:50","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":["8094","RENT","\u9810\u7e73\u79df\u91d1",9,798,"MO","1",798,"2","2020-05-04 15:26:50","2","2020-05-04 15:26:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:26:50","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":["8094","RENT","\u9810\u7e73\u79df\u91d1",10,798,"MO","1",798,"2","2020-05-04 15:26:50","2","2020-05-04 15:26:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:26:50","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":["8094","RENT","\u9810\u7e73\u79df\u91d1",11,798,"MO","1",798,"2","2020-05-04 15:26:50","2","2020-05-04 15:26:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:26:50","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":["8094","RENT","\u9810\u7e73\u79df\u91d1",12,798,"MO","1",798,"2","2020-05-04 15:26:50","2","2020-05-04 15:26:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:26:50","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":["8094","RENT","\u9810\u7e73\u79df\u91d1",13,798,"MO","1",798,"2","2020-05-04 15:26:50","2","2020-05-04 15:26:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:26:50","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":["8094","RENT","\u9810\u7e73\u79df\u91d1",14,798,"MO","1",798,"2","2020-05-04 15:26:50","2","2020-05-04 15:26:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:26:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[9576,0,"8094"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-04 15:26:50","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":[1520,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207739","2020-05-04 15:26:50",9576,"2","2020-05-04 15:26:50","2","2020-05-04 15:26:50","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:26:50","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":["7739","DEPOSIT",null,"PAID","2020-05-04 15:26:50",0,"2","2020-05-04 15:26:50","2","2020-05-04 15:26:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:26:50","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":["7739","INVOICE","8094","PAID","2020-05-04 15:26:50",9576,"2","2020-05-04 15:26:50","2","2020-05-04 15:26:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:58:20","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1261&filter3=undefined","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1261,"customer_code":"C191261","identity_type":"PERSONAL","identity_id":"G285177(5)","title":"Mr","lastname":"Lee","firstname":"Pak Ho","companyname":"","email":null,"tel":"62037746","address":"Room 2510, Lei Fook House, Lower Block, Apleichau Estate, Ap Lei Chau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1098.0","renew_rent_month":"3","renew_warehousing_date":"2020-03-04","renew_room_key":"076,58156","renew_remark":"3 months contract. Storage rental $2000 paid by cash on February 10, 2020. Remaining balance $1294 on February 16, 2020. Storage deposit $2196 transferred from agreement A14-CT196621 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207215, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[{"master_room_discount_id":"434","master_room_id":"35","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"742","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"742","room_code":"O18","retail_price":"1098.0","discounted_price":1043.4,"location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1098,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3294,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-04","rent_from":"2020-03-04","rent_to":"2020-06-03","delivery_service":"0","remark":"3 months contract. Storage rental paid by cash on May 4, 2020. Storage deposit $2196 transferred from agreement A14-CT207215 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":3294,"final_order_total":3294,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,58156","order_product":[],"pass":true}},"first_order_id":"4872","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> O18 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1098.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:58:20","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",1261,"NEW","A14-CT207766",1098,1098,0,0,"3","3",3294,3294,3294,"2020-05-04 15:58:20","0",null,null,null,"2020-03-04","2020-06-03","3 months contract. Storage rental paid by cash on May 4, 2020. Storage deposit $2196 transferred from agreement A14-CT207215 to this agreement.\r\n","2020-03-04","16",0,null,0,"0","2","2020-05-04 15:58:20","2","2020-05-04 15:58:20","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"076,58156","C191261","PERSONAL","Mr","l497mGOiMNQGidT3z5xzAA==","kiriEIqhcx866RNZiMXdKQ==","","qHi3rsy91wJafe8aQmSjkmxOhUk0X6aK9VcTSc7yi\/AmaNRZB7kJOc\/zHJ5gm+eKW\/g5fEQeq8RrqyNpSUg9Gp\/65DlaMHcBxxfKpNEtdiupU2zfVkpLoVZKNjzC+yhw","JmEgNMwRplOvZMflhfIdgw==",null,"itGnrdkuMhaVMvNK+jHZew==",null,1,"4872"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:58:20","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":["7766","434","35","742","%","4.97",54.5706,"2","2020-05-04 15:58:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:58:20","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":["7766","742","1098.0",1043.4,"2","2020-05-04 15:58:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:58:20","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-03-04","2020-06-03","742"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-04 15:58:20","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":["7766",1261,"SETTLED","A14-I208095","2020-05-04 15:58:20","2020-03-04","2","2020-05-04 15:58:20","2","2020-05-04 15:58:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:58:20","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":["8095","RENT","\u9810\u7e73\u79df\u91d1",1,1098,"MO","1",1098,"2","2020-05-04 15:58:20","2","2020-05-04 15:58:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:58:20","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":["8095","RENT","\u9810\u7e73\u79df\u91d1",2,1098,"MO","1",1098,"2","2020-05-04 15:58:20","2","2020-05-04 15:58:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:58:20","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":["8095","RENT","\u9810\u7e73\u79df\u91d1",3,1098,"MO","1",1098,"2","2020-05-04 15:58:20","2","2020-05-04 15:58:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:58:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3294,0,"8095"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-04 15:58:20","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":[1261,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207740","2020-05-04 15:58:20",3294,"2","2020-05-04 15:58:20","2","2020-05-04 15:58:20","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:58:20","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":["7740","DEPOSIT",null,"PAID","2020-05-04 15:58:20",0,"2","2020-05-04 15:58:20","2","2020-05-04 15:58:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 15:58:20","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":["7740","INVOICE","8095","PAID","2020-05-04 15:58:20",3294,"2","2020-05-04 15:58:20","2","2020-05-04 15:58:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 16:00:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 16:27: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":"filter1=2&filter2=1261&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":685,"customer_code":"C180685","identity_type":"PERSONAL","identity_id":"Z136565(8)","title":"Mr","lastname":"Tam","firstname":"Wai Hung","companyname":"","email":null,"tel":"61102922","address":"Room 210, Wah Lai House, Wah Kwai Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2298.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-01","renew_room_key":"053,56239","renew_remark":"1 month contract. Storage rental paid by cash on April 2, 2020. Storage deposit transferred from agreement A18-CT207294 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207556, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"81","order_discount":[],"order_room":[{"room_id":"857","room_code":"T01","retail_price":"2298.0","discounted_price":"2298.00","location_id":"3"}],"roughly_size":"30","total_retail_price":2298,"total_discounted_price":2298,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2298,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-01","rent_from":"2020-05-01","rent_to":"2020-05-31","delivery_service":"0","remark":"1 month contract. Storage rental $2300 paid by bank transfer on May 4, 2020. Storage deposit transferred from agreement A18-CT207556 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2298,"final_order_total":2298,"location_id":"3","branch_id":"1","company_id":"1","room_key":"053,56239","order_product":[],"pass":true}},"first_order_id":"4879","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> T01 <\/td>\r\n\t\t\t\t\t 5X6X7 <\/td>\r\n\t\t\t\t\t $2298.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":"30","total_discounted_price":"2298.0","deposit":"0","total_retail_price":"2298.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 16:27:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",685,"NEW","A18-CT207767",2298,2298,0,0,"1","1",2298,2298,2298,"2020-05-04 16:27:13","0",null,null,null,"2020-05-01","2020-05-31","1 month contract. Storage rental $2300 paid by bank transfer on May 4, 2020. Storage deposit transferred from agreement A18-CT207556 to this agreement.\r\n","2020-05-01","30",0,null,0,"0","2","2020-05-04 16:27:12","2","2020-05-04 16:27:12","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"053,56239","C180685","PERSONAL","Mr","Vy30hO8KRRcWAyFHMj+GkQ==","RAqogkelEKt1q5b\/6Neu\/g==","","T1rrupXx2a84nbfDVVe7dRZNixC4wynq7dBDu6A1cSJX7dG0wQgUJ6ZUu1fBgxwDKFNAcVyti6Of6RFkiuBYCg==","\/abipioEOeirm5gkDUnYEA==",null,"HSRQWr1h55jzD6yUUsYl4g==",null,1,"4879"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 16:27: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":["7767","857","2298.0","2298.00","2","2020-05-04 16:27:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 16:27:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-01","2020-05-31","857"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-04 16:27: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":["7767",685,"SETTLED","A18-I208096","2020-05-04 16:27:12","2020-05-01","2","2020-05-04 16:27:12","2","2020-05-04 16:27:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 16:27: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":["8096","RENT","\u9810\u7e73\u79df\u91d1",1,2298,"MO","1",2298,"2","2020-05-04 16:27:12","2","2020-05-04 16:27:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 16:27:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2298,0,"8096"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-04 16:27: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":[685,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207741","2020-05-04 16:27:12",2298,"2","2020-05-04 16:27:12","2","2020-05-04 16:27:12","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 16:27: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":["7741","DEPOSIT",null,"PAID","2020-05-04 16:27:12",0,"2","2020-05-04 16:27:12","2","2020-05-04 16:27:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 16:27: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":["7741","INVOICE","8096","PAID","2020-05-04 16:27:12",2298,"2","2020-05-04 16:27:12","2","2020-05-04 16:27:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:27","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":"","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1130,"customer_code":"C181130","identity_type":"PERSONAL","identity_id":"Z070788(1)","title":"Ms","lastname":"Lau","firstname":"Li Sze Cecilia","companyname":"","email":null,"tel":"96688344","address":"Room 3202, 32\/F, Pik Ngan House, Shek Pai Wan Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"OTHER","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"730.0","renew_rent_month":"3","renew_warehousing_date":"2020-04-02","renew_room_key":"0012474143","renew_remark":"3 months contract.Storage rental paid by PayMe on February 4, 2020. Storage deposit $1536 transferred from agreement A05-CT196310 to this agreement. $33 handling charge for PayMe. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207108, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"227","order_discount":[],"order_room":[{"room_id":"1715","room_code":"A05-189","retail_price":"768.0","discounted_price":"768.00","location_id":"4"}],"roughly_size":"10","total_retail_price":768,"total_discounted_price":692,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":4152,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-02","rent_from":"2020-04-02","rent_to":"2020-10-01","delivery_service":"0","remark":"6 months contract. Storage rental paid by cash on May 04, 2020. Storage deposit $1536 transferred from agreement A05-CT207108 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":4152,"final_order_total":4152,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012474143","order_product":[],"pass":true}},"first_order_id":"5553","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-189 <\/td>\r\n\t\t\t\t\t 5X2X7 <\/td>\r\n\t\t\t\t\t $768.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"10","total_discounted_price":"692.00","deposit":"0.00","total_retail_price":"768.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:28","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",1130,"NEW","A05-CT207768",768,692,0,0,"6","6",4152,4152,4152,"2020-05-04 18:04:28","0",null,null,null,"2020-04-02","2020-10-01","6 months contract. Storage rental paid by cash on May 04, 2020. Storage deposit $1536 transferred from agreement A05-CT207108 to this agreement. ","2020-04-02","10",0,null,0,"0","2","2020-05-04 18:04:27","2","2020-05-04 18:04:27","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"0012474143","C181130","PERSONAL","Ms","Q7dddLoh0EPGaZDKbwv\/jg==","oe4emdjBwqJ3qUpOcI17hw==","","\/QfijdScWhkQWfsmkPMljZ9P+5UUKT0THdSHVa9QeuyLTiEQOKp04v8JakW3KcvglDwzO3ygDTfk48CK+LAID5xp3SASfODgqkpIuHxLDoM=","wKSrUc0OEnw6GepIGxdVoA==",null,"Y5uwS77UN+eKOlIguG0Geg==",null,1,"5553"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:28","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":["7768","1715","768.0","768.00","2","2020-05-04 18:04:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-02","2020-10-01","1715"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-04 18:04:28","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":["7768",1130,"SETTLED","A05-I208097","2020-05-04 18:04:27","2020-04-02","2","2020-05-04 18:04:27","2","2020-05-04 18:04:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:28","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":["8097","RENT","\u9810\u7e73\u79df\u91d1",1,692,"MO","1",692,"2","2020-05-04 18:04:27","2","2020-05-04 18:04:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:28","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":["8097","RENT","\u9810\u7e73\u79df\u91d1",2,692,"MO","1",692,"2","2020-05-04 18:04:27","2","2020-05-04 18:04:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:28","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":["8097","RENT","\u9810\u7e73\u79df\u91d1",3,692,"MO","1",692,"2","2020-05-04 18:04:27","2","2020-05-04 18:04:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:28","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":["8097","RENT","\u9810\u7e73\u79df\u91d1",4,692,"MO","1",692,"2","2020-05-04 18:04:27","2","2020-05-04 18:04:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:28","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":["8097","RENT","\u9810\u7e73\u79df\u91d1",5,692,"MO","1",692,"2","2020-05-04 18:04:27","2","2020-05-04 18:04:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:28","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":["8097","RENT","\u9810\u7e73\u79df\u91d1",6,692,"MO","1",692,"2","2020-05-04 18:04:27","2","2020-05-04 18:04:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4152,0,"8097"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-04 18:04:28","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":[1130,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207742","2020-05-04 18:04:27",4152,"2","2020-05-04 18:04:27","2","2020-05-04 18:04:27","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:28","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":["7742","DEPOSIT",null,"PAID","2020-05-04 18:04:27",0,"2","2020-05-04 18:04:27","2","2020-05-04 18:04:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:28","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":["7742","INVOICE","8097","PAID","2020-05-04 18:04:27",4152,"2","2020-05-04 18:04:27","2","2020-05-04 18:04:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:38","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=3&filter2=2020-04-01&filter3=2020-04-09&page=3","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"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> WC-23 <\/td>\r\n\t\t\t\t\t 4X2.5X8 <\/td>\r\n\t\t\t\t\t $1228.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":"M850375(9)","title":"Mr","lastname":"STETSIUK","firstname":"Andrii","companyname":"","email":"andrew.stet27@gmail.com","tel":"90897030","address":"3\/F A, 10 Prince's Terrace, Mid-Levels, Central, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1746","room_code":"WC-23","retail_price":"1228.0","discounted_price":"1228.00","location_id":"8"}],"roughly_size":"10","total_retail_price":1228,"total_discounted_price":1228,"deposit":2456,"rent_month":"14","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"14","prepaid_amount":16148,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3500.00","warehousing_date":"2020-05-05","rent_from":"2020-05-05","rent_to":"2021-07-04","delivery_service":"0","remark":"14 months contract. Special offer the 13th and 14th months free, average price $978\/month. Storage rental and deposit paid by credit card on May 4, 2020. ","paymethod":"CREDIT_CARD","paymethod2":"CREDIT_CARD","discount_deduct":3500,"order_total":19648,"final_order_total":16148,"location_id":"8","branch_id":"1","company_id":"1","room_key":"076, 48037","order_product":[],"pass":true}},"roughly_size":"10","total_discounted_price":"1228.00","deposit":"2456.00","total_retail_price":"1228.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:39","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":["C201578","PERSONAL","Mr","zBMq6UuXZr1\/OkPrhoyjaQ==","05KwrqLqPDVFNbdLt0shRA==","","4nGkeb1\/4jJljcWQUH9L0A==","ufydS4BBOEjwLB84JNVKGXmjIS6Y9hQxpR7tkdKLLeI=","3dCBmbWZOQIdsX\/WeQX2O6VFMlxnndjM8AxtKAveuQHn5syqJKNVzky8uNa83ozaoGEadYmUqOnu+NPrj1hPqw==","OgOEl9S8b6C8+eikYeuWDg==",null,"ufydS4BBOEjwLB84JNVKGXmjIS6Y9hQxpR7tkdKLLeI=","a5s4aIMPhqsWj8Dgf3F27g==","2","2020-05-04 18:04:38","2","2020-05-04 18:04:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:40","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","8",1578,"NEW","WC-CT207769",1228,1228,2456,0,"14","14",16148,19648,16148,"2020-05-04 18:04:40","0",null,null,null,"2020-05-05","2021-07-04","14 months contract. Special offer the 13th and 14th months free, average price $978\/month. Storage rental and deposit paid by credit card on May 4, 2020. ","2020-05-05","10",0,null,3500,"3500.00","2","2020-05-04 18:04:38","2","2020-05-04 18:04:38","CREDIT_CARD","","","","CREDIT_CARD","","","",null,0,"076, 48037","C201578","PERSONAL","Mr","zBMq6UuXZr1\/OkPrhoyjaQ==","05KwrqLqPDVFNbdLt0shRA==","","3dCBmbWZOQIdsX\/WeQX2O6VFMlxnndjM8AxtKAveuQHn5syqJKNVzky8uNa83ozaoGEadYmUqOnu+NPrj1hPqw==","4nGkeb1\/4jJljcWQUH9L0A==","ufydS4BBOEjwLB84JNVKGXmjIS6Y9hQxpR7tkdKLLeI=","OgOEl9S8b6C8+eikYeuWDg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:40","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":["7769","1746","1228.0","1228.00","2","2020-05-04 18:04:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-05","2021-07-04","1746"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-04 18:04:40","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":["7769","WC-D205398","PAID",2456,0,"2021-07-04","2020-05-04 18:04:38","2020-05-04 18:04:38","2","2020-05-04 18:04:38","2","2020-05-04 18:04:38",1578]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:40","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":["7769",1578,"SETTLED","WC-I208098","2020-05-04 18:04:38","2020-05-05","2","2020-05-04 18:04:38","2","2020-05-04 18:04:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:40","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":["8098","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-04 18:04:38","2","2020-05-04 18:04:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:40","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":["8098","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-05-04 18:04:38","2","2020-05-04 18:04:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:40","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":["8098","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,184,"MO","1",184,"2","2020-05-04 18:04:38","2","2020-05-04 18:04:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:40","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":["8098","RENT","\u9810\u7e73\u79df\u91d1",4,1228,"MO","1",1228,"2","2020-05-04 18:04:38","2","2020-05-04 18:04:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:40","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":["8098","RENT","\u9810\u7e73\u79df\u91d1",5,1228,"MO","1",1228,"2","2020-05-04 18:04:38","2","2020-05-04 18:04:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:40","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":["8098","RENT","\u9810\u7e73\u79df\u91d1",6,1228,"MO","1",1228,"2","2020-05-04 18:04:38","2","2020-05-04 18:04:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:40","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":["8098","RENT","\u9810\u7e73\u79df\u91d1",7,1228,"MO","1",1228,"2","2020-05-04 18:04:38","2","2020-05-04 18:04:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:40","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":["8098","RENT","\u9810\u7e73\u79df\u91d1",8,1228,"MO","1",1228,"2","2020-05-04 18:04:38","2","2020-05-04 18:04:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:40","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":["8098","RENT","\u9810\u7e73\u79df\u91d1",9,1228,"MO","1",1228,"2","2020-05-04 18:04:38","2","2020-05-04 18:04:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:40","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":["8098","RENT","\u9810\u7e73\u79df\u91d1",10,1228,"MO","1",1228,"2","2020-05-04 18:04:38","2","2020-05-04 18:04:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:40","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":["8098","RENT","\u9810\u7e73\u79df\u91d1",11,1228,"MO","1",1228,"2","2020-05-04 18:04:38","2","2020-05-04 18:04:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:40","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":["8098","RENT","\u9810\u7e73\u79df\u91d1",12,1228,"MO","1",1228,"2","2020-05-04 18:04:38","2","2020-05-04 18:04:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:40","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":["8098","RENT","\u9810\u7e73\u79df\u91d1",13,1228,"MO","1",1228,"2","2020-05-04 18:04:38","2","2020-05-04 18:04:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:40","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":["8098","RENT","\u9810\u7e73\u79df\u91d1",14,1228,"MO","1",1228,"2","2020-05-04 18:04:38","2","2020-05-04 18:04:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13692,0,"8098"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-04 18:04:40","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":[1578,"CREDIT_CARD","","","","CREDIT_CARD","","","","PAID","P207743","2020-05-04 18:04:38",16148,"2","2020-05-04 18:04:38","2","2020-05-04 18:04:38","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:40","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":["7743","DEPOSIT","5398","PAID","2020-05-04 18:04:38",2456,"2","2020-05-04 18:04:38","2","2020-05-04 18:04:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:04:40","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":["7743","INVOICE","8098","PAID","2020-05-04 18:04:38",13692,"2","2020-05-04 18:04:38","2","2020-05-04 18:04:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 18:38:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-04 19:19:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****