CN110929491A - Data report generation method, device, server and storage medium - Google Patents

Abstract

The embodiment of the invention provides a data report generation method, a data report generation device, a server and a storage medium, belongs to the technical field of computers, and solves the problems that a large amount of labor time is consumed for customized development of a data report in the prior art, and the requirement of a user for a customized data report cannot be met. The method comprises the following steps: determining and displaying an operable index data source corresponding to the user permission instruction according to the acquired user permission instruction; when an index grouping instruction is obtained, performing index item grouping display on the operable index data source according to a preset index dimension and a preset weight, wherein the preset weight refers to a highlighted display position of an index item when the index item is displayed in a grouping manner; when the index selection instruction is obtained, a temporary data report is generated according to the index items displayed in the selected grouping mode in the index selection instruction, and the temporary data report comprises data contents corresponding to the index items displayed in the selected grouping mode. The embodiment of the invention is suitable for the generation process of the data report.

Description

Data report generation method, device, server and storage medium

Technical Field

The invention relates to the technical field of computers, in particular to a data report generation method, a data report generation device, a server and a storage medium.

Background

Most of the current technical models adopted for data report generation are MVC (Model-View-Controller, View-mode-Controller) design modes, and customized development is required when a data report is created for a certain specific use scene. The customized development work needs to consume a large amount of manpower time, the online period is long, and the requirements of the user on self-adaptive and self-customized data report forms cannot be met.

Disclosure of Invention

The embodiment of the invention aims to provide a data report generation method, a data report generation device, a server and a storage medium, which solve the problems that the customization development of a data report in the prior art consumes a large amount of labor time and cannot meet the requirements of a user on a self-adaptive and self-customized data report.

In order to achieve the above object, an embodiment of the present invention provides a method for generating a datagram table, including: determining and displaying an operable index data source corresponding to the user permission instruction according to the acquired user permission instruction; when an index grouping instruction is obtained, performing index item grouping display on the operable index data source according to a preset index dimension and a preset weight, wherein the preset weight refers to a highlighted display position of an index item when the index item is displayed in a grouping manner; when an index selection instruction is obtained, a temporary data report is generated according to the index items displayed in groups selected in the index selection instruction, and the temporary data report comprises data contents corresponding to the index items displayed in groups selected.

Further, the displaying of the operable index data source corresponding to the user permission instruction includes: and according to the preset index dimension, cascade-displaying all dimension index items of each data source in the operable index data sources corresponding to the user permission instruction.

Further, the grouping and displaying the index items of the operable index data source according to a preset index dimension and a preset weight includes: according to the preset index dimension, grouping index items of each dimension of each data source in the operable index data sources; and displaying the grouped index items at display positions corresponding to the preset weights according to the preset weights corresponding to each index item, wherein the larger the preset weight is, the more the corresponding display positions are highlighted.

Further, when the index selection instruction is obtained, the generating a temporary data report according to the index item displayed in the group selected in the index selection instruction includes: when an index selection instruction is obtained, displaying the index items displayed in a grouping mode selected in the index selection instruction in a flashing mode; and searching the data content corresponding to the index item displayed in the selected grouping mode, and generating a temporary data report according to the data content corresponding to the index item displayed in the selected grouping mode.

Further, after the generating a temporary data report according to the index items displayed in the group selected in the index selection instruction, the method further includes: and when the graphical instruction is acquired, displaying the temporary data report as a corresponding visual chart according to the type corresponding to the graphical instruction.

