\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-090 <\/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-27 14:09:36","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","1601","NEW","C15-CT208230",720,648,720,0,"6","6",4608,4668,4668,"2020-06-27 14:09:36","0",null,null,null,"2020-06-28","2020-12-27","6 months contract. Storage rental and deposit, smart card paid by bank transfer on Jun 01 and June 27, 2020. Smart card mailed out on the same day.","2020-06-28","9",0,null,0,"0","2","2020-06-27 14:09:35","2","2020-06-27 14:09:35","BANKIN","","","","BANKIN","","","",null,0,"'0012522666","C201601","PERSONAL","Ms","yANzfeHOhYehhNPJXy6BjA==","SLPJ+c2smshjwdK17xoj0w==","","lAF0AAJ3AqNty+pBAU7EbCRJzFa1XH9hWRBtQCFFmXpkKJf+0SZspW+TnjfGNiaJ3YaUbYQ22GsAX9HvYjzRTg==","desOfu2ZjBghntFAO8JBUA==","UKfG0XI\/377XXojv28P6q\/xTS84v2kjrtBVip\/w7Mic=","0gjoYj55Iz\/5DK\/YfGu9Fw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:09:36","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":["8230","412 available_room_list_input","159","1396","%","9.90",71.28,"2","2020-06-27 14:09:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:09:36","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":["8230","1601","11","1","60.0",60,"2","2020-06-27 14:09:35","2","2020-06-27 14:09:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:09:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"8230"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-06-27 14:09:36","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":["8230","1396","720.0",648.7,"2","2020-06-27 14:09:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:09:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-28","2020-12-27","1396"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-27 14:09:36","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":["8230","C15-D205505","PAID",720,0,"2020-12-27","2020-06-27 14:09:35","2020-06-27 14:09:35","2","2020-06-27 14:09:35","2","2020-06-27 14:09:35","1601"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:09:36","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":["8230","1601","SETTLED","C15-I208559","2020-06-27 14:09:35","2020-06-28","2","2020-06-27 14:09:35","2","2020-06-27 14:09:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:09:36","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":["8559","RENT","\u9810\u7e73\u79df\u91d1",1,648,"MO","1",648,"2","2020-06-27 14:09:35","2","2020-06-27 14:09:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:09:36","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":["8559","RENT","\u9810\u7e73\u79df\u91d1",2,648,"MO","1",648,"2","2020-06-27 14:09:35","2","2020-06-27 14:09:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:09:36","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":["8559","RENT","\u9810\u7e73\u79df\u91d1",3,648,"MO","1",648,"2","2020-06-27 14:09:35","2","2020-06-27 14:09:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:09:36","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":["8559","RENT","\u9810\u7e73\u79df\u91d1",4,648,"MO","1",648,"2","2020-06-27 14:09:35","2","2020-06-27 14:09:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:09:36","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":["8559","RENT","\u9810\u7e73\u79df\u91d1",5,648,"MO","1",648,"2","2020-06-27 14:09:35","2","2020-06-27 14:09:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:09:36","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":["8559","RENT","\u9810\u7e73\u79df\u91d1",6,648,"MO","1",648,"2","2020-06-27 14:09:35","2","2020-06-27 14:09:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:09:36","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":["8559","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-06-27 14:09:35","2","2020-06-27 14:09:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:09:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3948,0,"8559"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-27 14:09:36","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":["1601","BANKIN","","","","BANKIN","","","","PAID","P208202","2020-06-27 14:09:35",4668,"2","2020-06-27 14:09:35","2","2020-06-27 14:09:35","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:09:36","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":["8202","DEPOSIT","5505","PAID","2020-06-27 14:09:35",720,"2","2020-06-27 14:09:35","2","2020-06-27 14:09:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:09:36","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":["8202","INVOICE","8559","PAID","2020-06-27 14:09:35",3948,"2","2020-06-27 14:09:35","2","2020-06-27 14:09:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:32:06","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":632,"customer_code":"C170632","identity_type":"PERSONAL","identity_id":"D243401(7)","title":"Ms","lastname":"Lee","firstname":"Lai Ming, Alcina","companyname":"","email":"lee_alcina@yahoo.ca","tel":"94671102","address":"Room D, 25\/F, Block 13, South Horizons, Ap Lei Chau, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2730.0","renew_rent_month":"6","renew_warehousing_date":"2020-06-25","renew_room_key":"055,47949","renew_remark":"6 months contract. Storage rental paid by PPS on December 24, 2019. Storage deposit transferred from agreement A18-CT196016 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196794, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"99","order_discount":[{"master_room_discount_id":"276","master_room_id":"99","discount_type":"%","price":"3033.00","disocunted_price":"2882.00","discount":"4.98","monthly_deduct":151.0434,"room_id":"964","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"964","room_code":"W09","retail_price":"3033.0","discounted_price":2882,"location_id":"3"}],"roughly_size":"40","total_retail_price":3033,"total_discounted_price":2881,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":8643,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-25","rent_from":"2020-06-25","rent_to":"2020-09-24","delivery_service":"0","remark":"3 months contract. Storage rental $5292 paid by bank transfer on June 19, 2020. Remaiining balance $3351 paid by PPS on June 24, 2020. Storage deposit transferred from agreement A18-CT196794 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":8643,"final_order_total":8643,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,47949","order_product":[],"pass":true}},"first_order_id":"3999","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> W09 <\/td>\r\n\t\t\t\t\t 5X8X7 <\/td>\r\n\t\t\t\t\t $3033.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"40","total_discounted_price":"2881.00","deposit":"0.00","total_retail_price":"3033.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:32:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",632,"NEW","A18-CT208231",3033,2881,0,0,"3","3",8643,8643,8643,"2020-06-27 14:32:06","0",null,null,null,"2020-06-25","2020-09-24","3 months contract. Storage rental $5292 paid by bank transfer on June 19, 2020. Remaiining balance $3351 paid by PPS on June 24, 2020. Storage deposit transferred from agreement A18-CT196794 to this agreement.\r\n","2020-06-25","40",0,null,0,"0","2","2020-06-27 14:32:06","2","2020-06-27 14:32:06","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,47949","C170632","PERSONAL","Ms","AL5hM952v9ts3ZqZ1sV00o7yYLfw8EQYSercOXeLziQ=","kiriEIqhcx866RNZiMXdKQ==","","QRIVNgDGbansdHxoEiq7OR\/+6zxlIzso2mZ85wNdBCHI0ecqtYFGHWBVImjjdGzl+3IyCdPwVhSQzxv3Pk9eBw==","GJ1swh7VRt2RG2vt+oIoTg==","K0oMvBb4us7oMDY7ABoY88k2Tik+rqx+FB3rDMCIXXs=","vgxCKfEnSpH3xf3slIYzRg==",null,1,"3999"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:32:06","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":["8231","276","99","964","%","4.98",151.0434,"2","2020-06-27 14:32:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:32:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8231","964","3033.0",2882,"2","2020-06-27 14:32:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:32:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-25","2020-09-24","964"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-27 14:32:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8231",632,"SETTLED","A18-I208560","2020-06-27 14:32:06","2020-06-25","2","2020-06-27 14:32:06","2","2020-06-27 14:32:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:32:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8560","RENT","\u9810\u7e73\u79df\u91d1",1,2881,"MO","1",2881,"2","2020-06-27 14:32:06","2","2020-06-27 14:32:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:32:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8560","RENT","\u9810\u7e73\u79df\u91d1",2,2881,"MO","1",2881,"2","2020-06-27 14:32:06","2","2020-06-27 14:32:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:32:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8560","RENT","\u9810\u7e73\u79df\u91d1",3,2881,"MO","1",2881,"2","2020-06-27 14:32:06","2","2020-06-27 14:32:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:32:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8643,0,"8560"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-27 14:32:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[632,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208203","2020-06-27 14:32:06",8643,"2","2020-06-27 14:32:06","2","2020-06-27 14:32:06","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:32:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8203","DEPOSIT",null,"PAID","2020-06-27 14:32:06",0,"2","2020-06-27 14:32:06","2","2020-06-27 14:32:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:32:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8203","INVOICE","8560","PAID","2020-06-27 14:32:06",8643,"2","2020-06-27 14:32:06","2","2020-06-27 14:32:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:36: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":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":874,"customer_code":"C180874","identity_type":"PERSONAL","identity_id":"K451268(5)","title":"Mr","lastname":"Lui","firstname":"Chun Hung","companyname":"","email":"patpat9413888@yahoo.com.hk","tel":"90301273","address":"Room 403, Low Block, Lei Fook House, Apleichau Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-22","renew_room_key":"076,32357","renew_remark":"1 month contract. Storage rental paid by PPS on May 26, 2020. Storage deposit transferred from agreement A12-CT207722 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207979, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"241","room_code":"D45","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-22","rent_from":"2020-06-22","rent_to":"2020-07-21","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on June 24, 2020. Storage deposit transferred from agreement A12-CT207979 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"076,32357","order_product":[],"pass":true}},"first_order_id":"4854","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> D45 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:36: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","1",874,"NEW","A12-CT208232",998,1038,0,0,"1","1",1038,1038,1038,"2020-06-27 14:36:53","0",null,null,null,"2020-06-22","2020-07-21","1 month contract. Storage rental paid by PPS on June 24, 2020. Storage deposit transferred from agreement A12-CT207979 to this agreement.","2020-06-22","12",0,null,0,"0","2","2020-06-27 14:36:53","2","2020-06-27 14:36:53","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"076,32357","C180874","PERSONAL","Mr","8E6nLeLaS+nuXxUNvooxGQ==","vyCKi4IYWx3VnCZylJM1yA==","","t2fcXTNQ5zXw41HK7XLxjgpqs4CAbleDk0AZC75MEKtw5ZsokMMh80cI\/IUaR9tYbJXdnEldy\/dOlMJjVNoCJBK+BLg2Hq37YGStg4SRRpc=","v99UbwvGk\/IX8Amdc7pe+Q==","93qNDvLNra1NfZlAUamtzf14nbvapEp9X2o2aos8F7w=","fzIJnHKlsYW3ETkg3nSzoQ==",null,1,"4854"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:36: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":["8232","241","998.0","998.00","2","2020-06-27 14:36:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:36: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-06-22","2020-07-21","241"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-27 14:36: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":["8232",874,"SETTLED","A12-I208561","2020-06-27 14:36:53","2020-06-22","2","2020-06-27 14:36:53","2","2020-06-27 14:36:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:36: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":["8561","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-06-27 14:36:53","2","2020-06-27 14:36:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:36:53","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"8561"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-27 14:36: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":[874,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208204","2020-06-27 14:36:53",1038,"2","2020-06-27 14:36:53","2","2020-06-27 14:36:53","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:36: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":["8204","DEPOSIT",null,"PAID","2020-06-27 14:36:53",0,"2","2020-06-27 14:36:53","2","2020-06-27 14:36:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:36: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":["8204","INVOICE","8561","PAID","2020-06-27 14:36:53",1038,"2","2020-06-27 14:36:53","2","2020-06-27 14:36:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:42:27","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1209,"customer_code":"C191209","identity_type":"BUSINESS","identity_id":"64526999-000-03-18-5","title":"Mr","lastname":"Leung","firstname":"Ka Lau","companyname":"Best View Medical Development Company","email":null,"tel":"90186205","address":"Unit 1902, Euro Trade Centre, 21-23 Des Voeus, Road, Central, HK","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3659.0","renew_rent_month":"3","renew_warehousing_date":"2020-06-01","renew_room_key":"'0005885043","renew_remark":"3 months contract. Storage rental paid by PPS on March 18, 2020. Storage deposit $7704 transferred from agreement A05-CT196662 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207444, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"117","order_discount":[{"master_room_discount_id":"257","master_room_id":"117","discount_type":"%","price":"1857.00","disocunted_price":"1764.20","discount":"5.00","monthly_deduct":92.85,"room_id":"1138","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"257","master_room_id":"117","discount_type":"%","price":"1857.00","disocunted_price":"1764.20","discount":"5.00","monthly_deduct":92.85,"room_id":"1139","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1139","room_code":"A05-137","retail_price":"1857.0","discounted_price":1764.2,"location_id":"4"},{"room_id":"1138","room_code":"A05-136","retail_price":"1857.0","discounted_price":1764.2,"location_id":"4"}],"roughly_size":"48","total_retail_price":3714,"total_discounted_price":3659,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":10977,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-01","rent_from":"2020-06-01","rent_to":"2020-08-31","delivery_service":"0","remark":"3 months contract. Storage rental $10997 paid by PPS on June 26, 2020. Extra $20 will be transferred to next contract. Storage deposit $7704 transferred from agreement A05-CT207444 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":10977,"final_order_total":10977,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0005885043","order_product":[],"pass":true}},"first_order_id":"4454","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-137 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1857.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> A05-136 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1857.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":"48","total_discounted_price":"3659.0","deposit":"0","total_retail_price":"3714.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:42:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1209,"NEW","A05-CT208233",3714,3659,0,0,"3","3",10977,10977,10977,"2020-06-27 14:42:28","0",null,null,null,"2020-06-01","2020-08-31","3 months contract. Storage rental $10997 paid by PPS on June 26, 2020. Extra $20 will be transferred to next contract. Storage deposit $7704 transferred from agreement A05-CT207444 to this agreement.","2020-06-01","48",0,null,0,"0","2","2020-06-27 14:42:27","2","2020-06-27 14:42:27","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"'0005885043","C191209","BUSINESS","Mr","Ebe2Xk+ChWnDzqCWd6WBrw==","xEf2h2aoyRQ71ZVgBH+9WQ==","Best View Medical Development Company","fZP1EBYNZvAW0ckQSQ+CdZw5ZQNC6hOEs48GPHpGBdC5fkviQ2Xu7h5J6K8vTswvwZ7NYdBXj845+Fyi9MjI566mseupS8qSW\/Bo2+hrIq0=","5ERXd0gNQCH11R5GxrK3jw==",null,null,"Lq0JO0e7hNkl7CgT1wQOOZSm7SXwfr1rJZbv25RiWLU=",1,"4454"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:42:28","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":["8233","257","117","1138","%","5.00",92.85,"2","2020-06-27 14:42:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:42:28","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":["8233","257","117","1139","%","5.00",92.85,"2","2020-06-27 14:42:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:42:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8233","1139","1857.0",1764.2,"2","2020-06-27 14:42:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:42:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-08-31","1139"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-27 14:42:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8233","1138","1857.0",1764.2,"2","2020-06-27 14:42:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:42:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-08-31","1138"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-27 14:42:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8233",1209,"SETTLED","A05-I208562","2020-06-27 14:42:27","2020-06-01","2","2020-06-27 14:42:27","2","2020-06-27 14:42:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:42:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8562","RENT","\u9810\u7e73\u79df\u91d1",1,3659,"MO","1",3659,"2","2020-06-27 14:42:27","2","2020-06-27 14:42:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:42:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8562","RENT","\u9810\u7e73\u79df\u91d1",2,3659,"MO","1",3659,"2","2020-06-27 14:42:27","2","2020-06-27 14:42:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:42:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8562","RENT","\u9810\u7e73\u79df\u91d1",3,3659,"MO","1",3659,"2","2020-06-27 14:42:27","2","2020-06-27 14:42:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:42:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10977,0,"8562"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-27 14:42:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1209,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208205","2020-06-27 14:42:27",10977,"2","2020-06-27 14:42:27","2","2020-06-27 14:42:27","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:42:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8205","DEPOSIT",null,"PAID","2020-06-27 14:42:27",0,"2","2020-06-27 14:42:27","2","2020-06-27 14:42:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 14:42:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8205","INVOICE","8562","PAID","2020-06-27 14:42:27",10977,"2","2020-06-27 14:42:27","2","2020-06-27 14:42:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 15:04:14","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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":658,"customer_code":"C170658","identity_type":"PERSONAL","identity_id":"C360042(2)","title":"Mr","lastname":"Ho","firstname":"Wing Fai","companyname":"","email":"hwf_168168@y7mail.com","tel":"93173067","address":"7D, Block 12, South Horizons, Ap Lei Chau","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1445.0","renew_rent_month":"6","renew_warehousing_date":"2020-06-28","renew_room_key":"055, 27208","renew_remark":"6 months contract. Storage rental paid by PPS on December 24, 2019. Storage deposit transferred from agreement A18-CT195379 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196793, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"78","order_discount":[{"master_room_discount_id":"254","master_room_id":"78","discount_type":"%","price":"1605.00","disocunted_price":"1444.50","discount":"10.00","monthly_deduct":160.5,"room_id":"969","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"969","room_code":"W14","retail_price":"1605.0","discounted_price":1444.5,"location_id":"3"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1445,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":8670,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-28","rent_from":"2020-06-28","rent_to":"2020-12-27","delivery_service":"0","remark":"6 months contract. Storage rental paid by PPS on June 26, 2020. Storage deposit transferred from agreement A18-CT196793 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":8670,"final_order_total":8670,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055, 27208","order_product":[],"pass":true}},"first_order_id":"3919","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> W14 <\/td>\r\n\t\t\t\t\t 4X5X7 <\/td>\r\n\t\t\t\t\t $1605.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1445.0","deposit":"0","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 15:04: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","3",658,"NEW","A18-CT208234",1605,1445,0,0,"6","6",8670,8670,8670,"2020-06-27 15:04:15","0",null,null,null,"2020-06-28","2020-12-27","6 months contract. Storage rental paid by PPS on June 26, 2020. Storage deposit transferred from agreement A18-CT196793 to this agreement.\r\n","2020-06-28","20",0,null,0,"0","2","2020-06-27 15:04:14","2","2020-06-27 15:04:14","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055, 27208","C170658","PERSONAL","Mr","exXj8iOIk7ZPPCdtuXrDKw==","D\/skxQ5s\/L5yyRWaDK\/iSg==","","BrnQdhUG5+A5mci6IM4XyX4zTASBl9aVj2x4HjeOgKnB6X\/9TWIuWc6g+W5UG7v3","AHutFB+W4vjin3IcJMhKUw==","DEoCeJnLhiawgLc9gV5SNkZux2f9\/C2R50Fde5+OTGM=","V3b8pyJ6S49Yk8OkPrwWVA==",null,1,"3919"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 15:04:15","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":["8234","254","78","969","%","10.00",160.5,"2","2020-06-27 15:04:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 15:04: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":["8234","969","1605.0",1444.5,"2","2020-06-27 15:04:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 15:04: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-06-28","2020-12-27","969"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-27 15:04: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":["8234",658,"SETTLED","A18-I208563","2020-06-27 15:04:14","2020-06-28","2","2020-06-27 15:04:14","2","2020-06-27 15:04:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 15:04: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":["8563","RENT","\u9810\u7e73\u79df\u91d1",1,1445,"MO","1",1445,"2","2020-06-27 15:04:14","2","2020-06-27 15:04:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 15:04: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":["8563","RENT","\u9810\u7e73\u79df\u91d1",2,1445,"MO","1",1445,"2","2020-06-27 15:04:14","2","2020-06-27 15:04:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 15:04: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":["8563","RENT","\u9810\u7e73\u79df\u91d1",3,1445,"MO","1",1445,"2","2020-06-27 15:04:14","2","2020-06-27 15:04:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 15:04: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":["8563","RENT","\u9810\u7e73\u79df\u91d1",4,1445,"MO","1",1445,"2","2020-06-27 15:04:14","2","2020-06-27 15:04:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 15:04: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":["8563","RENT","\u9810\u7e73\u79df\u91d1",5,1445,"MO","1",1445,"2","2020-06-27 15:04:14","2","2020-06-27 15:04:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 15:04: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":["8563","RENT","\u9810\u7e73\u79df\u91d1",6,1445,"MO","1",1445,"2","2020-06-27 15:04:14","2","2020-06-27 15:04:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 15:04:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8670,0,"8563"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-27 15:04: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":[658,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208206","2020-06-27 15:04:14",8670,"2","2020-06-27 15:04:14","2","2020-06-27 15:04:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 15:04: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":["8206","DEPOSIT",null,"PAID","2020-06-27 15:04:14",0,"2","2020-06-27 15:04:14","2","2020-06-27 15:04:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 15:04: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":["8206","INVOICE","8563","PAID","2020-06-27 15:04:14",8670,"2","2020-06-27 15:04:14","2","2020-06-27 15:04:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 15:28:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 15:30:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 15:30:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 15:41:11","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","'0012522666","6 months contract. Storage rental and deposit, smart card paid by bank transfer on Jun 01,2020. Smart card mailed out on the same day.","2020-06-27 15:41:11","2","SLPJ+c2smshjwdK17xoj0w==","yANzfeHOhYehhNPJXy6BjA==","UKfG0XI\/377XXojv28P6q\/xTS84v2kjrtBVip\/w7Mic=","desOfu2ZjBghntFAO8JBUA==","lAF0AAJ3AqNty+pBAU7EbCRJzFa1XH9hWRBtQCFFmXpkKJf+0SZspW+TnjfGNiaJ3YaUbYQ22GsAX9HvYjzRTg==",8008]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-27 16:00:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****