CN111858596A - Data acquisition method, device, computer equipment and storage medium - Google Patents

Abstract

The present application relates to a data acquisition method, apparatus, computer equipment and storage medium. The method includes: acquiring a first identifier of the first display information in the power grid information display page; querying a preset power grid information mapping table according to the first identifier, and acquiring a plurality of second display information corresponding to the first display information and each first display information. 2. The data query interface corresponding to the display information; the power grid information mapping table records multiple data query interfaces, and each data query interface corresponds to multiple second display information; obtain the second identifier of the target display information, according to the second identifier from each A data query interface corresponding to the target display information is determined in the data query interface corresponding to the second display information; information data of the target display information is obtained through the data query interface. By adopting the method, each power grid information display page can call the data query interface, and there is no need to separately write a corresponding data query interface for the display information of each display page.

Description

Data acquisition method, device, computer equipment and storage medium

technical field

The present application relates to the technical field of power grid data management and control, and in particular, to a data acquisition method, apparatus, computer equipment and storage medium.

Background technique

The power industry data is complex and various. In order to meet the demand for visualization of power grid operation monitoring, more and more enterprises have begun to adopt the method of large-screen construction to conduct 24-hour real-time early warning, monitoring and analysis of various data in the power industry, so as to realize the monitoring and analysis of various types of data in the power industry. Comprehensive management and control of enterprise, marketing and various business fields. Large-screen construction is a high-brightness, high-resolution, and accurate color reproduction TV wall composed of a single set of projection display units. Generally, there are multiple display pages. Each display page can display different information, and different display pages. The display requirements of information are different, so each display page needs to call different data query interfaces.

The data calling method of the traditional display page is: according to the display requirements of different display information in each display page, a corresponding data query interface is written for each display page, and each display page can be obtained by calling its corresponding data query interface. information data, and then display the received information data.

However, in the current data calling method, one or more data query interfaces need to be written for each page, which greatly increases the workload of system development and causes code redundancy.

SUMMARY OF THE INVENTION

Based on this, it is necessary to provide a data acquisition method, device, computer equipment and storage medium for the technical problems of increasing the workload of system development and causing code redundancy in the above data calling method.

A data acquisition method, the method comprising:

Obtain the first identifier of the first display information on the power grid information display page;

Query a preset grid information mapping table according to the first identifier, and obtain a plurality of second presentation information corresponding to the first presentation information and a data query interface corresponding to each second presentation information; wherein, the grid information mapping The table record has multiple data query interfaces, and each data query interface corresponds to multiple second display information;

obtaining a second identifier of the target display information, and determining a data query interface corresponding to the target display information from the data query interfaces corresponding to each of the second display information according to the second identifier;

Through the data query interface, the information data of the target display information is acquired.

In one embodiment, before acquiring the information data of the target display information, the method further includes:

Obtain the data query parameters and attribute identifiers of the target display information;

According to the data query parameter and the attribute identifier, the information data of the target display information is acquired.

In one embodiment, the data query parameter includes a query date; if the data query interface is a monthly query interface;

The obtaining the information data of the target display information according to the data query parameter and the attribute identifier includes:

If the attribute identification of the target display information is monthly display information, the information data within the query date is acquired as the information data of the target display information.

In one embodiment, acquiring the information data of the target display information according to the data query parameter and the attribute identifier further includes:

If the attribute of the target display information is identified as quarterly display information, the query date is matched with a plurality of preset quarterly dates, and when the query date matches any of the quarterly dates, the query date is obtained with all the quarterly dates. The information data corresponding to the quarterly date that matches the query date, as the information data of the target display information;

When the query date does not match each of the quarterly dates, the information data corresponding to the previous quarterly date corresponding to the query date is acquired as the information data of the target display information.

In one embodiment, acquiring the information data of the target display information according to the data query parameter and the attribute identifier further includes:

If the attribute of the target display information is identified as annual display information, the query date is matched with a preset annual date, and when the query date matches the annual date, the data corresponding to the annual date is obtained. Information data, as the information data of the target display information;

When the query date does not match the annual date, the information data corresponding to the previous year date corresponding to the query date is acquired as the information data of the target display information.

In one embodiment, after acquiring the information data of the target display information, the method further includes:

importing the information data into a preset data template corresponding to the data query interface to obtain information data in a set format;

Through the data query interface, the information data in the set format is sent to the front end, so that the front end can render the power grid information display page according to the information data in the set format.

A data acquisition device, the device includes:

a first identification obtaining module, configured to obtain the first identification of the first display information in the power grid information display page;

a display information acquisition module, configured to query a preset grid information mapping table according to the first identifier, and acquire a plurality of second display information corresponding to the first display information and a data query interface corresponding to each second display information; The grid information mapping table records a plurality of data query interfaces, and each data query interface corresponds to a plurality of second display information;

a screening module, configured to obtain a second identifier of the target display information, and determine a data query interface corresponding to the target display information from the data query interfaces corresponding to each of the second display information according to the second identifier;

The information data acquisition module is configured to acquire the information data of the target display information through the data query interface.

A computer device includes a memory and a processor, the memory stores a computer program, and the processor implements the following steps when executing the computer program:

Obtain the first identifier of the first display information on the power grid information display page;

Query a preset grid information mapping table according to the first identifier, and obtain a plurality of second presentation information corresponding to the first presentation information and a data query interface corresponding to each second presentation information; wherein, the grid information mapping The table record has multiple data query interfaces, and each data query interface corresponds to multiple second display information;

obtaining a second identifier of the target display information, and determining a data query interface corresponding to the target display information from the data query interfaces corresponding to each of the second display information according to the second identifier;

Through the data query interface, the information data of the target display information is acquired.

A computer-readable storage medium on which a computer program is stored, and when the computer program is executed by a processor, the following steps are implemented:

Obtain the first identifier of the first display information on the power grid information display page;

Query a preset grid information mapping table according to the first identifier, and obtain a plurality of second presentation information corresponding to the first presentation information and a data query interface corresponding to each second presentation information; wherein, the grid information mapping The table record has multiple data query interfaces, and each data query interface corresponds to multiple second display information;

obtaining a second identifier of the target display information, and determining a data query interface corresponding to the target display information from the data query interfaces corresponding to each of the second display information according to the second identifier;

Through the data query interface, the information data of the target display information is acquired.

The above data acquisition method, device, computer equipment and storage medium, the corresponding relationship between the first display information and the second display information, and the corresponding relationship between the second display information and the data query interface are constructed through the grid information mapping table, so that the grid information is obtained when the grid information is obtained. After displaying the first identifier of the first display information on the page, a plurality of second display information corresponding to the first display information can be acquired according to the first identifier, and a data query interface corresponding to each second display information can be acquired. Further, after obtaining the second identifier of the target display information, determine the data query interface corresponding to the target display information from the data query interfaces corresponding to each second display information according to the second identifier, and finally obtain the target through the data query interface. The information data of the display information, this solution adopts the method of constructing the corresponding relationship between the target display information and the data query interface, which is suitable for any grid information display page. Each grid information display page can call the data query interface, and there is no need for each display. The corresponding data query interface is written for the display information of the page, thereby reducing the workload of system development and solving the technical problems of large development volume and redundant code existing in the traditional method.

Description of drawings

Fig. 1 is the application scene diagram of the data acquisition method in one embodiment;

2 is a schematic flowchart of a data acquisition method in one embodiment;

3 is a schematic flowchart of an information data acquisition step of target display information in one embodiment;

4 is a schematic flowchart of a data acquisition method in an application embodiment;

5 is a schematic page diagram of an indicator management system in one embodiment;

6 is a structural block diagram of a data acquisition device in one embodiment;

FIG. 7 is a diagram of the internal structure of a computer device in one embodiment.

Detailed ways

In order to make the purpose, technical solutions and advantages of the present application more clearly understood, the present application will be described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application, but not to limit the present application.

The data acquisition method provided in this application can be applied to the application environment shown in FIG. 1 . The front end 102 communicates with the server 104 through a network. The display pages of different front ends 102 can display different power grid information, and the server 104 can be implemented by an independent server or a server cluster composed of multiple servers. In the application scenario of the data acquisition method provided by the present application, the server 104 acquires the first identifier of the first displayed information in the power grid information display page of any front end 102; according to the first identifier, the preset power grid information mapping table is queried, and the A plurality of second display information corresponding to the first display information and a data query interface corresponding to each second display information; the grid information mapping table records a plurality of data query interfaces, and each data query interface corresponds to a plurality of target display information; The information mapping table records a plurality of data query interfaces, and each data query interface corresponds to a plurality of second display information; the second identifier of the target display information is obtained, and the second identifier is obtained from the data query interface corresponding to each second display information according to the second identifier. Determine the data query interface corresponding to the target display information; obtain the information data of the target display information through the data query interface, and finally send the information data of the target display information to the front end 102 through the data query interface to send the information data of the target display information to the front end 102 to The front end 102 is caused to render the power grid information display page according to the information data of the target display information.

In one embodiment, as shown in FIG. 2, a data acquisition method is provided, which is described by taking the method applied to the server 104 in FIG. 1 as an example, including the following steps:

Step S202, acquiring the first identifier of the first display information in the power grid information display page.