Correspondingly, an embodiment of the present invention further provides a device for generating a data report, including: the acquisition unit is used for acquiring a user permission instruction, an index grouping instruction and an index selection instruction; the determining unit is used for determining an operable index data source corresponding to the user permission instruction according to the user permission instruction acquired by the acquiring unit; the display unit is used for displaying the operable index data source corresponding to the user permission instruction; the grouping unit is used for grouping the index items of the operable index data source according to a preset index dimension and a preset weight when the acquisition unit acquires an index grouping instruction, wherein the preset weight is a highlighted position of the index item when the index item is displayed in a grouped manner; the display unit is also used for displaying the index item grouping of the operable index data source; and the report generation unit is used for generating a temporary data report according to the index items displayed in groups selected in the index selection instruction when the acquisition unit acquires the index selection instruction, wherein the temporary data report comprises the data content corresponding to the selected index items displayed in groups.

Further, the display unit is further configured to cascade-display, according to the preset index dimension, each dimension index item of each data source in the operable index data sources corresponding to the user permission instruction.

Further, the grouping unit is further configured to group index items of each dimension for each data source in the operable index data sources according to the preset index dimension; the display unit is further configured to display the grouped index items at display positions corresponding to the preset weights of the index items according to the preset weights corresponding to the index items, wherein the larger the preset weight is, the more the corresponding display positions are protruded.

Further, the display unit is further configured to, when the obtaining unit obtains an index selection instruction, flash and display an index item displayed in a group selected in the index selection instruction; the report generating unit is further configured to search for data content corresponding to the selected grouping displayed index item, and generate a temporary data report according to the data content corresponding to the selected grouping displayed index item.

Further, the obtaining unit is further configured to obtain a graphical instruction; the display unit is further used for displaying the temporary data report as a corresponding visual chart according to the type corresponding to the graphical instruction when the obtaining unit obtains the graphical instruction.

Correspondingly, the embodiment of the invention also provides a server, and the server is used for executing the data table generating method.

Accordingly, an embodiment of the present invention further provides a computer-readable storage medium, which stores computer instructions, and the computer instructions cause the computer to execute the data table generating method described above.

According to the technical scheme, an operable index data source corresponding to the user permission instruction is determined and displayed according to the acquired user permission instruction, then when the index grouping instruction is acquired, the operable index data source is subjected to index item grouping display according to a preset index dimension and a preset weight, wherein the preset weight refers to the highlighted display position of an index item when the index item is displayed in a grouping mode, when the index selection instruction is acquired, a temporary data report is generated according to the index item displayed in the grouping mode selected in the index selection instruction, and the temporary data report comprises data content corresponding to the selected index item displayed in the grouping mode. The embodiment of the invention solves the problems that the customized development of the data report consumes a large amount of manpower time and cannot meet the requirements of the user on the self-adaptive and self-customized data report in the prior art, realizes the requirement of randomly selecting the index items from the displayed index items and generating the temporary data report, and meets the user-defined report of the user dimension.

Additional features and advantages of embodiments of the invention will be set forth in the detailed description which follows.

Drawings

The accompanying drawings, which are included to provide a further understanding of the embodiments of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description serve to explain the embodiments of the invention without limiting the embodiments of the invention. In the drawings:

fig. 1 is a schematic flowchart of a data report generating method according to an embodiment of the present invention;

fig. 2 is a schematic diagram of a display effect of a grouping indicator according to an embodiment of the present invention;

fig. 3 is a schematic diagram illustrating another display effect of grouping indicators according to an embodiment of the present invention;

fig. 4 is a schematic flow chart of another data table generating method according to an embodiment of the present invention;

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

fig. 6 is a schematic structural diagram of an apparatus according to an embodiment of the present invention.

Detailed Description

The following detailed description of embodiments of the invention refers to the accompanying drawings. It should be understood that the detailed description and specific examples, while indicating embodiments of the invention, are given by way of illustration and explanation only, not limitation.

Fig. 1 is a schematic flowchart of a data report generation method according to an embodiment of the present invention. As shown in fig. 1, the method comprises the steps of:

step 101, determining and displaying an operable index data source corresponding to an acquired user permission instruction according to the acquired user permission instruction;

102, when an index grouping instruction is obtained, performing index item grouping display on the operable index data source according to a preset index dimension and a preset weight, wherein the preset weight is a highlighted position of an index item when the index item is displayed in a grouping manner;

