CN115061721A

CN115061721A - Report generation method and device, computer equipment and storage medium

Info

Publication number: CN115061721A
Application number: CN202210817089.5A
Authority: CN
Inventors: 潘登登
Original assignee: Ping An Technology Shenzhen Co Ltd
Current assignee: Ping An Technology Shenzhen Co Ltd
Priority date: 2022-07-12
Filing date: 2022-07-12
Publication date: 2022-09-16

Abstract

The invention is applicable to the technical field of data processing, provides a report generation method, a report generation device, computer equipment and a storage medium, the method obtains the field information collected in the collection item corresponding to the field to be configured by obtaining the layout information and the field to be configured of each display item in the report to be generated, converts the field information into the query statement, extracting a data source corresponding to the field information from the database according to the query statement, acquiring corresponding target data, sending the target data to corresponding display items, laying out and rendering all the display items, and determining a report, business personnel only need to configure the report to be generated, developers do not need to continuously modify codes according to requirements, dependency on the developers is reduced, flexibility of report generation is improved, and therefore efficiency of report generation is improved.

Description

Report generation method and device, computer equipment and storage medium

Technical Field

The invention relates to the field of artificial intelligence, in particular to a report generation method and device, computer equipment and a storage medium.

Background

In the informatization process, more and more enterprises are applied, the business data volume of various businesses is increased, the enterprise data is generated into business reports, and the business analysis and business control are carried out, so that the effective application of the enterprise data can be realized.

In the prior art, when different business systems generate reports, different data are queried according to interfaces of corresponding systems, then Excel files are generated according to a rendering module, and the Excel files are sent to corresponding front ends for display, development of each report generation needs at least one developer to participate in the whole process, when the reports generated by different business systems need to be modified and maintained, or when reports of new business systems need to be generated, corresponding data query conditions, query interfaces, templates and logic for generating the Excel need to be newly added by a back end, and the developer needs to write a specific back end interface aiming at each report export type, so that the developer is excessively depended on in the report generation process, the report generation efficiency is low, and how to improve the report generation efficiency becomes an urgent problem to be solved.

Disclosure of Invention

Therefore, it is necessary to provide a report generation method, apparatus, computer device and storage medium to solve the problem of low efficiency of report generation.

In a first aspect, a report generating method is provided, where the method includes:

acquiring layout information and fields to be configured of each display item in a report to be generated;

generating and displaying an acquisition item corresponding to the field to be configured based on the acquisition script of the report to be generated, acquiring field information acquired in the acquisition item, and acquiring an inquiry statement corresponding to the acquisition item according to an inquiry code of the field to be configured and the field information;

extracting a data source corresponding to the field information from a database according to the query statement, triggering an interface to connect with the data source, and acquiring corresponding target data;

sending the target data to a corresponding display item according to the layout information and a preset rendering

And the rule is used for laying out and rendering all the display items and determining the result after laying out and rendering as the report.

In a second aspect, a report generating apparatus is provided, the apparatus including:

the acquisition module is used for acquiring the layout information and the fields to be configured of each display item in the report to be generated;

the query statement conversion module is used for generating and displaying a collection item corresponding to the field to be configured based on the collection script of the report to be generated, acquiring field information collected in the collection item, and acquiring a query statement corresponding to the collection item according to a query code of the field to be configured and the field information;

the target data acquisition module is used for extracting a data source corresponding to the field information from a database according to the query statement, triggering an interface to connect with the data source and acquiring corresponding target data;

a report generation module used for sending the target data to the corresponding display item and rendering according to the layout information and the preset rendering

In a third aspect, an embodiment of the present invention provides a computer device, where the computer device includes a processor, a memory, and a computer program stored in the memory and executable on the processor, and the processor, when executing the computer program, implements the report generation method according to the first aspect.

In a fourth aspect, an embodiment of the present invention provides a computer-readable storage medium, where a computer program is stored, and when the computer program is executed by a processor, the computer program implements the report generating method according to the first aspect.

Compared with the prior art, the invention has the following beneficial effects:

acquiring layout information and a field to be configured of each display item in a report to be generated, generating and displaying an acquisition item corresponding to the field to be configured, acquiring field information acquired in the acquisition item, converting the field information into a query statement by using a query code of the field to be configured corresponding to the acquisition item, extracting a data source corresponding to the field information from a database according to the query statement, triggering an interface to connect with the data source, acquiring corresponding target data, sending the target data to the corresponding display item, performing layout and rendering on all the display items according to the layout information and a preset rendering rule, determining the result after the layout and rendering as the report, acquiring the field information of the acquisition item in the field to be configured by configuration according to the acquired layout information and the field to be configured of the report to be generated, acquiring the report data source based on the field information, the report is generated, business personnel only need to configure the report to be generated, developers do not need to continuously modify codes according to requirements, dependency on the developers is reduced, flexibility of report generation is improved, and accordingly efficiency of report generation is improved.

Drawings

In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the description of the embodiments of the present invention will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art that other drawings can be obtained according to these drawings without inventive labor.

Fig. 1 is a schematic diagram of an application environment of a report generation method according to an embodiment of the present invention;

fig. 2 is a flowchart illustrating a report generating method according to an embodiment of the present invention;

fig. 3 is a schematic structural diagram of a report generating apparatus according to an embodiment of the present invention;

