{"created_at":"2020-01-31 09:50:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:02:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:28:06","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:40:54","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1008&filter3=undefined","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","floor_plan_rent_room":[{"room_id":"1182","master_room_id":"111","room_code":"A05-180"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1008,"customer_code":"C181008","identity_type":"PERSONAL","identity_id":"K700926(7)","title":"Ms","lastname":"Cheng","firstname":"King","companyname":"","email":"dumpling_jing@hotmail.com","tel":"90989956","address":"FT F 60\/F Tower 2 , 38 Tai Hong Street, Grand Promenade , Sai Wan Ho, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1115.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-10","renew_room_key":"0005796877","renew_remark":"1 month contract. Change unit from C15-018 to C15-012. Deposit $1796 and remaining rental $500 transferred from agreement C15-CT206842 to this agreement. Remaining balance $1049 paid by PPS on Jan 08,2020.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT206919, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2230.0","renew_master_room_id":"172","order_discount":[],"order_room":[{"room_id":"1408","room_code":"C15-102","retail_price":"1115.0","discounted_price":"1115.00","location_id":"6"}],"roughly_size":"20","total_retail_price":1115,"total_discounted_price":1115,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1115,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-10","rent_from":"2020-02-10","rent_to":"2020-03-09","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on January 25, 2020. Storage deposit $2230 transferred from agreement C15-CT206919 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1115,"final_order_total":1115,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0005796877","order_product":[],"pass":true}},"first_order_id":"3501","selected_room_tr":"\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t

---

\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t

\u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t

\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>
C15-102 <\/td>\r\n\t\t\t\t\t	4X5X6.5 <\/td>\r\n\t\t\t\t\t	$1115.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1115.0","deposit":"0","total_retail_price":"1115.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:40:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1008,"NEW","C15-CT207067",1115,1115,0,0,"1","1",1115,1115,1115,"2020-01-31 11:40:54","0",null,null,null,"2020-02-10","2020-03-09","1 month contract. Storage rental paid by PPS on January 25, 2020. Storage deposit $2230 transferred from agreement C15-CT206919 to this agreement. \r\n","2020-02-10","20",0,null,0,"0","2","2020-01-31 11:40:54","2","2020-01-31 11:40:54","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0005796877","C181008","PERSONAL","Ms","pyScVxHN1bAPGGa\/Bucd1Q==","UCPBCXrBLI9U7KKsPqgmNA==","","LoTfAY\/7hsJ5LMg1lxRl5U61+y\/bHOn3mXXs4ZtLiTsKgr3U0XtRwxPFeprq+NiHAM+QrB+m5+WZ7R14dzMxe+z0ciqodfk7L3bAksKmsSI=","ODUJ\/sh5I9t4EANm7+m4qQ==","IK6uRSfHgYDvM30SfvOBrVdAXD9E++uXhp1WOnqnMIk=","0n\/HYQ\/ulfaXU7JBtiiVDg==",null,1,"3501"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:40:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7067","1408","1115.0","1115.00","2","2020-01-31 11:40:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:40: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-02-10","2020-03-09","1408"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-31 11:40: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":["7067",1008,"SETTLED","C15-I207395","2020-01-31 11:40:54","2020-02-10","2","2020-01-31 11:40:54","2","2020-01-31 11:40:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:40: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":["7395","RENT","\u9810\u7e73\u79df\u91d1",1,1115,"MO","1",1115,"2","2020-01-31 11:40:54","2","2020-01-31 11:40:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:40:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1115,0,"7395"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-31 11:40: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":[1008,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207043","2020-01-31 11:40:54",1115,"2","2020-01-31 11:40:54","2","2020-01-31 11:40:54","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:40: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":["7043","DEPOSIT",null,"PAID","2020-01-31 11:40:54",0,"2","2020-01-31 11:40:54","2","2020-01-31 11:40:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:40: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":["7043","INVOICE","7395","PAID","2020-01-31 11:40:54",1115,"2","2020-01-31 11:40:54","2","2020-01-31 11:40:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:45:14","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1008&filter3=undefined&msg=%E5%8F%96%E6%B6%88","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","floor_plan_rent_room":[{"room_id":"1182","master_room_id":"111","room_code":"A05-180"}],"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-02-01","renew_room_key":"054,41837","renew_remark":"1 month contract. Storage rental paid by PPS on December 23, 2019. Storage deposit transferred from agreement A18-CT196541 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196788, \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-02-01","rent_from":"2020-02-01","rent_to":"2020-02-29","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on January 25, 2020. Storage deposit transferred from agreement A18-CT196788 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-01-31 11:45:14","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-CT207068",1090,1090,0,0,"1","1",1090,1090,1090,"2020-01-31 11:45:14","0",null,null,null,"2020-02-01","2020-02-29","1 month contract. Storage rental paid by PPS on January 25, 2020. Storage deposit transferred from agreement A18-CT196788 to this agreement.\r\n","2020-02-01","12",0,null,0,"0","2","2020-01-31 11:45:14","2","2020-01-31 11:45:14","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-01-31 11:45:14","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":["7068","837","1090.0","1090.00","2","2020-01-31 11:45:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:45:14","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-02-01","2020-02-29","837"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-31 11:45:14","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":["7068",652,"SETTLED","A18-I207396","2020-01-31 11:45:14","2020-02-01","2","2020-01-31 11:45:14","2","2020-01-31 11:45:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:45:14","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":["7396","RENT","\u9810\u7e73\u79df\u91d1",1,1090,"MO","1",1090,"2","2020-01-31 11:45:14","2","2020-01-31 11:45:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:45:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1090,0,"7396"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-31 11:45:14","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","P207044","2020-01-31 11:45:14",1090,"2","2020-01-31 11:45:14","2","2020-01-31 11:45:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:45:14","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":["7044","DEPOSIT",null,"PAID","2020-01-31 11:45:14",0,"2","2020-01-31 11:45:14","2","2020-01-31 11:45:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:45:14","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":["7044","INVOICE","7396","PAID","2020-01-31 11:45:14",1090,"2","2020-01-31 11:45:14","2","2020-01-31 11:45:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:53:34","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1008&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","floor_plan_rent_room":[{"room_id":"1182","master_room_id":"111","room_code":"A05-180"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":637,"customer_code":"C170637","identity_type":"PERSONAL","identity_id":"D706815(9)","title":"Mr","lastname":"Choy","firstname":"Yuk Ling Francis","companyname":"","email":"garyc2hk@yahoo.com.hk","tel":"94332403","address":"6E, 6\/F, Jing Hui Garden, 8 Aberdeen Main Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1228.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-01","renew_room_key":"055,14113","renew_remark":"1 month contract. Storage rental paid by PPS on December 27, 2019. Storage deposit $2456 transferred from agreement A18-CT196544 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT206838, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"981","room_code":"X06","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1228,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-01","rent_from":"2020-02-01","rent_to":"2020-02-29","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on January 30, 2020. Storage deposit $2456 transferred from agreement A18-CT206838 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1228,"final_order_total":1228,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,14113","order_product":[],"pass":true}},"first_order_id":"4858","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> X06 <\/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":"1228.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:53:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",637,"NEW","A18-CT207069",1290,1228,0,0,"1","1",1228,1228,1228,"2020-01-31 11:53:35","0",null,null,null,"2020-02-01","2020-02-29","1 month contract. Storage rental paid by PPS on January 30, 2020. Storage deposit $2456 transferred from agreement A18-CT206838 to this agreement. \r\n","2020-02-01","16",0,null,0,"0","2","2020-01-31 11:53:34","2","2020-01-31 11:53:34","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,14113","C170637","PERSONAL","Mr","J+g+TeRBIdzsY6tyXdUL4DZdTF+kJBMmq07PxUuV2rQ=","UrsMAvfb5x9QBcnJ8435JA==","","IqhgG3xSMZDgzwxkBvRbXd3aZXF9S\/xKJDNT6bRp\/CaVT0KgEUyW3DMnqWGhAmYTEqUAiJDuiC0jx5487vY8cg==","46NXlqFaJugFX+V9A1awbQ==","j6foxYTVlm9b0h+GRpM4lraceSoVkydGqoE3S05vxDI=","zgahvSRYS8hsN+dhdAMC4A==",null,1,"4858"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:53:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7069","981","1290.0","1290.00","2","2020-01-31 11:53:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:53:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2020-02-29","981"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-31 11:53:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7069",637,"SETTLED","A18-I207397","2020-01-31 11:53:34","2020-02-01","2","2020-01-31 11:53:34","2","2020-01-31 11:53:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:53:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7397","RENT","\u9810\u7e73\u79df\u91d1",1,1228,"MO","1",1228,"2","2020-01-31 11:53:34","2","2020-01-31 11:53:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:53:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1228,0,"7397"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-31 11:53:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[637,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207045","2020-01-31 11:53:34",1228,"2","2020-01-31 11:53:34","2","2020-01-31 11:53:34","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:53:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7045","DEPOSIT",null,"PAID","2020-01-31 11:53:34",0,"2","2020-01-31 11:53:34","2","2020-01-31 11:53:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:53:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7045","INVOICE","7397","PAID","2020-01-31 11:53:34",1228,"2","2020-01-31 11:53:34","2","2020-01-31 11:53:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:55:19","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1008&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","floor_plan_rent_room":[{"room_id":"1182","master_room_id":"111","room_code":"A05-180"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":311,"customer_code":"C170311","identity_type":"PERSONAL","identity_id":"K465007(7)","title":"Mr","lastname":"Lo","firstname":"Ho Yin Owen","companyname":"","email":"aumanoh@gmail.com","tel":"94816466","address":"Rm 1, 15\/F, Kong Tai Court, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-18","renew_room_key":"054,46524","renew_remark":"1 month contract. Storage rental paid by PPS on December 31, 2019. Storage deposit $1396 transferred from agreement A14-CT196565 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT206846, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"731","room_code":"O07","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":998,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-18","rent_from":"2020-01-18","rent_to":"2020-02-17","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on January 30, 2020. Storage deposit $1396 transferred from agreement A14-CT206846 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":998,"final_order_total":998,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,46524","order_product":[],"pass":true}},"first_order_id":"4521","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> O07 <\/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":"998.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:55:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",311,"NEW","A14-CT207070",998,998,0,0,"1","1",998,998,998,"2020-01-31 11:55:20","0",null,null,null,"2020-01-18","2020-02-17","1 month contract. Storage rental paid by PPS on January 30, 2020. Storage deposit $1396 transferred from agreement A14-CT206846 to this agreement.","2020-01-18","12",0,null,0,"0","2","2020-01-31 11:55:19","2","2020-01-31 11:55:19","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,46524","C170311","PERSONAL","Mr","rCN1lNVsvQUEIb4CpJx1nQ==","4w4biS+jM\/Q3DAzxHdf3pA==","","UucV8Ifr0A3QD8t\/j4UcOkwkrTPm33ceBZgTGHCMj6A\/O47vut2lT34hVu5UQZtV","jhz+YIyFB3NZsNn7IDpl4g==","BsQLPUdVMtvEb+TZbZnmUf9xqaiffRvcCnuR9msGho8=","1b5I8lCuen+0vvfOkqGOwA==",null,1,"4521"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:55:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7070","731","998.0","998.00","2","2020-01-31 11:55:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:55:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-18","2020-02-17","731"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-31 11:55:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7070",311,"SETTLED","A14-I207398","2020-01-31 11:55:19","2020-01-18","2","2020-01-31 11:55:19","2","2020-01-31 11:55:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:55:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7398","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-01-31 11:55:19","2","2020-01-31 11:55:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:55:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"7398"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-31 11:55:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[311,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207046","2020-01-31 11:55:19",998,"2","2020-01-31 11:55:19","2","2020-01-31 11:55:19","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:55:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7046","DEPOSIT",null,"PAID","2020-01-31 11:55:19",0,"2","2020-01-31 11:55:19","2","2020-01-31 11:55:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 11:55:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7046","INVOICE","7398","PAID","2020-01-31 11:55:19",998,"2","2020-01-31 11:55:19","2","2020-01-31 11:55:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:01:53","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=984&filter3=undefined","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","floor_plan_rent_room":[{"room_id":"1182","master_room_id":"111","room_code":"A05-180"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":984,"customer_code":"C180984","identity_type":"PERSONAL","identity_id":"D444981(A)","title":"Mr","lastname":"Hon","firstname":"King Tak","companyname":"","email":"roberthin@ymail.com","tel":"90454998","address":"Flat H, 11\/F, Block 30, South Horizons, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"781.0","renew_rent_month":"12","renew_warehousing_date":"2020-05-01","renew_room_key":"189,29082","renew_remark":"12 months contract. Storage rental paid by cheque on March 16, 2019. Storage deposit $1650 transferred from agreement A18-CT183224 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT194594, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"100","order_discount":[],"order_room":[{"room_id":"933","room_code":"V07(\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":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":9372,"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":"2021-04-30","delivery_service":"0","remark":"12 months contract. Storage rental paid by PPS on January 30, 2020. Storage deposit $1650 transferred from agreement A18-CT194594 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":9372,"final_order_total":9372,"location_id":"3","branch_id":"1","company_id":"1","room_key":"189,29082","order_product":[],"pass":true}},"first_order_id":4594,"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> V07(\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.0","deposit":"0","total_retail_price":"867.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:01:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",984,"NEW","A18-CT207071",867,781,0,0,"12","12",9372,9372,9372,"2020-01-31 12:01:54","0",null,null,null,"2020-05-01","2021-04-30","12 months contract. Storage rental paid by PPS on January 30, 2020. Storage deposit $1650 transferred from agreement A18-CT194594 to this agreement.","2020-05-01","7.2",0,null,0,"0","2","2020-01-31 12:01:53","2","2020-01-31 12:01:53","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"189,29082","C180984","PERSONAL","Mr","K1n4PQJHwbXmvIIiK7rB7Q==","EoaUEoejMbsPJ+HqYaK40Q==","","e9RKgXD4Qs2Y3ZZ1MU\/yBHOgudiA74hGvSjRisnSLzeDlSqw1WFNwgvLAYjMupIWV7Vj4vTJanDYX8pNr9SrxQ==","HBlHNfj0PuGMnoYxgn67uA==","pF3b813nnUmoJSSdyHV42CneokMbr8xkP296itfdjI8=","w++rdV5nlzQanbkUzKL9oA==",null,1,4594]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:01:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7071","933","867.0","867.00","2","2020-01-31 12:01:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:01:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-01","2021-04-30","933"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-31 12:01:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7071",984,"SETTLED","A18-I207399","2020-01-31 12:01:53","2020-05-01","2","2020-01-31 12:01:53","2","2020-01-31 12:01:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:01:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7399","RENT","\u9810\u7e73\u79df\u91d1",1,781,"MO","1",781,"2","2020-01-31 12:01:53","2","2020-01-31 12:01:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:01:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7399","RENT","\u9810\u7e73\u79df\u91d1",2,781,"MO","1",781,"2","2020-01-31 12:01:53","2","2020-01-31 12:01:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:01:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7399","RENT","\u9810\u7e73\u79df\u91d1",3,781,"MO","1",781,"2","2020-01-31 12:01:53","2","2020-01-31 12:01:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:01:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7399","RENT","\u9810\u7e73\u79df\u91d1",4,781,"MO","1",781,"2","2020-01-31 12:01:53","2","2020-01-31 12:01:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:01:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7399","RENT","\u9810\u7e73\u79df\u91d1",5,781,"MO","1",781,"2","2020-01-31 12:01:53","2","2020-01-31 12:01:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:01:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7399","RENT","\u9810\u7e73\u79df\u91d1",6,781,"MO","1",781,"2","2020-01-31 12:01:53","2","2020-01-31 12:01:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:01:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7399","RENT","\u9810\u7e73\u79df\u91d1",7,781,"MO","1",781,"2","2020-01-31 12:01:53","2","2020-01-31 12:01:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:01:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7399","RENT","\u9810\u7e73\u79df\u91d1",8,781,"MO","1",781,"2","2020-01-31 12:01:53","2","2020-01-31 12:01:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:01:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7399","RENT","\u9810\u7e73\u79df\u91d1",9,781,"MO","1",781,"2","2020-01-31 12:01:53","2","2020-01-31 12:01:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:01:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7399","RENT","\u9810\u7e73\u79df\u91d1",10,781,"MO","1",781,"2","2020-01-31 12:01:53","2","2020-01-31 12:01:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:01:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7399","RENT","\u9810\u7e73\u79df\u91d1",11,781,"MO","1",781,"2","2020-01-31 12:01:53","2","2020-01-31 12:01:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:01:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7399","RENT","\u9810\u7e73\u79df\u91d1",12,781,"MO","1",781,"2","2020-01-31 12:01:53","2","2020-01-31 12:01:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:01:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[9372,0,"7399"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-31 12:01:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[984,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207047","2020-01-31 12:01:53",9372,"2","2020-01-31 12:01:53","2","2020-01-31 12:01:53","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:01:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7047","DEPOSIT",null,"PAID","2020-01-31 12:01:53",0,"2","2020-01-31 12:01:53","2","2020-01-31 12:01:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:01:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7047","INVOICE","7399","PAID","2020-01-31 12:01:53",9372,"2","2020-01-31 12:01:53","2","2020-01-31 12:01:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:02:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:13:31","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=984&filter3=undefined&msg=%E5%8F%96%E6%B6%88","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","floor_plan_rent_room":[{"room_id":"1182","master_room_id":"111","room_code":"A05-180"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":764,"customer_code":"C180764","identity_type":"PERSONAL","identity_id":"D851757(5)","title":"Ms","lastname":"Fung","firstname":"Yee Han Esther","companyname":"","email":"estherf.travel@gmail.com","tel":"97273927","address":"Room 1504, Block I, Kong Wing 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":"934.0","renew_rent_month":"6","renew_warehousing_date":"2020-02-11","renew_room_key":"055,51230","renew_remark":"6 months contract. Storage rental paid by cheque deposit on August 22, 2019. Storage deposit transferred from agreement A12-CT194312 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195776, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"318","room_code":"F03","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":934,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":11208,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"934.00","warehousing_date":"2020-02-11","rent_from":"2020-02-11","rent_to":"2021-03-10","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by bank transfer on January 31, 2020. Storage deposit transferred from agreement A12-CT195776 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":934,"order_total":12142,"final_order_total":11208,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,51230","order_product":[],"pass":true}},"first_order_id":"4312","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> F03 <\/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":"934.00","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:13:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",764,"NEW","A12-CT207072",998,934,0,0,"13","13",11208,12142,11208,"2020-01-31 12:13:32","0",null,null,null,"2020-02-11","2021-03-10","13 months contract. Special offer the 13th month free. Storage rental paid by bank transfer on January 31, 2020. Storage deposit transferred from agreement A12-CT195776 to this agreement.","2020-02-11","12",0,null,934,"934.00","2","2020-01-31 12:13:31","2","2020-01-31 12:13:31","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,51230","C180764","PERSONAL","Ms","6BMc8ZOOwoFs8YdZInHbzA==","fw9NU0t2sgJqYX3ZpxPMlA==","","qgMEcWnfDXUsm3kMoUi30omAz3ZiBtIbxbrgs4kUBJ2lN+Wr1xemXQcC0pNU0DafXDoGKPf7krtYn4daIRjS5v7u6suSO\/2C5FrWzu25fv8=","h0slt3levyhWSQxnXTjRIQ==","\/QAr59h7oR4dSkPWcn1fcwoxDDQCjA0XVBH1iGxbOeQ=","\/A4dFMBDtBIOxFzwmji2aw==",null,1,"4312"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:13:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7072","318","998.0","998.00","2","2020-01-31 12:13:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:13:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-11","2021-03-10","318"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-31 12:13:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7072",764,"SETTLED","A12-I207400","2020-01-31 12:13:31","2020-02-11","2","2020-01-31 12:13:31","2","2020-01-31 12:13:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:13:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7400","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,934,"MO","1",934,"2","2020-01-31 12:13:31","2","2020-01-31 12:13:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:13:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7400","RENT","\u9810\u7e73\u79df\u91d1",3,934,"MO","1",934,"2","2020-01-31 12:13:31","2","2020-01-31 12:13:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:13:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7400","RENT","\u9810\u7e73\u79df\u91d1",4,934,"MO","1",934,"2","2020-01-31 12:13:31","2","2020-01-31 12:13:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:13:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7400","RENT","\u9810\u7e73\u79df\u91d1",5,934,"MO","1",934,"2","2020-01-31 12:13:31","2","2020-01-31 12:13:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:13:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7400","RENT","\u9810\u7e73\u79df\u91d1",6,934,"MO","1",934,"2","2020-01-31 12:13:31","2","2020-01-31 12:13:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:13:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7400","RENT","\u9810\u7e73\u79df\u91d1",7,934,"MO","1",934,"2","2020-01-31 12:13:31","2","2020-01-31 12:13:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:13:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7400","RENT","\u9810\u7e73\u79df\u91d1",8,934,"MO","1",934,"2","2020-01-31 12:13:31","2","2020-01-31 12:13:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:13:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7400","RENT","\u9810\u7e73\u79df\u91d1",9,934,"MO","1",934,"2","2020-01-31 12:13:31","2","2020-01-31 12:13:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:13:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7400","RENT","\u9810\u7e73\u79df\u91d1",10,934,"MO","1",934,"2","2020-01-31 12:13:31","2","2020-01-31 12:13:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:13:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7400","RENT","\u9810\u7e73\u79df\u91d1",11,934,"MO","1",934,"2","2020-01-31 12:13:31","2","2020-01-31 12:13:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:13:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7400","RENT","\u9810\u7e73\u79df\u91d1",12,934,"MO","1",934,"2","2020-01-31 12:13:31","2","2020-01-31 12:13:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:13:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7400","RENT","\u9810\u7e73\u79df\u91d1",13,934,"MO","1",934,"2","2020-01-31 12:13:31","2","2020-01-31 12:13:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:13:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11208,0,"7400"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-31 12:13:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[764,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207048","2020-01-31 12:13:31",11208,"2","2020-01-31 12:13:31","2","2020-01-31 12:13:31","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:13:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7048","DEPOSIT",null,"PAID","2020-01-31 12:13:31",0,"2","2020-01-31 12:13:31","2","2020-01-31 12:13:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:13:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7048","INVOICE","7400","PAID","2020-01-31 12:13:31",11208,"2","2020-01-31 12:13:31","2","2020-01-31 12:13:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:21:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:35:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:42:06","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 12:48:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 13:01:30","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1125&filter3=undefined&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"730","master_room_id":"34","room_code":"O06"}],"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> O06 <\/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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"V007365(2)","title":"Ms","lastname":"WU","firstname":"Hiu Tung","companyname":"","email":"cholewu@netvigator.com","tel":"98689797","address":"Flat B, 27\/F, Blk 12, South Horizons, Ap Lei Chau, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"730","room_code":"O06","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":1996,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2494,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"500.00","warehousing_date":"2020-02-03","rent_from":"2020-02-03","rent_to":"2020-03-02","delivery_service":"0","remark":"1 months contract. Special promotion $500 coupon. Storage rental and deposit paid by EPS on Jan 31,2020. Smartcard provided on Jan 31,2020.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":500,"order_total":2994,"final_order_total":2494,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190,26392","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"998.00","deposit":"1996.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 13:01:32","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":["C201500","PERSONAL","Ms","QoxtZbvpB3h4jnM47BGoLQ==","RgTQL6em\/We21zilKNSwtg==","","28KM6keYo21+UrqtICcroQ==","gEvUCNziKgP\/TCw2naIi3P83I9N0Hy\/tmv4MZ3e1XM4=","wSAAs815SSTsLlXnxGu1os7BzTbR8JUF3k1iys9PHoSaMSxD1mpoR2D3CfwkeEM2WYoQ\/T7ofHQxXl7iPOkXYQ==","B7Wj0rrUibMuApoQPF8hTw==",null,"gEvUCNziKgP\/TCw2naIi3P83I9N0Hy\/tmv4MZ3e1XM4=","ul3Cax7tSTWyEmMwLLFtOQ==","2","2020-01-31 13:01:30","2","2020-01-31 13:01:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 13:01:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2",1500,"NEW","A14-CT207073",998,998,1996,0,"1","1",2494,2994,2494,"2020-01-31 13:01:32","0",null,null,null,"2020-02-03","2020-03-02","1 months contract. Special promotion $500 coupon. Storage rental and deposit paid by EPS on Jan 31,2020. Smartcard provided on Jan 31,2020.","2020-02-03","12",0,null,500,"500.00","2","2020-01-31 13:01:30","2","2020-01-31 13:01:30","EPS","","","","EPS","","","",null,0,"190,26392","C201500","PERSONAL","Ms","QoxtZbvpB3h4jnM47BGoLQ==","RgTQL6em\/We21zilKNSwtg==","","wSAAs815SSTsLlXnxGu1os7BzTbR8JUF3k1iys9PHoSaMSxD1mpoR2D3CfwkeEM2WYoQ\/T7ofHQxXl7iPOkXYQ==","28KM6keYo21+UrqtICcroQ==","gEvUCNziKgP\/TCw2naIi3P83I9N0Hy\/tmv4MZ3e1XM4=","B7Wj0rrUibMuApoQPF8hTw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 13:01:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7073","730","998.0","998.00","2","2020-01-31 13:01:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 13:01:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-03","2020-03-02","730"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-31 13:01:32","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":["7073","A14-D205274","PAID",1996,0,"2020-03-02","2020-01-31 13:01:30","2020-01-31 13:01:30","2","2020-01-31 13:01:30","2","2020-01-31 13:01:30",1500]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 13:01:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7073",1500,"SETTLED","A14-I207401","2020-01-31 13:01:30","2020-02-03","2","2020-01-31 13:01:30","2","2020-01-31 13:01:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 13:01:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7401","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,498,"MO","1",498,"2","2020-01-31 13:01:30","2","2020-01-31 13:01:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 13:01:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[498,0,"7401"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-31 13:01:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1500,"EPS","","","","EPS","","","","PAID","P207049","2020-01-31 13:01:30",2494,"2","2020-01-31 13:01:30","2","2020-01-31 13:01:30","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 13:01:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7049","DEPOSIT","5274","PAID","2020-01-31 13:01:30",1996,"2","2020-01-31 13:01:30","2","2020-01-31 13:01:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 13:01:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7049","INVOICE","7401","PAID","2020-01-31 13:01:30",498,"2","2020-01-31 13:01:30","2","2020-01-31 13:01:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 13:04:54","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=984&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","floor_plan_rent_room":[{"room_id":"1182","master_room_id":"111","room_code":"A05-180"}],"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-02-01","renew_room_key":"054,19016","renew_remark":"3 months contract. Storage rental paid by bank transfer on October 31, 2019. Storage deposit transferred from agreement A12-CT195777 to this agreement. \u820a\u5408\u7d04\u7de8\u865f: A12-CT195777, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196268, \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-02-01","rent_from":"2020-02-01","rent_to":"2020-04-30","delivery_service":"0","remark":"3 months contract. Storage rental paid by Cash on January 31, 2020. Storage deposit transferred from agreement A12-CT196268 to this agreement.","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-01-31 13:04: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","1",325,"NEW","A12-CT207074",598,568,0,0,"3","3",1704,1704,1704,"2020-01-31 13:04:55","0",null,null,null,"2020-02-01","2020-04-30","3 months contract. Storage rental paid by Cash on January 31, 2020. Storage deposit transferred from agreement A12-CT196268 to this agreement.","2020-02-01","12",0,null,0,"0","2","2020-01-31 13:04:54","2","2020-01-31 13:04:54","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-01-31 13:04: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":["7074","201","598.0","598.00","2","2020-01-31 13:04:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 13:04: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-02-01","2020-04-30","201"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-31 13:04: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":["7074",325,"SETTLED","A12-I207402","2020-01-31 13:04:54","2020-02-01","2","2020-01-31 13:04:54","2","2020-01-31 13:04:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 13:04: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":["7402","RENT","\u9810\u7e73\u79df\u91d1",1,568,"MO","1",568,"2","2020-01-31 13:04:54","2","2020-01-31 13:04:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 13:04: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":["7402","RENT","\u9810\u7e73\u79df\u91d1",2,568,"MO","1",568,"2","2020-01-31 13:04:54","2","2020-01-31 13:04:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 13:04: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":["7402","RENT","\u9810\u7e73\u79df\u91d1",3,568,"MO","1",568,"2","2020-01-31 13:04:54","2","2020-01-31 13:04:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 13:04:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1704,0,"7402"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-31 13:04: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":[325,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207050","2020-01-31 13:04:54",1704,"2","2020-01-31 13:04:54","2","2020-01-31 13:04:54","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 13:04: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":["7050","DEPOSIT",null,"PAID","2020-01-31 13:04:54",0,"2","2020-01-31 13:04:54","2","2020-01-31 13:04:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 13:04: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":["7050","INVOICE","7402","PAID","2020-01-31 13:04:54",1704,"2","2020-01-31 13:04:54","2","2020-01-31 13:04:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 14:02:37","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=984&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","floor_plan_rent_room":[{"room_id":"1182","master_room_id":"111","room_code":"A05-180"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":282,"customer_code":"C170282","identity_type":"PERSONAL","identity_id":"G068266(6)","title":"Mr","lastname":"Ng","firstname":"Tak Wah","companyname":"","email":"twahng@gmail.com","tel":"92422690","address":"Flat G, 38\/F, Tower 8, Yee King Court(South Horizons), 8 South Horizon Drive","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1139.0","renew_rent_month":"6","renew_warehousing_date":"2020-02-04","renew_room_key":"055,16762","renew_remark":"6 months contract. Storage rental paid by bank transfer on July 24, 2019. Storage deposit transferred from agreement A12-CT194260 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195540, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[{"master_room_discount_id":"76","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1376.00","discount":"9.95","monthly_deduct":152.036,"room_id":"72","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"72","room_code":"B20","retail_price":"1528.0","discounted_price":1376,"location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1139,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6834,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-04","rent_from":"2020-02-04","rent_to":"2020-08-03","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on January 31, 2020. Storage deposit transferred from agreement A12-CT195540 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6834,"final_order_total":6834,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,16762","order_product":[],"pass":true}},"first_order_id":"4260","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> B20 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1139.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 14:02:37","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",282,"NEW","A12-CT207075",1528,1139,0,0,"6","6",6834,6834,6834,"2020-01-31 14:02:37","0",null,null,null,"2020-02-04","2020-08-03","6 months contract. Storage rental paid by bank transfer on January 31, 2020. Storage deposit transferred from agreement A12-CT195540 to this agreement.","2020-02-04","20",0,null,0,"0","2","2020-01-31 14:02:37","2","2020-01-31 14:02:37","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,16762","C170282","PERSONAL","Mr","1oSMVf9+g3+SXdtq\/wgYKQ==","cxr02xsD1tXvJ4ihJHZKWw==","","dfVtG\/X1v207Y3TuRXqMMCIw7na4MqUY+nr+A3eIY2rw4Jq3pYOTpCq0A+9BQfnueGX\/Eo0+Ro0OGm38769e47os42Hui4yHN1cGtexqlEA=","7izEgGHU2g1NCb3EB0KTRQ==","TjCWufExzYiTKNe\/bL+4HbcRAk1gcEOjHvwMJVjddwE=","KZd08t5UjHZTlaP3My2mrA==",null,1,"4260"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 14:02:37","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":["7075","76","10","72","%","9.95",152.036,"2","2020-01-31 14:02:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 14:02:37","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":["7075","72","1528.0",1376,"2","2020-01-31 14:02:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 14:02:37","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-02-04","2020-08-03","72"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-31 14:02:37","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":["7075",282,"SETTLED","A12-I207403","2020-01-31 14:02:37","2020-02-04","2","2020-01-31 14:02:37","2","2020-01-31 14:02:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 14:02:37","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":["7403","RENT","\u9810\u7e73\u79df\u91d1",1,1139,"MO","1",1139,"2","2020-01-31 14:02:37","2","2020-01-31 14:02:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 14:02:37","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":["7403","RENT","\u9810\u7e73\u79df\u91d1",2,1139,"MO","1",1139,"2","2020-01-31 14:02:37","2","2020-01-31 14:02:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 14:02:37","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":["7403","RENT","\u9810\u7e73\u79df\u91d1",3,1139,"MO","1",1139,"2","2020-01-31 14:02:37","2","2020-01-31 14:02:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 14:02:37","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":["7403","RENT","\u9810\u7e73\u79df\u91d1",4,1139,"MO","1",1139,"2","2020-01-31 14:02:37","2","2020-01-31 14:02:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 14:02:37","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":["7403","RENT","\u9810\u7e73\u79df\u91d1",5,1139,"MO","1",1139,"2","2020-01-31 14:02:37","2","2020-01-31 14:02:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 14:02:37","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":["7403","RENT","\u9810\u7e73\u79df\u91d1",6,1139,"MO","1",1139,"2","2020-01-31 14:02:37","2","2020-01-31 14:02:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 14:02:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6834,0,"7403"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-31 14:02:37","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":[282,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207051","2020-01-31 14:02:37",6834,"2","2020-01-31 14:02:37","2","2020-01-31 14:02:37","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 14:02:37","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":["7051","DEPOSIT",null,"PAID","2020-01-31 14:02:37",0,"2","2020-01-31 14:02:37","2","2020-01-31 14:02:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 14:02:37","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":["7051","INVOICE","7403","PAID","2020-01-31 14:02:37",6834,"2","2020-01-31 14:02:37","2","2020-01-31 14:02:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:18:24","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","floor_plan_rent_room":[{"room_id":"1182","master_room_id":"111","room_code":"A05-180"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":185,"customer_code":"C160185","identity_type":"BUSINESS","identity_id":"D222377(6)","title":"Mr","lastname":"Ho","firstname":"Siu Nang","companyname":"\u9280\u6cb3\u6e05\u6f54\u670d\u52d9\u516c\u53f8","email":"paulhogalaxy@gmail.com","tel":"65056392","address":"\u83ef\u5bcc\u6751\u83ef\u8208\u6a131523\u5ba4","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2058.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-01","renew_room_key":"137,04114","renew_remark":"1 month contract. Storage rental paid by cheque on Jan 01, 2020. Storage deposit $4116 transferred from agreement A12-CT195365 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT206824, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"352","room_code":"F37","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"},{"room_id":"341","room_code":"F26","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"28","total_retail_price":2096,"total_discounted_price":2058,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2058,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-01","rent_from":"2020-02-01","rent_to":"2020-02-29","delivery_service":"0","remark":"1 month contract. Storage rental paid by cheque on January 31, 2020. Storage deposit $4116 transferred from agreement A12-CT206824 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":2058,"final_order_total":2058,"location_id":"1","branch_id":"1","company_id":"1","room_key":"137,04114","order_product":[],"pass":true}},"first_order_id":"4022","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> F37 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> F26 <\/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":"28","total_discounted_price":"2058.0","deposit":"0","total_retail_price":"2096.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:18: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",185,"NEW","A12-CT207076",2096,2058,0,0,"1","1",2058,2058,2058,"2020-01-31 15:18:25","0",null,null,null,"2020-02-01","2020-02-29","1 month contract. Storage rental paid by cheque on January 31, 2020. Storage deposit $4116 transferred from agreement A12-CT206824 to this agreement.","2020-02-01","28",0,null,0,"0","2","2020-01-31 15:18:24","2","2020-01-31 15:18:24","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"137,04114","C160185","BUSINESS","Mr","8VAqcL3IspaH8hPnjc\/j9A==","D\/skxQ5s\/L5yyRWaDK\/iSg==","\u9280\u6cb3\u6e05\u6f54\u670d\u52d9\u516c\u53f8","SBeCrqSWBJHo5WFUZ0wFgWaHbBHLeyJ\/CgjYHNn7Je8=","0fbfPnHuJdatugGcNk6K4A==","7VZ2UwSPOXgEZkVAE40qKlC4LQp+t2ycCXdAGmycB94=",null,"iG6Lypr2+yMga87E7kAeDA==",1,"4022"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:18: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":["7076","352","1098.0","1098.00","2","2020-01-31 15:18:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:18: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-02-01","2020-02-29","352"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-31 15:18: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":["7076","341","998.0","998.00","2","2020-01-31 15:18:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:18: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-02-01","2020-02-29","341"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-31 15:18: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":["7076",185,"SETTLED","A12-I207404","2020-01-31 15:18:24","2020-02-01","2","2020-01-31 15:18:24","2","2020-01-31 15:18:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:18: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":["7404","RENT","\u9810\u7e73\u79df\u91d1",1,2058,"MO","1",2058,"2","2020-01-31 15:18:24","2","2020-01-31 15:18:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:18:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2058,0,"7404"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-31 15:18: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":[185,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207052","2020-01-31 15:18:24",2058,"2","2020-01-31 15:18:24","2","2020-01-31 15:18:24","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:18: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":["7052","DEPOSIT",null,"PAID","2020-01-31 15:18:24",0,"2","2020-01-31 15:18:24","2","2020-01-31 15:18:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:18: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":["7052","INVOICE","7404","PAID","2020-01-31 15:18:24",2058,"2","2020-01-31 15:18:24","2","2020-01-31 15:18:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:21:43","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ?, `customer_companyname` = ? where id = ?","parameters":["VOID","20","13 months contract. Storage rental and storage deposit paid by EPS on January 30, 2020. Smartcard provided on January 30, 2020. ","2020-01-31 15:21:43","2","J7AHnwLqFVSF7LcuxIPXIg==","ZGBHXOclIM+UlBOBu7+VHw==","WZYWUzzptL48Wb1xUe1CA8S7v\/YytLwKMKRM+bSYjDQ=","sKBSHRtWCOMXc4pt3XKKxg==","Y6Y64684LEAASRCic9igdNR4yxR3hXmGHq6J96GBEKprn0KLnzLI7m6m984WCFvcrderYHqQo1+X52PIW+nuSw==","Shanghai Legend Limited",7062]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:21:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:23:48","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","floor_plan_rent_room":[{"room_id":"1755","master_room_id":"232","room_code":"WC-14"}],"_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-14 <\/td>\r\n\t\t\t\t\t 2.5X2.5X4 <\/td>\r\n\t\t\t\t\t $798.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":"0","identity_type":"BUSINESS","identity_id":"P655683(7)","title":"Mr","lastname":"Hong","firstname":"Phu","companyname":"Shanghai Legend Limited","email":"dphu@hotmail.com","tel":"67627538","address":"12\/F, Block 44, Baguio Villa, 550 Victoria Road, Hong Kong","pass":true,"customer_id":"1499","customer_code":"C201499","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1755","room_code":"WC-14","retail_price":"798.0","discounted_price":"798.00","location_id":"8"}],"roughly_size":"6.25","total_retail_price":798,"total_discounted_price":798,"deposit":1596,"rent_month":"14","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"14","prepaid_amount":11172,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1596.00","warehousing_date":"2020-02-06","rent_from":"2020-02-06","rent_to":"2021-04-05","delivery_service":"0","remark":"13 months contract. Storage rental and storage deposit paid by EPS on January 30, 2020. Smartcard provided on January 30, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":1596,"order_total":12768,"final_order_total":11172,"location_id":"8","branch_id":"1","company_id":"1","room_key":"20","order_product":[],"pass":true}},"roughly_size":"6.25","total_discounted_price":"798.00","deposit":"1596.00","total_retail_price":"798.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:23:48","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","1499","NEW","WC-CT207077",798,798,1596,0,"14","14",11172,12768,11172,"2020-01-31 15:23:48","0",null,null,null,"2020-02-06","2021-04-05","13 months contract. Storage rental and storage deposit paid by EPS on January 30, 2020. Smartcard provided on January 30, 2020. ","2020-02-06","6.25",0,null,1596,"1596.00","2","2020-01-31 15:23:47","2","2020-01-31 15:23:47","EPS","","","","EPS","","","",null,0,"20","C201499","BUSINESS","Mr","ZGBHXOclIM+UlBOBu7+VHw==","J7AHnwLqFVSF7LcuxIPXIg==","Shanghai Legend Limited","Y6Y64684LEAASRCic9igdNR4yxR3hXmGHq6J96GBEKprn0KLnzLI7m6m984WCFvcrderYHqQo1+X52PIW+nuSw==","sKBSHRtWCOMXc4pt3XKKxg==","WZYWUzzptL48Wb1xUe1CA8S7v\/YytLwKMKRM+bSYjDQ=",null,"0Bbp6r4fIjN1S+fUK3wJCw=="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:23:48","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":["7077","1755","798.0","798.00","2","2020-01-31 15:23:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:23:48","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-02-06","2021-04-05","1755"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-31 15:23:48","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":["7077","WC-D205275","PAID",1596,0,"2021-04-05","2020-01-31 15:23:47","2020-01-31 15:23:47","2","2020-01-31 15:23:47","2","2020-01-31 15:23:47","1499"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:23:48","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":["7077","1499","SETTLED","WC-I207405","2020-01-31 15:23:47","2020-02-06","2","2020-01-31 15:23:47","2","2020-01-31 15:23:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:23:48","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":["7405","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-01-31 15:23:47","2","2020-01-31 15:23:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:23:48","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":["7405","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,798,"MO","1",798,"2","2020-01-31 15:23:47","2","2020-01-31 15:23:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:23:48","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":["7405","RENT","\u9810\u7e73\u79df\u91d1",4,798,"MO","1",798,"2","2020-01-31 15:23:47","2","2020-01-31 15:23:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:23:48","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":["7405","RENT","\u9810\u7e73\u79df\u91d1",5,798,"MO","1",798,"2","2020-01-31 15:23:47","2","2020-01-31 15:23:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:23:48","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":["7405","RENT","\u9810\u7e73\u79df\u91d1",6,798,"MO","1",798,"2","2020-01-31 15:23:47","2","2020-01-31 15:23:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:23:48","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":["7405","RENT","\u9810\u7e73\u79df\u91d1",7,798,"MO","1",798,"2","2020-01-31 15:23:47","2","2020-01-31 15:23:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:23:48","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":["7405","RENT","\u9810\u7e73\u79df\u91d1",8,798,"MO","1",798,"2","2020-01-31 15:23:47","2","2020-01-31 15:23:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:23:48","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":["7405","RENT","\u9810\u7e73\u79df\u91d1",9,798,"MO","1",798,"2","2020-01-31 15:23:47","2","2020-01-31 15:23:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:23:48","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":["7405","RENT","\u9810\u7e73\u79df\u91d1",10,798,"MO","1",798,"2","2020-01-31 15:23:47","2","2020-01-31 15:23:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:23:48","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":["7405","RENT","\u9810\u7e73\u79df\u91d1",11,798,"MO","1",798,"2","2020-01-31 15:23:47","2","2020-01-31 15:23:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:23:48","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":["7405","RENT","\u9810\u7e73\u79df\u91d1",12,798,"MO","1",798,"2","2020-01-31 15:23:47","2","2020-01-31 15:23:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:23:48","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":["7405","RENT","\u9810\u7e73\u79df\u91d1",13,798,"MO","1",798,"2","2020-01-31 15:23:47","2","2020-01-31 15:23:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:23:48","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":["7405","RENT","\u9810\u7e73\u79df\u91d1",14,798,"MO","1",798,"2","2020-01-31 15:23:47","2","2020-01-31 15:23:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:23:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[9576,0,"7405"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-31 15:23:48","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":["1499","EPS","","","","EPS","","","","PAID","P207053","2020-01-31 15:23:47",11172,"2","2020-01-31 15:23:47","2","2020-01-31 15:23:47","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:23:48","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":["7053","DEPOSIT","5275","PAID","2020-01-31 15:23:47",1596,"2","2020-01-31 15:23:47","2","2020-01-31 15:23:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:23:48","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":["7053","INVOICE","7405","PAID","2020-01-31 15:23:47",9576,"2","2020-01-31 15:23:47","2","2020-01-31 15:23:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 15:23:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 16:14:44","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","floor_plan_rent_room":[{"room_id":"1755","master_room_id":"232","room_code":"WC-14"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":755,"customer_code":"C180755","identity_type":"PERSONAL","identity_id":"D674816(4)","title":"Ms","lastname":"Lee","firstname":"Kam Mui","companyname":"","email":null,"tel":"54998807","address":"Flat F, 25\/F, Kam Fat Building, 145 Lee Chi Road, Apleichau, 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-02-06","renew_room_key":"136,32469","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 4, 2020. Storage deposit transferred from agreement A14-CT196604 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT206876, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"628","room_code":"M39","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"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-02-06","rent_from":"2020-02-06","rent_to":"2020-03-05","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 31, 2020. Storage deposit transferred from agreement A14-CT206876 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"136,32469","order_product":[],"pass":true}},"first_order_id":"4693","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> M39 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 16:14:44","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",755,"NEW","A14-CT207078",598,598,0,0,"1","1",598,598,598,"2020-01-31 16:14:44","0",null,null,null,"2020-02-06","2020-03-05","1 month contract. Storage rental paid by bank transfer on January 31, 2020. Storage deposit transferred from agreement A14-CT206876 to this agreement.\r\n","2020-02-06","12",0,null,0,"0","2","2020-01-31 16:14:44","2","2020-01-31 16:14:44","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,32469","C180755","PERSONAL","Ms","Bz\/rX4ASIpNafqhGM12E+g==","kiriEIqhcx866RNZiMXdKQ==","","J+qxNwNZZDybuSy0bJS1H3QTc7\/evdtOLUtQc4ivvsWPxn+cqVkhkN\/TohPrTXWpxmb7Nhoov\/XjNXxhd0djX6hEDvZ74IuDZYu9myZVwCs=","uTqJ0Kzbi8lcDPgXUMT73Q==",null,"fFKAofifZnWz0Rnx1R5aUA==",null,1,"4693"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 16:14:44","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":["7078","628","598.0","598.00","2","2020-01-31 16:14:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 16:14:44","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-02-06","2020-03-05","628"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-31 16:14:44","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":["7078",755,"SETTLED","A14-I207406","2020-01-31 16:14:44","2020-02-06","2","2020-01-31 16:14:44","2","2020-01-31 16:14:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 16:14:44","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":["7406","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-01-31 16:14:44","2","2020-01-31 16:14:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 16:14:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7406"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-31 16:14:44","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":[755,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207054","2020-01-31 16:14:44",598,"2","2020-01-31 16:14:44","2","2020-01-31 16:14:44","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 16:14:44","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":["7054","DEPOSIT",null,"PAID","2020-01-31 16:14:44",0,"2","2020-01-31 16:14:44","2","2020-01-31 16:14:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 16:14:44","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":["7054","INVOICE","7406","PAID","2020-01-31 16:14:44",598,"2","2020-01-31 16:14:44","2","2020-01-31 16:14:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 17:03:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 17:35:38","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&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","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","floor_plan_rent_room":[{"room_id":"1755","master_room_id":"232","room_code":"WC-14"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":663,"customer_code":"C170663","identity_type":"PERSONAL","identity_id":"D302826(8)","title":"Ms","lastname":"Chu","firstname":"Lai Ngan ","companyname":"","email":null,"tel":"91216789","address":"Flat E, 13\/F, Tower 8, South Horizons, Ap Lei Chau","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-01","renew_room_key":"055,06790","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 6, 2020. Storage deposit transferred from agreement A18-CT196600 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT206881, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"989","room_code":"X14","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1290,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-01","rent_from":"2020-02-01","rent_to":"2020-02-29","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 31, 2020. Storage deposit transferred from agreement A18-CT206881 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,06790","order_product":[],"pass":true}},"first_order_id":"4345","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> X14 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 17:35:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",663,"NEW","A18-CT207079",1290,1290,0,0,"1","1",1290,1290,1290,"2020-01-31 17:35:38","0",null,null,null,"2020-02-01","2020-02-29","1 month contract. Storage rental paid by bank transfer on January 31, 2020. Storage deposit transferred from agreement A18-CT206881 to this agreement.","2020-02-01","16",0,null,0,"0","2","2020-01-31 17:35:38","2","2020-01-31 17:35:38","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,06790","C170663","PERSONAL","Ms","+hf2BdEzeyuAlJ9o86BQkA==","uwdKi3S38jh5+tBibXKG4A==","","ZkyPYW\/X9p1lPTh\/bKU+\/PiAtXClt+yHReh+airMmSnG6Uwc2BRo5SF4sycqncKB\/EoNyhigJWrejarCTwNPAg==","q3\/rgHjoH\/vhcz82yJ8JGA==",null,"x7LEi0saK+ePsbHhJKXpDQ==",null,1,"4345"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 17:35:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7079","989","1290.0","1290.00","2","2020-01-31 17:35:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 17:35:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2020-02-29","989"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-31 17:35:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7079",663,"SETTLED","A18-I207407","2020-01-31 17:35:38","2020-02-01","2","2020-01-31 17:35:38","2","2020-01-31 17:35:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 17:35:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7407","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-01-31 17:35:38","2","2020-01-31 17:35:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 17:35:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"7407"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-31 17:35:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[663,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207055","2020-01-31 17:35:38",1290,"2","2020-01-31 17:35:38","2","2020-01-31 17:35:38","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 17:35:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7055","DEPOSIT",null,"PAID","2020-01-31 17:35:38",0,"2","2020-01-31 17:35:38","2","2020-01-31 17:35:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 17:35:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7055","INVOICE","7407","PAID","2020-01-31 17:35:38",1290,"2","2020-01-31 17:35:38","2","2020-01-31 17:35:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-31 18:14:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****