{"created_at":"2020-05-28 09:58:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 10:23:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 12:56:10","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1270&filter3=undefined","floor_plan_rent_room":[{"room_id":"697","master_room_id":"28","room_code":"N14"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1270,"customer_code":"C191270","identity_type":"PERSONAL","identity_id":"G546063(7)","title":"Ms","lastname":"FAN","firstname":"Mei Ling","companyname":"","email":"cynthiafan56@hotmail.com","tel":"91947566","address":"Flat D, 9\/F, Tower 2, Neptune Terrace, 11 Tai Man Street, Chai Wan, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"729.0","renew_rent_month":"12","renew_warehousing_date":"2020-05-25","renew_room_key":"'0005795981, 0005011945","renew_remark":"12 months contract. Special offer 2 months off. $500 deposit paid on May 14, 2019. Storage rental and deposit paid by cheque on May 18, 2019. 2 smartcard provided on May 18, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT194998, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $810.0","renew_master_room_id":"167","order_discount":[{"master_room_discount_id":"407","master_room_id":"167","discount_type":"%","price":"810.00","disocunted_price":"608.80","discount":"24.84","monthly_deduct":201.204,"room_id":"1360","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1360","room_code":"C15-054","retail_price":"810.0","discounted_price":608.8,"location_id":"6"}],"roughly_size":"12","total_retail_price":810,"total_discounted_price":729,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":4374,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-25","rent_from":"2020-05-25","rent_to":"2020-11-24","delivery_service":"0","remark":"6 months contract. Storage rental paid by PPS on May 22, 2020. Storage deposit $810 transferred from agreement C15-CT194998 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":4374,"final_order_total":4374,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0005795981, 0005011945","order_product":[],"pass":true}},"first_order_id":4998,"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-054 <\/td>\r\n\t\t\t\t\t	4X3X6.5 <\/td>\r\n\t\t\t\t\t	$810.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"729.00","deposit":"0.00","total_retail_price":"810.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 12:56:11","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",1270,"NEW","C15-CT207977",810,729,0,0,"6","6",4374,4374,4374,"2020-05-28 12:56:11","0",null,null,null,"2020-05-25","2020-11-24","6 months contract. Storage rental paid by PPS on May 22, 2020. Storage deposit $810 transferred from agreement C15-CT194998 to this agreement. \r\n","2020-05-25","12",0,null,0,"0","2","2020-05-28 12:56:10","2","2020-05-28 12:56:10","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"'0005795981, 0005011945","C191270","PERSONAL","Ms","VqAnviVtDDTIwLD+q0gSYw==","QDZ0QffxYncTRu3rFOvjaw==","","2jjBmJKZY22YYRUO5\/rmaAiLKYwWWes56zwssQrVvtJUqI1RSH2L2b9l\/oAkwAm7Rk4r0FEQMJ9ZwPCY\/LwZ2dYD16YFkhWxIL47xeCVFGA=","2lRak+ZEXaox1qwD7NU7lQ==","IX+yPYMksLvMFCBi9XTVvueB+NkTqRQ7AqzyJZjxC7I=","4A8xZvuZMdyT5B7IrM2j9g==",null,1,4998]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 12:56:11","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":["7977","407","167","1360","%","24.84",201.204,"2","2020-05-28 12:56:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 12:56:11","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":["7977","1360","810.0",608.8,"2","2020-05-28 12:56:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 12:56:11","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-25","2020-11-24","1360"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-28 12:56:11","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":["7977",1270,"SETTLED","C15-I208306","2020-05-28 12:56:10","2020-05-25","2","2020-05-28 12:56:10","2","2020-05-28 12:56:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 12:56:11","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":["8306","RENT","\u9810\u7e73\u79df\u91d1",1,729,"MO","1",729,"2","2020-05-28 12:56:10","2","2020-05-28 12:56:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 12:56:11","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":["8306","RENT","\u9810\u7e73\u79df\u91d1",2,729,"MO","1",729,"2","2020-05-28 12:56:10","2","2020-05-28 12:56:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 12:56:11","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":["8306","RENT","\u9810\u7e73\u79df\u91d1",3,729,"MO","1",729,"2","2020-05-28 12:56:10","2","2020-05-28 12:56:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 12:56:11","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":["8306","RENT","\u9810\u7e73\u79df\u91d1",4,729,"MO","1",729,"2","2020-05-28 12:56:10","2","2020-05-28 12:56:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 12:56:11","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":["8306","RENT","\u9810\u7e73\u79df\u91d1",5,729,"MO","1",729,"2","2020-05-28 12:56:10","2","2020-05-28 12:56:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 12:56:11","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":["8306","RENT","\u9810\u7e73\u79df\u91d1",6,729,"MO","1",729,"2","2020-05-28 12:56:10","2","2020-05-28 12:56:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 12:56:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4374,0,"8306"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-28 12:56:11","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":[1270,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207950","2020-05-28 12:56:10",4374,"2","2020-05-28 12:56:10","2","2020-05-28 12:56:10","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 12:56:11","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":["7950","DEPOSIT",null,"PAID","2020-05-28 12:56:10",0,"2","2020-05-28 12:56:10","2","2020-05-28 12:56:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 12:56:11","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":["7950","INVOICE","8306","PAID","2020-05-28 12:56:10",4374,"2","2020-05-28 12:56:10","2","2020-05-28 12:56:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 14:00:54","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1270&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"697","master_room_id":"28","room_code":"N14"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":652,"customer_code":"C170652","identity_type":"PERSONAL","identity_id":"D708260(7)","title":"Mr","lastname":"Tam","firstname":"Ming Kit ","companyname":"","email":"flyboy731@gmail.com","tel":"96525971","address":"Flat 5, 6\/f, Kong Wing Court Aberdeen Centre ","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1090.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-01","renew_room_key":"054,41837","renew_remark":"1 month contract. Storage rental paid by PPS on April 29, 2020. Storage deposit transferred from agreement A18-CT207521 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207777, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"77","order_discount":[],"order_room":[{"room_id":"837","room_code":"R11","retail_price":"1090.0","discounted_price":"1090.00","location_id":"3"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":1090,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1090,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-01","rent_from":"2020-06-01","rent_to":"2020-06-30","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on May 25, 2020. Storage deposit transferred from agreement A18-CT207777 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1090,"final_order_total":1090,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,41837","order_product":[],"pass":true}},"first_order_id":"4853","selected_room_tr":"	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> R11 <\/td>\r\n\t\t\t\t\t 3X4X7 <\/td>\r\n\t\t\t\t\t $1090.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"1090.0","deposit":"0","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 14:00:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",652,"NEW","A18-CT207978",1090,1090,0,0,"1","1",1090,1090,1090,"2020-05-28 14:00:55","0",null,null,null,"2020-06-01","2020-06-30","1 month contract. Storage rental paid by PPS on May 25, 2020. Storage deposit transferred from agreement A18-CT207777 to this agreement.\r\n","2020-06-01","12",0,null,0,"0","2","2020-05-28 14:00:54","2","2020-05-28 14:00:54","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,41837","C170652","PERSONAL","Mr","SNekCwopks2jcqexjcIyHg==","RAqogkelEKt1q5b\/6Neu\/g==","","n56ucwsCeMJCZJzkVQ6k1WBlpaRdIidZGXGL94XS5YnAhumcwszABrybE3YYUXEa","vWdjb89guDF+JdQiVIW+vA==","7jhdXQwxz0eVBJmxgK0I3558T6i6tRkWYOXpLO7HShk=","7ygY2utveKNtmE8VDaM3iw==",null,1,"4853"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 14:00:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7978","837","1090.0","1090.00","2","2020-05-28 14:00:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 14:00:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-06-30","837"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-28 14:00:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7978",652,"SETTLED","A18-I208307","2020-05-28 14:00:54","2020-06-01","2","2020-05-28 14:00:54","2","2020-05-28 14:00:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 14:00:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8307","RENT","\u9810\u7e73\u79df\u91d1",1,1090,"MO","1",1090,"2","2020-05-28 14:00:54","2","2020-05-28 14:00:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 14:00:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1090,0,"8307"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-28 14:00:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[652,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207951","2020-05-28 14:00:54",1090,"2","2020-05-28 14:00:54","2","2020-05-28 14:00:54","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 14:00:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7951","DEPOSIT",null,"PAID","2020-05-28 14:00:54",0,"2","2020-05-28 14:00:54","2","2020-05-28 14:00:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 14:00:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7951","INVOICE","8307","PAID","2020-05-28 14:00:54",1090,"2","2020-05-28 14:00:54","2","2020-05-28 14:00:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 14:07:25","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1270&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"697","master_room_id":"28","room_code":"N14"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":874,"customer_code":"C180874","identity_type":"PERSONAL","identity_id":"K451268(5)","title":"Mr","lastname":"Lui","firstname":"Chun Hung","companyname":"","email":"patpat9413888@yahoo.com.hk","tel":"90301273","address":"Room 403, Low Block, Lei Fook House, Apleichau Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-22","renew_room_key":"076,32357","renew_remark":"1 month contract. Storage rental paid by PPS on April 24, 2020. Storage deposit transferred from agreement A12-CT207534 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207722, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"241","room_code":"D45","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-22","rent_from":"2020-05-22","rent_to":"2020-06-21","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on May 26, 2020. Storage deposit transferred from agreement A12-CT207722 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"076,32357","order_product":[],"pass":true}},"first_order_id":"4854","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> D45 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 14:07: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","1",874,"NEW","A12-CT207979",998,1038,0,0,"1","1",1038,1038,1038,"2020-05-28 14:07:25","0",null,null,null,"2020-05-22","2020-06-21","1 month contract. Storage rental paid by PPS on May 26, 2020. Storage deposit transferred from agreement A12-CT207722 to this agreement.\r\n","2020-05-22","12",0,null,0,"0","2","2020-05-28 14:07:25","2","2020-05-28 14:07:25","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"076,32357","C180874","PERSONAL","Mr","8E6nLeLaS+nuXxUNvooxGQ==","vyCKi4IYWx3VnCZylJM1yA==","","t2fcXTNQ5zXw41HK7XLxjgpqs4CAbleDk0AZC75MEKtw5ZsokMMh80cI\/IUaR9tYbJXdnEldy\/dOlMJjVNoCJBK+BLg2Hq37YGStg4SRRpc=","v99UbwvGk\/IX8Amdc7pe+Q==","93qNDvLNra1NfZlAUamtzf14nbvapEp9X2o2aos8F7w=","fzIJnHKlsYW3ETkg3nSzoQ==",null,1,"4854"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 14:07: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":["7979","241","998.0","998.00","2","2020-05-28 14:07:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 14:07: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-22","2020-06-21","241"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-28 14:07: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":["7979",874,"SETTLED","A12-I208308","2020-05-28 14:07:25","2020-05-22","2","2020-05-28 14:07:25","2","2020-05-28 14:07:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 14:07: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":["8308","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-05-28 14:07:25","2","2020-05-28 14:07:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 14:07:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"8308"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-28 14:07: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":[874,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207952","2020-05-28 14:07:25",1038,"2","2020-05-28 14:07:25","2","2020-05-28 14:07:25","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 14:07: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":["7952","DEPOSIT",null,"PAID","2020-05-28 14:07:25",0,"2","2020-05-28 14:07:25","2","2020-05-28 14:07:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 14:07: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":["7952","INVOICE","8308","PAID","2020-05-28 14:07:25",1038,"2","2020-05-28 14:07:25","2","2020-05-28 14:07:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 14:16:27","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1270&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":"697","master_room_id":"28","room_code":"N14"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":888,"customer_code":"C180888","identity_type":"PERSONAL","identity_id":"K099955(5)","title":"Ms","lastname":"Ho","firstname":"Man Yee Cherie","companyname":"","email":"cheriehmy@gmail.com","tel":"90575456","address":"Flat A, 1\/F, Block 9, Fullview Garden, 18 Siu Sai Wan Road, Siu Sai Wan, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1112.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-27","renew_room_key":"0005763937","renew_remark":"1 month contract. Storage rental paid by PPS on April 16, 2020. Storage deposit $2224 transferred from agreement B01-CT207477 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT207661, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"140","order_discount":[],"order_room":[{"room_id":"1237","room_code":"B01-047","retail_price":"1112.0","discounted_price":"1112.00","location_id":"5"}],"roughly_size":"16","total_retail_price":1112,"total_discounted_price":1112,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1112,"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 26, 2020. Storage deposit $2224 transferred from agreement B01-CT207661 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1112,"final_order_total":1112,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0005763937","order_product":[],"pass":true}},"first_order_id":"4003","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> B01-047 <\/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":"16","total_discounted_price":"1112.0","deposit":"0","total_retail_price":"1112.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 14:16: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",888,"NEW","B01-CT207980",1112,1112,0,0,"1","1",1112,1112,1112,"2020-05-28 14:16:28","0",null,null,null,"2020-05-27","2020-06-26","1 month contract. Storage rental paid by PPS on May 26, 2020. Storage deposit $2224 transferred from agreement B01-CT207661 to this agreement.\r\n","2020-05-27","16",0,null,0,"0","2","2020-05-28 14:16:27","2","2020-05-28 14:16:27","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0005763937","C180888","PERSONAL","Ms","B6XcmzmDA9cWki+qLStEaA==","D\/skxQ5s\/L5yyRWaDK\/iSg==","","zb+wEJU2BcjiqagYCnyRNQzS3jTcz1KQCkGgLWtY\/y+C8KU+srfsdCNTrRUrjSHTpRbkV0JFumXQh3K4klaHUNKIaPzoQH6Ro1qQAUtDwWHyil1VPuPOWLDOdLKNt30K","Mv9sZMBZUVgbHGVZIxyZfQ==","d8Ms1Ternr8fasYV7yyV8x0bubUdhthIhbdOyphH3tQ=","b0wVwk81Vh1dF13X\/TkOaw==",null,1,"4003"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 14:16: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":["7980","1237","1112.0","1112.00","2","2020-05-28 14:16:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 14:16: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-27","2020-06-26","1237"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-28 14:16: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":["7980",888,"SETTLED","B01-I208309","2020-05-28 14:16:27","2020-05-27","2","2020-05-28 14:16:27","2","2020-05-28 14:16:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 14:16: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":["8309","RENT","\u9810\u7e73\u79df\u91d1",1,1112,"MO","1",1112,"2","2020-05-28 14:16:27","2","2020-05-28 14:16:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 14:16:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1112,0,"8309"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-28 14:16: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":[888,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207953","2020-05-28 14:16:27",1112,"2","2020-05-28 14:16:27","2","2020-05-28 14:16:27","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 14:16: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":["7953","DEPOSIT",null,"PAID","2020-05-28 14:16:27",0,"2","2020-05-28 14:16:27","2","2020-05-28 14:16:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 14:16: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":["7953","INVOICE","8309","PAID","2020-05-28 14:16:27",1112,"2","2020-05-28 14:16:27","2","2020-05-28 14:16:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 14:49:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:11:48","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=1&filter2=1270&filter3=undefined&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":"697","master_room_id":"28","room_code":"N14"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1234,"customer_code":"C191234","identity_type":"PERSONAL","identity_id":"A992753(3)","title":"Mr","lastname":"Leung","firstname":"Fook Chi","companyname":"","email":null,"tel":"92580224","address":"Flat 612, Hoi Au Lau, Yue Kwong Chuen, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","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-30","renew_room_key":"076,34771","renew_remark":"1 month contract. Storage rental paid by cash on Apr 29,2020. Storage deposit $1196 transferred from agreement A12-CT206956 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207741, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"1","order_discount":[],"order_room":[{"room_id":"206","room_code":"D10","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","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-30","rent_from":"2020-05-30","rent_to":"2020-06-29","delivery_service":"0","remark":"1 month contract. Storage rental paid by cash on May 28, 2020. Storage deposit $1196 transferred from agreement A12-CT207741 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"1","branch_id":"1","company_id":"1","room_key":"076,34771","order_product":[],"pass":true}},"first_order_id":"4825","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> D10 <\/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":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:11:49","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",1234,"NEW","A12-CT207981",598,598,0,0,"1","1",598,598,598,"2020-05-28 15:11:49","0",null,null,null,"2020-05-30","2020-06-29","1 month contract. Storage rental paid by cash on May 28, 2020. Storage deposit $1196 transferred from agreement A12-CT207741 to this agreement.\r\n","2020-05-30","12",0,null,0,"0","2","2020-05-28 15:11:48","2","2020-05-28 15:11:48","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"076,34771","C191234","PERSONAL","Mr","F\/umanY79JktEH7A1eI69g==","xEf2h2aoyRQ71ZVgBH+9WQ==","","XTYU2OniJyv9lUGzwvbJSHyM14sep7GRbYQb3Jgep2k7Fi1IMrcmDV5+Z25SrXkFYSvlx5HtEATFWvWN2DLe2Q==","gnPh6HJdAP7lRaZUREQgWQ==",null,"rDZcYGHuhVj1YRDxDF7BDg==",null,1,"4825"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:11:49","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":["7981","206","598.0","598.00","2","2020-05-28 15:11:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:11:49","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-30","2020-06-29","206"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-28 15:11:49","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":["7981",1234,"SETTLED","A12-I208310","2020-05-28 15:11:48","2020-05-30","2","2020-05-28 15:11:48","2","2020-05-28 15:11:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:11:49","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":["8310","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-05-28 15:11:48","2","2020-05-28 15:11:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:11:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8310"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-28 15:11:49","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":[1234,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207954","2020-05-28 15:11:48",598,"2","2020-05-28 15:11:48","2","2020-05-28 15:11:48","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:11:49","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":["7954","DEPOSIT",null,"PAID","2020-05-28 15:11:48",0,"2","2020-05-28 15:11:48","2","2020-05-28 15:11:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:11:49","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":["7954","INVOICE","8310","PAID","2020-05-28 15:11:48",598,"2","2020-05-28 15:11:48","2","2020-05-28 15:11:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:32:17","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=1&filter2=1270&filter3=undefined&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":"1738","master_room_id":"236","room_code":"WC-31"}],"_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> WC-31 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1888.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","warehousing":{"1":{"new_customer":"1","identity_type":"BUSINESS","identity_id":"65680342","title":"Ms","lastname":"KWOK","firstname":"Pik Shan","companyname":"H AND H WORKS LIMITED","email":"handhworks.hk@gmail.com","tel":"61633563","address":"Shop 1B, G\/F, Kai Wong Commercial Building, 49-51A Cough Street Central, H.K.","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1738","room_code":"WC-31","retail_price":"1888.0","discounted_price":"1888.00","location_id":"8"}],"roughly_size":"16","total_retail_price":1888,"total_discounted_price":1605,"deposit":3210,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":4815,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-29","rent_from":"2020-05-29","rent_to":"2020-06-28","delivery_service":"0","remark":"1 month contract. Storage rental and deposit paid by EPS on May 28, 2020. Smartcard and password lock provided on May 28, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":0,"order_total":4815,"final_order_total":4815,"location_id":"8","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"roughly_size":"16","total_discounted_price":"1605.00","deposit":"3210.00","total_retail_price":"1888.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:32:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201595","BUSINESS","Ms","q40Jz7KgXsE+y74j2rZ59Q==","bGWftO7QHB1VrLc6D5WiAA==","H AND H WORKS LIMITED","U3G+JVqoAbCGIWWCAWYkCw==","0zkW7P37hijyDT9vbr6yOrS+xolTu1sgR2Ib8R9oXa8=","J4k4jtzM79uSoozLNGzaVKZYBr7Y+ewm1DBCj3LplyiBc99nz\/6YZ0+Q2v9TfdQUAtyLdzowUVHupMzWMOf\/90Ku7UX3cB0pz70YKeUjIBE=",null,"F19SjGwo1T71+np8dW8Fww==","0zkW7P37hijyDT9vbr6yOrS+xolTu1sgR2Ib8R9oXa8=","MrJOEaKHeLKIGrr7cDhXSw==","2","2020-05-28 15:32:17","2","2020-05-28 15:32:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:32:18","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","8",1595,"NEW","WC-CT207982",1888,1605,3210,0,"1","1",4815,4815,4815,"2020-05-28 15:32:18","0",null,null,null,"2020-05-29","2020-06-28","1 month contract. Storage rental and deposit paid by EPS on May 28, 2020. Smartcard and password lock provided on May 28, 2020. ","2020-05-29","16",0,null,0,"0","2","2020-05-28 15:32:17","2","2020-05-28 15:32:17","EPS","","","","EPS","","","",null,0,"","C201595","BUSINESS","Ms","q40Jz7KgXsE+y74j2rZ59Q==","bGWftO7QHB1VrLc6D5WiAA==","H AND H WORKS LIMITED","J4k4jtzM79uSoozLNGzaVKZYBr7Y+ewm1DBCj3LplyiBc99nz\/6YZ0+Q2v9TfdQUAtyLdzowUVHupMzWMOf\/90Ku7UX3cB0pz70YKeUjIBE=","U3G+JVqoAbCGIWWCAWYkCw==","0zkW7P37hijyDT9vbr6yOrS+xolTu1sgR2Ib8R9oXa8=",null,"F19SjGwo1T71+np8dW8Fww=="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:32:18","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":["7982","1738","1888.0","1888.00","2","2020-05-28 15:32:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:32:18","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-29","2020-06-28","1738"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-28 15:32:18","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":["7982","WC-D205434","PAID",3210,0,"2020-06-28","2020-05-28 15:32:17","2020-05-28 15:32:17","2","2020-05-28 15:32:17","2","2020-05-28 15:32:17",1595]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:32:18","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":["7982",1595,"SETTLED","WC-I208311","2020-05-28 15:32:17","2020-05-29","2","2020-05-28 15:32:17","2","2020-05-28 15:32:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:32:18","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":["8311","RENT","\u9810\u7e73\u79df\u91d1",1,1605,"MO","1",1605,"2","2020-05-28 15:32:17","2","2020-05-28 15:32:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:32:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1605,0,"8311"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-28 15:32:18","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":[1595,"EPS","","","","EPS","","","","PAID","P207955","2020-05-28 15:32:17",4815,"2","2020-05-28 15:32:17","2","2020-05-28 15:32:17","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:32:18","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":["7955","DEPOSIT","5434","PAID","2020-05-28 15:32:17",3210,"2","2020-05-28 15:32:17","2","2020-05-28 15:32:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:32:18","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":["7955","INVOICE","8311","PAID","2020-05-28 15:32:17",1605,"2","2020-05-28 15:32:17","2","2020-05-28 15:32:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:35:38","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=1&filter2=1270&filter3=undefined&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":"1738","master_room_id":"236","room_code":"WC-31"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1037,"customer_code":"C181037","identity_type":"PERSONAL","identity_id":"R076502(2)","title":"Mr","lastname":"Macintosh","firstname":"Alexander Stuart Petrie","companyname":"","email":"alexmacintosh@mac.com","tel":"66839873","address":"22B, South Tower 8, Bel-Air Phase 2, 38 Bel-Air Avenue, Island South, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1106.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-22","renew_room_key":"189,62758","renew_remark":"6 months contract. Storage rental paid by bank transfer on November 20, 2019. Storage deposit $2456 transferred from agreement A18-CT183524 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196453, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"980","room_code":"X05","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":13944,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1162.00","warehousing_date":"2020-05-22","rent_from":"2020-05-22","rent_to":"2021-06-21","delivery_service":"0","remark":"13 months contract. Special offer the 13th months free. Storage rental paid by bank transfer on May 25, 2020. Storage deposit $2456 transferred from agreement A18-CT196453 to this agreement. ,","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":1162,"order_total":15106,"final_order_total":13944,"location_id":"3","branch_id":"1","company_id":"1","room_key":"189,62758","order_product":[],"pass":true}},"first_order_id":"3524","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> X05 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1162.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:35:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",1037,"NEW","A18-CT207983",1290,1162,0,0,"13","13",13944,15106,13944,"2020-05-28 15:35:39","0",null,null,null,"2020-05-22","2021-06-21","13 months contract. Special offer the 13th months free. Storage rental paid by bank transfer on May 25, 2020. Storage deposit $2456 transferred from agreement A18-CT196453 to this agreement. ,","2020-05-22","16",0,null,1162,"1162.00","2","2020-05-28 15:35:38","2","2020-05-28 15:35:38","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"189,62758","C181037","PERSONAL","Mr","ZTusNJ8HT+0mbR3x5lxUF5qKn+Uc6uLC3pwYtO\/syGg=","BRLQA1km6g4ZTdutj\/MXsA==","","a1vAvbD3YD+jXBAFgVaYid+JJ5zcWh4ffDvLlZ3QdMCkSWXz7mXAt\/VYsjgGDl\/8T8HyiqwWpcR4ILCpH3vATUpHf8B38ZHV5LmbKjh6h4Q=","A+wNeZpa1QwykxgqGUvKXA==","uEkm40F\/SYdNAWN5qjBiln3OzXkJp1i0nvXTbtbWiW0=","SHCZKt9syKemnZQjYUUasA==",null,1,"3524"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:35:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7983","980","1290.0","1290.00","2","2020-05-28 15:35:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:35:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-22","2021-06-21","980"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-28 15:35:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7983",1037,"SETTLED","A18-I208312","2020-05-28 15:35:38","2020-05-22","2","2020-05-28 15:35:38","2","2020-05-28 15:35:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:35:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8312","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1162,"MO","1",1162,"2","2020-05-28 15:35:38","2","2020-05-28 15:35:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:35:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8312","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-05-28 15:35:38","2","2020-05-28 15:35:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:35:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8312","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-05-28 15:35:38","2","2020-05-28 15:35:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:35:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8312","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-05-28 15:35:38","2","2020-05-28 15:35:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:35:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8312","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-05-28 15:35:38","2","2020-05-28 15:35:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:35:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8312","RENT","\u9810\u7e73\u79df\u91d1",7,1162,"MO","1",1162,"2","2020-05-28 15:35:38","2","2020-05-28 15:35:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:35:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8312","RENT","\u9810\u7e73\u79df\u91d1",8,1162,"MO","1",1162,"2","2020-05-28 15:35:38","2","2020-05-28 15:35:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:35:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8312","RENT","\u9810\u7e73\u79df\u91d1",9,1162,"MO","1",1162,"2","2020-05-28 15:35:38","2","2020-05-28 15:35:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:35:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8312","RENT","\u9810\u7e73\u79df\u91d1",10,1162,"MO","1",1162,"2","2020-05-28 15:35:38","2","2020-05-28 15:35:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:35:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8312","RENT","\u9810\u7e73\u79df\u91d1",11,1162,"MO","1",1162,"2","2020-05-28 15:35:38","2","2020-05-28 15:35:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:35:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8312","RENT","\u9810\u7e73\u79df\u91d1",12,1162,"MO","1",1162,"2","2020-05-28 15:35:38","2","2020-05-28 15:35:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:35:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8312","RENT","\u9810\u7e73\u79df\u91d1",13,1162,"MO","1",1162,"2","2020-05-28 15:35:38","2","2020-05-28 15:35:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:35:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13944,0,"8312"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-28 15:35:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1037,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207956","2020-05-28 15:35:38",13944,"2","2020-05-28 15:35:38","2","2020-05-28 15:35:38","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:35:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7956","DEPOSIT",null,"PAID","2020-05-28 15:35:38",0,"2","2020-05-28 15:35:38","2","2020-05-28 15:35:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 15:35:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7956","INVOICE","8312","PAID","2020-05-28 15:35:38",13944,"2","2020-05-28 15:35:38","2","2020-05-28 15:35:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 16:00:41","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":"1738","master_room_id":"236","room_code":"WC-31"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1146,"customer_code":"C181146","identity_type":"PERSONAL","identity_id":"D103036(2)","title":"Ms","lastname":"Leung ","firstname":"Lai Yee","companyname":"","email":null,"tel":"93069953","address":"28\/C , Block 10 , Nam Fung Sun Cheun, Quarry Bay","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1798.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-11","renew_room_key":"0012403799","renew_remark":"1 month contract. Storage rental paid by cheque on April 20,2020. Deposit transferred from agreement C15-CT207426 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT207675, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"170","order_discount":[],"order_room":[{"room_id":"1354","room_code":"C15-048","retail_price":"1108.0","discounted_price":"1108.00","location_id":"6"},{"room_id":"1353","room_code":"C15-047","retail_price":"1108.0","discounted_price":"1108.00","location_id":"6"}],"roughly_size":"32","total_retail_price":2216,"total_discounted_price":1798,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1798,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-11","rent_from":"2020-05-11","rent_to":"2020-06-10","delivery_service":"0","remark":"1 month contract. Storage rental paid by cheque on May 28,2020. Deposit transferred from agreement C15-CT207675 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":1798,"final_order_total":1798,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012403799","order_product":[],"pass":true}},"first_order_id":"4293","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> C15-048 <\/td>\r\n\t\t\t\t\t 4X4X6.5 <\/td>\r\n\t\t\t\t\t $1108.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> C15-047 <\/td>\r\n\t\t\t\t\t 4X4X6.5 <\/td>\r\n\t\t\t\t\t $1108.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":"32","total_discounted_price":"1798.0","deposit":"0","total_retail_price":"2216.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 16:00:41","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",1146,"NEW","C15-CT207984",2216,1798,0,0,"1","1",1798,1798,1798,"2020-05-28 16:00:41","0",null,null,null,"2020-05-11","2020-06-10","1 month contract. Storage rental paid by cheque on May 28,2020. Deposit transferred from agreement C15-CT207675 to this agreement.\r\n","2020-05-11","32",0,null,0,"0","2","2020-05-28 16:00:41","2","2020-05-28 16:00:41","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"0012403799","C181146","PERSONAL","Ms","gjSpyhqyAa7WiwccZ+QVeQ==","EU9enA5\/vY58OMUDrd7sSw==","","dX+zJ458tDKiugVFVeBzNhNApFHtw42VR0\/lPFKhmiYTCTEHyOZIjDuovvRjZrW6gZiRuj2LsbRWS9nBvW\/ZuQ==","iaEkitfo+RiWiRQ1VJ1bPg==",null,"S1RRDrlG6v7bZDT0Ztugpw==",null,1,"4293"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 16:00:41","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":["7984","1354","1108.0","1108.00","2","2020-05-28 16:00:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 16:00:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-11","2020-06-10","1354"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-28 16:00:41","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":["7984","1353","1108.0","1108.00","2","2020-05-28 16:00:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 16:00:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-11","2020-06-10","1353"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-28 16:00:41","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":["7984",1146,"SETTLED","C15-I208313","2020-05-28 16:00:41","2020-05-11","2","2020-05-28 16:00:41","2","2020-05-28 16:00:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 16:00:41","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":["8313","RENT","\u9810\u7e73\u79df\u91d1",1,1798,"MO","1",1798,"2","2020-05-28 16:00:41","2","2020-05-28 16:00:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 16:00:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1798,0,"8313"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-28 16:00:41","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":[1146,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207957","2020-05-28 16:00:41",1798,"2","2020-05-28 16:00:41","2","2020-05-28 16:00:41","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 16:00:41","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":["7957","DEPOSIT",null,"PAID","2020-05-28 16:00:41",0,"2","2020-05-28 16:00:41","2","2020-05-28 16:00:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 16:00:41","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":["7957","INVOICE","8313","PAID","2020-05-28 16:00:41",1798,"2","2020-05-28 16:00:41","2","2020-05-28 16:00:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 17:35:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-28 18:43:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****