{"created_at":"2020-06-20 10:10:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 10:51:41","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&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1576","master_room_id":"213","room_code":"A16-085"},{"room_id":"1582","master_room_id":"213","room_code":"A16-091"},{"room_id":"1577","master_room_id":"204","room_code":"A16-086"},{"room_id":"1583","master_room_id":"204","room_code":"A16-092"}],"renew":1,"warehousing":{"1":{"new_customer":"1","customer_id":1277,"customer_code":"C191277","identity_type":"PERSONAL","identity_id":"D452156(1)","title":"Ms","lastname":"Lam","firstname":"Yin Fun","companyname":"","email":"estherlam1@hotmail.com","tel":"90497006","address":"6\/F, Yue On Buliding, 2A O' Brien Road, Wan Chai, H.K","pass":true,"customer_first_order":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1589.0","renew_rent_month":"13","renew_warehousing_date":"2020-07-01","renew_room_key":"0012388447","renew_remark":"13 months contract. Special "Rent Now" 5% off and one month free. Storage rental $19068 paid by cash on May 25, 2019. Storage deposit $3714 will be paid by cash on or before June 1, 2019. Smartcard provided on May 25, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT195074, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $3714.0","renew_master_room_id":"117","order_discount":[],"order_room":[{"room_id":"1576","room_code":"A16-085","retail_price":"1930.0","discounted_price":"1930.00","location_id":"7"},{"room_id":"1582","room_code":"A16-091","retail_price":"1930.0","discounted_price":"1930.00","location_id":"7"},{"room_id":"1577","room_code":"A16-086","retail_price":"1605.0","discounted_price":"1605.00","location_id":"7"},{"room_id":"1583","room_code":"A16-092","retail_price":"1605.0","discounted_price":"1605.00","location_id":"7"}],"roughly_size":"100","total_retail_price":7070,"total_discounted_price":7264,"deposit":14528,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":25424,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"10896.00","warehousing_date":"2020-07-15","rent_from":"2020-07-15","rent_to":"2020-10-14","delivery_service":"0","remark":"3 months contract. Special offer 50% off for first 3 months. Storage rental and deposit paid by cheque on JUNE 20,2020. Smart Card provided on JUNE 20,2020.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":10896,"order_total":36320,"final_order_total":25424,"location_id":"7","branch_id":"1","company_id":"1","room_key":"'189,51979","order_product":[],"pass":true}},"first_order_id":5074,"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t

---

