{"created_at":"2020-07-08 10:35:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:07:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:09:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:10:05","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&filter1=0&filter2=1539&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":"1750","master_room_id":"232","room_code":"WC-19"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":663,"customer_code":"C170663","identity_type":"PERSONAL","identity_id":"D302826(8)","title":"Ms","lastname":"Chu","firstname":"Lai Ngan ","companyname":"","email":null,"tel":"91216789","address":"Flat E, 13\/F, Tower 8, South Horizons, Ap Lei Chau","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1605.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-27","renew_room_key":"055,06790","renew_remark":"1 month contract. Storage rental paid by bank transfer on JUNE 1, 2020. Storage deposit transferred from agreement A18-CT207739 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT208184, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"78","order_discount":[],"order_room":[{"room_id":"939","room_code":"V13","retail_price":"1605.0","discounted_price":"1605.00","location_id":"3"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1605,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1605,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-27","rent_from":"2020-06-27","rent_to":"2020-07-26","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Jul 6, 2020. Storage deposit transferred from agreement A18-CT208184 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1605,"final_order_total":1605,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,06790","order_product":[],"pass":true}},"first_order_id":"7493","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>
V13 <\/td>\r\n\t\t\t\t\t	4X5X7 <\/td>\r\n\t\t\t\t\t	$1605.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1605.0","deposit":"0","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:10:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",663,"NEW","A18-CT208329",1605,1605,0,0,"1","1",1605,1605,1605,"2020-07-08 11:10:06","0",null,null,null,"2020-06-27","2020-07-26","1 month contract. Storage rental paid by bank transfer on Jul 6, 2020. Storage deposit transferred from agreement A18-CT208184 to this agreement.\r\n","2020-06-27","20",0,null,0,"0","2","2020-07-08 11:10:05","2","2020-07-08 11:10:05","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,06790","C170663","PERSONAL","Ms","+hf2BdEzeyuAlJ9o86BQkA==","uwdKi3S38jh5+tBibXKG4A==","","ZkyPYW\/X9p1lPTh\/bKU+\/PiAtXClt+yHReh+airMmSnG6Uwc2BRo5SF4sycqncKB\/EoNyhigJWrejarCTwNPAg==","q3\/rgHjoH\/vhcz82yJ8JGA==",null,"x7LEi0saK+ePsbHhJKXpDQ==",null,1,"7493"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:10: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":["8329","939","1605.0","1605.00","2","2020-07-08 11:10:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:10:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-27","2020-07-26","939"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-08 11:10: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":["8329",663,"SETTLED","A18-I208658","2020-07-08 11:10:05","2020-06-27","2","2020-07-08 11:10:05","2","2020-07-08 11:10:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:10: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":["8658","RENT","\u9810\u7e73\u79df\u91d1",1,1605,"MO","1",1605,"2","2020-07-08 11:10:05","2","2020-07-08 11:10:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:10:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1605,0,"8658"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-08 11:10: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":[663,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208301","2020-07-08 11:10:05",1605,"2","2020-07-08 11:10:05","2","2020-07-08 11:10:05","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:10: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":["8301","DEPOSIT",null,"PAID","2020-07-08 11:10:05",0,"2","2020-07-08 11:10:05","2","2020-07-08 11:10:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:10: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":["8301","INVOICE","8658","PAID","2020-07-08 11:10:05",1605,"2","2020-07-08 11:10:05","2","2020-07-08 11:10:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:15:26","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&filter1=0&filter2=1539&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":"1750","master_room_id":"232","room_code":"WC-19"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":663,"customer_code":"C170663","identity_type":"PERSONAL","identity_id":"D302826(8)","title":"Ms","lastname":"Chu","firstname":"Lai Ngan ","companyname":"","email":null,"tel":"91216789","address":"Flat E, 13\/F, Tower 8, South Horizons, Ap Lei Chau","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-01","renew_room_key":"055,06790","renew_remark":"1 month contract. Storage rental paid by bank transfer on June 1, 2020. Storage deposit transferred from agreement A18-CT207542 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT208015, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"989","room_code":"X14","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"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-06-01","rent_from":"2020-06-01","rent_to":"2020-06-30","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Jul 6, 2020. Storage deposit transferred from agreement A18-CT208015 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,06790","order_product":[],"pass":true}},"first_order_id":"4345","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> X14 <\/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> \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":"16","total_discounted_price":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:15: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","3",663,"NEW","A18-CT208330",1290,1290,0,0,"1","1",1290,1290,1290,"2020-07-08 11:15:26","0",null,null,null,"2020-06-01","2020-06-30","1 month contract. Storage rental paid by bank transfer on Jul 6, 2020. Storage deposit transferred from agreement A18-CT208015 to this agreement.\r\n","2020-06-01","16",0,null,0,"0","2","2020-07-08 11:15:26","2","2020-07-08 11:15:26","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,06790","C170663","PERSONAL","Ms","+hf2BdEzeyuAlJ9o86BQkA==","uwdKi3S38jh5+tBibXKG4A==","","ZkyPYW\/X9p1lPTh\/bKU+\/PiAtXClt+yHReh+airMmSnG6Uwc2BRo5SF4sycqncKB\/EoNyhigJWrejarCTwNPAg==","q3\/rgHjoH\/vhcz82yJ8JGA==",null,"x7LEi0saK+ePsbHhJKXpDQ==",null,1,"4345"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:15: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":["8330","989","1290.0","1290.00","2","2020-07-08 11:15:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:15: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-06-01","2020-06-30","989"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-08 11:15: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":["8330",663,"SETTLED","A18-I208659","2020-07-08 11:15:26","2020-06-01","2","2020-07-08 11:15:26","2","2020-07-08 11:15:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:15: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":["8659","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-07-08 11:15:26","2","2020-07-08 11:15:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:15:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"8659"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-08 11:15: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":[663,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208302","2020-07-08 11:15:26",1290,"2","2020-07-08 11:15:26","2","2020-07-08 11:15:26","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:15: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":["8302","DEPOSIT",null,"PAID","2020-07-08 11:15:26",0,"2","2020-07-08 11:15:26","2","2020-07-08 11:15:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:15: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":["8302","INVOICE","8659","PAID","2020-07-08 11:15:26",1290,"2","2020-07-08 11:15:26","2","2020-07-08 11:15:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:24:43","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=INVOICE&filter1=0&filter2=1539&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":"1750","master_room_id":"232","room_code":"WC-19"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1287,"customer_code":"C191287","identity_type":"PERSONAL","identity_id":"D819262(7)","title":"Mr","lastname":"Koo","firstname":"Sheung Chi Kenneth","companyname":"","email":"koo966@yahoo.com","tel":"61699635","address":"Flat B, 11\/F, Tower 1, Bel-Air, 68 Bel-Air Peak Avenue, Pok Fu Lam, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"981.0","renew_rent_month":"13","renew_warehousing_date":"2020-07-08","renew_room_key":"189,02121,189,02356","renew_remark":"13 months contract. Special "Rent Now" 5% discount and one month free. Storage rental and deposit paid by EPS on June 6, 2019. Purchased one more smartcard. Smartcards provided on June 6, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT195169, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2180.0","renew_master_room_id":"113","order_discount":[{"master_room_discount_id":"245","master_room_id":"113","discount_type":"%","price":"1090.00","disocunted_price":"981.00","discount":"10.00","monthly_deduct":109,"room_id":"1072","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1072","room_code":"A05-070","retail_price":"1090.0","discounted_price":981,"location_id":"4"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":981,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5886,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-08","rent_from":"2020-07-08","rent_to":"2021-01-07","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on Jul 8, 2020. Storage deposit $2180 transferred from A05-CT195169 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5886,"final_order_total":5886,"location_id":"4","branch_id":"1","company_id":"1","room_key":"189,02121,189,02356","order_product":[],"pass":true}},"first_order_id":5169,"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-070 <\/td>\r\n\t\t\t\t\t 4X3X7 <\/td>\r\n\t\t\t\t\t $1090.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":"12","total_discounted_price":"981.00","deposit":"0.00","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:24:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1287,"NEW","A05-CT208331",1090,981,0,0,"6","6",5886,5886,5886,"2020-07-08 11:24:43","0",null,null,null,"2020-07-08","2021-01-07","6 months contract. Storage rental paid by bank transfer on Jul 8, 2020. Storage deposit $2180 transferred from A05-CT195169 to this agreement.\r\n","2020-07-08","12",0,null,0,"0","2","2020-07-08 11:24:43","2","2020-07-08 11:24:43","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"189,02121,189,02356","C191287","PERSONAL","Mr","RTTkaXxDDVcWc1twxtJisjnPA3rXBxdyKqeUwmF9X2s=","HkhyNtD\/DbbA5r1iZV6U\/w==","","mLUutgRoodVDXnkrvlaut7xF5B3dgV\/o0uDyzWPOMTRok8qL6sR+btSYvPCrhHbs+Xa17R\/FGZmXwYTIk27VIdJzAUhc2tCfYQKPMTZ8LKY=","p8AJJRjgbtxBQsZUZol8CQ==","Kj5vgj4f4vhu8X1ZpqEDXW+K3pDZ+wBeX3hIDpDb+1o=","xj+qFEPjaL2JW+xLn26BwA==",null,1,5169]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:24:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["8331","245","113","1072","%","10.00",109,"2","2020-07-08 11:24:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:24:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8331","1072","1090.0",981,"2","2020-07-08 11:24:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:24:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-08","2021-01-07","1072"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-08 11:24:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8331",1287,"SETTLED","A05-I208660","2020-07-08 11:24:43","2020-07-08","2","2020-07-08 11:24:43","2","2020-07-08 11:24:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:24:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8660","RENT","\u9810\u7e73\u79df\u91d1",1,981,"MO","1",981,"2","2020-07-08 11:24:43","2","2020-07-08 11:24:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:24:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8660","RENT","\u9810\u7e73\u79df\u91d1",2,981,"MO","1",981,"2","2020-07-08 11:24:43","2","2020-07-08 11:24:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:24:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8660","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2020-07-08 11:24:43","2","2020-07-08 11:24:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:24:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8660","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2020-07-08 11:24:43","2","2020-07-08 11:24:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:24:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8660","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2020-07-08 11:24:43","2","2020-07-08 11:24:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:24:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8660","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2020-07-08 11:24:43","2","2020-07-08 11:24:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:24:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5886,0,"8660"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-08 11:24:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1287,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208303","2020-07-08 11:24:43",5886,"2","2020-07-08 11:24:43","2","2020-07-08 11:24:43","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:24:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8303","DEPOSIT",null,"PAID","2020-07-08 11:24:43",0,"2","2020-07-08 11:24:43","2","2020-07-08 11:24:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:24:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8303","INVOICE","8660","PAID","2020-07-08 11:24:43",5886,"2","2020-07-08 11:24:43","2","2020-07-08 11:24:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:29:56","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&filter1=0&filter2=1539&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":"1750","master_room_id":"232","room_code":"WC-19"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":336,"customer_code":"C170336","identity_type":"PERSONAL","identity_id":"D157455\uff089\uff09","title":"Mr","lastname":"MAK","firstname":"CHUEN CHI","companyname":"","email":null,"tel":"92098496","address":"\u5317\u89d2\u548c\u5bcc\u4e2d\u5fc3\u7b2c\u5341\u5ea711\u6a13A\u5ba4","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1076.0","renew_rent_month":"13","renew_warehousing_date":"2020-07-13","renew_room_key":"133,59818","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by cheque on April 11, 2019. Storage deposit transferred from agreement A14-CT183914 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT194738, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"599","room_code":"M10","retail_price":"598.0","discounted_price":"598.00","location_id":"2"},{"room_id":"597","room_code":"M08","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"24","total_retail_price":1196,"total_discounted_price":1076,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6456,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-13","rent_from":"2020-07-13","rent_to":"2021-01-12","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on Jul 7, 2019. Storage deposit transferred from agreement A14-CT194738 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6456,"final_order_total":6456,"location_id":"2","branch_id":"1","company_id":"1","room_key":"133,59818","order_product":[],"pass":true}},"first_order_id":4738,"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> M10 <\/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> M08 <\/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":"24","total_discounted_price":"1076.00","deposit":"0.00","total_retail_price":"1196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:29:57","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",336,"NEW","A14-CT208332",1196,1076,0,0,"6","6",6456,6456,6456,"2020-07-08 11:29:57","0",null,null,null,"2020-07-13","2021-01-12","6 months contract. Storage rental paid by bank transfer on Jul 7, 2019. Storage deposit transferred from agreement A14-CT194738 to this agreement.\r\n","2020-07-13","24",0,null,0,"0","2","2020-07-08 11:29:56","2","2020-07-08 11:29:56","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"133,59818","C170336","PERSONAL","Mr","rOy\/Kvct6Hd23QprMEISRA==","22KPgW1C3CU66tb5kESLdQ==","","x2LafP6732A9snz8fIOgslHOM94H+R6nyLIsYJzTWhhEgAlBD+hT4yFGhzeaDLF9","bp2bU5FkjeU9L\/FB4wIBjA==",null,"I9Qv2U+SF8Y+71FaCFdBpA==",null,1,4738]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:29:57","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":["8332","599","598.0","598.00","2","2020-07-08 11:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:29:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-13","2021-01-12","599"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-08 11:29:57","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":["8332","597","598.0","598.00","2","2020-07-08 11:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:29:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-13","2021-01-12","597"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-08 11:29:57","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":["8332",336,"SETTLED","A14-I208661","2020-07-08 11:29:56","2020-07-13","2","2020-07-08 11:29:56","2","2020-07-08 11:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:29:57","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":["8661","RENT","\u9810\u7e73\u79df\u91d1",1,1076,"MO","1",1076,"2","2020-07-08 11:29:56","2","2020-07-08 11:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:29:57","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":["8661","RENT","\u9810\u7e73\u79df\u91d1",2,1076,"MO","1",1076,"2","2020-07-08 11:29:56","2","2020-07-08 11:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:29:57","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":["8661","RENT","\u9810\u7e73\u79df\u91d1",3,1076,"MO","1",1076,"2","2020-07-08 11:29:56","2","2020-07-08 11:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:29:57","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":["8661","RENT","\u9810\u7e73\u79df\u91d1",4,1076,"MO","1",1076,"2","2020-07-08 11:29:56","2","2020-07-08 11:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:29:57","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":["8661","RENT","\u9810\u7e73\u79df\u91d1",5,1076,"MO","1",1076,"2","2020-07-08 11:29:56","2","2020-07-08 11:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:29:57","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":["8661","RENT","\u9810\u7e73\u79df\u91d1",6,1076,"MO","1",1076,"2","2020-07-08 11:29:56","2","2020-07-08 11:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:29:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6456,0,"8661"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-08 11:29:57","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":[336,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208304","2020-07-08 11:29:56",6456,"2","2020-07-08 11:29:56","2","2020-07-08 11:29:56","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:29:57","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":["8304","DEPOSIT",null,"PAID","2020-07-08 11:29:56",0,"2","2020-07-08 11:29:56","2","2020-07-08 11:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:29:57","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":["8304","INVOICE","8661","PAID","2020-07-08 11:29:56",6456,"2","2020-07-08 11:29:56","2","2020-07-08 11:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:36:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:37:16","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","floor_plan_rent_room":[],"index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":897,"customer_code":"C180897","identity_type":"BUSINESS","identity_id":"32217364","title":"Ms","lastname":"Lee","firstname":"Rowena","companyname":"Evershine Secretaries Limited","email":"rowena@csclaw.com.hk","tel":"97782828","address":"Unit 402, 4\/F, Wing On House, 71 Des Voeux Road Central,HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1021.0","renew_rent_month":"12","renew_warehousing_date":"2020-07-13","renew_room_key":"0012449119","renew_remark":"12 months contract. Storage rental paid by check on 08 July 2019. Storage deposit $2616 transferred from agreement B01-CT182683 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT195418, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"141","order_discount":[{"master_room_discount_id":"342","master_room_id":"141","discount_type":"%","price":"1308.00","disocunted_price":"851.00","discount":"34.94","monthly_deduct":457.0152,"room_id":"1226","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1226","room_code":"B01-036","retail_price":"1308.0","discounted_price":851,"location_id":"5"}],"roughly_size":"20","total_retail_price":1308,"total_discounted_price":1021,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":12252,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-13","rent_from":"2020-07-13","rent_to":"2021-07-12","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on Jul 08,2020. Storage deposit $2616 transferred from agreement B01-CT195418 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":12252,"final_order_total":12252,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0012449119","order_product":[],"pass":true}},"first_order_id":"2683","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-036 <\/td>\r\n\t\t\t\t\t 4X5X7 <\/td>\r\n\t\t\t\t\t $1308.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":"20","total_discounted_price":"1021.0","deposit":"0","total_retail_price":"1308.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:37:17","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",897,"NEW","B01-CT208333",1308,1021,0,0,"12","12",12252,12252,12252,"2020-07-08 11:37:17","0",null,null,null,"2020-07-13","2021-07-12","12 months contract. Storage rental paid by bank transfer on Jul 08,2020. Storage deposit $2616 transferred from agreement B01-CT195418 to this agreement.","2020-07-13","20",0,null,0,"0","2","2020-07-08 11:37:16","2","2020-07-08 11:37:16","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012449119","C180897","BUSINESS","Ms","0+TV6zm3LdEvtQm7OWbRKA==","kiriEIqhcx866RNZiMXdKQ==","Evershine Secretaries Limited","wPsolNV+FCmp84UGZp1WN+G7gLmyOt79lhthCyE25GUmXP\/WVi877L00ezq8WNwNkrRYbjNgE737P+VVo63v3Q==","hwoX4xXDqyHPltsuJm8a3Q==","WYAWJ3XpDQ1uoWAHNQJjU15n697GnepqoE7jdYdvguk=",null,"\/4SNCWI7OvEDtK1pzdIdSQ==",1,"2683"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:37:17","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":["8333","342","141","1226","%","34.94",457.0152,"2","2020-07-08 11:37:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:37:17","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":["8333","1226","1308.0",851,"2","2020-07-08 11:37:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:37:17","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-13","2021-07-12","1226"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-08 11:37:17","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":["8333",897,"SETTLED","B01-I208662","2020-07-08 11:37:16","2020-07-13","2","2020-07-08 11:37:16","2","2020-07-08 11:37:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:37:17","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":["8662","RENT","\u9810\u7e73\u79df\u91d1",1,1021,"MO","1",1021,"2","2020-07-08 11:37:16","2","2020-07-08 11:37:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:37:17","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":["8662","RENT","\u9810\u7e73\u79df\u91d1",2,1021,"MO","1",1021,"2","2020-07-08 11:37:16","2","2020-07-08 11:37:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:37:17","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":["8662","RENT","\u9810\u7e73\u79df\u91d1",3,1021,"MO","1",1021,"2","2020-07-08 11:37:16","2","2020-07-08 11:37:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:37:17","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":["8662","RENT","\u9810\u7e73\u79df\u91d1",4,1021,"MO","1",1021,"2","2020-07-08 11:37:16","2","2020-07-08 11:37:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:37:17","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":["8662","RENT","\u9810\u7e73\u79df\u91d1",5,1021,"MO","1",1021,"2","2020-07-08 11:37:16","2","2020-07-08 11:37:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:37:17","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":["8662","RENT","\u9810\u7e73\u79df\u91d1",6,1021,"MO","1",1021,"2","2020-07-08 11:37:16","2","2020-07-08 11:37:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:37:17","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":["8662","RENT","\u9810\u7e73\u79df\u91d1",7,1021,"MO","1",1021,"2","2020-07-08 11:37:16","2","2020-07-08 11:37:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:37:17","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":["8662","RENT","\u9810\u7e73\u79df\u91d1",8,1021,"MO","1",1021,"2","2020-07-08 11:37:16","2","2020-07-08 11:37:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:37:17","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":["8662","RENT","\u9810\u7e73\u79df\u91d1",9,1021,"MO","1",1021,"2","2020-07-08 11:37:16","2","2020-07-08 11:37:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:37:17","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":["8662","RENT","\u9810\u7e73\u79df\u91d1",10,1021,"MO","1",1021,"2","2020-07-08 11:37:16","2","2020-07-08 11:37:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:37:17","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":["8662","RENT","\u9810\u7e73\u79df\u91d1",11,1021,"MO","1",1021,"2","2020-07-08 11:37:16","2","2020-07-08 11:37:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:37:17","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":["8662","RENT","\u9810\u7e73\u79df\u91d1",12,1021,"MO","1",1021,"2","2020-07-08 11:37:16","2","2020-07-08 11:37:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:37:17","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[12252,0,"8662"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-08 11:37:17","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":[897,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208305","2020-07-08 11:37:16",12252,"2","2020-07-08 11:37:16","2","2020-07-08 11:37:16","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:37:17","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":["8305","DEPOSIT",null,"PAID","2020-07-08 11:37:16",0,"2","2020-07-08 11:37:16","2","2020-07-08 11:37:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 11:37:17","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":["8305","INVOICE","8662","PAID","2020-07-08 11:37:16",12252,"2","2020-07-08 11:37:16","2","2020-07-08 11:37:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 12:25:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 12:29:31","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 12:49:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 12:57:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 13:05:51","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 13:11:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 13:19:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 13:26:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 13:29:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 13:34:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 13:38:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 13:38:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 13:39:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 13:56:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 14:42:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 14:47:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 14:48:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 14:49:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:02:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:05:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:05:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:14:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:22:37","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","floor_plan_rent_room":[{"room_id":"1750","master_room_id":"232","room_code":"WC-19"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1242,"customer_code":"C191242","identity_type":"BUSINESS","identity_id":"11719733-000-02-19-5","title":"Ms","lastname":"Lai","firstname":"Wing Yee, Eva","companyname":"Leo Engineering Limited","email":"leoengltd@gmail.com","tel":"28577258","address":"Flat B, 17\/F, Block 2, Kingley Industrial Building, 33 Yip Kan Street, Wong Chuk Hang, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1528.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-23","renew_room_key":"189, 29074","renew_remark":"1 month contract. Change unit from B05 to B12. Storage deposit $3056 transferred from agreement A12-CT207246 to this agreement. Storage rental paid by bank transfer on May 18, 2020. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207888, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $3056.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"64","room_code":"B12","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1452,"deposit":0,"rent_month":"4","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"4","prepaid_amount":5808,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-23","rent_from":"2020-06-23","rent_to":"2020-10-22","delivery_service":"0","remark":"4 months contract. Storage rental fee paid by bank transfer on Jul 08, 2020. Storage deposit $3056 transferred from agreement A12-CT207888 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5808,"final_order_total":5808,"location_id":"1","branch_id":"1","company_id":"1","room_key":"189, 29074","order_product":[],"pass":true}},"first_order_id":7888,"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> B12 <\/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":"1452.00","deposit":"0.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:22: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","1",1242,"NEW","A12-CT208334",1528,1452,0,0,"4","4",5808,5808,5808,"2020-07-08 15:22:38","0",null,null,null,"2020-06-23","2020-10-22","4 months contract. Storage rental fee paid by bank transfer on Jul 08, 2020. Storage deposit $3056 transferred from agreement A12-CT207888 to this agreement. \r\n","2020-06-23","20",0,null,0,"0","2","2020-07-08 15:22:37","2","2020-07-08 15:22:37","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"189, 29074","C191242","BUSINESS","Ms","Vt1s1tKyVHGE6ijWGp3g+w==","lzx0GiXnrd0waIhp6oozpQ==","Leo Engineering Limited","V+9pyaXSanw3cB\/uChDsBTU8VHLSHKXXirjbf4HhHeq9AoCbEpifZIM2PfmHZywVHfLZTWCD1znFfMbte52A1RhZSEU+HET7Az2teqxNOuRGZkraXDsV9xeBIB00Zu2rVMXsYNEgpgQC\/e2XnwBFGg==","LmRjdENAVEeS\/ql+Q5bRgw==","Xqh5H+LlZ+ZbGgv+\/6hg8Kl\/yJkr2MjdyVAG\/2Pn7H4=",null,"T4TaIH0rG3Elgf1srlSVcOW0IsKlbN0iAi9GLAKqHkc=",1,7888]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:22: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":["8334","64","1528.0","1528.00","2","2020-07-08 15:22:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:22: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-06-23","2020-10-22","64"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-08 15:22: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":["8334",1242,"SETTLED","A12-I208663","2020-07-08 15:22:37","2020-06-23","2","2020-07-08 15:22:37","2","2020-07-08 15:22:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:22: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":["8663","RENT","\u9810\u7e73\u79df\u91d1",1,1452,"MO","1",1452,"2","2020-07-08 15:22:37","2","2020-07-08 15:22:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:22: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":["8663","RENT","\u9810\u7e73\u79df\u91d1",2,1452,"MO","1",1452,"2","2020-07-08 15:22:37","2","2020-07-08 15:22:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:22: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":["8663","RENT","\u9810\u7e73\u79df\u91d1",3,1452,"MO","1",1452,"2","2020-07-08 15:22:37","2","2020-07-08 15:22:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:22: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":["8663","RENT","\u9810\u7e73\u79df\u91d1",4,1452,"MO","1",1452,"2","2020-07-08 15:22:37","2","2020-07-08 15:22:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:22:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5808,0,"8663"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-08 15:22: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":[1242,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208306","2020-07-08 15:22:37",5808,"2","2020-07-08 15:22:37","2","2020-07-08 15:22:37","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:22: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":["8306","DEPOSIT",null,"PAID","2020-07-08 15:22:37",0,"2","2020-07-08 15:22:37","2","2020-07-08 15:22:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:22: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":["8306","INVOICE","8663","PAID","2020-07-08 15:22:37",5808,"2","2020-07-08 15:22:37","2","2020-07-08 15:22:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:23:30","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":"","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":373,"customer_code":"C170373","identity_type":"PERSONAL","identity_id":"A810524(6)","title":"Ms","lastname":"Tang","firstname":"Wai Fong","companyname":"","email":"tang222888@hotmail.com","tel":"92668877","address":"Flat A,13\/F,Kaning Mansion,Aberdeen,Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3784.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-20","renew_room_key":"055,46666","renew_remark":"1 month contract. Storage rental paid by PPS on May 20, 2020. Storage deposit transferred from agreement A12-CT207660 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207921, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"409","room_code":"H19","retail_price":"1938.0","discounted_price":"1938.00","location_id":"1"},{"room_id":"86","room_code":"B34","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"62.5","total_retail_price":3466,"total_discounted_price":3784,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":3784,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-20","rent_from":"2020-05-20","rent_to":"2020-06-19","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on June 29, 2020. Storage deposit transferred from agreement A12-CT207921 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":3784,"final_order_total":3784,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,46666","order_product":[],"pass":true}},"first_order_id":"4881","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> H19 <\/td>\r\n\t\t\t\t\t 5X8.5X8 <\/td>\r\n\t\t\t\t\t $1938.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> B34 <\/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":"62.5","total_discounted_price":"3784.0","deposit":"0","total_retail_price":"3466.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:23:31","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",373,"NEW","A12-CT208335",3466,3784,0,0,"1","1",3784,3784,3784,"2020-07-08 15:23:31","0",null,null,null,"2020-05-20","2020-06-19","1 month contract. Storage rental paid by PPS on June 29, 2020. Storage deposit transferred from agreement A12-CT207921 to this agreement.","2020-05-20","62.5",0,null,0,"0","2","2020-07-08 15:23:30","2","2020-07-08 15:23:30","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,46666","C170373","PERSONAL","Ms","nTGfHLdEIudAzJAvttiE\/g==","M7CfcmE2OSMlZOkNgaoDmQ==","","BXgfEt9fXMpUNvxC+2X229VwwYS6rNmHtxMS+n23vDnbhk3n3xs6q6u0V\/EvTko5","HCKjEGhRJ8yb3ZyyPfmQag==","jQ4ob3N7+u9PyWPiMEH+PWHdZ55bC9BctdRu99koSsw=","QQr8JjuTNOLQNSu7eSLB1g==",null,1,"4881"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:23:31","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":["8335","409","1938.0","1938.00","2","2020-07-08 15:23:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:23:31","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-20","2020-06-19","409"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-08 15:23:31","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":["8335","86","1528.0","1528.00","2","2020-07-08 15:23:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:23:31","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-20","2020-06-19","86"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-08 15:23:31","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":["8335",373,"SETTLED","A12-I208664","2020-07-08 15:23:30","2020-05-20","2","2020-07-08 15:23:30","2","2020-07-08 15:23:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:23:31","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":["8664","RENT","\u9810\u7e73\u79df\u91d1",1,3784,"MO","1",3784,"2","2020-07-08 15:23:30","2","2020-07-08 15:23:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:23:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3784,0,"8664"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-08 15:23:31","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":[373,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208307","2020-07-08 15:23:30",3784,"2","2020-07-08 15:23:30","2","2020-07-08 15:23:30","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:23:31","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":["8307","DEPOSIT",null,"PAID","2020-07-08 15:23:30",0,"2","2020-07-08 15:23:30","2","2020-07-08 15:23:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:23:31","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":["8307","INVOICE","8664","PAID","2020-07-08 15:23:30",3784,"2","2020-07-08 15:23:30","2","2020-07-08 15:23:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:30:20","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":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-07-01","renew_room_key":"054,41837","renew_remark":"1 month contract. Storage rental paid by PPS on May 25, 2020. Storage deposit transferred from agreement A18-CT207777 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207978, \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-07-01","rent_from":"2020-07-01","rent_to":"2020-07-31","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on June 29, 2020. Storage deposit transferred from agreement A18-CT207978 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-07-08 15:30:20","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-CT208336",1090,1090,0,0,"1","1",1090,1090,1090,"2020-07-08 15:30:20","0",null,null,null,"2020-07-01","2020-07-31","1 month contract. Storage rental paid by PPS on June 29, 2020. Storage deposit transferred from agreement A18-CT207978 to this agreement.\r\n","2020-07-01","12",0,null,0,"0","2","2020-07-08 15:30:20","2","2020-07-08 15:30:20","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-07-08 15:30:20","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":["8336","837","1090.0","1090.00","2","2020-07-08 15:30:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:30:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-01","2020-07-31","837"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-08 15:30:20","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":["8336",652,"SETTLED","A18-I208665","2020-07-08 15:30:20","2020-07-01","2","2020-07-08 15:30:20","2","2020-07-08 15:30:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:30:20","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":["8665","RENT","\u9810\u7e73\u79df\u91d1",1,1090,"MO","1",1090,"2","2020-07-08 15:30:20","2","2020-07-08 15:30:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:30:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1090,0,"8665"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-08 15:30:20","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","P208308","2020-07-08 15:30:20",1090,"2","2020-07-08 15:30:20","2","2020-07-08 15:30:20","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:30:20","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":["8308","DEPOSIT",null,"PAID","2020-07-08 15:30:20",0,"2","2020-07-08 15:30:20","2","2020-07-08 15:30:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:30:20","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":["8308","INVOICE","8665","PAID","2020-07-08 15:30:20",1090,"2","2020-07-08 15:30:20","2","2020-07-08 15:30:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:35:06","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","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-06-26","renew_room_key":"072,57038","renew_remark":"1 month contract. Storage rental paid by PPS on June 3, 2020. Storage deposit transferred from agreement A14-CT207780 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT208046, \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-06-26","rent_from":"2020-06-26","rent_to":"2020-07-25","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on June 29, 2020. Storage deposit transferred from agreement A14-CT208046 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-07-08 15:35: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","2",807,"NEW","A14-CT208337",1342,1342,0,0,"1","1",1342,1342,1342,"2020-07-08 15:35:06","0",null,null,null,"2020-06-26","2020-07-25","1 month contract. Storage rental paid by PPS on June 29, 2020. Storage deposit transferred from agreement A14-CT208046 to this agreement.\r\n","2020-06-26","16",0,null,0,"0","2","2020-07-08 15:35:06","2","2020-07-08 15:35:06","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-07-08 15:35: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":["8337","526","1342.0","1342.00","2","2020-07-08 15:35:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:35:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-26","2020-07-25","526"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-08 15:35: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":["8337",807,"SETTLED","A14-I208666","2020-07-08 15:35:06","2020-06-26","2","2020-07-08 15:35:06","2","2020-07-08 15:35:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:35: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":["8666","RENT","\u9810\u7e73\u79df\u91d1",1,1342,"MO","1",1342,"2","2020-07-08 15:35:06","2","2020-07-08 15:35:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:35:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1342,0,"8666"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-08 15:35: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":[807,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208309","2020-07-08 15:35:06",1342,"2","2020-07-08 15:35:06","2","2020-07-08 15:35:06","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:35: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":["8309","DEPOSIT",null,"PAID","2020-07-08 15:35:06",0,"2","2020-07-08 15:35:06","2","2020-07-08 15:35:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 15:35: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":["8309","INVOICE","8666","PAID","2020-07-08 15:35:06",1342,"2","2020-07-08 15:35:06","2","2020-07-08 15:35:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 16:20:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 16:20:48","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 16:25:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 16:27:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 16:27:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 17:00:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 17:12:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 17:15:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 18:19:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-08 21:29:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****