Vehicle entry and exit management method, device, computer equipment and storage medium
By deploying Bluetooth iBeacon devices on inbound and outbound vehicles and using Bluetooth base stations and a column-based database management engine, detailed vehicle entry and exit information reports are generated, solving the problem of low manual management efficiency at entry and exit ports and achieving accurate tracking and efficient management.
Patent Information
- Application Number
- CN202410651430.3
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-05-24
- Publication Date
- 2025-09-16
- Estimated Expiration
- 2044-05-24
AI Technical Summary
In existing technologies, vehicle management at entry and exit ports relies on manual labor, which is inefficient and prone to human errors, making it difficult to provide detailed and accurate data support for vehicle entry and exit management.
Positioning messages are transmitted by Bluetooth iBeacon devices deployed on inbound and outbound vehicles. These messages are received and processed by inbound and outbound Bluetooth base stations to generate vehicle entry and exit record data. These data are then analyzed using a column-based database management engine to generate detailed vehicle entry and exit information reports.
It achieves accurate tracking and recording of inbound and outbound vehicles, simplifies the data collection process, and improves the efficiency, convenience and granularity of vehicle entry and exit management.
Smart Images

Figure CN118488380B_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of intelligent transportation technology, and in particular to a vehicle entry and exit management method, apparatus, computer equipment and storage medium. Background Art
[0002] At present, the entry and exit management of vehicles at entry and exit ports still relies on manual labor. Manual management is not only inefficient, but also prone to human omissions. It is difficult to provide detailed and accurate data support for vehicle entry and exit management, and the management of entry and exit vehicles is not convenient and precise enough. Summary of the Invention
[0003] In order to improve the efficiency, convenience and granularity of vehicle entry and exit management, the present application provides a vehicle entry and exit management method, apparatus, computer equipment and storage medium.
[0004] The above-mentioned invention objective of this application is achieved through the following technical solutions:
[0005] receiving, through an entry Bluetooth base station, a first positioning message transmitted by a Bluetooth iBeacon device deployed on an inbound vehicle, and determining, through the entry Bluetooth base station, entry record data of the inbound vehicle based on the first positioning message and a first time of receiving the first positioning message;
[0006] receiving, by an outbound Bluetooth base station, a second positioning message transmitted by a Bluetooth iBeacon device deployed on an outbound vehicle, and determining, by the outbound Bluetooth base station, outbound record data of the outbound vehicle based on the second positioning message and a second time at which the second positioning message is received;
[0007] Generate a vehicle entry and exit information report based on the entry record data and the exit record data.
[0008] By adopting the above technical solutions, the efficiency, convenience and granularity of vehicle entry and exit management can be improved.
[0009] In one example, the present application may be further configured as follows: determining the entry record data of the inbound vehicle by the inbound Bluetooth base station based on the first positioning message and the first time of receiving the first positioning message, including:
[0010] Extracting the ID of the inbound vehicle carried in the first positioning message through the inbound Bluetooth base station;
[0011] Determining whether the inbound vehicle is a registered vehicle based on the inbound vehicle ID by the inbound Bluetooth base station;
[0012] If the inbound vehicle is a registered vehicle, generating a first verification code and an entry status code corresponding to the inbound vehicle through the inbound Bluetooth base station;
[0013] The entry record data of the inbound vehicle is determined by the inbound Bluetooth base station according to the ID of the inbound vehicle, the first time, the first verification code and the entry status code.
[0014] By adopting the above technical solution, the entry record data can cover key information related to the entry of inbound vehicles.
[0015] In one example, the present application may be further configured as follows: determining whether the inbound vehicle is a registered vehicle according to the ID of the inbound vehicle by the inbound Bluetooth base station includes:
[0016] The inbound vehicle's ID is compared with a pre-stored vehicle registration table through the inbound Bluetooth base station, and if there is a registration ID in the pre-stored vehicle registration table that is consistent with the inbound vehicle's ID, it is determined that the inbound vehicle is a registered vehicle.
[0017] By adopting the above technical solution, it is possible to quickly and accurately confirm that the outbound vehicle is a registered vehicle.
[0018] In one example, the present application may be further configured as follows: determining the entry record data of the inbound vehicle by the inbound Bluetooth base station according to the ID of the inbound vehicle, the first time, the first verification code, and the entry status code, including:
[0019] The ID of the incoming vehicle, the first time, the first verification code and the entry status code are combined through the entry Bluetooth base station to obtain a first combined string, and the first combined string is converted into first RFID data, and the first RFID data is used as the entry record data.
[0020] By adopting the above technical solution, it is possible to facilitate the analysis of entry record data.
[0021] In one example, the present application may be further configured as follows: determining, by the outbound Bluetooth base station, the outbound vehicle's outbound record data based on the second positioning message and the second time of receiving the second positioning message, includes:
[0022] extracting the ID of the outbound vehicle carried in the second positioning message through the outbound Bluetooth base station;
[0023] Determining whether the outbound vehicle is a registered vehicle based on the outbound vehicle ID by the outbound Bluetooth base station;
[0024] If the outbound vehicle is a registered vehicle, generating a second verification code and an outbound status code corresponding to the outbound vehicle through the outbound Bluetooth base station;
[0025] The outbound Bluetooth base station determines the entry record data of the outbound vehicle according to the ID of the outbound vehicle, the second time, the second verification code, and the outbound status code.
[0026] By adopting the above technical solution, the exit record data can cover the key information related to the exit of outbound vehicles.
[0027] In one example, the present application may be further configured as follows: generating a vehicle entry and exit information report corresponding to the entry and exit port based on the entry record data and the exit record data, including:
[0028] The entry and exit record data are analyzed by a column-based database management engine to generate a vehicle entry and exit information report corresponding to the entry and exit port.
[0029] By adopting the above technical solution, entry record data and exit record data can be analyzed efficiently and accurately, thereby generating detailed vehicle entry and exit information reports.
[0030] In one example, the present application may be further configured as follows: the entry record data and the exit record data are analyzed by the column-based database management engine to generate a vehicle entry and exit information report corresponding to the entry and exit port, including:
[0031] Importing the entry record data and the exit record data into a database table through the column-based database management engine;
[0032] Writing query statements using the query language of the column-based database management engine to extract required data from the database table for integration to obtain integrated data;
[0033] A vehicle entry and exit information report template is created through the column-based database management engine, and the integrated data is filled into the vehicle entry and exit information report template to obtain the vehicle entry and exit information report, which includes the vehicle ID and entry and exit frequency.
[0034] By adopting the above technical solutions, accurate analysis and efficient integration of entry and exit record data are achieved.
[0035] The second object of the present invention is achieved through the following technical solutions:
[0036] A vehicle entry and exit management device, comprising:
[0037] a first determining module, configured to receive, through an entry Bluetooth base station, a first positioning message transmitted by a Bluetooth iBeacon device deployed on an inbound vehicle, and determine, through the entry Bluetooth base station, entry record data of the inbound vehicle based on the first positioning message and a first time of receiving the first positioning message;
[0038] a second determining module, configured to receive, through an outbound Bluetooth base station, a second positioning message transmitted by a Bluetooth iBeacon device deployed on an outbound vehicle, and determine, through the outbound Bluetooth base station, the outbound record data of the outbound vehicle based on the second positioning message and a second time at which the second positioning message is received;
[0039] A generating module is used to generate a vehicle entry and exit information report based on the entry record data and the exit record data.
[0040] The third objective of this application is achieved through the following technical solutions:
[0041] A computer device includes a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, the steps of the vehicle entry and exit management method described above are implemented.
[0042] The fourth objective of this application is achieved through the following technical solutions:
[0043] A computer-readable storage medium stores a computer program, which, when executed by a processor, implements the steps of the above-mentioned vehicle entry and exit management method.
[0044] In summary, this application has the following beneficial technical effects:
[0045] Accurate tracking and recording of inbound and outbound vehicles are achieved through Bluetooth base stations and Bluetooth iBeacon devices, which greatly simplifies the process of collecting entry and exit record data. Based on the entry and exit record data, detailed vehicle entry and exit information reports are generated to provide support for vehicle entry and exit management at entry and exit ports, which can improve the efficiency, convenience and granularity of vehicle entry and exit management. BRIEF DESCRIPTION OF THE DRAWINGS
[0046] Figure 1 A flow chart of a vehicle entry and exit management method provided in an embodiment of the present application;
[0047] Figure 2 An example diagram of an application scenario of a vehicle entry and exit management method provided in an embodiment of the present application;
[0048] Figure 3 A schematic block diagram of a vehicle entry and exit management device provided in an embodiment of the present application;
[0049] Figure 4 This is a schematic block diagram of the structure of a computer device involved in one embodiment of the present application.
[0050] The realization of the objectives, functional features and advantages of this application will be further explained in conjunction with embodiments and with reference to the accompanying drawings. DETAILED DESCRIPTION
[0051] The following will be combined with the drawings in the embodiments of this application to clearly and completely describe the technical solutions in the embodiments of this application. Obviously, the embodiments described are part of the embodiments of this application, not all of them. Based on the embodiments in this application, all other embodiments obtained by ordinary technicians in this field without making creative efforts are within the scope of protection of this application.
[0052] The flowcharts shown in the accompanying drawings are for illustrative purposes only and do not necessarily include all contents and operations / steps, nor must they be executed in the order described. For example, some operations / steps may be decomposed, combined, or partially merged, so the actual execution order may vary depending on the actual situation.
[0053] It should be understood that the terms used in this specification are only for the purpose of describing specific embodiments and are not intended to limit the present application. As used in this specification and the appended claims, the singular forms "a", "an", and "the" are intended to include the plural forms unless the context clearly indicates otherwise.
[0054] It should be further understood that the term “and / or” used in this specification and the appended claims refers to any and all possible combinations of one or more of the associated listed items, and includes these combinations.
[0055] The embodiments of the present application provide a vehicle entry and exit management method, apparatus, computer device, and storage medium. The vehicle entry and exit management method utilizes a Bluetooth base station and Bluetooth iBeacon device to accurately track and record entry and exit vehicles, greatly simplifying the process of collecting entry and exit record data. Based on the entry and exit record data, detailed vehicle entry and exit information reports are generated, providing support for vehicle entry and exit management at entry and exit ports, thereby improving the efficiency, convenience, and granularity of vehicle entry and exit management.
[0056] The following describes some embodiments of the present application in detail with reference to the accompanying drawings. In the absence of conflict, the following embodiments and features therein may be combined with each other.
[0057] Please refer to Figure 1 , Figure 1 A schematic flow chart of a vehicle entry and exit management method provided in accordance with an embodiment of the present application. The vehicle entry and exit management method is primarily applicable to computer devices, such as PCs (Personal Computers) or servers, and other terminal devices with data processing capabilities.
[0058] Among them, the server can be an independent server or a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, content delivery networks (CDN), and big data and data analysis platforms.
[0059] like Figure 1 As shown, the vehicle entry and exit management method includes steps S101 to S103.
[0060] Step S101: receiving a first positioning message transmitted by a Bluetooth iBeacon device deployed on an inbound vehicle through an inbound Bluetooth base station, and determining the inbound record data of the inbound vehicle through the inbound Bluetooth base station based on the first positioning message and the first time the first positioning message is received.
[0061] The application environment of this vehicle entry and exit management method includes an entry and exit management system deployed on a computer device, a Bluetooth base station deployed at the entry point of an entry-exit port (defined as an entry Bluetooth base station), a Bluetooth base station deployed at the exit point of an entry-exit port (defined as an exit Bluetooth base station), and Bluetooth iBeacon devices deployed on vehicles requiring entry (defined as entry vehicles) and vehicles requiring exit (defined as exit vehicles). It is understood that the entry and exit vehicles can be the same vehicle or different vehicles.
[0062] Among them, the entry and exit management system establishes communication connections with the entry Bluetooth base station deployed at the entry point and the exit Bluetooth base station deployed at the exit point.
[0063] A Bluetooth iBeacon device is a wireless transmission device that utilizes Bluetooth Low Energy (BLE) technology. It typically consists of a small chip and a battery. It transmits positioning messages at fixed times and communicates with Bluetooth-enabled devices within a certain distance range to inform them of its presence and location. Therefore, Bluetooth iBeacon devices are deployed on incoming vehicles to transmit a first positioning message when the incoming vehicle is within the entry area of an entry-exit port, and on outgoing vehicles to transmit a second positioning message when the outgoing vehicle is within the exit area of the port. It should be noted that the first positioning message carries the ID of the incoming vehicle, and the second positioning message carries the ID of the outgoing vehicle. This ID can be a unique code composed of numbers, letters, and / or symbols that can distinguish between different vehicles.
[0064] an entry Bluetooth base station, configured to receive a first positioning message transmitted by a Bluetooth iBeacon device deployed on an inbound vehicle, and determine entry record data of the inbound vehicle based on the first positioning message and the first time the first positioning message is received, thereby reporting the entry record data of the inbound vehicle to an entry and exit management system;
[0065] The outbound Bluetooth base station is used to receive the second positioning message transmitted by the Bluetooth iBeacon device deployed on the outbound vehicle, and determine the outbound record data of the outbound vehicle based on the second positioning message and the second time when the second positioning message is received, thereby reporting the outbound record data of the outbound vehicle to the entry and exit management system.
[0066] The entry and exit management system is used to receive the entry record data of inbound vehicles reported by the entry Bluetooth base station, and receive the exit record data reported by the exit Bluetooth base station, so as to generate vehicle entry and exit information reports based on the entry record data and the exit record data.
[0067] Based on the above application environment, the vehicle entry and exit management method is introduced in detail below.
[0068] For any incoming vehicle, when it is within the entry area of the entry-exit port, the first positioning message transmitted by the Bluetooth iBeacon device can be received by the entry Bluetooth base station.
[0069] For an inbound Bluetooth base station, upon receiving the first positioning message transmitted by a Bluetooth iBeacon device deployed on an inbound vehicle, it can confirm that the corresponding inbound vehicle is within the entry area of the entry-exit port. Therefore, the inbound Bluetooth base station can determine the inbound vehicle's entry record data based on the first positioning message and the first time the first positioning message was received. The first time the inbound Bluetooth base station received the first positioning message can be used as the entry time of the inbound vehicle.
[0070] In one embodiment, determining the entry record data of an inbound vehicle based on the first positioning message and the first time of receiving the first positioning message through the entry Bluetooth base station can be: extracting the ID of the inbound vehicle carried in the first positioning message through the entry Bluetooth base station; determining whether the inbound vehicle is a registered vehicle based on the ID of the inbound vehicle through the entry Bluetooth base station; if the inbound vehicle is a registered vehicle, generating a first verification code and an entry status code corresponding to the inbound vehicle through the entry Bluetooth base station; determining the entry record data of the inbound vehicle based on the ID, first time, first verification code and entry status code of the inbound vehicle through the entry Bluetooth base station.
[0071] The inbound Bluetooth base station can extract the ID of the inbound vehicle carried in the first positioning message, and then determine whether the inbound vehicle is a registered vehicle based on the ID of the inbound vehicle.
[0072] In one embodiment, determining whether an incoming vehicle is a registered vehicle based on the ID of the incoming vehicle through the incoming Bluetooth base station can be done by comparing the ID of the incoming vehicle with a pre-stored vehicle registration table through the incoming Bluetooth base station, and determining that the incoming vehicle is a registered vehicle if there is a registration ID in the pre-stored vehicle registration table that is consistent with the ID of the incoming vehicle.
[0073] Among them, the entry Bluetooth base station stores a pre-established vehicle registration form (defined as a pre-stored vehicle registration form), which stores the IDs (defined as registration IDs) of vehicles that comply with the entry and exit management regulations of the entry and exit ports and are allowed to enter and exit after registration and approval.
[0074] The inbound Bluetooth base station can compare the ID of the inbound vehicle with the pre-stored vehicle registration table. If there is a registration ID in the pre-stored vehicle registration table that is consistent with the ID of the inbound vehicle, it can quickly and accurately confirm that the inbound vehicle is a registered vehicle.
[0075] Once the inbound vehicle is confirmed to be a registered vehicle, the inbound Bluetooth base station can generate a first verification code and an entry status code corresponding to the inbound vehicle. The first verification code is used to verify the validity and legality of the inbound vehicle's entry, and the entry status code is used to indicate the entry status of the inbound vehicle.
[0076] For example, the first verification code can be generated based on the ID of the incoming vehicle. For example, the ID of the incoming vehicle can be subjected to an operation (such as modulo, addition, subtraction, multiplication, division, encryption, etc.) according to a certain algorithm or rule to generate the first verification code based on the incoming vehicle ID. The algorithm or rule for generating the first verification code can be set according to actual needs, as long as the generated first verification code is unique and has a certain degree of security.
[0077] For example, an entry status code can be generated based on the first time. For example, the first time can be converted into a fixed-length string and a character representing the entry / exit port of entry is appended, such as the first two capital letters EN of Enter followed by the entry / exit port code. The rules for generating the entry status code can be customized based on actual needs, as long as the generated entry status code is unique and valid.
[0078] Furthermore, the entry Bluetooth base station determines the entry record data of the entry vehicle based on the ID, first time, first verification code and entry status code of the entry vehicle.
[0079] In one embodiment, the entry record data of the incoming vehicle is determined by the entry Bluetooth base station based on the ID, first time, first verification code and entry status code of the incoming vehicle. The entry Bluetooth base station combines the ID, first time, first verification code and entry status code of the incoming vehicle to obtain a first combined character string, and converts the first combined character string into first RFID data, and uses the first RFID data as the entry record data.
[0080] Specifically, the entry Bluetooth base station can combine the ID, first time, first verification code and entry status code of the entry vehicle to obtain a first combined character string. For example, the combination can be performed in the format of "ID of the entry vehicle-first time-first verification code-entry status code".
[0081] Afterwards, the first combined character string is converted into a record string in RFID format (defined as first RFID data). For example, the first combined character string is hexadecimal-encoded to generate a record string in RFID format; the first RFID data is used as entry record data of the inbound vehicle.
[0082] In this way, the entry record data can cover key information related to the entry of inbound vehicles, facilitating statistical analysis in the subsequent entry and exit management system.
[0083] Step S102: receiving, through the outbound Bluetooth base station, a second positioning message transmitted by a Bluetooth iBeacon device deployed on an outbound vehicle, and determining, through the outbound Bluetooth base station, outbound record data of the outbound vehicle based on the second positioning message and a second time at which the second positioning message is received.
[0084] For any outbound vehicle, when it is within the outbound area of the entry-exit port, the second positioning message transmitted by the Bluetooth iBeacon device deployed on the outbound vehicle can be received by the outbound Bluetooth base station.
[0085] For the outbound Bluetooth base station, as long as it receives the second positioning message transmitted by the Bluetooth iBeacon device deployed on the outbound vehicle, it can confirm that the corresponding outbound vehicle is within the outbound area of the entry-exit port. Therefore, the outbound Bluetooth base station can determine the outbound vehicle's exit record data based on the second positioning message and the second time it received the second positioning message. The second time the outbound Bluetooth base station received the second positioning message can be used as the outbound vehicle's exit time.
[0086] In one embodiment, determining the outbound record data of the outbound vehicle based on the second positioning message and the second time of receiving the second positioning message by the outbound Bluetooth base station can be as follows: extracting the ID of the outbound vehicle carried in the second positioning message by the outbound Bluetooth base station; determining whether the outbound vehicle is a registered vehicle based on the ID of the outbound vehicle by the outbound Bluetooth base station; if the outbound vehicle is a registered vehicle, generating a second verification code and an outbound status code corresponding to the outbound vehicle by the outbound Bluetooth base station; and determining the entry record data of the outbound vehicle by the outbound Bluetooth base station based on the ID of the outbound vehicle, the second time, the second verification code, and the outbound status code.
[0087] The outbound Bluetooth base station can extract the ID of the outbound vehicle carried in the second positioning message, and then determine whether the outbound vehicle is a registered vehicle based on the ID of the outbound vehicle.
[0088] Specifically, the outbound Bluetooth base station can compare the ID of the outbound vehicle with the pre-stored vehicle registration table. If there is a registration ID in the pre-stored vehicle registration table that is consistent with the ID of the outbound vehicle, it can quickly and accurately confirm that the outbound vehicle is a registered vehicle.
[0089] Once the outbound vehicle is confirmed to be a registered vehicle, the outbound Bluetooth base station can generate a second verification code and an outbound status code corresponding to the outbound vehicle. The second verification code is used to verify the validity and legality of the outbound vehicle's departure, and the outbound status code is used to indicate the outbound vehicle's corresponding outbound status.
[0090] For example, the second verification code can be generated based on the outbound vehicle ID. For example, the outbound vehicle ID can be subjected to calculations (such as modulo, addition, subtraction, multiplication, division, encryption, etc.) according to a specific algorithm or rule to generate the second verification code based on the outbound vehicle ID. The algorithm or rule for generating the second verification code can be configured according to actual needs, as long as the generated second verification code is unique and has a certain degree of security.
[0091] For example, an exit status code can be generated based on the second time. For example, the second time can be converted into a fixed-length string and a character representing the entry and exit port can be added, such as the first two capital letters of "Exit" followed by the entry and exit port code, to obtain the exit status code. The rules for generating the exit status code can be set according to actual needs, as long as the generated exit status code is unique and valid.
[0092] Furthermore, the outbound Bluetooth base station may determine the outbound record data of the outbound vehicle according to the outbound vehicle ID, the second time, the second verification code, and the outbound status code.
[0093] Specifically, the outbound Bluetooth base station can combine the outbound vehicle ID, the second time, the second verification code and the outbound status code to obtain a second combined character string. For example, the combination is performed in the format of "outbound vehicle ID-second time-second verification code-outbound status code".
[0094] Afterwards, the second combined character string is converted into a record string in RFID format (defined as second RFID data). For example, the second combined character string is also hexadecimal-encoded to generate a record string in RFID format; the second RFID data is used as the exit record data of the outbound vehicle.
[0095] In this way, the exit record data can cover key information related to the exit of outbound vehicles, which is convenient for the subsequent statistical analysis of the entry and exit management system.
[0096] The entry Bluetooth base station can report the entry record data of inbound vehicles to the vehicle entry and exit management system, and the exit Bluetooth base station can report the exit record data of outbound vehicles to the vehicle entry and exit management system.
[0097] Step S103: Generate a vehicle entry and exit information report based on the entry record data and the exit record data.
[0098] The vehicle entry and exit management system can generate vehicle entry and exit information reports based on the entry record data of inbound vehicles and the exit record data of outbound vehicles.
[0099] In one embodiment, step S103 may be to analyze the entry record data and the exit record data through a column-based database management engine to generate a vehicle entry and exit information report corresponding to the entry and exit ports.
[0100] To improve the efficiency of analyzing entry and exit record data, you can pre-deploy a column-based database management engine (ClickHouse) on the vehicle entry and exit management system. ClickHouse is a column-based database management engine (DBMS) for online analytical processing (OLAP). Compared to traditional databases, column-based database management engines offer features such as online real-time query, a complete DBMS (a column-based database management engine is a DBMS, not a single database; it allows for the creation of tables and databases, loading data, and running queries at runtime without reconfiguring or restarting the server), column-based storage, no need for any data preprocessing, support for batch updates, comprehensive SQL support and functions, and high availability.
[0101] Then the vehicle entry and exit management system can use the columnar database management engine to efficiently and accurately analyze the entry and exit record data, thereby generating detailed vehicle entry and exit information reports, providing support for vehicle entry and exit management at entry and exit ports, and improving management efficiency and granularity.
[0102] In one embodiment, entry record data and exit record data are analyzed through a column-based database management engine to generate a vehicle entry and exit information report corresponding to the entry and exit ports. This can be done by importing the entry record data and exit record data into a database table through the column-based database management engine; writing a query statement through the query language of the column-based database management engine to extract required data from the database table for integration to obtain integrated data; creating a vehicle entry and exit information report template through the column-based database management engine, and filling the integrated data into the vehicle entry and exit information report template to obtain a vehicle entry and exit information report. The vehicle entry and exit information report includes the vehicle ID and entry and exit frequency.
[0103] Specifically, the vehicle entry and exit management system first creates two database tables using a column-based database management engine. One database table is used to store entry record data, including the necessary fields corresponding to the inbound vehicle ID, first time, first verification code, and entry status code; the other database table is used to store exit record data, including the necessary fields corresponding to the outbound vehicle ID, second time, second verification code, and exit status code.
[0104] Then, the data import function is executed through the column-based database management engine to import the inbound record data and the outbound record data into the corresponding database tables respectively.
[0105] Afterwards, the corresponding first check code fields and second check code fields in the two database tables are checked respectively to ensure the validity of the two database tables.
[0106] Next, a query statement is written using a query language (e.g., SQL) for a column-based database management engine to extract the required data from the two database tables, including the ID, first time, and entry status code of inbound vehicles, and the ID, second time, and exit status code of outbound vehicles. The required data is then integrated to generate integrated data. For example, the first time, entry status code, and second time, exit status code corresponding to inbound and outbound vehicles with the same ID are matched and integrated, and the entry and exit frequencies of inbound and outbound vehicles with the same ID are counted as the same vehicle.
[0107] Finally, a vehicle entry and exit information report template is created through the columnar database management engine, and the integrated data is filled into the vehicle entry and exit information report template to obtain a vehicle entry and exit information report. The vehicle entry and exit information report can include the vehicle ID and entry and exit frequency.
[0108] In this way, accurate analysis and efficient integration of entry and exit record data are achieved through the column-based database management engine.
[0109] Figure 2 This is an example diagram of an application scenario for vehicle entry and exit management. To better understand the above embodiment, the following example application scenario is provided:
[0110] Taking the application scenario of the Hong Kong-Macao-Zhuhai shuttle bus entering and exiting the Macau port as an example, the entry Bluetooth base station deployed at the entry office of the Macau port can receive the positioning information transmitted by the Bluetooth iBeacon device deployed on the shuttle bus within the entry area of the Macau port, and thus determine the entry record data of the shuttle bus based on the positioning information and the time when the positioning information was received.
[0111] Similarly, by deploying an outbound Bluetooth base station at the exit of the Macau Port, it is possible to receive positioning messages transmitted by Bluetooth iBeacon devices deployed on shuttle buses within the exit area of the Macau Port, thereby determining the exit record data of the shuttle bus based on the positioning message and the time when the positioning message was received.
[0112] Finally, based on the entry and exit record data of the shuttle bus, the entry and exit information report corresponding to the shuttle bus can be generated, which can provide a detailed basis for the Macau Transport Bureau to monitor the Hong Kong-Zhuhai-Macao shuttle bus.
[0113] The vehicle entry and exit management method provided in the above embodiment receives a first positioning message transmitted by a Bluetooth iBeacon device deployed on an inbound vehicle through an inbound Bluetooth base station, and determines the entry record data of the inbound vehicle based on the first positioning message and the first time the first positioning message is received through the inbound Bluetooth base station; receives a second positioning message transmitted by a Bluetooth iBeacon device deployed on an outbound vehicle through an outbound Bluetooth base station, and determines the exit record data of the outbound vehicle based on the second positioning message and the second time the second positioning message is received through the outbound Bluetooth base station; and generates a vehicle entry and exit information report based on the entry record data and the exit record data. Accurate tracking and recording of inbound and outbound vehicles is achieved through the Bluetooth base station and Bluetooth iBeacon device, greatly simplifying the process of collecting entry and exit record data. Based on the entry and exit record data, a detailed vehicle entry and exit information report is generated, providing support for vehicle entry and exit management at entry and exit ports, and improving the efficiency, convenience, and granularity of vehicle entry and exit management.
[0114] Please refer to Figure 3 , Figure 3 A schematic block diagram of a vehicle entry and exit management device provided in an embodiment of the present application.
[0115] like Figure 3 As shown, the vehicle entry and exit management device 300 includes: a first determination module 301, a second determination module 302 and a generation module 303.
[0116] A first determining module 301 is configured to receive, through an entry Bluetooth base station, a first positioning message transmitted by a Bluetooth iBeacon device deployed on an inbound vehicle, and determine, through the entry Bluetooth base station, entry record data of the inbound vehicle based on the first positioning message and a first time of receiving the first positioning message;
[0117] A second determining module 302 is configured to receive, through an outbound Bluetooth base station, a second positioning message transmitted by a Bluetooth iBeacon device deployed on an outbound vehicle, and determine, through the outbound Bluetooth base station, outbound record data of the outbound vehicle based on the second positioning message and a second time at which the second positioning message is received;
[0118] The generating module 303 is used to generate a vehicle entry and exit information report based on the entry record data and the exit record data.
[0119] The apparatus provided in the above embodiment can be implemented in the form of a computer program. The computer program can be used in Figure 4 Runs on the computer device shown.
[0120] See also Figure 4 , Figure 4A schematic block diagram of the structure of a computer device provided in an embodiment of the present application.
[0121] like Figure 4 As shown, the computer device 400 includes a processor 402, a memory 403, and a communication interface 404 connected via a system bus 401, wherein the memory may include a non-volatile storage medium and an internal memory.
[0122] The non-volatile storage medium can store an operating system and a computer program. The computer program includes program instructions, and when the program instructions are executed, the processor can execute any one of the vehicle entry and exit management methods.
[0123] The processor is used to provide computing and control capabilities and support the operation of the entire computer equipment.
[0124] The internal memory provides an environment for the operation of the computer program in the non-volatile storage medium. When the computer program is executed by the processor, the processor can execute any vehicle entry and exit management method.
[0125] The communication interface is used for network communication, such as sending assigned tasks, etc. It will be understood by those skilled in the art that Figure 4 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than shown in the figure, or combine certain components, or have a different component arrangement.
[0126] It should be understood that the processor may be a central processing unit (CPU), other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The general-purpose processor may be a processor, or the processor may be any conventional processor, etc.
[0127] In one embodiment, the processor is configured to execute a computer program stored in the memory to implement the following steps:
[0128] receiving, through an entry Bluetooth base station, a first positioning message transmitted by a Bluetooth iBeacon device deployed on an inbound vehicle, and determining, through the entry Bluetooth base station, entry record data of the inbound vehicle based on the first positioning message and a first time of receiving the first positioning message;
[0129] receiving, by an outbound Bluetooth base station, a second positioning message transmitted by a Bluetooth iBeacon device deployed on an outbound vehicle, and determining, by the outbound Bluetooth base station, outbound record data of the outbound vehicle based on the second positioning message and a second time at which the second positioning message is received;
[0130] Generate a vehicle entry and exit information report based on the entry record data and the exit record data.
[0131] In one embodiment, when the processor implements determining the entry record data of the inbound vehicle based on the first positioning message and the first time of receiving the first positioning message through the inbound Bluetooth base station, it is configured to implement:
[0132] Extracting the ID of the inbound vehicle carried in the first positioning message through the inbound Bluetooth base station;
[0133] Determining whether the inbound vehicle is a registered vehicle based on the inbound vehicle ID by the inbound Bluetooth base station;
[0134] If the inbound vehicle is a registered vehicle, generating a first verification code and an entry status code corresponding to the inbound vehicle through the inbound Bluetooth base station;
[0135] The entry record data of the inbound vehicle is determined by the inbound Bluetooth base station according to the ID of the inbound vehicle, the first time, the first verification code and the entry status code.
[0136] In one embodiment, when the processor implements determining, through the inbound Bluetooth base station, based on the ID of the inbound vehicle, whether the inbound vehicle is a registered vehicle, the processor is configured to implement:
[0137] The inbound vehicle's ID is compared with a pre-stored vehicle registration table through the inbound Bluetooth base station, and if there is a registration ID in the pre-stored vehicle registration table that is consistent with the inbound vehicle's ID, it is determined that the inbound vehicle is a registered vehicle.
[0138] In one embodiment, when the processor implements determining the entry record data of the inbound vehicle through the inbound Bluetooth base station based on the ID of the inbound vehicle, the first time, the first verification code, and the entry status code, it is configured to implement:
[0139] The ID of the incoming vehicle, the first time, the first verification code and the entry status code are combined through the entry Bluetooth base station to obtain a first combined string, and the first combined string is converted into first RFID data, and the first RFID data is used as the entry record data.
[0140] In one embodiment, when the processor implements determining the exit record data of the outbound vehicle according to the second positioning message and the second time of receiving the second positioning message through the outbound Bluetooth base station, it is configured to implement:
[0141] extracting the ID of the outbound vehicle carried in the second positioning message through the outbound Bluetooth base station;
[0142] Determining whether the outbound vehicle is a registered vehicle based on the outbound vehicle ID by the outbound Bluetooth base station;
[0143] If the outbound vehicle is a registered vehicle, generating a second verification code and an outbound status code corresponding to the outbound vehicle through the outbound Bluetooth base station;
[0144] The outbound Bluetooth base station determines the entry record data of the outbound vehicle according to the ID of the outbound vehicle, the second time, the second verification code, and the outbound status code.
[0145] In one embodiment, when the processor generates the vehicle entry and exit information report corresponding to the entry and exit port based on the entry record data and the exit record data, it is configured to implement:
[0146] The entry and exit record data are analyzed by a column-based database management engine to generate a vehicle entry and exit information report corresponding to the entry and exit port.
[0147] In one embodiment, when the processor implements the analysis of the entry record data and the exit record data by the column-based database management engine to generate the vehicle entry and exit information report corresponding to the entry and exit port, it is used to implement:
[0148] Importing the entry record data and the exit record data into a database table through the column-based database management engine;
[0149] Writing query statements using the query language of the column-based database management engine to extract required data from the database table for integration to obtain integrated data;
[0150] A vehicle entry and exit information report template is created through the column-based database management engine, and the integrated data is filled into the vehicle entry and exit information report template to obtain the vehicle entry and exit information report, which includes the vehicle ID and entry and exit frequency.
[0151] An embodiment of the present application also provides a computer-readable storage medium, on which a computer program is stored. The computer program includes program instructions. The method implemented when the program instructions are executed can refer to the various embodiments of the vehicle entry and exit management method of the present application.
[0152] The computer-readable storage medium may be an internal storage unit of the computer device described in the aforementioned embodiment, such as a hard disk or memory of the computer device. The computer-readable storage medium may also be an external storage device of the computer device, such as a plug-in hard disk, a SmartMedia Card (SMC), a Secure Digital (SD) card, a flash memory card, etc., equipped on the computer device.
[0153] Furthermore, the computer-readable storage medium may mainly include a program storage area and a data storage area, wherein the program storage area may store an operating system, an application required for at least one function, etc.; the data storage area may store data created according to the use of the blockchain node, etc.
[0154] The blockchain referred to in this application is a new application model for computer technologies such as distributed data storage, peer-to-peer transmission, consensus mechanisms, and encryption algorithms. Blockchain is essentially a decentralized database, a series of data blocks generated using cryptographic methods. Each data block contains information about a batch of network transactions, which is used to verify the validity of this information (to prevent counterfeiting) and generate the next block. Blockchain can include the underlying blockchain platform, the platform product service layer, and the application service layer.
[0155] It should be noted that, in this document, the terms "comprises," "includes," or any other variations thereof are intended to encompass non-exclusive inclusion, such that a process, method, article, or system comprising a series of elements includes not only those elements but also other elements not explicitly listed, or elements inherent to such process, method, article, or system. In the absence of further limitations, an element defined by the phrase "comprising a" does not exclude the presence of other identical elements in the process, method, article, or system comprising the element.
[0156] The serial numbers of the embodiments of the present application are for description only and do not represent the advantages or disadvantages of the embodiments. The above description is only a specific embodiment of the present application, but the scope of protection of the present application is not limited thereto. Any technician familiar with the technical field can easily think of various equivalent modifications or replacements within the technical scope disclosed in this application, and these modifications or replacements should be included in the scope of protection of this application. Therefore, the scope of protection of this application should be based on the scope of protection of the claims.
Claims
1. A vehicle entry and exit management method, characterized in that: The method comprises: Receiving a first positioning message transmitted by a Bluetooth iBeacon device deployed on an incoming vehicle through an entry Bluetooth base station, and determining the entry record data of the incoming vehicle through the entry Bluetooth base station based on the first positioning message and the first time the first positioning message is received; determining the entry record data of the incoming vehicle through the entry Bluetooth base station based on the first positioning message and the first time the first positioning message is received, including: extracting the ID of the incoming vehicle carried in the first positioning message through the entry Bluetooth base station; determining whether the incoming vehicle is a registered vehicle based on the ID of the incoming vehicle through the entry Bluetooth base station; The determining, by the inbound Bluetooth base station according to the ID of the inbound vehicle, whether the inbound vehicle is a registered vehicle includes: The inbound vehicle ID is compared with a pre-stored vehicle registration table through the inbound Bluetooth base station, and if there is a registration ID in the pre-stored vehicle registration table that is consistent with the ID of the inbound vehicle, it is determined that the inbound vehicle is a registered vehicle; If the inbound vehicle is a registered vehicle, generating a first verification code and an entry status code corresponding to the inbound vehicle through the inbound Bluetooth base station; determining the entry record data of the inbound vehicle through the inbound Bluetooth base station based on the ID of the inbound vehicle, the first time, the first verification code, and the entry status code; The determining, by the entry Bluetooth base station according to the ID of the entry vehicle, the first time, the first verification code, and the entry status code, of the entry record data of the entry vehicle includes: combining the ID of the inbound vehicle, the first time, the first verification code, and the inbound status code through the inbound Bluetooth base station to obtain a first combined string, converting the first combined string into first RFID data, and using the first RFID data as the inbound record data; Receiving, by an outbound Bluetooth base station, a second positioning message transmitted by a Bluetooth iBeacon device deployed on an outbound vehicle, and determining, by the outbound Bluetooth base station, the outbound record data of the outbound vehicle based on the second positioning message and the second time at which the second positioning message is received; determining, by the outbound Bluetooth base station, the outbound record data of the outbound vehicle based on the second positioning message and the second time at which the second positioning message is received, includes: extracting, by the outbound Bluetooth base station, the ID of the outbound vehicle carried in the second positioning message; determining, by the outbound Bluetooth base station, whether the outbound vehicle is a registered vehicle based on the ID of the outbound vehicle; if the outbound vehicle is a registered vehicle, generating, by the outbound Bluetooth base station, a second verification code and an outbound status code corresponding to the outbound vehicle; determining, by the outbound Bluetooth base station, the outbound record data of the outbound vehicle based on the ID of the outbound vehicle, the second time, the second verification code, and the outbound status code; Generate a vehicle entry and exit information report based on the entry record data and the exit record data, and generate a vehicle entry and exit information report corresponding to the entry and exit port based on the entry record data and the exit record data, including: analyzing the entry record data and the exit record data through a columnar database management engine to generate a vehicle entry and exit information report corresponding to the entry and exit port.
2. The vehicle entry and exit management method according to claim 1, characterized in that: The column-based database management engine is used to analyze the entry and exit record data to generate a vehicle entry and exit information report corresponding to the entry and exit port, including: Importing the entry record data and the exit record data into a database table through the column-based database management engine; Writing query statements using the query language of the column-based database management engine to extract required data from the database table for integration to obtain integrated data; A vehicle entry and exit information report template is created through the column-based database management engine, and the integrated data is filled into the vehicle entry and exit information report template to obtain the vehicle entry and exit information report, which includes the vehicle ID and entry and exit frequency.
3. A vehicle entry and exit management device, characterized in that: The vehicle entry and exit management device includes: The first determination module is used to receive the first positioning message transmitted by the Bluetooth iBeacon device deployed on the incoming vehicle through the entry Bluetooth base station, and determine the entry record data of the incoming vehicle according to the first positioning message and the first time of receiving the first positioning message through the entry Bluetooth base station; determining the entry record data of the incoming vehicle according to the first positioning message and the first time of receiving the first positioning message through the entry Bluetooth base station can be to extract the ID of the incoming vehicle carried by the first positioning message through the entry Bluetooth base station; determine whether the incoming vehicle is a registered vehicle according to the ID of the incoming vehicle through the entry Bluetooth base station; when determining whether the incoming vehicle is a registered vehicle according to the ID of the incoming vehicle through the entry Bluetooth base station, it is used to achieve: comparing the ID of the incoming vehicle with the pre-stored vehicle registration table through the entry Bluetooth base station, and if there is a corresponding ID in the pre-stored vehicle registration table When the ID of the incoming vehicle is consistent with the registered ID, it is determined that the incoming vehicle is a registered vehicle; when the incoming vehicle is a registered vehicle, a first verification code and an entry status code corresponding to the incoming vehicle are generated through the entry Bluetooth base station; the entry record data of the incoming vehicle is determined by the entry Bluetooth base station according to the ID, first time, first verification code and entry status code of the incoming vehicle; when the entry record data of the incoming vehicle is determined by the entry Bluetooth base station according to the ID, first time, first verification code and entry status code of the incoming vehicle, it is used to achieve: the ID, first time, first verification code and entry status code of the incoming vehicle are combined by the entry Bluetooth base station to obtain a first combination character string, and the first combination character string is converted into first RFID data, and the first RFID data is used as the entry record data; A second determination module is configured to receive, through an outbound Bluetooth base station, a second positioning message transmitted by a Bluetooth iBeacon device deployed on an outbound vehicle, and determine, through the outbound Bluetooth base station, the outbound record data of the outbound vehicle based on the second positioning message and the second time at which the second positioning message is received; determining, through the outbound Bluetooth base station, the outbound record data of the outbound vehicle based on the second positioning message and the second time at which the second positioning message is received may be, extracting, through the outbound Bluetooth base station, the ID of the outbound vehicle carried in the second positioning message; determining, through the outbound Bluetooth base station, whether the outbound vehicle is a registered vehicle based on the ID of the outbound vehicle; if the outbound vehicle is a registered vehicle, generating, through the outbound Bluetooth base station, a second verification code and an outbound status code corresponding to the outbound vehicle; determining, through the outbound Bluetooth base station, the outbound record data of the outbound vehicle based on the ID of the outbound vehicle, the second time, the second verification code, and the outbound status code; A generating module is configured to generate a vehicle entry and exit information report based on the entry record data and the exit record data, wherein the generating module generates a vehicle entry and exit information report corresponding to the entry and exit port based on the entry record data and the exit record data, including: The entry and exit record data are analyzed by a column-based database management engine to generate a vehicle entry and exit information report corresponding to the entry and exit port.
4. A computer device, characterized in that: The method comprises a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of the vehicle entry and exit management method as claimed in any one of claims 1 to 2 when executing the computer program.
5. A computer-readable storage medium, characterized in that The computer-readable storage medium stores a computer program, wherein when the computer program is executed by a processor, the steps of the vehicle entry and exit management method according to any one of claims 1 to 2 are implemented.
Citation Information
Patent Citations
Vehicle entering and exiting system based on Bluetooth recognition
CN104992484A
Vehicle checking method and system
CN113744441A