{"created_at":"2020-07-20 09:59:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 10:16:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 11:05:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 11:26:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 12:11:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 12:14:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 12:28:54","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","floor_plan_rent_room":{"2":{"room_id":"1554","master_room_id":"198","room_code":"A16-063"}},"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1188,"customer_code":"C191188","identity_type":"PERSONAL","identity_id":"\u00e9745455(8)","title":"Mr","lastname":"Yeung","firstname":"Ngai Nang Allan","companyname":"","email":"old_b@hotmail.com","tel":"98404228","address":"Flat F, 30\/F, Fu Wai Court, 32 Fortress Hill Road, North Point, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1879.0","renew_rent_month":"12","renew_warehousing_date":"2020-08-01","renew_room_key":"0012518289","renew_remark":"6 months contract. Storage rental paid by bank transfer on July 27, 2019. Storage deposit $4816 transferred from agreement B01-CT194248 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT195588, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"154","order_discount":[{"master_room_discount_id":"350","master_room_id":"154","discount_type":"%","price":"2408.00","disocunted_price":"1565.90","discount":"34.97","monthly_deduct":842.0776,"room_id":"1243","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1243","room_code":"B01-053","retail_price":"2408.0","discounted_price":1565.9,"location_id":"5"}],"roughly_size":"42","total_retail_price":2408,"total_discounted_price":1879,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":22548,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-08-01","rent_from":"2020-08-01","rent_to":"2021-07-31","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on July 19, 2020. Storage deposit $4816 transferred from agreement B01-CT195588 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":22548,"final_order_total":22548,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0012518289","order_product":[],"pass":true}},"first_order_id":"4248","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>
B01-053 <\/td>\r\n\t\t\t\t\t	6X7X7 <\/td>\r\n\t\t\t\t\t	$2408.00 <\/td>\r\n\t\t\t\t	N\/A <\/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":"42","total_discounted_price":"1879.0","deposit":"0","total_retail_price":"2408.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 12:28: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","2","5",1188,"NEW","B01-CT208425",2408,1879,0,0,"12","12",22548,22548,22548,"2020-07-20 12:28:55","0",null,null,null,"2020-08-01","2021-07-31","12 months contract. Storage rental paid by bank transfer on July 19, 2020. Storage deposit $4816 transferred from agreement B01-CT195588 to this agreement. \r\n","2020-08-01","42",0,null,0,"0","2","2020-07-20 12:28:54","2","2020-07-20 12:28:54","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012518289","C191188","PERSONAL","Mr","qGN6DFJ8hgCCunAKrD6eAQ==","0IE6jeWdSRK4n3kDzgwX0g==","","Nd6\/AyDbYmKsCyvRLgrOW6rIl9\/18QSqJYqS31tBrGhRs7OelpAuXiR5GXuUCMse0AlJyWMJj0DSTXpo6uKsg\/Yn6h2IIRHkUu39e9jcShc=","vw\/+NdSP+h88KP5gEzKlPg==","LCkrboi44yg2EgN0LRu1+Gz2tFhNlFapI9YF5r5xw2Q=","uT+nIWbW09zEdPPUuhsQXA==",null,1,"4248"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 12:28:55","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":["8425","350","154","1243","%","34.97",842.0776,"2","2020-07-20 12:28:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 12:28: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":["8425","1243","2408.0",1565.9,"2","2020-07-20 12:28:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 12:28: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-08-01","2021-07-31","1243"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-20 12:28: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":["8425",1188,"SETTLED","B01-I208754","2020-07-20 12:28:54","2020-08-01","2","2020-07-20 12:28:54","2","2020-07-20 12:28:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 12:28: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":["8754","RENT","\u9810\u7e73\u79df\u91d1",1,1879,"MO","1",1879,"2","2020-07-20 12:28:54","2","2020-07-20 12:28:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 12:28: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":["8754","RENT","\u9810\u7e73\u79df\u91d1",2,1879,"MO","1",1879,"2","2020-07-20 12:28:54","2","2020-07-20 12:28:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 12:28: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":["8754","RENT","\u9810\u7e73\u79df\u91d1",3,1879,"MO","1",1879,"2","2020-07-20 12:28:54","2","2020-07-20 12:28:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 12:28: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":["8754","RENT","\u9810\u7e73\u79df\u91d1",4,1879,"MO","1",1879,"2","2020-07-20 12:28:54","2","2020-07-20 12:28:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 12:28: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":["8754","RENT","\u9810\u7e73\u79df\u91d1",5,1879,"MO","1",1879,"2","2020-07-20 12:28:54","2","2020-07-20 12:28:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 12:28: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":["8754","RENT","\u9810\u7e73\u79df\u91d1",6,1879,"MO","1",1879,"2","2020-07-20 12:28:54","2","2020-07-20 12:28:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 12:28: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":["8754","RENT","\u9810\u7e73\u79df\u91d1",7,1879,"MO","1",1879,"2","2020-07-20 12:28:54","2","2020-07-20 12:28:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 12:28: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":["8754","RENT","\u9810\u7e73\u79df\u91d1",8,1879,"MO","1",1879,"2","2020-07-20 12:28:54","2","2020-07-20 12:28:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 12:28: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":["8754","RENT","\u9810\u7e73\u79df\u91d1",9,1879,"MO","1",1879,"2","2020-07-20 12:28:54","2","2020-07-20 12:28:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 12:28: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":["8754","RENT","\u9810\u7e73\u79df\u91d1",10,1879,"MO","1",1879,"2","2020-07-20 12:28:54","2","2020-07-20 12:28:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 12:28: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":["8754","RENT","\u9810\u7e73\u79df\u91d1",11,1879,"MO","1",1879,"2","2020-07-20 12:28:54","2","2020-07-20 12:28:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 12:28: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":["8754","RENT","\u9810\u7e73\u79df\u91d1",12,1879,"MO","1",1879,"2","2020-07-20 12:28:54","2","2020-07-20 12:28:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 12:28:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[22548,0,"8754"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-20 12:28: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":[1188,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208397","2020-07-20 12:28:54",22548,"2","2020-07-20 12:28:54","2","2020-07-20 12:28:54","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 12:28: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":["8397","DEPOSIT",null,"PAID","2020-07-20 12:28:54",0,"2","2020-07-20 12:28:54","2","2020-07-20 12:28:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 12:28: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":["8397","INVOICE","8754","PAID","2020-07-20 12:28:54",22548,"2","2020-07-20 12:28:54","2","2020-07-20 12:28:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 12:54:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:06:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:06:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:07:43","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","floor_plan_rent_room":{"2":{"room_id":"1554","master_room_id":"198","room_code":"A16-063"}},"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1170,"customer_code":"C191170","identity_type":"PERSONAL","identity_id":"K426537(8)","title":"Mr","lastname":"Leung","firstname":"Cheuk Kin Peter","companyname":"","email":"ckpleung@gmail.com","tel":"91956031","address":"Flat 415, Blk. D, Kornhill, 19 Hong Shing St, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"729.0","renew_rent_month":"6","renew_warehousing_date":"2020-07-09","renew_room_key":"0005796879","renew_remark":"6 months contract. Storage rental paid by bank transfer on Jan 23,2020. Deposit $810 transferred from agreement C15-CT194127 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT207031, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"167","order_discount":[{"master_room_discount_id":"407","master_room_id":"167","discount_type":"%","price":"810.00","disocunted_price":"608.80","discount":"24.84","monthly_deduct":201.204,"room_id":"1326","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1326","room_code":"C15-020","retail_price":"810.0","discounted_price":608.8,"location_id":"6"}],"roughly_size":"12","total_retail_price":810,"total_discounted_price":729,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":4374,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-09","rent_from":"2020-07-09","rent_to":"2021-01-08","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on Jul 19,2020. Deposit $810 transferred from agreement C15-CT207031 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4374,"final_order_total":4374,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0005796879","order_product":[],"pass":true}},"first_order_id":"4127","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> C15-020 <\/td>\r\n\t\t\t\t\t 4X3X6.5 <\/td>\r\n\t\t\t\t\t $810.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\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":"729.0","deposit":"0","total_retail_price":"810.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:07: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","3","6",1170,"NEW","C15-CT208426",810,729,0,0,"6","6",4374,4374,4374,"2020-07-20 13:07:43","0",null,null,null,"2020-07-09","2021-01-08","6 months contract. Storage rental paid by bank transfer on Jul 19,2020. Deposit $810 transferred from agreement C15-CT207031 to this agreement.\r\n","2020-07-09","12",0,null,0,"0","2","2020-07-20 13:07:43","2","2020-07-20 13:07:43","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005796879","C191170","PERSONAL","Mr","onFpygDlp7QMdiHELSDrtw==","xEf2h2aoyRQ71ZVgBH+9WQ==","","W6Cb+QcuqMkU1Lk8zZT9NEQwlFLuG+vNTTbabAvD1ZofvXgVxA4Xzl78kA4dHtXbL8Y4TANJaAebQFao8Ga\/Vg==","mdIZh4C4CIGu799lBnyElw==","1M\/dd65p5lwuK+EOCSCR+YmZ5bIukEhicMk+wYxfH00=","Xkrqdqh3gtr\/asAhkX26Ug==",null,1,"4127"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:07:43","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":["8426","407","167","1326","%","24.84",201.204,"2","2020-07-20 13:07:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:07: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":["8426","1326","810.0",608.8,"2","2020-07-20 13:07:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:07: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-09","2021-01-08","1326"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-20 13:07: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":["8426",1170,"SETTLED","C15-I208755","2020-07-20 13:07:43","2020-07-09","2","2020-07-20 13:07:43","2","2020-07-20 13:07:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:07: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":["8755","RENT","\u9810\u7e73\u79df\u91d1",1,729,"MO","1",729,"2","2020-07-20 13:07:43","2","2020-07-20 13:07:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:07: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":["8755","RENT","\u9810\u7e73\u79df\u91d1",2,729,"MO","1",729,"2","2020-07-20 13:07:43","2","2020-07-20 13:07:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:07: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":["8755","RENT","\u9810\u7e73\u79df\u91d1",3,729,"MO","1",729,"2","2020-07-20 13:07:43","2","2020-07-20 13:07:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:07: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":["8755","RENT","\u9810\u7e73\u79df\u91d1",4,729,"MO","1",729,"2","2020-07-20 13:07:43","2","2020-07-20 13:07:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:07: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":["8755","RENT","\u9810\u7e73\u79df\u91d1",5,729,"MO","1",729,"2","2020-07-20 13:07:43","2","2020-07-20 13:07:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:07: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":["8755","RENT","\u9810\u7e73\u79df\u91d1",6,729,"MO","1",729,"2","2020-07-20 13:07:43","2","2020-07-20 13:07:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:07:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4374,0,"8755"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-20 13:07: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":[1170,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208398","2020-07-20 13:07:43",4374,"2","2020-07-20 13:07:43","2","2020-07-20 13:07:43","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:07: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":["8398","DEPOSIT",null,"PAID","2020-07-20 13:07:43",0,"2","2020-07-20 13:07:43","2","2020-07-20 13:07:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:07: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":["8398","INVOICE","8755","PAID","2020-07-20 13:07:43",4374,"2","2020-07-20 13:07:43","2","2020-07-20 13:07:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:12:36","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":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":"1","renew_warehousing_date":"2020-07-21","renew_room_key":"055,32980","renew_remark":"1 month contract. Storage rental paid by bank transfer on JUNE 20, 2020. Storage deposit transferred from agreement A12-CT207912 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT208190, \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-07-21","rent_from":"2020-07-21","rent_to":"2020-08-20","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on July 20, 2020. Storage deposit transferred from agreement A12-CT208190 to this agreement.\r\n","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.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:12: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",798,"NEW","A12-CT208427",998,1038,0,0,"1","1",1038,1038,1038,"2020-07-20 13:12:36","0",null,null,null,"2020-07-21","2020-08-20","1 month contract. Storage rental paid by bank transfer on July 20, 2020. Storage deposit transferred from agreement A12-CT208190 to this agreement.\r\n","2020-07-21","12",0,null,0,"0","2","2020-07-20 13:12:36","2","2020-07-20 13:12:36","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-07-20 13:12: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":["8427","279","998.0","998.00","2","2020-07-20 13:12:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:12: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-07-21","2020-08-20","279"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-20 13:12: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":["8427",798,"SETTLED","A12-I208756","2020-07-20 13:12:36","2020-07-21","2","2020-07-20 13:12:36","2","2020-07-20 13:12:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:12: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":["8756","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-07-20 13:12:36","2","2020-07-20 13:12:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:12:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"8756"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-20 13:12: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":[798,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208399","2020-07-20 13:12:36",1038,"2","2020-07-20 13:12:36","2","2020-07-20 13:12:36","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:12: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":["8399","DEPOSIT",null,"PAID","2020-07-20 13:12:36",0,"2","2020-07-20 13:12:36","2","2020-07-20 13:12:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:12: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":["8399","INVOICE","8756","PAID","2020-07-20 13:12:36",1038,"2","2020-07-20 13:12:36","2","2020-07-20 13:12:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:23: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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":525,"customer_code":"C170525","identity_type":"PERSONAL","identity_id":"G161193(2)","title":"Ms","lastname":"Man","firstname":"Fung Yi Roni","companyname":"","email":"manroni@kawinghong.com","tel":"54362045","address":"\u9999\u6e2f\u8d64\u67f1\u9f8d\u5fb7\u82d1\u6649\u5fb7\u95a32\u6a1313\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2336.0","renew_rent_month":"1","renew_warehousing_date":"2020-07-21","renew_room_key":"056,13866","renew_remark":"1 month contract. Storage rental paid by bank transfer on JUNE 17, 2020. Storage deposit transferred from agreement A14-CT207935 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT208179, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"544","room_code":"L22(\u670d\u88dd\u5009)","retail_price":"1342.0","discounted_price":"1342.00","location_id":"2"},{"room_id":"545","room_code":"L23","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"32","total_retail_price":2440,"total_discounted_price":2336,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2336,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-21","rent_from":"2020-07-21","rent_to":"2020-08-20","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on July 20, 2020. Storage deposit transferred from agreement A14-CT208179 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2336,"final_order_total":2336,"location_id":"2","branch_id":"1","company_id":"1","room_key":"056,13866","order_product":[],"pass":true}},"first_order_id":"4877","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> L22(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1342.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> L23 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.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":"32","total_discounted_price":"2336.0","deposit":"0","total_retail_price":"2440.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:23:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",525,"NEW","A14-CT208428",2440,2336,0,0,"1","1",2336,2336,2336,"2020-07-20 13:23:54","0",null,null,null,"2020-07-21","2020-08-20","1 month contract. Storage rental paid by bank transfer on July 20, 2020. Storage deposit transferred from agreement A14-CT208179 to this agreement.\r\n","2020-07-21","32",0,null,0,"0","2","2020-07-20 13:23:53","2","2020-07-20 13:23:53","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"056,13866","C170525","PERSONAL","Ms","ibYrH9hZ8AxKQwoDOyRf7g==","1iB+Fi5mVPBhoP\/ei\/0Bag==","","6FEfBp4QinpFgaVk\/XySHjwYeKgnpkSt7nsZEe9qVfgX7gsIGumX1P5i\/O8D1hN0","kjGiWZ21y1YpwaPjV74WsA==","qyZUZxcd5Fov\/z6YWfj+Qzvwf4EvFlsT926fUqJ1c+g=","CTeh4\/H1iVpxG8qx2JRcpg==",null,1,"4877"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:23:54","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":["8428","544","1342.0","1342.00","2","2020-07-20 13:23:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:23:54","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-21","2020-08-20","544"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-20 13:23:54","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":["8428","545","1098.0","1098.00","2","2020-07-20 13:23:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:23:54","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-21","2020-08-20","545"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-20 13:23:54","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":["8428",525,"SETTLED","A14-I208757","2020-07-20 13:23:53","2020-07-21","2","2020-07-20 13:23:53","2","2020-07-20 13:23:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:23:54","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":["8757","RENT","\u9810\u7e73\u79df\u91d1",1,2336,"MO","1",2336,"2","2020-07-20 13:23:53","2","2020-07-20 13:23:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:23:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2336,0,"8757"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-20 13:23:54","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":[525,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208400","2020-07-20 13:23:53",2336,"2","2020-07-20 13:23:53","2","2020-07-20 13:23:53","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:23:54","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":["8400","DEPOSIT",null,"PAID","2020-07-20 13:23:53",0,"2","2020-07-20 13:23:53","2","2020-07-20 13:23:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:23:54","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":["8400","INVOICE","8757","PAID","2020-07-20 13:23:53",2336,"2","2020-07-20 13:23:53","2","2020-07-20 13:23:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:25:37","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","floor_plan_rent_room":{"3":{"room_id":"818","master_room_id":"106","room_code":"Q15"}},"selected_room_tr":"\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n\t\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\t\t\t \n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> Q15 <\/td>\n\t\t\t\t\t 4X4.5X7 <\/td>\n\t\t\t\t\t $1.00 <\/td>\n\t\t\t\t N\/A <\/td> <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\u522a\u9664<\/button>\n\t\t\t\t\t<\/td><\/tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"H306142(8)","title":"Ms","lastname":"YIP","firstname":"Mei Kam","companyname":"","email":"pearlyip@ymail.com","tel":"93362222","address":"6A, Tower 3, Hillsborough Court, 18 Old Peak RD, Mid-Level","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"818","room_code":"Q15","retail_price":"1.0","discounted_price":"1.00","location_id":"3"}],"roughly_size":"18","total_retail_price":1,"total_discounted_price":1838,"deposit":3676,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":11398,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3306.00","warehousing_date":"2020-08-01","rent_from":"2020-08-01","rent_to":"2021-01-31","delivery_service":"0","remark":"6 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit paid by cheque on Jul 20, 2020. Smart card provided on the same day.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":3306,"order_total":14704,"final_order_total":11398,"location_id":"3","branch_id":"1","company_id":"1","room_key":"076, 43982","order_product":[],"pass":true}},"roughly_size":"18","total_discounted_price":"1838.00","deposit":"3676.00","total_retail_price":"1.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:25:39","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":["C201677","PERSONAL","Ms","v6d8eaMaljmnAx1HUOXaxA==","\/H+5BvS7nufXH+HNSFtUFw==","","7rrVW5bJ1RZUPLgZQRvFZw==","hW9zOqk9C0bhixv3Xs0iuqJu9P+nDkNn0abuT77txwo=","D9S4JAM2xDmLwzgcJ6wyaL5xlejYKQr3mQgFaPzfkhxbzzporNgwcXjafVPL4tEcpzi7\/lJOJsBIM8CGvIUpvQ==","\/nk96cQ2RIjRLqBOSFKNIg==",null,"hW9zOqk9C0bhixv3Xs0iuqJu9P+nDkNn0abuT77txwo=","H+0Wfb4iaYC6qdFI8k8d0A==","2","2020-07-20 13:25:37","2","2020-07-20 13:25:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:25:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","3",1677,"NEW","A18-CT208429",1,1838,3676,0,"6","6",11398,14704,11398,"2020-07-20 13:25:39","0",null,null,null,"2020-08-01","2021-01-31","6 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit paid by cheque on Jul 20, 2020. Smart card provided on the same day.","2020-08-01","18",0,null,3306,"3306.00","2","2020-07-20 13:25:37","2","2020-07-20 13:25:37","CHEQUE","","","","CHEQUE","","","",null,0,"076, 43982","C201677","PERSONAL","Ms","v6d8eaMaljmnAx1HUOXaxA==","\/H+5BvS7nufXH+HNSFtUFw==","","D9S4JAM2xDmLwzgcJ6wyaL5xlejYKQr3mQgFaPzfkhxbzzporNgwcXjafVPL4tEcpzi7\/lJOJsBIM8CGvIUpvQ==","7rrVW5bJ1RZUPLgZQRvFZw==","hW9zOqk9C0bhixv3Xs0iuqJu9P+nDkNn0abuT77txwo=","\/nk96cQ2RIjRLqBOSFKNIg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:25:39","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":["8429","818","1.0","1.00","2","2020-07-20 13:25:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:25:39","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-08-01","2021-01-31","818"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-20 13:25:39","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":["8429","A18-D205554","PAID",3676,0,"2021-01-31","2020-07-20 13:25:37","2020-07-20 13:25:37","2","2020-07-20 13:25:37","2","2020-07-20 13:25:37",1677]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:25:39","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":["8429",1677,"SETTLED","A18-I208758","2020-07-20 13:25:37","2020-08-01","2","2020-07-20 13:25:37","2","2020-07-20 13:25:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:25:39","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":["8758","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-07-20 13:25:37","2","2020-07-20 13:25:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:25:39","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":["8758","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,370,"MO","1",370,"2","2020-07-20 13:25:37","2","2020-07-20 13:25:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:25:39","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":["8758","RENT","\u9810\u7e73\u79df\u91d1",3,1838,"MO","1",1838,"2","2020-07-20 13:25:37","2","2020-07-20 13:25:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:25:39","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":["8758","RENT","\u9810\u7e73\u79df\u91d1",4,1838,"MO","1",1838,"2","2020-07-20 13:25:37","2","2020-07-20 13:25:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:25:39","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":["8758","RENT","\u9810\u7e73\u79df\u91d1",5,1838,"MO","1",1838,"2","2020-07-20 13:25:37","2","2020-07-20 13:25:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:25:39","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":["8758","RENT","\u9810\u7e73\u79df\u91d1",6,1838,"MO","1",1838,"2","2020-07-20 13:25:37","2","2020-07-20 13:25:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:25:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7722,0,"8758"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-20 13:25:39","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":[1677,"CHEQUE","","","","CHEQUE","","","","PAID","P208401","2020-07-20 13:25:37",11398,"2","2020-07-20 13:25:37","2","2020-07-20 13:25:37","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:25:39","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":["8401","DEPOSIT","5554","PAID","2020-07-20 13:25:37",3676,"2","2020-07-20 13:25:37","2","2020-07-20 13:25:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 13:25:39","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":["8401","INVOICE","8758","PAID","2020-07-20 13:25:37",7722,"2","2020-07-20 13:25:37","2","2020-07-20 13:25:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 14:09:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 14:31:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 14:48:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 15:38:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 15:38:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 15:39:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 15:41:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 15:42:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 15:45:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 15:55:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:11:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:14:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:14:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:16:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:19:24","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=INVOICE&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":{"4":{"room_id":"1429","master_room_id":"166","room_code":"C15-123"}},"_payment_type":"INVOICE","selected_room_tr":"\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n\t\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\t\t\t \n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-123 <\/td>\n\t\t\t\t\t 4X3X3 <\/td>\n\t\t\t\t\t $566.00 <\/td>\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed83\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> \n\t\t\t\t\t\t\u522a\u9664<\/button>\n\t\t\t\t\t<\/td><\/tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"Y384685(5)","title":"Ms","lastname":"NG","firstname":"Wing Sze","companyname":"","email":"coco123330@yahoo.com.hk","tel":"68482081","address":"\u67f4\u7063\u8208\u83ef\u4e8c\u671f\u88d5\u8208\u6a13703\u5ba4","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1429","room_code":"C15-123","retail_price":"566.0","discounted_price":"566.00","location_id":"6"}],"roughly_size":"12","total_retail_price":566,"total_discounted_price":510,"deposit":566,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":6686,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-20","rent_from":"2020-07-20","rent_to":"2021-07-19","delivery_service":"0","remark":"12 months contract. Storage rental and deposit $566 paid by PPS on Jul 19, 2020. Smart card provided on the same day.","paymethod":"PPS","paymethod2":"PPS","discount_deduct":0,"order_total":6686,"final_order_total":6686,"location_id":"6","branch_id":"3","company_id":"1","room_key":"087,62282","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"510.00","deposit":"566.00","total_retail_price":"566.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:19:25","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":["C201678","PERSONAL","Ms","tvlahPc3bnH\/bIjpFpqEMA==","yXKLXTtbNpECaRVTZxF\/Rw==","","Vf0x8xDeFEj\/wzlFzeCz3Q==","D21OMzfvCmIBKM+V+ZndKk9HgpW8yEvtXFpwR+goV8A=","UP9B+rMOloNwYNBp8Ofo3l82MsLQSj1dkM+8BDpbXSjhhZPgZGIWIWYQSVo+uOzN","i45rQNIpFXrURprY2ASioA==",null,"D21OMzfvCmIBKM+V+ZndKk9HgpW8yEvtXFpwR+goV8A=","yFwWTtsxU\/Ou7mIE8f5nAQ==","2","2020-07-20 16:19:24","2","2020-07-20 16:19:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:19:26","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",1678,"NEW","C15-CT208430",566,510,566,0,"12","12",6686,6686,6686,"2020-07-20 16:19:26","0",null,null,null,"2020-07-20","2021-07-19","12 months contract. Storage rental and deposit $566 paid by PPS on Jul 19, 2020. Smart card provided on the same day.","2020-07-20","12",0,null,0,"0","2","2020-07-20 16:19:24","2","2020-07-20 16:19:24","PPS","","","","PPS","","","",null,0,"087,62282","C201678","PERSONAL","Ms","tvlahPc3bnH\/bIjpFpqEMA==","yXKLXTtbNpECaRVTZxF\/Rw==","","UP9B+rMOloNwYNBp8Ofo3l82MsLQSj1dkM+8BDpbXSjhhZPgZGIWIWYQSVo+uOzN","Vf0x8xDeFEj\/wzlFzeCz3Q==","D21OMzfvCmIBKM+V+ZndKk9HgpW8yEvtXFpwR+goV8A=","i45rQNIpFXrURprY2ASioA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:19:26","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":["8430","1429","566.0","566.00","2","2020-07-20 16:19:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:19:26","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-20","2021-07-19","1429"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-20 16:19:26","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":["8430","C15-D205555","PAID",566,0,"2021-07-19","2020-07-20 16:19:24","2020-07-20 16:19:24","2","2020-07-20 16:19:24","2","2020-07-20 16:19:24",1678]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:19:26","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":["8430",1678,"SETTLED","C15-I208759","2020-07-20 16:19:24","2020-07-20","2","2020-07-20 16:19:24","2","2020-07-20 16:19:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:19:26","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":["8759","RENT","\u9810\u7e73\u79df\u91d1",1,510,"MO","1",510,"2","2020-07-20 16:19:24","2","2020-07-20 16:19:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:19:26","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":["8759","RENT","\u9810\u7e73\u79df\u91d1",2,510,"MO","1",510,"2","2020-07-20 16:19:24","2","2020-07-20 16:19:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:19:26","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":["8759","RENT","\u9810\u7e73\u79df\u91d1",3,510,"MO","1",510,"2","2020-07-20 16:19:24","2","2020-07-20 16:19:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:19:26","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":["8759","RENT","\u9810\u7e73\u79df\u91d1",4,510,"MO","1",510,"2","2020-07-20 16:19:24","2","2020-07-20 16:19:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:19:26","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":["8759","RENT","\u9810\u7e73\u79df\u91d1",5,510,"MO","1",510,"2","2020-07-20 16:19:24","2","2020-07-20 16:19:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:19:26","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":["8759","RENT","\u9810\u7e73\u79df\u91d1",6,510,"MO","1",510,"2","2020-07-20 16:19:24","2","2020-07-20 16:19:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:19:26","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":["8759","RENT","\u9810\u7e73\u79df\u91d1",7,510,"MO","1",510,"2","2020-07-20 16:19:24","2","2020-07-20 16:19:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:19:26","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":["8759","RENT","\u9810\u7e73\u79df\u91d1",8,510,"MO","1",510,"2","2020-07-20 16:19:24","2","2020-07-20 16:19:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:19:26","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":["8759","RENT","\u9810\u7e73\u79df\u91d1",9,510,"MO","1",510,"2","2020-07-20 16:19:24","2","2020-07-20 16:19:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:19:26","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":["8759","RENT","\u9810\u7e73\u79df\u91d1",10,510,"MO","1",510,"2","2020-07-20 16:19:24","2","2020-07-20 16:19:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:19:26","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":["8759","RENT","\u9810\u7e73\u79df\u91d1",11,510,"MO","1",510,"2","2020-07-20 16:19:24","2","2020-07-20 16:19:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:19:26","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":["8759","RENT","\u9810\u7e73\u79df\u91d1",12,510,"MO","1",510,"2","2020-07-20 16:19:24","2","2020-07-20 16:19:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:19:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6120,0,"8759"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-20 16:19:26","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":[1678,"PPS","","","","PPS","","","","PAID","P208402","2020-07-20 16:19:24",6686,"2","2020-07-20 16:19:24","2","2020-07-20 16:19:24","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:19:26","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":["8402","DEPOSIT","5555","PAID","2020-07-20 16:19:24",566,"2","2020-07-20 16:19:24","2","2020-07-20 16:19:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:19:26","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":["8402","INVOICE","8759","PAID","2020-07-20 16:19:24",6120,"2","2020-07-20 16:19:24","2","2020-07-20 16:19:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:38:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:52:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:52:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:52:47","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 16:54:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 17:05:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 17:23:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 17:25:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 17:25:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 18:12:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 18:40:22","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=INVOICE&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":{"5":{"room_id":"561","master_room_id":"48","room_code":"L39"}},"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":"1","customer_id":262,"customer_code":"C170262","identity_type":"PERSONAL","identity_id":"D484790(4)","title":"Ms","lastname":"WONG","firstname":"Cheuk Man Mandy","companyname":"","email":"lemonnosugar@gmail.com","tel":"92028053","address":"6A, Portfield Bldg, 10-16 Yuk Sau Street, Happy Valley","pass":true,"customer_first_order":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3301.0","renew_rent_month":"12","renew_warehousing_date":"2020-07-25","renew_room_key":"056,15543,054,62603","renew_remark":"12 months contract. Special renewal offer, $300 Maxim's cake voucher offered. Storage rental paid by bank transfer on July 22, 2019. Storage deposit transferred from agreement A12-CT194110 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195545, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"561","room_code":"L39","retail_price":"2318.0","discounted_price":"2318.00","location_id":"2"}],"roughly_size":"32","total_retail_price":2318,"total_discounted_price":2086,"deposit":4636,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":28170,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3584.00","warehousing_date":"2020-07-27","rent_from":"2020-07-27","rent_to":"2021-08-26","delivery_service":"0","remark":"13 months contract. Referral bouns -$250. Special offer the 13th month free and extra 5% rent now discount. Storage rental and deposit paid by cheque on Jul 20, 2020. Smart card provided on the same day.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":3584,"order_total":31754,"final_order_total":28170,"location_id":"2","branch_id":"1","company_id":"1","room_key":"189,12131","order_product":[],"pass":true}},"first_order_id":"4110","selected_room_tr":"\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n\t\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\t\t\t \n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> L39 <\/td>\n\t\t\t\t\t 4X8X8 <\/td>\n\t\t\t\t\t $2318.00 <\/td>\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\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> \n\t\t\t\t\t\t\u522a\u9664<\/button>\n\t\t\t\t\t<\/td><\/tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"2086.00","deposit":"4636.00","total_retail_price":"2318.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 18:40:23","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":["C201679","PERSONAL","Ms","kwdSO7Ycb8PwoVKLWhZpYA==","ddrfzAYTmkL\/QNu3psjONQ==","","a\/y2Qrzn0kao6T1xJXuB3g==","ueYgCG4LhuKcGq\/NkZFOrUks9W+D2VEm4LiPJX4u06g=","BHQ9hkHdRQGEjBqtlvqUCVY7Yq+vCPSiUJb+oMnt7bk1vuNyZJtS9G8xdeAHmfDgQcWK8DukQi8Gjmh8wsizjg==","pflhzOWnDf2jT37JrLakNQ==",null,"ueYgCG4LhuKcGq\/NkZFOrUks9W+D2VEm4LiPJX4u06g=","gLf7tj9rhz1611RbBchB\/w==","2","2020-07-20 18:40:22","2","2020-07-20 18:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 18:40:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",1679,"NEW","A14-CT208431",2318,2086,4636,0,"13","13",28170,31754,28170,"2020-07-20 18:40:24","0",null,null,null,"2020-07-27","2021-08-26","13 months contract. Referral bouns -$250. Special offer the 13th month free and extra 5% rent now discount. Storage rental and deposit paid by cheque on Jul 20, 2020. Smart card provided on the same day.","2020-07-27","32",0,null,3584,"3584.00","2","2020-07-20 18:40:22","2","2020-07-20 18:40:22","CHEQUE","","","","CHEQUE","","","",null,0,"189,12131","C201679","PERSONAL","Ms","kwdSO7Ycb8PwoVKLWhZpYA==","ddrfzAYTmkL\/QNu3psjONQ==","","BHQ9hkHdRQGEjBqtlvqUCVY7Yq+vCPSiUJb+oMnt7bk1vuNyZJtS9G8xdeAHmfDgQcWK8DukQi8Gjmh8wsizjg==","a\/y2Qrzn0kao6T1xJXuB3g==","ueYgCG4LhuKcGq\/NkZFOrUks9W+D2VEm4LiPJX4u06g=","pflhzOWnDf2jT37JrLakNQ==",null,1,"4110"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 18:40:24","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":["8431","561","2318.0","2318.00","2","2020-07-20 18:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 18:40:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-27","2021-08-26","561"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-20 18:40:24","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":["8431","A14-D205556","PAID",4636,0,"2021-08-26","2020-07-20 18:40:22","2020-07-20 18:40:22","2","2020-07-20 18:40:22","2","2020-07-20 18:40:22",1679]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 18:40:24","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":["8431",1679,"SETTLED","A14-I208760","2020-07-20 18:40:22","2020-07-27","2","2020-07-20 18:40:22","2","2020-07-20 18:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 18:40:24","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":["8760","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-07-20 18:40:22","2","2020-07-20 18:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 18:40:24","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":["8760","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,588,"MO","1",588,"2","2020-07-20 18:40:22","2","2020-07-20 18:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 18:40:24","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":["8760","RENT","\u9810\u7e73\u79df\u91d1",3,2086,"MO","1",2086,"2","2020-07-20 18:40:22","2","2020-07-20 18:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 18:40:24","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":["8760","RENT","\u9810\u7e73\u79df\u91d1",4,2086,"MO","1",2086,"2","2020-07-20 18:40:22","2","2020-07-20 18:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 18:40:24","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":["8760","RENT","\u9810\u7e73\u79df\u91d1",5,2086,"MO","1",2086,"2","2020-07-20 18:40:22","2","2020-07-20 18:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 18:40:24","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":["8760","RENT","\u9810\u7e73\u79df\u91d1",6,2086,"MO","1",2086,"2","2020-07-20 18:40:22","2","2020-07-20 18:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 18:40:24","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":["8760","RENT","\u9810\u7e73\u79df\u91d1",7,2086,"MO","1",2086,"2","2020-07-20 18:40:22","2","2020-07-20 18:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 18:40:24","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":["8760","RENT","\u9810\u7e73\u79df\u91d1",8,2086,"MO","1",2086,"2","2020-07-20 18:40:22","2","2020-07-20 18:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 18:40:24","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":["8760","RENT","\u9810\u7e73\u79df\u91d1",9,2086,"MO","1",2086,"2","2020-07-20 18:40:22","2","2020-07-20 18:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 18:40:24","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":["8760","RENT","\u9810\u7e73\u79df\u91d1",10,2086,"MO","1",2086,"2","2020-07-20 18:40:22","2","2020-07-20 18:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 18:40:24","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":["8760","RENT","\u9810\u7e73\u79df\u91d1",11,2086,"MO","1",2086,"2","2020-07-20 18:40:22","2","2020-07-20 18:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 18:40:24","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":["8760","RENT","\u9810\u7e73\u79df\u91d1",12,2086,"MO","1",2086,"2","2020-07-20 18:40:22","2","2020-07-20 18:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 18:40:24","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":["8760","RENT","\u9810\u7e73\u79df\u91d1",13,2086,"MO","1",2086,"2","2020-07-20 18:40:22","2","2020-07-20 18:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 18:40:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[23534,0,"8760"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-20 18:40:24","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":[1679,"CHEQUE","","","","CHEQUE","","","","PAID","P208403","2020-07-20 18:40:22",28170,"2","2020-07-20 18:40:22","2","2020-07-20 18:40:22","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 18:40:24","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":["8403","DEPOSIT","5556","PAID","2020-07-20 18:40:22",4636,"2","2020-07-20 18:40:22","2","2020-07-20 18:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 18:40:24","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":["8403","INVOICE","8760","PAID","2020-07-20 18:40:22",23534,"2","2020-07-20 18:40:22","2","2020-07-20 18:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 18:43:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 18:45:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-20 18:56:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****