fig. 4 is a schematic structural diagram of a computer device according to an embodiment of the present invention.

Detailed Description

The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.

It should be understood that the terms "comprises" and/or "comprising," when used in this specification and the appended claims, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.

It should also be understood that the term "and/or" as used in this specification and the appended claims refers to and includes any and all possible combinations of one or more of the associated listed items.

As used in this specification and the appended claims, the term "if" may be interpreted contextually as "when", "upon" or "in response to" determining "or" in response to detecting ". Similarly, the phrase "if it is determined" or "if a [ described condition or event ] is detected" may be interpreted contextually to mean "upon determining" or "in response to determining" or "upon detecting [ described condition or event ]" or "in response to detecting [ described condition or event ]".

Furthermore, in the description of the present invention and the appended claims, the terms "first," "second," "third," and the like are used for distinguishing between descriptions and not necessarily for describing or implying relative importance.

Reference throughout this specification to "one embodiment" or "some embodiments," or the like, means that a particular feature, structure, or characteristic described in connection with the embodiment is included in one or more embodiments of the present invention. Thus, appearances of the phrases "in one embodiment," "in some embodiments," "in other embodiments," or the like, in various places throughout this specification are not necessarily all referring to the same embodiment, but rather "one or more but not all embodiments" unless specifically stated otherwise. The terms "comprising," "including," "having," and variations thereof mean "including, but not limited to," unless expressly specified otherwise.

It should be understood that, the sequence numbers of the steps in the following embodiments do not imply an execution sequence, and the execution sequence of each process should be determined by its function and inherent logic, and should not constitute any limitation to the implementation process of the embodiments of the present invention.

In order to explain the technical means of the present invention, the following description will be given by way of specific examples.

The report generation method provided by an embodiment of the present invention can be applied to the application environment shown in fig. 1, in which a client communicates with a server. The client includes, but is not limited to, a palm top computer, a desktop computer, a notebook computer, an ultra-mobile personal computer (UMPC), a netbook, a Personal Digital Assistant (PDA), and other computer devices. The server can be implemented by an independent server or a server cluster composed of a plurality of servers.

Referring to fig. 2, which is a schematic flow chart of a report generation method according to an embodiment of the present invention, the report generation method may be applied to the server in fig. 1, where the server is connected to a corresponding client to provide a model training service for the client. As shown in fig. 2, the report generation method may include the following steps.

S201: and acquiring the layout information and the field to be configured of each display item in the report to be generated.

In step S201, the report to be generated is a report that needs to be generated by the corresponding business system, the layout information is a display style of the report, and the field to be configured is each item of data that needs to be displayed by the report, that is, the content that needs to be included in the report to be configured, for example, a data source of the data in the report, start and stop time of the data in the report, field information in the data table that needs to be included in each report, a display form of the report, and the like.

In this embodiment, a report configuration interface is set in the configuration system, and a selection control for a business worker to select a data table can be set in the report configuration interface, that is, the business worker can select a data table in a required database in the report configuration interface. The database may be a MySQL database or other structured query language based database. Each field in the data table structure in the database may be a field that may be required by a service person obtained by analyzing a service chain by a developer, and the fields required by different service scenarios are different. The field component to be configured can also display field deleting and adding controls for business personnel to select corresponding fields in the field component to be configured; the configuration system deletes a field and a configuration item of the field in the component to be configured according to the triggering operation of a business person on a deletion control of a certain displayed field, and adds a row of fields and a configuration item of the field in the component to be configured according to the triggering operation of the business person on an addition control. The field entry to be configured may include information such as the table display, the presentation name, the parent header, the field type, etc.

It should be noted that "table display" is used to indicate whether the field to be configured needs to be shown in the report. The display name is used for being displayed as a header in the report, the parent header is an upper level of the display name, the field type is used for configuring the type of the field, and business personnel can directly configure required information on a report configuration interface, so that the flexibility of configuring the report by the business personnel is improved, and the difficulty of developing a table structure by developers is reduced.

The layout information of the report to be generated is the display style of the report, the position information of each display item in the report, the proportion of each display item in the report, or the position of lines and columns in each display item. The display item refers to an item to be displayed in a report to be generated, the type of the item can be a table, a chart and the like, the type of the style information of the display item can include a font type, a background color, an indentation, a column width, a line height, a font color, a font size, a blank space before and after text removal, a percentage display and the like, in a specific application scenario, each type of the style information of the display item can be represented by a specific number, a specific numerical value of each type can also be represented by a specific number, for example, the font type can be represented by 1, and the style information of the display item can be conveniently identified by means of the number.

Specifically, in order to identify the field to be configured of the presentation item, a data format of the field to be configured of the presentation item may be defined, for example, the presentation item configuration information may be defined according to a format of a presentation item type and a type value, (1, 11) indicates that a font type of the presentation item is bold, and the like, and for the presentation item with a numerical value, the field to be configured of the presentation item may be defined according to a format of the presentation item type, the type value, and the numerical value.