The first display information may represent information of business modules corresponding to various business scenarios in the power industry. For example, the first display information may include operation overview, enterprise profile, power grid operation, auditing, industry optimization, corporate governance according to law, and customer service. , reliable power supply, safety management and functional power grid construction and other business modules.

The first identifier is an identifier representing the uniqueness of the first display information, which may be a code, an ID or a name of the first display information.

In specific implementation, when the user needs to query or update the information data of the first display information on the display page of any front end 102, the front end 102 can be triggered to generate a data acquisition request for the first display information, and the data acquisition request can be sent to The server 104, at the same time, the front end 102 also uses the first identifier of the first display information as an incoming parameter, and sends it to the server 104 together with the data acquisition request, and the server 104 receives the data acquisition request sent by the front end 102 and the first display information. logo.

Step S204, query the preset grid information mapping table according to the first identifier, and obtain a plurality of second presentation information corresponding to the first presentation information and a data query interface corresponding to each second presentation information; the grid information mapping table records multiple Data query interfaces, each of which corresponds to a plurality of second display information.

The power grid information mapping table records the correspondence between the first display information and the second display information and the correspondence between the second display information and the data query interface.

Wherein, the second display information may represent information of various management and control indicators corresponding to the first display information. For example, if the first display information is a power grid operation business module, the second display information may be indicators such as the unified load and the western power load. information, if the first display information is the reliable power supply service module, the second display information may be information on indicators such as the comprehensive voltage qualification rate and the comprehensive voltage qualification rate of urban residents.

The data query interface refers to an interface for outputting data to the data connection line when the front end 102 and the server 104 transmit data, including a real-time query interface, a daily query interface, and a monthly query interface.

In a specific implementation, after acquiring the first identifier of the first display information, the server 104 may query the preset grid information mapping table according to the first identifier of the first display information, and then according to the first display information recorded in the grid information mapping table The corresponding relationship with the second display information and the corresponding relationship between the second display information and the data query interface, a plurality of second display information corresponding to the first display information and a data query interface corresponding to each second display information are obtained.

Step S206: Acquire a second identifier of the target display information, and determine a data query interface corresponding to the target display information from the data query interfaces corresponding to each second display information according to the second identifier.

The second identifier is an identifier representing the uniqueness of the target display information, for example, the second identifier may be the information name, information code, or information ID of the target display information.

In a specific implementation, the incoming parameters also include the second identifier of the target display information. After acquiring the second identifier of the target display information passed in by the front end 102, the server 104 can query the data corresponding to each second display information according to the second identifier. A data query interface corresponding to the target display information is determined in the interface.

In step S208, the information data of the target display information is acquired through the data query interface.

In a specific implementation, after obtaining the data query interface of the target display information, the server 104 can obtain the information data of the target display information from the database corresponding to the target display information through the data query interface. The acquired information data of the target display information is sent to the front end 102 through the data query interface, so that the front end 102 renders the power grid information display page according to the information data of the target display information.

In the above data acquisition method, the corresponding relationship between the first display information and the second display information, and the corresponding relationship between the second display information and the data query interface are constructed through the grid information mapping table, so that the first display information is obtained in the grid information display page. After the first identifier is obtained, a plurality of second display information corresponding to the first display information can be acquired according to the first identifier, and a data query interface corresponding to each second display information can be acquired. Further, after obtaining the second identifier of the target display information, determine the data query interface corresponding to the target display information from the data query interfaces corresponding to each second display information according to the second identifier, and finally obtain the target through the data query interface. The information data of the displayed information adopts the method of constructing the corresponding relationship between the target display information and the data query interface, so that this solution is suitable for any grid information display page. Each grid information display page can call the data query interface, realizing the data query interface. The flexible invocation of the system eliminates the need to write a corresponding data query interface for the display information of each display page, reduces the workload of system development, and solves the problem that a single page calls multiple data query interfaces to query data, which affects the performance of the system and database, resulting in The system data update is stuck, and the data cannot be displayed in time. In addition, adopting this method does not need to adjust all the interfaces one by one when maintaining the interfaces in the later stage, which overcomes the problem that the subsequent system maintenance workload is relatively large.

In one embodiment, as shown in FIG. 3, before the above step S208, the method further includes:

Step S302, obtaining data query parameters and attribute identifiers of the target display information;

Step S304: Acquire information data of the target display information according to the data query parameter and the attribute identifier.

Wherein, the data query parameter represents the information data filter condition parameter of the query, for example, the query date.

The attribute identifier represents the update identifier of the target display information on the grid information display page, which can be determined in advance according to the display requirements of each second display information, and a corresponding relationship between the attribute identifier and each second display information can be established. The attribute identifier may be real-time display information (for example, hourly or every minute, etc.), daily display information, monthly display information, quarterly display information, and annual display information. For example, when the target display information is the unified regulation load and the western power load, and the unified regulation load and the western power load need to be updated daily, the target display information can be identified as the daily display information.

