Speed sensor alarm data query method and device, medium, equipment and product

Abstract

The invention discloses a speed sensor alarm data query method and device, a medium, equipment and a product, the method is applied to a front end, and the method comprises the following steps: generating an alarm data query request based on a query operation of a user on a data management interface; the alarm data comprises alarm data of the speed sensor; the query request carries a query range parameter of the alarm data; sending the query request to a back end, and receiving a retrieval result of the alarm data returned by the back end; the retrieval result is retrieved by the back end in the database based on the query range parameter; and displaying the retrieval result in a chart form based on an open source visualization library. According to the method and the device provided by the invention, the query efficiency of the alarm data of the speed sensor is improved; according to the technical scheme, the alarm data can be presented in a visual mode, and the readability of the alarm data is improved, so that the accuracy and timeliness of alarm fault diagnosis are improved, and the safety and reliability of vehicle operation are ensured.

Description

Technical Field

[0001] The present application relates to the field of computer technology, and in particular to a speed sensor alarm data query method, device, medium, equipment and product. Background Art

[0002] In rail transit, the alarm data of the train's speed sensors are generally stored in the same database. It is difficult for users to view the alarm data intuitively, and the presentation of the alarm data is not clear, making it inconvenient to analyze and diagnose the cause of the alarm.

[0003] Therefore, how to efficiently query alarm data and clearly display the alarm data has become a technical problem that needs to be solved urgently in the industry. Summary of the invention

[0004] The present application provides a speed sensor alarm data query method, device, medium, equipment and product to solve the technical problem of how to efficiently query alarm data and clearly display the alarm data in the prior art.

[0005] In a first aspect, the present application provides a speed sensor alarm data query method, which is applied to a front end, and the method includes: Generate a query request for alarm data based on a query operation of a user in a data management interface; the alarm data includes alarm data of a speed sensor; the query request carries a query range parameter of the alarm data; Sending the query request to the backend, and receiving the search result of the alarm data returned by the backend; the search result is obtained by the backend in the database based on the query range parameter; The search results are displayed in the form of charts based on an open source visualization library.

[0006] In some embodiments, sending the query request to a backend and receiving a search result of the alarm data returned by the backend includes: Sending the query request to the application programming interface of the backend; the application programming interface is used to define the uniform resource locator and parameter format of the query request; Receiving the search result returned by the application programming interface; The backend constructs a structured query language query statement for the alarm data based on the application programming interface, and retrieves the alarm data in the database based on the structured query language query statement to obtain the retrieval result.

[0007] In some embodiments, the display of the search results in the form of a chart based on an open source visualization library includes: Displaying the number of alarms of the speed sensor in the search result; the number of alarms is the number of alarms of the speed sensor that have not been cleared at present; Identify time dimension statistical data of the alarm of the speed sensor in the search result, and convert the time dimension statistical data into a line chart for display based on the chart plug-in of the open source visualization library; Based on the alarm release time of the vehicle side in the search results, the alarm data is displayed in the form of a scatter plot.

[0008] In some embodiments, the data management interface is provided with a query range parameter option; the query range parameter option includes a time range option and a vehicle information option; The time range option supports the user to select the start date and end date of the alarm, and supports setting a default time range; The vehicle information option supports fuzzy search or information auto-completion function, and supports vehicle information verification; The data management interface supports paging query and asynchronous loading of the alarm data.

[0009] In some embodiments, after displaying the search results in the form of a chart based on an open source visualization library, the method further includes: Generate a report generation request for the alarm data based on the report acquisition operation of the user in the data management interface; the report generation request carries the search results and indicators to be filled in the report template; Sending the report generation request to the backend, and receiving the report file in the form of file download returned by the backend; The report file is obtained based on the backend acquiring the data of the indicator to be filled in the database and filling the data of the indicator to be filled in into the report template.

[0010] In some embodiments, after displaying the search results in the form of a chart based on an open source visualization library, the method further includes: Generate a report generation request for the alarm data periodically based on a set period; The report generation request is sent to the backend, and a report file in the form of a file download returned by the backend is received.

[0011] In a second aspect, the present application provides a speed sensor alarm data query device, which is applied to a front end, and the device includes: A generating module, configured to generate a query request for alarm data based on a query operation of a user in a data management interface; the alarm data includes alarm data of a speed sensor; and the query request carries a query range parameter of the alarm data; A retrieval module is used to send the query request to the backend and receive the retrieval result of the alarm data returned by the backend; the retrieval result is obtained by the backend in the database based on the query range parameter; The display module is used to display the search results in the form of charts based on the open source visualization library.

