{"created_at":"2020-05-05 02:38:31","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 02:38:48","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 02:39:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:30: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":"filter1=3&filter2=2020-04-01&filter3=2020-04-09&page=3&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":400,"customer_code":"C170400","identity_type":"PERSONAL","identity_id":"D478125(3)","title":"Mr","lastname":"Pak","firstname":"Hing Nam William","companyname":"","email":"williampak@yahoo.com","tel":"92339084","address":"18E,Comfort Centre,108 Old Main Street,Aberdeen HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2018.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-07","renew_room_key":"054,41862","renew_remark":"6 months contract. Storage rental paid by bank transfer on Nov 06, 2019. Storage deposit transferred from agreement A14-CT194897 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196336, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"30","order_discount":[],"order_room":[{"room_id":"650","room_code":"M61","retail_price":"775.0","discounted_price":"775.00","location_id":"2"},{"room_id":"649","room_code":"M60","retail_price":"775.0","discounted_price":"775.00","location_id":"2"},{"room_id":"636","room_code":"M47","retail_price":"775.0","discounted_price":"775.00","location_id":"2"},{"room_id":"635","room_code":"M46","retail_price":"775.0","discounted_price":"775.00","location_id":"2"}],"roughly_size":"36","total_retail_price":3100,"total_discounted_price":2018,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":24216,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-07","rent_from":"2020-05-07","rent_to":"2021-05-06","delivery_service":"0","remark":"12 months contract. Special offer $300 Maxim's voucher and 2 gifts. Storage rental paid by bank transfer on May 5, 2020. Storage deposit transferred from agreement A14-CT196336 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":24216,"final_order_total":24216,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,41862","order_product":[],"pass":true}},"first_order_id":"3474","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\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>
M61 <\/td>\r\n\t\t\t\t\t	3X3X8 <\/td>\r\n\t\t\t\t\t	$775.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>
M60 <\/td>\r\n\t\t\t\t\t	3X3X8 <\/td>\r\n\t\t\t\t\t	$775.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>
M47 <\/td>\r\n\t\t\t\t\t	3X3X8 <\/td>\r\n\t\t\t\t\t	$775.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>
M46 <\/td>\r\n\t\t\t\t\t	3X3X8 <\/td>\r\n\t\t\t\t\t	$775.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":"36","total_discounted_price":"2018.00","deposit":"0.00","total_retail_price":"3100.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:30:22","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",400,"NEW","A14-CT207770",3100,2018,0,0,"12","12",24216,24216,24216,"2020-05-05 10:30:22","0",null,null,null,"2020-05-07","2021-05-06","12 months contract. Special offer $300 Maxim's voucher and 2 gifts. Storage rental paid by bank transfer on May 5, 2020. Storage deposit transferred from agreement A14-CT196336 to this agreement.","2020-05-07","36",0,null,0,"0","2","2020-05-05 10:30:22","2","2020-05-05 10:30:22","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,41862","C170400","PERSONAL","Mr","4xdTGuMk2e6S9GT7kBszqcEkLQE+wxier+D5AqLE6go=","Nqa9Akxyx2h5PVMZAYut7Q==","","FpYa4f7KJN+xafhErT4EtgKduIy5jw6WoIZVxnKti\/oeKBvtXzor+TlhSTgjyGX3kDd2dYT+LrhwpvD5NHQzMQ==","T2kg2iW\/dz22NkOvrWOuKg==","oH1o2WTX7Tm3DVjtiwbn3ozbRLNov31GQJFvtgZ\/jxI=","wHCBjexSXZeawiMyRYbYwg==",null,1,"3474"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:30:22","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":["7770","650","775.0","775.00","2","2020-05-05 10:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:30:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-07","2021-05-06","650"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-05 10:30:22","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":["7770","649","775.0","775.00","2","2020-05-05 10:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:30:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-07","2021-05-06","649"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-05 10:30:22","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":["7770","636","775.0","775.00","2","2020-05-05 10:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:30:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-07","2021-05-06","636"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-05 10:30:22","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":["7770","635","775.0","775.00","2","2020-05-05 10:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:30:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-07","2021-05-06","635"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-05 10:30:22","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":["7770",400,"SETTLED","A14-I208099","2020-05-05 10:30:22","2020-05-07","2","2020-05-05 10:30:22","2","2020-05-05 10:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:30:22","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":["8099","RENT","\u9810\u7e73\u79df\u91d1",1,2018,"MO","1",2018,"2","2020-05-05 10:30:22","2","2020-05-05 10:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:30:22","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":["8099","RENT","\u9810\u7e73\u79df\u91d1",2,2018,"MO","1",2018,"2","2020-05-05 10:30:22","2","2020-05-05 10:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:30:22","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":["8099","RENT","\u9810\u7e73\u79df\u91d1",3,2018,"MO","1",2018,"2","2020-05-05 10:30:22","2","2020-05-05 10:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:30:22","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":["8099","RENT","\u9810\u7e73\u79df\u91d1",4,2018,"MO","1",2018,"2","2020-05-05 10:30:22","2","2020-05-05 10:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:30:22","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":["8099","RENT","\u9810\u7e73\u79df\u91d1",5,2018,"MO","1",2018,"2","2020-05-05 10:30:22","2","2020-05-05 10:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:30:22","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":["8099","RENT","\u9810\u7e73\u79df\u91d1",6,2018,"MO","1",2018,"2","2020-05-05 10:30:22","2","2020-05-05 10:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:30:22","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":["8099","RENT","\u9810\u7e73\u79df\u91d1",7,2018,"MO","1",2018,"2","2020-05-05 10:30:22","2","2020-05-05 10:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:30:22","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":["8099","RENT","\u9810\u7e73\u79df\u91d1",8,2018,"MO","1",2018,"2","2020-05-05 10:30:22","2","2020-05-05 10:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:30:22","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":["8099","RENT","\u9810\u7e73\u79df\u91d1",9,2018,"MO","1",2018,"2","2020-05-05 10:30:22","2","2020-05-05 10:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:30:22","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":["8099","RENT","\u9810\u7e73\u79df\u91d1",10,2018,"MO","1",2018,"2","2020-05-05 10:30:22","2","2020-05-05 10:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:30:22","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":["8099","RENT","\u9810\u7e73\u79df\u91d1",11,2018,"MO","1",2018,"2","2020-05-05 10:30:22","2","2020-05-05 10:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:30:22","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":["8099","RENT","\u9810\u7e73\u79df\u91d1",12,2018,"MO","1",2018,"2","2020-05-05 10:30:22","2","2020-05-05 10:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:30:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[24216,0,"8099"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-05 10:30:22","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":[400,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207744","2020-05-05 10:30:22",24216,"2","2020-05-05 10:30:22","2","2020-05-05 10:30:22","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:30:22","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":["7744","DEPOSIT",null,"PAID","2020-05-05 10:30:22",0,"2","2020-05-05 10:30:22","2","2020-05-05 10:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:30:22","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":["7744","INVOICE","8099","PAID","2020-05-05 10:30:22",24216,"2","2020-05-05 10:30:22","2","2020-05-05 10:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:58:55","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=3&filter2=2020-04-01&filter3=2020-04-09&page=3&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":576,"customer_code":"C170576","identity_type":"PERSONAL","identity_id":"D257655(5)","title":"Ms","lastname":"Tse","firstname":"Wai Ching","companyname":"","email":"advance.maggie@gmail.com","tel":"96732270","address":"Flat 2, 17\/F, Ngan On House, Yue On Court, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-11","renew_room_key":"054,01063,137,19322,076,29513","renew_remark":"6 months contract. Storage rental paid by bank transfer on Nov 09, 2019. Storage deposit transferred from agreement A12-CT194903 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196346, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"40","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"40","room_code":"A40","retail_price":"1098.0","discounted_price":989,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":935,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5610,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-11","rent_from":"2020-05-11","rent_to":"2020-11-10","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on May 4, 2020. Storage deposit transferred from agreement A12-CT196346 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5610,"final_order_total":5610,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,01063,137,19322,076,29513","order_product":[],"pass":true}},"first_order_id":"3429","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> A40 <\/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\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":"16","total_discounted_price":"935.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:58:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",576,"NEW","A12-CT207771",1098,935,0,0,"6","6",5610,5610,5610,"2020-05-05 10:58:56","0",null,null,null,"2020-05-11","2020-11-10","6 months contract. Storage rental paid by bank transfer on May 4, 2020. Storage deposit transferred from agreement A12-CT196346 to this agreement.\r\n","2020-05-11","16",0,null,0,"0","2","2020-05-05 10:58:55","2","2020-05-05 10:58:55","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,01063,137,19322,076,29513","C170576","PERSONAL","Ms","yu\/0S+RF2RRsi8jECHi7sQ==","JbA4gcU0oX0prLybEfuQ0g==","","8IPTU4T8SkKk2bYg1MgG8ONNj05mRTUua7IcsvyxnSoAdAO9i2Y5LztoBM6Q84DKTyjS8NU0bXZJmaGiQpb68w==","0Od8yfeYo8TRl8TNeKrbmA==","upnq56tagpPq\/rP4PZnAUQDeu2yx6QceV74vpeLggg8=","Gqgd0ic7Gwt8gsPCQKe24w==",null,1,"3429"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:58:56","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":["7771","72","8","40","%","9.93",109.0314,"2","2020-05-05 10:58:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:58:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7771","40","1098.0",989,"2","2020-05-05 10:58:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:58:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-11","2020-11-10","40"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-05 10:58:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7771",576,"SETTLED","A12-I208100","2020-05-05 10:58:55","2020-05-11","2","2020-05-05 10:58:55","2","2020-05-05 10:58:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:58:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8100","RENT","\u9810\u7e73\u79df\u91d1",1,935,"MO","1",935,"2","2020-05-05 10:58:55","2","2020-05-05 10:58:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:58:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8100","RENT","\u9810\u7e73\u79df\u91d1",2,935,"MO","1",935,"2","2020-05-05 10:58:55","2","2020-05-05 10:58:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:58:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8100","RENT","\u9810\u7e73\u79df\u91d1",3,935,"MO","1",935,"2","2020-05-05 10:58:55","2","2020-05-05 10:58:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:58:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8100","RENT","\u9810\u7e73\u79df\u91d1",4,935,"MO","1",935,"2","2020-05-05 10:58:55","2","2020-05-05 10:58:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:58:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8100","RENT","\u9810\u7e73\u79df\u91d1",5,935,"MO","1",935,"2","2020-05-05 10:58:55","2","2020-05-05 10:58:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:58:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8100","RENT","\u9810\u7e73\u79df\u91d1",6,935,"MO","1",935,"2","2020-05-05 10:58:55","2","2020-05-05 10:58:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:58:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5610,0,"8100"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-05 10:58:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[576,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207745","2020-05-05 10:58:55",5610,"2","2020-05-05 10:58:55","2","2020-05-05 10:58:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:58:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7745","DEPOSIT",null,"PAID","2020-05-05 10:58:55",0,"2","2020-05-05 10:58:55","2","2020-05-05 10:58:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 10:58:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7745","INVOICE","8100","PAID","2020-05-05 10:58:55",5610,"2","2020-05-05 10:58:55","2","2020-05-05 10:58:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:01:06","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=3&filter2=2020-04-01&filter3=2020-04-09&page=3&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":191,"customer_code":"C160191","identity_type":"BUSINESS","identity_id":"K044377(8)","title":"Mr","lastname":"Sze","firstname":"Po Lui","companyname":"\u6052\u6bc5\u88dd\u98fe\u5de5\u7a0b","email":"po_hang_ngai@yahoo.com.hk","tel":"94708127","address":"\u9d28\u8137\u6d32\u5927\u885797-103, 6\/F C\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1430.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-05","renew_room_key":"054,44253","renew_remark":"6 months contract. Storage rental paid by bank transfer on Nov 04, 2019. Storage deposit transferred from agreement A12-CT194850 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196352, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"16","order_discount":[{"master_room_discount_id":"86","master_room_id":"16","discount_type":"%","price":"1838.00","disocunted_price":"1653.80","discount":"10.02","monthly_deduct":184.1676,"room_id":"53","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"53","room_code":"B01","retail_price":"1838.0","discounted_price":1653.8,"location_id":"1"}],"roughly_size":"25","total_retail_price":1838,"total_discounted_price":1430,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":8580,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-05","rent_from":"2020-05-05","rent_to":"2020-11-04","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on May 4, 2020. Storage deposit transferred from agreement A12-CT196352 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":8580,"final_order_total":8580,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,44253","order_product":[],"pass":true}},"first_order_id":"4850","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 <\/td>\r\n\t\t\t\t\t 5X5X8 <\/td>\r\n\t\t\t\t\t $1838.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":"25","total_discounted_price":"1430.0","deposit":"0","total_retail_price":"1838.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:01:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",191,"NEW","A12-CT207772",1838,1430,0,0,"6","6",8580,8580,8580,"2020-05-05 11:01:06","0",null,null,null,"2020-05-05","2020-11-04","6 months contract. Storage rental paid by bank transfer on May 4, 2020. Storage deposit transferred from agreement A12-CT196352 to this agreement.","2020-05-05","25",0,null,0,"0","2","2020-05-05 11:01:06","2","2020-05-05 11:01:06","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,44253","C160191","BUSINESS","Mr","PvWOoCMfg1HOabh8hHbkZQ==","tKWd\/xUwRmzuYlA5DWYN9Q==","\u6052\u6bc5\u88dd\u98fe\u5de5\u7a0b","2wKgHdSZXeeCYiVPiv2MfYFzW0eKPJU47Ng6uL++79k=","n+uq1dvILRbMnepkMy\/b4Q==","aOjmo\/HYwKlxQHKRip+Qh1kxeVAZ3EHUUcAWhfe9ixw=",null,"cdCe0zj+d6Wonrr\/uTQrtw==",1,"4850"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:01:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["7772","86","16","53","%","10.02",184.1676,"2","2020-05-05 11:01:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:01:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7772","53","1838.0",1653.8,"2","2020-05-05 11:01:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:01:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-05","2020-11-04","53"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-05 11:01:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7772",191,"SETTLED","A12-I208101","2020-05-05 11:01:06","2020-05-05","2","2020-05-05 11:01:06","2","2020-05-05 11:01:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:01:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8101","RENT","\u9810\u7e73\u79df\u91d1",1,1430,"MO","1",1430,"2","2020-05-05 11:01:06","2","2020-05-05 11:01:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:01:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8101","RENT","\u9810\u7e73\u79df\u91d1",2,1430,"MO","1",1430,"2","2020-05-05 11:01:06","2","2020-05-05 11:01:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:01:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8101","RENT","\u9810\u7e73\u79df\u91d1",3,1430,"MO","1",1430,"2","2020-05-05 11:01:06","2","2020-05-05 11:01:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:01:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8101","RENT","\u9810\u7e73\u79df\u91d1",4,1430,"MO","1",1430,"2","2020-05-05 11:01:06","2","2020-05-05 11:01:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:01:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8101","RENT","\u9810\u7e73\u79df\u91d1",5,1430,"MO","1",1430,"2","2020-05-05 11:01:06","2","2020-05-05 11:01:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:01:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8101","RENT","\u9810\u7e73\u79df\u91d1",6,1430,"MO","1",1430,"2","2020-05-05 11:01:06","2","2020-05-05 11:01:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:01:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8580,0,"8101"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-05 11:01:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[191,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207746","2020-05-05 11:01:06",8580,"2","2020-05-05 11:01:06","2","2020-05-05 11:01:06","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:01:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7746","DEPOSIT",null,"PAID","2020-05-05 11:01:06",0,"2","2020-05-05 11:01:06","2","2020-05-05 11:01:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:01:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7746","INVOICE","8101","PAID","2020-05-05 11:01:06",8580,"2","2020-05-05 11:01:06","2","2020-05-05 11:01:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:10:12","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=3&filter2=2020-04-01&filter3=2020-04-09&page=3&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":506,"customer_code":"C170506","identity_type":"PERSONAL","identity_id":"D435016(3)","title":"Mr","lastname":"Kwok","firstname":"Chi Kong","companyname":"","email":"kwokchikong@gmail.com","tel":"91520880","address":"\u9d28\u8137\u6d32\u5229\u679d\u9053145\u865f\u91d1\u767c\u5927\u5ec85\u6a13F\u5ba4","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1286.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-17","renew_room_key":"054,46844","renew_remark":"1 month contract. Storage rental paid by PPS on March 24, 2020. Storage deposit transferred from agreement A12-CT207258 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207479, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"113","room_code":"B61","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1286,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1286,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-17","rent_from":"2020-04-17","rent_to":"2020-05-16","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on April 29, 2020. Storage deposit transferred from agreement A12-CT207479 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1286,"final_order_total":1286,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,46844","order_product":[],"pass":true}},"first_order_id":"4179","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> B61 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.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":"20","total_discounted_price":"1286.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:10:12","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",506,"NEW","A12-CT207773",1528,1286,0,0,"1","1",1286,1286,1286,"2020-05-05 11:10:12","0",null,null,null,"2020-04-17","2020-05-16","1 month contract. Storage rental paid by PPS on April 29, 2020. Storage deposit transferred from agreement A12-CT207479 to this agreement.","2020-04-17","20",0,null,0,"0","2","2020-05-05 11:10:12","2","2020-05-05 11:10:12","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,46844","C170506","PERSONAL","Mr","m+azv2CUGWm2lPm4xNx9sA==","+pNULpsInm3siHASV0hIrg==","","LwVAteVJ0ZkV+zmR7qIDhOZ88Sc7Q+u3tsoHaiRzz2YCnm7wtowmDZcdUdskzm9A","22F8u0roh3XfvK0e6+ag3g==","WR6bE6RUwKqp5feySv5edgfk8AMEkZpUrE0\/8O+jORg=","Rmwt5dKGhWq\/pC\/sJ3hH+A==",null,1,"4179"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:10:12","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":["7773","113","1528.0","1528.00","2","2020-05-05 11:10:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:10:12","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-04-17","2020-05-16","113"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-05 11:10:12","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":["7773",506,"SETTLED","A12-I208102","2020-05-05 11:10:12","2020-04-17","2","2020-05-05 11:10:12","2","2020-05-05 11:10:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:10:12","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":["8102","RENT","\u9810\u7e73\u79df\u91d1",1,1286,"MO","1",1286,"2","2020-05-05 11:10:12","2","2020-05-05 11:10:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:10:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1286,0,"8102"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-05 11:10:12","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":[506,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207747","2020-05-05 11:10:12",1286,"2","2020-05-05 11:10:12","2","2020-05-05 11:10:12","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:10:12","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":["7747","DEPOSIT",null,"PAID","2020-05-05 11:10:12",0,"2","2020-05-05 11:10:12","2","2020-05-05 11:10:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:10:12","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":["7747","INVOICE","8102","PAID","2020-05-05 11:10:12",1286,"2","2020-05-05 11:10:12","2","2020-05-05 11:10:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:13:28","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=3&filter2=2020-04-01&filter3=2020-04-09&page=3&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":506,"customer_code":"C170506","identity_type":"PERSONAL","identity_id":"D435016(3)","title":"Mr","lastname":"Kwok","firstname":"Chi Kong","companyname":"","email":"kwokchikong@gmail.com","tel":"91520880","address":"\u9d28\u8137\u6d32\u5229\u679d\u9053145\u865f\u91d1\u767c\u5927\u5ec85\u6a13F\u5ba4","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-15","renew_room_key":"054,46844","renew_remark":"1 month contract. Storage rental paid by PPS on March 23, 2020. Storage deposit transferred from agreement A12-CT207259 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207478, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"243","room_code":"D47","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":998,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-15","rent_from":"2020-04-15","rent_to":"2020-05-14","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on April 29, 2020. Storage deposit transferred from agreement A12-CT207478 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":998,"final_order_total":998,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,46844","order_product":[],"pass":true}},"first_order_id":"4192","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> D47 <\/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":"998.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:13:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",506,"NEW","A12-CT207774",998,998,0,0,"1","1",998,998,998,"2020-05-05 11:13:28","0",null,null,null,"2020-04-15","2020-05-14","1 month contract. Storage rental paid by PPS on April 29, 2020. Storage deposit transferred from agreement A12-CT207478 to this agreement.\r\n","2020-04-15","12",0,null,0,"0","2","2020-05-05 11:13:28","2","2020-05-05 11:13:28","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,46844","C170506","PERSONAL","Mr","m+azv2CUGWm2lPm4xNx9sA==","+pNULpsInm3siHASV0hIrg==","","LwVAteVJ0ZkV+zmR7qIDhOZ88Sc7Q+u3tsoHaiRzz2YCnm7wtowmDZcdUdskzm9A","22F8u0roh3XfvK0e6+ag3g==","WR6bE6RUwKqp5feySv5edgfk8AMEkZpUrE0\/8O+jORg=","Rmwt5dKGhWq\/pC\/sJ3hH+A==",null,1,"4192"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:13:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7774","243","998.0","998.00","2","2020-05-05 11:13:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:13:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-15","2020-05-14","243"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-05 11:13:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7774",506,"SETTLED","A12-I208103","2020-05-05 11:13:28","2020-04-15","2","2020-05-05 11:13:28","2","2020-05-05 11:13:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:13:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8103","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-05-05 11:13:28","2","2020-05-05 11:13:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:13:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"8103"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-05 11:13:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[506,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207748","2020-05-05 11:13:28",998,"2","2020-05-05 11:13:28","2","2020-05-05 11:13:28","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:13:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7748","DEPOSIT",null,"PAID","2020-05-05 11:13:28",0,"2","2020-05-05 11:13:28","2","2020-05-05 11:13:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:13:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7748","INVOICE","8103","PAID","2020-05-05 11:13:28",998,"2","2020-05-05 11:13:28","2","2020-05-05 11:13:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:13:28","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","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1274,"customer_code":"C191274","identity_type":"PERSONAL","identity_id":"K628182(6)","title":"Mr","lastname":"WONG","firstname":"Ho Fung Alastair","companyname":"","email":"kworca2@yahoo.com.hk","tel":"93886951","address":"Flat 1707, Block 9, Heng Fa Chuen, Chai Wan, HK","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1053.0","renew_rent_month":"3","renew_warehousing_date":"2020-04-23","renew_room_key":"'0012387151","renew_remark":"3 months contract. Change unit from C15-049 to C15-045. Storage rental $294 and storage deposit $1108 to this agreement. Remaining balance $2865 paid by cash on January 10, 2020. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT206928, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1108.0","renew_master_room_id":"177","order_discount":[],"order_room":[{"room_id":"1351","room_code":"C15-045","retail_price":"1108.0","discounted_price":"1108.00","location_id":"6"}],"roughly_size":"18","total_retail_price":1108,"total_discounted_price":998,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5988,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-23","rent_from":"2020-04-23","rent_to":"2020-10-22","delivery_service":"0","remark":"6 months contract. Storage rental $6000 paid by bank transfer on May 04,2020. Outstanding $12 will be transferred into the next contract. Storage deposit $1108 transferred from agreement C15-CT206928 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5988,"final_order_total":5988,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012387151","order_product":[],"pass":true}},"first_order_id":6928,"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-045 <\/td>\r\n\t\t\t\t\t 4.5X4X6.5 <\/td>\r\n\t\t\t\t\t $1108.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"18","total_discounted_price":"998.00","deposit":"0.00","total_retail_price":"1108.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:13:29","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",1274,"NEW","C15-CT207775",1108,998,0,0,"6","6",5988,5988,5988,"2020-05-05 11:13:29","0",null,null,null,"2020-04-23","2020-10-22","6 months contract. Storage rental $6000 paid by bank transfer on May 04,2020. Outstanding $12 will be transferred into the next contract. Storage deposit $1108 transferred from agreement C15-CT206928 to this agreement.","2020-04-23","18",0,null,0,"0","2","2020-05-05 11:13:28","2","2020-05-05 11:13:28","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0012387151","C191274","PERSONAL","Mr","vVW1z8GZlxuG7uBwhPoAB+LQf8j\/vSFoHdbqoY3SwDo=","ddrfzAYTmkL\/QNu3psjONQ==","","UycQTH9zCSoPKTvTvIsbf5ABu8M0uPs1S829Rlpymn+TfepzS\/z\/IIsXxdrBPRAC","q6xzCvHViDJ5kezBmImvsA==","O26+D0wug4NA7bff7KsT\/LtBPTVdXq+ptB1lo71O0DU=","cjeBGrcluVIUBb5SnqNvbA==",null,1,6928]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:13:29","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":["7775","1351","1108.0","1108.00","2","2020-05-05 11:13:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:13:29","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-04-23","2020-10-22","1351"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-05 11:13:29","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":["7775",1274,"SETTLED","C15-I208104","2020-05-05 11:13:28","2020-04-23","2","2020-05-05 11:13:28","2","2020-05-05 11:13:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:13:29","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":["8104","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-05-05 11:13:28","2","2020-05-05 11:13:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:13:29","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":["8104","RENT","\u9810\u7e73\u79df\u91d1",2,998,"MO","1",998,"2","2020-05-05 11:13:28","2","2020-05-05 11:13:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:13:29","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":["8104","RENT","\u9810\u7e73\u79df\u91d1",3,998,"MO","1",998,"2","2020-05-05 11:13:28","2","2020-05-05 11:13:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:13:29","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":["8104","RENT","\u9810\u7e73\u79df\u91d1",4,998,"MO","1",998,"2","2020-05-05 11:13:28","2","2020-05-05 11:13:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:13:29","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":["8104","RENT","\u9810\u7e73\u79df\u91d1",5,998,"MO","1",998,"2","2020-05-05 11:13:28","2","2020-05-05 11:13:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:13:29","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":["8104","RENT","\u9810\u7e73\u79df\u91d1",6,998,"MO","1",998,"2","2020-05-05 11:13:28","2","2020-05-05 11:13:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:13:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5988,0,"8104"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-05 11:13:29","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":[1274,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207749","2020-05-05 11:13:28",5988,"2","2020-05-05 11:13:28","2","2020-05-05 11:13:28","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:13:29","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":["7749","DEPOSIT",null,"PAID","2020-05-05 11:13:28",0,"2","2020-05-05 11:13:28","2","2020-05-05 11:13:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:13:29","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":["7749","INVOICE","8104","PAID","2020-05-05 11:13:28",5988,"2","2020-05-05 11:13:28","2","2020-05-05 11:13:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:16:09","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=3&filter2=2020-04-01&filter3=2020-04-09&page=3&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1008,"customer_code":"C181008","identity_type":"PERSONAL","identity_id":"K700926(7)","title":"Ms","lastname":"Cheng","firstname":"King","companyname":"","email":"dumpling_jing@hotmail.com","tel":"90989956","address":"FT F 60\/F Tower 2 , 38 Tai Hong Street, Grand Promenade , Sai Wan Ho, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1115.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-10","renew_room_key":"0005796877","renew_remark":"1 month contract. Storage rental paid by PPS on March 30, 2020. Storage deposit $2230 transferred from agreement C15-CT207313 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT207532, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"172","order_discount":[],"order_room":[{"room_id":"1408","room_code":"C15-102","retail_price":"1115.0","discounted_price":"1115.00","location_id":"6"}],"roughly_size":"20","total_retail_price":1115,"total_discounted_price":1115,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1115,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-10","rent_from":"2020-05-10","rent_to":"2020-06-09","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on April 29, 2020. Storage deposit $2230 transferred from agreement C15-CT207532 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1115,"final_order_total":1115,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0005796877","order_product":[],"pass":true}},"first_order_id":"3501","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-102 <\/td>\r\n\t\t\t\t\t 4X5X6.5 <\/td>\r\n\t\t\t\t\t $1115.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1115.0","deposit":"0","total_retail_price":"1115.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:16:09","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",1008,"NEW","C15-CT207776",1115,1115,0,0,"1","1",1115,1115,1115,"2020-05-05 11:16:09","0",null,null,null,"2020-05-10","2020-06-09","1 month contract. Storage rental paid by PPS on April 29, 2020. Storage deposit $2230 transferred from agreement C15-CT207532 to this agreement. \r\n","2020-05-10","20",0,null,0,"0","2","2020-05-05 11:16:09","2","2020-05-05 11:16:09","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0005796877","C181008","PERSONAL","Ms","pyScVxHN1bAPGGa\/Bucd1Q==","UCPBCXrBLI9U7KKsPqgmNA==","","LoTfAY\/7hsJ5LMg1lxRl5U61+y\/bHOn3mXXs4ZtLiTsKgr3U0XtRwxPFeprq+NiHAM+QrB+m5+WZ7R14dzMxe+z0ciqodfk7L3bAksKmsSI=","ODUJ\/sh5I9t4EANm7+m4qQ==","IK6uRSfHgYDvM30SfvOBrVdAXD9E++uXhp1WOnqnMIk=","0n\/HYQ\/ulfaXU7JBtiiVDg==",null,1,"3501"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:16:09","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":["7776","1408","1115.0","1115.00","2","2020-05-05 11:16:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:16:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-10","2020-06-09","1408"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-05 11:16:09","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":["7776",1008,"SETTLED","C15-I208105","2020-05-05 11:16:09","2020-05-10","2","2020-05-05 11:16:09","2","2020-05-05 11:16:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:16:09","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":["8105","RENT","\u9810\u7e73\u79df\u91d1",1,1115,"MO","1",1115,"2","2020-05-05 11:16:09","2","2020-05-05 11:16:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:16:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1115,0,"8105"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-05 11:16:09","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":[1008,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207750","2020-05-05 11:16:09",1115,"2","2020-05-05 11:16:09","2","2020-05-05 11:16:09","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:16:09","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":["7750","DEPOSIT",null,"PAID","2020-05-05 11:16:09",0,"2","2020-05-05 11:16:09","2","2020-05-05 11:16:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:16:09","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":["7750","INVOICE","8105","PAID","2020-05-05 11:16:09",1115,"2","2020-05-05 11:16:09","2","2020-05-05 11:16:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:19:10","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=3&filter2=2020-04-01&filter3=2020-04-09&page=3&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":652,"customer_code":"C170652","identity_type":"PERSONAL","identity_id":"D708260(7)","title":"Mr","lastname":"Tam","firstname":"Ming Kit ","companyname":"","email":"flyboy731@gmail.com","tel":"96525971","address":"Flat 5, 6\/f, Kong Wing Court Aberdeen Centre ","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1090.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-01","renew_room_key":"054,41837","renew_remark":"1 month contract. Storage rental paid by PPS on March 26, 2020. Storage deposit transferred from agreement A18-CT207305 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207521, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"77","order_discount":[],"order_room":[{"room_id":"837","room_code":"R11","retail_price":"1090.0","discounted_price":"1090.00","location_id":"3"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":1090,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1090,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-01","rent_from":"2020-05-01","rent_to":"2020-05-31","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on April 29, 2020. Storage deposit transferred from agreement A18-CT207521 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1090,"final_order_total":1090,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,41837","order_product":[],"pass":true}},"first_order_id":"4853","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> R11 <\/td>\r\n\t\t\t\t\t 3X4X7 <\/td>\r\n\t\t\t\t\t $1090.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"1090.0","deposit":"0","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:19:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",652,"NEW","A18-CT207777",1090,1090,0,0,"1","1",1090,1090,1090,"2020-05-05 11:19:10","0",null,null,null,"2020-05-01","2020-05-31","1 month contract. Storage rental paid by PPS on April 29, 2020. Storage deposit transferred from agreement A18-CT207521 to this agreement.\r\n","2020-05-01","12",0,null,0,"0","2","2020-05-05 11:19:10","2","2020-05-05 11:19:10","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,41837","C170652","PERSONAL","Mr","SNekCwopks2jcqexjcIyHg==","RAqogkelEKt1q5b\/6Neu\/g==","","n56ucwsCeMJCZJzkVQ6k1WBlpaRdIidZGXGL94XS5YnAhumcwszABrybE3YYUXEa","vWdjb89guDF+JdQiVIW+vA==","7jhdXQwxz0eVBJmxgK0I3558T6i6tRkWYOXpLO7HShk=","7ygY2utveKNtmE8VDaM3iw==",null,1,"4853"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:19:10","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":["7777","837","1090.0","1090.00","2","2020-05-05 11:19:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:19:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-01","2020-05-31","837"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-05 11:19:10","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":["7777",652,"SETTLED","A18-I208106","2020-05-05 11:19:10","2020-05-01","2","2020-05-05 11:19:10","2","2020-05-05 11:19:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:19:10","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":["8106","RENT","\u9810\u7e73\u79df\u91d1",1,1090,"MO","1",1090,"2","2020-05-05 11:19:10","2","2020-05-05 11:19:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:19:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1090,0,"8106"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-05 11:19:10","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":[652,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207751","2020-05-05 11:19:10",1090,"2","2020-05-05 11:19:10","2","2020-05-05 11:19:10","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:19:10","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":["7751","DEPOSIT",null,"PAID","2020-05-05 11:19:10",0,"2","2020-05-05 11:19:10","2","2020-05-05 11:19:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:19:10","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":["7751","INVOICE","8106","PAID","2020-05-05 11:19:10",1090,"2","2020-05-05 11:19:10","2","2020-05-05 11:19:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:37:27","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=3&filter2=2020-04-01&filter3=2020-04-09&page=3&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":681,"customer_code":"C180681","identity_type":"PERSONAL","identity_id":"K087413(2)","title":"Mr","lastname":"Chung","firstname":"Ka Po","companyname":"","email":"patrickbobofamily@gmail.com","tel":"63336887","address":"3\/F, Siu Fung Hong Building, 239-241 Wing Lok Street, Sheung Wan, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"965.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-02","renew_room_key":"056,05555","renew_remark":"1 month contract. Storage rental paid by PPS on March 30, 2020. Storage deposit transferred from agreement A18-CT207285 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207530, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"103","order_discount":[],"order_room":[{"room_id":"906","room_code":"U07","retail_price":"965.0","discounted_price":"965.00","location_id":"3"}],"roughly_size":"8","total_retail_price":965,"total_discounted_price":965,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":965,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-02","rent_from":"2020-05-02","rent_to":"2020-06-01","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on April 29, 2020. Storage deposit transferred from agreement A18-CT207530 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":965,"final_order_total":965,"location_id":"3","branch_id":"1","company_id":"1","room_key":"056,05555","order_product":[],"pass":true}},"first_order_id":"4704","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> U07 <\/td>\r\n\t\t\t\t\t 2X4X7 <\/td>\r\n\t\t\t\t\t $965.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"8","total_discounted_price":"965.0","deposit":"0","total_retail_price":"965.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:37:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",681,"NEW","A18-CT207778",965,965,0,0,"1","1",965,965,965,"2020-05-05 11:37:27","0",null,null,null,"2020-05-02","2020-06-01","1 month contract. Storage rental paid by PPS on April 29, 2020. Storage deposit transferred from agreement A18-CT207530 to this agreement.\r\n","2020-05-02","8",0,null,0,"0","2","2020-05-05 11:37:27","2","2020-05-05 11:37:27","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"056,05555","C180681","PERSONAL","Mr","WpXUsGIV5ZMagl9ab+XsmA==","ThKwrAIcvgN3JqAg+7\/isg==","","MfbxfJxu6rnCI3QT7TKkp941rf6ZLqXK4FI5VbVzAJiJni8uQnXc2gGJQSsyflI200jM1kVIWfocMiR8ixEVuOtN59H0aUN3N6cpSW\/Zb8g=","uk+aBM1pdnZq7uENadbWLg==","AlXt3dY1\/1B81wXwqLajny8WQO2W1oXWizWY\/cvTtlY=","ikLrZy69X3qkMVAoKWXxnQ==",null,1,"4704"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:37:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7778","906","965.0","965.00","2","2020-05-05 11:37:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:37:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-02","2020-06-01","906"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-05 11:37:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7778",681,"SETTLED","A18-I208107","2020-05-05 11:37:27","2020-05-02","2","2020-05-05 11:37:27","2","2020-05-05 11:37:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:37:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8107","RENT","\u9810\u7e73\u79df\u91d1",1,965,"MO","1",965,"2","2020-05-05 11:37:27","2","2020-05-05 11:37:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:37:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[965,0,"8107"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-05 11:37:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[681,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207752","2020-05-05 11:37:27",965,"2","2020-05-05 11:37:27","2","2020-05-05 11:37:27","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:37:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7752","DEPOSIT",null,"PAID","2020-05-05 11:37:27",0,"2","2020-05-05 11:37:27","2","2020-05-05 11:37:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:37:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7752","INVOICE","8107","PAID","2020-05-05 11:37:27",965,"2","2020-05-05 11:37:27","2","2020-05-05 11:37:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:47: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":"filter1=3&filter2=2020-04-01&filter3=2020-04-09&page=3&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":688,"customer_code":"C180688","identity_type":"PERSONAL","identity_id":"K122210(4)","title":"Mr","lastname":"Cheung","firstname":"Wai Yung","companyname":"","email":"yung912@gmail.com","tel":"92637806","address":"Rm A, 20\/F, Block 20, Mei Cheung Court, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1090.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-08","renew_room_key":"054,60450","renew_remark":"1 month contract. Storage rental paid by PPS on April 2, 2020. Storage deposit transferred from agreement A18-CT207310 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207565, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"77","order_discount":[],"order_room":[{"room_id":"813","room_code":"Q10","retail_price":"1090.0","discounted_price":"1090.00","location_id":"3"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":1090,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1090,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-08","rent_from":"2020-05-08","rent_to":"2020-06-07","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on May 4, 2020. Storage deposit transferred from agreement A18-CT207565 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1090,"final_order_total":1090,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,60450","order_product":[],"pass":true}},"first_order_id":"4769","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> Q10 <\/td>\r\n\t\t\t\t\t 3X4X7 <\/td>\r\n\t\t\t\t\t $1090.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"1090.0","deposit":"0","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:47:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",688,"NEW","A18-CT207779",1090,1090,0,0,"1","1",1090,1090,1090,"2020-05-05 11:47:23","0",null,null,null,"2020-05-08","2020-06-07","1 month contract. Storage rental paid by PPS on May 4, 2020. Storage deposit transferred from agreement A18-CT207565 to this agreement.\r\n","2020-05-08","12",0,null,0,"0","2","2020-05-05 11:47:22","2","2020-05-05 11:47:22","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,60450","C180688","PERSONAL","Mr","w+3oxtOYocerQ225PhLj2Q==","vCxOlXQuvOQaoL822H2o\/Q==","","QvNFWPnZK2SY5iOuJxtofiF6G+A71It3PRUQIo0auvIWzvBTZRm2wfB\/VYgB4L2eWR9M0rvXLhbVNAUw9JyOPpQPVCto6YLfO\/ESHYYW+OA=","+JEnloGcmAHQH7QI0dDDrg==","KssyFPR1OHCnH1SYGPPT\/JDvr7I47++6Ndv+5eVj1fE=","OGIBS1CZsN25WARbNGD97w==",null,1,"4769"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:47:23","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":["7779","813","1090.0","1090.00","2","2020-05-05 11:47:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:47:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-08","2020-06-07","813"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-05 11:47:23","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":["7779",688,"SETTLED","A18-I208108","2020-05-05 11:47:22","2020-05-08","2","2020-05-05 11:47:22","2","2020-05-05 11:47:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:47:23","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":["8108","RENT","\u9810\u7e73\u79df\u91d1",1,1090,"MO","1",1090,"2","2020-05-05 11:47:22","2","2020-05-05 11:47:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:47:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1090,0,"8108"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-05 11:47:23","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":[688,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207753","2020-05-05 11:47:22",1090,"2","2020-05-05 11:47:22","2","2020-05-05 11:47:22","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:47:23","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":["7753","DEPOSIT",null,"PAID","2020-05-05 11:47:22",0,"2","2020-05-05 11:47:22","2","2020-05-05 11:47:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:47:23","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":["7753","INVOICE","8108","PAID","2020-05-05 11:47:22",1090,"2","2020-05-05 11:47:22","2","2020-05-05 11:47:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:49:32","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=3&filter2=2020-04-01&filter3=2020-04-09&page=3&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":807,"customer_code":"C180807","identity_type":"PERSONAL","identity_id":"K546620(2)","title":"Mr","lastname":"Choy","firstname":"Chung Kit","companyname":"","email":"chung.greatoo@gmail.com","tel":"65722444","address":"Flat F, 17\/F, Pokfulam Gardens, Pok Fu Lam, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1342.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-26","renew_room_key":"072,57038","renew_remark":"1 month contract. Storage rental paid by bank transfer on March 30, 2020. Storage deposit transferred from agreement A14-CT207281 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207533, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"68","order_discount":[],"order_room":[{"room_id":"526","room_code":"L04(\u670d\u88dd\u5009)","retail_price":"1342.0","discounted_price":"1342.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1342,"total_discounted_price":1342,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1342,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-26","rent_from":"2020-04-26","rent_to":"2020-05-25","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on May 4, 2020. Storage deposit transferred from agreement A14-CT207533 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1342,"final_order_total":1342,"location_id":"2","branch_id":"1","company_id":"1","room_key":"072,57038","order_product":[],"pass":true}},"first_order_id":"4859","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> L04(\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>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1342.0","deposit":"0","total_retail_price":"1342.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:49:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",807,"NEW","A14-CT207780",1342,1342,0,0,"1","1",1342,1342,1342,"2020-05-05 11:49:32","0",null,null,null,"2020-04-26","2020-05-25","1 month contract. Storage rental paid by PPS on May 4, 2020. Storage deposit transferred from agreement A14-CT207533 to this agreement.\r\n","2020-04-26","16",0,null,0,"0","2","2020-05-05 11:49:32","2","2020-05-05 11:49:32","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"072,57038","C180807","PERSONAL","Mr","UrB+L8vaPiEMZevupuoWEA==","UrsMAvfb5x9QBcnJ8435JA==","","ME0hoxN9uZ9kGpx7EDhDMplFp1dDf6LAd2zTCgZuVMA07NK1aBM+okfJHxxQhQeMEGMyIA8TbBMZxd3bYkNlpA==","yzkFlVLEWHluqrSaK6I+5w==","D5Tn0rsTf6KebW06OoCf5+7qkW80yY20kTJlXh0yutU=","SXzqecVFjMModfNH2tMtyQ==",null,1,"4859"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:49:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7780","526","1342.0","1342.00","2","2020-05-05 11:49:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:49:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-26","2020-05-25","526"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-05 11:49:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7780",807,"SETTLED","A14-I208109","2020-05-05 11:49:32","2020-04-26","2","2020-05-05 11:49:32","2","2020-05-05 11:49:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:49:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8109","RENT","\u9810\u7e73\u79df\u91d1",1,1342,"MO","1",1342,"2","2020-05-05 11:49:32","2","2020-05-05 11:49:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:49:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1342,0,"8109"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-05 11:49:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[807,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207754","2020-05-05 11:49:32",1342,"2","2020-05-05 11:49:32","2","2020-05-05 11:49:32","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:49:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7754","DEPOSIT",null,"PAID","2020-05-05 11:49:32",0,"2","2020-05-05 11:49:32","2","2020-05-05 11:49:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:49:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7754","INVOICE","8109","PAID","2020-05-05 11:49:32",1342,"2","2020-05-05 11:49:32","2","2020-05-05 11:49:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:55:27","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=3&filter2=2020-04-01&filter3=2020-04-09&page=3&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1131,"customer_code":"C181131","identity_type":"PERSONAL","identity_id":"Z345376(7)","title":"Mr","lastname":"Chan","firstname":"Siu Cheung","companyname":"","email":"siucheung2004@yahoo.com.hk","tel":"98251393","address":"Room 2204, Tung On House, Lei Tung Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-03","renew_room_key":"0005012995","renew_remark":"1 month contract. Storage rental paid by PPS on April 3, 2020. Storage deposit transferred from agreement A05-CT207379 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207585, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"110","order_discount":[],"order_room":[{"room_id":"1077","room_code":"A05-075","retail_price":"598.0","discounted_price":"598.00","location_id":"4"}],"roughly_size":"8","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-03","rent_from":"2020-05-03","rent_to":"2020-06-02","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on May 4, 2020. Storage deposit transferred from agreement A05-CT207585 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0005012995","order_product":[],"pass":true}},"first_order_id":"4845","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-075 <\/td>\r\n\t\t\t\t\t 4X2X3.5 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \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":"8","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:55:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1131,"NEW","A05-CT207781",598,598,0,0,"1","1",598,598,598,"2020-05-05 11:55:27","0",null,null,null,"2020-05-03","2020-06-02","1 month contract. Storage rental paid by PPS on May 4, 2020. Storage deposit transferred from agreement A05-CT207585 to this agreement.\r\n","2020-05-03","8",0,null,0,"0","2","2020-05-05 11:55:27","2","2020-05-05 11:55:27","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0005012995","C181131","PERSONAL","Mr","fGcZizJCatuKFWu4ZRrKSA==","U9yoE9KqV1v8YlRkf7Q2yg==","","CQCYoAe3GOoadJVRzLyv+sNtTDGIle0HVMeR83McsJynyrP8tFX204cW64FCZ5NA5j\/z2cPdugPvlnA2Si9a8Q==","9k5P13X5Z+o0UYFE5+2bdg==","ApBLMJPz\/Z49uwpRoZz00ngQMrV7EI2jJmIQp3ku3DM=","EdsRFjojZ1QPZDY\/kWek4g==",null,1,"4845"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:55:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7781","1077","598.0","598.00","2","2020-05-05 11:55:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:55:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-03","2020-06-02","1077"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-05 11:55:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7781",1131,"SETTLED","A05-I208110","2020-05-05 11:55:27","2020-05-03","2","2020-05-05 11:55:27","2","2020-05-05 11:55:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:55:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8110","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-05-05 11:55:27","2","2020-05-05 11:55:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:55:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8110"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-05 11:55:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1131,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207755","2020-05-05 11:55:27",598,"2","2020-05-05 11:55:27","2","2020-05-05 11:55:27","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:55:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7755","DEPOSIT",null,"PAID","2020-05-05 11:55:27",0,"2","2020-05-05 11:55:27","2","2020-05-05 11:55:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:55:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7755","INVOICE","8110","PAID","2020-05-05 11:55:27",598,"2","2020-05-05 11:55:27","2","2020-05-05 11:55:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:57: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":"filter1=3&filter2=2020-04-01&filter3=2020-04-09&page=3&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1301,"customer_code":"C191301","identity_type":"PERSONAL","identity_id":"K08388(5)","title":"Ms","lastname":"Kwan","firstname":"Yuen Yee Amy","companyname":"","email":"akyyhk@yahoo.com","tel":"92750360","address":"Flat L, 9\/F, Blk 5, Hong Sing Garden, Tseung Kwan O, N.T.","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-16","renew_room_key":"111,40893","renew_remark":"1 month contract. Storage rental paid by PPS on April 14, 2020. Storage deposit transferred from agreement A16-CT207418 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT207635, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"202","order_discount":[],"order_room":[{"room_id":"1519","room_code":"A16-028","retail_price":"1290.0","discounted_price":"1290.00","location_id":"7"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1290,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-16","rent_from":"2020-05-16","rent_to":"2020-06-15","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on May 4, 2020. Storage deposit transferred from agreement A16-CT207635 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"7","branch_id":"1","company_id":"1","room_key":"111,40893","order_product":[],"pass":true}},"first_order_id":"5235","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A16-028 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:57:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","7",1301,"NEW","A16-CT207782",1290,1290,0,0,"1","1",1290,1290,1290,"2020-05-05 11:57:38","0",null,null,null,"2020-05-16","2020-06-15","1 month contract. Storage rental paid by PPS on May 4, 2020. Storage deposit transferred from agreement A16-CT207635 to this agreement.\r\n","2020-05-16","16",0,null,0,"0","2","2020-05-05 11:57:37","2","2020-05-05 11:57:37","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"111,40893","C191301","PERSONAL","Ms","5wigC8kzb56lGRRSAEYGsw==","iNwdG3Dj3OBaAQ6MRfBM1w==","","\/Ewh1holgp6WSTJa\/JHYhYvoqKRvnYtpL3yQk4vYZf\/xWDWin6QHzWL6hMnAUJ4T8XbSzfh5jMoFXOktD1XRYw==","YESwwapoFqF3cRsBQ+uG6A==","G8w9ZbnhyRcx0XoYCRwUCjIw8+4PSVsFNffrrS+i8x4=","kt7RlFLP4CUDPa9sfSXSrg==",null,1,"5235"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:57:38","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":["7782","1519","1290.0","1290.00","2","2020-05-05 11:57:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:57:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-16","2020-06-15","1519"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-05 11:57:38","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":["7782",1301,"SETTLED","A16-I208111","2020-05-05 11:57:37","2020-05-16","2","2020-05-05 11:57:37","2","2020-05-05 11:57:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:57:38","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":["8111","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-05-05 11:57:37","2","2020-05-05 11:57:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:57:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"8111"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-05 11:57:38","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":[1301,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207756","2020-05-05 11:57:37",1290,"2","2020-05-05 11:57:37","2","2020-05-05 11:57:37","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:57:38","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":["7756","DEPOSIT",null,"PAID","2020-05-05 11:57:37",0,"2","2020-05-05 11:57:37","2","2020-05-05 11:57:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 11:57:38","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":["7756","INVOICE","8111","PAID","2020-05-05 11:57:37",1290,"2","2020-05-05 11:57:37","2","2020-05-05 11:57:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 12:10:25","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=3&filter2=2020-04-01&filter3=2020-04-09&page=3&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":392,"customer_code":"C170392","identity_type":"PERSONAL","identity_id":"P988279(4)","title":"Mr","lastname":"Lee","firstname":"Kenneth Pak Lok","companyname":"","email":"kenneth_P_Lee@yahoo.com","tel":"69712837","address":"Flat B,22\/F,Tower 2,Sham Wan Towers 3 Ap Lei Chau Drive, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"5098.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-01","renew_room_key":"138,17024","renew_remark":"1 month contract. Storage rental paid by PPS on April 1, 2020. Storage deposit transferred from agreement A12-CT207316 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207551, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[{"master_room_discount_id":"76","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1376.00","discount":"9.95","monthly_deduct":152.036,"room_id":"106","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"76","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1376.00","discount":"9.95","monthly_deduct":152.036,"room_id":"115","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"76","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1376.00","discount":"9.95","monthly_deduct":152.036,"room_id":"114","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"76","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1376.00","discount":"9.95","monthly_deduct":152.036,"room_id":"105","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"115","room_code":"B63","retail_price":"1528.0","discounted_price":1376,"location_id":"1"},{"room_id":"114","room_code":"B62","retail_price":"1528.0","discounted_price":1376,"location_id":"1"},{"room_id":"106","room_code":"B54","retail_price":"1528.0","discounted_price":1376,"location_id":"1"},{"room_id":"105","room_code":"B53","retail_price":"1528.0","discounted_price":1376,"location_id":"1"}],"roughly_size":"80","total_retail_price":6112,"total_discounted_price":4335,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":26010,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-01","rent_from":"2020-05-01","rent_to":"2020-10-31","delivery_service":"0","remark":"6 month contract. Special offer $4335\/month. Storage rental paid by PPS on May 4, 2020. Storage deposit transferred from agreement A12-CT207551 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":26010,"final_order_total":26010,"location_id":"1","branch_id":"1","company_id":"1","room_key":"138,17024","order_product":[],"pass":true}},"first_order_id":"3904","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\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> B63 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.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> B62 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.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> B54 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.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> B53 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.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":"80","total_discounted_price":"4335.00","deposit":"0.00","total_retail_price":"6112.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 12:10: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",392,"NEW","A12-CT207783",6112,4335,0,0,"6","6",26010,26010,26010,"2020-05-05 12:10:26","0",null,null,null,"2020-05-01","2020-10-31","6 month contract. Special offer $4335\/month. Storage rental paid by PPS on May 4, 2020. Storage deposit transferred from agreement A12-CT207551 to this agreement. \r\n","2020-05-01","80",0,null,0,"0","2","2020-05-05 12:10:25","2","2020-05-05 12:10:25","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"138,17024","C170392","PERSONAL","Mr","BEeVus+G60XJp0DLlFrw5Q==","kiriEIqhcx866RNZiMXdKQ==","","VBX\/XdmRdgqhOmFZK5ALSyxeI8iku\/iH07d+anuZyhubwt\/HaXR\/HjzcA3Wmmw6VBgIGznHH4FxYZNbCfAjNaYs6u2AtWPKHmRXPxCIWvd4=","u2w9koTKJQGsIdFvv8jAeA==","L4egO5Mnnt0ETYeC+58eDoCS0BetZV+b23ZS6nqWBBs=","1A9B3kdXJoFpDPdlSZGM4g==",null,1,"3904"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 12:10:26","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":["7783","76","10","106","%","9.95",152.036,"2","2020-05-05 12:10:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 12:10:26","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":["7783","76","10","115","%","9.95",152.036,"2","2020-05-05 12:10:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 12:10:26","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":["7783","76","10","114","%","9.95",152.036,"2","2020-05-05 12:10:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 12:10:26","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":["7783","76","10","105","%","9.95",152.036,"2","2020-05-05 12:10:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 12:10: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":["7783","115","1528.0",1376,"2","2020-05-05 12:10:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 12:10: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-05-01","2020-10-31","115"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-05 12:10: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":["7783","114","1528.0",1376,"2","2020-05-05 12:10:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 12:10: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-05-01","2020-10-31","114"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-05 12:10: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":["7783","106","1528.0",1376,"2","2020-05-05 12:10:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 12:10: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-05-01","2020-10-31","106"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-05 12:10: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":["7783","105","1528.0",1376,"2","2020-05-05 12:10:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 12:10: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-05-01","2020-10-31","105"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-05 12:10: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":["7783",392,"SETTLED","A12-I208112","2020-05-05 12:10:25","2020-05-01","2","2020-05-05 12:10:25","2","2020-05-05 12:10:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 12:10: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":["8112","RENT","\u9810\u7e73\u79df\u91d1",1,4335,"MO","1",4335,"2","2020-05-05 12:10:25","2","2020-05-05 12:10:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 12:10: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":["8112","RENT","\u9810\u7e73\u79df\u91d1",2,4335,"MO","1",4335,"2","2020-05-05 12:10:25","2","2020-05-05 12:10:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 12:10: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":["8112","RENT","\u9810\u7e73\u79df\u91d1",3,4335,"MO","1",4335,"2","2020-05-05 12:10:25","2","2020-05-05 12:10:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 12:10: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":["8112","RENT","\u9810\u7e73\u79df\u91d1",4,4335,"MO","1",4335,"2","2020-05-05 12:10:25","2","2020-05-05 12:10:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 12:10: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":["8112","RENT","\u9810\u7e73\u79df\u91d1",5,4335,"MO","1",4335,"2","2020-05-05 12:10:25","2","2020-05-05 12:10:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 12:10: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":["8112","RENT","\u9810\u7e73\u79df\u91d1",6,4335,"MO","1",4335,"2","2020-05-05 12:10:25","2","2020-05-05 12:10:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 12:10:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[26010,0,"8112"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-05 12:10: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":[392,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207757","2020-05-05 12:10:25",26010,"2","2020-05-05 12:10:25","2","2020-05-05 12:10:25","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 12:10: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":["7757","DEPOSIT",null,"PAID","2020-05-05 12:10:25",0,"2","2020-05-05 12:10:25","2","2020-05-05 12:10:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 12:10: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":["7757","INVOICE","8112","PAID","2020-05-05 12:10:25",26010,"2","2020-05-05 12:10:25","2","2020-05-05 12:10:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 12:12:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 12:12:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:32:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:35:59","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=808&filter3=undefined","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":808,"customer_code":"C180808","identity_type":"PERSONAL","identity_id":"D114107(5)","title":"Ms","lastname":"Ng","firstname":"Siu Chun","companyname":"","email":null,"tel":"93515525","address":"Flat 903, Tung Ping House, Lei Tung Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"6","renew_warehousing_date":"2020-04-28","renew_room_key":"055,40654","renew_remark":"6 months contract. Storage rental paid by cash on Nov 12, 2019. Storage deposit transferred from agreement A14-CT195168 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196373, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"617","room_code":"M28","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-28","rent_from":"2020-04-28","rent_to":"2020-10-27","delivery_service":"0","remark":"6 months contract. Storage rental paid by EPS on May 05,2020. Storage deposit transferred from agreement A14-CT196373 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,40654","order_product":[],"pass":true}},"first_order_id":"4654","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> M28 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"538.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:35:59","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",808,"NEW","A14-CT207784",598,538,0,0,"6","6",3228,3228,3228,"2020-05-05 15:35:59","0",null,null,null,"2020-04-28","2020-10-27","6 months contract. Storage rental paid by EPS on May 05,2020. Storage deposit transferred from agreement A14-CT196373 to this agreement.","2020-04-28","12",0,null,0,"0","2","2020-05-05 15:35:59","2","2020-05-05 15:35:59","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"055,40654","C180808","PERSONAL","Ms","LmaXsK026kNlbTZPD4fV0A==","cxr02xsD1tXvJ4ihJHZKWw==","","hpstB0eNEL0X0aKz8YSf533xErsjEzfXkkfjzbuIu496QAvHkLq4mkHG5gfr7cJcSCKyZ9sx3WpAq+oEvsuqejgLpDh\/I9M0vy6pFhV6vYg=","\/2ck84sC33rXEUoZqHwLsg==",null,"Qc\/dtBW6maIPRZJWnj6pfA==",null,1,"4654"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:35:59","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":["7784","617","598.0","598.00","2","2020-05-05 15:35:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:35:59","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-04-28","2020-10-27","617"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-05 15:35:59","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":["7784",808,"SETTLED","A14-I208113","2020-05-05 15:35:59","2020-04-28","2","2020-05-05 15:35:59","2","2020-05-05 15:35:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:35:59","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":["8113","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-05-05 15:35:59","2","2020-05-05 15:35:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:35:59","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":["8113","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-05-05 15:35:59","2","2020-05-05 15:35:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:35:59","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":["8113","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-05-05 15:35:59","2","2020-05-05 15:35:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:35:59","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":["8113","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-05-05 15:35:59","2","2020-05-05 15:35:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:35:59","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":["8113","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-05-05 15:35:59","2","2020-05-05 15:35:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:35:59","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":["8113","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-05-05 15:35:59","2","2020-05-05 15:35:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:35:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"8113"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-05 15:35:59","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":[808,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207758","2020-05-05 15:35:59",3228,"2","2020-05-05 15:35:59","2","2020-05-05 15:35:59","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:35:59","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":["7758","DEPOSIT",null,"PAID","2020-05-05 15:35:59",0,"2","2020-05-05 15:35:59","2","2020-05-05 15:35:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:35:59","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":["7758","INVOICE","8113","PAID","2020-05-05 15:35:59",3228,"2","2020-05-05 15:35:59","2","2020-05-05 15:35:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:50:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:52:15","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":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":724,"customer_code":"C180724","identity_type":"PERSONAL","identity_id":"D488390(0)","title":"Mr","lastname":"Chan","firstname":"Kai Ming Johnny","companyname":"","email":"ckmjohnny@gmail.com","tel":"92855920","address":"Room 922, Wah Cheong House, Wah Fu Estate, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2058.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-05","renew_room_key":"054,32853","renew_remark":"1 month contract. Storage rental paid by PPS on April 2, 2020. Storage deposit transferred from agreement A12-CT207323 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207564, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"321","room_code":"F06","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"332","room_code":"F17","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"28","total_retail_price":2096,"total_discounted_price":2058,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2058,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-05","rent_from":"2020-05-05","rent_to":"2020-06-04","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on May 4, 2020. Storage deposit transferred from agreement A12-CT207564 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":2058,"final_order_total":2058,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,32853","order_product":[],"pass":true}},"first_order_id":"4888","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> F06 <\/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> F17 <\/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\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":"28","total_discounted_price":"2058.0","deposit":"0","total_retail_price":"2096.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:52:16","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",724,"NEW","A12-CT207785",2096,2058,0,0,"1","1",2058,2058,2058,"2020-05-05 15:52:16","0",null,null,null,"2020-05-05","2020-06-04","1 month contract. Storage rental paid by PPS on May 4, 2020. Storage deposit transferred from agreement A12-CT207564 to this agreement.\r\n","2020-05-05","28",0,null,0,"0","2","2020-05-05 15:52:15","2","2020-05-05 15:52:15","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,32853","C180724","PERSONAL","Mr","S2Y\/+hrua6snugCiRVXC+g==","U9yoE9KqV1v8YlRkf7Q2yg==","","k+e0QYxm9l5HuoQuXakgBNnw8UW4n+ZLcCG9eEWYCG3GGUVs8OcyHqJxZXBRIAQ7e4G25Jwv46TjFMKIeqmD6Q==","uIJTfVK37Ukw\/PebwnT1DA==","HVGIbYlde5F3OKyLRPpR9QsuoR+xNkr5wlpbBQugV6E=","tHG2eMtIkTmRjccZ2JJ3PQ==",null,1,"4888"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:52:16","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":["7785","321","998.0","998.00","2","2020-05-05 15:52:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:52:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-05","2020-06-04","321"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-05 15:52:16","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":["7785","332","1098.0","1098.00","2","2020-05-05 15:52:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:52:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-05","2020-06-04","332"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-05 15:52:16","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":["7785",724,"SETTLED","A12-I208114","2020-05-05 15:52:15","2020-05-05","2","2020-05-05 15:52:15","2","2020-05-05 15:52:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:52:16","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":["8114","RENT","\u9810\u7e73\u79df\u91d1",1,2058,"MO","1",2058,"2","2020-05-05 15:52:15","2","2020-05-05 15:52:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:52:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2058,0,"8114"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-05 15:52:16","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":[724,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207759","2020-05-05 15:52:15",2058,"2","2020-05-05 15:52:15","2","2020-05-05 15:52:15","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:52:16","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":["7759","DEPOSIT",null,"PAID","2020-05-05 15:52:15",0,"2","2020-05-05 15:52:15","2","2020-05-05 15:52:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:52:16","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":["7759","INVOICE","8114","PAID","2020-05-05 15:52:15",2058,"2","2020-05-05 15:52:15","2","2020-05-05 15:52:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:54:35","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","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":888,"customer_code":"C180888","identity_type":"PERSONAL","identity_id":"K099955(5)","title":"Ms","lastname":"Ho","firstname":"Man Yee Cherie","companyname":"","email":"cheriehmy@gmail.com","tel":"90575456","address":"Flat A, 1\/F, Block 9, Fullview Garden, 18 Siu Sai Wan Road, Siu Sai Wan, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1488.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-06","renew_room_key":"0005763937","renew_remark":"1 month contract. Storage rental paid by PPS on April 3, 2020. Storage deposit $2976 transferred from agreement B01-CT207327 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT207586, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"143","order_discount":[],"order_room":[{"room_id":"1274","room_code":"B01-084","retail_price":"1488.0","discounted_price":"1488.00","location_id":"5"}],"roughly_size":"24","total_retail_price":1488,"total_discounted_price":1488,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1488,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-06","rent_from":"2020-05-06","rent_to":"2020-06-05","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on May 4, 2020. Storage deposit $2976 transferred from agreement B01-CT207586 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1488,"final_order_total":1488,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0005763937","order_product":[],"pass":true}},"first_order_id":"4797","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-084 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1488.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\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":"24","total_discounted_price":"1488.0","deposit":"0","total_retail_price":"1488.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:54:35","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",888,"NEW","B01-CT207786",1488,1488,0,0,"1","1",1488,1488,1488,"2020-05-05 15:54:35","0",null,null,null,"2020-05-06","2020-06-05","1 month contract. Storage rental paid by PPS on May 4, 2020. Storage deposit $2976 transferred from agreement B01-CT207586 to this agreement.\r\n","2020-05-06","24",0,null,0,"0","2","2020-05-05 15:54:35","2","2020-05-05 15:54:35","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0005763937","C180888","PERSONAL","Ms","B6XcmzmDA9cWki+qLStEaA==","D\/skxQ5s\/L5yyRWaDK\/iSg==","","zb+wEJU2BcjiqagYCnyRNQzS3jTcz1KQCkGgLWtY\/y+C8KU+srfsdCNTrRUrjSHTpRbkV0JFumXQh3K4klaHUNKIaPzoQH6Ro1qQAUtDwWHyil1VPuPOWLDOdLKNt30K","Mv9sZMBZUVgbHGVZIxyZfQ==","d8Ms1Ternr8fasYV7yyV8x0bubUdhthIhbdOyphH3tQ=","b0wVwk81Vh1dF13X\/TkOaw==",null,1,"4797"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:54:35","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":["7786","1274","1488.0","1488.00","2","2020-05-05 15:54:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:54:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-06","2020-06-05","1274"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-05 15:54:35","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":["7786",888,"SETTLED","B01-I208115","2020-05-05 15:54:35","2020-05-06","2","2020-05-05 15:54:35","2","2020-05-05 15:54:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:54:35","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":["8115","RENT","\u9810\u7e73\u79df\u91d1",1,1488,"MO","1",1488,"2","2020-05-05 15:54:35","2","2020-05-05 15:54:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:54:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1488,0,"8115"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-05 15:54:35","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":[888,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207760","2020-05-05 15:54:35",1488,"2","2020-05-05 15:54:35","2","2020-05-05 15:54:35","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:54:35","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":["7760","DEPOSIT",null,"PAID","2020-05-05 15:54:35",0,"2","2020-05-05 15:54:35","2","2020-05-05 15:54:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 15:54:35","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":["7760","INVOICE","8115","PAID","2020-05-05 15:54:35",1488,"2","2020-05-05 15:54:35","2","2020-05-05 15:54:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 16:42:35","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ?, `customer_companyname` = ? where id = ?","parameters":["NEW","'0012415064","12 months contract. Special offer the 11th and 12th months free. Storage rental and deposit paid by bank transfer on Apr 18,2020. Smart card paid on the same day.","2020-05-05 16:42:35","2","njl5Lx5qDFHpqhsximKa\/w==","CLdPcdOLHcCn35qFN+q1pA==","lm2v6hTwvDXBvutBjA39Yg==","rVMZFcDXyY2EKmNqsjGP+baAGw0IflBQPS3oBDxPJnqrm6PLWhYXyKyrrZdyRDi76D22pUVQVlNNH+QVnPrpNJ+ruNhCndzFtPrJwnHs\/40=","Advanced Therapy Center Limited",7670]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 18:06:57","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":950,"customer_code":"C180950","identity_type":"PERSONAL","identity_id":"M096081(6)","title":"Mr","lastname":"Vincelli","firstname":"Stefano","companyname":"","email":"sabiobra@hotmail.com","tel":"95652114","address":"35 Happy View Terrace, Happy Valley, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4116.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-03","renew_room_key":"076,29154","renew_remark":"1 month contract. Storage rental paid by bank transfer on February 4, 2020. Storage deposit transferred from agreement A14-CT207153 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207398, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"58","order_discount":[],"order_room":[{"room_id":"417","room_code":"I08","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"424","room_code":"J06","retail_price":"2888.0","discounted_price":"2888.00","location_id":"2"}],"roughly_size":"56","total_retail_price":3986,"total_discounted_price":4116,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":4116,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-03","rent_from":"2020-04-03","rent_to":"2020-05-02","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on March, 2020. Storage deposit transferred from agreement A14-CT207398 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4116,"final_order_total":4116,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,29154","order_product":[],"pass":true}},"first_order_id":"4680","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> I08 <\/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> J06 <\/td>\r\n\t\t\t\t\t 5X8X8 <\/td>\r\n\t\t\t\t\t $2888.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \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":"56","total_discounted_price":"4116.0","deposit":"0","total_retail_price":"3986.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 18:06:58","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",950,"NEW","A14-CT207787",3986,4116,0,0,"1","1",4116,4116,4116,"2020-05-05 18:06:58","0",null,null,null,"2020-04-03","2020-05-02","1 month contract. Storage rental paid by bank transfer on March, 2020. Storage deposit transferred from agreement A14-CT207398 to this agreement.\r\n","2020-04-03","56",0,null,0,"0","2","2020-05-05 18:06:57","2","2020-05-05 18:06:57","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,29154","C180950","PERSONAL","Mr","kBtwICYFFgkwWiGlHlA7Vg==","J9AQQ+eusxRuMi9Uwswx2w==","","xpCmz6ayhnKM9CeubIeX46ST4OH8jL8leoh\/7rF5LKq0NI4lQzsUw3z+sKEaA2Q2","HMxniP6OLhRLykg\/y72g1w==","G2oqjsMfynuJ5hF7HR+cYPuapiwUrw6QQkLUvHZtFiE=","LjEwev8Vn2pWAe0zRvbXAw==",null,1,"4680"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 18:06:58","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":["7787","417","1098.0","1098.00","2","2020-05-05 18:06:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 18:06:58","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-04-03","2020-05-02","417"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-05 18:06:58","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":["7787","424","2888.0","2888.00","2","2020-05-05 18:06:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 18:06:58","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-04-03","2020-05-02","424"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-05 18:06:58","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":["7787",950,"SETTLED","A14-I208116","2020-05-05 18:06:57","2020-04-03","2","2020-05-05 18:06:57","2","2020-05-05 18:06:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 18:06:58","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":["8116","RENT","\u9810\u7e73\u79df\u91d1",1,4116,"MO","1",4116,"2","2020-05-05 18:06:57","2","2020-05-05 18:06:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 18:06:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4116,0,"8116"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-05 18:06:58","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":[950,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207761","2020-05-05 18:06:57",4116,"2","2020-05-05 18:06:57","2","2020-05-05 18:06:57","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 18:06:58","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":["7761","DEPOSIT",null,"PAID","2020-05-05 18:06:57",0,"2","2020-05-05 18:06:57","2","2020-05-05 18:06:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 18:06:58","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":["7761","INVOICE","8116","PAID","2020-05-05 18:06:57",4116,"2","2020-05-05 18:06:57","2","2020-05-05 18:06:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 19:06:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 21:11:06","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-05 21:11:18","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****