\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>
A05-148 <\/td>\n\t\t\t\t\t	4X4X7 <\/td>\n\t\t\t\t\t	$1290.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":"16","total_discounted_price":"1162.00","deposit":"2580.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 14:18:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","4","1308","NEW","A05-CT208128",1290,1162,2580,0,"13","13",15828,17686,15828,"2020-06-13 14:18:56","0",null,null,null,"2020-06-13","2021-07-12","13 months contract. Special offer the 13th month free and 5% discount for the first contract. Storage rental and deposit paid by cheque on June 13,2020. Smart card provided on the same day.","2020-06-13","16",0,null,1858,"1858.00","2","2020-06-13 14:18:56","2","2020-06-13 14:18:56","CHEQUE","","","","CHEQUE","","","",null,0,"191,03256","C191308","BUSINESS","Mr","gB3lOIKGw08oQZ3wGQ6W1A==","geOxdqMjY4EfViko4YZGSQ==","Benefit Fortune Limited","bu5tPuWOtnuHBmJkBeldAiY5OL\/nT2BlZ8u1nYt2JMnH1SMUdR\/0Mx1Qpr2nD0+l+5rTFBx\/Z9SJZFFNFsTHWA==","1Ir0VMLoNN3NtWwigkp49A==",null,null,"ECATmg8MPbMczZf2LJGyOw=="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 14:18:56","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":["8128","1150","1290.0","1290.00","2","2020-06-13 14:18:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 14:18:56","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-13","2021-07-12","1150"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-13 14:18:56","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":["8128","A05-D205470","PAID",2580,0,"2021-07-12","2020-06-13 14:18:56","2020-06-13 14:18:56","2","2020-06-13 14:18:56","2","2020-06-13 14:18:56","1308"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 14:18:56","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":["8128","1308","SETTLED","A05-I208457","2020-06-13 14:18:56","2020-06-13","2","2020-06-13 14:18:56","2","2020-06-13 14:18:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 14:18:56","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":["8457","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-13 14:18:56","2","2020-06-13 14:18:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 14:18:56","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":["8457","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,466,"MO","1",466,"2","2020-06-13 14:18:56","2","2020-06-13 14:18:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 14:18:56","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":["8457","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-06-13 14:18:56","2","2020-06-13 14:18:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 14:18:56","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":["8457","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-06-13 14:18:56","2","2020-06-13 14:18:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 14:18:56","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":["8457","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-06-13 14:18:56","2","2020-06-13 14:18:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 14:18:56","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":["8457","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-06-13 14:18:56","2","2020-06-13 14:18:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 14:18:56","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":["8457","RENT","\u9810\u7e73\u79df\u91d1",7,1162,"MO","1",1162,"2","2020-06-13 14:18:56","2","2020-06-13 14:18:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 14:18:56","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":["8457","RENT","\u9810\u7e73\u79df\u91d1",8,1162,"MO","1",1162,"2","2020-06-13 14:18:56","2","2020-06-13 14:18:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 14:18:56","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":["8457","RENT","\u9810\u7e73\u79df\u91d1",9,1162,"MO","1",1162,"2","2020-06-13 14:18:56","2","2020-06-13 14:18:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 14:18:56","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":["8457","RENT","\u9810\u7e73\u79df\u91d1",10,1162,"MO","1",1162,"2","2020-06-13 14:18:56","2","2020-06-13 14:18:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 14:18:56","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":["8457","RENT","\u9810\u7e73\u79df\u91d1",11,1162,"MO","1",1162,"2","2020-06-13 14:18:56","2","2020-06-13 14:18:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 14:18:56","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":["8457","RENT","\u9810\u7e73\u79df\u91d1",12,1162,"MO","1",1162,"2","2020-06-13 14:18:56","2","2020-06-13 14:18:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 14:18:56","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":["8457","RENT","\u9810\u7e73\u79df\u91d1",13,1162,"MO","1",1162,"2","2020-06-13 14:18:56","2","2020-06-13 14:18:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 14:18:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13248,0,"8457"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-13 14:18:56","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":["1308","CHEQUE","","","","CHEQUE","","","","PAID","P208100","2020-06-13 14:18:56",15828,"2","2020-06-13 14:18:56","2","2020-06-13 14:18:56","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 14:18:56","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":["8100","DEPOSIT","5470","PAID","2020-06-13 14:18:56",2580,"2","2020-06-13 14:18:56","2","2020-06-13 14:18:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 14:18:56","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":["8100","INVOICE","8457","PAID","2020-06-13 14:18:56",13248,"2","2020-06-13 14:18:56","2","2020-06-13 14:18:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 14:29:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 14:35:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 14:35:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 14:46:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:21: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&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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":927,"customer_code":"C180927","identity_type":"PERSONAL","identity_id":"D666143(3)","title":"Ms","lastname":"Wong","firstname":"Suk Fong","companyname":"","email":null,"tel":"91683606","address":"Room 1301, Lei Tin House, Ap Lei Chau Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2455.0","renew_rent_month":"13","renew_warehousing_date":"2020-06-24","renew_room_key":"0012473904","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by EPS on May 18, 2019. Storage deposit $5456 transferred from agreement A05-CT183645 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT195002, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"128","order_discount":[],"order_room":[{"room_id":"1177","room_code":"A05-175","retail_price":"2728.0","discounted_price":"2728.00","location_id":"4"}],"roughly_size":"36","total_retail_price":2728,"total_discounted_price":2455,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":29460,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2455.00","warehousing_date":"2020-06-24","rent_from":"2020-06-24","rent_to":"2021-07-23","delivery_service":"0","remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by EPS on June 13, 2020. Storage deposit $5456 transferred from agreement A05-CT195002 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":2455,"order_total":31915,"final_order_total":29460,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012473904","order_product":[],"pass":true}},"first_order_id":"3645","selected_room_tr":"	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-175 <\/td>\r\n\t\t\t\t\t 6X6X7 <\/td>\r\n\t\t\t\t\t $2728.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"36","total_discounted_price":"2455.0","deposit":"0","total_retail_price":"2728.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:21: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","4",927,"NEW","A05-CT208129",2728,2455,0,0,"13","13",29460,31915,29460,"2020-06-13 15:21:07","0",null,null,null,"2020-06-24","2021-07-23","13 months contract. Special renewal offer, one month free. Storage rental paid by EPS on June 13, 2020. Storage deposit $5456 transferred from agreement A05-CT195002 to this agreement.\r\n","2020-06-24","36",0,null,2455,"2455.00","2","2020-06-13 15:21:06","2","2020-06-13 15:21:06","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"0012473904","C180927","PERSONAL","Ms","RuVfL5bwQLIgNmfuYGybyg==","hULSwM2MvFtpeV9\/z+er8Q==","","\/noqmiuDb\/hjRj1eYE4trVPZoOKjXdyhUSrUupwZKPza\/7s6H3GlvFNpxvpKT21fWPgIReSQG38AX8dmimU1wRCbwWnBj1I1k3J0SVXXVTE=","p59Q2E6nuIjMUPe0+p7LLw==",null,"L53wlyOpMEKhaIG7t3tP+A==",null,1,"3645"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:21: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":["8129","1177","2728.0","2728.00","2","2020-06-13 15:21:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:21: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-06-24","2021-07-23","1177"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-13 15:21: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":["8129",927,"SETTLED","A05-I208458","2020-06-13 15:21:06","2020-06-24","2","2020-06-13 15:21:06","2","2020-06-13 15:21:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:21: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":["8458","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,2455,"MO","1",2455,"2","2020-06-13 15:21:06","2","2020-06-13 15:21:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:21: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":["8458","RENT","\u9810\u7e73\u79df\u91d1",3,2455,"MO","1",2455,"2","2020-06-13 15:21:06","2","2020-06-13 15:21:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:21: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":["8458","RENT","\u9810\u7e73\u79df\u91d1",4,2455,"MO","1",2455,"2","2020-06-13 15:21:06","2","2020-06-13 15:21:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:21: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":["8458","RENT","\u9810\u7e73\u79df\u91d1",5,2455,"MO","1",2455,"2","2020-06-13 15:21:06","2","2020-06-13 15:21:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:21: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":["8458","RENT","\u9810\u7e73\u79df\u91d1",6,2455,"MO","1",2455,"2","2020-06-13 15:21:06","2","2020-06-13 15:21:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:21: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":["8458","RENT","\u9810\u7e73\u79df\u91d1",7,2455,"MO","1",2455,"2","2020-06-13 15:21:06","2","2020-06-13 15:21:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:21: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":["8458","RENT","\u9810\u7e73\u79df\u91d1",8,2455,"MO","1",2455,"2","2020-06-13 15:21:06","2","2020-06-13 15:21:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:21: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":["8458","RENT","\u9810\u7e73\u79df\u91d1",9,2455,"MO","1",2455,"2","2020-06-13 15:21:06","2","2020-06-13 15:21:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:21: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":["8458","RENT","\u9810\u7e73\u79df\u91d1",10,2455,"MO","1",2455,"2","2020-06-13 15:21:06","2","2020-06-13 15:21:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:21: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":["8458","RENT","\u9810\u7e73\u79df\u91d1",11,2455,"MO","1",2455,"2","2020-06-13 15:21:06","2","2020-06-13 15:21:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:21: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":["8458","RENT","\u9810\u7e73\u79df\u91d1",12,2455,"MO","1",2455,"2","2020-06-13 15:21:06","2","2020-06-13 15:21:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:21: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":["8458","RENT","\u9810\u7e73\u79df\u91d1",13,2455,"MO","1",2455,"2","2020-06-13 15:21:06","2","2020-06-13 15:21:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:21:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[29460,0,"8458"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-13 15:21: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":[927,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P208101","2020-06-13 15:21:06",29460,"2","2020-06-13 15:21:06","2","2020-06-13 15:21:06","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:21: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":["8101","DEPOSIT",null,"PAID","2020-06-13 15:21:06",0,"2","2020-06-13 15:21:06","2","2020-06-13 15:21:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:21: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":["8101","INVOICE","8458","PAID","2020-06-13 15:21:06",29460,"2","2020-06-13 15:21:06","2","2020-06-13 15:21:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:26:20","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","0012473904, 0012398389","13 months contract. Special renewal offer, one month free. Storage rental paid by EPS on June 13, 2020. Storage deposit $5456 transferred from agreement A05-CT195002 to this agreement.\r\n","2020-06-13 15:26:20","2","hULSwM2MvFtpeV9\/z+er8Q==","RuVfL5bwQLIgNmfuYGybyg==","p59Q2E6nuIjMUPe0+p7LLw==","\/noqmiuDb\/hjRj1eYE4trVPZoOKjXdyhUSrUupwZKPza\/7s6H3GlvFNpxvpKT21fWPgIReSQG38AX8dmimU1wRCbwWnBj1I1k3J0SVXXVTE=",8129]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:30:55","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1407,"customer_code":"C191407","identity_type":"PERSONAL","identity_id":"K832783(1)","title":"Mr","lastname":"MAK","firstname":"Kwok Kin","companyname":"","email":"kinmak78@gmail.com","tel":"61086045","address":"Room 1502, Tung Cheong House, Lei Tung Estate","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1226.0","renew_rent_month":"3","renew_warehousing_date":"2020-06-28","renew_room_key":"190,36626","renew_remark":"3 months contract. Storage rental paid by cash on Mar 21,2020. Storage rental $2580 transferred from agreement A16-CT196695 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT207468, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"202","order_discount":[],"order_room":[{"room_id":"1675","room_code":"A16-184","retail_price":"1290.0","discounted_price":"1290.00","location_id":"7"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1226,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3678,"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-09-27","delivery_service":"0","remark":"3 months contract. Storage rental paid by cash on June 13, 2020. Storage rental $2580 transferred from agreement A16-CT207468 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":3678,"final_order_total":3678,"location_id":"7","branch_id":"1","company_id":"1","room_key":"190,36626","order_product":[],"pass":true}},"first_order_id":"4790","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> A16-184 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.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":"16","total_discounted_price":"1226.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:30:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","7",1407,"NEW","A16-CT208130",1290,1226,0,0,"3","3",3678,3678,3678,"2020-06-13 15:30:55","0",null,null,null,"2020-06-28","2020-09-27","3 months contract. Storage rental paid by cash on June 13, 2020. Storage rental $2580 transferred from agreement A16-CT207468 to this agreement.\r\n","2020-06-28","16",0,null,0,"0","2","2020-06-13 15:30:55","2","2020-06-13 15:30:55","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"190,36626","C191407","PERSONAL","Mr","xtUUq7hHomPSgb0b1ApOww==","22KPgW1C3CU66tb5kESLdQ==","","0rjSs8WGoS7vuxPMpCuEyBBtI4hm53pl17OGNH+6SjGZTuBNXmUvO\/uZVcRLEom0","bBagOZVlfi7Vx5iHJfXB6Q==","kI2TPQxBZH97bJ7jJa5AnUEPA9betkNktVAFnwKYqoE=","mWsM69a\/kcUwVU02RZTj+Q==",null,1,"4790"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:30:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8130","1675","1290.0","1290.00","2","2020-06-13 15:30:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:30:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-28","2020-09-27","1675"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-13 15:30:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8130",1407,"SETTLED","A16-I208459","2020-06-13 15:30:55","2020-06-28","2","2020-06-13 15:30:55","2","2020-06-13 15:30:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:30:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8459","RENT","\u9810\u7e73\u79df\u91d1",1,1226,"MO","1",1226,"2","2020-06-13 15:30:55","2","2020-06-13 15:30:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:30:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8459","RENT","\u9810\u7e73\u79df\u91d1",2,1226,"MO","1",1226,"2","2020-06-13 15:30:55","2","2020-06-13 15:30:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:30:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8459","RENT","\u9810\u7e73\u79df\u91d1",3,1226,"MO","1",1226,"2","2020-06-13 15:30:55","2","2020-06-13 15:30:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:30:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3678,0,"8459"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-13 15:30:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1407,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P208102","2020-06-13 15:30:55",3678,"2","2020-06-13 15:30:55","2","2020-06-13 15:30:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:30:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8102","DEPOSIT",null,"PAID","2020-06-13 15:30:55",0,"2","2020-06-13 15:30:55","2","2020-06-13 15:30:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-13 15:30:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8102","INVOICE","8459","PAID","2020-06-13 15:30:55",3678,"2","2020-06-13 15:30:55","2","2020-06-13 15:30:55"]},"data_before":[],"data_after":[],"step":1} *****