[0012] In a third aspect, the present application provides a non-transitory computer-readable storage medium having a computer program stored thereon, which implements the above method when executed by a processor.

[0013] In a fourth aspect, the present application provides an electronic device, comprising a memory and a processor, wherein the memory stores a computer program, and the processor is configured to implement the above method when executing the program through the computer program.

[0014] In a fifth aspect, the present application also provides a computer program product, including a computer program, which implements the above method when executed by a processor.

[0015] The speed sensor alarm data query method, device, medium, equipment and product provided by the present application can quickly query the alarm data of the speed sensor by sending a query request carrying the query range parameters of the speed sensor alarm data to the back end through the front end, and receiving the retrieval results of the alarm data retrieved in the database according to the query range parameters returned by the back end, thereby improving the data query efficiency; the retrieval results are displayed in the form of charts through an open source visualization library, so that the alarm data can be presented in an intuitive manner, which improves the readability of the alarm data and can help maintenance personnel to more efficiently analyze and view the alarm data of the vehicle speed sensor, thereby improving the accuracy and timeliness of alarm fault diagnosis and ensuring the safety and reliability of vehicle operation. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present application and, together with the description, serve to explain the principles of the present application.

[0017] In order to more clearly illustrate the technical solutions in the present application or the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0018] Figure 1 One of the flow charts of the speed sensor alarm data query method provided in the embodiment of the present application; Figure 2 A second flow chart of a speed sensor alarm data query method provided in an embodiment of the present application; Figure 3 A schematic diagram of the structure of a speed sensor alarm data query device provided in an embodiment of the present application; Figure 4 A schematic diagram of the structure of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0019] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present application.

[0020] It should be noted that the terms "first", "second" etc. in the present application are used to distinguish similar objects, and need not be used to describe a specific order or sequential order. It should be understood that the data used in this way can be interchangeable in appropriate circumstances, so that the embodiments of the present application described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any of their variations are intended to cover non-exclusive inclusions, for example, the process, method, system, product or equipment comprising a series of steps or modules need not be limited to those steps or modules clearly listed, but may include other steps or modules that are not clearly listed or inherent to these processes, methods, products or equipment.

[0021] The speed sensor alarm data query method provided in the embodiment of the present application is applicable to the front end, which can be the front end of various electronic devices with a display screen and supporting web browsing, including but not limited to servers, smart phones, tablet computers, laptops, and desktop computers.

[0022] In the technical solution of this application, the collection, storage, use, processing, transmission, provision and disclosure of personal information involved comply with the provisions of relevant laws and regulations, take necessary confidentiality measures, and do not violate public order and good morals.

[0023] Figure 1 One of the flow charts of the speed sensor alarm data query method provided in the embodiment of the present application is as follows: Figure 1 As shown, the method includes step 110, step 120 and step 130. The steps of the method flow are only a possible implementation of the present application.

[0024] Step 110: Generate a query request for alarm data based on the query operation of the user in the data management interface; the alarm data includes the alarm data of the speed sensor; and the query request carries a query range parameter of the alarm data.

[0025] Specifically, the execution subject of the speed sensor alarm data query method provided in the embodiment of the present application is a speed sensor alarm data query device, which can be a hardware device independently set in the front-end device or a software program running in the front-end device.

[0026] The data management interface is a front-end user interface for managing and operating alarm data. It supports users to perform operations such as data query and report acquisition. The data management interface supports users to query data based on conditions such as time range and vehicle information, making it convenient to view and export alarm data on demand. Users can be operation and maintenance personnel.

[0027] The warning data of the speed sensor may include relevant information such as vehicle speeding and abnormal speed.

[0028] The query range parameter refers to the conditions or parameters specified by the user in the data management interface to limit the query range of alarm data, such as the time range.

[0029] The embodiment of the present application designs the page layout and interactive functions of the data management interface at the front end, establishes a RESTful API interface and query logic at the back end, stores the alarm data through the database and optimizes the data query speed. In terms of parameter settings, the time range selection can provide a date selector and a default range, the vehicle-side information input supports drop-down selection and verification, and the data query can optimize the index and structured query language (SQL) statement to improve the query performance. This helps users accurately analyze and monitor the speed sensor alarm data and achieve effective management of the vehicle operation.