In a specific implementation, the incoming parameters also include data query parameters of the target display information. The server 104 may first determine the database corresponding to the target display information and the attribute identifier of the target display information according to the second identifier of the target display information, and further according to the target display information The information data of the target display information is obtained from the database corresponding to the target display information.

In this embodiment, by obtaining the data query parameters and attribute identifiers of the target display information, the information data of the target display information is obtained from the database corresponding to the target display information, so as to further use the information data of the target display information to render the power grid information page, so that Maintenance personnel can monitor the operation of the grid in real time.

Further, in one embodiment, the above-mentioned data query parameters include a query date; the above-mentioned step S304 further includes:

When the data query interface corresponding to the target display information is a real-time query interface, the attribute corresponding to the target display information is identified as real-time display information, and all information data of the target display information before the query date is obtained as the information data of the target display information.

When the data query interface corresponding to the target display information is a daily query interface, the attribute corresponding to the target display information is identified as daily display information, and the latest recorded information data of the target display information on the query date is obtained as the information of the target display information data.

When the data query interface corresponding to the target display information is a monthly query interface, the attribute identifiers corresponding to the target display information may be monthly display information, quarterly display information and annual display information, and the above step S304 further includes:

If the attribute identifier of the target display information is monthly display information, the information data corresponding to the query date is obtained as the information data of the target display information.

Specifically, the monthly display information, quarterly display information and annual display information all call the monthly query interface to obtain information data, wherein the monthly display information obtains the information data of the current month, for example, if the query date is March 2019, then obtain the information data of March 2019 information data.

In one embodiment, if the attribute of the target display information is identified as quarterly display information, the query date is matched with a plurality of preset quarterly dates, and when the query date matches any quarterly date, the query date is obtained. The information data corresponding to the matching quarterly date is used as the information data of the target display information; when the query date does not match the dates of each quarter, the information data corresponding to the previous quarter date corresponding to the query date is obtained as the information of the target display information data.

The quarter date may be the last month of each quarter, for example, the quarter date may be March of a certain year, June of a certain year, September of a certain year, and December of a certain year. Among them, when the quarterly date is March of a certain year, obtain the information data in the first quarter of the year (ie, January to March); when the quarterly date is June of a certain year, obtain the second quarter of the year (ie, 4 information data within the month to June); when the quarter date is September of a certain year, obtain the information data in the third quarter of the year (ie, July to September); when the quarter date is December of a certain year, obtain the information data Information data for the fourth quarter of the year (i.e. October to December).

Specifically, if the target display information is quarterly display information, the query date is matched with each quarterly date, and the information data of the corresponding time is obtained according to the matching result. When the query date matches any quarterly date, the query date is obtained. The information data corresponding to the quarterly date that matches the date is used as the information data of the target display information. For example, if the query date is March 2019 and matches the quarterly date of the first quarter of 2019, the period from January to March 2019 will be obtained. The information data of the month, as the information data of the target display information. Conversely, when the query date does not match the dates of each quarter, the current quarter date corresponding to the query date can be determined first, then the date of the previous quarter of the current quarter date can be determined, and finally the information data corresponding to the date of the previous quarter can be obtained as the target. The information data of the displayed information. For example, if the query date is July 2019 and does not match the dates of each quarter, first determine the date of the current quarter corresponding to the query date is September 2019, and further determine the previous quarter corresponding to the query date. If the date is June 2019, the information data corresponding to the quarterly date of June 2019 is obtained, that is, the information data of the target display information from April to June 2019 is obtained as the information data of the target display information.

In one embodiment, if the attribute of the target display information is identified as annual display information, the query date is matched with the preset annual date, and when the query date matches the annual date, the information data corresponding to the annual date is obtained as The information data of the target display information; when the query date does not match the annual date, the information data corresponding to the previous year date corresponding to the query date is obtained as the information data of the target display information.

Among them, the annual date can be the last month of each year, that is, December of a certain year. When the query date is an annual date, the information data from January to December of the year in which the query date is located is obtained.

Specifically, if the target display information is annual display information, the query date is matched with the annual date, and the information data of the corresponding time is obtained according to the matching result, that is, when the query date matches the annual date, the corresponding date of the year is obtained. For example, if the query date is December 2019 and matches the annual date, the information data from January to December 2019 will be obtained as the information data of the target display information. Conversely, when the query date does not match the annual date, the information data corresponding to the date of the previous year of the year in which the query date is located is obtained. The corresponding annual date is December 2019, and the date of the previous year is further determined to be December 2018, so as to obtain the information data with the annual date from January to December 2018, as the information data of the target display information.