\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\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>
A16-085 <\/td>\r\n\t\t\t\t\t	5X5X7 <\/td>\r\n\t\t\t\t\t	$1930.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>
A16-091 <\/td>\r\n\t\t\t\t\t	5X5X7 <\/td>\r\n\t\t\t\t\t	$1930.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>
A16-086 <\/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>	<\/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>
A16-092 <\/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>	<\/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":"100","total_discounted_price":"7264.00","deposit":"14528.00","total_retail_price":"7070.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 10:51:43","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":["C201636","PERSONAL","Ms","jrhWKhgxGbhtAD9Q86MyUw==","0JxYUqbNPOvgfMwVa0l0NA==","","Uf3iEP+cbtsryaPual06YQ==","LqRvvUIng2ITmQDDd6tQ\/vLWg5+3MEU44FbG89hO+5Y=","i7vT8HAvMPa0ZwNtySKqnTAnixDYIsaA15feTT5iLU\/6pgMB0Etm49EiNMcu7PsJiKoXwORfsm55cxc3u99d6w==","ZTPR1AvRwWfuDTIzMxAOMA==",null,"LqRvvUIng2ITmQDDd6tQ\/vLWg5+3MEU44FbG89hO+5Y=","D7N2WvT5P9mG8ByiaHGhGw==","2","2020-06-20 10:51:41","2","2020-06-20 10:51:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 10:51:43","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","7",1636,"NEW","A16-CT208188",7070,7264,14528,0,"3","3",25424,36320,25424,"2020-06-20 10:51:43","0",null,null,null,"2020-07-15","2020-10-14","3 months contract. Special offer 50% off for first 3 months. Storage rental and deposit paid by cheque on JUNE 20,2020. Smart Card provided on JUNE 20,2020.","2020-07-15","100",0,null,10896,"10896.00","2","2020-06-20 10:51:41","2","2020-06-20 10:51:41","CHEQUE","","","","CHEQUE","","","",null,0,"'189,51979","C201636","PERSONAL","Ms","jrhWKhgxGbhtAD9Q86MyUw==","0JxYUqbNPOvgfMwVa0l0NA==","","i7vT8HAvMPa0ZwNtySKqnTAnixDYIsaA15feTT5iLU\/6pgMB0Etm49EiNMcu7PsJiKoXwORfsm55cxc3u99d6w==","Uf3iEP+cbtsryaPual06YQ==","LqRvvUIng2ITmQDDd6tQ\/vLWg5+3MEU44FbG89hO+5Y=","ZTPR1AvRwWfuDTIzMxAOMA==",null,1,5074]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 10:51:43","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":["8188","1576","1930.0","1930.00","2","2020-06-20 10:51:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 10:51:43","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-15","2020-10-14","1576"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-20 10:51:43","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":["8188","1582","1930.0","1930.00","2","2020-06-20 10:51:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 10:51:43","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-15","2020-10-14","1582"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-20 10:51:43","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":["8188","1577","1605.0","1605.00","2","2020-06-20 10:51:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 10:51:43","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-15","2020-10-14","1577"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-20 10:51:43","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":["8188","1583","1605.0","1605.00","2","2020-06-20 10:51:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 10:51:43","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-15","2020-10-14","1583"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-20 10:51:43","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":["8188","A16-D205488","PAID",14528,0,"2020-10-14","2020-06-20 10:51:41","2020-06-20 10:51:41","2","2020-06-20 10:51:41","2","2020-06-20 10:51:41",1636]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 10:51:43","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":["8188",1636,"SETTLED","A16-I208517","2020-06-20 10:51:41","2020-07-15","2","2020-06-20 10:51:41","2","2020-06-20 10:51:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 10:51:43","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":["8517","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-20 10:51:41","2","2020-06-20 10:51:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 10:51:43","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":["8517","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,3632,"MO","1",3632,"2","2020-06-20 10:51:41","2","2020-06-20 10:51:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 10:51:43","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":["8517","RENT","\u9810\u7e73\u79df\u91d1",3,7264,"MO","1",7264,"2","2020-06-20 10:51:41","2","2020-06-20 10:51:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 10:51:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10896,0,"8517"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-20 10:51:43","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":[1636,"CHEQUE","","","","CHEQUE","","","","PAID","P208160","2020-06-20 10:51:41",25424,"2","2020-06-20 10:51:41","2","2020-06-20 10:51:41","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 10:51:43","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":["8160","DEPOSIT","5488","PAID","2020-06-20 10:51:41",14528,"2","2020-06-20 10:51:41","2","2020-06-20 10:51:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 10:51:43","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":["8160","INVOICE","8517","PAID","2020-06-20 10:51:41",10896,"2","2020-06-20 10:51:41","2","2020-06-20 10:51:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 12:12:43","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","191,03248","13 months contract. Special offer renewal price list 50% off for the first 3 months and the 13th month free. Deposit $500 paid by PayMe on June 09,2020. The balance of storage rental and deposit $11548 paid by cash on 11JUNE2020. Smart card will provide later. Padlock provided on 11JUNE2020.","2020-06-20 12:12:43","2","iAKb9Y+6DFOZKg+8+iuRrA==","tnBXsw2iRVZmC7agW3nxRw==","f0RgO2mVVUDM\/nLFDmD8xA==","WAeDQGyJs5GONb+7AH7S3+poCGWF1+fb+lVhrBHyBjm+j6zrUiqt3Wr6M+U+ocXuHAokHb5SnGVVm7hU6w8HTw==",8106]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 12:14:16","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","191,03248","13 months contract. Special offer renewal price list 50% off for the first 3 months and the 13th month free. Deposit $500 paid by PayMe on June 09,2020. The balance of storage rental and deposit $11548 paid by cash on 11JUNE2020. Smart card will provide later. Padlock provided on 11JUNE2020.","2020-06-20 12:14:16","2","iAKb9Y+6DFOZKg+8+iuRrA==","tnBXsw2iRVZmC7agW3nxRw==","f0RgO2mVVUDM\/nLFDmD8xA==","WAeDQGyJs5GONb+7AH7S389l4t3nQQAFJhSqtMlAokLkA1xUmzwWL8iGIgTylkbpu5+sxqehDBmtQ82GdRXG0A==",8106]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 12:57:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 13:08:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 13:08:48","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 13:35:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 13:38: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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1355,"customer_code":"C191355","identity_type":"PERSONAL","identity_id":"D260822(8)","title":"Mr","lastname":"Lau","firstname":"Ka Ho David","companyname":"","email":"lkhdavid@yahoo.com.hk","tel":"92023125","address":"5\/F, Harrow Mansion, 170-172 Aberdeen Main Rd, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2188.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-04","renew_room_key":"076,48044","renew_remark":"2 months contract. Storage rental $2188\/month. Storage rental paid by bank transfer on May 22, 2020. Storage deposit $4376 transferred from agreement A12-CT207541 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207927, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"4","order_discount":[],"order_room":[{"room_id":"297","room_code":"E24","retail_price":"1138.0","discounted_price":"946.00","location_id":"1"},{"room_id":"308","room_code":"E35","retail_price":"1138.0","discounted_price":"946.00","location_id":"1"}],"roughly_size":"30","total_retail_price":2276,"total_discounted_price":2188,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2188,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-04","rent_from":"2020-05-04","rent_to":"2020-06-03","delivery_service":"0","remark":"1 months contract. Storage rental $2188\/month. Storage rental paid by bank transfer on JUNE 20, 2020. Storage deposit $4376 transferred from agreement A12-CT207927 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2188,"final_order_total":2188,"location_id":"1","branch_id":"1","company_id":"1","room_key":"076,48044","order_product":[],"pass":true}},"first_order_id":"5625","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> E24 <\/td>\r\n\t\t\t\t\t 3X5X8 <\/td>\r\n\t\t\t\t\t $1138.00 <\/td>\r\n\t\t\t\t $946.0 <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> E35 <\/td>\r\n\t\t\t\t\t 3X5X8 <\/td>\r\n\t\t\t\t\t $1138.00 <\/td>\r\n\t\t\t\t $946.0 <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"30","total_discounted_price":"2188.0","deposit":"0","total_retail_price":"2276.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 13:38:07","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",1355,"NEW","A12-CT208189",2276,2188,0,0,"1","1",2188,2188,2188,"2020-06-20 13:38:07","0",null,null,null,"2020-05-04","2020-06-03","1 months contract. Storage rental $2188\/month. Storage rental paid by bank transfer on JUNE 20, 2020. Storage deposit $4376 transferred from agreement A12-CT207927 to this agreement.","2020-05-04","30",0,null,0,"0","2","2020-06-20 13:38:06","2","2020-06-20 13:38:06","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,48044","C191355","PERSONAL","Mr","byNdTNcCLo6aLQN435WZZQ==","oe4emdjBwqJ3qUpOcI17hw==","","mLjIS1gL5SfHxNCxPFPye21mGzNX+ITzU4qVF+K6L0jbVek9r3oaeRQYRWuk5L45CjWLjqP\/\/6VUESa\/Ue5xcw==","LjaeJ3csMFHue8wAtOK+sQ==","HYtOeAa2oajm09cLWUO73jrw++DhYubmcByxwcfKdrU=","ks+B19crkUr8NVNksxwxyg==",null,1,"5625"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 13:38:07","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":["8189","297","1138.0","946.00","2","2020-06-20 13:38:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 13:38:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-04","2020-06-03","297"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-20 13:38:07","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":["8189","308","1138.0","946.00","2","2020-06-20 13:38:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 13:38:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-04","2020-06-03","308"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-20 13:38:07","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":["8189",1355,"SETTLED","A12-I208518","2020-06-20 13:38:06","2020-05-04","2","2020-06-20 13:38:06","2","2020-06-20 13:38:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 13:38:07","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":["8518","RENT","\u9810\u7e73\u79df\u91d1",1,2188,"MO","1",2188,"2","2020-06-20 13:38:06","2","2020-06-20 13:38:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 13:38:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2188,0,"8518"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-20 13:38:07","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":[1355,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208161","2020-06-20 13:38:06",2188,"2","2020-06-20 13:38:06","2","2020-06-20 13:38:06","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 13:38:07","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":["8161","DEPOSIT",null,"PAID","2020-06-20 13:38:06",0,"2","2020-06-20 13:38:06","2","2020-06-20 13:38:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 13:38:07","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":["8161","INVOICE","8518","PAID","2020-06-20 13:38:06",2188,"2","2020-06-20 13:38:06","2","2020-06-20 13:38:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 13:54:34","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":798,"customer_code":"C180798","identity_type":"PERSONAL","identity_id":"Z916749(9)","title":"Mr","lastname":"Lo","firstname":"Ka Chun","companyname":"","email":"loka0039@gmai.com","tel":"96670730","address":"Flat 3107, 31\/F, Tin Chak House, Tin Wan Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"2","renew_warehousing_date":"2020-06-21","renew_room_key":"055,32980","renew_remark":"2 month contract. Storage rental paid by bank transfer on April 21 and May 21, 2020. Storage deposit transferred from agreement A12-CT207454 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207912, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"279","room_code":"E06","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-21","rent_from":"2020-06-21","rent_to":"2020-07-20","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on JUNE 20, 2020. Storage deposit transferred from agreement A12-CT207912 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,32980","order_product":[],"pass":true}},"first_order_id":"4789","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> E06 <\/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.00","deposit":"00.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 13:54:34","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",798,"NEW","A12-CT208190",998,1038,0,0,"1","1",1038,1038,1038,"2020-06-20 13:54:34","0",null,null,null,"2020-06-21","2020-07-20","1 month contract. Storage rental paid by bank transfer on JUNE 20, 2020. Storage deposit transferred from agreement A12-CT207912 to this agreement.","2020-06-21","12",0,null,0,"0","2","2020-06-20 13:54:34","2","2020-06-20 13:54:34","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,32980","C180798","PERSONAL","Mr","51MA8AWBJt370WUqsUeCnw==","4w4biS+jM\/Q3DAzxHdf3pA==","","mMzQ1c7IXnG31el3pMn+cAlVmwOEO8RAHQZJFRSLNV\/SmYFvT5hQ\/KG4Is71QjPxXCoAkN9ubgFw5NXyRPui2oMB3Uo2T5sIHAA\/TnArqac=","iu3rJGYyixnPHEo1U9vPkA==","vSxCV4H9VfvlX9eKdpf+03ZOzigLaCc\/nH8UtdLNTfM=","L8wtX\/W+agotXtDfSAWTVA==",null,1,"4789"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 13:54:34","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":["8190","279","998.0","998.00","2","2020-06-20 13:54:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 13:54:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-21","2020-07-20","279"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-20 13:54:34","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":["8190",798,"SETTLED","A12-I208519","2020-06-20 13:54:34","2020-06-21","2","2020-06-20 13:54:34","2","2020-06-20 13:54:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 13:54:34","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":["8519","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-06-20 13:54:34","2","2020-06-20 13:54:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 13:54:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"8519"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-20 13:54:34","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":[798,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208162","2020-06-20 13:54:34",1038,"2","2020-06-20 13:54:34","2","2020-06-20 13:54:34","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 13:54:34","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":["8162","DEPOSIT",null,"PAID","2020-06-20 13:54:34",0,"2","2020-06-20 13:54:34","2","2020-06-20 13:54:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 13:54:34","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":["8162","INVOICE","8519","PAID","2020-06-20 13:54:34",1038,"2","2020-06-20 13:54:34","2","2020-06-20 13:54:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-20 16:34:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****