[0030] You can design the front-end data management interface through the front-end Vue component, including the layout of each functional module and the setting of interaction mode. You can use the Vue framework to write components to implement functions such as data display, user interaction and data request. Draw various charts such as line charts and bar charts by integrating the ECharts library. The ECharts library is an open source visualization library.

[0031] You can use the Node.js backend framework to build backend services, receive requests from the frontend and process data. Design a RESTful API interface, and define the Uniform Resource Locator (URL) and parameter format of the data request through the RESTful API interface. Write data query logic through the backend interface, connect to the database and perform query operations to obtain speed sensor alarm data.

[0032] You can create a MySQL database and design the speed sensor alarm data table structure. Define indexes to speed up data query, especially for common query conditions such as alarm time. Write a scheduled task or data import script to store real-time alarm data in the database.

[0033] Designing the data management interface through the front-end Vue component, setting up an efficient back-end data interface, and selecting appropriate database storage and optimization can lay the foundation for improving data query efficiency.

[0034] The front end can generate a query request for the alarm data of the speed sensor through the query operation of the user in the data management interface, and the request can be an HTTP request. The query request carries the query range parameter of the alarm data. The front end sends the query request to the application programming interface (Application Programming Interface, API) of the back end, passing the query range parameters, such as time range and vehicle information.

[0035] Step 120: Send the query request to the backend, and receive the retrieval result of the alarm data returned by the backend; the retrieval result is obtained by the backend in the database based on the query range parameter.

[0036] Specifically, the backend interface receives a query request, parses the query request, obtains a query range parameter of the alarm data, constructs an SQL query statement according to the query range parameter of the alarm data, retrieves the alarm data in the database through the SQL query statement, and obtains a search result, which includes the alarm data.

[0037] The backend returns the search results to the frontend in JSON format.

[0038] Step 130: Display the search results in the form of charts based on the open source visualization library.

[0039] Specifically, after the front end obtains the search results sent by the back end, the alarm data in the search results are visualized in the form of charts through the open source visualization library.

[0040] For example, after the user selects a time period on the data management interface and clicks query, the front end sends the time range parameters to the back end API interface. The back end queries the database based on the parameters and returns the search results to the front end. The front end updates the page display based on the search results.

[0041] The embodiment of the present application can also provide a search report. For example, when the user clicks the report generation button in the data management interface, the front end sends the search result as a parameter to the back end API interface. The back end generates a report file based on the parameter and returns it to the front end. The front end provides the report file for downloading to the user. In this way, the user can see the charts and statistical information of the speed sensor alarm data queried according to the selected time period, and can generate and download the corresponding report file.

[0042] It can monitor the vehicle's speed sensor warning status in real time and promptly remind users to help them take timely measures to avoid potential problems.

[0043] It can also provide analysis of alarm clearing time to help evaluate the efficiency of vehicle fault handling, optimize repair and maintenance plans, and reduce parking time and costs.

[0044] The speed sensor alarm data query method provided in the embodiment of the present application can quickly query the alarm data of the speed sensor by sending a query request carrying the query range parameters of the speed sensor alarm data to the back end through the front end, and receiving the retrieval result of the alarm data retrieved in the database according to the query range parameters returned by the back end, thereby improving the data query efficiency; the retrieval result is displayed in the form of a chart through an open source visualization library, so that the alarm data can be presented in an intuitive manner, which improves the readability of the alarm data and can help maintenance personnel to more efficiently analyze and view the alarm data of the vehicle speed sensor, thereby improving the accuracy and timeliness of alarm fault diagnosis and ensuring the safety and reliability of vehicle operation.

[0045] It should be noted that each implementation method of the present application can be freely combined, the order can be changed, or it can be executed separately, and does not need to rely on or depend on a fixed execution order.

[0046] In some embodiments, step 120 includes: An application programming interface for sending the query request to a backend; the application programming interface is used to define a uniform resource locator and parameter format of the query request; receiving the search result returned by the application programming interface; The backend constructs a structured query language query statement for the alarm data based on the application programming interface, and retrieves the alarm data in the database based on the structured query language query statement to obtain a retrieval result.

[0047] Step 130 includes: The number of alarms of the speed sensor in the search results is displayed; the number of alarms is the number of alarms that have not been cleared by the current speed sensor; Identify the time dimension statistics of the speed sensor alarms in the search results, and convert the time dimension statistics into a line chart for display based on the chart plug-in of the open source visualization library; Based on the alarm release time on the vehicle side in the search results, the alarm data is displayed in the form of a scatter plot.

