CN109597845A - Report configuration method, device, computer equipment and storage medium - Google Patents
Report configuration method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN109597845A CN109597845A CN201811236638.XA CN201811236638A CN109597845A CN 109597845 A CN109597845 A CN 109597845A CN 201811236638 A CN201811236638 A CN 201811236638A CN 109597845 A CN109597845 A CN 109597845A
- Authority
- CN
- China
- Prior art keywords
- keyword
- report
- container
- editor
- field
- 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.)
- Granted
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/12—Use of codes for handling textual entities
- G06F40/14—Tree-structured documents
-
- 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
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
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)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses report configuration method, device, computer equipment and storage mediums.This method comprises: obtaining the selected keyword in the keyword container being pre-created by report keyword editor's container, and receive restriction parameter corresponding with selected keyword;Parse included keyword and restriction parameter corresponding with keyword in report keyword editor's container, the corresponding field of report is sequentially produced, by the hypertext markup language code being pre-created according to the sequencing of keyword in report keyword editor's container to generate target report.This method realizes the simplification of report generation process using data processing technique, and report can customize field and quickly generate.
Description
Technical field
The present invention relates to data mart modeling technical field more particularly to a kind of report configuration method, device, computer equipment and
Storage medium.
Background technique
Currently, the Database Engineer of enterprise realizes generally by code when developing data sheet and builds table sum number
According to importing, causes the development process difficulty of report larger and time-consuming more, be not able to satisfy layman's fast custom report
Demand.
Summary of the invention
The embodiment of the invention provides a kind of report configuration method, device, computer equipment and storage mediums, it is intended to solve
Exploitation report is to realize that building table and data imports by code in the prior art, leads to asking more than the big time-consuming of report development difficulty
Topic.
In a first aspect, the embodiment of the invention provides a kind of report configuration methods comprising:
The selected keyword in the keyword container being pre-created is obtained by report keyword editor's container, and is connect
Receive restriction parameter corresponding with selected keyword;
Included keyword and restriction parameter corresponding with keyword in report keyword editor's container are parsed, according to report
The sequencing of keyword sequentially produces report by the hypertext markup language code being pre-created in table keyword editor's container
Corresponding field, to generate target report.
Second aspect, the embodiment of the invention provides a kind of report configuration devices comprising:
Keyword setting unit, for being obtained in the keyword container being pre-created by report keyword editor's container
Selected keyword, and receive restriction parameter corresponding with selected keyword;
Target report generation unit, for parsing keyword and and keyword included in report keyword editor's container
Corresponding restriction parameter, according to the sequencing of keyword in report keyword editor's container by the hypertext markup that is pre-created
Language codes sequentially produce the corresponding field of report, to generate target report.
The third aspect, the embodiment of the present invention provide a kind of computer equipment again comprising memory, processor and storage
On the memory and the computer program that can run on the processor, the processor execute the computer program
Report configuration method described in the above-mentioned first aspect of Shi Shixian.
Fourth aspect, the embodiment of the invention also provides a kind of storage mediums, wherein the storage medium is stored with calculating
Machine program, the computer program make the processor execute report described in above-mentioned first aspect to match when being executed by a processor
Set method.
The embodiment of the invention provides a kind of report configuration method, device, computer equipment and storage mediums.It is being reported
When table is developed, keyword only need to be selected in keyword container and is placed in report keyword editor's container, and to each key
Corresponding restriction parameter is arranged in word, passes through hypertext markup language code later to the field of keyword automatic report generation with life
At target report.The method achieve the simplification of report generation process, and report can customize field and quickly generate.
Detailed description of the invention
Technical solution in order to illustrate the embodiments of the present invention more clearly, below will be to needed in embodiment description
Attached drawing is briefly described, it should be apparent that, drawings in the following description are some embodiments of the invention, general for this field
For logical technical staff, without creative efforts, it is also possible to obtain other drawings based on these drawings.
Fig. 1 is the flow diagram of report configuration method provided in an embodiment of the present invention;
Fig. 2 is another flow diagram of report configuration method provided in an embodiment of the present invention;
Fig. 3 is the sub-process schematic diagram of report configuration method provided in an embodiment of the present invention;
Fig. 4 is another sub-process schematic diagram of report configuration method provided in an embodiment of the present invention;
Fig. 5 is another sub-process schematic diagram of report configuration method provided in an embodiment of the present invention;
Fig. 6 is the schematic block diagram of report configuration device provided in an embodiment of the present invention;
Fig. 7 is another schematic block diagram of report configuration device provided in an embodiment of the present invention;
Fig. 8 is the subelement schematic block diagram of report configuration device provided in an embodiment of the present invention;
Fig. 9 is another subelement schematic block diagram of report configuration device provided in an embodiment of the present invention;
Figure 10 is another subelement schematic block diagram of report configuration device provided in an embodiment of the present invention;
Figure 11 is the schematic block diagram of computer equipment provided in an embodiment of the present invention.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are some of the embodiments of the present invention, instead of all the embodiments.Based on this hair
Embodiment in bright, every other implementation obtained by those of ordinary skill in the art without making creative efforts
Example, shall fall within the protection scope of the present invention.
It should be appreciated that ought use in this specification and in the appended claims, term " includes " and "comprising" instruction
Described feature, entirety, step, operation, the presence of element and/or component, but one or more of the other feature, whole is not precluded
Body, step, operation, the presence or addition of element, component and/or its set.
It is also understood that mesh of the term used in this description of the invention merely for the sake of description specific embodiment
And be not intended to limit the present invention.As description of the invention and it is used in the attached claims, unless on
Other situations are hereafter clearly indicated, otherwise " one " of singular, "one" and "the" are intended to include plural form.
It will be further appreciated that the term "and/or" used in description of the invention and the appended claims is
Refer to any combination and all possible combinations of one or more of associated item listed, and including these combinations.
Referring to Fig. 1, Fig. 1 is the flow diagram of report configuration method provided in an embodiment of the present invention, report configuration
Method is applied in management server or terminal, and this method is carried out by the application software being installed in management server or terminal
It executes, management server is the enterprise terminal for carrying out report configuration, and terminal can be smart phone, tablet computer, pen
Remember that this computer, desktop computer, personal digital assistant and wearable device etc. have the electronic equipment of communication function.
As shown in Figure 1, the method comprising the steps of S101~S102.
S101, the selected key in the keyword container being pre-created is obtained by report keyword editor's container
Word, and receive restriction parameter corresponding with selected keyword.
In the present embodiment, the application scenarios of report configuration method are as follows:
In the corresponding user interface of the application program for automatic report generation developed, at least provided with two
A region, one of region are provided with keyword container, another region is provided with report keyword editor's container.Work as user
When need to quickly generate report, first (keyword is understood that the keyword needed for selecting generation target report in keyword container
For the field in report), selected keyword is then moved to report keyword editor's container, is finally being reported according to user
The hypertext markup language code that table keyword editor's container is directed to the restriction parameter of each keyword setting and is pre-created
Generate target report.Namely during generating target report, user need to only pick out required keyword and for each pass
Keyword setting limits parameter, and processing can be carried out by hypertext markup language code and quickly generates target report, is not necessarily to user
Report is developed by voluntarily writing code.
Wherein, the parameter that limits includes at least the data type of keyword, typing mode, checks that rule and layout are wanted
It asks;For example, first being chosen in keyword container when including this field of order number in the target report that user needs customized generation
This keyword of order number simultaneously moves it into report keyword editor's container, then to order in report keyword editor's container
It is as follows that number this keyword was correspondingly arranged limits parameter: for data type as integer, typing mode is single-line text boxes, check gauge
Then being include three characters of 20 characters and head is DDH, and layout requirements are placed in the middle.By the design method of above-mentioned page formula, make
The development process for obtaining report simplifies, and development difficulty reduces.
In one embodiment, as shown in Fig. 2, before step S101 further include:
S101a, keyword container is pre-created, and corresponding with each keyword in keyword container for generating report
The hypertext markup language code of corresponding field.
In the present embodiment, in the keyword container being pre-created, each keyword can be considered as a field, these words
The source of section can be data set, and can be by hypertext markup language generation for the field in each keyword automatic report generation
Code is realized.
Wherein, data set is one by history service demand information, and data corresponding with history service demand information
The set of fields and data acquisition system that library script counts.
In one embodiment, as shown in figure 3, keyword container is pre-created in step S101a including:
S1001, history service demand information, and database script corresponding with history service demand information are obtained;
S1002, basis database script corresponding with history service demand information, statistics obtains is wrapped in database script
The frequency of each only field and each only field in the script included obtains corresponding with field included in database script
Data set;
S1003, field included in data set is extracted, is placed in keyword container and is stored.
In the present embodiment, the analysis of historical data is carried out to history service demand information and corresponding database script,
It can know that demand end is bigger to the demand of which field.By to database foot corresponding with history service demand information
This is counted, and statistics obtains the frequency of each only field and each only field in script included in database script, is obtained
To data set corresponding with field included in database script.Such as there is " select field name A in database script
This query statement of from tables of data ", the frequency that field name A can be queried add one.And it can basis in the data set
The frequency of only field carries out descending sort, obtains the data set that can intuitively know field frequency.
It is corresponding with each keyword in keyword container for generating the hypertext markup of report corresponding field creating
Language codes (i.e. HTML code), i.e. effect are such as by HTML code to generate table to generate report on web interface
The process of lattice is as follows:
A1) setting unit sound of laughing formula, HTML code are as follows:
td{text-align:center;width:100px;height:30px;}
Wherein text-align:center indicates the text centric alignment of cell, the width of cell be 100 pixels,
Height is 30 pixels;
A2) normal cells lattice pattern is set, such as:
.inp{width:80px;height:26px;font-size:10px;text-align:center;}
Wherein .inp indicates file format, and font-size indicates font size;
A3) table title entry field pattern is set, such as:
.cap{font-size:20px;text-align:center;}
Wherein .inp indicates input rectangle style;
A4) the input rectangle style of the first row of table is set;
A5 row input frame column input frame and region) are transmitted;
A6 line number value) is obtained;
A7 columns value) is obtained;
A8 a table element) is created;
A9) setting table outer rim is all shown;
A10) setting table interior frame is all shown;
A11 the cell commonly arranged) is created.
It can be realized by HTML code and report automatically created according to keyword, and create corresponding field in report, no
The efficiency of report generation is improved only, and reduces the difficulty of report generation.
In one embodiment, as shown in figure 4, receiving restriction ginseng corresponding with selected keyword in step S101
Number, comprising:
S1011, according to the selected keyword, corresponding generation limits the volume of parameter in report keyword editor's container
Collect region;
S1012, reception parameter value corresponding with each sub- restriction parameter in parameter is limited, and fill to corresponding editing area
Domain.
In the present embodiment, keyword container can be placed in the corresponding user behaviour of application program for being used for automatic report generation
Make the region on the left of interface, report keyword editor's container is placed in the corresponding user behaviour of application program for automatic report generation
Make interface zone, the form of Multiline Edit, i.e., corresponding editing area in every a line are set as in report keyword editor's container
A keyword and the editing area for limiting parameter corresponding with the keyword can be accommodated.Wherein, user can take keyword to drag
The keyword selected in keyword container is drawn to report keyword editor's container by the mode dragged, and keyword is entering report
Arrangement mode in table keyword editor's container, the time order and function for being drawn to report keyword editor's container according to keyword are suitable
Sequence is sequentially arranged in from top to bottom in report keyword editor's container, the corresponding pass of every a line in report keyword editor's container
Keyword and its editing area for limiting parameter.
It can be correspondingly arranged the restriction parameter of the row keyword in every a line in report keyword editor's container, such as with
When order number this keyword is set to certain a line of report keyword editor's container by family, the editor of restriction parameter behind
In region, it is integer that data type, which can be set, and typing mode is single-line text boxes, and checking that rule is includes 20 characters and head
Three characters are DDH, layout requirements be it is placed in the middle, when completing the corresponding parameter value of each sub- restriction parameter in setting restriction parameter,
Each sub- restriction parameter is filled into editing area corresponding to the row.By the above-mentioned means, user is during developing report
Keyword and setting qualifications need to be only selected, the rapid configuration of report generation condition can be completed.
In one embodiment, as shown in figure 4, step S101 further include:
If S1013, the son for detecting the presence of non-editing mode limit parameter, the prompt that supplement is filled in is carried out;
S1014, the son for receiving non-editing mode limit the entry values of parameter, and fill to corresponding editing area.
In the present embodiment, it is completed in user and multiple keywords and its matching for restriction parameter is postponed, there is son if it exists
It, need to be in the virtual push button of user's click generation report when limiting non-editing mode (that is to say the state that blank is not edited) in parameter
When, then the prompt that supplement is filled in is carried out to user by way of prompting frame.Once detecting that user's completion is above-mentioned not edit
The son of state limits the entry values of parameter, and the entry values of sub- restriction parameter are filled to corresponding editing area.Pass through above-mentioned side
Formula can effectively avoid qualifications set by user from having the case where omission.
Included keyword and restriction parameter corresponding with keyword in S102, parsing report keyword editor's container,
It is sequentially given birth to according to the sequencing of keyword in report keyword editor's container by the hypertext markup language code being pre-created
At the corresponding field of report, to generate target report.
In the present embodiment, when user complete it is selected generate target report needed for keyword and corresponding with each keyword
Restriction parameter after, sequentially sequentially given birth to by the hypertext markup language code being pre-created according to the sequence that user selectes keyword
At the corresponding field of report, to complete quickly generating for the initialized target report for being not filled by data.
In one embodiment, as shown in figure 5, step S102 includes:
S1021, keyword included in keyword editor container is obtained, is created according to hypertext markup language code is corresponding
Build the initial report including keyword fields all in keyword editor's container;
S1022, restriction parameter corresponding with each keyword is obtained, generates word according to hypertext markup language code is corresponding
The qualifications of section;
S1023, target report is generated according to initial report and the qualifications of field.
In the present embodiment, when generation is not filled by the initialized target report of data, before this according to hypertext markup language
Say that the corresponding creation of code includes the initial report of all keyword fields in keyword editor container, then according to hypertext markup
The corresponding qualifications for generating field of language codes.It is each to be filled to mesh after completing the generation of field and qualifications
The data for marking report can correspond to the qualifications of field corresponding to the cell of filling by it to be detected, and judge the data
It whether is the valid data for meeting qualifications.I.e. by the setting of qualifications, so that the target report generated has data
Function is checked oneself, the filling data for being unsatisfactory for qualifications can be used for quickly detecting.
In one embodiment, as shown in Fig. 2, after step S102 further include:
S103, data query script is generated according to the corresponding field in target report, according to data query script from target
Corresponding data is extracted in database and the corresponding data that generate are inserted into script, and it is corresponding by extracted data to be inserted into script according to data
It fills to target report.
In the present embodiment, after generating target report, each field according to included by target report is one by one
It is corresponding to generate data query script (i.e. SQL script), by querying condition set by data query script by target database
In corresponding data inquire to obtain, later further according to from target database extract corresponding data generate data be inserted into script, by
Data insertion script will be directed into target report by the extracted data of data query script.Such as the A word in target database
Section correspondence shows 100 datas, in the target report created also has A field, by generation with data query function
SQL script, which corresponds to the A field in target database, to be shown after 100 datas all extract by with data insertions function
SQL script fills into target report the corresponding column of A field.Script is inserted by data, and data are inserted into target report automatically
Table, realizes the automation of data processing, and improves data-handling efficiency.
The method achieve when carrying out report exploitation, need to only select keyword in keyword container to be placed in report pass
In keyword editor's container, and corresponding restriction parameter is arranged to each keyword, passes through hypertext markup language code pair later
The field of keyword automatic report generation realizes the simplification of report generation process to generate target report, and report can be certainly
Field is defined to quickly generate.
The embodiment of the present invention also provides a kind of report configuration device, and the report configuration device is for executing aforementioned report configuration
Any embodiment of method.Specifically, referring to Fig. 6, Fig. 6 is the schematic of report configuration device provided in an embodiment of the present invention
Block diagram.The report configuration device 100 can be configured in management server or terminal.
As shown in fig. 6, report configuration device 100 includes keyword setting unit 101 and target report generation unit 102.
Keyword setting unit 101 holds for being obtained by report keyword editor's container in the keyword being pre-created
Selected keyword in device, and receive restriction parameter corresponding with selected keyword.
In the present embodiment, it is described limit parameter include at least the data type of keyword, typing mode, check rule,
And layout requirements;For example, first holding in keyword when including this field of order number in the target report that user needs customized generation
This keyword of order number is chosen in device and moves it into report keyword editor's container, then in report keyword editor's container
In to order number this keyword be correspondingly arranged to limit parameter as follows: for data type as integer, typing mode is single file text
Frame, checking that rule is include three characters of 20 characters and head is DDH, and layout requirements are placed in the middle.Pass through setting for above-mentioned page formula
Meter mode, so that the development process of report simplifies, and development difficulty reduces.
In one embodiment, as shown in fig. 7, report configuration device 100 further include:
Keyword container creating unit 101a, for being pre-created keyword container, and with each pass in keyword container
Keyword is corresponding for generating the hypertext markup language code of report corresponding field.
In the present embodiment, in the keyword container being pre-created, each keyword can be considered as a field, these words
The source of section can be data set, and can be by hypertext markup language generation for the field in each keyword automatic report generation
Code is realized.
Wherein, data set is one by history service demand information, and data corresponding with history service demand information
The set of fields and data acquisition system that library script counts.
In one embodiment, as shown in figure 8, keyword container creating unit 101a includes:
Historic demand information acquisition unit 1001 is believed for obtaining history service demand information, and with history service demand
Cease corresponding database script;
Statistics unit 1002, for according to database script corresponding with history service demand information, statistics to be obtained
The frequency of each only field and each only field in included script, obtains and institute in database script in database script
Including the corresponding data set of field;
Field extraction unit 1003 is placed in keyword container for extracting field included in data set
In stored.
In the present embodiment, the analysis of historical data is carried out to history service demand information and corresponding database script,
It can know that demand end is bigger to the demand of which field.By to database foot corresponding with history service demand information
This is counted, and statistics obtains the frequency of each only field and each only field in script included in database script, is obtained
To data set corresponding with field included in database script.Such as there is " select field name A in database script
This query statement of from tables of data ", the frequency that field name A can be queried add one.And it can basis in the data set
The frequency of only field carries out descending sort, obtains the data set that can intuitively know field frequency.
It is corresponding with each keyword in keyword container for generating the hypertext markup of report corresponding field creating
Language codes (i.e. HTML code), i.e., effect is to generate report on web interface.Root can be realized by HTML code
Report is automatically created according to keyword, and creates corresponding field in report, not only increases the efficiency of report generation, and reduce
The difficulty of report generation.
In one embodiment, as shown in figure 9, keyword setting unit 101, comprising:
Qualifications edit cell 1011, for right in report keyword editor's container according to the selected keyword
The editing area for limiting parameter should be generated;
Qualifications acquiring unit 1012, for receiving parameter value corresponding with each sub- restriction parameter in parameter is limited,
And it fills to corresponding editing area.
In the present embodiment, keyword container can be placed in the corresponding user behaviour of application program for being used for automatic report generation
Make the region on the left of interface, report keyword editor's container is placed in the corresponding user behaviour of application program for automatic report generation
Make interface zone, the form of Multiline Edit, i.e., corresponding editing area in every a line are set as in report keyword editor's container
A keyword and the editing area for limiting parameter corresponding with the keyword can be accommodated.Wherein, user can take keyword to drag
The keyword selected in keyword container is drawn to report keyword editor's container by the mode dragged, and keyword is entering report
Arrangement mode in table keyword editor's container, the time order and function for being drawn to report keyword editor's container according to keyword are suitable
Sequence is sequentially arranged in from top to bottom in report keyword editor's container, the corresponding pass of every a line in report keyword editor's container
Keyword and its editing area for limiting parameter.
It can be correspondingly arranged the restriction parameter of the row keyword in every a line in report keyword editor's container, such as with
When order number this keyword is set to certain a line of report keyword editor's container by family, the editor of restriction parameter behind
In region, it is integer that data type, which can be set, and typing mode is single-line text boxes, and checking that rule is includes 20 characters and head
Three characters are DDH, layout requirements be it is placed in the middle, when completing the corresponding parameter value of each sub- restriction parameter in setting restriction parameter,
Each sub- restriction parameter is filled into editing area corresponding to the row.By the above-mentioned means, user is during developing report
Keyword and setting qualifications need to be only selected, the rapid configuration of report generation condition can be completed.
In one embodiment, as shown in figure 9, keyword setting unit 101 further include:
Non- editing prompt unit 1013 carries out supplement and fills out if the son for detecting the presence of non-editing mode limits parameter
The prompt write;
Non- edit condition fills unit 1014, the son for receiving non-editing mode limits the entry values of parameter, and fills
To corresponding editing area.
In the present embodiment, it is completed in user and multiple keywords and its matching for restriction parameter is postponed, there is son if it exists
It, need to be in the virtual push button of user's click generation report when limiting non-editing mode (that is to say the state that blank is not edited) in parameter
When, then the prompt that supplement is filled in is carried out to user by way of prompting frame.Once detecting that user's completion is above-mentioned not edit
The son of state limits the entry values of parameter, and the entry values of sub- restriction parameter are filled to corresponding editing area.Pass through above-mentioned side
Formula can effectively avoid qualifications set by user from having the case where omission.
Target report generation unit 102, for parse in report keyword editor's container included keyword and with pass
The corresponding restriction parameter of keyword, according to the sequencing of keyword in report keyword editor's container by the hypertext that is pre-created
Markup language code sequentially produces the corresponding field of report, to generate target report.
In the present embodiment, when user complete it is selected generate target report needed for keyword and corresponding with each keyword
Restriction parameter after, sequentially sequentially given birth to by the hypertext markup language code being pre-created according to the sequence that user selectes keyword
At the corresponding field of report, to complete quickly generating for the initialized target report for being not filled by data.
In one embodiment, as shown in Figure 10, target report generation unit 102 includes:
Report field generation unit 1021, for obtaining keyword included in keyword editor's container, according to super text
The corresponding creation of this markup language code includes the initial report of all keyword fields in keyword editor container;
Parameter generating unit 1022 is limited, for obtaining restriction parameter corresponding with each keyword, according to hypertext mark
Remember the corresponding qualifications for generating field of language codes;
Report generation unit 1023, for generating target report according to the qualifications of initial report and field.
In the present embodiment, when generation is not filled by the initialized target report of data, before this according to hypertext markup language
Say that the corresponding creation of code includes the initial report of all keyword fields in keyword editor container, then according to hypertext markup
The corresponding qualifications for generating field of language codes.It is each to be filled to mesh after completing the generation of field and qualifications
The data for marking report can correspond to the qualifications of field corresponding to the cell of filling by it to be detected, and judge the data
It whether is the valid data for meeting qualifications.I.e. by the setting of qualifications, so that the target report generated has data
Function is checked oneself, the filling data for being unsatisfactory for qualifications can be used for quickly detecting.
In one embodiment, as shown in fig. 7, report configuration device 100 further include:
Data fills unit 103, for generating data query script according to the corresponding field in target report, according to data
Query script extracts corresponding data from target database and the corresponding data that generate are inserted into script, is inserted into script for institute according to data
The data of extraction are corresponding to fill to target report.
In the present embodiment, after generating target report, each field according to included by target report is one by one
It is corresponding to generate data query script (i.e. SQL script), by querying condition set by data query script by target database
In corresponding data inquire to obtain, later further according to from target database extract corresponding data generate data be inserted into script, by
Data insertion script will be directed into target report by the extracted data of data query script.Such as the A word in target database
Section correspondence shows 100 datas, in the target report created also has A field, by generation with data query function
SQL script, which corresponds to the A field in target database, to be shown after 100 datas all extract by with data insertions function
SQL script fills into target report the corresponding column of A field.Script is inserted by data, and data are inserted into target report automatically
Table, realizes the automation of data processing, and improves data-handling efficiency.
The arrangement achieves when carrying out report exploitation, need to only select keyword in keyword container to be placed in report pass
In keyword editor's container, and corresponding restriction parameter is arranged to each keyword, passes through hypertext markup language code pair later
The field of keyword automatic report generation realizes the simplification of report generation process to generate target report, and report can be certainly
Field is defined to quickly generate.
Above-mentioned report configuration device can be implemented as the form of computer program, which can be in such as Figure 11 institute
It is run in the computer equipment shown.
Figure 11 is please referred to, Figure 11 is the schematic block diagram of computer equipment provided in an embodiment of the present invention.
Refering to fig. 11, which includes processor 502, memory and the net connected by system bus 501
Network interface 505, wherein memory may include non-volatile memory medium 503 and built-in storage 504.
The non-volatile memory medium 503 can storage program area 5031 and computer program 5032.The computer program
5032 are performed, and processor 502 may make to execute report configuration method.
The processor 502 supports the operation of entire computer equipment 500 for providing calculating and control ability.
The built-in storage 504 provides environment for the operation of the computer program 5032 in non-volatile memory medium 503, should
When computer program 5032 is executed by processor 502, processor 502 may make to execute report configuration method.
The network interface 505 is for carrying out network communication, such as the transmission of offer data information.Those skilled in the art can
To understand, structure shown in Figure 11, only the block diagram of part-structure relevant to the present invention program, is not constituted to this hair
The restriction for the computer equipment 500 that bright scheme is applied thereon, specific computer equipment 500 may include than as shown in the figure
More or fewer components perhaps combine certain components or with different component layouts.
Wherein, the processor 502 is for running computer program 5032 stored in memory, to realize following function
Can: by report keyword editor's container obtain in the keyword container being pre-created selected keyword, and receive with
The corresponding restriction parameter of selected keyword;Parse keyword included in report keyword editor's container and with key
The corresponding restriction parameter of word, according to the sequencing of keyword in report keyword editor's container by the hypertext mark that is pre-created
Note language codes sequentially produce the corresponding field of report, to generate target report.
In one embodiment, processor 502 execute keyword included in parsing report keyword editor's container and
Restriction parameter corresponding with keyword is super by what is be pre-created according to the sequencing of keyword in report keyword editor's container
Text mark up language code sequentially produces the corresponding field of report, the step of to generate target report after, also execute following behaviour
Make: data query script being generated according to the corresponding field in target report, is mentioned from target database according to data query script
It takes corresponding data and the corresponding data that generate is inserted into script, be inserted into script for the corresponding filling of extracted data to target according to data
Report.
In one embodiment, processor 502 is being executed through the acquisition of report keyword editor's container in the pass being pre-created
Selected keyword in keyword container, and before the step of receiving restriction parameter corresponding with selected keyword, also
It performs the following operations: keyword container is pre-created, and corresponding with each keyword in keyword container for generating report
The hypertext markup language code of corresponding field.Processor 502 executes such as when the step of keyword container is pre-created in execution
Lower operation: history service demand information, and database script corresponding with history service demand information are obtained;According to history industry
The corresponding database script of business demand information, statistics obtain each only field in script included in database script, and each
The frequency of only field obtains data set corresponding with field included in database script;It will be included in data set
Field extracts, and is placed in keyword container and is stored.
In one embodiment, processor 502 receive it is corresponding with selected keyword restriction parameter step when,
Perform the following operations: according to the selected keyword, corresponding generation limits the editor of parameter in report keyword editor's container
Region;Receive parameter value corresponding with each sub- restriction parameter in parameter is limited, and filling is to corresponding editing area.
In one embodiment, processor 502 receives parameter corresponding with sub- restriction parameter each in restriction parameter executing
Value, and after the step of filling to corresponding editing area, it also performs the following operations: if detecting the presence of the son of non-editing mode
Parameter is limited, the prompt that supplement is filled in is carried out;The son for receiving non-editing mode limits the entry values of parameter, and fills to corresponding
Editing area.
In one embodiment, processor 502 is executing key included in parsing report keyword editor's container
Word and restriction parameter corresponding with keyword, according to the sequencing of keyword in report keyword editor's container by being pre-created
Hypertext markup language code sequentially produce the corresponding field of report, when step to generate target report, execute following behaviour
Make: obtaining keyword included in keyword editor container, includes key according to the corresponding creation of hypertext markup language code
The initial report of all keyword fields in word editor's container;Restriction parameter corresponding with each keyword is obtained, according to super text
The corresponding qualifications for generating field of this markup language code;Target report is generated according to initial report and the qualifications of field
Table.
It will be understood by those skilled in the art that the embodiment of computer equipment shown in Figure 11 is not constituted to computer
The restriction of equipment specific composition, in other embodiments, computer equipment may include components more more or fewer than diagram, or
Person combines certain components or different component layouts.For example, in some embodiments, computer equipment can only include depositing
Reservoir and processor, in such embodiments, the structure and function of memory and processor are consistent with embodiment illustrated in fig. 11,
Details are not described herein.
It should be appreciated that in embodiments of the present invention, processor 502 can be central processing unit (Central
Processing Unit, CPU), which 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 GateArray, FPGA) or other programmable logic devices
Part, discrete gate or transistor logic, discrete hardware components etc..Wherein, general processor can be microprocessor or
The processor is also possible to any conventional processor etc..
Storage medium is provided in another embodiment of the invention.The storage medium can be that non-volatile computer can
Read storage medium.The storage medium is stored with computer program, and following step is realized when wherein computer program is executed by processor
It is rapid: by report keyword editor's container obtain in the keyword container being pre-created selected keyword, and receive with
The corresponding restriction parameter of selected keyword;Parse keyword included in report keyword editor's container and with key
The corresponding restriction parameter of word, according to the sequencing of keyword in report keyword editor's container by the hypertext mark that is pre-created
Note language codes sequentially produce the corresponding field of report, to generate target report.
In one embodiment, keyword included in parsing report keyword editor's container and corresponding with keyword
Restriction parameter, according to the sequencing of keyword in report keyword editor's container by the hypertext markup language that is pre-created
Code sequentially produces the corresponding field of report, after generating target report, further includes: according to the corresponding field in target report
Data query script is generated, corresponding data is extracted from target database according to data query script and the corresponding data that generate is inserted into
Script is inserted into script for the corresponding filling of extracted data to target report according to data.
In one embodiment, described that the institute in the keyword container being pre-created is obtained by report keyword editor's container
Selected keyword, and before reception restriction parameter corresponding with selected keyword, further includes: keyword is pre-created
Container, and it is corresponding with each keyword in keyword container for generating the hypertext markup language generation of report corresponding field
Code;Wherein, described that keyword container is pre-created, comprising: obtain history service demand information, and with history service demand information
Corresponding database script;According to database script corresponding with history service demand information, statistics is obtained in database script
The frequency of each only field and each only field in included script obtains and field pair included in database script
The data set answered;Field included in data set is extracted, is placed in keyword container and is stored.
In one embodiment, described to receive restriction parameter corresponding with selected keyword, comprising: according to the choosing
Fixed keyword is corresponding in report keyword editor's container to generate the editing area for limiting parameter;It receives and limits in parameter often
One son limits the corresponding parameter value of parameter, and fills to corresponding editing area.
In one embodiment, reception parameter value corresponding with each sub- restriction parameter in parameter is limited, and filling is extremely
After corresponding editing area, further includes: if detect the presence of non-editing mode son limit parameter, carry out supplement fill in mention
Show;The son for receiving non-editing mode limits the entry values of parameter, and fills to corresponding editing area.
In one embodiment, keyword included in parsing report keyword editor's container and corresponding with keyword
Restriction parameter, according to the sequencing of keyword in report keyword editor's container by the hypertext markup language that is pre-created
Code sequentially produces the corresponding field of report, to generate target report, comprising: obtains pass included in keyword editor container
Keyword includes the initial report of all keyword fields in keyword editor container according to the corresponding creation of hypertext markup language code
Table;Restriction parameter corresponding with each keyword is obtained, according to the corresponding restriction item for generating field of hypertext markup language code
Part;Target report is generated according to initial report and the qualifications of field.
It is apparent to those skilled in the art that for convenience of description and succinctly, foregoing description is set
The specific work process of standby, device and unit, can refer to corresponding processes in the foregoing method embodiment, and details are not described herein.
Those of ordinary skill in the art may be aware that unit described in conjunction with the examples disclosed in the embodiments of the present disclosure and algorithm
Step can be realized with electronic hardware, computer software, or a combination of the two, in order to clearly demonstrate hardware and software
Interchangeability generally describes each exemplary composition and step according to function in the above description.These functions are studied carefully
Unexpectedly the specific application and design constraint depending on technical solution are implemented in hardware or software.Professional technician
Each specific application can be used different methods to achieve the described function, but this realization is it is not considered that exceed
The scope of the present invention.
In several embodiments provided by the present invention, it should be understood that disclosed unit and method, it can be with
It realizes by another way.For example, the apparatus embodiments described above are merely exemplary, for example, the unit
It divides, only logical function partition, there may be another division manner in actual implementation, can also will be with the same function
Unit set is at a unit, such as multiple units or components can be combined or can be integrated into another system or some
Feature can be ignored, or not execute.In addition, shown or discussed mutual coupling, direct-coupling or communication connection can
Be through some interfaces, the indirect coupling or communication connection of device or unit, be also possible to electricity, mechanical or other shapes
Formula connection.
The unit as illustrated by the separation member may or may not be physically separated, aobvious as unit
The component shown may or may not be physical unit, it can and it is in one place, or may be distributed over multiple
In network unit.Some or all of unit therein can be selected to realize the embodiment of the present invention according to the actual needs
Purpose.
It, can also be in addition, the functional units in various embodiments of the present invention may be integrated into one processing unit
It is that each unit physically exists alone, is also possible to two or more units and is integrated in one unit.It is above-mentioned integrated
Unit both can take the form of hardware realization, can also realize in the form of software functional units.
If the integrated unit is realized in the form of SFU software functional unit and sells or use as independent product
When, it can store in one storage medium.Based on this understanding, technical solution of the present invention is substantially in other words to existing
The all or part of part or the technical solution that technology contributes can be embodied in the form of software products, should
Computer software product is stored in a storage medium, including some instructions are used so that a computer equipment (can be
Personal computer, server or network equipment etc.) execute all or part of step of each embodiment the method for the present invention
Suddenly.And storage medium above-mentioned include: USB flash disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), magnetic disk or
The various media that can store program code such as person's CD.
The above description is merely a specific embodiment, but scope of protection of the present invention is not limited thereto, any
Those familiar with the art in the technical scope disclosed by the present invention, can readily occur in various equivalent modifications or replace
It changes, these modifications or substitutions should be covered by the protection scope of the present invention.Therefore, protection scope of the present invention should be with right
It is required that protection scope subject to.
Claims (10)
1. a kind of report configuration method characterized by comprising
By report keyword editor's container obtain in the keyword container being pre-created selected keyword, and receive with
The corresponding restriction parameter of selected keyword;
Included keyword and restriction parameter corresponding with keyword in report keyword editor's container are parsed, is closed according to report
The sequencing of keyword is sequentially produced pair of report by the hypertext markup language code being pre-created in keyword editor's container
Field is answered, to generate target report.
2. report configuration method according to claim 1, which is characterized in that in parsing report keyword editor's container
Included keyword and restriction parameter corresponding with keyword, according in report keyword editor's container keyword it is successive suitable
Sequence is sequentially produced the corresponding field of report by the hypertext markup language code being pre-created, after generating target report, also
Include:
Data query script is generated according to the corresponding field in target report, is mentioned from target database according to data query script
It takes corresponding data and the corresponding data that generate is inserted into script, be inserted into script for the corresponding filling of extracted data to target according to data
Report.
3. report configuration method according to claim 1, which is characterized in that described to be obtained by report keyword editor's container
The selected keyword in the keyword container being pre-created is taken, and receives restriction ginseng corresponding with selected keyword
Before number, further includes:
Keyword container is pre-created, and corresponding with each keyword in keyword container for generating report corresponding field
Hypertext markup language code;
It is wherein, described that keyword container is pre-created, comprising:
Obtain history service demand information, and database script corresponding with history service demand information;
According to database script corresponding with history service demand information, statistics is obtained in script included in database script
The frequency of each only field and each only field obtains data set corresponding with field included in database script;
Field included in data set is extracted, is placed in keyword container and is stored.
4. report configuration method according to claim 3, which is characterized in that the reception is opposite with selected keyword
The restriction parameter answered, comprising:
According to the selected keyword, corresponding generation limits the editing area of parameter in report keyword editor's container;
Receive parameter value corresponding with each sub- restriction parameter in parameter is limited, and filling is to corresponding editing area.
5. report configuration method according to claim 4, which is characterized in that the reception and each sub- limit in restriction parameter
Determine the corresponding parameter value of parameter, and fill to corresponding editing area, further includes:
If the son for detecting the presence of non-editing mode limits parameter, the prompt that supplement is filled in is carried out;
The son for receiving non-editing mode limits the entry values of parameter, and fills to corresponding editing area.
6. report configuration method according to claim 1, which is characterized in that in parsing report keyword editor's container
Included keyword and restriction parameter corresponding with keyword, according in report keyword editor's container keyword it is successive suitable
Sequence is sequentially produced the corresponding field of report by the hypertext markup language code being pre-created, to generate target report, comprising:
Keyword included in keyword editor container is obtained, includes key according to the corresponding creation of hypertext markup language code
The initial report of all keyword fields in word editor's container;
Restriction parameter corresponding with each keyword is obtained, according to the corresponding restriction item for generating field of hypertext markup language code
Part;
Target report is generated according to initial report and the qualifications of field.
7. a kind of report configuration device characterized by comprising
Keyword setting unit, it is selected in the keyword container being pre-created for being obtained by report keyword editor's container
Fixed keyword, and receive restriction parameter corresponding with selected keyword;
Target report generation unit, for parsing in report keyword editor's container included keyword and corresponding with keyword
Restriction parameter, according to the sequencing of keyword in report keyword editor's container by the hypertext markup language that is pre-created
Code sequentially produces the corresponding field of report, to generate target report.
8. report configuration device according to claim 7, which is characterized in that further include:
Data fills unit, for generating data query script according to the corresponding field in target report, according to data query foot
This extracts corresponding data from target database and the corresponding data that generate are inserted into script, and being inserted into script according to data will be extracted
Data are corresponding to fill to target report.
9. a kind of computer equipment, including memory, processor and it is stored on the memory and can be on the processor
The computer program of operation, which is characterized in that the processor realizes such as claim 1 to 6 when executing the computer program
Any one of described in report configuration method.
10. a kind of storage medium, which is characterized in that the storage medium is stored with computer program, and the computer program is worked as
The processor is set to execute such as report configuration method as claimed in any one of claims 1 to 6 when being executed by processor.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811236638.XA CN109597845B (en) | 2018-10-23 | 2018-10-23 | Report configuration method, report configuration device, computer equipment and storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811236638.XA CN109597845B (en) | 2018-10-23 | 2018-10-23 | Report configuration method, report configuration device, computer equipment and storage medium |
Publications (2)
Publication Number | Publication Date |
---|---|
CN109597845A true CN109597845A (en) | 2019-04-09 |
CN109597845B CN109597845B (en) | 2023-08-08 |
Family
ID=65957958
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811236638.XA Active CN109597845B (en) | 2018-10-23 | 2018-10-23 | Report configuration method, report configuration device, computer equipment and storage medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109597845B (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111797279A (en) * | 2020-07-17 | 2020-10-20 | 西安数据如金信息科技有限公司 | Data storage method and device |
Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20060090154A1 (en) * | 2004-10-07 | 2006-04-27 | International Business Machines Corp. | System and method for contributing remote object content to an integrated development environment type-ahead |
JP2009245232A (en) * | 2008-03-31 | 2009-10-22 | Gengo Rikai Kenkyusho:Kk | Dedicated rule editor for generating rule definition of problem extraction from free description sentence of medical observation document |
KR20100121967A (en) * | 2009-05-11 | 2010-11-19 | 주식회사 에이션넷 | Realtime keyward broadcasting method of user revenue using web editor |
WO2014070037A1 (en) * | 2012-10-31 | 2014-05-08 | Limited Liability Company "1C" | Automated report generation method |
CN104461412A (en) * | 2014-12-30 | 2015-03-25 | 广州视源电子科技股份有限公司 | Method and system for printing specified area of web page |
CN106301893A (en) * | 2016-08-01 | 2017-01-04 | 北京创智信科科技股份有限公司 | The information interacting method safeguarded for BTS management and system |
-
2018
- 2018-10-23 CN CN201811236638.XA patent/CN109597845B/en active Active
Patent Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20060090154A1 (en) * | 2004-10-07 | 2006-04-27 | International Business Machines Corp. | System and method for contributing remote object content to an integrated development environment type-ahead |
JP2009245232A (en) * | 2008-03-31 | 2009-10-22 | Gengo Rikai Kenkyusho:Kk | Dedicated rule editor for generating rule definition of problem extraction from free description sentence of medical observation document |
KR20100121967A (en) * | 2009-05-11 | 2010-11-19 | 주식회사 에이션넷 | Realtime keyward broadcasting method of user revenue using web editor |
WO2014070037A1 (en) * | 2012-10-31 | 2014-05-08 | Limited Liability Company "1C" | Automated report generation method |
CN104461412A (en) * | 2014-12-30 | 2015-03-25 | 广州视源电子科技股份有限公司 | Method and system for printing specified area of web page |
CN106301893A (en) * | 2016-08-01 | 2017-01-04 | 北京创智信科科技股份有限公司 | The information interacting method safeguarded for BTS management and system |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111797279A (en) * | 2020-07-17 | 2020-10-20 | 西安数据如金信息科技有限公司 | Data storage method and device |
CN111797279B (en) * | 2020-07-17 | 2024-01-19 | 西安数据如金信息科技有限公司 | Method and device for storing data |
Also Published As
Publication number | Publication date |
---|---|
CN109597845B (en) | 2023-08-08 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US7673235B2 (en) | Method and apparatus for utilizing an object model to manage document parts for use in an electronic document | |
US9613115B2 (en) | Generating programs based on input-output examples using converter modules | |
US9348482B2 (en) | Modeling system for graphic user interface | |
CN101122899B (en) | Report generation method and device | |
CN110738037B (en) | Method, apparatus, device and storage medium for automatically generating electronic form | |
CN100527121C (en) | Method for importing and exporting data of hierarchic structure | |
CN108762764A (en) | Code automatic generation method, device, computer equipment and storage medium | |
CN109766529B (en) | Report generation method and equipment | |
CN104239073B (en) | Data maintenance system rapid prototyping development system and method | |
CN107368346A (en) | A kind of code generating method and device based on metadata and script engine | |
CN111126019B (en) | Report generation method and device based on mode customization and electronic equipment | |
CN108694214A (en) | Generation method, generating means, readable medium and the electronic equipment of data sheet | |
CN111625226B (en) | Prototype-based man-machine interaction design implementation method and system | |
CN106354483B (en) | Data processing method and device and electronic equipment | |
CN109710250A (en) | It is a kind of for constructing the visualization engine system and method for user interface | |
CN108170425A (en) | A kind of amending method of program code, modification device and terminal device | |
CN116468010A (en) | Report generation method, device, terminal and storage medium | |
CN113283216A (en) | Webpage content display method, device, equipment and storage medium | |
CN111427577A (en) | Code processing method and device and server | |
CN114371845A (en) | Form generation method and device | |
US20070192355A1 (en) | Definitions in Master Documents | |
CN109597845A (en) | Report configuration method, device, computer equipment and storage medium | |
CN114207598A (en) | Electronic form conversion | |
CN115758018A (en) | Grid-based page layout method and device, computer equipment and storage medium | |
US8719693B2 (en) | Method for storing localized XML document values |
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 | ||
GR01 | Patent grant | ||
GR01 | Patent grant |