In the above embodiment, by determining the correspondence between the various attribute identifiers of the target display information and the information data to be acquired by the various attribute identifiers, it is convenient to quickly determine the required acquisition after acquiring the attribute identifiers of the target display information. information data, reducing the interaction time between the front end and the server.

In one embodiment, after step S208, the method further includes: importing the information data into a preset data template corresponding to the data query interface to obtain information data in a set format; The data is sent to the front end for the front end to render the grid information display page according to the information data in the set format.

In the specific implementation, each type of data query interface is preset with a corresponding data template. After obtaining the information data of the target display information, the server 104 can import the information data of the target display information into the data query interface corresponding to the target display information. In the data template, information data such as "key-value" format is generated. For example, if the target display information is the average power outage time, and the corresponding data query interface is the real-time query interface and the monthly query interface, the target information code + type format is returned. Data: KK02000Month-return data, KK02000Time-return data, and finally return the formatted information data to the front end through the data query interface corresponding to the target display information, so that the front end can perform the grid information display page according to the information data in the set format. render. It is also possible to return the formatted information data to a data block for the front-end to call uniformly.

In this embodiment, by setting a corresponding data template for each type of data query interface, a unified data format can be set, so as to reduce the time for front-end developers to process the format of the returned information data, improve development efficiency, and thus overcome different When the data format returned by the data query interface is inconsistent, it is a technical problem that increases the workload of the front-end.

In order to clarify the technical solution provided by the embodiments of the present application, the solution will be described below with reference to FIG. 4 , which is a schematic flowchart of a data acquisition method in an application example. The specific process of the method is as follows:

1. Customize the data transmission mechanism of each business scenario page. Since the second display information corresponding to different display pages is different, the display requirements of the second display information are also different. Therefore, according to the display requirements of the system business, each indicator under the page of different business scenarios (that is, the second display page) is customized on the front-end display page. Information) data transmission mechanism, the display page can refresh the displayed indicator data according to the transmission mechanism. For example, in the business scenario of power grid operation, the unified data distribution function can be set to call the unified data distribution function every day or every 15 minutes, and the display page is refreshed every 15 minutes or every day. In the reliable power supply business scenario, monthly indicators such as the comprehensive voltage qualification rate and the comprehensive voltage qualification rate of urban residents can be set to call the unified data distribution function once a month, query the data once, and refresh the display page once a month.

2. Set custom interface. The data query interface can be divided into three types: monthly query interface, daily query interface, and real-time query interface. Among them, the real-time query interface is used to update indicators in real time (ie, display information in real time). The daily query interface is used to call the daily update indicator (that is, the daily display information). The monthly query interface is used to call the monthly update indicator (that is, the monthly display information), the quarterly update indicator (that is, the quarterly display information) and the annual update indicator (that is, the annual display information). The data query interface matches the information data of the corresponding reporting method in the database according to the reporting method of the corresponding indicator (such as manual filling and system direct mining, etc.) ) and plan value types (such as monthly plan and annual plan) match the corresponding types of information data in the corresponding result table and plan value table in the database, respectively.

3. Establish a large-screen indicator management system. According to various business scenarios on the large screen, create new business modules on the large screen in the basic indicator information table (see Table 1 below): operation overview, enterprise profile, power grid operation, auditing, industry optimization, corporate governance by law, customer service, reliable power supply, For safety management and functional power grid construction, these modules are classified as indicator classification modules (indicator_type: 1), that is, the first display information. Then configure the basic information of the indicators to be displayed on the large screen, and classify these indicators as indicators or indicator subdivisions (indicator_type: 1/2), that is, the second display information. Bind all business modules through the indicator configuration table (see Table 2 below) under the general large-screen module, and bind the indicators that the business module needs to display under each business module. Displaying requirements configure the data query interface that the indicator needs to call, and realize the establishment of the indicator management system on the large screen. As shown in Figure 5, in order to establish the page diagram of the indicator management system, the large screen includes the above business modules, each business module corresponds to multiple indicators, and under the indicators of the corresponding module, the data query interface for calling can be set, for example , in the business scenario of power grid operation, bind the real-time indicators such as the unified load and western power load to the indicator system. After the binding is completed, find the real-time indicator from the grid operation module of the indicator system, and bind the real-time indicator corresponding to the The real-time query interface that needs to be called. In the reliable power supply business scenario, bind the monthly indicators such as the comprehensive voltage qualification rate and the comprehensive voltage qualification rate of urban residents. After the binding is completed, find the monthly indicators under the reliable power supply module of the indicator system, and bind the monthly indicators corresponding to the month that needs to be called. query interface. In the reliable power supply business scenario, the indicator of the user's average power outage time can also be bound. This indicator needs to display real-time data and monthly data. Therefore, after finding this indicator from the reliable power supply module of the indicator system, you can bind the real-time query interface and Monthly query interface.

