CN111967234A - Visual report generation method and device, terminal equipment and storage medium - Google Patents
Visual report generation method and device, terminal equipment and storage medium Download PDFInfo
- Publication number
- CN111967234A CN111967234A CN202010743057.6A CN202010743057A CN111967234A CN 111967234 A CN111967234 A CN 111967234A CN 202010743057 A CN202010743057 A CN 202010743057A CN 111967234 A CN111967234 A CN 111967234A
- Authority
- CN
- China
- Prior art keywords
- report
- target
- destination
- list
- web front
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/26—Visual data mining; Browsing structured data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/445—Program loading or initiating
- G06F9/44505—Configuring for program initiating, e.g. using registry, configuration files
- G06F9/4451—User profiles; Roaming
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/451—Execution arrangements for user interfaces
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Human Computer Interaction (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The embodiment of the invention discloses a method and a device for generating a visual report, terminal equipment and a storage medium, wherein the configuration information of the visual report, which is sent by a web front end, is obtained, wherein the configuration information comprises a destination field list, a destination condition list and destination grouping information; generating an SQL file by the target field list, the target condition list and the target grouping information, wherein the SQL file comprises target searching conditions; according to the target searching condition, searching report data corresponding to the target searching condition in a pre-established database; and sending the report data to the web front end so that the web front end generates the report data into a visual report and displays the visual report on a web interface, thereby improving the report generation efficiency.
Description
Technical Field
The invention relates to the technical field of computer software, in particular to a method and a device for generating a visual report, terminal equipment and a storage medium.
Background
With the development of the Internet, background applications based on the B/S architecture are gradually increased. In the applications, a user needs to analyze an operation decision through a report generated by big data, the reports are very numerous, a background development interface is needed in the traditional report generation mode, the web front end needs to be called one by one, then a visual report can be generated, the operation steps are too long, the report can be generated only by matching of front-end developers, rear-end developers and testers, the research and development time is needed to be spent, and the report generation efficiency is very low.
Disclosure of Invention
In view of the above problems, embodiments of the present invention are provided to provide a method and an apparatus for generating a visual report, a terminal device, and a storage medium for generating a visual report, which overcome the above problems or at least partially solve the above problems.
In a first aspect, an embodiment of the present invention provides a method for generating a visual report, where the method includes:
acquiring configuration information of a visual report sent by a web front end, wherein the configuration information comprises a destination field list, a destination condition list and destination grouping information;
generating an SQL file by the target field list, the target condition list and the target grouping information, wherein the SQL file comprises a target searching condition;
according to the target searching condition, searching report data corresponding to the target searching condition in a pre-established database;
and sending the report data to the web front end so that the web front end generates a visual report from the report data and displays the visual report on a web interface.
Optionally, the destination field list includes each field name, an operator and an initial input value in a pre-established database, where the operator at least includes equal to, not equal to, less than, not less than, greater than, not greater than, including, not including, and whether empty;
or the destination field list includes an arithmetic expression.
Optionally, the destination condition list includes each field name, an operator and an initial input value in a pre-established database, wherein the operator at least includes equal to, not equal to, less than, not less than, greater than, not greater than, including, not including, or whether empty.
Optionally, the destination grouping information is used for grouping a plurality of field names.
Optionally, the method further comprises:
the web front end receives a user selected chart name, chart type and chart description, wherein the chart type comprises one or more of a bar graph, a pie graph, a bar graph, a line graph, a map, a thermodynamic diagram, a funnel graph, a radar chart, a relational graph, a box and whisker diagram and a tree diagram.
Optionally, the sending the report data to the web front end, so that the web front end generates a visual report from the report data, and displays the visual report on a web interface, includes:
and sending the report data to the web front end so that the web front end generates a visual report according to the chart name, the chart type and the chart description and displays the visual report on a web interface.
In a second aspect, an embodiment of the present invention provides an apparatus for generating a visual report, where the apparatus includes:
the system comprises an acquisition module, a display module and a display module, wherein the acquisition module is used for acquiring configuration information of a visual report sent by a web front end, and the configuration information comprises a destination field list, a destination condition list and destination grouping information;
the generating module is used for generating the target field list, the target condition list and the target grouping information into an SQL file, wherein the SQL file comprises a target searching condition;
the searching module is used for searching report data corresponding to the target searching condition in a pre-established database according to the target searching condition;
and the display module is used for sending the report data to the web front end so that the web front end displays the report data on a web interface.
Optionally, the destination field list includes each field name, an operator and an initial input value in a pre-established database, where the operator at least includes equal to, not equal to, less than, not less than, greater than, not greater than, including, not including, and whether empty; or the destination field list includes an arithmetic expression.
Optionally, the destination condition list includes each field name, an operator and an initial input value in a pre-established database, wherein the operator at least includes equal to, not equal to, less than, not less than, greater than, not greater than, including, not including, or whether empty.
Optionally, the destination grouping information is used for grouping a plurality of field names.
Optionally, the web front end further comprises an input module, and the input module is configured to:
receiving a chart name, a chart type and a chart description selected by a user, wherein the chart type comprises one or more of a column chart, a pie chart, a bar chart, a line chart, a map, a thermodynamic diagram, a funnel diagram, a radar chart, a relation diagram, a box-whisker diagram and a tree diagram.
Optionally, the display module is configured to:
and sending the report data to the web front end so that the web front end generates a visual report according to the chart name, the chart type and the chart description and displays the visual report on a web interface.
In a third aspect, an embodiment of the present invention provides a terminal device, including: at least one processor and memory;
the memory stores a computer program; the at least one processor executes the computer program stored in the memory to implement the method for generating the visual report provided in 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 in the computer-readable storage medium, and when the computer program is executed, the method for generating a visual report provided in the first aspect is implemented.
The embodiment of the invention has the following advantages:
according to the method, the device, the terminal equipment and the storage medium for generating the visual report, the configuration information of the visual report, which is sent by the web front end, is obtained, wherein the configuration information comprises a destination field list, a destination condition list and destination grouping information; generating an SQL file by the target field list, the target condition list and the target grouping information, wherein the SQL file comprises target searching conditions; according to the target searching condition, searching report data corresponding to the target searching condition in a pre-established database; and sending the report data to the web front end so that the web front end generates the report data into a visual report and displays the visual report on a web interface, thereby improving the report generation efficiency.
Drawings
FIG. 1 is a flowchart illustrating steps of a method for generating a visual report according to an embodiment of the present invention;
FIG. 2 is a flowchart illustrating the steps of another embodiment of a method for generating a visual report according to the present invention;
FIG. 3 is a flowchart illustrating the steps of a method for generating a visual report according to another embodiment of the present invention;
FIG. 4 is a block diagram illustrating an embodiment of a visual report generation apparatus according to the present invention;
fig. 5 is a schematic structural diagram of a terminal device 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 only a part of the embodiments of the present invention, and not all of the embodiments. 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.
An embodiment of the present invention provides a method for generating a visual report, which is used for automatically generating a visual report. The execution subject of the embodiment is a generation device of a visual report, and is arranged on a web server.
Referring to fig. 1, a flowchart illustrating steps of an embodiment of a method for generating a visual report according to the present invention is shown, where the method specifically includes the following steps:
s101, acquiring configuration information of a visual report sent by a web front end, wherein the configuration information comprises a destination field list, a destination condition list and destination grouping information;
specifically, the embodiment of the present invention provides a web server and a web front end, where a user may select a destination field list, a destination condition list, and destination group information on the web front end, where the user wants to generate a visual report, and the web front end generates configuration information from the destination field list, the destination condition list, and the destination group information, and sends the configuration information to the web server.
It should be noted that there are many ways for the user to determine the destination field list, the destination condition list, and the destination grouping information on the web front end, for example, the user may select the destination field list, the destination condition list, and the destination grouping information through dragging, or the user may determine the destination condition list through inputting information, or select the destination grouping information through an option box, which is not specifically limited in the embodiment of the present invention.
S102, generating an SQL file by the target field list, the target condition list and the target grouping information, wherein the SQL file comprises a target searching condition;
specifically, the web server receives configuration information sent by the web front end through the API interface, analyzes the configuration information, obtains a destination field list, a destination condition list and destination grouping information, and generates an SQL file from the destination field list, the destination condition list and the destination grouping information, where the SQL file includes SQL statements and destination search conditions.
S103, searching report data corresponding to the target searching condition in a pre-established database according to the target searching condition;
specifically, the web server searches report data corresponding to the target searching condition in a pre-established database according to the target searching condition;
exemplarily, if the pre-established database is a database of examination scores of students, the database comprises field names such as names, classes, languages, mathematics, English, score sums and the like, and each field corresponds to a different numerical value;
if the configuration information is that the first group comprises student names and language scores, the second group comprises student names and mathematics scores, the target search condition is the student name (and) language scores and the student name (and) mathematics scores, the web server searches in a pre-established database of student examination scores according to the student name (and) language scores and the student name (and) mathematics scores, and the numerical values of the student names and the student scores, namely report data, respectively correspond to the student name (and) language scores and the student name (and) mathematics scores.
And S104, sending the report data to the web front end so that the web front end generates a visual report from the report data and displays the visual report on a web interface.
Specifically, the web server sends report data, namely numerical values of names and Chinese achievements of students and numerical values of names and mathematical achievements of students to the web front end, the web front end generates visual reports of the numerical values of the names and the Chinese achievements of the students and the numerical values of the names and the mathematical achievements of the students, and the visual reports are displayed on a web interface and can be column diagrams, pie charts, bar charts, line graphs and the like.
The method for generating the visual report, provided by the embodiment of the invention, comprises the steps of obtaining configuration information of the visual report, which is sent by a web front end, wherein the configuration information comprises a destination field list, a destination condition list and destination grouping information; generating an SQL file by the target field list, the target condition list and the target grouping information, wherein the SQL file comprises target searching conditions; according to the target searching condition, searching report data corresponding to the target searching condition in a pre-established database; and sending the report data to the web front end so that the web front end generates the report data into a visual report and displays the visual report on a web interface, thereby improving the report generation efficiency.
The embodiment of the present invention further provides a supplementary description on the method for generating a visual report provided in the above embodiment.
As shown in fig. 2, a flowchart illustrating steps of another embodiment of a method for generating a visual report according to the present invention is shown, where the method for generating a visual report includes:
s201, receiving a chart name, a chart type and a chart description selected by a user by the web front end, wherein the chart type comprises one or more of a column chart, a pie chart, a bar chart, a line chart, a map, a thermodynamic diagram, a funnel diagram, a radar chart, a relation diagram, a box and whisker diagram and a tree diagram.
The chart name is the name of the visual chart, the chart description is the simple introduction of the chart, the icon type comprises one or more of a column chart, a pie chart, a bar chart, a line chart, a map, a thermodynamic diagram, a funnel diagram, a radar chart, a relation diagram, a box and whisker diagram and a tree diagram, and the user can select the icon type according to the needs.
S202, acquiring configuration information of a visual report sent by a web front end, wherein the configuration information comprises a destination field list, a destination condition list and destination grouping information;
specifically, the destination field list includes each field name, an operator and an initial input value in a pre-established database, wherein the operator at least includes equal to, not equal to, less than, not less than, greater than, not greater than, including, not including, and whether empty;
or the destination field list includes an arithmetic expression.
The destination condition list comprises each field name, an operator and an initial input value in a pre-established database, wherein the operator at least comprises one of equal to, unequal to, less than, not less than, greater than, not greater than, containing, not containing and empty.
The destination grouping information is used for grouping a plurality of field names.
Specifically, the field selection logic method: firstly, acquiring the existing fields of the database through a request interface, selecting the names of the returned database fields, continuously selecting an operator, inputting the value of a condition, and repeating the steps, wherein the operator has the relation of equal to, not equal to, less than, not less than, more than, not more than, containing, not containing, empty or the like, and the relation between the operator and the operator can be (or and). Arithmetic expressions can also be selected, and an alias can be set for the combination to achieve the purpose of sharing, and finally, the field to be displayed finally is generated.
Conditional select logic list: as with the above field selection, the only difference is that an arithmetic expression cannot be selected.
Grouping logic: multiple fields are selected for grouping.
S203, generating an SQL file by the target field list, the target condition list and the target grouping information, wherein the SQL file comprises a target searching condition;
s204, searching report data corresponding to the target searching condition in a pre-established database according to the target searching condition;
since steps S203 to S204 are the same as steps S102 and S103 in the embodiment shown in fig. 1. Step S102 to step S103 have already been described in detail in fig. 1, and therefore step S203 to step S204 will not be described again here.
S205, sending the report data to the web front end so that the web front end generates a visual report according to the chart name, the chart type and the chart description and displays the visual report on a web interface.
Specifically, after receiving report data returned by the web server, the web front end generates a visual report, such as a bar chart, a pie chart, a bar chart, a line chart, a map, a thermodynamic diagram, a funnel diagram, a radar chart, a relationship diagram, a box and whisker diagram, a tree diagram and the like, from the report data according to a chart type input by a user in advance, and displays the visual report on a web interface.
Fig. 3 is a flowchart illustrating steps of a method for generating a visual report according to another embodiment of the present invention, as shown in fig. 3, the method includes:
1. selecting a field list on a web front end;
2. selecting a list of conditions on a web front end;
3. selecting grouping information on a web front end;
4. the web front end generates configuration information from the field list, the condition list and the grouping information;
5. the web front end sends the configuration information to a web server, namely a background;
6. the web server generates an SQL file from the field list, the condition list and the grouping information, wherein the SQL file comprises a target search condition;
7. the web server searches report data corresponding to the target searching condition in a pre-established database according to the target searching condition;
8. the web server sends the report data to a web front end, namely a web page;
9. and the web front end automatically generates a visual chart from the returned report data.
The whole process can automatically generate various required reports only by configuring the reports on the web pages.
It should be noted that, for simplicity of description, the method embodiments are described as a series of acts or combination of acts, but those skilled in the art will recognize that the present invention is not limited by the illustrated order of acts, as some steps may occur in other orders or concurrently in accordance with the embodiments of the present invention. Further, those skilled in the art will appreciate that the embodiments described in the specification are presently preferred and that no particular act is required to implement the invention.
The method for generating the visual report, provided by the embodiment of the invention, comprises the steps of obtaining configuration information of the visual report, which is sent by a web front end, wherein the configuration information comprises a destination field list, a destination condition list and destination grouping information; generating an SQL file by the target field list, the target condition list and the target grouping information, wherein the SQL file comprises target searching conditions; according to the target searching condition, searching report data corresponding to the target searching condition in a pre-established database; and sending the report data to the web front end so that the web front end generates the report data into a visual report and displays the visual report on a web interface, thereby improving the report generation efficiency.
Another embodiment of the present invention provides a device for generating a visual report, which is used to execute the method for generating a visual report provided in the foregoing embodiment.
Referring to fig. 4, a block diagram of a structure of an embodiment of a device for generating a visual report according to the present invention is shown, where the device may specifically include the following modules: an obtaining module 401, a generating module 402, a searching module 403 and a displaying module 404, wherein:
the obtaining module 401 is configured to obtain configuration information of a visual report sent by a web front end, where the configuration information includes a destination field list, a destination condition list, and destination grouping information;
the generating module 402 is configured to generate an SQL file from the destination field list, the destination condition list, and the destination grouping information, where the SQL file includes a destination search condition;
the searching module 403 is configured to search, according to the target searching condition, report data corresponding to the target searching condition in a pre-established database;
the display module 404 is configured to send the report data to the web front end, so that the web front end displays the report data on a web interface.
The device for generating the visual report, provided by the embodiment of the invention, acquires the configuration information of the visual report, which is sent by a web front end, wherein the configuration information comprises a destination field list, a destination condition list and destination grouping information; generating an SQL file by the target field list, the target condition list and the target grouping information, wherein the SQL file comprises target searching conditions; according to the target searching condition, searching report data corresponding to the target searching condition in a pre-established database; and sending the report data to the web front end so that the web front end generates the report data into a visual report and displays the visual report on a web interface, thereby improving the report generation efficiency.
The present invention further provides a supplementary description of the apparatus for generating a visual report according to the foregoing embodiment.
Optionally, the destination field list includes each field name, an operator and an initial input value in a pre-established database, where the operator at least includes equal to, not equal to, less than, not less than, greater than, not greater than, including, not including, and whether empty; or the destination field list includes an arithmetic expression.
Optionally, the destination condition list includes each field name, an operator and an initial input value in a pre-established database, wherein the operator at least includes equal to, not equal to, less than, not less than, greater than, not greater than, including, not including, or whether empty.
Optionally, the destination grouping information is used for grouping a plurality of field names.
Optionally, the web front end further comprises an input module, and the input module is configured to:
receiving a chart name, a chart type and a chart description selected by a user, wherein the chart type comprises one or more of a column chart, a pie chart, a bar chart, a line chart, a map, a thermodynamic diagram, a funnel diagram, a radar chart, a relation diagram, a box-whisker diagram and a tree diagram.
Optionally, the display module is configured to:
and sending the report data to the web front end so that the web front end generates a visual report according to the chart name, the chart type and the chart description and displays the visual report on a web interface.
It should be noted that the respective implementable modes in the present embodiment may be implemented individually, or may be implemented in combination in any combination without conflict, and the present application is not limited thereto.
For the device embodiment, since it is basically similar to the method embodiment, the description is simple, and for the relevant points, refer to the partial description of the method embodiment.
The device for generating the visual report, provided by the embodiment of the invention, acquires the configuration information of the visual report, which is sent by a web front end, wherein the configuration information comprises a destination field list, a destination condition list and destination grouping information; generating an SQL file by the target field list, the target condition list and the target grouping information, wherein the SQL file comprises target searching conditions; according to the target searching condition, searching report data corresponding to the target searching condition in a pre-established database; and sending the report data to the web front end so that the web front end generates the report data into a visual report and displays the visual report on a web interface, thereby improving the report generation efficiency.
Another embodiment of the present invention provides a terminal device, configured to execute the method for generating a visual report provided in the foregoing embodiment.
Fig. 5 is a schematic structural diagram of a terminal device of the present invention, and as shown in fig. 5, the terminal device includes: at least one processor 501 and memory 502;
the memory stores a computer program; the at least one processor executes the computer program stored in the memory to implement the method for generating the visual report provided by the above embodiment.
The terminal device provided by this embodiment acquires configuration information of a visual report sent by a web front end, where the configuration information includes a destination field list, a destination condition list, and destination grouping information; generating an SQL file by the target field list, the target condition list and the target grouping information, wherein the SQL file comprises target searching conditions; according to the target searching condition, searching report data corresponding to the target searching condition in a pre-established database; and sending the report data to the web front end so that the web front end generates the report data into a visual report and displays the visual report on a web interface, thereby improving the report generation efficiency.
Yet another embodiment of the present application provides a computer-readable storage medium, in which a computer program is stored, and when the computer program is executed, the method for generating a visual report provided in any of the above embodiments is implemented.
According to the computer-readable storage medium of the embodiment, the configuration information of the visual report sent by the web front end is obtained, wherein the configuration information comprises a destination field list, a destination condition list and destination grouping information; generating an SQL file by the target field list, the target condition list and the target grouping information, wherein the SQL file comprises target searching conditions; according to the target searching condition, searching report data corresponding to the target searching condition in a pre-established database; and sending the report data to the web front end so that the web front end generates the report data into a visual report and displays the visual report on a web interface, thereby improving the report generation efficiency.
The embodiments in the present specification are described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments are referred to each other.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, apparatus, or computer program product. Accordingly, embodiments of the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, embodiments of the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
Embodiments of the present invention are described with reference to flowchart illustrations and/or block diagrams of methods, electronic devices (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing electronic device to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing electronic device, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing electronic devices to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing electronic device to cause a series of operational steps to be performed on the computer or other programmable electronic device to produce a computer implemented process such that the instructions which execute on the computer or other programmable electronic device provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
While preferred embodiments of the present invention have been described, additional variations and modifications of these embodiments may occur to those skilled in the art once they learn of the basic inventive concepts. Therefore, it is intended that the appended claims be interpreted as including preferred embodiments and all such alterations and modifications as fall within the scope of the embodiments of the invention.
Finally, it should also be noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or electronic device that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or electronic device. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or electronic device that comprises the element.
The method for generating a visual report and the device for generating a visual report provided by the invention are described in detail, and a specific example is applied in the text to explain the principle and the implementation mode of the invention, and the description of the above embodiment is only used for helping to understand the method and the core idea of the invention; meanwhile, for a person skilled in the art, according to the idea of the present invention, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present invention.
Claims (10)
1. A method for generating a visual report is characterized by comprising the following steps:
acquiring configuration information of a visual report sent by a web front end, wherein the configuration information comprises a destination field list, a destination condition list and destination grouping information;
generating an SQL file by the target field list, the target condition list and the target grouping information, wherein the SQL file comprises a target searching condition;
according to the target searching condition, searching report data corresponding to the target searching condition in a pre-established database;
and sending the report data to the web front end so that the web front end generates a visual report from the report data and displays the visual report on a web interface.
2. The method of claim 1, wherein the destination field list comprises field names, operators and initial input values in a pre-established database, wherein the operators comprise at least one of equal to, unequal to, less than, greater than, not greater than, containing, not containing, and empty;
or the destination field list includes an arithmetic expression.
3. The method of claim 1, wherein the destination condition list comprises field names, operators and initial input values in a pre-established database, wherein the operators comprise at least equal to, not equal to, less than, not less than, greater than, not greater than, including, not including, or not empty.
4. The method according to claim 2 or 3, wherein the destination grouping information is used for grouping a plurality of field names.
5. The method of claim 1, further comprising:
the web front end receives a user selected chart name, chart type and chart description, wherein the chart type comprises one or more of a bar graph, a pie graph, a bar graph, a line graph, a map, a thermodynamic diagram, a funnel graph, a radar chart, a relational graph, a box and whisker diagram and a tree diagram.
6. The method of claim 5, wherein sending the reporting data to the web front end to enable the web front end to generate a visual report from the reporting data and display the visual report on a web interface comprises:
and sending the report data to the web front end so that the web front end generates a visual report according to the chart name, the chart type and the chart description and displays the visual report on a web interface.
7. An apparatus for generating a visual report, the apparatus comprising:
the system comprises an acquisition module, a display module and a display module, wherein the acquisition module is used for acquiring configuration information of a visual report sent by a web front end, and the configuration information comprises a destination field list, a destination condition list and destination grouping information;
the generating module is used for generating the target field list, the target condition list and the target grouping information into an SQL file, wherein the SQL file comprises a target searching condition;
the searching module is used for searching report data corresponding to the target searching condition in a pre-established database according to the target searching condition;
and the display module is used for sending the report data to the web front end so that the web front end displays the report data on a web interface.
8. The apparatus of claim 7, wherein the destination field list comprises field names, operators and initial input values in a pre-established database, wherein the operators comprise at least one of equal to, not equal to, less than, not less than, greater than, not greater than, including, not including, and being empty; or the destination field list includes an arithmetic expression.
9. A terminal device, comprising: at least one processor and memory;
the memory stores a computer program; the at least one processor executes the memory-stored computer program to implement the method of generating a visual report of any of claims 1-6.
10. A computer-readable storage medium, characterized in that a computer program is stored in the computer-readable storage medium, which when executed implements the method for generating a visual report according to any one of claims 1-6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010743057.6A CN111967234A (en) | 2020-07-29 | 2020-07-29 | Visual report generation method and device, terminal equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010743057.6A CN111967234A (en) | 2020-07-29 | 2020-07-29 | Visual report generation method and device, terminal equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111967234A true CN111967234A (en) | 2020-11-20 |
Family
ID=73363450
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010743057.6A Pending CN111967234A (en) | 2020-07-29 | 2020-07-29 | Visual report generation method and device, terminal equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111967234A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113705183A (en) * | 2021-07-16 | 2021-11-26 | 厦门海迈科技股份有限公司 | Web service-oriented electronic form data generation and maintenance method and related equipment |
| CN114219873A (en) * | 2021-12-10 | 2022-03-22 | 中国建设银行股份有限公司 | Chart drawing method and device, electronic equipment and computer storage medium |
| CN114238724A (en) * | 2021-12-23 | 2022-03-25 | 中国建设银行股份有限公司 | Data visualization method and device |
| CN115826928A (en) * | 2022-12-20 | 2023-03-21 | 东方邦信金融科技(上海)有限公司 | Program generation method, system, electronic device, and computer-readable storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105843945A (en) * | 2016-04-08 | 2016-08-10 | 联动优势科技有限公司 | Report generation method and system |
| CN110717319A (en) * | 2019-09-24 | 2020-01-21 | 车智互联（北京）科技有限公司 | Self-service report generation method and device, computing equipment and system |
-
2020
- 2020-07-29 CN CN202010743057.6A patent/CN111967234A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105843945A (en) * | 2016-04-08 | 2016-08-10 | 联动优势科技有限公司 | Report generation method and system |
| CN110717319A (en) * | 2019-09-24 | 2020-01-21 | 车智互联（北京）科技有限公司 | Self-service report generation method and device, computing equipment and system |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113705183A (en) * | 2021-07-16 | 2021-11-26 | 厦门海迈科技股份有限公司 | Web service-oriented electronic form data generation and maintenance method and related equipment |
| CN113705183B (en) * | 2021-07-16 | 2024-09-20 | 厦门海迈科技股份有限公司 | Web service-oriented electronic form data generation and maintenance method and related equipment |
| CN114219873A (en) * | 2021-12-10 | 2022-03-22 | 中国建设银行股份有限公司 | Chart drawing method and device, electronic equipment and computer storage medium |
| CN114238724A (en) * | 2021-12-23 | 2022-03-25 | 中国建设银行股份有限公司 | Data visualization method and device |
| CN115826928A (en) * | 2022-12-20 | 2023-03-21 | 东方邦信金融科技(上海)有限公司 | Program generation method, system, electronic device, and computer-readable storage medium |
| CN115826928B (en) * | 2022-12-20 | 2024-03-22 | 东方邦信金融科技(上海)有限公司 | Program generating method, system, electronic device and computer readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111967234A (en) | Visual report generation method and device, terminal equipment and storage medium | |
| Rastkar et al. | Generating natural language summaries for crosscutting source code concerns | |
| KR20180041200A (en) | Information processing method and apparatus | |
| Milev | Conceptual approach for development of web scraping application for tracking information | |
| US9195456B2 (en) | Managing a catalog of scripts | |
| US8458187B2 (en) | Methods and systems for visualizing topic location in a document redundancy graph | |
| US10599760B2 (en) | Intelligent form creation | |
| US9779135B2 (en) | Semantic related objects | |
| Tosadori et al. | Creating, generating and comparing random network models with NetworkRandomizer | |
| CN103646122A (en) | Picture identification method based on drag picture, picture identification system based on drag picture, picture identification equipment based on drag picture and picture identification device based on drag picture | |
| CN111881664A (en) | Information extraction method, device, equipment and medium combining RPA and AI | |
| CN111309371A (en) | Query method and device | |
| CN109471935B (en) | Questionnaire survey object determining method and device, electronic equipment and storage medium | |
| CN111488368A (en) | Data query method and device and electronic equipment | |
| JP2019528522A (en) | Task processing method and distributed computing framework | |
| CN111368011B (en) | Knowledge graph construction method and device, computer equipment and medium | |
| Bo et al. | Towards an efficient searching approach of ros message by knowledge graph | |
| CN112685282B (en) | Test method, test device, electronic equipment and computer readable storage medium | |
| CN103995895A (en) | Image recognition method and device based on image | |
| CN109101473B (en) | Method and apparatus for processing two-dimensional data table | |
| CN114037493A (en) | Method and system for generating bidding document | |
| CN113656443B (en) | Data disassembling method and device, electronic equipment and storage medium | |
| CN108763474B (en) | Method, device and storage medium for acquiring transaction correlation and executing regression test | |
| CN112988986A (en) | Man-machine interaction method, device and equipment | |
| CN111930959A (en) | Method and device for generating text by using map knowledge |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |