\r\n\t\t\t\t\tD07 4X3X4 $598.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"568.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 11:26:15","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",834,"NEW","A12-CT208449",598,568,0,0,"3","3",1704,1704,1704,"2020-07-23 11:26:15","0",null,null,null,"2020-07-28","2020-10-27","3 months contract. Storage rental paid by bank transfer on Jul 23, 2020. Storage deposit transferred from agreement A12-CT207664 to this agreement.\r\n","2020-07-28","12",0,null,0,"0","2","2020-07-23 11:26:15","2","2020-07-23 11:26:15","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"134,30221","C180834","PERSONAL","Ms","G2xqKoaAB4yeR+cf9ZGMdg==","U9yoE9KqV1v8YlRkf7Q2yg==","","nLjhSMtekhxQpcfX8SNans875\/V7aIHDhPlCmQHH9uNbzt8DFEAO7N2hfazru6UUlTBTViJjKiBDh+oaLnxYwQ==","arpZc1qFqpaOpcxV\/MnJQQ==","rCRtqQSRWqiXITT\/u46s526Wgky9rIcrW67drVdGPXw=","E8DFyj493b9lDECElzTPsQ==",null,1,"4849"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 11:26:15","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":["8449","203","598.0","598.00","2","2020-07-23 11:26:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 11:26:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-28","2020-10-27","203"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-23 11:26:15","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":["8449",834,"SETTLED","A12-I208778","2020-07-23 11:26:15","2020-07-28","2","2020-07-23 11:26:15","2","2020-07-23 11:26:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 11:26:15","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":["8778","RENT","\u9810\u7e73\u79df\u91d1",1,568,"MO","1",568,"2","2020-07-23 11:26:15","2","2020-07-23 11:26:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 11:26:15","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":["8778","RENT","\u9810\u7e73\u79df\u91d1",2,568,"MO","1",568,"2","2020-07-23 11:26:15","2","2020-07-23 11:26:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 11:26:15","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":["8778","RENT","\u9810\u7e73\u79df\u91d1",3,568,"MO","1",568,"2","2020-07-23 11:26:15","2","2020-07-23 11:26:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 11:26:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1704,0,"8778"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-07-23 11:26:15","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":[834,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208421","2020-07-23 11:26:15",1704,"2","2020-07-23 11:26:15","2","2020-07-23 11:26:15","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 11:26:15","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":["8421","DEPOSIT",null,"PAID","2020-07-23 11:26:15",0,"2","2020-07-23 11:26:15","2","2020-07-23 11:26:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 11:26:15","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":["8421","INVOICE","8778","PAID","2020-07-23 11:26:15",1704,"2","2020-07-23 11:26:15","2","2020-07-23 11:26:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 11:55:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 12:33:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 12:39:30","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":{"1":{"room_id":"728","master_room_id":"34","room_code":"O04"}},"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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tO04 4X3X8 $998.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"R759033(3)","title":"Mr","lastname":"ASHWORTH","firstname":"Simon Henry Charles","companyname":"","email":"simon_ashworth@live.co.uk","tel":"63427087","address":"32C, Tower 7, Bel-Air 6, Pokfulam, Aberdeen","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"728","room_code":"O04","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":899,"deposit":1996,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":7120,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"270.00","warehousing_date":"2020-07-25","rent_from":"2020-07-25","rent_to":"2021-01-24","delivery_service":"0","remark":"6 months contract. special rent now offer 5% off. Storage deposit $500 paid by EPS on Jul 18, 2020. Remaining rental and deposit $6620 paid by EPS on Jul 23, 2020. Smart card provided on the same day.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":270,"order_total":7390,"final_order_total":7120,"location_id":"2","branch_id":"1","company_id":"1","room_key":"111,41200","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"899.00","deposit":"1996.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 12:39:32","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":["C201683","PERSONAL","Mr","Z0dGFq\/EG\/km6sqs3QSNh\/iODya0IJzD0MLHaxTlXlY=","LFQ5CdnIOVZhywg\/cDlL7g==","","tyWXCbGd\/IdUug8XmW9ZWQ==","LIZqzQtH8jDdSLuKFfZtkNNBP7JEgMIVS7jf4SYImtk=","gwaxKVQAnnq+Io8f8qTiA5TE+P+AShf2l5gpd4Q2A+hQDzLNSinVlPpVMw\/sE4bD","So4QXmZG7nVaqL3m5hNxtQ==",null,"LIZqzQtH8jDdSLuKFfZtkNNBP7JEgMIVS7jf4SYImtk=","Bafwkkfk7mvj47ECd4N7Bg==","2","2020-07-23 12:39:30","2","2020-07-23 12:39:30"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 12:39:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2",1683,"NEW","A14-CT208450",998,899,1996,0,"6","6",7120,7390,7120,"2020-07-23 12:39:32","0",null,null,null,"2020-07-25","2021-01-24","6 months contract. special rent now offer 5% off. Storage deposit $500 paid by EPS on Jul 18, 2020. Remaining rental and deposit $6620 paid by EPS on Jul 23, 2020. Smart card provided on the same day.","2020-07-25","12",0,null,270,"270.00","2","2020-07-23 12:39:30","2","2020-07-23 12:39:30","EPS","","","","EPS","","","",null,0,"111,41200","C201683","PERSONAL","Mr","Z0dGFq\/EG\/km6sqs3QSNh\/iODya0IJzD0MLHaxTlXlY=","LFQ5CdnIOVZhywg\/cDlL7g==","","gwaxKVQAnnq+Io8f8qTiA5TE+P+AShf2l5gpd4Q2A+hQDzLNSinVlPpVMw\/sE4bD","tyWXCbGd\/IdUug8XmW9ZWQ==","LIZqzQtH8jDdSLuKFfZtkNNBP7JEgMIVS7jf4SYImtk=","So4QXmZG7nVaqL3m5hNxtQ==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 12:39:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8450","728","998.0","998.00","2","2020-07-23 12:39:30"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 12:39:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-25","2021-01-24","728"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-23 12:39:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["8450","A14-D205560","PAID",1996,0,"2021-01-24","2020-07-23 12:39:30","2020-07-23 12:39:30","2","2020-07-23 12:39:30","2","2020-07-23 12:39:30",1683]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 12:39:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8450",1683,"SETTLED","A14-I208779","2020-07-23 12:39:30","2020-07-25","2","2020-07-23 12:39:30","2","2020-07-23 12:39:30"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 12:39:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8779","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,629,"MO","1",629,"2","2020-07-23 12:39:30","2","2020-07-23 12:39:30"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 12:39:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8779","RENT","\u9810\u7e73\u79df\u91d1",2,899,"MO","1",899,"2","2020-07-23 12:39:30","2","2020-07-23 12:39:30"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 12:39:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8779","RENT","\u9810\u7e73\u79df\u91d1",3,899,"MO","1",899,"2","2020-07-23 12:39:30","2","2020-07-23 12:39:30"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 12:39:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8779","RENT","\u9810\u7e73\u79df\u91d1",4,899,"MO","1",899,"2","2020-07-23 12:39:30","2","2020-07-23 12:39:30"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 12:39:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8779","RENT","\u9810\u7e73\u79df\u91d1",5,899,"MO","1",899,"2","2020-07-23 12:39:30","2","2020-07-23 12:39:30"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 12:39:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8779","RENT","\u9810\u7e73\u79df\u91d1",6,899,"MO","1",899,"2","2020-07-23 12:39:30","2","2020-07-23 12:39:30"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 12:39:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5124,0,"8779"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-07-23 12:39:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1683,"EPS","","","","EPS","","","","PAID","P208422","2020-07-23 12:39:30",7120,"2","2020-07-23 12:39:30","2","2020-07-23 12:39:30","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 12:39:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8422","DEPOSIT","5560","PAID","2020-07-23 12:39:30",1996,"2","2020-07-23 12:39:30","2","2020-07-23 12:39:30"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 12:39:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8422","INVOICE","8779","PAID","2020-07-23 12:39:30",5124,"2","2020-07-23 12:39:30","2","2020-07-23 12:39:30"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 13:41:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 13:47:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 15:20:25","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"313","master_room_id":"6","room_code":"E40"}],"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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tE40 4X3X8 $998.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"K204360(2)","title":"Ms","lastname":"LI","firstname":"Lai Cheong","companyname":"","email":"liloretta123@gmail.com","tel":"68133933","address":"Flat C, 10\/F, Ocean House, Aberdeen, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"469","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"949.00","discount":"4.91","monthly_deduct":49.0018,"room_id":"313","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"313","room_code":"E40","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-07-23","rent_from":"2020-07-23","rent_to":"2020-10-22","delivery_service":"0","remark":"3 months contract. Special offer 50% off for the first 3 months. Storage rental $1497 and deposit $1996 paid by EPS on Jul 23, 2020. Smart card and padlock provided on the same day.","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,26401","order_product":[],"pass":true}},"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-07-23 15:20:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201684","PERSONAL","Ms","szkUMlxVQcVo8f6ACxC3fQ==","hbkan9PC5SCnBxQh2lhA4w==","","pvQScOqQR+oO6maZM5xIkA==","0gvpheiGQhC778516LPicI543ACTPjHyc5jIoruaElA=","UdhYzu\/Ok3xY5fMa1hdaxRKeBCdrazX40sDVNcuiYaZeLVd6uNO0bCbu9jB9Zoek","QUjsNlGeHshgxb8q8G5n4A==",null,"0gvpheiGQhC778516LPicI543ACTPjHyc5jIoruaElA=","hRcCnfp5xepVbW+BOCsvrA==","2","2020-07-23 15:20:25","2","2020-07-23 15:20:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 15:20:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1",1684,"NEW","A12-CT208451",998,998,1996,0,"3","3",3493,4990,3493,"2020-07-23 15:20:27","0",null,null,null,"2020-07-23","2020-10-22","3 months contract. Special offer 50% off for the first 3 months. Storage rental $1497 and deposit $1996 paid by EPS on Jul 23, 2020. Smart card and padlock provided on the same day.","2020-07-23","12",0,null,1497,"1497.00","2","2020-07-23 15:20:25","2","2020-07-23 15:20:25","EPS","","","","EPS","","","",null,0,"190,26401","C201684","PERSONAL","Ms","szkUMlxVQcVo8f6ACxC3fQ==","hbkan9PC5SCnBxQh2lhA4w==","","UdhYzu\/Ok3xY5fMa1hdaxRKeBCdrazX40sDVNcuiYaZeLVd6uNO0bCbu9jB9Zoek","pvQScOqQR+oO6maZM5xIkA==","0gvpheiGQhC778516LPicI543ACTPjHyc5jIoruaElA=","QUjsNlGeHshgxb8q8G5n4A==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 15:20:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["8451","469","6","313","%","4.91",49.0018,"2","2020-07-23 15:20:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 15:20:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8451","313","998.0",949,"2","2020-07-23 15:20:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 15:20:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-23","2020-10-22","313"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-23 15:20:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["8451","A12-D205561","PAID",1996,0,"2020-10-22","2020-07-23 15:20:25","2020-07-23 15:20:25","2","2020-07-23 15:20:25","2","2020-07-23 15:20:25",1684]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 15:20:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8451",1684,"SETTLED","A12-I208780","2020-07-23 15:20:25","2020-07-23","2","2020-07-23 15:20:25","2","2020-07-23 15:20:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 15:20:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8780","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-07-23 15:20:25","2","2020-07-23 15:20:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 15:20:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8780","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,499,"MO","1",499,"2","2020-07-23 15:20:25","2","2020-07-23 15:20:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 15:20:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8780","RENT","\u9810\u7e73\u79df\u91d1",3,998,"MO","1",998,"2","2020-07-23 15:20:25","2","2020-07-23 15:20:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 15:20:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1497,0,"8780"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-07-23 15:20:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1684,"EPS","","","","EPS","","","","PAID","P208423","2020-07-23 15:20:25",3493,"2","2020-07-23 15:20:25","2","2020-07-23 15:20:25","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 15:20:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8423","DEPOSIT","5561","PAID","2020-07-23 15:20:25",1996,"2","2020-07-23 15:20:25","2","2020-07-23 15:20:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 15:20:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8423","INVOICE","8780","PAID","2020-07-23 15:20:25",1497,"2","2020-07-23 15:20:25","2","2020-07-23 15:20:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 16:14:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 17:03:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 17:19:53","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1095&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1165,"customer_code":"C191165","identity_type":"PERSONAL","identity_id":"D488336(6)","title":"Ms","lastname":"CHIU","firstname":"Man Kwan","companyname":"","email":"candichiu@hotmail.com","tel":"96512360","address":"Flat1003, 10\/F, Tai Hang Terrace, 5 Chu Fa RD, Tai Hang, HK","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-07-27","renew_room_key":"189, 63728","renew_remark":"1 month contract. $500 deposit paid by cash. Remaining storage renal and deposit paid by EPS on June 22, 2020. Smartcard and padlock provided on June 22, 2020. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT208201, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1196.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"595","room_code":"M06","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-27","rent_from":"2020-07-27","rent_to":"2020-08-26","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Jul 23, 2020. Storage deposit $1196 transferred from agreement A14-CT208201 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"189, 63728","order_product":[],"pass":true}},"first_order_id":8201,"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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tM06 4X3X4 $598.00 N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 17:19:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",1165,"NEW","A14-CT208452",598,598,0,0,"1","1",598,598,598,"2020-07-23 17:19:53","0",null,null,null,"2020-07-27","2020-08-26","1 month contract. Storage rental paid by bank transfer on Jul 23, 2020. Storage deposit $1196 transferred from agreement A14-CT208201 to this agreement.","2020-07-27","12",0,null,0,"0","2","2020-07-23 17:19:53","2","2020-07-23 17:19:53","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"189, 63728","C191165","PERSONAL","Ms","nc3fEXXJHnulVM\/GUMaHew==","+2U\/KB65ELBPajGnn0cBQw==","","urfXjI4Jimo1Uj91IXd8YLSPFD4+wAYUJfk3OjTs4g80p4DA436fWMJxbleLKDJhblfxiGIMV1pPw+ZwYtQduQ==","OmcRTHhYzrQ1CZc5esvItA==","vueNpHpcFC84z2RjGUE6F+92Jm6vaDCSwqvwsdA1ecg=","fs+3rtDIEM41Zps0NSod4Q==",null,1,8201]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 17:19:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8452","595","598.0","598.00","2","2020-07-23 17:19:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 17:19:53","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-27","2020-08-26","595"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-23 17:19:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8452",1165,"SETTLED","A14-I208781","2020-07-23 17:19:53","2020-07-27","2","2020-07-23 17:19:53","2","2020-07-23 17:19:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 17:19:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8781","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-07-23 17:19:53","2","2020-07-23 17:19:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 17:19:53","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8781"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-07-23 17:19:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1165,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208424","2020-07-23 17:19:53",598,"2","2020-07-23 17:19:53","2","2020-07-23 17:19:53","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 17:19:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8424","DEPOSIT",null,"PAID","2020-07-23 17:19:53",0,"2","2020-07-23 17:19:53","2","2020-07-23 17:19:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 17:19:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8424","INVOICE","8781","PAID","2020-07-23 17:19:53",598,"2","2020-07-23 17:19:53","2","2020-07-23 17:19:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 17:47:01","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 18:38:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 19:03:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 19:14:08","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=INVOICE&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1527,"customer_code":"C201527","identity_type":"PERSONAL","identity_id":"M552436(4)","title":"Mr","lastname":"JONES","firstname":"Dustin","companyname":"","email":"alice@unifiedcommercegroup.com","tel":"91689733","address":"TBC","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"5658.0","renew_rent_month":"2","renew_warehousing_date":"2020-07-28","renew_room_key":"0012488874","renew_remark":"2 months contract. Special offer $5658\/month. Storage rental paid by bank transfer on May 26,2020. Storage deposit $5955 transferred from agreement C15-CT207273 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT207971, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"190","order_discount":[],"order_room":[{"room_id":"1384","room_code":"C15-078","retail_price":"810.0","discounted_price":"810.00","location_id":"6"},{"room_id":"1383","room_code":"C15-077","retail_price":"810.0","discounted_price":"810.00","location_id":"6"},{"room_id":"1382","room_code":"C15-076","retail_price":"810.0","discounted_price":"810.00","location_id":"6"},{"room_id":"1381","room_code":"C15-075","retail_price":"810.0","discounted_price":"810.00","location_id":"6"},{"room_id":"1376","room_code":"C15-070","retail_price":"938.0","discounted_price":"938.00","location_id":"6"},{"room_id":"1375","room_code":"C15-069","retail_price":"938.0","discounted_price":"938.00","location_id":"6"},{"room_id":"1374","room_code":"C15-068","retail_price":"1678.0","discounted_price":"1678.00","location_id":"6"}],"roughly_size":"107.19999999999999","total_retail_price":6794,"total_discounted_price":5955,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":5955,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-28","rent_from":"2020-07-28","rent_to":"2020-08-27","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Jul 23,2020. Storage deposit $5955 transferred from agreement C15-CT207971 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5955,"final_order_total":5955,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012488874","order_product":[],"pass":true}},"first_order_id":"7273","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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tC15-078 4X3X6.5 $810.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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\tC15-077 4X3X6.5 $810.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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\tC15-076 4X3X6.5 $810.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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\tC15-075 4X3X6.5 $810.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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\tC15-070 4X3.7X6.5 $938.00 N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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\tC15-069 4X3.7X6.5 $938.00 N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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\tC15-068 8X3.7X6.5 $1678.00 N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"107.19999999999999","total_discounted_price":"5955.00","deposit":"0.00","total_retail_price":"6794.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 19:14:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1527,"NEW","C15-CT208453",6794,5955,0,0,"1","1",5955,5955,5955,"2020-07-23 19:14:08","0",null,null,null,"2020-07-28","2020-08-27","1 month contract. Storage rental paid by bank transfer on Jul 23,2020. Storage deposit $5955 transferred from agreement C15-CT207971 to this agreement.","2020-07-28","107.19999999999999",0,null,0,"0","2","2020-07-23 19:14:08","2","2020-07-23 19:14:08","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012488874","C201527","PERSONAL","Mr","v2BX+mjdA2aaaXILtDpd2w==","ATQh2m7sYJgeNyjTRRusJQ==","","6F88GPSmmnGXsPk2ZyJKWg==","fuNqlbfJMi6ZKr9QrM5uYg==","KTz\/ce5VPXucGVxvMyRSYZP7MQI0HIXkuvcyqUuYvYE=","cd7wH0Mayh7s5WVPAqrd7Q==",null,1,"7273"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 19:14:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8453","1384","810.0","810.00","2","2020-07-23 19:14:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 19:14:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-28","2020-08-27","1384"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-23 19:14:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8453","1383","810.0","810.00","2","2020-07-23 19:14:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 19:14:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-28","2020-08-27","1383"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-23 19:14:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8453","1382","810.0","810.00","2","2020-07-23 19:14:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 19:14:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-28","2020-08-27","1382"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-23 19:14:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8453","1381","810.0","810.00","2","2020-07-23 19:14:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 19:14:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-28","2020-08-27","1381"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-23 19:14:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8453","1376","938.0","938.00","2","2020-07-23 19:14:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 19:14:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-28","2020-08-27","1376"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-23 19:14:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8453","1375","938.0","938.00","2","2020-07-23 19:14:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 19:14:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-28","2020-08-27","1375"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-23 19:14:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8453","1374","1678.0","1678.00","2","2020-07-23 19:14:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 19:14:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-28","2020-08-27","1374"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-23 19:14:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8453",1527,"SETTLED","C15-I208782","2020-07-23 19:14:08","2020-07-28","2","2020-07-23 19:14:08","2","2020-07-23 19:14:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 19:14:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8782","RENT","\u9810\u7e73\u79df\u91d1",1,5955,"MO","1",5955,"2","2020-07-23 19:14:08","2","2020-07-23 19:14:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 19:14:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5955,0,"8782"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-07-23 19:14:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1527,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208425","2020-07-23 19:14:08",5955,"2","2020-07-23 19:14:08","2","2020-07-23 19:14:08","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 19:14:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8425","DEPOSIT",null,"PAID","2020-07-23 19:14:08",0,"2","2020-07-23 19:14:08","2","2020-07-23 19:14:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-23 19:14:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8425","INVOICE","8782","PAID","2020-07-23 19:14:08",5955,"2","2020-07-23 19:14:08","2","2020-07-23 19:14:08"]},"data_before":[],"data_after":[],"step":1}
*****