step 103, when an index selection instruction is obtained, generating a temporary data report according to the index items displayed in groups selected in the index selection instruction, wherein the temporary data report includes data contents corresponding to the selected index items displayed in groups.

The execution main body of the embodiment of the invention can be a user side with a reporting system or a server with the reporting system. For a server with a report system, the embodiment of the invention can be realized through the interaction between a user side and the server. When a user needs to generate a temporary report, the user logs in the system through a user name and a password, the server receives a user authority instruction, namely the user name and the password of the user, and the authority setting corresponding to the user name is searched through the login authority, the operation authority, the query authority and the data authority which are configured for each user name in advance. For example, the user may be authenticated by using the MD5 algorithm, that is, when the user registers, the user password is stored in the MD5 value, when the user logs in, the user inputs the password and calculates the value as MD5, and then compares the value with the stored MD5 value, if the ciphertext is the same, the password may be considered to be correct, otherwise, the password is wrong. Through the steps, the server can determine the legality of the user login without knowing the clear code of the user password. Therefore, the password of the user can be prevented from being known by the user with the authority of the server administrator, and the difficulty of cracking the password is increased to a certain extent. The login authority configured for each user refers to the authority of the user to log in the report system. The operation authority refers to the authority of the user for operating the data report in the report system. The inquiry authority refers to the authority of the user for inquiring each data report in the report system. The data authority refers to the size of the range of the data report viewed by the user. In addition, the authority of each user corresponds to the role of the user to which the user belongs, and if the roles are different, the corresponding authorities are different, and the operable data ranges are different, for example, the roles may include: national administrator, war area chief prison, provincial area chief prison, urban administrator, etc. The above-described setting of user rights has a special user rights table in the server to configure the rights. After a user logs in a report system by using a user authority instruction (a user name and a password), a server receives the user authority instruction, determines the legality of user login according to the password of the user, determines the authority of the user according to the user name when the user login is legal, extracts a corresponding operable index data source and displays the operable index data source on a display interface.

In addition, optionally, when the operable index data sources corresponding to the user permission instruction are displayed, the dimension index items of each data source in the operable index data sources corresponding to the user permission instruction may be displayed in a cascaded manner according to preset index dimensions. For example, when the user is the right of provincial administration, the obtained operable index data source is an index data source of provincial dimensions, for example, a newly added contracted store, and the like of the provincial dimensions. The newly added contract shop of the data source further includes index items of multiple dimensions, for example, multiple dimensions of newly added contract shops of the urban area, newly added contract shops of the business district, newly added contract shops of the community, and the like.

And when the user inputs an index grouping instruction, the server acquires the index grouping instruction. The user may input the index grouping instruction on the display interface in various ways, for example, by clicking an icon of the index grouping, or by performing gesture operation on the display interface, for example, by touching any area of the operable index data source displayed on the current interface for more than a set time (for example, three seconds), and the like, which is not limited in the embodiment of the present invention. And after the server receives the index grouping instruction, grouping the index items of each dimension of each data source in the operable index data sources according to the preset index dimension, namely dividing the index items of each dimension of each data source in the currently displayed operable index data sources into independent indexes. And then, displaying the grouped index items at display positions corresponding to the preset weights according to the preset weights corresponding to each index item, wherein the preset weights refer to the highlighted display positions of the index items when the index items are displayed in groups, and the larger the preset weight is, the more the corresponding display positions are highlighted. For example, the user may set a preset weight to the index item that he or she is interested in advance, for example, the score of the preset weight may be divided into threelevels 10, 5, and 1, and the higher the level is, the larger the preset weight is, the more the corresponding display position is highlighted. For example, the upper left of the display interface is set as the origin of coordinates, the index items closer to the origin of coordinates have larger preset weights and the display positions thereof are more prominent, while the index items displayed from the origin of coordinates to the right and below of the display interface have gradually smaller preset weights and the display positions thereof are gradually common. As shown in fig. 2, if the score of the preset weight corresponding to the index item displayed in the area a of the display interface is 10, the index item is displayed at a protruding position close to the origin of coordinates, and the score of the preset weight corresponding to the index item displayed in the area B is 5, the display position of the index item in the area is relatively common with respect to the index item in the area a, and the display position of the index item in the area C is more common. In addition, in order to facilitate the user's selection of the displayed index items, the text sizes of the index items displayed in the A, B, C area may be reduced one by one. Optionally, as shown in fig. 3, the display of the indicator items may be configured to display the indicator item with the score of 10 of the preset weight in the area a, that is, the midpoint of the display interface, display the indicator item with the score of 5 of the preset weight in the area B, display the indicator item with the score of 1 of the preset weight in the area C, or reduce the text size of the indicator item displayed in the area A, B, C one by one. After the index item grouping display is performed on the operable index data source through thestep 102, the index items after grouping can be independently displayed on the display interface in a full screen mode.