It should be noted that, when the report data to be generated is data in a single data table, the data in the corresponding data table may be directly displayed, and when the report data to be generated is multiple data and a mathematical relationship exists among the multiple data, the layout information of the report to be generated may be displayed by means of the mathematical relationship, and the result data of the data relationship may be written into the result display item. Therefore, when the result display item information is subsequently changed, only part of data in the multiple data tables can be changed, or only the mathematical relationship is changed, and the like, when the result display item is obtained, initial display data in the multiple display items can be obtained, a display data calculation formula among the display items is obtained, the result display item data is determined based on the initial display data and the display data calculation formula, and the initial display data is displayed in the result display item obtained according to the display item calculation formula. For example, the initial presentation data is 2, 3, the result presentation item data is 6, the mathematical calculation formula between the initial presentation data and the result presentation item data is 2 × 3 — 6, the presentation item identifiers of the initial presentation data are 1 and 2, respectively, the presentation item identifier of the result presentation data is 3, and then the presentation item calculation formula between the presentation items identified as 1, 2, and 3 is [3] × [1] [2], that is, the presentation data identified as 3 is the product of the presentation data identified as 1 and 2.

It should be noted that, in the layout information of the report to be generated, the report to be generated may be set to a mode in which part of the displayed items are visible to users and part of the displayed items are invisible to users, or part of the data in the report to be generated may be set to be invisible and part of the data is visible, that is, the user needs to configure the permissions of the displayed items in the report, and obtain the corresponding permission information in the configuration file.

Optionally, the obtaining layout information and a field to be configured of each display item in the report to be generated includes:

according to the received request information generated by the report, searching a report template matched with the request information in a preset report template database to obtain a report to be generated;

and acquiring the layout information and the field to be configured of each display item in the report to be generated through the configuration file corresponding to the report to be generated.

In this embodiment, the received request information for generating the report refers to a request for generating a front-end report, and the report generation request carries a service identifier, such as a service name or a service identifier, of a service corresponding to the report to be generated. The business can be various businesses in the operation of the enterprise, such as financial business, attendance checking business or workload statistics business and the like. Those skilled in the art will appreciate that the illustration is merely for example, and in other embodiments, services may include more, and the application is not limited thereto.

The preset report template database comprises report templates corresponding to various services, each report template corresponds to one service identifier, and the report to be generated corresponding to the service is obtained according to the matching result of the service identifier carrying the service corresponding to the report to be generated in the report generation request and the service identifier corresponding to the report template in the preset report template database.

And acquiring the layout information and the field to be configured of each display item in the report to be generated through the configuration file corresponding to the report to be generated. The configuration file corresponding to the report to be generated is a plurality of configuration item information, and the configuration item information may include a name of the report to be generated, a header column definition (including a double header) of the report to be generated, a data column value type and display format, whether column values are displayed in total (including grouping and summarizing), a Structured Query Language (SQL) script of a data source, a data result sorting, a field definition and assignment (including a self-defined service parameter field constant) of a filtering service object, and the like.

It should be noted that, by using the SQL query statement, the data source of the report to be generated is quickly obtained, and the corresponding terminal is returned according to the report data obtaining request to be generated, so that a full-function simple report to be generated can be quickly created, a Business and Operating System (BOS) does not need to be installed, a large number of repetitive operations do not need to be performed on the attribute configuration of each report to be generated, and the field information in the configuration file is used as the query logic of the SQL statement, so that the data in all the data tables can be concentrated in one interface for display operation, thereby effectively improving the generation efficiency of the report.

S202: and generating and displaying an acquisition item corresponding to the field to be configured based on the acquisition script of the report to be generated, acquiring field information acquired in the acquisition item, and acquiring an inquiry statement corresponding to the acquisition item according to the inquiry code of the field to be configured and the field information.

In step S202, a collection item corresponding to the field to be configured is displayed on the report configuration interface, where the collection item is field information in the data table corresponding to the field to be configured, the corresponding data and the field information corresponding to the data are collected from the collection item, and the field information is converted into a corresponding query statement by acquiring a query code of the field to be configured corresponding to the collection item.

In this embodiment, each acquisition script in the acquisition scripts has a corresponding script identifier, the script identifier includes an acquisition item and a processing operation desired for acquisition, each acquisition script is associated with one acquisition item, according to the acquisition script of the report to be generated, an acquisition item of a corresponding field to be configured is configured on the configuration interface, the field to be configured is identification information corresponding to a table name in the data table, the acquisition item is information of each field in the data table, that is, corresponding data in each row or each column, and the acquired field information is field information of corresponding data in each row in the data table or a field name or a field type corresponding to data in each column, and the like.

It should be noted that, according to the difference of the platforms of the report to be generated, the language corresponding to the collection script is different, for example, in an android platform, the custom command may be a gradle command (a project automation building tool). The gradle commands are scripts written by application developers in the groovy language (a programming language) that can run in the build tool gradle. It is to be understood that other ways may be used to trigger the customizing terminal to customize the data collection kit, which is not limited in this respect.

And using the query code of the field to be configured corresponding to the acquisition item to extract the corresponding data table from the database to obtain the data corresponding to the data table, wherein the field information in the acquisition item is the field name, the field type or the field length and the like. For example, the field to be configured may be presented as a "Player data sheet," and the data column name "role occupation" or the like may be displayed in a drop-down menu of the data sheet name,

