{"created_at":"2020-05-13 09:41:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 10:11:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 10:11:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 10:13:42","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":"all=1&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":"1121","master_room_id":"114","room_code":"A05-119"},{"room_id":"1120","master_room_id":"114","room_code":"A05-118"},{"room_id":"1127","master_room_id":"114","room_code":"A05-125"},{"room_id":"1128","master_room_id":"114","room_code":"A05-126"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":877,"customer_code":"C180877","identity_type":"PERSONAL","identity_id":"R938804(3)","title":"Ms","lastname":"Cameron","firstname":"Ekaterina","companyname":"","email":"info@nasonpearl.com","tel":"97337317","address":"Flat 2135, 21\/F, Tower 5, Hong Kong Parkview, 88 Tai Tam Reservoir Road, Hong Kong ","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3462.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-01","renew_room_key":"190,40465,189,29022","renew_remark":"1 months contract. Storage rental paid by bank transfer on April 2, 2020. Storage deposit transferred from agreement A18-CT207193 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207560, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"78","order_discount":[],"order_room":[{"room_id":"846","room_code":"S05","retail_price":"1857.0","discounted_price":"1857.00","location_id":"3"},{"room_id":"810","room_code":"Q07","retail_price":"1605.0","discounted_price":"1605.00","location_id":"3"}],"roughly_size":"44","total_retail_price":3462,"total_discounted_price":3462,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":3462,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-01","rent_from":"2020-04-01","rent_to":"2020-04-30","delivery_service":"0","remark":"1 months contract. Storage rental paid by bank transfer on May 12, 2020. Storage deposit transferred from agreement A18-CT207560 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3462,"final_order_total":3462,"location_id":"3","branch_id":"1","company_id":"1","room_key":"190,40465,189,29022","order_product":[],"pass":true}},"first_order_id":"4121","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>
S05 <\/td>\r\n\t\t\t\t\t	4X6X7 <\/td>\r\n\t\t\t\t\t	$1857.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>
Q07 <\/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":"44","total_discounted_price":"3462.0","deposit":"0","total_retail_price":"3462.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 10:13: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","3",877,"NEW","A18-CT207833",3462,3462,0,0,"1","1",3462,3462,3462,"2020-05-13 10:13:43","0",null,null,null,"2020-04-01","2020-04-30","1 months contract. Storage rental paid by bank transfer on May 12, 2020. Storage deposit transferred from agreement A18-CT207560 to this agreement.\r\n","2020-04-01","44",0,null,0,"0","2","2020-05-13 10:13:42","2","2020-05-13 10:13:42","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190,40465,189,29022","C180877","PERSONAL","Ms","RPthaial2IFX5OTQVN1g+A==","5j4q6ReeucnDk5XYC2qhww==","","rRXmSas1C74UhCIMAl4XVBNkmNxuyBYhPciKj+xVXn2vQd37Gl4JOgs8HGkmy+xJFTDVdTpVVL4FPjZ3S+Pjo17HXHrjXmDiJKqKzjzyVmbMcgqz6jBEyLIHEHGxlwsr","c+0bwcSjwgphezD5fySi+g==","k2\/+w1ZaM4nSEX\/8U65t74fzkbo4RpcfhFOMFpzQU3M=","2SUKxPo6VxWobmWOngKfJg==",null,1,"4121"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 10:13: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":["7833","846","1857.0","1857.00","2","2020-05-13 10:13:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 10:13: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-04-01","2020-04-30","846"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-13 10:13: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":["7833","810","1605.0","1605.00","2","2020-05-13 10:13:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 10:13: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-04-01","2020-04-30","810"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-13 10:13: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":["7833",877,"SETTLED","A18-I208162","2020-05-13 10:13:42","2020-04-01","2","2020-05-13 10:13:42","2","2020-05-13 10:13:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 10:13: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":["8162","RENT","\u9810\u7e73\u79df\u91d1",1,3462,"MO","1",3462,"2","2020-05-13 10:13:42","2","2020-05-13 10:13:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 10:13:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3462,0,"8162"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-13 10:13: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":[877,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207807","2020-05-13 10:13:42",3462,"2","2020-05-13 10:13:42","2","2020-05-13 10:13:42","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 10:13: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":["7807","DEPOSIT",null,"PAID","2020-05-13 10:13:42",0,"2","2020-05-13 10:13:42","2","2020-05-13 10:13:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 10:13: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":["7807","INVOICE","8162","PAID","2020-05-13 10:13:42",3462,"2","2020-05-13 10:13:42","2","2020-05-13 10:13:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 10:31:42","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":"all=1&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":"1121","master_room_id":"114","room_code":"A05-119"},{"room_id":"1120","master_room_id":"114","room_code":"A05-118"},{"room_id":"1127","master_room_id":"114","room_code":"A05-125"},{"room_id":"1128","master_room_id":"114","room_code":"A05-126"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":533,"customer_code":"C170533","identity_type":"PERSONAL","identity_id":"D702226(2)","title":"Mr","lastname":"Leung","firstname":"Ming Fai","companyname":"","email":"leungmingfai@hotmail.com","tel":"62805618","address":"Flat G,9\/F, Kam Fung Mansion, 171 Aberdeen Main Rd, Aberdeen ","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-18","renew_room_key":"136,58083","renew_remark":"1 month contract. Storage rental paid by bank transfer on April 10, 2020. Storage deposit transferred from agreement A14-CT207415 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207617, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"754","room_code":"O30","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-18","rent_from":"2020-04-18","rent_to":"2020-05-17","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on May 12, 2020. Storage deposit transferred from agreement A14-CT207617 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"2","branch_id":"1","company_id":"1","room_key":"136,58083","order_product":[],"pass":true}},"first_order_id":"4566","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> O30 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 10:31:42","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",533,"NEW","A14-CT207834",998,1038,0,0,"1","1",1038,1038,1038,"2020-05-13 10:31:42","0",null,null,null,"2020-04-18","2020-05-17","1 month contract. Storage rental paid by bank transfer on May 12, 2020. Storage deposit transferred from agreement A14-CT207617 to this agreement.","2020-04-18","12",0,null,0,"0","2","2020-05-13 10:31:42","2","2020-05-13 10:31:42","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,58083","C170533","PERSONAL","Mr","ltCiTyDjJ0Gdz4KiVHpL3w==","xEf2h2aoyRQ71ZVgBH+9WQ==","","oxxB92pGHSI9I6dk86NeV50fIKbJm7OHBHlNQ0XlFwdi0YrCU3uueNLGwLXtYZ27jc2ffcQTK04oDV5uyRKmsw==","65I9HJH8Lb0dMm8MBuRKKw==","UoHdQ18xnvupRvjCY9wtS6MZZ24DKjVuPgYYyCDQhRU=","IiBGQKIxd9Yo4PXXqWkRIg==",null,1,"4566"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 10:31:42","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":["7834","754","998.0","998.00","2","2020-05-13 10:31:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 10:31:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-18","2020-05-17","754"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-13 10:31:42","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":["7834",533,"SETTLED","A14-I208163","2020-05-13 10:31:42","2020-04-18","2","2020-05-13 10:31:42","2","2020-05-13 10:31:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 10:31:42","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":["8163","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-05-13 10:31:42","2","2020-05-13 10:31:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 10:31:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"8163"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-13 10:31:42","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":[533,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207808","2020-05-13 10:31:42",1038,"2","2020-05-13 10:31:42","2","2020-05-13 10:31:42","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 10:31:42","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":["7808","DEPOSIT",null,"PAID","2020-05-13 10:31:42",0,"2","2020-05-13 10:31:42","2","2020-05-13 10:31:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 10:31:42","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":["7808","INVOICE","8163","PAID","2020-05-13 10:31:42",1038,"2","2020-05-13 10:31:42","2","2020-05-13 10:31:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 11:13:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 11:30:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 11:36:24","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"all=1&msg=%E5%8F%96%E6%B6%88&page=3&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1121","master_room_id":"114","room_code":"A05-119"},{"room_id":"1120","master_room_id":"114","room_code":"A05-118"},{"room_id":"1127","master_room_id":"114","room_code":"A05-125"},{"room_id":"1128","master_room_id":"114","room_code":"A05-126"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":819,"customer_code":"C180819","identity_type":"PERSONAL","identity_id":"K212943(4)","title":"Ms","lastname":"Au","firstname":"Kei Ching Amy","companyname":"","email":"youramyau@yahoo.com.hk","tel":"96547999","address":"Flat E, 26\/F, Tower 30, South Horizons, Ap Lei Chau, H.K. ","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"781.0","renew_rent_month":"13","renew_warehousing_date":"2020-05-10","renew_room_key":"054,42476","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by bank transfer on May 7 , 2019. Storage deposit transferred from agreement A18-CT183266 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT194922, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"100","order_discount":[],"order_room":[{"room_id":"927","room_code":"V01(\u670d\u88dd\u5009)","retail_price":"867.0","discounted_price":"867.00","location_id":"3"}],"roughly_size":"7.2","total_retail_price":867,"total_discounted_price":781,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":4686,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-10","rent_from":"2020-05-10","rent_to":"2020-11-09","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on May 11, 2020. Storage deposit transferred from agreement A18-CT194922 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4686,"final_order_total":4686,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,42476","order_product":[],"pass":true}},"first_order_id":"3266","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> V01(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 3X2.4X7 <\/td>\r\n\t\t\t\t\t $867.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":"7.2","total_discounted_price":"781.00","deposit":"0.00","total_retail_price":"867.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 11:36:25","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",819,"NEW","A18-CT207835",867,781,0,0,"6","6",4686,4686,4686,"2020-05-13 11:36:25","0",null,null,null,"2020-05-10","2020-11-09","6 months contract. Storage rental paid by bank transfer on May 11, 2020. Storage deposit transferred from agreement A18-CT194922 to this agreement.","2020-05-10","7.2",0,null,0,"0","2","2020-05-13 11:36:24","2","2020-05-13 11:36:24","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,42476","C180819","PERSONAL","Ms","dVj4J+lYghCCZ6j7xB0y\/g==","egeOlBPCZ2i\/hzcvvQMisg==","","aIBbvQq8YQ+YsrC7Mh6+9nprcM2Ksxc3W\/pOm5FFxiIOChq5rq4h2Nsl7FruoSpSPycbzftL7rQhqY7tu6AXGg==","5D3yw606RFt+OpK0HNFwbg==","9CJuxzNtcNJjbXvPE7+qKTExgZ18ZoqJfESc2G\/ovk8=","bPmuhNgX\/MWb3INrJuG0FA==",null,1,"3266"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 11:36:25","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":["7835","927","867.0","867.00","2","2020-05-13 11:36:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 11:36:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-10","2020-11-09","927"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-13 11:36:25","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":["7835",819,"SETTLED","A18-I208164","2020-05-13 11:36:24","2020-05-10","2","2020-05-13 11:36:24","2","2020-05-13 11:36:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 11:36:25","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":["8164","RENT","\u9810\u7e73\u79df\u91d1",1,781,"MO","1",781,"2","2020-05-13 11:36:24","2","2020-05-13 11:36:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 11:36:25","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":["8164","RENT","\u9810\u7e73\u79df\u91d1",2,781,"MO","1",781,"2","2020-05-13 11:36:24","2","2020-05-13 11:36:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 11:36:25","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":["8164","RENT","\u9810\u7e73\u79df\u91d1",3,781,"MO","1",781,"2","2020-05-13 11:36:24","2","2020-05-13 11:36:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 11:36:25","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":["8164","RENT","\u9810\u7e73\u79df\u91d1",4,781,"MO","1",781,"2","2020-05-13 11:36:24","2","2020-05-13 11:36:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 11:36:25","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":["8164","RENT","\u9810\u7e73\u79df\u91d1",5,781,"MO","1",781,"2","2020-05-13 11:36:24","2","2020-05-13 11:36:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 11:36:25","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":["8164","RENT","\u9810\u7e73\u79df\u91d1",6,781,"MO","1",781,"2","2020-05-13 11:36:24","2","2020-05-13 11:36:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 11:36:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4686,0,"8164"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-13 11:36:25","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":[819,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207809","2020-05-13 11:36:24",4686,"2","2020-05-13 11:36:24","2","2020-05-13 11:36:24","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 11:36:25","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":["7809","DEPOSIT",null,"PAID","2020-05-13 11:36:24",0,"2","2020-05-13 11:36:24","2","2020-05-13 11:36:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 11:36:25","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":["7809","INVOICE","8164","PAID","2020-05-13 11:36:24",4686,"2","2020-05-13 11:36:24","2","2020-05-13 11:36:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 12:25:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 12:28:27","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1031,"customer_code":"C181031","identity_type":"PERSONAL","identity_id":"K295466(4)","title":"Mr","lastname":"NG","firstname":"PO KEUNG KARLMAN","companyname":"","email":null,"tel":"96592025","address":"56\/F B Island Rosort T1, Chai Wan, HK","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1741.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-10","renew_room_key":"0012422305","renew_remark":"6 months contract. Storage rental paid by bank transfer on 11 Nov, 2019. Deposit $3956 transferred from agreement B01-CT183515 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT196371, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"140","order_discount":[{"master_room_discount_id":"315","master_room_id":"140","discount_type":"%","price":"1112.00","disocunted_price":"816.00","discount":"26.62","monthly_deduct":296.0144,"room_id":"1230","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"315","master_room_id":"140","discount_type":"%","price":"1112.00","disocunted_price":"816.00","discount":"26.62","monthly_deduct":296.0144,"room_id":"1231","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1231","room_code":"B01-041","retail_price":"1112.0","discounted_price":816,"location_id":"5"},{"room_id":"1230","room_code":"B01-040","retail_price":"1112.0","discounted_price":816,"location_id":"5"}],"roughly_size":"32","total_retail_price":2224,"total_discounted_price":1080,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6480,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-10","rent_from":"2020-05-10","rent_to":"2020-11-09","delivery_service":"0","remark":"6 months contract. Special renewal offer: $1080\/ month. Storage rental paid by bank transfer on May 9,2020. Deposit $3956 transferred from agreement B01-CT196371 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6480,"final_order_total":6480,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0012422305","order_product":[],"pass":true}},"first_order_id":"3515","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> B01-041 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1112.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> B01-040 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1112.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":"32","total_discounted_price":"1080.00","deposit":"0","total_retail_price":"2224.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 12:28:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","2","5",1031,"NEW","B01-CT207836",2224,1080,0,0,"6","6",6480,6480,6480,"2020-05-13 12:28:28","0",null,null,null,"2020-05-10","2020-11-09","6 months contract. Special renewal offer: $1080\/ month. Storage rental paid by bank transfer on May 9,2020. Deposit $3956 transferred from agreement B01-CT196371 to this agreement.","2020-05-10","32",0,null,0,"0","2","2020-05-13 12:28:27","2","2020-05-13 12:28:27","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012422305","C181031","PERSONAL","Mr","wuPzzmjYDQME6ISEDVNzRUtnHE6zi+\/4VCGmIdtoT9w=","yXKLXTtbNpECaRVTZxF\/Rw==","","niJP24Zo\/mDJSPZvE4W4no\/l6yOf2igENJr0\/OOGhoqnrnrQMAtCeJ9YGZyvie5D","BCyq4DwiBSdIaq\/OxI3U0A==",null,"pFlRHsexZ\/2hcA7nrI\/zeQ==",null,1,"3515"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 12:28:28","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":["7836","315","140","1230","%","26.62",296.0144,"2","2020-05-13 12:28:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 12:28:28","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":["7836","315","140","1231","%","26.62",296.0144,"2","2020-05-13 12:28:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 12:28:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7836","1231","1112.0",816,"2","2020-05-13 12:28:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 12:28:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-10","2020-11-09","1231"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-13 12:28:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7836","1230","1112.0",816,"2","2020-05-13 12:28:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 12:28:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-10","2020-11-09","1230"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-13 12:28:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7836",1031,"SETTLED","B01-I208165","2020-05-13 12:28:27","2020-05-10","2","2020-05-13 12:28:27","2","2020-05-13 12:28:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 12:28:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8165","RENT","\u9810\u7e73\u79df\u91d1",1,1080,"MO","1",1080,"2","2020-05-13 12:28:27","2","2020-05-13 12:28:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 12:28:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8165","RENT","\u9810\u7e73\u79df\u91d1",2,1080,"MO","1",1080,"2","2020-05-13 12:28:27","2","2020-05-13 12:28:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 12:28:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8165","RENT","\u9810\u7e73\u79df\u91d1",3,1080,"MO","1",1080,"2","2020-05-13 12:28:27","2","2020-05-13 12:28:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 12:28:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8165","RENT","\u9810\u7e73\u79df\u91d1",4,1080,"MO","1",1080,"2","2020-05-13 12:28:27","2","2020-05-13 12:28:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 12:28:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8165","RENT","\u9810\u7e73\u79df\u91d1",5,1080,"MO","1",1080,"2","2020-05-13 12:28:27","2","2020-05-13 12:28:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 12:28:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8165","RENT","\u9810\u7e73\u79df\u91d1",6,1080,"MO","1",1080,"2","2020-05-13 12:28:27","2","2020-05-13 12:28:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 12:28:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6480,0,"8165"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-13 12:28:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1031,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207810","2020-05-13 12:28:27",6480,"2","2020-05-13 12:28:27","2","2020-05-13 12:28:27","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 12:28:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7810","DEPOSIT",null,"PAID","2020-05-13 12:28:27",0,"2","2020-05-13 12:28:27","2","2020-05-13 12:28:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 12:28:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7810","INVOICE","8165","PAID","2020-05-13 12:28:27",6480,"2","2020-05-13 12:28:27","2","2020-05-13 12:28:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 13:20:59","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1265,"customer_code":"C191265","identity_type":"PERSONAL","identity_id":"M510528(0)","title":"Mr","lastname":"FRIEDMAN","firstname":"Joshua Elliot","companyname":"","email":"JF7na@virginia.edu","tel":"56379226","address":"Davis Polk, 17\/F, 3A Chater Road, Central, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2167.0","renew_rent_month":"12","renew_warehousing_date":"2020-05-10","renew_room_key":"0012385379","renew_remark":"12 months contract. Special off 2 months free. Storage rental and deposit paid by bank transfer on May 10, 2019. Smartcard provided on May 10, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT194941, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2888.0","renew_master_room_id":"186","order_discount":[],"order_room":[{"room_id":"1330","room_code":"C15-024","retail_price":"2888.0","discounted_price":"2888.00","location_id":"6"}],"roughly_size":"48","total_retail_price":2888,"total_discounted_price":2600,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":15600,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-10","rent_from":"2020-05-10","rent_to":"2020-11-09","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on May 13,2020. Storage deposit $2888 transferred from agreement C15-CT194941 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":15600,"final_order_total":15600,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012385379","order_product":[],"pass":true}},"first_order_id":4941,"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-024 <\/td>\r\n\t\t\t\t\t 6X8X6.5 <\/td>\r\n\t\t\t\t\t $2888.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":"48","total_discounted_price":"2600.00","deposit":"0.00","total_retail_price":"2888.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 13:20:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1265,"NEW","C15-CT207837",2888,2600,0,0,"6","6",15600,15600,15600,"2020-05-13 13:20:59","0",null,null,null,"2020-05-10","2020-11-09","6 months contract. Storage rental paid by bank transfer on May 13,2020. Storage deposit $2888 transferred from agreement C15-CT194941 to this agreement.","2020-05-10","48",0,null,0,"0","2","2020-05-13 13:20:59","2","2020-05-13 13:20:59","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012385379","C191265","PERSONAL","Mr","CfwQUhe9dYU9+BMA3yqcmQ==","HQFD\/t7SC27\/DpwjgY1qXQ==","","gh++ursg9tvHPS5ApWKLfF7YANLpUdVC2F2dQGNPvp8gY5T9KPwXzHW9iJfhY01dVpmpG1p+depMJp2xGaxDqA==","7Fmm+6o8W6r6ZQhUuHeGig==","NXJ4R+MBs8R4eqEgZ+581KgmKDv0DoMzfZEtMCt3LOg=","w46ZXKbKro0ehBTeFqhILg==",null,1,4941]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 13:20:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7837","1330","2888.0","2888.00","2","2020-05-13 13:20:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 13:20:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-10","2020-11-09","1330"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-13 13:20:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7837",1265,"SETTLED","C15-I208166","2020-05-13 13:20:59","2020-05-10","2","2020-05-13 13:20:59","2","2020-05-13 13:20:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 13:20:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8166","RENT","\u9810\u7e73\u79df\u91d1",1,2600,"MO","1",2600,"2","2020-05-13 13:20:59","2","2020-05-13 13:20:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 13:20:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8166","RENT","\u9810\u7e73\u79df\u91d1",2,2600,"MO","1",2600,"2","2020-05-13 13:20:59","2","2020-05-13 13:20:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 13:20:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8166","RENT","\u9810\u7e73\u79df\u91d1",3,2600,"MO","1",2600,"2","2020-05-13 13:20:59","2","2020-05-13 13:20:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 13:20:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8166","RENT","\u9810\u7e73\u79df\u91d1",4,2600,"MO","1",2600,"2","2020-05-13 13:20:59","2","2020-05-13 13:20:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 13:20:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8166","RENT","\u9810\u7e73\u79df\u91d1",5,2600,"MO","1",2600,"2","2020-05-13 13:20:59","2","2020-05-13 13:20:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 13:20:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8166","RENT","\u9810\u7e73\u79df\u91d1",6,2600,"MO","1",2600,"2","2020-05-13 13:20:59","2","2020-05-13 13:20:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 13:20:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[15600,0,"8166"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-13 13:20:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1265,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207811","2020-05-13 13:20:59",15600,"2","2020-05-13 13:20:59","2","2020-05-13 13:20:59","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 13:20:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7811","DEPOSIT",null,"PAID","2020-05-13 13:20:59",0,"2","2020-05-13 13:20:59","2","2020-05-13 13:20:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 13:20:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7811","INVOICE","8166","PAID","2020-05-13 13:20:59",15600,"2","2020-05-13 13:20:59","2","2020-05-13 13:20:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 14:24:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 14:38:18","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":"all=1&msg=%E5%8F%96%E6%B6%88&page=3&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1121","master_room_id":"114","room_code":"A05-119"},{"room_id":"1120","master_room_id":"114","room_code":"A05-118"},{"room_id":"1127","master_room_id":"114","room_code":"A05-125"},{"room_id":"1128","master_room_id":"114","room_code":"A05-126"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":645,"customer_code":"C170645","identity_type":"PERSONAL","identity_id":"K758362(1)","title":"Ms","lastname":"Lo","firstname":"Chi Man","companyname":"","email":"genena22@hotmail.com","tel":"91944806","address":"Flat 414, Hoy Au Lau, 30 Aberdeen Reservoir Road, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1930.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-13","renew_room_key":"055,32901","renew_remark":"1 month contract. Storage rental paid by PPS on April 1, 2020. Storage deposit transferred from agreement A18-CT207380 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207547, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"104","order_discount":[],"order_room":[{"room_id":"921","room_code":"U22","retail_price":"1930.0","discounted_price":"1930.00","location_id":"3"}],"roughly_size":"25","total_retail_price":1930,"total_discounted_price":1930,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1930,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-13","rent_from":"2020-05-13","rent_to":"2020-06-12","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on May 12, 2020. Storage deposit transferred from agreement A18-CT207547 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1930,"final_order_total":1930,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,32901","order_product":[],"pass":true}},"first_order_id":"4603","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> U22 <\/td>\r\n\t\t\t\t\t 5X5X7 <\/td>\r\n\t\t\t\t\t $1930.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\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":"25","total_discounted_price":"1930.0","deposit":"0","total_retail_price":"1930.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 14:38:19","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",645,"NEW","A18-CT207838",1930,1930,0,0,"1","1",1930,1930,1930,"2020-05-13 14:38:19","0",null,null,null,"2020-05-13","2020-06-12","1 month contract. Storage rental paid by PPS on May 12, 2020. Storage deposit transferred from agreement A18-CT207547 to this agreement.\r\n","2020-05-13","25",0,null,0,"0","2","2020-05-13 14:38:18","2","2020-05-13 14:38:18","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,32901","C170645","PERSONAL","Ms","+C9tc1TdnI5EfCJwPTju+g==","4w4biS+jM\/Q3DAzxHdf3pA==","","QMkWrBFC2X6lmw9G0kXHhByvUdctN4xesGoioPV7sHj0ug\/2VE3Vu0hVGC54w69582+1x9K+zMchNd7qlRGsNg==","h+d\/rmx9gukw63otAze1Lw==","1z3NagnfII+6QFgwXezQPOKHlQj6cPA1M\/NudLu\/U1M=","qSA+xbsjXbCHJxgeqBksBQ==",null,1,"4603"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 14:38:19","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":["7838","921","1930.0","1930.00","2","2020-05-13 14:38:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 14:38:19","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-13","2020-06-12","921"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-13 14:38:19","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":["7838",645,"SETTLED","A18-I208167","2020-05-13 14:38:18","2020-05-13","2","2020-05-13 14:38:18","2","2020-05-13 14:38:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 14:38:19","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":["8167","RENT","\u9810\u7e73\u79df\u91d1",1,1930,"MO","1",1930,"2","2020-05-13 14:38:18","2","2020-05-13 14:38:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 14:38:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1930,0,"8167"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-13 14:38:19","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":[645,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207812","2020-05-13 14:38:18",1930,"2","2020-05-13 14:38:18","2","2020-05-13 14:38:18","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 14:38:19","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":["7812","DEPOSIT",null,"PAID","2020-05-13 14:38:18",0,"2","2020-05-13 14:38:18","2","2020-05-13 14:38:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 14:38:19","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":["7812","INVOICE","8167","PAID","2020-05-13 14:38:18",1930,"2","2020-05-13 14:38:18","2","2020-05-13 14:38:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 14:40: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":"all=1&msg=%E5%8F%96%E6%B6%88&page=3&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1121","master_room_id":"114","room_code":"A05-119"},{"room_id":"1120","master_room_id":"114","room_code":"A05-118"},{"room_id":"1127","master_room_id":"114","room_code":"A05-125"},{"room_id":"1128","master_room_id":"114","room_code":"A05-126"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":645,"customer_code":"C170645","identity_type":"PERSONAL","identity_id":"K758362(1)","title":"Ms","lastname":"Lo","firstname":"Chi Man","companyname":"","email":"genena22@hotmail.com","tel":"91944806","address":"Flat 414, Hoy Au Lau, 30 Aberdeen Reservoir Road, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3180.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-27","renew_room_key":"055,32901","renew_remark":"1 month contract. Storage rental paid by PPS on April 1, 2020. Storage deposit transferred from agreement A18-CT207381 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207548, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"102","order_discount":[],"order_room":[{"room_id":"951","room_code":"V25","retail_price":"3180.0","discounted_price":"3180.00","location_id":"3"}],"roughly_size":"42","total_retail_price":3180,"total_discounted_price":3180,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":3180,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-27","rent_from":"2020-05-27","rent_to":"2020-06-26","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on May 12, 2020. Storage deposit transferred from agreement A18-CT207548 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":3180,"final_order_total":3180,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,32901","order_product":[],"pass":true}},"first_order_id":"4604","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> V25 <\/td>\r\n\t\t\t\t\t 6X7X7 <\/td>\r\n\t\t\t\t\t $3180.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":"42","total_discounted_price":"3180.0","deposit":"0","total_retail_price":"3180.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 14:40: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",645,"NEW","A18-CT207839",3180,3180,0,0,"1","1",3180,3180,3180,"2020-05-13 14:40:06","0",null,null,null,"2020-05-27","2020-06-26","1 month contract. Storage rental paid by PPS on May 12, 2020. Storage deposit transferred from agreement A18-CT207548 to this agreement.\r\n","2020-05-27","42",0,null,0,"0","2","2020-05-13 14:40:06","2","2020-05-13 14:40:06","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,32901","C170645","PERSONAL","Ms","+C9tc1TdnI5EfCJwPTju+g==","4w4biS+jM\/Q3DAzxHdf3pA==","","QMkWrBFC2X6lmw9G0kXHhByvUdctN4xesGoioPV7sHj0ug\/2VE3Vu0hVGC54w69582+1x9K+zMchNd7qlRGsNg==","h+d\/rmx9gukw63otAze1Lw==","1z3NagnfII+6QFgwXezQPOKHlQj6cPA1M\/NudLu\/U1M=","qSA+xbsjXbCHJxgeqBksBQ==",null,1,"4604"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 14:40: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":["7839","951","3180.0","3180.00","2","2020-05-13 14:40:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 14:40:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-27","2020-06-26","951"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-13 14:40: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":["7839",645,"SETTLED","A18-I208168","2020-05-13 14:40:06","2020-05-27","2","2020-05-13 14:40:06","2","2020-05-13 14:40:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 14:40: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":["8168","RENT","\u9810\u7e73\u79df\u91d1",1,3180,"MO","1",3180,"2","2020-05-13 14:40:06","2","2020-05-13 14:40:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 14:40:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3180,0,"8168"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-13 14:40: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":[645,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207813","2020-05-13 14:40:06",3180,"2","2020-05-13 14:40:06","2","2020-05-13 14:40:06","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 14:40: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":["7813","DEPOSIT",null,"PAID","2020-05-13 14:40:06",0,"2","2020-05-13 14:40:06","2","2020-05-13 14:40:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 14:40: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":["7813","INVOICE","8168","PAID","2020-05-13 14:40:06",3180,"2","2020-05-13 14:40:06","2","2020-05-13 14:40:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 15:29:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 15:29:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 15:43:15","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=437&filter3=undefined&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":"759","master_room_id":"35","room_code":"O35"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \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> O35 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"D612903(0)","title":"Mrs","lastname":"Lo","firstname":"Ah Fong ","companyname":"","email":"","tel":"94555435","address":"Flat E,22\/F,Pak King Court,South Horizons,HK","pass":true,"customer_id":"437","customer_code":"C170437","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"759","room_code":"O35","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":935,"deposit":2076,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":4010,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3676.00","warehousing_date":"2020-05-15","rent_from":"2020-05-15","rent_to":"2020-11-14","delivery_service":"0","remark":"6 months contract. Change unit from K49 K50 to O35. Storage renal and deposit $3676 transferred from agreement A14-CT196401 to this agreement. Remaining balance $4010 paid by cash on May 13, 2020. ","paymethod":"CASH","paymethod2":"CASH","discount_deduct":3676,"order_total":7686,"final_order_total":4010,"location_id":"2","branch_id":"1","company_id":"1","room_key":"134,54409","order_product":[],"pass":true}},"roughly_size":"16","total_discounted_price":"935.00","deposit":"2076.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 15:43:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2","437","NEW","A14-CT207840",1098,935,2076,0,"6","6",4010,7686,4010,"2020-05-13 15:43:16","0",null,null,null,"2020-05-15","2020-11-14","6 months contract. Change unit from K49 K50 to O35. Storage renal and deposit $3676 transferred from agreement A14-CT196401 to this agreement. Remaining balance $4010 paid by cash on May 13, 2020. ","2020-05-15","16",0,null,3676,"3676.00","2","2020-05-13 15:43:15","2","2020-05-13 15:43:15","CASH","","","","CASH","","","",null,0,"134,54409","C170437","PERSONAL","Mrs","n9hth2fgsU3vQg0TbE8sxA==","4w4biS+jM\/Q3DAzxHdf3pA==","","OlZWouijSK5Sal7NKryvoYU6ka9Zr7KedBHWAv7Qk7CdCJD5XryYMzMn6AvtPS7G","Rf3CcBMRsJs2KmxIEFBhaQ==",null,"A4AfFnmwn6bvlBgVucwOzg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 15:43:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7840","759","1098.0","1098.00","2","2020-05-13 15:43:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 15:43:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-15","2020-11-14","759"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-13 15:43:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["7840","A14-D205408","PAID",2076,0,"2020-11-14","2020-05-13 15:43:15","2020-05-13 15:43:15","2","2020-05-13 15:43:15","2","2020-05-13 15:43:15","437"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 15:43:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7840","437","SETTLED","A14-I208169","2020-05-13 15:43:15","2020-05-15","2","2020-05-13 15:43:15","2","2020-05-13 15:43:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 15:43:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8169","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-13 15:43:15","2","2020-05-13 15:43:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 15:43:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8169","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-05-13 15:43:15","2","2020-05-13 15:43:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 15:43:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8169","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,0,"MO","1",0,"2","2020-05-13 15:43:15","2","2020-05-13 15:43:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 15:43:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8169","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",4,64,"MO","1",64,"2","2020-05-13 15:43:15","2","2020-05-13 15:43:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 15:43:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8169","RENT","\u9810\u7e73\u79df\u91d1",5,935,"MO","1",935,"2","2020-05-13 15:43:15","2","2020-05-13 15:43:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 15:43:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8169","RENT","\u9810\u7e73\u79df\u91d1",6,935,"MO","1",935,"2","2020-05-13 15:43:15","2","2020-05-13 15:43:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 15:43:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1934,0,"8169"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-13 15:43:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["437","CASH","","","","CASH","","","","PAID","P207814","2020-05-13 15:43:15",4010,"2","2020-05-13 15:43:15","2","2020-05-13 15:43:15","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 15:43:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7814","DEPOSIT","5408","PAID","2020-05-13 15:43:15",2076,"2","2020-05-13 15:43:15","2","2020-05-13 15:43:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 15:43:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7814","INVOICE","8169","PAID","2020-05-13 15:43:15",1934,"2","2020-05-13 15:43:15","2","2020-05-13 15:43:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:08:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:32:39","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=INVOICE&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"759","master_room_id":"35","room_code":"O35"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1137,"customer_code":"C181137","identity_type":"PERSONAL","identity_id":"D511733(0)","title":"Ms","lastname":"Cheung","firstname":"Mei Ping","companyname":"","email":null,"tel":"54034230","address":"Flat 3, 23\/F, Block Q, Mei Fai Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-08","renew_room_key":"0007305364","renew_remark":"1 month contract. Storage rental paid by bank transfer on April 13, 2020. Storage deposit transferred from agreement A05-CT207408 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207604, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"110","order_discount":[],"order_room":[{"room_id":"1087","room_code":"A05-085","retail_price":"598.0","discounted_price":"598.00","location_id":"4"}],"roughly_size":"8","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-08","rent_from":"2020-05-08","rent_to":"2020-06-07","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on May 13, 2020. Storage deposit transferred from agreement A05-CT207604 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0007305364","order_product":[],"pass":true}},"first_order_id":"4717","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-085 <\/td>\r\n\t\t\t\t\t 4X2X3.5 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"8","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:32:40","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",1137,"NEW","A05-CT207841",598,598,0,0,"1","1",598,598,598,"2020-05-13 16:32:40","0",null,null,null,"2020-05-08","2020-06-07","1 month contract. Storage rental paid by bank transfer on May 13, 2020. Storage deposit transferred from agreement A05-CT207604 to this agreement.","2020-05-08","8",0,null,0,"0","2","2020-05-13 16:32:39","2","2020-05-13 16:32:39","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0007305364","C181137","PERSONAL","Ms","ov4itGGMhitaTATk31YbvA==","vCxOlXQuvOQaoL822H2o\/Q==","","E1vSnV3\/zTD\/COo0L4lGPzFMAscGCZXb3LMO+qHc4+tCAMOAjpkWSa444NxIRpkUETecgSZwbVUPrOe8jXLqvSR8eOGI+jndWcBFCAJnBXs=","pvHbwmM2tVjF9UsDRGbtTQ==",null,"itJoZuSGBd5W3YULMxGxDQ==",null,1,"4717"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:32:40","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":["7841","1087","598.0","598.00","2","2020-05-13 16:32:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:32:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-08","2020-06-07","1087"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-13 16:32:40","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":["7841",1137,"SETTLED","A05-I208170","2020-05-13 16:32:39","2020-05-08","2","2020-05-13 16:32:39","2","2020-05-13 16:32:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:32:40","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":["8170","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-05-13 16:32:39","2","2020-05-13 16:32:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:32:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8170"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-13 16:32:40","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":[1137,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207815","2020-05-13 16:32:39",598,"2","2020-05-13 16:32:39","2","2020-05-13 16:32:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:32:40","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":["7815","DEPOSIT",null,"PAID","2020-05-13 16:32:39",0,"2","2020-05-13 16:32:39","2","2020-05-13 16:32:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:32:40","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":["7815","INVOICE","8170","PAID","2020-05-13 16:32:39",598,"2","2020-05-13 16:32:39","2","2020-05-13 16:32:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:36:14","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=INVOICE&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"759","master_room_id":"35","room_code":"O35"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":325,"customer_code":"C170325","identity_type":"PERSONAL","identity_id":"R804168(6)","title":"Mr","lastname":"ANSELL ","firstname":" Shaun Mark","companyname":"","email":"Shaunansell65@gmail.com","tel":"97628676","address":"8A ,238 Abedreen Main Road ,Abedreen HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"568.0","renew_rent_month":"3","renew_warehousing_date":"2020-05-01","renew_room_key":"054,19016","renew_remark":"3 months contract. Storage rental paid by Cash on January 31, 2020. Storage deposit transferred from agreement A12-CT196268 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207074, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"1","order_discount":[],"order_room":[{"room_id":"201","room_code":"D05","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":568,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":1704,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-01","rent_from":"2020-05-01","rent_to":"2020-07-31","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on May 13, 2020. Storage deposit transferred from agreement A12-CT207074 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1704,"final_order_total":1704,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,19016","order_product":[],"pass":true}},"first_order_id":"4213","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> D05 <\/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> \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":"12","total_discounted_price":"568.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:36:15","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",325,"NEW","A12-CT207842",598,568,0,0,"3","3",1704,1704,1704,"2020-05-13 16:36:15","0",null,null,null,"2020-05-01","2020-07-31","3 months contract. Storage rental paid by bank transfer on May 13, 2020. Storage deposit transferred from agreement A12-CT207074 to this agreement.\r\n","2020-05-01","12",0,null,0,"0","2","2020-05-13 16:36:14","2","2020-05-13 16:36:14","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,19016","C170325","PERSONAL","Mr","Op\/ODZ4wbP+60KE6RPIyPw==","Bb7vJXwZTn9s6cwQVmmq5A==","","XJh\/zq4yghgOiMDx+HvjYwkb3e7LVIxbAq1KVCxvfDsgALe\/FCNW\/\/PHGOmdfiBy","VHHhJn4Sh7PNcqKksmKQOA==","ZNLdRFW35r0FbcjlpTIPXOhuy+O3b88HjDyoea83SuM=","AQ1LL32uAIa7iL0zQQFXyw==",null,1,"4213"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:36:15","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":["7842","201","598.0","598.00","2","2020-05-13 16:36:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:36:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-01","2020-07-31","201"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-13 16:36:15","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":["7842",325,"SETTLED","A12-I208171","2020-05-13 16:36:14","2020-05-01","2","2020-05-13 16:36:14","2","2020-05-13 16:36:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:36:15","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":["8171","RENT","\u9810\u7e73\u79df\u91d1",1,568,"MO","1",568,"2","2020-05-13 16:36:14","2","2020-05-13 16:36:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:36:15","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":["8171","RENT","\u9810\u7e73\u79df\u91d1",2,568,"MO","1",568,"2","2020-05-13 16:36:14","2","2020-05-13 16:36:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:36:15","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":["8171","RENT","\u9810\u7e73\u79df\u91d1",3,568,"MO","1",568,"2","2020-05-13 16:36:14","2","2020-05-13 16:36:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:36:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1704,0,"8171"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-13 16:36:15","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":[325,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207816","2020-05-13 16:36:14",1704,"2","2020-05-13 16:36:14","2","2020-05-13 16:36:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:36:15","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":["7816","DEPOSIT",null,"PAID","2020-05-13 16:36:14",0,"2","2020-05-13 16:36:14","2","2020-05-13 16:36:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:36:15","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":["7816","INVOICE","8171","PAID","2020-05-13 16:36:14",1704,"2","2020-05-13 16:36:14","2","2020-05-13 16:36:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:48:07","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":"759","master_room_id":"35","room_code":"O35"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":818,"customer_code":"C180818","identity_type":"PERSONAL","identity_id":"D703992(2)","title":"Ms","lastname":"Fung","firstname":"Wai Ching","companyname":"","email":"chip_n_dale166@yahoo.com.hk","tel":"98125760","address":"Room 4, 3\/F, Kong Tai Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2202.0","renew_rent_month":"3","renew_warehousing_date":"2020-04-16","renew_room_key":"054,17784","renew_remark":"3 months contract. Storage rental paid by PPS on February 20, 2020. Storage deposit transferred from agreement A14-CT196348 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207240, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[{"master_room_discount_id":"434","master_room_id":"35","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"516","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"434","master_room_id":"35","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"803","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"803","room_code":"K61","retail_price":"1098.0","discounted_price":1043.4,"location_id":"2"},{"room_id":"516","room_code":"K53","retail_price":"1098.0","discounted_price":1043.4,"location_id":"2"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":2202,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":6606,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-16","rent_from":"2020-04-16","rent_to":"2020-07-15","delivery_service":"0","remark":"3 months contract. Storage rental paid by PPS on May 12, 2020. Storage deposit transferred from agreement A14-CT207240 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6606,"final_order_total":6606,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,17784","order_product":[],"pass":true}},"first_order_id":"4838","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> K61 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> K53 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"2202.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:48:08","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",818,"NEW","A14-CT207843",2196,2202,0,0,"3","3",6606,6606,6606,"2020-05-13 16:48:08","0",null,null,null,"2020-04-16","2020-07-15","3 months contract. Storage rental paid by PPS on May 12, 2020. Storage deposit transferred from agreement A14-CT207240 to this agreement.\r\n","2020-04-16","32",0,null,0,"0","2","2020-05-13 16:48:07","2","2020-05-13 16:48:07","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,17784","C180818","PERSONAL","Ms","yu\/0S+RF2RRsi8jECHi7sQ==","fw9NU0t2sgJqYX3ZpxPMlA==","","aaFSbXHSM+gPlOwdl71kBt7soBX\/1aneMHEJOQYEO6L+eTZCyEdmviQxuPN7ErkMp8jCZMURTq8BYQgvLiGXScTEP6pC0Wf9Qm9V\/ZEYNWo=","2XbqO7eDKwpKi\/y4qvPGdQ==","RSOrop83aKNG+aZKY\/WBkseqisNlK416aa5o4eaZ8qM=","zaMy9FDDPHyrX0QJz9TXhA==",null,1,"4838"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:48:08","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":["7843","434","35","516","%","4.97",54.5706,"2","2020-05-13 16:48:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:48:08","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":["7843","434","35","803","%","4.97",54.5706,"2","2020-05-13 16:48:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:48:08","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":["7843","803","1098.0",1043.4,"2","2020-05-13 16:48:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:48:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-16","2020-07-15","803"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-13 16:48:08","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":["7843","516","1098.0",1043.4,"2","2020-05-13 16:48:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:48:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-16","2020-07-15","516"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-13 16:48:08","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":["7843",818,"SETTLED","A14-I208172","2020-05-13 16:48:07","2020-04-16","2","2020-05-13 16:48:07","2","2020-05-13 16:48:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:48:08","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":["8172","RENT","\u9810\u7e73\u79df\u91d1",1,2202,"MO","1",2202,"2","2020-05-13 16:48:07","2","2020-05-13 16:48:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:48:08","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":["8172","RENT","\u9810\u7e73\u79df\u91d1",2,2202,"MO","1",2202,"2","2020-05-13 16:48:07","2","2020-05-13 16:48:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:48:08","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":["8172","RENT","\u9810\u7e73\u79df\u91d1",3,2202,"MO","1",2202,"2","2020-05-13 16:48:07","2","2020-05-13 16:48:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:48:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6606,0,"8172"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-13 16:48:08","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":[818,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207817","2020-05-13 16:48:07",6606,"2","2020-05-13 16:48:07","2","2020-05-13 16:48:07","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:48:08","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":["7817","DEPOSIT",null,"PAID","2020-05-13 16:48:07",0,"2","2020-05-13 16:48:07","2","2020-05-13 16:48:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 16:48:08","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":["7817","INVOICE","8172","PAID","2020-05-13 16:48:07",6606,"2","2020-05-13 16:48:07","2","2020-05-13 16:48:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 17:04:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 17:25:52","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&page=2","floor_plan_rent_room":[{"room_id":"759","master_room_id":"35","room_code":"O35"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1078,"customer_code":"C181078","identity_type":"PERSONAL","identity_id":"K106845(8)","title":"Ms","lastname":"Leung","firstname":"Yuk To Anne","companyname":"","email":"msaannee@yahoo.com.hk","tel":"91957008","address":"Flat E, 11\/F, Block 19, Chi Fu Fa Yuen, 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":"981.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-14","renew_room_key":"0012388479","renew_remark":"6 months contract. Storage rental paid by bank transfer on November 15, 2019. Storage deposit $2180 transferred from agreement A05-CT183582 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196405, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"113","order_discount":[],"order_room":[{"room_id":"1065","room_code":"A05-063","retail_price":"1090.0","discounted_price":"981.00","location_id":"4"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":981,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":11772,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"981.00","warehousing_date":"2020-05-14","rent_from":"2020-05-14","rent_to":"2021-06-13","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free and 2 renewal gifts. Storage rental paid by EPS on May 13, 2020. Storage deposit $2180 transferred from agreement A05-CT196405 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":981,"order_total":12753,"final_order_total":11772,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012388479","order_product":[],"pass":true}},"first_order_id":"3582","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-063 <\/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","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 17:25:52","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",1078,"NEW","A05-CT207844",1090,981,0,0,"13","13",11772,12753,11772,"2020-05-13 17:25:52","0",null,null,null,"2020-05-14","2021-06-13","13 months contract. Special offer the 13th month free and 2 renewal gifts. Storage rental paid by EPS on May 13, 2020. Storage deposit $2180 transferred from agreement A05-CT196405 to this agreement. ","2020-05-14","12",0,null,981,"981.00","2","2020-05-13 17:25:52","2","2020-05-13 17:25:52","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"0012388479","C181078","PERSONAL","Ms","q3JwePH6ZJ7kv\/yQvraNHg==","xEf2h2aoyRQ71ZVgBH+9WQ==","","B7SZjWswgxtdYgRA+Uj8unrOTa1eVXFJtUxAaUEu2bxooH8ApxOH\/EI7vUM7edAsuv8xPxHdcXhmm+ekQtuVzQ==","BHmWAYqNZHALgajI600zNQ==","TLtqGsFQQVDBeG\/mAWVfotHfnNaPanGEq3WtPBVoX78=","IemuCh0LSrNIhkYjmzC4wQ==",null,1,"3582"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 17:25:52","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":["7844","1065","1090.0","981.00","2","2020-05-13 17:25:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 17:25:52","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-14","2021-06-13","1065"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-13 17:25:52","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":["7844",1078,"SETTLED","A05-I208173","2020-05-13 17:25:52","2020-05-14","2","2020-05-13 17:25:52","2","2020-05-13 17:25:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 17:25:52","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":["8173","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,981,"MO","1",981,"2","2020-05-13 17:25:52","2","2020-05-13 17:25:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 17:25:52","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":["8173","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2020-05-13 17:25:52","2","2020-05-13 17:25:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 17:25:52","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":["8173","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2020-05-13 17:25:52","2","2020-05-13 17:25:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 17:25:52","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":["8173","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2020-05-13 17:25:52","2","2020-05-13 17:25:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 17:25:52","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":["8173","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2020-05-13 17:25:52","2","2020-05-13 17:25:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 17:25:52","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":["8173","RENT","\u9810\u7e73\u79df\u91d1",7,981,"MO","1",981,"2","2020-05-13 17:25:52","2","2020-05-13 17:25:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 17:25:52","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":["8173","RENT","\u9810\u7e73\u79df\u91d1",8,981,"MO","1",981,"2","2020-05-13 17:25:52","2","2020-05-13 17:25:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 17:25:52","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":["8173","RENT","\u9810\u7e73\u79df\u91d1",9,981,"MO","1",981,"2","2020-05-13 17:25:52","2","2020-05-13 17:25:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 17:25:52","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":["8173","RENT","\u9810\u7e73\u79df\u91d1",10,981,"MO","1",981,"2","2020-05-13 17:25:52","2","2020-05-13 17:25:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 17:25:52","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":["8173","RENT","\u9810\u7e73\u79df\u91d1",11,981,"MO","1",981,"2","2020-05-13 17:25:52","2","2020-05-13 17:25:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 17:25:52","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":["8173","RENT","\u9810\u7e73\u79df\u91d1",12,981,"MO","1",981,"2","2020-05-13 17:25:52","2","2020-05-13 17:25:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 17:25:52","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":["8173","RENT","\u9810\u7e73\u79df\u91d1",13,981,"MO","1",981,"2","2020-05-13 17:25:52","2","2020-05-13 17:25:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 17:25:52","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11772,0,"8173"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-13 17:25:52","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":[1078,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207818","2020-05-13 17:25:52",11772,"2","2020-05-13 17:25:52","2","2020-05-13 17:25:52","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 17:25:52","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":["7818","DEPOSIT",null,"PAID","2020-05-13 17:25:52",0,"2","2020-05-13 17:25:52","2","2020-05-13 17:25:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 17:25:52","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":["7818","INVOICE","8173","PAID","2020-05-13 17:25:52",11772,"2","2020-05-13 17:25:52","2","2020-05-13 17:25:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-13 17:44:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****