When the server obtains an index selection instruction of a user for the index items displayed in groups, the index items displayed in groups selected in the index selection instruction are displayed in a flashing mode, data content corresponding to the selected index items displayed in groups is searched, and a temporary data report is generated according to the data content corresponding to the selected index items displayed in groups. In addition, for convenience of viewing by a user, a chart visualization operation may be provided, for example, after a graphical instruction input by the user is obtained, the temporary data report may be displayed as a corresponding visualization chart according to a type corresponding to the graphical instruction. For example, the type corresponding to the graphical instruction may include radar chart, histogram, pie chart, rose chart, etc., and the temporary data report may be displayed as a corresponding visual chart through different types of graphical instructions.

In addition, the system is extensible, and the temporary data report can be sent to a preset mailbox in a mail form, so that a user can conveniently check and file the report.

In order to facilitate understanding of the embodiment of the present invention, the following describes the data table generation with the interaction between the user terminal and the server, as shown in fig. 4, including the following steps:

step 401, a user side receives a user authority instruction input by a user and uploads the instruction to a server;

step 402, a server acquires the user permission instruction and verifies a password in the user permission instruction;

step 403, after the password is verified to be legal, obtaining a user operable index data source through a user name in the user permission instruction, and issuing the user operable index data source to a user side for display;

step 404, displaying an operable index data source corresponding to the user authority instruction by a user side;

step 405, a user side receives a preset touch instruction of a user on a current display interface, namely an index grouping instruction is obtained, and the instruction is uploaded to a server;

step 406, after the server obtains the index grouping instruction, grouping the index items of each dimension of each data source in the operable index data sources according to a preset index dimension;

step 407, displaying the grouped index items at display positions corresponding to the preset weights of the index items according to the preset weights corresponding to the index items, and sending the set display results to the user side;

step 408, independently displaying the grouped index items on a display interface of the user side in a full screen;

step 409, a user side receives an index selection instruction input by a user and uploads the index selection instruction to a server;

step 410, when the server obtains an index selection instruction, the server instructs the user side to flash and display the selected grouping displayed index items in the index selection instruction;

step 411, searching for data content corresponding to the selected grouping displayed index item, and generating a temporary data report according to the data content corresponding to the selected grouping displayed index item;

step 412, the server sends the temporary data report to the user side and a preset mailbox;

step 413, the user end receives and displays the temporary data report;

step 414, when the user side obtains the graphical instruction, uploading the graphical instruction to the server;

step 415, the server generates a corresponding visual chart from the temporary data chart according to the type corresponding to the graphical instruction, and sends the visual chart to the user side for display;

and step 416, the user terminal displays the temporary data chart to generate a corresponding visual chart.