[0048] Specifically, Figure 2 The second flow chart of the speed sensor alarm data query method provided in the embodiment of the present application is as follows: Figure 2 As shown, the method includes the following steps.

[0049] The user selects the query range parameters of the alarm data on the data management interface, for example, the time period of the most recent week. The user clicks the query button to trigger the query function of the front-end Vue component. The query function is used to display subsequent data.

[0050] The front-end Vue component uses the time period selected by the user as the query range parameter and sends it to the back-end Application Programming Interface (API) interface through an HTTP request.

[0051] After receiving the request, the backend API interface constructs the corresponding SQL query statement.

[0052] The back-end API interface connects to the database, performs a query operation, retrieves the speed sensor alarm data that meets the time period condition, and obtains the retrieval result.

[0053] The database returns the search results to the backend API interface. The backend API interface returns the search results to the frontend Vue component in JSON format.

[0054] The front-end Vue component receives the search results and updates and displays the chart based on the warning data in the search results.

[0055] The data management interface updates charts and statistical information based on the search results and presents them to the user.

[0056] Table 1 describes the display content of some display components, the data processing process of the search results, and the generation logic of the final display results.

[0057] Table 1 Speed ​​sensor fault alarm analysis shows relevant information of components

[0058] According to indicators such as the number of alarms and the proportion, the alarms can be ranked and analyzed from the dimensions of vehicles and sections according to the vehicle end and section location of the alarm, helping to find vehicles with frequent alarms, carry out targeted maintenance and improvements, and improve vehicle reliability and operating efficiency. Special values ​​can also be selected for display to highlight abnormal values ​​or trends in the data, allowing maintenance personnel to quickly find problems and take corresponding measures.

[0059] The speed sensor alarm data query method provided in the embodiment of the present application adopts a multi-dimensional data display method to classify and display the speed sensor fault alarm data according to different dimensions, which can help maintenance personnel to fully understand the alarm data situation.

[0060] In some embodiments, a query range parameter option is provided in the data management interface; the query range parameter option includes a time range option and a vehicle information option; The time range option allows users to select the start and end dates of the alarm, as well as support setting the default time range; The vehicle information option supports fuzzy search or information auto-completion function, as well as vehicle information verification; The data management interface supports paginated query and asynchronous loading of alarm data.

[0061] Specifically, the data management interface is provided with query range parameter options, which may include time options and vehicle information options.

[0062] A date picker can be provided to allow users to select a start date and an end date. A default time range can also be set, such as the data for the last week or month. The minimum and maximum time ranges can also be limited according to business needs to avoid excessive data queries.

[0063] A drop-down menu can be provided to select vehicle information and obtain a list of vehicles from the database. Fuzzy search or auto-complete functions are supported to facilitate users to enter vehicle information. Vehicle information can also be verified to ensure that the entered vehicle information is valid. A drop-down menu for the segment position can be added to obtain the segment list of the corresponding vehicle from the database. There are two logics in the drop-down list here: vehicle information and segment information can be selected separately, and only one can be selected to search; the two searches are linked. After selecting a vehicle, the segment list will only display the segment where the selected vehicle has an alarm. The same applies in reverse.

[0064] You can use database indexes to optimize query performance, especially for fields such as alarm time and vehicle information. You can write efficient SQL query statements to avoid full table scans and unnecessary data loading. It can also support paging queries and asynchronous loading when the amount of data is large, improving system response speed.

[0065] The speed sensor alarm data query method provided in the embodiment of the present application realizes detailed parameter settings by setting a query range parameter option in the data management interface, which can improve data query efficiency and data query stability, help users accurately query and analyze alarm data, and realize monitoring and management of vehicle operation conditions.

[0066] In some embodiments, after step 130, the method further includes: Generate a report generation request for alarm data based on a report acquisition operation of a user in a data management interface; the report generation request carries the search results and indicators to be filled in the report template; Send a report generation request to the backend, and receive a report file in the form of a file download returned by the backend; The report file is obtained based on the backend obtaining the data of the indicator to be filled in the database and filling the data of the indicator to be filled in into the report template.

[0067] After step 130, the following steps are also included:

[0068] Generate a report request based on a set period to periodically generate alarm data; Send a report generation request to the backend, and receive the report file in the form of a file download returned by the backend.