it should be noted that, in this embodiment, the query code of the field to be configured is an SQL statement code, which may be "Select form tb 1", and is a query code corresponding to the field to be configured, tb1 is an identifier in a data table corresponding to the field to be configured, tb1 may be an employee information table of a certain company, where tb1 includes a name field, an age field, a gender field, and the like, when the field information collected in the field to be configured by the collection item is the name field, the query statement corresponding to the field information may be "Select form tb1where a1 is 1" a1 is the name field in the data table tb1, when the field information collected in the field to be configured by the collection item is the age field, the query statement corresponding to the field information may be "Select form tb1where a she a2 is 1" a2 is the name field in the data table tb1, and when the collection field is the gender field in the collection information field, the query statement to which the field information corresponds can be "Select form tb1where A3 is 1" A3 is the gender field in data table tb 1. And converting the query code corresponding to the field to be configured into a query statement corresponding to the field information. And query statements corresponding to the field information are directly obtained on the basis of the query codes corresponding to the fields to be configured, so that the data query efficiency is improved.

It should be noted that the query code may be byte code. Bytecode is a binary file that contains an executable program that consists of a series of opcode/data pairs. Bytecode is an intermediate code that is more abstract than machine code and requires the translator to convert to the intermediate code of the machine code. Regardless of the hardware environment, bytecode is mainly used to implement specific software operations and software environments, and implementation of bytecode is implemented by compilers and virtual machines, and bytecode is generally not as readable as source code, but a series of coded digital constants, references, instructions, and the like.

Optionally, generating and displaying an acquisition item corresponding to the field to be configured, acquiring field information acquired in the acquisition item, and converting the field information into a query statement by using a query code of the field to be configured corresponding to the acquisition item, including:

acquiring field information acquired in the acquisition items according to the acquisition items corresponding to the fields to be configured;

and based on the field information, filling the query codes of the fields to be configured corresponding to the acquisition items to obtain query statements corresponding to the field information.

In this embodiment, when submitting a selected acquisition item to query corresponding data on a report configuration interface, field information acquired in the acquisition item is obtained through field information in a data table corresponding to a data source SQL script in a field to be configured, where the field information includes a field name, and query codes in the field to be configured are extracted, and after selecting an acquisition item in a corresponding field to be configured, the field information corresponding to the selected acquisition item is filled in the query codes in the configuration field to obtain a query statement corresponding to the acquisition item, so that data in the corresponding data source is obtained according to the query statement.

For example, the query code corresponding to the field to be configured is SQL > DESC emp, a data table corresponding to emp is queried, after the field information corresponding to the acquisition item is acquired, for example, data in all columns in the emp data table is acquired, after the query code with the configuration field is filled, a query statement SQL > SELECT x FROM emp corresponding to the field information in all columns is obtained, when a column is specified in the query data table, the corresponding query statement is SQL > SELECT DISTINCT mgr FROM emp, wherein DISTINCT is the field information in the specified column. And sequentially filling the query codes of the fields to be configured according to the field information in different acquisition items so as to obtain the query sentences of the field information, and thus obtaining the target data according to the query sentences.

When the corresponding data is obtained according to the query statement, each data table may have at most one unique constraint, i.e., there is one unique constraint field, or the unique constraint field is marked as empty. Here, the unique constraint includes a primary key constraint. A unique constraint may mean that the values of the fields cannot be repeated in all records of the data table. For example, a unique constraint may be populated in the identification field, and the identification value of each record is unique and no duplication occurs. Unique constraints may be used to limit the uniqueness of data on a data column.

S203: and according to the query statement, extracting a data source corresponding to the field information from the database, triggering an interface to connect with the data source, and acquiring corresponding target data.

In step S203, the query statement corresponding to the field information includes a corresponding query interface, and the query interface is connected to a corresponding data source in the database to obtain target data, where the target data is data corresponding to the field information in the acquisition item.

In this embodiment, according to the generated query statement, an operation Interface (API) of the query database tool may be called to query field information in the data table corresponding to the table name involved from the data source. The database tool is used for extracting, converting and loading data. After the table names related to the query statement are screened, the operation interface of the query database tool can be called first to obtain the target data. If the connection fails, the query is exited and the feedback check fails. If the connection is successful, the next operation can be continued.

For example, an API to query the HIVE table may be called, where HIVE is a data warehouse tool used to perform data extraction, transformation, and loading. HIVE is a data warehouse tool based on Hadoop, is used for data extraction, transformation and loading, and is a mechanism capable of storing, querying and analyzing large-scale data stored in Hadoop. The HIVE data warehouse tool can map the structured data file into a database table and provide the SQL query function. The Hadoop is a distributed system infrastructure.

It should be noted that, when the framework development software is used, the attribute file is usually used to configure the database information, which has the advantage that when a plurality of places of the program relate to the database connection, only the attribute file needs to be loaded to read the database information, and if the database is changed, only the attribute file of the database needs to be changed, and the program file does not need to be changed file by file. In this embodiment, when a query database tool is used to perform data extraction, conversion, and loading, the attribute file corresponding to the database is processed to obtain corresponding target data.

Optionally, if the field information includes a field name, extracting a data source corresponding to the field information from the database according to the query statement, and triggering the interface to connect the data source to obtain corresponding target data, including:

analyzing the query statement to obtain a query condition in the query statement;

acquiring identification information of a data table in a database corresponding to a field to be configured according to the query condition;

matching the field name in the data table corresponding to the identification information with the field name in the field information, and if the matching is successful, obtaining a target field name;

and extracting the field value corresponding to the target field name in the data table based on the operation interface corresponding to the database to obtain the target data corresponding to the field information.