As shown in Table 1 below, it is an indicator basic information table, including indicator definition primary key, indicator code, indicator name, completion value reporting period, completion value data source, indicator type and other indicator information.

Table 1

As shown in Table 2 below, it is an indicator configuration table, which can configure the ID of the indicator, the corresponding parent indicator ID (that is, the ID of the business module corresponding to the indicator), and the data query interface corresponding to the indicator. There may be one or more data query interfaces corresponding to each indicator.

Table 2

4. Query data according to the index attributes of the index system. When querying indicator data, the front end passes in the code of the business module to be queried through the data query interface, and transmits data query parameters such as the indicator code array, organization array, month array, and year array corresponding to the data query interface, and calls the unified data distribution function. The distribution function will first query all indicators or indicator subdivisions (i.e. the second presentation information) and each indicator or indicator subdivision under the corresponding business module according to the incoming business module code (that is, the first identifier of the first display information). The data query interface corresponding to the item, and then filter out the corresponding target indicator (that is, the target display information) that needs to be queried according to the incoming indicator encoding array (that is, the second identifier of the target display information), and the data query interface corresponding to the target indicator (that is, the target display information). The data query interface corresponding to the target display information), match the target indicator to the data query interface corresponding to the target indicator, and finally obtain and data according to other incoming parameters, such as organization array, month array and year array (that is, data query parameters). Information data corresponding to the query parameter.

As shown in Table 3 below, it is the incoming parameter table corresponding to the daily query interface, including parameter name/field, parameter description, whether the parameter is required, and the data type corresponding to each incoming parameter. The incoming parameter includes the organization code, Sort method (specify incoming string), indicator encoding and implement indicator incoming time format. For example, the parameter name is orgMrids, that is, the incoming parameter of the organization code is an optional parameter, and its corresponding data type is array.

As shown in Table 4 below, it is the return data table of the daily query interface, including the name/field of the return parameter, the description of the return parameter, and the data type corresponding to each return parameter. , for example, the return parameter name is jhzxpcl, that is, the data type corresponding to the return parameter of the planned execution deviation rate is string.

table 3

Table 4

As shown in Table 5 below, it is the incoming parameter table of the real-time query interface, including parameter name, parameter description, whether the parameter is required, and the data type corresponding to each incoming parameter. Incoming string), indicator encoding and implementing indicator incoming time format. For example, the parameter name is orgMrids, that is, the incoming parameter of the organization code is a parameter that must be passed in, and its corresponding data type is array.

table 5

The returned data table of the real-time query interface is the same as the returned data table of the daily query interface, and details are not repeated here.

As shown in Table 6 below, it is the incoming parameter table of the monthly query interface, including the parameter name/field, parameter description, whether the parameter is required, and the data type corresponding to each incoming parameter. Select the query month range, the sorting method (specify the incoming string), the organization code range, the selected query year range and the query status. For example, the parameter name is indicatorCodes, that is, the incoming parameter of the indicator coding interval is a parameter that must be passed in, and its corresponding data type is array.

Table 6

Among them, the returned data table of the monthly query interface, in addition to the content in the returned data table of the above daily query interface, also includes the content shown in Table 7 below, that is, it also includes the current value, the current period year-on-year and the current period year-on-year color. Incoming parameters, and the data types corresponding to the three incoming parameters.

Table 7

parameter name/field illustrate type dqIndicatorValue current value string dqTb year-on-year string dqTbColor Current YoY Color string

5. Generate data according to the set data template. According to the established data templates of different data query interfaces, the obtained information data is assembled into business data in various formats, such as a single data object, data list, etc., and then the data block is returned in the form of key-value, such as the average power outage time of customers. The real-time query interface and monthly query interface return the code + type: KK02000Month-returns data, data and KK02000Time-returns data for the front-end unified call.

The data acquisition method provided in this embodiment simplifies the development method of the large-screen system and reduces the workload of system maintenance by customizing the data transmission method and returning the data uniformly, so that business personnel can quickly acquire the required display according to requirements. Data, and returning to a unified data format can make front-end developers more handy in processing returned data, thereby speeding up the version iteration of the large-screen system and enabling faster expansion and changes of the corresponding business. Using this method, the returned data can be customized according to business requirements, and the required data can be flexibly queried. Different from the fixed business interface, it is not restricted to a single business module, and each business module can be flexibly called to meet complex business requirements.