[0069] Specifically, the report template can be designed in advance, including setting the structure, style and data filling method of the report, so as to ensure that the generated report has good readability and aesthetics.

[0070] The indicators to be filled in are the indicators to be filled in the report template.

[0071] You can add the report generation function to the front-end Vue component. Users can select a time period and click the Generate Report button in the data management interface. The front-end uses the time period selected by the user as a parameter and sends a report generation request to the back-end API interface. The report generation request can be an HTTP request.

[0072] After receiving the report generation request, the back-end API interface parses it, obtains the parameter, and queries the database to obtain the corresponding speed sensor alarm data according to the parameter. The back-end uses a template engine or other methods to fill the data into the report template and generate a report file.

[0073] The backend returns the generated report file to the frontend in the form of a file download, and the frontend provides the report file to the user for download.

[0074] For example, the front-end Vue component generates a report button based on the search results and passes the search results as parameters to the back-end API interface. The user clicks the Generate Report button to trigger the report generation function of the front-end Vue component. The front-end Vue component sends the search results as parameters to the back-end API interface through an HTTP request. The back-end API interface receives the HTTP request, parses the parameters, and queries the database to obtain the corresponding speed sensor alarm data based on the parameters. The back-end fills the data into the report template to generate a report file and returns the report file to the front-end. The front-end Vue component receives the report file and provides it to the user for download.

[0075] Periodic reports can also be generated regularly, such as weekly or monthly reports, so that users can regularly understand and evaluate the vehicle's warning conditions, allowing users to have a more comprehensive understanding of the vehicle's operating conditions and take appropriate measures to improve the vehicle's safety and reliability.

[0076] The speed sensor alarm data query method provided in the embodiment of the present application provides a report generation function, and the user can generate a report according to the selected time period to analyze and record the alarm situation in more detail; through the report generation function, the user can more conveniently obtain detailed alarm data and conduct more in-depth analysis and recording.

[0077] The speed sensor alarm data query device provided in an embodiment of the present application is described below. The speed sensor alarm data query device described below and the speed sensor alarm data query method described above can refer to each other.

[0078] Figure 3 A schematic diagram of the structure of a speed sensor alarm data query device provided in an embodiment of the present application, such as Figure 3 As shown, the device is applied to the front end, and the device includes a generation module 310, a retrieval module 320 and a display module 330.

[0079] A generation module, used to generate a query request for alarm data based on a query operation of a user in a data management interface; the alarm data includes alarm data of a speed sensor; and the query request carries a query range parameter of the alarm data; The retrieval module is used to send the query request to the backend and receive the retrieval result of the alarm data returned by the backend; the retrieval result is retrieved by the backend in the database based on the query range parameter; The display module is used to display the search results in the form of charts based on the open source visualization library.

[0080] Specifically, according to an embodiment of the present application, any multiple modules among the generation module, the retrieval module and the display module can be combined into one module for implementation, or any one of the modules can be split into multiple modules.

[0081] Alternatively, at least part of the functionality of one or more of these modules may be combined with at least part of the functionality of other modules and implemented in one module.

[0082] According to an embodiment of the present application, at least one of the generation module, the retrieval module and the display module can be at least partially implemented as a hardware circuit, such as a field programmable gate array, a programmable logic array, a system on a chip, a system on a substrate, a system on a package, an application-specific integrated circuit, or can be implemented by hardware or firmware such as any other reasonable way of integrating or packaging the circuit, or can be implemented in any one of the three implementation methods of software, hardware and firmware, or in an appropriate combination of any of them.

[0083] Alternatively, at least one of the generating module, the retrieving module and the displaying module may be at least partially implemented as a computer program module, and when the computer program module is executed, the corresponding function may be performed.

[0084] The speed sensor alarm data query device provided in the embodiment of the present application sends a query request carrying a query range parameter of the speed sensor alarm data to the back end through the front end, and receives the retrieval result of the alarm data retrieved in the database according to the query range parameter returned by the back end, so that the alarm data of the speed sensor can be quickly queried, thereby improving the data query efficiency; the retrieval result is displayed in the form of a chart through an open source visualization library, so that the alarm data can be presented in an intuitive manner, which improves the readability of the alarm data, and can help maintenance personnel to more efficiently analyze and view the alarm data of the vehicle speed sensor, thereby improving the accuracy and timeliness of alarm fault diagnosis and ensuring the safety and reliability of vehicle operation.