In this embodiment, the query statement is parsed to obtain the query condition in the query statement, for example, the data query statement may be an SQL statement, which may be "Select form tb1where a1 is 1", and the SQL statement means that a data record of field data 1 is queried from table tb1, where a1 represents a field in table tb 1. For example, the table tb1 can be an employee information table for a company, where table tb1 includes a name field, an age field, a gender field, etc., and then the field A1 can be the name field in table tb1, the age field in table tb1 can be A2, and the gender field can be A3. By parsing the query statement, the resulting query conditions are tb1 and A1. According to the query condition, a data table in a database corresponding to the field to be configured is obtained, the data table is a data table of tb1, the field information in the data table tb1 may include field names of a1, a2, A3 and the like, the field name in the query statement is a1, the field name in the query statement is matched with the field name in the data table, if the matching is successful, the target field name is obtained, a target field name a1 is obtained, the field value corresponding to the target field name in the data table is extracted, and if the data source in the target field a1 is the name field, the target data corresponding to the name field is sent to an interface of a report to be generated through a corresponding interface for display.

Optionally, acquiring target data corresponding to the field information based on an operation interface corresponding to the database, including:

converting the data format corresponding to the field value into a standard data format, and writing the standard data format into a data file to obtain a standard data file;

and extracting target data corresponding to the field value in the standard data file through a corresponding operation interface. In this embodiment, the data format corresponding to the field value is converted into the standard data format and written into the standard data file, the data source data is written into the standard data format file to generate the standard data file, the data corresponding to the field value in the standard data file is called through the corresponding operation interface, and the data is displayed in the report to be generated.

For example, interface data in the report to be generated is data in an XML format, relational data stored in the database can be converted into data in the XML format, in the relational data, the data is mainly stored in the database in a two-dimensional table form, the data is composed of rows and columns, each column defines fields of the data, each row is a numerical value of a data tuple with the same field, and each data is composed of attributes defined by the fields and the data itself. In the XML document, each data is also equivalent to an element, and is composed of a name of the element and a value of the element, and the element may contain sub-elements to form a tree-like data diagram, so if conversion is to be performed, data of each unit in the relational data table is mainly converted into an element in the XML document, that is, a field attribute and a value of the relational data are converted into a name of the element and a value of the element in the XML document, and a corresponding report is generated on a report generation interface according to the name of the element and the value of the element.

It should be noted that, when the target data is obtained according to the query statement, according to the database information included in the query statement, API information corresponding to the database may be determined, an API corresponding to the database is called, and the target data is obtained from the database through the API.

For example, when the query statement is "select from business table where field information", the query statement is parsed, first, a corresponding query keyword is searched, and data information included in the keyword is extracted, where the keyword of the query statement includes: select, from, where, group by, having, order by. Extracting the content contained in the keyword, corresponding to the data table to be queried after the select from keyword, and the field information to be queried after the where keyword, obtaining corresponding query conditions according to the query content in the query statement, matching field names corresponding to the field information in the query statement from all the field information contained in the data table to be queried, for example, the a data table contains attendance information of all employees, including employee information of a1, a2, A3, etc., but the query statement needs to query the attendance information of the a1 employee, matching all field names in the A data table with the field names in the field information in the query statement to obtain the target field name in the A data table, the name of the target field is the name of an A1 employee, and the field value corresponding to the acquired name of the target field is written into the data file through the API, so that a standard data file is obtained.

In the embodiment, the field value corresponding to the target field can be written into the JSON format file, JSON format data is composed of character strings, the grammar is simple and easy to read, the conversion between the object and the data is flexible, the name and the value field of the data are distinguished by using simple separators, the redundancy is low, the JSON format data is suitable for being used as a carrier for data transmission, and text or identifiers are difficult to distinguish between the identifiers and practical attribute values due to the fact that a large number of separators exist in the JSON format data, so that the data is safe in the transmission process.

When a report needs to be displayed at the front end, the front end analyzes received JSON format data, when the JSON format data is analyzed, JSON Array is uniformly adopted to return a result, Null data processing is performed, Null data and Null data are directly deleted where the data is located, data format processing, decimal number, separation number, currency symbol, percentage, time/date and data length processing are performed, if the number is less than a preset value, all data are displayed, and if the number is less than the preset value, the next digit of a novel point is displayed. Different types of reports can be generated based on the JSON format data, including text reports, ring reports, broken line reports, column reports, strip reports, table reports and the like, and the JSON format data includes configuration file information in the report to be generated, such as report keywords, table headers, units, chart types, paging information, whether the report has tab page tags, whether the report has filter columns, whether the report has row sequences and the like.

It should be noted that, in the report to be generated, each display item is stored in JSON format data in the form of a data block, each data block is composed of a data block name and data block data, the data block data is composed of a field to be configured and data contained in a plurality of field names, and the data block data is obtained by conversion, wherein the important step is to query each field of each JSON Object in the JSON Array, if the field to be configured in the data block data is matched, the data corresponding to the field in the JSON Object is assigned to the data corresponding to the corresponding field name in the data block data, and the data corresponding to the field name is the target data.

S204: and sending the target data to the corresponding display items, performing layout and rendering on all the display items according to the layout information and a preset rendering rule, and determining the result after the layout and the rendering as a report.

