\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>
X24 <\/td>\n\t\t\t\t\t	7X4X7 <\/td>\n\t\t\t\t\t	$2161.00 <\/td>\n\t\t\t\t	- <\/td>	<\/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":"1945.00","deposit":"4322.00","total_retail_price":"2161.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:04: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` = ?","parameters":["1","1","3","833","NEW","A18-CT208170",2161,1945,4322,0,"13","13",16176,29607,16176,"2020-06-18 14:04:13","0",null,null,null,"2020-06-21","2021-07-20","13 months contract. Special offer the 13th month free. Changed unit from W08 to X24. Storage rental $5460 and deposit $5776, lovebox deposit $250 (ttl:$11486) transferred from A18-CT195820 to this agreement. The balance of storage rental and deposit $16176 paid by bank transfer on June 18,2020.","2020-06-21","28",0,null,13431,"13431.00","2","2020-06-18 14:04:12","2","2020-06-18 14:04:12","BANKIN","","","","BANKIN","","","",null,0,"137,15338189,52034","C180833","PERSONAL","Mr","wgLpImy8bqnEZDZd4PLZbA==","ME1HgmDJnR5612zeAsjIHA==","","CJ0X6EW5AUse3PXTI8VGHfEt8XFcIxrwkty5bKGrI1qbY8um5Mnm+CyMIi\/fd+ktrIWOMeQO4wI\/m4cITZxQNQ==","sJ19c6dVaXHhJTbeoakgiw==","1sigslx75wbzHxx5AIgm3Nk9ZxQBTlWK6teTqUCDsKE=","kyy6KmLDAEo3cJY2wRJedg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:04: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":["8170","999","2161.0","2161.00","2","2020-06-18 14:04:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:04:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-21","2021-07-20","999"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-18 14:04:13","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":["8170","A18-D205480","PAID",4322,0,"2021-07-20","2020-06-18 14:04:12","2020-06-18 14:04:12","2","2020-06-18 14:04:12","2","2020-06-18 14:04:12","833"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:04: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":["8170","833","SETTLED","A18-I208499","2020-06-18 14:04:12","2020-06-21","2","2020-06-18 14:04:12","2","2020-06-18 14:04:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:04: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":["8499","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-18 14:04:12","2","2020-06-18 14:04:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:04: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":["8499","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-06-18 14:04:12","2","2020-06-18 14:04:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:04: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":["8499","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,0,"MO","1",0,"2","2020-06-18 14:04:12","2","2020-06-18 14:04:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:04: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":["8499","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",4,0,"MO","1",0,"2","2020-06-18 14:04:12","2","2020-06-18 14:04:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:04: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":["8499","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",5,0,"MO","1",0,"2","2020-06-18 14:04:12","2","2020-06-18 14:04:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:04: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":["8499","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",6,0,"MO","1",0,"2","2020-06-18 14:04:12","2","2020-06-18 14:04:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:04: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":["8499","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",7,184,"MO","1",184,"2","2020-06-18 14:04:12","2","2020-06-18 14:04:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:04: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":["8499","RENT","\u9810\u7e73\u79df\u91d1",8,1945,"MO","1",1945,"2","2020-06-18 14:04:12","2","2020-06-18 14:04:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:04: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":["8499","RENT","\u9810\u7e73\u79df\u91d1",9,1945,"MO","1",1945,"2","2020-06-18 14:04:12","2","2020-06-18 14:04:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:04: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":["8499","RENT","\u9810\u7e73\u79df\u91d1",10,1945,"MO","1",1945,"2","2020-06-18 14:04:12","2","2020-06-18 14:04:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:04: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":["8499","RENT","\u9810\u7e73\u79df\u91d1",11,1945,"MO","1",1945,"2","2020-06-18 14:04:12","2","2020-06-18 14:04:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:04: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":["8499","RENT","\u9810\u7e73\u79df\u91d1",12,1945,"MO","1",1945,"2","2020-06-18 14:04:12","2","2020-06-18 14:04:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:04: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":["8499","RENT","\u9810\u7e73\u79df\u91d1",13,1945,"MO","1",1945,"2","2020-06-18 14:04:12","2","2020-06-18 14:04:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:04:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11854,0,"8499"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-18 14:04: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":["833","BANKIN","","","","BANKIN","","","","PAID","P208142","2020-06-18 14:04:12",16176,"2","2020-06-18 14:04:12","2","2020-06-18 14:04:12","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:04: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":["8142","DEPOSIT","5480","PAID","2020-06-18 14:04:12",4322,"2","2020-06-18 14:04:12","2","2020-06-18 14:04:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:04: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":["8142","INVOICE","8499","PAID","2020-06-18 14:04:12",11854,"2","2020-06-18 14:04:12","2","2020-06-18 14:04:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:18:54","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[],"index_url_parameter":"type=INVOICE","_payment_type":"INVOICE","warehousing":{"1":{"new_customer":"0","identity_type":"BUSINESS","identity_id":"32676788","title":"Mr","lastname":"LEUNG","firstname":"Louis","companyname":"Bonanza Interior Products Limited","email":"bonanza.interior@gmail.com","tel":"90906006","address":"Flat 1803-5, Hang Seng North Point Building 335-341 King's Rd, North Point, HK","pass":true,"customer_id":"1586","customer_code":"C201586","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1416","room_code":"C15-110","retail_price":"720.0","discounted_price":"720.00","location_id":"6"}],"roughly_size":"9","total_retail_price":720,"total_discounted_price":648,"deposit":720,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":6880,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1616.00","warehousing_date":"2020-06-20","rent_from":"2020-06-20","rent_to":"2021-06-19","delivery_service":"0","remark":"12 months contract. Special offer the 11th & 12th months free and 5% 'rent now' discount for the first contract. Storage rental and deposit paid by bank transfer on June 17, 2020.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":1616,"order_total":8496,"final_order_total":6880,"location_id":"6","branch_id":"3","company_id":"1","room_key":"","order_product":[],"pass":true}},"selected_room_tr":"\n	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n	\n \n\n \n \n \n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> C15-110 <\/td>\n\t\t\t\t\t 3X3X6.5 <\/td>\n\t\t\t\t\t $720.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"9","total_discounted_price":"648.00","deposit":"720.00","total_retail_price":"720.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:18:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","3","6","1586","NEW","C15-CT208171",720,648,720,0,"12","12",6880,8496,6880,"2020-06-18 14:18:55","0",null,null,null,"2020-06-20","2021-06-19","12 months contract. Special offer the 11th & 12th months free and 5% 'rent now' discount for the first contract. Storage rental and deposit paid by bank transfer on June 17, 2020.","2020-06-20","9",0,null,1616,"1616.00","2","2020-06-18 14:18:54","2","2020-06-18 14:18:54","BANKIN","","","","BANKIN","","","",null,0,"","C201586","BUSINESS","Mr","UVjrCP4Ux0XGx\/NzXvnkmQ==","yXKc2lCF323ApRADrjNaSg==","Bonanza Interior Products Limited","djHiHXMolmT13wVdf6TQPT6gi\/lqypjeVCbA4PUDsIzMdXoxzF9W1d767uZrMM9UR8Ko7TPQkrFu78V0zh1J2eoxzomoqGcKm\/7h+RFaKPw=","smG3fSRJ66n9dtGIZ+0hng==","FOOO3aO2hhdQRAXW6Va0cOJSidlswlLbbwc1PAfAGd4=",null,"tR+EFMxmviDjsG6ERopa1g=="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:18:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8171","1416","720.0","720.00","2","2020-06-18 14:18:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:18:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-20","2021-06-19","1416"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-18 14:18:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["8171","C15-D205481","PAID",720,0,"2021-06-19","2020-06-18 14:18:54","2020-06-18 14:18:54","2","2020-06-18 14:18:54","2","2020-06-18 14:18:54","1586"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:18:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8171","1586","SETTLED","C15-I208500","2020-06-18 14:18:54","2020-06-20","2","2020-06-18 14:18:54","2","2020-06-18 14:18:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:18:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8500","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-18 14:18:54","2","2020-06-18 14:18:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:18:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8500","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-06-18 14:18:54","2","2020-06-18 14:18:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:18:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8500","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,328,"MO","1",328,"2","2020-06-18 14:18:54","2","2020-06-18 14:18:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:18:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8500","RENT","\u9810\u7e73\u79df\u91d1",4,648,"MO","1",648,"2","2020-06-18 14:18:54","2","2020-06-18 14:18:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:18:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8500","RENT","\u9810\u7e73\u79df\u91d1",5,648,"MO","1",648,"2","2020-06-18 14:18:54","2","2020-06-18 14:18:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:18:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8500","RENT","\u9810\u7e73\u79df\u91d1",6,648,"MO","1",648,"2","2020-06-18 14:18:54","2","2020-06-18 14:18:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:18:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8500","RENT","\u9810\u7e73\u79df\u91d1",7,648,"MO","1",648,"2","2020-06-18 14:18:54","2","2020-06-18 14:18:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:18:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8500","RENT","\u9810\u7e73\u79df\u91d1",8,648,"MO","1",648,"2","2020-06-18 14:18:54","2","2020-06-18 14:18:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:18:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8500","RENT","\u9810\u7e73\u79df\u91d1",9,648,"MO","1",648,"2","2020-06-18 14:18:54","2","2020-06-18 14:18:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:18:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8500","RENT","\u9810\u7e73\u79df\u91d1",10,648,"MO","1",648,"2","2020-06-18 14:18:54","2","2020-06-18 14:18:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:18:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8500","RENT","\u9810\u7e73\u79df\u91d1",11,648,"MO","1",648,"2","2020-06-18 14:18:54","2","2020-06-18 14:18:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:18:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8500","RENT","\u9810\u7e73\u79df\u91d1",12,648,"MO","1",648,"2","2020-06-18 14:18:54","2","2020-06-18 14:18:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:18:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6160,0,"8500"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-18 14:18:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1586","BANKIN","","","","BANKIN","","","","PAID","P208143","2020-06-18 14:18:54",6880,"2","2020-06-18 14:18:54","2","2020-06-18 14:18:54","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:18:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8143","DEPOSIT","5481","PAID","2020-06-18 14:18:54",720,"2","2020-06-18 14:18:54","2","2020-06-18 14:18:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:18:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8143","INVOICE","8500","PAID","2020-06-18 14:18:54",6160,"2","2020-06-18 14:18:54","2","2020-06-18 14:18:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:19:06","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ?, `customer_companyname` = ? where id = ?","parameters":["NEW","'0005796799; '0005019599","12 months contract. Special offer the 11th & 12th months free and 5% 'rent now' discount for the first contract. Storage rental and deposit paid by bank transfer on June 17, 2020.","2020-06-18 14:19:06","2","yXKc2lCF323ApRADrjNaSg==","UVjrCP4Ux0XGx\/NzXvnkmQ==","FOOO3aO2hhdQRAXW6Va0cOJSidlswlLbbwc1PAfAGd4=","smG3fSRJ66n9dtGIZ+0hng==","djHiHXMolmT13wVdf6TQPT6gi\/lqypjeVCbA4PUDsIzMdXoxzF9W1d767uZrMM9UR8Ko7TPQkrFu78V0zh1J2eoxzomoqGcKm\/7h+RFaKPw=","Bonanza Interior Products Limited",8171]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:22:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:25:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:38:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:42:48","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[],"index_url_parameter":"type=INVOICE&filter1=0&filter2=1222","_payment_type":"INVOICE","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"M009619(4)","title":"Ms","lastname":"XIAO","firstname":"Jiayu","companyname":"","email":"","tel":"96318553","address":"Flat A, 27\/F, Blk 5, Island Resort, Siu Sai Wan","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1249","room_code":"B01-059","retail_price":"1.0","discounted_price":"1.00","location_id":"5"}],"roughly_size":"6","total_retail_price":1,"total_discounted_price":730,"deposit":1536,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3726,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-17","rent_from":"2020-06-17","rent_to":"2020-09-16","delivery_service":"0","remark":"3 months contract. Storage rental, deposit and smart card, padlock paid by bank transfer on June 17,2020. Smart card mail out on June 18,2020.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3846,"final_order_total":3846,"location_id":"5","branch_id":"2","company_id":"1","room_key":"'0012438122","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"},{"product_id":"12","product_name":"\u5009\u9396\u5319","qty":"1","price":"60.0"}],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n\n \n \n \n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> B01-059 <\/td>\n\t\t\t\t\t 2X3X7 <\/td>\n\t\t\t\t\t $1.00 <\/td>\n\t\t\t\t - <\/td> <\/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":"6","total_discounted_price":"730.00","deposit":"1536.00","total_retail_price":"1.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:42:50","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":["C201629","PERSONAL","Ms","qi39ahc2iqoRMjhgwaRGMA==","n2+dQtQa2AXChWp\/SWrD4Q==","","4NzcLyk10ky3J\/iu4+y1hw==",null,"0ACQDKA4GUxOgkSIXfdm6V2VBVJ5gRCFh7t7kY7auQyMJEvTZ62cv+SjJZGWrbOV","oBYcMN\/TDZ0TXO8aJnCZyQ==",null,null,"vMO80GltTcQIcBg\/+WgC5g==","2","2020-06-18 14:42:48","2","2020-06-18 14:42:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:42: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` = ?","parameters":["1","2","5",1629,"NEW","B01-CT208172",1,730,1536,0,"3","3",3726,3846,3846,"2020-06-18 14:42:50","0",null,null,null,"2020-06-17","2020-09-16","3 months contract. Storage rental, deposit and smart card, padlock paid by bank transfer on June 17,2020. Smart card mail out on June 18,2020.","2020-06-17","6",0,null,0,"0","2","2020-06-18 14:42:48","2","2020-06-18 14:42:48","BANKIN","","","","BANKIN","","","",null,0,"'0012438122","C201629","PERSONAL","Ms","qi39ahc2iqoRMjhgwaRGMA==","n2+dQtQa2AXChWp\/SWrD4Q==","","0ACQDKA4GUxOgkSIXfdm6V2VBVJ5gRCFh7t7kY7auQyMJEvTZ62cv+SjJZGWrbOV","4NzcLyk10ky3J\/iu4+y1hw==",null,"oBYcMN\/TDZ0TXO8aJnCZyQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:42:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8172",1629,"11","1","60.0",60,"2","2020-06-18 14:42:48","2","2020-06-18 14:42:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:42:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8172",1629,"12","1","60.0",60,"2","2020-06-18 14:42:48","2","2020-06-18 14:42:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:42:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[120,"8172"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-06-18 14:42: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":["8172","1249","1.0","1.00","2","2020-06-18 14:42:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:42: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-06-17","2020-09-16","1249"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-18 14:42:50","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":["8172","B01-D205482","PAID",1536,0,"2020-09-16","2020-06-18 14:42:48","2020-06-18 14:42:48","2","2020-06-18 14:42:48","2","2020-06-18 14:42:48",1629]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:42: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":["8172",1629,"SETTLED","B01-I208501","2020-06-18 14:42:48","2020-06-17","2","2020-06-18 14:42:48","2","2020-06-18 14:42:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:42: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":["8501","RENT","\u9810\u7e73\u79df\u91d1",1,730,"MO","1",730,"2","2020-06-18 14:42:48","2","2020-06-18 14:42:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:42: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":["8501","RENT","\u9810\u7e73\u79df\u91d1",2,730,"MO","1",730,"2","2020-06-18 14:42:48","2","2020-06-18 14:42:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:42: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":["8501","RENT","\u9810\u7e73\u79df\u91d1",3,730,"MO","1",730,"2","2020-06-18 14:42:48","2","2020-06-18 14:42:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:42:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8501","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-06-18 14:42:48","2","2020-06-18 14:42:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:42:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8501","ORDER_PRODUCT","60.0","PCS","1",60,"12","2","2020-06-18 14:42:48","2","2020-06-18 14:42:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:42:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2310,0,"8501"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-18 14:42: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":[1629,"BANKIN","","","","BANKIN","","","","PAID","P208144","2020-06-18 14:42:48",3846,"2","2020-06-18 14:42:48","2","2020-06-18 14:42:48","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:42: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":["8144","DEPOSIT","5482","PAID","2020-06-18 14:42:48",1536,"2","2020-06-18 14:42:48","2","2020-06-18 14:42:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:42: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":["8144","INVOICE","8501","PAID","2020-06-18 14:42:48",2310,"2","2020-06-18 14:42:48","2","2020-06-18 14:42:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 14:44:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:06: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":"filter1=3&filter2=1315","floor_plan_rent_room":[{"room_id":"1702","master_room_id":"212","room_code":"A16-211"}],"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> A16-211 <\/td>\r\n\t\t\t\t\t 5X4X7 <\/td>\r\n\t\t\t\t\t $1605.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":"P773198(5)","title":"Ms","lastname":"ESPLEY","firstname":"Diane Susan","companyname":"","email":"dse88@yahoo.com","tel":"92335340","address":"27B Lung Cheung Garden, 26 Kennedy Town Praya","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1702","room_code":"A16-211","retail_price":"1605.0","discounted_price":"1605.00","location_id":"7"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1688,"deposit":3376,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":19588,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"5732.00","warehousing_date":"2020-06-21","rent_from":"2020-06-21","rent_to":"2021-07-20","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free and 50% off for the first 3 months. Storage rental and deposit will pay by bank transfer.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":5732,"order_total":25320,"final_order_total":19588,"location_id":"7","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"roughly_size":"20","total_discounted_price":"1688.00","deposit":"3376.00","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:06:58","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":["C201630","PERSONAL","Ms","ZoBN66ljb8LQgHh4BqVBDg==","UoUJou5X7pavudwgDyvCJA==","","w\/2dl6ITSYSDFlV5c5+Bgw==","nOA7YGE9szbZ5hT5PXEbXw==","k9G75b1uy\/8wi8mVvzSJ8t1xo2vv4QwjDIlU\/5IQXU2PX\/DgJXSHUoudpIbbHNJi","TACqK5DRIbkfGqXUVM\/Wzg==",null,"nOA7YGE9szbZ5hT5PXEbXw==","exzLTwTvbfYisqDdXjhQsw==","2","2020-06-18 15:06:57","2","2020-06-18 15:06:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:06:59","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","7",1630,"NEW","A16-CT208173",1605,1688,3376,0,"13","13",19588,25320,19588,"2020-06-18 15:06:59","0",null,null,null,"2020-06-21","2021-07-20","13 months contract. Special offer the 13th month free and 50% off for the first 3 months. Storage rental and deposit will pay by bank transfer.","2020-06-21","20",0,null,5732,"5732.00","2","2020-06-18 15:06:57","2","2020-06-18 15:06:57","BANKIN","","","","BANKIN","","","",null,0,"","C201630","PERSONAL","Ms","ZoBN66ljb8LQgHh4BqVBDg==","UoUJou5X7pavudwgDyvCJA==","","k9G75b1uy\/8wi8mVvzSJ8t1xo2vv4QwjDIlU\/5IQXU2PX\/DgJXSHUoudpIbbHNJi","w\/2dl6ITSYSDFlV5c5+Bgw==","nOA7YGE9szbZ5hT5PXEbXw==","TACqK5DRIbkfGqXUVM\/Wzg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:06:59","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":["8173","1702","1605.0","1605.00","2","2020-06-18 15:06:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:06:59","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-21","2021-07-20","1702"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-18 15:06:59","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":["8173","A16-D205483","PAID",3376,0,"2021-07-20","2020-06-18 15:06:57","2020-06-18 15:06:57","2","2020-06-18 15:06:57","2","2020-06-18 15:06:57",1630]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:06:59","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":["8173",1630,"SETTLED","A16-I208502","2020-06-18 15:06:57","2020-06-21","2","2020-06-18 15:06:57","2","2020-06-18 15:06:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:06:59","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":["8502","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-18 15:06:57","2","2020-06-18 15:06:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:06:59","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":["8502","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-06-18 15:06:57","2","2020-06-18 15:06:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:06:59","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":["8502","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,0,"MO","1",0,"2","2020-06-18 15:06:57","2","2020-06-18 15:06:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:06:59","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":["8502","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",4,1020,"MO","1",1020,"2","2020-06-18 15:06:57","2","2020-06-18 15:06:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:06:59","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":["8502","RENT","\u9810\u7e73\u79df\u91d1",5,1688,"MO","1",1688,"2","2020-06-18 15:06:57","2","2020-06-18 15:06:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:06:59","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":["8502","RENT","\u9810\u7e73\u79df\u91d1",6,1688,"MO","1",1688,"2","2020-06-18 15:06:57","2","2020-06-18 15:06:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:06:59","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":["8502","RENT","\u9810\u7e73\u79df\u91d1",7,1688,"MO","1",1688,"2","2020-06-18 15:06:57","2","2020-06-18 15:06:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:06:59","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":["8502","RENT","\u9810\u7e73\u79df\u91d1",8,1688,"MO","1",1688,"2","2020-06-18 15:06:57","2","2020-06-18 15:06:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:06:59","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":["8502","RENT","\u9810\u7e73\u79df\u91d1",9,1688,"MO","1",1688,"2","2020-06-18 15:06:57","2","2020-06-18 15:06:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:06:59","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":["8502","RENT","\u9810\u7e73\u79df\u91d1",10,1688,"MO","1",1688,"2","2020-06-18 15:06:57","2","2020-06-18 15:06:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:06:59","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":["8502","RENT","\u9810\u7e73\u79df\u91d1",11,1688,"MO","1",1688,"2","2020-06-18 15:06:57","2","2020-06-18 15:06:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:06:59","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":["8502","RENT","\u9810\u7e73\u79df\u91d1",12,1688,"MO","1",1688,"2","2020-06-18 15:06:57","2","2020-06-18 15:06:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:06:59","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":["8502","RENT","\u9810\u7e73\u79df\u91d1",13,1688,"MO","1",1688,"2","2020-06-18 15:06:57","2","2020-06-18 15:06:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:06:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[16212,0,"8502"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-18 15:06:59","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":[1630,"BANKIN","","","","BANKIN","","","","PAID","P208145","2020-06-18 15:06:57",19588,"2","2020-06-18 15:06:57","2","2020-06-18 15:06:57","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:06:59","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":["8145","DEPOSIT","5483","PAID","2020-06-18 15:06:57",3376,"2","2020-06-18 15:06:57","2","2020-06-18 15:06:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:06:59","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":["8145","INVOICE","8502","PAID","2020-06-18 15:06:57",16212,"2","2020-06-18 15:06:57","2","2020-06-18 15:06:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:19:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:24:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:42:47","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","floor_plan_rent_room":[],"warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"K936775(6)","title":"Ms","lastname":"BERTHOLD","firstname":"Katrina Maree","companyname":"","email":"francislim@sino.com","tel":"60510751","address":"11-12\/F, Tsim Sha Tsui Centre, Salibury Road, TST, H.K","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"469 available_room_list_input","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"949.00","discount":"4.91","monthly_deduct":49.0018,"room_id":"242","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"242","room_code":"D46","retail_price":"998.0","discounted_price":949,"location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":1996,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3493,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1497.00","warehousing_date":"2020-06-19","rent_from":"2020-06-19","rent_to":"2020-09-18","delivery_service":"0","remark":"3 months contract. Special offer 50% the first 3 months. Storage rental and deposit paid by EPS on JUNE 18,2020. Smart Card and padlock provided on JUNE 18,2020.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":1497,"order_total":4990,"final_order_total":3493,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190,37178","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n\n \n \n \n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> D46 <\/td>\n\t\t\t\t\t 4X3X8 <\/td>\n\t\t\t\t\t $998.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"12","total_discounted_price":"998.00","deposit":"1996.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:42:48","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":["C201631","PERSONAL","Ms","FwK+8\/PQd5Fu3670hQaaWg==","epTdMNNxYkiWMsNKNy5Iog==","","+pZAJZYuC8AX5p3Ja1bpZw==","56YMcliFAYVxfcG2iJnTVIwe0vOm2LWEmRG\/jl86pWo=","ZXt+knd0tVToT2W8q\/vhfQbcXP5oM4bKOoLHVuqqD\/2lvHxdCQHDpaHUgxdfMgm7RLB\/0wAlpuuok9C\/yn\/2zw==","DctiAvJ4uTGgdnVRMR+ZSQ==",null,"56YMcliFAYVxfcG2iJnTVIwe0vOm2LWEmRG\/jl86pWo=","Bqbd3l2YjvzPq0ghNiBbBA==","2","2020-06-18 15:42:47","2","2020-06-18 15:42:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:42:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1",1631,"NEW","A12-CT208174",998,998,1996,0,"3","3",3493,4990,3493,"2020-06-18 15:42:49","0",null,null,null,"2020-06-19","2020-09-18","3 months contract. Special offer 50% the first 3 months. Storage rental and deposit paid by EPS on JUNE 18,2020. Smart Card and padlock provided on JUNE 18,2020.","2020-06-19","12",0,null,1497,"1497.00","2","2020-06-18 15:42:47","2","2020-06-18 15:42:47","EPS","","","","EPS","","","",null,0,"190,37178","C201631","PERSONAL","Ms","FwK+8\/PQd5Fu3670hQaaWg==","epTdMNNxYkiWMsNKNy5Iog==","","ZXt+knd0tVToT2W8q\/vhfQbcXP5oM4bKOoLHVuqqD\/2lvHxdCQHDpaHUgxdfMgm7RLB\/0wAlpuuok9C\/yn\/2zw==","+pZAJZYuC8AX5p3Ja1bpZw==","56YMcliFAYVxfcG2iJnTVIwe0vOm2LWEmRG\/jl86pWo=","DctiAvJ4uTGgdnVRMR+ZSQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:42:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["8174","469 available_room_list_input","6","242","%","4.91",49.0018,"2","2020-06-18 15:42:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:42:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8174","242","998.0",949,"2","2020-06-18 15:42:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:42:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-19","2020-09-18","242"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-18 15:42:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["8174","A12-D205484","PAID",1996,0,"2020-09-18","2020-06-18 15:42:47","2020-06-18 15:42:47","2","2020-06-18 15:42:47","2","2020-06-18 15:42:47",1631]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:42:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8174",1631,"SETTLED","A12-I208503","2020-06-18 15:42:47","2020-06-19","2","2020-06-18 15:42:47","2","2020-06-18 15:42:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:42:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8503","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-18 15:42:47","2","2020-06-18 15:42:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:42:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8503","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,499,"MO","1",499,"2","2020-06-18 15:42:47","2","2020-06-18 15:42:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:42:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8503","RENT","\u9810\u7e73\u79df\u91d1",3,998,"MO","1",998,"2","2020-06-18 15:42:47","2","2020-06-18 15:42:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:42:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1497,0,"8503"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-18 15:42:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1631,"EPS","","","","EPS","","","","PAID","P208146","2020-06-18 15:42:47",3493,"2","2020-06-18 15:42:47","2","2020-06-18 15:42:47","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:42:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8146","DEPOSIT","5484","PAID","2020-06-18 15:42:47",1996,"2","2020-06-18 15:42:47","2","2020-06-18 15:42:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:42:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8146","INVOICE","8503","PAID","2020-06-18 15:42:47",1497,"2","2020-06-18 15:42:47","2","2020-06-18 15:42:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 15:54:43","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","190,37178","3 months contract. Special offer 50% the first 3 months. Storage rental and deposit paid by EPS on JUNE 18,2020. Smart Card and padlock provided on JUNE 18,2020.","2020-06-18 15:54:43","2","b0oALatreGSZ7Sc0VMzFlQ==","WLpmUYQzfww+zElM9ussXg==","56YMcliFAYVxfcG2iJnTVIwe0vOm2LWEmRG\/jl86pWo=","+pZAJZYuC8AX5p3Ja1bpZw==","ZXt+knd0tVToT2W8q\/vhfQbcXP5oM4bKOoLHVuqqD\/2lvHxdCQHDpaHUgxdfMgm7RLB\/0wAlpuuok9C\/yn\/2zw==",8174]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:06:23","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[],"index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":805,"customer_code":"C180805","identity_type":"PERSONAL","identity_id":"D048456(4)","title":"Mr","lastname":"Ip","firstname":"Wai Man Peter","companyname":"","email":"peterip_123@yahoo.com.hk","tel":"90490309","address":"Flat B, 33\/F, Kam Fung Building, 171 Aberdeen Main Road, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1081.0","renew_rent_month":"3","renew_warehousing_date":"2020-06-24","renew_room_key":"054,49726","renew_remark":"3 months contract. Storage rental paid by cheque on Mar 20, 2020. Storage deposit transferred from agreement A12-CT196759 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207461, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"4","order_discount":[],"order_room":[{"room_id":"47","room_code":"A47","retail_price":"1138.0","discounted_price":"946.00","location_id":"1"}],"roughly_size":"15","total_retail_price":1138,"total_discounted_price":1081,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3243,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-24","rent_from":"2020-06-24","rent_to":"2020-09-23","delivery_service":"0","remark":"3 months contract. Storage rental paid by cheque on June 18, 2020. Storage deposit transferred from agreement A12-CT207461 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":3243,"final_order_total":3243,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,49726","order_product":[],"pass":true}},"first_order_id":"4593","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> A47 <\/td>\r\n\t\t\t\t\t 3X5X8 <\/td>\r\n\t\t\t\t\t $1138.00 <\/td>\r\n\t\t\t\t $946.0 <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"15","total_discounted_price":"1081.0","deposit":"0","total_retail_price":"1138.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:06:23","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",805,"NEW","A12-CT208175",1138,1081,0,0,"3","3",3243,3243,3243,"2020-06-18 16:06:23","0",null,null,null,"2020-06-24","2020-09-23","3 months contract. Storage rental paid by cheque on June 18, 2020. Storage deposit transferred from agreement A12-CT207461 to this agreement.","2020-06-24","15",0,null,0,"0","2","2020-06-18 16:06:23","2","2020-06-18 16:06:23","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"054,49726","C180805","PERSONAL","Mr","KMW2WNS4\/2Ou1fiLVvP7rg==","bXicfGTTHvCncWFCqwKkUQ==","","2+TfOoy+5c7k+G5pAXlGhKviKQlQ6JMlJ23T5fHsKxBTgK45VYPwAcfHn7dYoNoQRM9cbLQN5++IWilHFxyTiUAmneE4Sfm5Ij8ZN2RhbSo=","vr\/AdzwKQbtT0jM33r1WTQ==","z\/nGCny6I9XIiNief2Hoy+Tox243fC9WIAZtWgdy2Cw=","DNNeq\/sh\/XOOePWAsw2neQ==",null,1,"4593"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:06:23","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":["8175","47","1138.0","946.00","2","2020-06-18 16:06:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:06:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-24","2020-09-23","47"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-18 16:06:23","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":["8175",805,"SETTLED","A12-I208504","2020-06-18 16:06:23","2020-06-24","2","2020-06-18 16:06:23","2","2020-06-18 16:06:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:06:23","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":["8504","RENT","\u9810\u7e73\u79df\u91d1",1,1081,"MO","1",1081,"2","2020-06-18 16:06:23","2","2020-06-18 16:06:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:06:23","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":["8504","RENT","\u9810\u7e73\u79df\u91d1",2,1081,"MO","1",1081,"2","2020-06-18 16:06:23","2","2020-06-18 16:06:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:06:23","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":["8504","RENT","\u9810\u7e73\u79df\u91d1",3,1081,"MO","1",1081,"2","2020-06-18 16:06:23","2","2020-06-18 16:06:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:06:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3243,0,"8504"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-18 16:06:23","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":[805,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P208147","2020-06-18 16:06:23",3243,"2","2020-06-18 16:06:23","2","2020-06-18 16:06:23","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:06:23","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":["8147","DEPOSIT",null,"PAID","2020-06-18 16:06:23",0,"2","2020-06-18 16:06:23","2","2020-06-18 16:06:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:06:23","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":["8147","INVOICE","8504","PAID","2020-06-18 16:06:23",3243,"2","2020-06-18 16:06:23","2","2020-06-18 16:06:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:15:13","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":463,"customer_code":"C170463","identity_type":"PERSONAL","identity_id":"E288313(2)","title":"Mr","lastname":"Chiu ","firstname":"Yiu Ki","companyname":"","email":null,"tel":"90228555","address":"Flat 23B,22 Aberdeen Main Road,Aberdeen","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"698.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-28","renew_room_key":"052,33974","renew_remark":"6 months contract. Storage rental paid by cash on December 14, 2019. Storage deposit transferred from agreement A14-CT195213 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196694, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"30","order_discount":[],"order_room":[{"room_id":"640","room_code":"M51","retail_price":"775.0","discounted_price":"775.00","location_id":"2"}],"roughly_size":"9","total_retail_price":775,"total_discounted_price":698,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":4188,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-28","rent_from":"2020-05-28","rent_to":"2020-11-27","delivery_service":"0","remark":"6 months contract. Storage rental paid by cash on June 18,2020. Storage deposit transferred from agreement A14-CT196694 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":4188,"final_order_total":4188,"location_id":"2","branch_id":"1","company_id":"1","room_key":"052,33974","order_product":[],"pass":true}},"first_order_id":"3825","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> M51 <\/td>\r\n\t\t\t\t\t 3X3X8 <\/td>\r\n\t\t\t\t\t $775.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":"9","total_discounted_price":"698.0","deposit":"0","total_retail_price":"775.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:15:14","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",463,"NEW","A14-CT208176",775,698,0,0,"6","6",4188,4188,4188,"2020-06-18 16:15:14","0",null,null,null,"2020-05-28","2020-11-27","6 months contract. Storage rental paid by cash on June 18,2020. Storage deposit transferred from agreement A14-CT196694 to this agreement.","2020-05-28","9",0,null,0,"0","2","2020-06-18 16:15:13","2","2020-06-18 16:15:13","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"052,33974","C170463","PERSONAL","Mr","fDjbvtG\/SvXrctE2WR2fFw==","FysZS\/0giBuTHN9RoeYUjQ==","","x\/kLFomFM3rGdBuCxYoI5SP8MfY5ixkQhguuKo2Ea0JZraMI32jc1PMZRUkvvstZ","Z\/9JgPZiqPB17mO3Tg5IAw==",null,"HVceRe5ILvTry7RpUhItKA==",null,1,"3825"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:15:14","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":["8176","640","775.0","775.00","2","2020-06-18 16:15:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:15:14","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-28","2020-11-27","640"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-18 16:15:14","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":["8176",463,"SETTLED","A14-I208505","2020-06-18 16:15:13","2020-05-28","2","2020-06-18 16:15:13","2","2020-06-18 16:15:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:15:14","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":["8505","RENT","\u9810\u7e73\u79df\u91d1",1,698,"MO","1",698,"2","2020-06-18 16:15:13","2","2020-06-18 16:15:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:15:14","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":["8505","RENT","\u9810\u7e73\u79df\u91d1",2,698,"MO","1",698,"2","2020-06-18 16:15:13","2","2020-06-18 16:15:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:15:14","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":["8505","RENT","\u9810\u7e73\u79df\u91d1",3,698,"MO","1",698,"2","2020-06-18 16:15:13","2","2020-06-18 16:15:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:15:14","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":["8505","RENT","\u9810\u7e73\u79df\u91d1",4,698,"MO","1",698,"2","2020-06-18 16:15:13","2","2020-06-18 16:15:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:15:14","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":["8505","RENT","\u9810\u7e73\u79df\u91d1",5,698,"MO","1",698,"2","2020-06-18 16:15:13","2","2020-06-18 16:15:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:15:14","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":["8505","RENT","\u9810\u7e73\u79df\u91d1",6,698,"MO","1",698,"2","2020-06-18 16:15:13","2","2020-06-18 16:15:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:15:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4188,0,"8505"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-18 16:15:14","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":[463,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P208148","2020-06-18 16:15:13",4188,"2","2020-06-18 16:15:13","2","2020-06-18 16:15:13","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:15:14","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":["8148","DEPOSIT",null,"PAID","2020-06-18 16:15:13",0,"2","2020-06-18 16:15:13","2","2020-06-18 16:15:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:15:14","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":["8148","INVOICE","8505","PAID","2020-06-18 16:15:13",4188,"2","2020-06-18 16:15:13","2","2020-06-18 16:15:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:33:36","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","'0012522650;'0012398434","12 months contract. Special offer 50% off for the first 3 months and the 11th & 12th months free for the first contract. Storage rental and deposit paid by bank transfer on June 05,2020. Smart card and padlock paid on the same day.","2020-06-18 16:33:36","2","BfbwRFgXcXfr1bciP\/Bldg==","hyN5\/h7JzFo++OquXZzInSASxbDCbJ\/SZO9VOLcd8pQ=","TpsVfG6TRmESVE8Ld40twF3YfnHeiOw2xU7MU\/5P8gw=","NYLur5T\/CFerDStJz2L3pg==","SdKDHVV80KEKdMraxsG12aBFsdLVTpUihFJYoCcZ5XqOWg6fDAtO6pZINnapCEdRPkXiiHFep1AMP2DL0rL9RZTCryRzQRX094UzieyxZK0=",8070]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:40:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:42:09","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":["C201632","PERSONAL","Ms","xSbILzZ8vw1LJlc\/2WX8ng==","EZtigKO\/pqUtttXKHr6APA==","","CfzRC\/7dXodGqI8UzeN3UA==",null,"6F88GPSmmnGXsPk2ZyJKWg==","GdyuY9yXus+qmbYp1EHImQ==","",null,"E689UctddjnatCRme5uUjw==","2","2020-06-18 16:42:07","2","2020-06-18 16:42:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:42:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:48:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 16:58:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 17:15:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 18:12:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 18:15:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 18:26:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 18:43:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-18 23:35:51","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****