By the embodiment of the invention, the user self-customized temporary data report can be generated on the basis of the user operable index data source, the problems that the customization development of the data report in the prior art consumes a large amount of labor time and cannot meet the requirements of the user self-adaptive and self-customized data report are solved, and the operable index data source can be displayed in a grouping mode based on the preset index dimension, so that the requirement of randomly selecting the index item from the displayed index items and generating the temporary data report is realized, and the report self-definition of the user dimension is met.

Correspondingly, fig. 5 is a schematic structural diagram of a data report generating device according to an embodiment of the present invention. As shown in fig. 5, theapparatus 50 includes: an obtainingunit 51, configured to obtain a user permission instruction, an index grouping instruction, and an index selection instruction; the determiningunit 52 is configured to determine, according to the user permission instruction acquired by the acquiring unit, an operable indicator data source corresponding to the user permission instruction; thedisplay unit 53 is used for displaying an operable index data source corresponding to the user permission instruction; agrouping unit 54, configured to, when the obtaining unit obtains an index grouping instruction, group the index items of the operable index data source according to a preset index dimension and a preset weight, where the preset weight is a highlighted position of an index item when the index item is displayed in a grouped manner; the display unit is also used for displaying the index item grouping of the operable index data source; and areport generating unit 55, configured to generate a temporary data report according to the index item displayed in the selected group in the index selection instruction when the obtaining unit obtains the index selection instruction, where the temporary data report includes data content corresponding to the index item displayed in the selected group.

Further, the display unit is further configured to cascade-display, according to the preset index dimension, each dimension index item of each data source in the operable index data sources corresponding to the user permission instruction.

Further, the grouping unit is further configured to group index items of each dimension for each data source in the operable index data sources according to the preset index dimension; the display unit is further configured to display the grouped index items at display positions corresponding to the preset weights of the index items according to the preset weights corresponding to the index items, wherein the larger the preset weight is, the more the corresponding display positions are protruded.

Further, the display unit is further configured to, when the obtaining unit obtains an index selection instruction, flash and display an index item displayed in a group selected in the index selection instruction; the report generating unit is further configured to search for data content corresponding to the selected grouping displayed index item, and generate a temporary data report according to the data content corresponding to the selected grouping displayed index item.

Further, the obtaining unit is further configured to obtain a graphical instruction; the display unit is further used for displaying the temporary data report as a corresponding visual chart according to the type corresponding to the graphical instruction when the obtaining unit obtains the graphical instruction.

The operation process of the device refers to the implementation process of the data table generation method.

Correspondingly, the embodiment of the present invention further provides a server, where the server is configured to execute the data table generating method in the foregoing embodiment.

Correspondingly, fig. 6 is a schematic structural diagram of an apparatus provided in an embodiment of the present invention, where the apparatus is applied in a server, and as shown in fig. 6, theapparatus 60 includes at least oneprocessor 61, and at least onememory 62 and abus 63 connected to theprocessor 61; the processor and the memory complete mutual communication through the bus; the processor is configured to call the program instructions in the memory to execute the data table generating method according to the above embodiment.

Accordingly, an embodiment of the present invention further provides a computer-readable storage medium, where the computer-readable storage medium stores computer instructions, and the computer instructions cause the computer to execute the data table generating method described in the foregoing embodiment.

Those of ordinary skill in the art will understand that: all or part of the steps for implementing the method embodiments may be implemented by hardware related to program instructions, and the program may be stored in a computer readable storage medium, and when executed, the program performs the steps including the method embodiments; and the aforementioned storage medium includes: various media that can store program codes, such as ROM, RAM, magnetic or optical disks.

The above-described embodiments of the electronic device and the like are merely illustrative, where the units described as separate parts may or may not be physically separate, and the parts displayed as units may or may not be physical units, may be located in one place, or may also be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.

Through the above description of the embodiments, those skilled in the art will clearly understand that each embodiment can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware. With this understanding in mind, the above-described technical solutions may be embodied in the form of a software product, which can be stored in a computer-readable storage medium, such as ROM/RAM, magnetic disk, optical disk, etc., and includes instructions for causing an electronic device (which may be a personal computer, a server, or a network device, etc.) to execute the methods described in the embodiments or some parts of the embodiments.