It should be understood that although the steps in the flowcharts of FIGS. 2-4 are shown in sequence according to the arrows, these steps are not necessarily executed in the sequence shown by the arrows. Unless explicitly stated herein, the execution of these steps is not strictly limited to the order, and the steps may be executed in other orders. Moreover, at least a part of the steps in FIGS. 2-4 may include multiple sub-steps or multiple stages. These sub-steps or stages are not necessarily executed at the same time, but may be executed at different times. These sub-steps or stages are not necessarily completed at the same time. The order of execution of the steps is not necessarily sequential, but may be performed alternately or alternately with other steps or at least part of sub-steps or stages of other steps.

In one embodiment, as shown in FIG. 6, a data acquisition device is provided, including: a first identification acquisition module 602, a display information acquisition module 604, a screening module 606 and an information data acquisition module 608, wherein:

The first identification obtaining module 602 is used for obtaining the first identification of the first display information in the power grid information display page;

The display information acquisition module 604 is configured to query a preset grid information mapping table according to the first identifier, and acquire a plurality of second display information corresponding to the first display information and a data query interface for each second display information; the grid information mapping table The record has multiple data query interfaces, and each data query interface corresponds to multiple second display information;

A screening module 606, configured to obtain a second identifier of the target display information, and determine a data query interface corresponding to the target display information from the data query interfaces corresponding to each second display information according to the second identifier;

The information data acquisition module 608 is configured to acquire the information data of the target display information through the data query interface.

In one embodiment, the above-mentioned apparatus further includes a parameter and identifier acquisition module for acquiring data query parameters and attribute identifiers of the target display information; the above-mentioned information data acquisition module 608 is further configured to acquire the target display parameters and attribute identifiers according to the data query parameters and attribute identifiers. Information data that displays information.

In one embodiment, the data query parameter includes a query date; if the data query interface is a monthly query interface; the above-mentioned information data acquisition module 608 is further configured to obtain the information within the query date if the attribute identifier of the target display information is monthly display information. Information data, which is the information data for displaying information as a target.

In one embodiment, the above-mentioned information data acquisition module 608 is further configured to match the query date with a plurality of preset quarterly dates if the attribute of the target display information is identified as quarterly display information. When the date matches, the information data corresponding to the quarterly date that matches the query date is obtained as the information data of the target display information; when the query date does not match the dates of each quarter, the corresponding date of the previous quarter corresponding to the query date is obtained. The information data, as the information data of the target display information.

In one embodiment, the above-mentioned information data acquisition module 608 is further configured to match the query date with the preset annual date if the attribute of the target display information is identified as annual display information, and when the query date matches the annual date, then The information data corresponding to the annual date is obtained as the information data of the target display information; when the query date does not match the annual date, the information data corresponding to the previous year date corresponding to the query date is obtained as the information data of the target display information.

In one embodiment, the above-mentioned apparatus further comprises:

The data import module is used to import the information data into the preset data template corresponding to the data query interface, and obtain the information data in the set format;

The data sending module sends the information data in the set format to the front end through the data query interface, so that the front end can render the grid information display page according to the information data in the set format.

It should be noted that the data acquisition device of the present application corresponds to the data acquisition method of the present application one by one, and the technical features and beneficial effects described in the embodiments of the above data acquisition method are applicable to the embodiments of the data acquisition device. For the content, please refer to the description in the method embodiment of the present application, which will not be repeated here, but is hereby declared.

In addition, each module in the above-mentioned data acquisition device may be implemented in whole or in part by software, hardware, or a combination thereof. The above modules can be embedded in or independent of the processor in the computer device in the form of hardware, or stored in the memory in the computer device in the form of software, so that the processor can call and execute the operations corresponding to the above modules.

In one embodiment, a computer device is provided, and the computer device may be a server, and its internal structure diagram may be as shown in FIG. 7 . The computer device includes a processor, memory, and a network interface connected by a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium, an internal memory. The nonvolatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the execution of the operating system and computer programs in the non-volatile storage medium. The database of the computer device is used to store the data generated by the data acquisition process. The network interface of the computer device is used to communicate with an external terminal through a network connection. The computer program, when executed by a processor, implements a data acquisition method.

Those skilled in the art can understand that the structure shown in FIG. 7 is only a block diagram of a partial structure related to the solution of the present application, and does not constitute a limitation on the computer equipment to which the solution of the present application is applied. Include more or fewer components than shown in the figures, or combine certain components, or have a different arrangement of components.

In one embodiment, a computer device is also provided, including a memory and a processor, where a computer program is stored in the memory, and the processor implements the steps in the foregoing method embodiments when the processor executes the computer program.

In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored, and when the computer program is executed by a processor, implements the steps in the foregoing method embodiments.