[0085] In some embodiments, the retrieval module is specifically used to: An application programming interface for sending the query request to a backend; the application programming interface is used to define a uniform resource locator and parameter format of the query request; receiving the search result returned by the application programming interface; The backend constructs a structured query language query statement for the alarm data based on the application programming interface, and retrieves the alarm data in the database based on the structured query language query statement to obtain a retrieval result.

[0086] In some embodiments, the display module is specifically used to: The number of alarms of the speed sensor in the search results is displayed; the number of alarms is the number of alarms that have not been cleared by the current speed sensor; Identify the time dimension statistics of the speed sensor alarms in the search results, and convert the time dimension statistics into a line chart for display based on the chart plug-in of the open source visualization library; Based on the alarm release time on the vehicle side in the search results, the alarm data is displayed in the form of a scatter plot.

[0087] In some embodiments, a query range parameter option is provided in the data management interface; the query range parameter option includes a time range option and a vehicle information option; The time range option allows users to select the start and end dates of the alarm, as well as support setting the default time range; The vehicle information option supports fuzzy search or information auto-completion function, as well as vehicle information verification; The data management interface supports paginated query and asynchronous loading of alarm data.

[0088] In some embodiments, the speed sensor warning data query device further includes a reporting module, and the reporting module is specifically used to: Generate a report generation request for alarm data based on a report acquisition operation of a user in a data management interface; the report generation request carries the search results and indicators to be filled in the report template; Send a report generation request to the backend, and receive a report file in the form of a file download returned by the backend; The report file is obtained based on the backend obtaining the data of the indicator to be filled in the database and filling the data of the indicator to be filled in into the report template.

[0089] In some embodiments, the reporting module is further specifically configured to: Generate a report request based on a set period to periodically generate alarm data; Send a report generation request to the backend, and receive the report file in the form of a file download returned by the backend.

[0090] It should be noted here that the speed sensor alarm data query device provided in the embodiment of the present application can implement all the method steps implemented in the above-mentioned speed sensor alarm data query method embodiment, and can achieve the same technical effect. The parts and beneficial effects of this embodiment that are the same as the method embodiment will not be described in detail here.

[0091] Figure 4 A schematic diagram of the structure of an electronic device provided in an embodiment of the present application, such as Figure 4As shown, the electronic device may include: a processor (Processor) 410, a communication interface (Communications Interface) 420, a memory (Memory) 430 and a communication bus (Communications Bus) 440, wherein the processor 410, the communication interface 420, and the memory 430 communicate with each other through the communication bus 440. The processor 410 may call the logic command in the memory 430 to execute the above method, which includes: A query request for alarm data is generated based on a query operation of a user in a data management interface; the alarm data includes alarm data of a speed sensor; and the query request carries a query range parameter of the alarm data; Send the query request to the backend, and receive the retrieval result of the alarm data returned by the backend; the retrieval result is retrieved by the backend in the database based on the query range parameters; The search results are displayed in the form of charts based on the open source visualization library.

[0092] In addition, the logical commands in the above-mentioned memory can be implemented in the form of software function modules and can be stored in a computer-readable storage medium when sold or used as an independent product. Based on this understanding, the technical solution of the present application can be essentially or partly embodied in the form of a software product that contributes to the prior art. The computer software product is stored in a storage medium, including several commands to enable a computer device (which can be a personal computer, server, or network device, etc.) to execute all or part of the steps of the method described in each embodiment of the present application. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM), random access memory (RAM), disk or optical disk, etc., and other media that can store program codes.

[0093] The processor in the electronic device provided in the embodiment of the present application can call the logic instructions in the memory to implement the above method. Its specific implementation method is consistent with the implementation method of the aforementioned method and can achieve the same beneficial effects, which will not be repeated here.

[0094] An embodiment of the present application also provides a non-transitory computer-readable storage medium on which a computer program is stored. When the computer program is executed by a processor, the methods provided in the above embodiments are implemented.

[0095] Its specific implementation is consistent with the aforementioned method implementation and can achieve the same beneficial effects, so it will not be repeated here.

[0096] An embodiment of the present application provides a computer program product, including a computer program, which implements the above method when executed by a processor.

[0097] The device embodiments described above are merely illustrative, wherein the modules described as separate components may or may not be physically separated, and the components displayed as modules may or may not be physical modules, i.e., they may be located in one place, or they may be distributed on multiple network modules. Some or all of the modules may be selected according to actual needs to achieve the purpose of the scheme of this embodiment. Those of ordinary skill in the art may understand and implement it without creative effort.