Finally, it should be noted that: 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; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.

Claims (10)

1. A method for generating a data report, comprising:

determining and displaying an operable index data source corresponding to the user permission instruction according to the acquired user permission instruction;

when an index grouping instruction is obtained, performing index item grouping display on the operable index data source according to a preset index dimension and a preset weight, wherein the preset weight refers to a highlighted display position of an index item when the index item is displayed in a grouping manner;

when an index selection instruction is obtained, a temporary data report is generated according to the index items displayed in groups selected in the index selection instruction, and the temporary data report comprises data contents corresponding to the index items displayed in groups selected.

2. The method of claim 1, wherein displaying an operational metric data source corresponding to the user permission instruction comprises:

and according to the preset index dimension, cascade-displaying all dimension index items of each data source in the operable index data sources corresponding to the user permission instruction.

3. The method according to claim 1, wherein the grouping and displaying the operational index data sources according to preset index dimensions and preset weights comprises:

according to the preset index dimension, grouping index items of each dimension of each data source in the operable index data sources;

and displaying the grouped index items at display positions corresponding to the preset weights according to the preset weights corresponding to each index item, wherein the larger the preset weight is, the more the corresponding display positions are highlighted.

4. The method according to claim 1, wherein when the index selection instruction is obtained, the generating a temporary data report according to the index items displayed in the group selected in the index selection instruction comprises:

when an index selection instruction is obtained, displaying the index items displayed in a grouping mode selected in the index selection instruction in a flashing mode;

and searching the data content corresponding to the index item displayed in the selected grouping mode, and generating a temporary data report according to the data content corresponding to the index item displayed in the selected grouping mode.

5. The method of claim 1, wherein after generating a temporary data report according to the grouped displayed metric items selected in the metric selection instruction, the method further comprises:

and when the graphical instruction is acquired, displaying the temporary data report as a corresponding visual chart according to the type corresponding to the graphical instruction.

6. A datagram generation apparatus, comprising:

the acquisition unit is used for acquiring a user permission instruction, an index grouping instruction and an index selection instruction;

the determining unit is used for determining an operable index data source corresponding to the user permission instruction according to the user permission instruction acquired by the acquiring unit;

the display unit is used for displaying the operable index data source corresponding to the user permission instruction;

the grouping unit is used for grouping the index items of the operable index data source according to a preset index dimension and a preset weight when the acquisition unit acquires an index grouping instruction, wherein the preset weight is a highlighted position of the index item when the index item is displayed in a grouped manner;

the display unit is also used for displaying the index item grouping of the operable index data source;

and the report generation unit is used for generating a temporary data report according to the index items displayed in groups selected in the index selection instruction when the acquisition unit acquires the index selection instruction, wherein the temporary data report comprises the data content corresponding to the selected index items displayed in groups.

7. The apparatus according to claim 6, wherein the grouping unit is further configured to group each of the operational index data sources into index items of respective dimensions according to the preset index dimension;

the display unit is further configured to display the grouped index items at display positions corresponding to the preset weights of the index items according to the preset weights corresponding to the index items, wherein the larger the preset weight is, the more the corresponding display positions are protruded.

8. The apparatus according to claim 6, wherein the display unit is further configured to, when the acquisition unit acquires an index selection instruction, blink and display an index item displayed in a group selected in the index selection instruction;

the report generating unit is further configured to search for data content corresponding to the selected grouping displayed index item, and generate a temporary data report according to the data content corresponding to the selected grouping displayed index item.

9. A server, characterized in that the server is adapted to perform the data table generation method according to any of claims 1-5.

10. A computer-readable storage medium storing computer instructions for causing a computer to perform the data table generation method of any one of claims 1 to 5.

Images