Those of ordinary skill in the art can understand that all or part of the processes in the methods of the above embodiments can be implemented by instructing relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium , when the computer program is executed, it may include the processes of the above-mentioned method embodiments. Wherein, any reference to memory, storage, database or other media used in the various embodiments provided in this application may include at least one of non-volatile and volatile memory. Non-volatile memory may include read-only memory (Read-Only Memory, ROM), magnetic tape, floppy disk, flash memory, or optical memory, and the like. Volatile memory may include random access memory (RAM) or external cache memory. By way of illustration and not limitation, the RAM may be in various forms, such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM).

The technical features of the above embodiments can be combined arbitrarily. For the sake of brevity, all possible combinations of the technical features in the above embodiments are not described. However, as long as there is no contradiction in the combination of these technical features, all It is considered to be the range described in this specification.

The above examples only represent several embodiments of the present application, and the descriptions thereof are relatively specific and detailed, but should not be construed as a limitation on the scope of the invention patent. It should be pointed out that for those skilled in the art, without departing from the concept of the present application, several modifications and improvements can be made, which all belong to the protection scope of the present application. Therefore, the scope of protection of the patent of the present application shall be subject to the appended claims.

Claims (10)

1. A method for data acquisition, the method comprising:

acquiring a first identifier of first display information in a power grid information display page;

inquiring a preset power grid information mapping table according to the first identifier, and acquiring a plurality of pieces of second display information corresponding to the first display information and data inquiry interfaces corresponding to the second display information; the power grid information mapping table records a plurality of data query interfaces, and each data query interface corresponds to a plurality of second display information;

Acquiring second identifiers of target display information, and determining data query interfaces corresponding to the target display information from data query interfaces corresponding to each second display information according to the second identifiers;

and acquiring the information data of the target display information through the data query interface.

2. The method according to claim 1, further comprising, before obtaining the information data of the target presentation information:

acquiring data query parameters and attribute identification of the target display information;

and acquiring the information data of the target display information according to the data query parameters and the attribute identification.

3. The method of claim 2, wherein the data query parameters include a query date; if the data query interface is a monthly query interface;

the acquiring information data of the target display information according to the data query parameter and the attribute identifier includes:

and if the attribute identification of the target display information is monthly display information, acquiring information data in the query date as the information data of the target display information.

4. The method according to claim 3, wherein the obtaining information data of the target display information according to the data query parameter and the attribute identifier further comprises:

If the attribute identification of the target display information is quarterly display information, matching the query date with a plurality of preset quarterly dates, and acquiring information data corresponding to the quarterly date matched with the query date as the information data of the target display information when the query date is matched with any one of the quarterly dates;

and when the query date is not matched with each quarter date, acquiring information data corresponding to a previous quarter date corresponding to the query date as the information data of the target display information.

5. The method according to claim 3, wherein the obtaining information data of the target display information according to the data query parameter and the attribute identifier further comprises:

if the attribute identifier of the target display information is annual display information, matching the query date with a preset annual date, and when the query date is matched with the annual date, acquiring information data corresponding to the annual date as the information data of the target display information;

and when the query date is not matched with the annual date, acquiring information data corresponding to the previous annual date corresponding to the query date as the information data of the target display information.

6. The method according to claim 1, further comprising, after obtaining the information data of the target presentation information:

importing the information data into a preset data template corresponding to the data query interface to obtain information data in a set format;

and sending the information data in the set format to a front end through the data query interface so that the front end can render the power grid information display page according to the information data in the set format.

7. A data acquisition apparatus, characterized in that the apparatus comprises:

the first identifier acquisition module is used for acquiring a first identifier of first display information in the power grid information display page;

the display information acquisition module is used for inquiring a preset power grid information mapping table according to the first identifier, and acquiring a plurality of pieces of second display information corresponding to the first display information and data inquiry interfaces corresponding to the second display information; the power grid information mapping table records a plurality of data query interfaces, and each data query interface corresponds to a plurality of second display information;

the screening module is used for acquiring second identifiers of the target display information and determining data query interfaces corresponding to the target display information from the data query interfaces corresponding to the second display information according to the second identifiers;

And the information data acquisition module is used for acquiring the information data of the target display information through the data query interface.

8. The apparatus according to claim 7, further comprising a parameter and identifier obtaining module, configured to obtain a data query parameter and an attribute identifier of the target display information; the information data acquisition module is further configured to acquire the information data of the target display information according to the data query parameter and the attribute identifier.

9. A computer device comprising a memory and a processor, the memory storing a computer program, wherein the processor implements the steps of the method of any one of claims 1 to 6 when executing the computer program.

10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 6.

Images