[0098] Through the description of the above implementation methods, those skilled in the art can clearly understand that each implementation method can be implemented by means of software plus a necessary general hardware platform, and of course, can also be implemented by hardware. Based on this understanding, the above technical solution is essentially or the part that contributes to the prior art can be embodied in the form of a software product, and the computer software product can be stored in a computer-readable storage medium, such as ROM / RAM, a disk, an optical disk, etc., including a number of instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods described in each embodiment or some parts of the embodiments.

[0099] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present application, rather than to limit it. Although the present application has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present application.

Claims

1. A speed sensor alarm data query method, It is characterized in that Applied to the front end, the method includes: Generate a query request for alarm data based on a query operation of a user in a data management interface; the alarm data includes alarm data of a speed sensor; the query request carries a query range parameter of the alarm data; Sending the query request to the backend, and receiving the search result of the alarm data returned by the backend; the search result is obtained by the backend in the database based on the query range parameter; The search results are displayed in the form of charts based on an open source visualization library.

2. The speed sensor alarm data query method according to claim 1, It is characterized in that The sending the query request to the backend and receiving the search result of the alarm data returned by the backend includes: Sending the query request to the application programming interface of the backend; the application programming interface is used to define the uniform resource locator and parameter format of the query request; Receiving the search result returned by the application programming interface; The backend constructs a structured query language query statement for the alarm data based on the application programming interface, and retrieves the alarm data in the database based on the structured query language query statement to obtain the retrieval result.

3. The speed sensor alarm data query method according to claim 1, It is characterized in that The search results are displayed in the form of charts based on the open source visualization library, including: Displaying the number of alarms of the speed sensor in the search result; the number of alarms is the number of alarms of the speed sensor that have not been cleared at present; Identify time dimension statistical data of the alarm of the speed sensor in the search result, and convert the time dimension statistical data into a line chart for display based on the chart plug-in of the open source visualization library; Based on the alarm release time of the vehicle side in the search results, the alarm data is displayed in the form of a scatter plot.

4. The speed sensor alarm data query method according to claim 1, It is characterized in that The data management interface is provided with a query range parameter option; the query range parameter option includes a time range option and a vehicle information option; The time range option supports the user to select the start date and end date of the alarm, and supports setting a default time range; The vehicle information option supports fuzzy search or information auto-completion function, and supports vehicle information verification; The data management interface supports paging query and asynchronous loading of the alarm data.

5. The speed sensor alarm data query method according to claim 1, It is characterized in that After displaying the search results in the form of a chart based on the open source visualization library, the method further includes: Generate a report generation request for the alarm data based on the report acquisition operation of the user in the data management interface; the report generation request carries the search results and indicators to be filled in the report template; Sending the report generation request to the backend, and receiving the report file in the form of file download returned by the backend; The report file is obtained based on the backend acquiring the data of the indicator to be filled in the database and filling the data of the indicator to be filled in into the report template.

6. The speed sensor warning data query method according to claim 1, It is characterized in that After displaying the search results in the form of a chart based on the open source visualization library, the method further includes: Generate a report generation request for the alarm data periodically based on a set period; The report generation request is sent to the backend, and a report file in the form of a file download returned by the backend is received.

7. A speed sensor alarm data query device, It is characterized in that Applied to the front end, the device comprises: A generating module, configured to generate a query request for alarm data based on a query operation of a user in a data management interface; the alarm data includes alarm data of a speed sensor; and the query request carries a query range parameter of the alarm data; A retrieval module is used to send the query request to the backend and receive the retrieval result of the alarm data returned by the backend; the retrieval result is obtained by the backend in the database based on the query range parameter; The display module is used to display the search results in the form of charts based on the open source visualization library.

8. A non-transitory computer-readable storage medium having a computer program stored thereon, It is characterized in that When the computer program is executed by a processor, the speed sensor warning data query method according to any one of claims 1 to 6 is implemented.

9. An electronic device comprising a memory and a processor, It is characterized in that The memory stores a computer program, and the processor is configured to execute the speed sensor warning data query method according to any one of claims 1 to 6 through the computer program.

10. A computer program product comprising a computer program, It is characterized in that When the computer program is executed by a processor, the speed sensor warning data query method according to any one of claims 1 to 6 is implemented.

Images