In step S204, the rendering rules may include conversion rules for converting a certain data type into another data type, such as converting null values into default values, converting 2018.10.01 into 2018, 10/1, and the like. Also, the rendering rules may contain specific rules, such as rounding, rounding down, and so forth; or other rules may be included, such as converting a "0" value into "definite" chinese, or using different color layouts for different rows or different columns of data corresponding to different field information, etc.

In this embodiment, the rendering rule may be predefined through encoding to obtain a plurality of rendering rules, so that the rendering rule for each row or column is determined for the row or column from the plurality of rendering rules. The data attributes, such as characters, numbers, and the like, of each row or column in the report to be generated can be determined by analyzing the data in each row or column. The data attributes may then be associated with rendering rules, such that the rendering rule associated with a row or column may be determined based on the data attributes of the row or column. However, the rendering rule of each data unit may also be determined in other manners, for example, determining the rendering rule corresponding to the identification number as the rendering rule of the row or column element according to the identification number of the row or column, and the like. And determining the layout and rendering rule of the report to be generated to obtain a corresponding report.

Optionally, the sending the target data to the corresponding display item, performing layout and rendering on all the display items according to the layout information and a preset rendering rule, and determining a result after the layout and the rendering as a report includes:

sending the target data to the corresponding display item through a preset operation mode to obtain data to be displayed;

according to the layout information, performing interactive processing on the data to be displayed to obtain target display data;

and rendering the target display data according to a preset rendering rule to obtain a report.

In this embodiment, the preset operation mode is a dragging mode, the target data are sequentially dragged to the display items, the display interface of the report to be generated can be divided into two parts, one part is a storage area of the target data, the other part is a report display area, and the target data in the storage area are dragged to the corresponding display items in the report display area in the dragging mode to obtain the data to be displayed.

The data to be displayed is processed interactively, wherein the interactive processing comprises the operations of adding, deleting, sequencing and the like to the target data in the report display area, when acquiescent collection items in the fields to be configured are defaulted, the report forms are generated each time by the target data corresponding to the same field information, when the data corresponding to different field information needs to be displayed and the data is added to the report, the field information corresponding to the collection item needs to be added to the report configuration interface in the report to be generated, and when the data is deleted from the report, the selected collection item can be deleted on the report configuration interface in the report to be generated, when the report data is reordered, in the report display area, dragging the data corresponding to different field information in the corresponding row or column through dragging operation, and continuously optimizing the report to be generated based on the corresponding layout information to obtain final target display data.

And rendering the target display data according to the rendering rule to obtain a report. The rendering rule can be a rendering rule set for each display item, and can also be a rendering rule set for each row or each column in the report.

Optionally, the rendering processing is performed on the target display data through a preset rendering rule to obtain a report, including:

splitting a report to be generated of target display data into different data units, and setting different rendering keywords for the different data units;

and performing rendering processing on each data unit based on a preset rendering rule corresponding to each rendering keyword to obtain a report.

In this embodiment, the target display data is split into different data units, where the data unit may include a minimum cell corresponding to a report to be generated in the target display data. Taking an EXCEL-type report to be generated for target presentation data as an example, in an EXCEL table, each cell can be used as a data unit, that is, if the EXCEL table is 4 rows and 4 columns, there are 16 data units, or each row can be used as a data unit, each column can be used as a data unit, or data units can be obtained by other splitting modes, for example, a certain number of cells are divided into one data unit, and the like. Different rendering can be performed on each data unit of the report to be generated of the target display data through various division of the data units, so that multiple rendering modes are available, and the rendering flexibility is provided.

When rendering is carried out, in order to facilitate quick rendering, corresponding rendering keywords are set for each data unit, it is determined that the rendering rule corresponding to each data unit can obtain the corresponding rendering rule through obtaining the rendering keyword corresponding to the data unit, corresponding relations exist between the rendering keywords and the rendering rule, all the contained corresponding relations are stored in a preset rendering database, when a label corresponding to each data unit in a report to be generated is obtained, the corresponding rendering keyword of each data unit can be matched with the rendering keyword in the preset rendering database to obtain a target rendering keyword in the rendering database, and the data unit is rendered according to the rendering rule corresponding to the target rendering keyword in the preset rendering database.

The user can set the rendering keywords of each data unit according to the needs of the user, or can pre-configure the rendering keywords of each data unit in the configuration file of the report to be generated of the target display data, and further can determine the rendering keywords of each data unit of the report to be generated according to the configuration file.

The corresponding relation between the rendering keywords in the rendering database and the rendering rules is preset, and one rendering keyword can correspond to one rendering rule. And the rendering keywords and the rendering rules can correspond to each other according to preset rules, for example, the rendering keywords are sorted according to the numerical values, the rendering rules are sorted according to the use frequency, and then the rendering keywords and the rendering rules are sequentially corresponding to each other.

It should be noted that the rendering keyword may include information of numbers, words and symbols, or a combination of information of numbers, words and symbols, for example, the rendering keyword may be "001", "002", "00A", and the like, which is not limited in this exemplary embodiment.

