CN110222321A - Report form generation method, device, computer installation and computer readable storage medium - Google Patents
Report form generation method, device, computer installation and computer readable storage medium Download PDFInfo
- Publication number
- CN110222321A CN110222321A CN201910306025.7A CN201910306025A CN110222321A CN 110222321 A CN110222321 A CN 110222321A CN 201910306025 A CN201910306025 A CN 201910306025A CN 110222321 A CN110222321 A CN 110222321A
- Authority
- CN
- China
- Prior art keywords
- report
- template
- query
- query conditions
- frame
- 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
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
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The present invention provides a kind of report form generation method, device, computer installation and computer readable storage medium.The report form generation method includes: to establish report template, and show logical message for each display module configuration in the report template, wherein the report template includes multiple and different display modules for showing pattern；Configure multiple report query conditions frames and query logic corresponding with multiple report query conditions frames；Report generation instruction is received, and obtains the input content of each report query conditions frame according to report generation instruction；Target report corresponding with report generation instruction is generated according to the input content of the report query conditions frame of acquisition and the report template.The present invention relates to data display technique, it can be achieved that Suresh Kumar mixing is presented in report shows function, user experience is promoted.
Description
Technical field
The present invention relates to technical field of data processing more particularly to a kind of report form generation method, device, computer installation and
Computer readable storage medium.
Background technique
Report is indispensable a kind of data exhibiting mode in office application system, it can be provided intuitively for user
Data View, makes a plan for user and provides basis and foundation with decision, and report is also to realize number in business intelligence application simultaneously
According to one of visual mode.There are various reporting systems in the industry at present, these reporting systems generally support user to customize single WEB
The function that table or single figure are shown, bandwagon effect are single.
Summary of the invention
In view of above-mentioned, the present invention provides a kind of report form generation method, device, computer installation and computer-readable storage medium
Matter can realize that mixing shows function, promote user experience.
One embodiment of the application provides a kind of report form generation method, which comprises
Report template is established, and shows logical message for each display module configuration in the report template, wherein institute
Stating report template includes multiple and different display modules for showing pattern；
Configure multiple report query conditions frames and query logic corresponding with multiple report query conditions frames；
Report generation instruction is received, and the defeated of each report query conditions frame is obtained according to report generation instruction
Enter content；And
It is generated according to the input content of the report query conditions frame of acquisition and the report template and is referred to the report generation
Enable corresponding target report.
Preferably, multiple display modules include table display module, text display module and figure display module.
Preferably, the report query conditions frame includes one or more of: monodrome text box, multivalue text box, when
Between control frame, customized non-SQL radio box, customized SQL radio box, customized non-SQL multiselect frame, customized SQL multiselect frame.
Preferably, the reception report generation instruction, and each report is obtained according to report generation instruction and is looked into
Before the step of asking the input content of condition box further include:
Report generation request is received, and the report generation is requested to carry out purview certification, to jump to default inquiry circle
Face, wherein the default query interface includes multiple report query conditions frames.
Preferably, the report generation instruction includes that report template identifies, the report query conditions frame according to acquisition
Input content and the report template generate and with the step of report generation instruction corresponding target report include:
The input content of the report query conditions frame of the acquisition is sent to presetting database by multithreading to look into
It askes；And
The matched report template generation target report is identified according to query result and with the report template.
Preferably, each thread corresponds each display module.
Preferably, described to identify the matched report template generation target according to query result and with the report template
The step of report includes:
The query result of each display module in the report template is returned into JSP page, and by the JSP
The page is formatted and merging treatment, to generate the target report.
One embodiment of the application provides a kind of report generation device, and described device includes:
Module is established, for establishing report template, and shows and patrols for each display module configuration in the report template
Information is collected, wherein the report template includes multiple display modules；
Configuration module, for configuring multiple report query conditions frames and corresponding with multiple report query conditions frames looking into
Ask logic；
Receiving module obtains each report for receiving report generation instruction, and according to report generation instruction
The input content of querying condition frame；And
Generation module, for according to the input content of the report query conditions frame of acquisition and the report template generates and institute
It states report generation and instructs corresponding target report.
One embodiment of the application provides a kind of computer installation, and the computer installation includes processor and memory,
Several computer programs are stored on the memory, the processor is for when executing the computer program stored in memory
The step of realizing report form generation method as elucidated before.
One embodiment of the application provides a kind of computer readable storage medium, is stored thereon with computer program, described
The step of report form generation method as elucidated before is realized when computer program is executed by processor.
Above-mentioned report form generation method, device, computer installation and computer readable storage medium, it can be achieved that verbal description,
The mixing of the Suresh Kumars such as table, figure shows function, and derived report is made to appear more like a report, and report bandwagon effect is abundant
Multiplicity promotes user experience.
Detailed description of the invention
It, below will be to required in embodiment description in order to illustrate more clearly of the technical solution of embodiment of the present invention
The attached drawing used is briefly described, it should be apparent that, the accompanying drawings in the following description is some embodiments of the present invention, for
For those of ordinary skill in the art, without creative efforts, it can also be obtained according to these attached drawings other
Attached drawing.
Fig. 1 is the step flow chart of report form generation method in one embodiment of the invention.
Fig. 2 is the functional block diagram of report generation device in one embodiment of the invention.
Fig. 3 is computer schematic device in one embodiment of the invention.
Specific embodiment
To better understand the objects, features and advantages of the present invention, with reference to the accompanying drawing and specific real
Applying mode, the present invention will be described in detail.It should be noted that in the absence of conflict, presently filed embodiment and reality
The feature applied in mode can be combined with each other.
In the following description, numerous specific details are set forth in order to facilitate a full understanding of the present invention, described embodiment
Only some embodiments of the invention, rather than whole embodiments.Based on the embodiment in the present invention, this field
Those of ordinary skill's every other embodiment obtained without making creative work, belongs to guarantor of the present invention
The range of shield.
Unless otherwise defined, all technical and scientific terms used herein and belong to technical field of the invention
The normally understood meaning of technical staff is identical.Term as used herein in the specification of the present invention is intended merely to description tool
The purpose of the embodiment of body, it is not intended that in the limitation present invention.
Preferably, report form generation method of the invention is applied in one or more computer installation.The computer
Device is that one kind can be according to the instruction for being previously set or storing, the automatic equipment for carrying out numerical value calculating and/or information processing,
Hardware includes but is not limited to microprocessor, specific integrated circuit (Application Specific Integrated
Circuit, ASIC), programmable gate array (Field-Programmable Gate Array, FPGA), digital processing unit
(Digital Signal Processor, DSP), embedded device etc..
The computer installation can be the calculating such as desktop PC, laptop, tablet computer, server and set
It is standby.The computer installation can carry out people by modes such as keyboard, mouse, remote controler, touch tablet or voice-operated devices with user
Machine interaction.
Embodiment one:
Fig. 1 is the step flow chart of report form generation method preferred embodiment of the present invention.The process according to different requirements,
The sequence of step can change in figure, and certain steps can be omitted.
As shown in fig.1, the report form generation method specifically includes following steps.
Step S11, report template is established, and shows logic letter for each display module configuration in the report template
Breath, wherein the report template includes multiple and different display modules for showing pattern.
In one embodiment, the report template includes multiple display modules, multiple display module have it is multiple not
With pattern is shown, for example, multiple display modules include table display module, text display module and figure display module, in turn
So that the report template has table, the mixing of figure and text shows function.Table display module is for realizing table exhibition
Show function, text display module shows function for realizing static, dynamic text, and image display module is for realizing figure displaying
Function.By configuring the displaying logical message of each display module, to realize the displaying function of each display module.
In one embodiment, when the display module in multiple display modules, which is configured to table, shows function,
That is the data of this module are shown by table, are configured for the display module and are shown that logical message includes showing for its configuration
The information such as position, database and corresponding SQL logic, the inquiry field of SQL is unrestricted, can be compiled according to actual needs
It writes.
In one embodiment, when the display module in multiple display modules, which is configured to figure, shows function,
That is the data of this module are shown by figure, are configured for the display module and are shown that logical message includes configuring figure for it
The information such as display location, graphic style, database and corresponding SQL logic.The graphic style can be cake chart, column
Shape figure, bar chart, circular chart, line chart, scatter plot, tendency chart, radar map, bubble diagram, area-graph etc..SQL logic needs are pressed
It is write according to particular requirement, such as by taking line chart as an example, the first row of SQL statement need to be data set corresponding to X-axis, second
Column need to be the Y-axis data set of first broken line, and third column need to be the Y-axis data set of Article 2 broken line, and so on, such broken line
Figure can show a plurality of broken line.
In one embodiment, when the display module in multiple display modules, which is configured to text, shows function,
That is the data of this module are shown by text, are configured for the display module and are shown that logical message includes textual presentation position
It sets, the information such as text formatting content, database and corresponding SQL logic.Text formatting content can write content of text and
It is inserted into table, font, color, size, alignment thereof etc. can be set in content of text, and the cell in the table of insertion can also be with
Write content of text.Various parameters can be set in text formatting content, all parameters are come out by a SQL Boolean query, are
Unite identification parameter symbol be p { * } or P { * }, " * " number therein can be all English character strings, Chinese character string or
Numeric string, " * " number need as the value of the first row of SQL query logic；Such as when text formatting is two content-defined
Parameter p { month } and p { statistics }, corresponding SQL query logic needs to be select ' month ', 201805union all
Select ' statistics ', 500, then it is exactly 500 that the corresponding value of parameter p { month }, which is exactly the corresponding value of 201805, p { statistics },.
Step S12, multiple report query conditions frames are configured and inquire corresponding with multiple report query conditions frames is patrolled
Volume.
In one embodiment, by configuring multiple report query conditions frames, such user can be defeated according to actual needs
Enter report derived parameter to inquire specific data and generate corresponding target report.For example, multiple report query conditions frame packets
Eight kinds of configurable report query conditions frames are included, are " monodrome text box ", " multivalue text box is separated with comma ", " multivalue text respectively
This frame is separated with ' | ' ", " time control frame ", " customized non-SQL radio box ", " customized SQL radio box ", " customized non-
SQL multiselect frame ", " customized SQL multiselect frame "." the monodrome text box ", " multivalue text box is separated with comma " and " multivalue text
This frame is separated with ' | ' " it supports to directly input text as querying condition.When querying condition is single word, " monodrome is literary for use
This frame " inputs single word, such as " life insurance ".When querying condition is multiple values, it can be used that " multivalue text box is with comma
Separate " or " multivalue text box is separated with ' | ' " input multiple words, such as input " life insurance, vehicle insurance " to " multivalue text box with
Comma separates ", or input " life insurance | vehicle insurance " is to " multivalue text box is separated with ' | ' "." multivalue text box is separated with comma " with
" multivalue text box is separated with ' | ' " function is identical, and difference is only that the separator of word is different." the time control frame " indicates
The condition of inquiry is time text formatting, and the pop-up of meeting having time control selects the specific period for user when user clicks, such as
Query time: 2018-01-01~2018-01-31 is selected by " the time control frame ".
" the customized SQL radio box " and " customized SQL multiselect frame " indicates that the pattern of this querying condition is combobox,
The list sources of combobox intermediate value can be to customize by sql like language from database in another data source configuration interface and look into automatically
It askes out, it is single choice combobox that " customized SQL radio box " and " customized SQL multiselect frame " difference, which is one, the other is more
Select combobox." the customized non-SQL radio box " and " customized non-SQL multiselect frame " equally indicates the pattern of this querying condition
It is combobox, the list sources of combobox intermediate value are to be separated in another data source configuration interface by text mode with comma
, it is single choice combobox that the difference of " customized non-SQL radio box " and " customized non-SQL multiselect frame ", which is one, the other is
Multiselect combobox.Configuration in the data source configuration interface can be associated with by multiple report templates to be used.
In one embodiment, the query logic defines two kinds of variable s { * } (either S { * }) and m { * } (or M
{ * }), s { * } (perhaps S { * }) indicates that single choice m { * } (or M { * }) indicates multiselect, and " * " number therein can be English character
String, Chinese character string or numeric string, it is corresponding with each report condition query frame by the way that two kinds of variable variables are arranged
Relationship, so that report query conditions frame is corresponding with query logic.
Step S13 receives report generation instruction, and obtains each report query item according to report generation instruction
The input content of part frame.
In one embodiment, the foundation of report template and the configuration of report query conditions frame can be completed in Web page.
It establishes completing template with postponing, user can inquire in Web page and generate report.It can receive a report generation
Request, and to the report generation request carry out purview certification (such as report generation request packet contain user log in identity information,
By carrying out purview certification to identity information), and default query interface is jumped to after certification passes through, wherein the default inquiry
Interface includes multiple report query conditions frames.Querying condition can be inputted or selected in the report query conditions frame
Content clicks report generation button, triggering report generation instruction, and then can be instructed according to the report generation and obtain each institute
State the input content of report query conditions frame.
In one embodiment, the report generation instruction includes report template identification information, passes through the report template
Identification information can determine the selected Reports module of this report generation.The report template identification information can uniquely determine
One report template.
Step S14, it is generated and the report according to the input content of the report query conditions frame of acquisition and the report template
Table, which generates, instructs corresponding target report.
It in one embodiment, can be by the report query conditions frame of the acquisition in order to save the report generation time
Input content by multithreading be sent to presetting database carry out parallel query, further according to query result and with the report template
It identifies matched report template and generates the target report.
In one embodiment, each thread corresponds each display module.For example, when selected report
Module includes that parallel query is then carried out using five threads there are five display module, saves the report generation time.Utilize multithreading
When being inquired, the query result of each display module in the report template can be returned into JSP page (Java
Server Pages, the java server page), and be formatted by the JSP page and merging treatment, to generate the mesh
Mark report.
For example, when needing to generate report, inquiry item can be inputted or selected in the report query conditions frame
Part content clicks report generation button, and report generation device passes through AJAX (Asynchronous Javascript And at this time
XML, asynchronous JavaScript and XML) content in report generation instruction and report query conditions frame is sent to SPRING
MVC frame, SPRING MVC frame are gone to replace the SQL of each display module with the value of the content in report query conditions frame
In variable, and the SQL query logic of all display modules is distributed to multiple threads, each thread is again by data inquiry request
It is sent to MYBATIS frame, parallel query, all threads such as report generation device are carried out by the presetting database thread pool
After being carried out, then unify query result to be returned to JSP page, and be formatted processing by JSP page and be merged into
It shows together, forms the target report.
Above-mentioned report form generation method makes to export, it can be achieved that the Suresh Kumars such as verbal description, table, figure mixing displaying function
Report appear more like a report, report bandwagon effect is rich and varied, promoted user experience.
Embodiment two:
Fig. 2 is the functional block diagram of report generation device preferred embodiment of the present invention.
As shown in fig.2, the report generation device 10 may include establishing module 101, configuration module 102, receiving mould
Block 103 and generation module 104.
The module 101 of establishing is each display module configuration in the report template for establishing report template
Logical message is shown, wherein the report template includes multiple and different display modules for showing pattern.
In one embodiment, the report template includes multiple display modules, multiple display module have it is multiple not
With pattern is shown, for example, multiple display modules include table display module, text display module and figure display module, in turn
So that the report template has table, the mixing of figure and text shows function.Table display module is for realizing table exhibition
Show function, text display module shows function for realizing static, dynamic text, and image display module is for realizing figure displaying
Function.By configuring the displaying logical message of each display module, to realize the displaying function of each display module.
In one embodiment, when the display module in multiple display modules, which is configured to table, shows function,
That is the data of this module are shown by table, are configured for the display module and are shown that logical message includes showing for its configuration
The information such as position, database and corresponding SQL logic, the inquiry field of SQL is unrestricted, can be compiled according to actual needs
It writes.
In one embodiment, when the display module in multiple display modules, which is configured to figure, shows function,
That is the data of this module are shown by figure, are configured for the display module and are shown that logical message includes configuring figure for it
The information such as display location, graphic style, database and corresponding SQL logic.The graphic style can be cake chart, column
Shape figure, bar chart, circular chart, line chart, scatter plot, tendency chart, radar map, bubble diagram, area-graph etc..SQL logic needs are pressed
It is write according to particular requirement, such as by taking line chart as an example, the first row of SQL statement need to be data set corresponding to X-axis, second
Column need to be the Y-axis data set of first broken line, and third column need to be the Y-axis data set of Article 2 broken line, and so on, such broken line
Figure can show a plurality of broken line.
In one embodiment, when the display module in multiple display modules, which is configured to text, shows function,
That is the data of this module are shown by text, are configured for the display module and are shown that logical message includes textual presentation position
It sets, the information such as text formatting content, database and corresponding SQL logic.Text formatting content can write content of text and
It is inserted into table, font, color, size, alignment thereof etc. can be set in content of text, and the cell in the table of insertion can also be with
Write content of text.Various parameters can be set in text formatting content, all parameters are come out by a SQL Boolean query, are
Unite identification parameter symbol be p { * } or P { * }, " * " number therein can be all English character strings, Chinese character string or
Numeric string, " * " number need as the value of the first row of SQL query logic；Such as when text formatting is two content-defined
Parameter p { month } and p { statistics }, corresponding SQL query logic needs to be select ' month ', 201805union all
Select ' statistics ', 500, then it is exactly 500 that the corresponding value of parameter p { month }, which is exactly the corresponding value of 201805, p { statistics },.
The configuration module 102 for configure multiple report query conditions frames and with multiple report query conditions frames pair
The query logic answered.
In one embodiment, multiple report query conditions frames are configured by the configuration module 102, such user can be with
Input report derived parameter according to actual needs to inquire specific data and generate corresponding target report.For example, multiple reports
Table querying condition frame includes eight kinds of configurable report query conditions frames, is " monodrome text box " respectively, " multivalue text box is with comma
Separate ", " multivalue text box is separated with ' | ' ", " time control frame ", " customized non-SQL radio box ", " customized SQL single choice
Frame ", " customized non-SQL multiselect frame ", " customized SQL multiselect frame "." the monodrome text box ", " multivalue text box is with comma
Separate " and " multivalue text box is separated with ' | ' " support to directly input text as querying condition.When querying condition is single word
Language inputs single word, such as " life insurance " using " monodrome text box ".When querying condition is multiple values, can be used " more
Value text box is separated with comma " or " multivalue text box is separated with ' | ' " input multiple words, such as input " life insurance, vehicle insurance "
To " multivalue text box is separated with comma ", or input " life insurance | vehicle insurance " is to " multivalue text box is separated with ' | ' "." multivalue text box
Separated with comma " it is identical as " multivalue text box is separated with ' | ' " function, difference is only that the separator of word is different.Described " when
Between control frame " indicate that the condition of inquiry is time text formatting, when user clicks can the pop-up of having time control select to have for user
The body period, such as query time: 2018-01-01~2018-01-31 is selected by " the time control frame ".
" the customized SQL radio box " and " customized SQL multiselect frame " indicates that the pattern of this querying condition is combobox,
The list sources of combobox intermediate value can be to customize by sql like language from database in another data source configuration interface and look into automatically
It askes out, it is single choice combobox that " customized SQL radio box " and " customized SQL multiselect frame " difference, which is one, the other is more
Select combobox." the customized non-SQL radio box " and " customized non-SQL multiselect frame " equally indicates the pattern of this querying condition
It is combobox, the list sources of combobox intermediate value are to be separated in another data source configuration interface by text mode with comma
, it is single choice combobox that the difference of " customized non-SQL radio box " and " customized non-SQL multiselect frame ", which is one, the other is
Multiselect combobox.Configuration in the data source configuration interface can be associated with by multiple report templates to be used.
In one embodiment, the query logic defines two kinds of variable s { * } (either S { * }) and m { * } (or M
{ * }), s { * } (perhaps S { * }) indicates that single choice m { * } (or M { * }) indicates multiselect, and " * " number therein can be English character
String, Chinese character string or numeric string, it is corresponding with each report condition query frame by the way that two kinds of variable variables are arranged
Relationship, so that report query conditions frame is corresponding with query logic.
The receiving module 103 obtains each institute for receiving report generation instruction, and according to report generation instruction
State the input content of report query conditions frame.
In one embodiment, the report generation device 10 can Web page complete report template foundation and report
The configuration of table querying condition frame.It establishes completing template with postponing, user can inquire in Web page and generate report
Table.The receiving module 103 can receive report generation request, and request the report generation to carry out purview certification (example
Identity information is logged in as report generation request packet contains user, by carrying out purview certification to identity information), and pass through in certification
After jump to default query interface, wherein the default query interface includes multiple report query conditions frames.In the report
Querying condition content can be inputted or selected in table querying condition frame, click report generation button, triggering report generation instructs,
And then the receiving module 103 can instruct in the input for obtaining each report query conditions frame according to the report generation
Hold.
In one embodiment, the report generation instruction includes report template identification information, passes through the report template
Identification information can determine the selected Reports module of this report generation.The report template identification information can uniquely determine
One report template.
The generation module 104 is used for raw according to the input content of the report query conditions frame of acquisition and the report template
At target report corresponding with report generation instruction.
In one embodiment, in order to save the report generation time, the generation module 104 can be by the report of the acquisition
The input content of table querying condition frame is sent to presetting database by multithreading and carries out parallel query, further according to query result and
Matched report template, which is identified, with the report template generates the target report.
In one embodiment, each thread corresponds each display module.For example, when selected report
Module includes that parallel query is then carried out using five threads there are five display module, saves the report generation time.The generation mould
When block 104 is inquired using multithreading, the query result of each display module in the report template can be returned
Back to JSP page (Java Server Pages, the java server page), and it is formatted and is merged by the JSP page
Processing, to generate the target report.
For example, when needing to generate report, inquiry item can be inputted or selected in the report query conditions frame
Part content clicks report generation button, and the generation module 104 passes through AJAX (Asynchronous Javascript at this time
And XML, asynchronous JavaScript and XML) content in report generation instruction and report query conditions frame is sent to
SPRING MVC frame, SPRING MVC frame are gone to replace each displaying mould with the value of the content in report query conditions frame
Variable in the SQL of block, and the SQL query logic of all display modules is distributed to multiple threads, each thread is again by data
Inquiry request is sent to MYBATIS frame, carries out parallel query, the generation module by the presetting database thread pool
After all threads such as 104 are carried out, then unify query result to return to JSP page, and be formatted by JSP page
It handles and is merged together and show, form the target report.
Above-mentioned report generation device makes to export, it can be achieved that the Suresh Kumars such as verbal description, table, figure mixing displaying function
Report appear more like a report, report bandwagon effect is rich and varied, promoted user experience.
Fig. 3 is the schematic diagram of computer installation preferred embodiment of the present invention.
The computer installation 1 includes memory 20, processor 30 and is stored in the memory 20 and can be in institute
State the computer program 40 run on processor 30, such as report generator.The processor 30 executes the computer journey
The step in above-mentioned report form generation method embodiment, such as step S11~S14 shown in FIG. 1 are realized when sequence 40.The processor
The function of each module in above-mentioned report generation device embodiment is realized when the 30 execution computer program 40, such as in Fig. 2
Module 101~104.
Illustratively, the computer program 40 can be divided into one or more module/units, it is one or
Multiple module/units are stored in the memory 20, and are executed by the processor 30, to complete the present invention.Described one
A or multiple module/units can be the series of computation machine program instruction section that can complete specific function, and described instruction section is used
In implementation procedure of the description computer program 40 in the computer installation 1.For example, the computer program 40 can be with
It is divided into Fig. 2 and establishes module 101, configuration module 102, receiving module 103 and generation module 104.Each specific function of module
It can be referring to embodiment two.
The computer installation 1 can be the calculating such as desktop PC, notebook, palm PC and cloud server and set
It is standby.It will be understood by those skilled in the art that the schematic diagram is only the example of computer installation 1, do not constitute to computer
The restriction of device 1 may include perhaps combining certain components or different components, example than illustrating more or fewer components
Such as described computer installation 1 can also include input-output equipment, network access equipment, bus.
Alleged processor 30 can be central processing unit (Central Processing Unit, CPU), can also be
Other general processors, digital signal processor (Digital Signal Processor, DSP), specific integrated circuit
(Application Specific Integrated Circuit, ASIC), ready-made programmable gate array (Field-
Programmable Gate Array, FPGA) either other programmable logic device, discrete gate or transistor logic,
Discrete hardware components etc..General processor can be microprocessor or the processor 30 is also possible to any conventional processing
Device etc., the processor 30 are the control centres of the computer installation 1, utilize various interfaces and the entire computer of connection
The various pieces of device 1.
The memory 20 can be used for storing the computer program 40 and/or module/unit, and the processor 30 passes through
Operation executes the computer program and/or module/unit being stored in the memory 20, and calls and be stored in memory
Data in 20 realize the various functions of the computer installation 1.The memory 20 can mainly include storing program area and deposit
Store up data field, wherein storing program area can application program needed for storage program area, at least one function (for example sound is broadcast
Playing function, image player function etc.) etc.；Storage data area, which can be stored, uses created data (ratio according to computer installation 1
Such as audio data, phone directory) etc..In addition, memory 20 may include high-speed random access memory, it can also include non-easy
The property lost memory, such as hard disk, memory, plug-in type hard disk, intelligent memory card (Smart Media Card, SMC), secure digital
(Secure Digital, SD) card, flash card (Flash Card), at least one disk memory, flush memory device or other
Volatile solid-state part.
If the integrated module/unit of the computer installation 1 is realized in the form of SFU software functional unit and as independence
Product when selling or using, can store in a computer readable storage medium.Based on this understanding, of the invention
It realizes all or part of the process in above-described embodiment method, can also instruct relevant hardware come complete by computer program
At the computer program can be stored in a computer readable storage medium, and the computer program is held by processor
When row, it can be achieved that the step of above-mentioned each embodiment of the method.Wherein, the computer program includes computer program code, institute
Stating computer program code can be source code form, object identification code form, executable file or certain intermediate forms etc..It is described
Computer-readable medium may include: any entity or device, recording medium, U that can carry the computer program code
Disk, mobile hard disk, magnetic disk, CD, computer storage, read-only memory (ROM, Read-Only Memory), arbitrary access
Memory (RAM, Random Access Memory), electric carrier signal, telecommunication signal and software distribution medium etc..It needs
It is bright, the content that the computer-readable medium includes can according in jurisdiction make laws and patent practice requirement into
Row increase and decrease appropriate, such as do not include electric load according to legislation and patent practice, computer-readable medium in certain jurisdictions
Wave signal and telecommunication signal.
In several embodiments provided by the present invention, it should be understood that disclosed computer installation and method, it can be with
It realizes by another way.For example, computer installation embodiment described above is only schematical, for example, described
The division of unit, only a kind of logical function partition, there may be another division manner in actual implementation.
It, can also be in addition, each functional unit in each embodiment of the present invention can integrate in same treatment unit
It is that each unit physically exists alone, can also be integrated in same unit with two or more units.Above-mentioned integrated list
Member both can take the form of hardware realization, can also realize in the form of hardware adds software function module.
It is obvious to a person skilled in the art that invention is not limited to the details of the above exemplary embodiments, Er Qie
In the case where without departing substantially from spirit or essential attributes of the invention, the present invention can be realized in other specific forms.Therefore, no matter
From the point of view of which point, the present embodiments are to be considered as illustrative and not restrictive, and the scope of the present invention is by appended power
Benefit requires rather than above description limits, it is intended that all by what is fallen within the meaning and scope of the equivalent elements of the claims
Variation is included in the present invention.Any reference signs in the claims should not be construed as limiting the involved claims.This
Outside, it is clear that one word of " comprising " does not exclude other units or steps, and odd number is not excluded for plural number.It is stated in computer installation claim
Multiple units or computer installation can also be implemented through software or hardware by the same unit or computer installation.The
One, the second equal words are used to indicate names, and are not indicated any particular order.
Finally it should be noted that the above examples are only used to illustrate the technical scheme of the present invention and are not limiting, although reference
Preferred embodiment describes the invention in detail, those skilled in the art should understand that, it can be to of the invention
Technical solution is modified or equivalent replacement, without departing from the spirit and scope of the technical solution of the present invention.
Claims (10)
1. a kind of report form generation method, which is characterized in that the described method includes:
Report template is established, and shows logical message for each display module configuration in the report template, wherein the report
Table template includes multiple and different display modules for showing pattern；
Configure multiple report query conditions frames and query logic corresponding with multiple report query conditions frames；
Report generation instruction is received, and is obtained in the input of each report query conditions frame according to report generation instruction
Hold；And
It is generated and report generation instruction pair according to the input content of the report query conditions frame of acquisition and the report template
The target report answered.
2. report form generation method as described in claim 1, which is characterized in that multiple display modules include that table shows mould
Block, text display module and figure display module.
3. report form generation method as described in claim 1, which is characterized in that the report query conditions frame includes following one kind
Or it is a variety of: monodrome text box, multivalue text box, time control frame, customized non-SQL radio box, customized SQL radio box, from
Define non-SQL multiselect frame, customized SQL multiselect frame.
4. report form generation method as claimed in any one of claims 1-3, which is characterized in that the reception report generation refers to
It enables, and is also wrapped before the step of obtaining the input content of each report query conditions frame according to report generation instruction
It includes:
Report generation request is received, and the report generation is requested to carry out purview certification, to jump to default query interface,
Described in preset query interface include multiple report query conditions frames.
5. report form generation method as claimed in any one of claims 1-3, which is characterized in that the report generation, which instructs, includes
Report template mark, the input content of the report query conditions frame according to acquisition and the report template generate and the report
Table generate instruct corresponding target report the step of include:
The input content of the report query conditions frame of the acquisition is sent to presetting database by multithreading to inquire；And
The matched report template generation target report is identified according to query result and with the report template.
6. report form generation method as claimed in claim 5, which is characterized in that each thread corresponds each exhibition
Show module.
7. report form generation method as claimed in claim 5, which is characterized in that it is described according to query result and with the report mould
The matched report template of panel sign generates the step of target report and includes:
The query result of each display module in the report template is returned into JSP page, and by the JSP page
It is formatted and merging treatment, to generate the target report.
8. a kind of report generation device, which is characterized in that described device includes:
Module is established, shows logic letter for establishing report template, and for each display module configuration in the report template
Breath, wherein the report template includes multiple display modules；
Configuration module is patrolled for configuring multiple report query conditions frames and inquire corresponding with multiple report query conditions frames
Volume；
Receiving module obtains each report query for receiving report generation instruction, and according to report generation instruction
The input content of condition box；And
Generation module, for being generated and the report according to the input content of the report query conditions frame of acquisition and the report template
Table, which generates, instructs corresponding target report.
9. a kind of computer installation, the computer installation includes processor and memory, is stored on the memory several
Computer program, which is characterized in that such as right is realized when the processor is for executing the computer program stored in memory
It is required that the step of report form generation method described in any one of 1-7.
10. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the computer program
The step of report form generation method as described in any one of claim 1-7 is realized when being executed by processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910306025.7A CN110222321A (en) | 2019-04-16 | 2019-04-16 | Report form generation method, device, computer installation and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910306025.7A CN110222321A (en) | 2019-04-16 | 2019-04-16 | Report form generation method, device, computer installation and computer readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110222321A true CN110222321A (en) | 2019-09-10 |
Family
ID=67822575
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910306025.7A Pending CN110222321A (en) | 2019-04-16 | 2019-04-16 | Report form generation method, device, computer installation and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110222321A (en) |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110795475A (en) * | 2019-09-24 | 2020-02-14 | 金蝶软件（中国）有限公司 | Report generation method and device, computer equipment and storage medium |
| CN111126026A (en) * | 2019-12-17 | 2020-05-08 | 叮当快药科技集团有限公司 | Method and tool for generating visual report form by analyzing SQL statement |
| CN111259643A (en) * | 2019-12-10 | 2020-06-09 | 深圳市远行科技股份有限公司 | Method and equipment for generating graphical report |
| CN111444696A (en) * | 2020-03-26 | 2020-07-24 | 中国银行股份有限公司 | Report display and editing method and device |
| CN111814441A (en) * | 2020-06-30 | 2020-10-23 | 平安科技（深圳）有限公司 | Report generation method and device, electronic equipment and storage medium |
| CN111881158A (en) * | 2020-07-31 | 2020-11-03 | 平安国际融资租赁有限公司 | Management report data processing method and device, computer system and readable storage medium |
| CN112000702A (en) * | 2020-09-18 | 2020-11-27 | 北京百度网讯科技有限公司 | Processing method and device for template label, electronic equipment and storage medium |
| CN112417836A (en) * | 2020-11-27 | 2021-02-26 | 智业软件股份有限公司 | Automatic table generation method, terminal equipment and storage medium |
| CN112667665A (en) * | 2020-12-31 | 2021-04-16 | 新奥数能科技有限公司 | Method and device for generating SCADA control system report and electronic equipment |
| CN112685435A (en) * | 2020-12-21 | 2021-04-20 | 福建新大陆软件工程有限公司 | Table query method and system based on Vue and Mybatis |
| CN113779941A (en) * | 2021-09-08 | 2021-12-10 | 无锡艾布斯智能科技发展有限公司 | Configurable dynamic report generation device, system and method |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101067786A (en) * | 2007-07-02 | 2007-11-07 | 华为技术有限公司 | Generation method and apparatus for report condition inputting interface |
| CN104778241A (en) * | 2015-04-08 | 2015-07-15 | 北京京东尚科信息技术有限公司 | Report generation method and system |
| CN105843945A (en) * | 2016-04-08 | 2016-08-10 | 联动优势科技有限公司 | Report generation method and system |
| CN106156075A (en) * | 2015-03-31 | 2016-11-23 | 中国科学院声学研究所 | A kind of report generation and the method and device of displaying |
| CN106682218A (en) * | 2016-12-30 | 2017-05-17 | 冶金自动化研究设计院 | Industrial enterprise Web data graphical system and generation method |
| CN107977459A (en) * | 2017-12-19 | 2018-05-01 | 北京小度信息科技有限公司 | Report form generation method and device |
| CN108073661A (en) * | 2016-11-18 | 2018-05-25 | 北京京东尚科信息技术有限公司 | Data retrieval method and device, report generating system and method |
| CN109471890A (en) * | 2018-10-16 | 2019-03-15 | 深圳壹账通智能科技有限公司 | Generation method, terminal device and the medium of report file |
-
2019
- 2019-04-16 CN CN201910306025.7A patent/CN110222321A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101067786A (en) * | 2007-07-02 | 2007-11-07 | 华为技术有限公司 | Generation method and apparatus for report condition inputting interface |
| CN106156075A (en) * | 2015-03-31 | 2016-11-23 | 中国科学院声学研究所 | A kind of report generation and the method and device of displaying |
| CN104778241A (en) * | 2015-04-08 | 2015-07-15 | 北京京东尚科信息技术有限公司 | Report generation method and system |
| CN105843945A (en) * | 2016-04-08 | 2016-08-10 | 联动优势科技有限公司 | Report generation method and system |
| CN108073661A (en) * | 2016-11-18 | 2018-05-25 | 北京京东尚科信息技术有限公司 | Data retrieval method and device, report generating system and method |
| CN106682218A (en) * | 2016-12-30 | 2017-05-17 | 冶金自动化研究设计院 | Industrial enterprise Web data graphical system and generation method |
| CN107977459A (en) * | 2017-12-19 | 2018-05-01 | 北京小度信息科技有限公司 | Report form generation method and device |
| CN109471890A (en) * | 2018-10-16 | 2019-03-15 | 深圳壹账通智能科技有限公司 | Generation method, terminal device and the medium of report file |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110795475A (en) * | 2019-09-24 | 2020-02-14 | 金蝶软件（中国）有限公司 | Report generation method and device, computer equipment and storage medium |
| CN111259643A (en) * | 2019-12-10 | 2020-06-09 | 深圳市远行科技股份有限公司 | Method and equipment for generating graphical report |
| CN111259643B (en) * | 2019-12-10 | 2023-11-28 | 深圳市远行科技股份有限公司 | Method and equipment for generating graphic report |
| CN111126026B (en) * | 2019-12-17 | 2021-10-08 | 叮当快药科技集团有限公司 | Method and tool for generating visual report form by analyzing SQL statement |
| CN111126026A (en) * | 2019-12-17 | 2020-05-08 | 叮当快药科技集团有限公司 | Method and tool for generating visual report form by analyzing SQL statement |
| CN111444696A (en) * | 2020-03-26 | 2020-07-24 | 中国银行股份有限公司 | Report display and editing method and device |
| CN111444696B (en) * | 2020-03-26 | 2024-04-19 | 中国银行股份有限公司 | Report form display and editing method and device |
| CN111814441A (en) * | 2020-06-30 | 2020-10-23 | 平安科技（深圳）有限公司 | Report generation method and device, electronic equipment and storage medium |
| CN111881158A (en) * | 2020-07-31 | 2020-11-03 | 平安国际融资租赁有限公司 | Management report data processing method and device, computer system and readable storage medium |
| CN112000702A (en) * | 2020-09-18 | 2020-11-27 | 北京百度网讯科技有限公司 | Processing method and device for template label, electronic equipment and storage medium |
| CN112000702B (en) * | 2020-09-18 | 2023-07-25 | 北京百度网讯科技有限公司 | Processing method and device for template label, electronic equipment and storage medium |
| CN112417836A (en) * | 2020-11-27 | 2021-02-26 | 智业软件股份有限公司 | Automatic table generation method, terminal equipment and storage medium |
| CN112685435A (en) * | 2020-12-21 | 2021-04-20 | 福建新大陆软件工程有限公司 | Table query method and system based on Vue and Mybatis |
| CN112667665A (en) * | 2020-12-31 | 2021-04-16 | 新奥数能科技有限公司 | Method and device for generating SCADA control system report and electronic equipment |
| CN113779941B (en) * | 2021-09-08 | 2023-07-25 | 无锡艾布斯智能科技发展有限公司 | Configurable dynamic report generation device, system and method |
| CN113779941A (en) * | 2021-09-08 | 2021-12-10 | 无锡艾布斯智能科技发展有限公司 | Configurable dynamic report generation device, system and method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110222321A (en) | Report form generation method, device, computer installation and computer readable storage medium | |
| CN109766097A (en) | UI generation method, device, electronic equipment and computer readable storage medium | |
| CN109614102A (en) | Code automatic generation method, device, electronic equipment and storage medium | |
| CN107341643B (en) | Visual process display method and system | |
| CN105487864A (en) | Method and device for automatically generating code | |
| CN112562284A (en) | Cabinet lattice door opening prompting method and device of intelligent cabinet and electronic equipment | |
| CN110929482B (en) | Questionnaire generation method and system | |
| CN109636301A (en) | Workflow configuration method, system, terminal and the readable storage medium storing program for executing of financial business | |
| CN112527848B (en) | Report data query method, device and system based on multiple data sources and storage medium | |
| CN112307397A (en) | Schedule processing method, device and equipment based on online document and storage medium | |
| CN112558967A (en) | Page automatic generation method and device, electronic equipment and storage medium | |
| CN115618032A (en) | View generation method and device, electronic equipment and storage medium | |
| CN111476007A (en) | Table generation method, table generation device, computer device and computer-readable storage medium | |
| CN111159344A (en) | Robot response method, device, equipment and storage medium | |
| CN109753501A (en) | A kind of data display method of off-line state, device, equipment and storage medium | |
| CN109165180A (en) | A kind of method and system improving source of houses broker operating efficiency | |
| CN109039670A (en) | The sharing method and device of team's configuration method, team's allocation plan | |
| CN116956381A (en) | BIM project data customization form configuration method and device | |
| WO2016201813A1 (en) | Dynamic layout method and system based on android | |
| CN116467004A (en) | Dynamic configuration method and device for application parameters, storage medium and server | |
| CN116089490A (en) | Data analysis method, device, terminal and storage medium | |
| CN109120783A (en) | Information acquisition method and device, mobile terminal and computer readable storage medium | |
| CN110083685B (en) | Data configuration method and device for intention recognition | |
| CN112711936A (en) | Information display method, device, equipment and storage medium | |
| CN108153834B (en) | Method and device for querying data by commercial intelligent application and electronic equipment |
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 |