The invention provides a report generating method, which comprises the steps of generating and displaying an acquisition item corresponding to a field to be configured by acquiring layout information and the field to be configured of each display item in a report to be generated, acquiring field information acquired in the acquisition item, converting the field information into a query statement by using a query code of the field to be configured corresponding to the acquisition item, extracting a data source corresponding to the field information from a database according to the query statement, triggering an interface to be connected with the data source, acquiring corresponding target data, sending the target data to the corresponding display item, performing layout and rendering on all the display items according to the layout information and a preset rendering rule, determining the result after the layout and the rendering as the report, acquiring the field information of the acquisition item in the field to be configured by configuration according to the acquired layout information and the field to be configured of the report to be generated, the report is generated by acquiring the report data source based on the field information, and business personnel only need to configure the report to be generated without continuously modifying codes according to requirements by development personnel, so that the dependency on the development personnel is reduced, the flexibility of report generation is increased, and the efficiency of report generation is improved.

Referring to fig. 3, fig. 3 is a schematic structural diagram of a report generating apparatus according to an embodiment of the present invention. The units included in the terminal in this embodiment are used to execute the steps in the embodiment corresponding to fig. 2. Please refer to fig. 2 and the related description of the embodiment corresponding to fig. 2. For convenience of explanation, only the portions related to the present embodiment are shown.

Referring to fig. 3, the report generation apparatus 30 includes:

the obtaining module 31 is configured to obtain layout information and a field to be configured of each display item in the report to be generated;

the query statement conversion module 32 is configured to generate and display a collection item corresponding to the field to be configured based on the collection script of the report to be generated, acquire field information collected in the collection item, and obtain a query statement corresponding to the collection item according to the query code of the field to be configured and the field information;

the target data acquisition module 33 is configured to extract a data source corresponding to the field information from the database according to the query statement, and trigger the interface to connect the data source to acquire corresponding target data;

and the report generation module 34 is configured to send the target data to the corresponding display items, perform layout and rendering on all the display items according to the layout information and a preset rendering rule, and determine a result after the layout and the rendering is a report.

Optionally, the obtaining module 31 includes:

the matching unit is used for searching a report template matched with the request information in a preset report template database according to the received request information generated by the report to obtain the report to be generated;

the device comprises a layout information and field to be configured acquisition unit, a field configuration unit and a field configuration unit, wherein the layout information and field to be configured acquisition unit is used for acquiring the layout information and the field to be configured of each display item in the report to be generated through a configuration file corresponding to the report to be generated; the configuration file is parameter data of a configuration interface corresponding to the report to be generated.

Optionally, the query statement conversion module 32 includes:

the acquisition unit is used for acquiring field information acquired in the acquisition items according to the acquisition items corresponding to the fields to be configured;

and the query statement acquisition unit is used for filling the query codes of the fields to be configured corresponding to the acquisition items based on the field information to obtain the query statements corresponding to the field information.

Optionally, the target data obtaining module 33 includes:

the analysis unit is used for analyzing the query statement to obtain a query condition in the query statement;

the identification information acquisition unit of the data table is used for acquiring the identification information of the data table in the database corresponding to the field to be configured according to the query condition;

the matching unit is used for matching the field name in the data table corresponding to the identification information with the field name in the field information, and if the matching is successful, the target field name is obtained;

and the extraction unit is used for extracting the field value corresponding to the target field name in the data table based on the operation interface corresponding to the database to obtain the target data corresponding to the field information.

Optionally, the extracting unit includes:

the conversion module is used for converting the data format corresponding to the field value into a standard data format and writing the standard data format into a data file to obtain a standard data file;

and the target data extraction subunit is used for extracting target data corresponding to the field value in the standard data file through the corresponding operation interface.

Optionally, the report generating module 34 includes:

the data to be displayed acquisition unit is used for sending the target data to the corresponding display item through a preset operation mode to obtain the data to be displayed;

the interaction unit is used for performing interaction processing on the data to be displayed according to the layout information to obtain target display data;

and the rendering unit is used for rendering the target display data according to a preset rendering rule to obtain a report.

Optionally, the rendering unit includes:

the rendering keyword setting subunit is used for splitting the report to be generated of the target display data into different data units and setting different rendering keywords for the different data units;

and the rendering processing subunit is used for performing rendering processing on each data unit based on the preset rendering rule corresponding to each rendering keyword to obtain a report.

Fig. 4 is a schematic structural diagram of a computer device according to an embodiment of the present invention. As shown in fig. 4, the computer apparatus of this embodiment includes: at least one processor (only one shown in fig. 4), a memory, and a computer program stored in the memory and executable on the at least one processor, the processor implementing the steps of any of the various report generation method embodiments described above when executing the computer program.

The computer device may include, but is not limited to, a processor, a memory. It will be appreciated by those skilled in the art that fig. 4 is merely an example of a computer device and is not intended to be limiting, and that a computer device may include more or fewer components than those shown, or some components may be combined, or different components may be included, such as a network interface, a display screen, and input devices, etc.

The Processor may be a CPU, or other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field-Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic, discrete hardware components, or the like. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.

The memory includes readable storage media, internal memory, etc., wherein the internal memory may be the internal memory of the computer device, and the internal memory provides an environment for the operating system and the execution of the computer-readable instructions in the readable storage media. The readable storage medium may be a hard disk of the computer device, and in other embodiments may also be an external storage device of the computer device, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), and the like, provided on the computer device. Further, the memory may also include both internal storage units and external storage devices of the computer device. The memory is used for storing an operating system, application programs, a BootLoader (BootLoader), data, and other programs, such as program codes of a computer program, and the like. The memory may also be used to temporarily store data that has been output or is to be output.

It will be apparent to those skilled in the art that, for convenience and brevity of description, only the above-mentioned division of the functional units and modules is illustrated, and in practical applications, the above-mentioned function distribution may be performed by different functional units and modules according to needs, that is, the internal structure of the apparatus is divided into different functional units or modules, so as to perform all or part of the functions described above. Each functional unit and module in the embodiments may be integrated in one processing unit, or each unit may exist alone physically, or two or more units are integrated in one unit, and the integrated unit may be implemented in a form of hardware, or in a form of software functional unit. In addition, specific names of the functional units and modules are only used for distinguishing one functional unit from another, and are not used for limiting the protection scope of the present invention. The specific working processes of the units and modules in the above-mentioned apparatus may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again. The integrated unit, if implemented in the form of a software functional unit and sold or used as a separate product, may be stored in a computer readable storage medium. Based on such understanding, all or part of the flow of the method of the above embodiments may be implemented by a computer program, which may be stored in a computer readable storage medium and used by a processor to implement the steps of the above method embodiments. Wherein the computer program comprises computer program code, which may be in the form of source code, object code, an executable file or some intermediate form, etc. The computer readable medium may include at least: any entity or device capable of carrying computer program code, recording medium, computer Memory, Read-Only Memory (ROM), Random Access Memory (RAM), electrical carrier wave signals, telecommunications signals, and software distribution media. Such as a usb-disk, a removable hard disk, a magnetic or optical disk, etc. In some jurisdictions, computer-readable media may not be an electrical carrier signal or a telecommunications signal in accordance with legislative and proprietary practices.

The present invention can also be implemented by a computer program product, which when executed on a computer device causes the computer device to implement all or part of the processes in the method of the above embodiments.

In the above embodiments, the descriptions of the respective embodiments have respective emphasis, and reference may be made to the related descriptions of other embodiments for parts that are not described or illustrated in a certain embodiment.

Those of ordinary skill in the art will appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware or combinations of computer software and electronic hardware. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.

In the embodiments provided by the present invention, it should be understood that the disclosed apparatus/computer device and method may be implemented in other ways. For example, the above-described apparatus/computer device embodiments are merely illustrative, and for example, a module or a unit may be divided into only one logical function, and may be implemented in other ways, for example, multiple units or components may be combined or integrated into another system, or some features may be omitted, or not implemented. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.

Units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.

The above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; such modifications and substitutions do not substantially depart from the spirit and scope of the embodiments of the present invention, and are intended to be included within the scope of the present invention.

Claims

1. A report generation method is characterized by comprising the following steps:

acquiring layout information and a field to be configured of each display item in a report to be generated;

and sending the target data to corresponding display items, laying out and rendering all the display items according to the layout information and a preset rendering rule, and determining the result after laying out and rendering as the report.

2. The report generation method according to claim 1, wherein the obtaining layout information and fields to be configured of each display item in the report to be generated comprises:

acquiring layout information and fields to be configured of each display item in the report to be generated through a configuration file corresponding to the report to be generated; the configuration file is parameter data of a configuration interface corresponding to the report to be generated.

3. The report generation method according to claim 1, wherein the generating and displaying the collection items corresponding to the fields to be configured based on the collection script of the report to be generated, obtaining the field information collected in the collection items, and obtaining the query statement corresponding to the collection items according to the query code of the fields to be configured and the field information comprises:

and filling the query codes of the fields to be configured corresponding to the acquisition items based on the field information to obtain the query statements corresponding to the field information.

4. The report generation method according to claim 1, wherein if the field information includes a field name, extracting a data source corresponding to the field information from a database according to the query statement, and triggering an interface to connect with the data source to obtain corresponding target data, the method includes:

acquiring identification information of a data table in a database corresponding to the field to be configured according to the query condition;

5. The report generation method according to claim 4, wherein the extracting a field value corresponding to a target field name in the data table based on the operation interface corresponding to the database to obtain target data corresponding to the field information comprises:

and extracting target data corresponding to the field value in the standard data file through a corresponding operation interface.

6. The report generation method according to claim 1, wherein the sending the target data to the corresponding display items, laying out and rendering all the display items according to the layout information and a preset rendering rule, and determining the result after laying out and rendering as the report comprises:

sending the target data to a corresponding display item through a preset operation mode to obtain data to be displayed;

and rendering the target display data according to the preset rendering rule to obtain the report.

7. The report generation method according to claim 6, wherein the rendering the target display data according to the preset rendering rule to obtain the report comprises:

and rendering each data unit based on a preset rendering rule corresponding to each rendering keyword to obtain the report.

8. A report generation apparatus, characterized in that the apparatus comprises:

the query statement conversion module is used for generating and displaying an acquisition item corresponding to the field to be configured, acquiring field information acquired in the acquisition item, and converting the field information into a query statement by using a query code of the field to be configured corresponding to the acquisition item;

9. A computer device comprising a processor, a memory, and a computer program stored in the memory and executable on the processor, the processor implementing the report generation method according to any of claims 1 to 7 when executing the computer program.

10. A computer-readable storage medium, in which a computer program is stored, which, when being executed by a processor, implements the report generating method according to any one of claims 1 to 7.