CN109597845B - Report configuration method, report configuration device, computer equipment and storage medium - Google Patents
Report configuration method, report configuration device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN109597845B CN109597845B CN201811236638.XA CN201811236638A CN109597845B CN 109597845 B CN109597845 B CN 109597845B CN 201811236638 A CN201811236638 A CN 201811236638A CN 109597845 B CN109597845 B CN 109597845B
- Authority
- CN
- China
- Prior art keywords
- report
- keyword
- container
- keywords
- editing
- 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.)
- Active
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 a report configuration method, a report configuration device, computer equipment and a storage medium. The method comprises the following steps: acquiring selected keywords in a pre-created keyword container through a report keyword editing container, and receiving limiting parameters corresponding to the selected keywords; analyzing keywords and limiting parameters corresponding to the keywords in the report keyword editing container, and sequentially generating corresponding fields of the report by pre-created hypertext markup language codes according to the sequence of the keywords in the report keyword editing container so as to generate a target report. The method adopts a data processing technology to simplify the report generation process, and the report can be rapidly generated by self-defining fields.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a report configuration method, a report configuration device, a computer device, and a storage medium.
Background
At present, when database engineers of enterprises develop data reports, the database engineers generally realize the construction and data import through codes, so that the development process of the reports is difficult and time-consuming, and the requirements of non-professionals on quick report customization cannot be met.
Disclosure of Invention
The embodiment of the invention provides a report configuration method, a report configuration device, computer equipment and a storage medium, and aims to solve the problem that in the prior art, development of a report is difficult and time-consuming due to the fact that the report is built and data is imported through codes.
In a first aspect, an embodiment of the present invention provides a report configuration method, including:
acquiring selected keywords in a pre-created keyword container through a report keyword editing container, and receiving limiting parameters corresponding to the selected keywords;
analyzing keywords and limiting parameters corresponding to the keywords in the report keyword editing container, and sequentially generating corresponding fields of the report by pre-created hypertext markup language codes according to the sequence of the keywords in the report keyword editing container so as to generate a target report.
In a second aspect, an embodiment of the present invention provides a report configuration apparatus, including:
a keyword setting unit for acquiring the selected keywords in the pre-created keyword container through the report keyword editing container and receiving the limiting parameters corresponding to the selected keywords;
and the target report generating unit is used for analyzing the keywords and the limiting parameters corresponding to the keywords in the report keyword editing container, and sequentially generating corresponding fields of the report by pre-created hypertext markup language codes according to the sequence of the keywords in the report keyword editing container so as to generate the target report.
In a third aspect, an embodiment of the present invention further provides a computer device, which includes a memory, a processor, and a computer program stored in the memory and capable of running on the processor, where the processor implements the report configuration method described in the first aspect when executing the computer program.
In a fourth aspect, an embodiment of the present invention further provides a storage medium, where the storage medium stores a computer program, where the computer program when executed by a processor causes the processor to execute the report configuration method described in the first aspect.
The embodiment of the invention provides a report configuration method, a report configuration device, computer equipment and a storage medium. When the report is developed, only the keywords in the keyword container are selected and placed in the report keyword editing container, corresponding limiting parameters are set for each keyword, and then the fields of the report are automatically generated for the keywords through the hypertext markup language codes to generate the target report. The method realizes the simplification of the report generation process, and the report can be rapidly generated by the custom field.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for the description of the embodiments will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a schematic flow chart of a report configuration method according to an embodiment of the present invention;
FIG. 2 is another flow chart of a report configuration method according to an embodiment of the present invention;
FIG. 3 is a schematic sub-flowchart of a report configuration method according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of another sub-flowchart of a report configuration method according to an embodiment of the present invention;
FIG. 5 is a schematic diagram of another sub-flowchart of a report configuration method according to an embodiment of the present invention;
FIG. 6 is a schematic block diagram of a report configuration device provided by an embodiment of the present invention;
FIG. 7 is another schematic block diagram of a report configuration device according to an embodiment of the present invention;
FIG. 8 is a schematic block diagram of a subunit of a report configuration device according to an embodiment of the present invention;
FIG. 9 is a schematic block diagram of another subunit of the report configuration device according to an embodiment of the present invention;
FIG. 10 is a schematic block diagram of another subunit of the report configuration device according to an embodiment of the present invention;
fig. 11 is a schematic block diagram of a computer device according to an embodiment of the present invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and fully with reference to the accompanying drawings, in which it is evident that the embodiments described are some, but not all embodiments of the invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
It should be understood that the terms "comprises" and "comprising," when used in this specification and the appended claims, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.
It is also to be understood that the terminology used in the description of the invention herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. As used in this specification and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise.
It should be further understood that the term "and/or" as used in the present specification and the appended claims refers to any and all possible combinations of one or more of the associated listed items, and includes such combinations.
Referring to fig. 1, fig. 1 is a flow chart of a report configuration method provided by an embodiment of the present invention, where the report configuration method is applied to a management server or a terminal, and the method is executed by application software installed in the management server or the terminal, where the management server is an enterprise terminal for performing report configuration, and the terminal may be an electronic device with a communication function, such as a smart phone, a tablet computer, a notebook computer, a desktop computer, a personal digital assistant, and a wearable device.
As shown in fig. 1, the method includes steps S101 to S102.
S101, acquiring the selected keywords in a pre-created keyword container through a report keyword editing container, and receiving limiting parameters corresponding to the selected keywords.
In this embodiment, the report configuration method has the following application scenarios:
at least two areas are arranged on a user operation interface corresponding to the developed application program for automatically generating the report, wherein one area is provided with a keyword container, and the other area is provided with a report keyword editing container. When a user needs to quickly generate a report, keywords (the keywords can be understood as fields in the report) required by generating a target report are selected from the keyword containers, then the selected keywords are moved to the report keyword editing container, and finally the target report is generated according to limiting parameters set by the user for each keyword in the report keyword editing container and the pre-created hypertext markup language code. In the process of generating the target report, the user can quickly generate the target report by processing the hypertext markup language codes only by selecting the needed keywords and setting the limiting parameters for each keyword, and the user does not need to write the codes by himself to develop the report.
The limiting parameters at least comprise the data type, the input mode, the checking rule and the layout requirement of the keywords; for example, when the target report to be custom-generated by the user includes a field of order number, the keyword of order number is selected from the keyword container and is moved into the report keyword editing container, and then the limiting parameters set for the keyword of order number in the report keyword editing container are as follows: the data type is an integer, the input mode is a single-line text box, the checking rule comprises 20-bit characters, the first three characters are DDH, and the layout requirement is centered. Through the page type design mode, the development process of the report is simplified, and the development difficulty is reduced.
In one embodiment, as shown in fig. 2, step S101 further includes:
s101a, a keyword container and a hypertext markup language code corresponding to each keyword in the keyword container and used for generating a report corresponding field are created in advance.
In this embodiment, each keyword in the keyword container created in advance may be regarded as a field, the sources of the fields may be data sets, and the fields in the report automatically generated for each keyword may be implemented by hypertext markup language code.
The data set is a field set and a data set which are obtained by statistics of historical business demand information and database scripts corresponding to the historical business demand information.
In one embodiment, as shown in fig. 3, creating a keyword container in advance in step S101a includes:
s1001, acquiring historical service demand information and a database script corresponding to the historical service demand information;
s1002, according to a database script corresponding to historical service demand information, counting and obtaining each single field in the script included in the database script and the frequency of each single field, and obtaining a data set corresponding to the field included in the database script;
s1003, extracting the fields included in the data set, and storing the extracted fields in a keyword container.
In this embodiment, analysis of historical data is performed on the historical service requirement information and the corresponding database script, so that it can be known which field the requirement end has a relatively large requirement. And counting the database scripts corresponding to the historical service demand information, and obtaining each single field and the frequency of each single field in the scripts included in the database scripts by counting to obtain a data set corresponding to the fields included in the database scripts. For example, there is a query statement in the database script that "select field name A from data table," the frequency with which this field name A is queried may be increased by one. And the data set can be ordered in descending order according to the frequency of a single field, so that the data set capable of intuitively knowing the frequency of the field is obtained.
In creating hypertext markup language code (i.e., HTML code) corresponding to each keyword in a keyword container for generating a report corresponding field, the process of generating a report on a web page interface, for example, by generating a table through the HTML code is as follows:
a1 A cell format whose HTML code is as follows:
td{text-align:center；width:100px；height:30px；}
the text-align represents that text centers of the cells are aligned, and the width of each cell is 100 pixels and the height of each cell is 30 pixels;
a2 A common cell pattern is set, such as:
.inp{width:80px；height:26px；font-size:10px；text-align:center；}
wherein inp represents a file format, and font-size represents a font size;
a3 Set table title input box style, such as:
.cap{font-size:20px；text-align:center；}
wherein inp represents an input box style;
a4 Setting an input box style of a first row of the table;
a5 Conveying the row input frame and the column input frame and the region;
a6 Acquiring a line value;
a7 Obtaining a column value;
a8 A table element is created;
a9 Setting all the outer frames of the table to be displayed;
a10 Setting the inner frame of the table to be displayed completely;
a11 A common column of cells is created.
The report can be automatically created according to the keywords through the HTML codes, and corresponding fields are created in the report, so that the report generation efficiency is improved, and the report generation difficulty is reduced.
In one embodiment, as shown in fig. 4, receiving the limiting parameters corresponding to the selected keyword in step S101 includes:
s1011, correspondingly generating an editing area of a limiting parameter in a report keyword editing container according to the selected keywords;
s1012, receiving parameter values corresponding to each sub-limiting parameter in the limiting parameters, and filling the parameter values into corresponding editing areas.
In this embodiment, the keyword container may be placed in a region on the left side of the user operation interface corresponding to the application program for automatically generating a report, the report keyword editing container is placed in a region of the user operation interface corresponding to the application program for automatically generating a report, and the report keyword editing container is set in a form of multiple-line editing, that is, the editing region corresponding to each line may accommodate one keyword and the editing region of the limiting parameter corresponding to the keyword. The method comprises the steps that a user can drag keywords selected in a keyword container to a report keyword editing container in a keyword dragging mode, the keywords enter the report keyword editing container in an arrangement mode, the keywords are orderly arranged in the report keyword editing container from top to bottom according to the time sequence of the keywords dragged to the report keyword editing container, and each row in the report keyword editing container corresponds to an editing area of one keyword and limiting parameters of the keyword.
The limiting parameters of the keywords in each row in the report keyword editing container can be correspondingly set, for example, a user sets the keyword of an order number in a certain row of the report keyword editing container, the data type can be set as an integer in an editing area of the limiting parameters, the input mode is a single-row text box, the checking rule comprises 20 characters and the first three characters are DDH, the layout requirement is centered, and when setting of parameter values corresponding to each sub-limiting parameter in the limiting parameters is completed, each sub-limiting parameter is filled into the editing area corresponding to the row. By the mode, a user can complete quick configuration of report generation conditions only by selecting keywords and setting limiting conditions in the process of developing the report.
In one embodiment, as shown in fig. 4, step S101 further includes:
s1013, if the fact that the sub-limiting parameters in the unedited state exist is detected, a supplementary filling prompt is carried out;
s1014, receiving input values of the sub-limiting parameters in the unedited state, and filling the input values into the corresponding edited region.
In this embodiment, after the user completes the configuration of the plurality of keywords and the defining parameters thereof, if there is an unedited state (i.e., a blank unedited state) in the sub-defining parameters, when the user clicks the virtual button for generating the report, the user is prompted to make up by means of a prompt box. And filling the input values of the sub-limiting parameters into the corresponding editing areas once the input values of the sub-limiting parameters in the unedited state are detected. Through the mode, the condition that limiting conditions set by a user are omitted can be effectively avoided.
S102, analyzing keywords and limiting parameters corresponding to the keywords in the report keyword editing container, and sequentially generating corresponding fields of the report by pre-created hypertext markup language codes according to the sequence of the keywords in the report keyword editing container to generate a target report.
In this embodiment, after the user finishes selecting the keywords required for generating the target report and the limiting parameters corresponding to each keyword, corresponding fields of the report are sequentially generated by the pre-created hypertext markup language codes according to the sequence of the keywords selected by the user, so as to complete the rapid generation of the initial target report without filling data.
In one embodiment, as shown in fig. 5, step S102 includes:
s1021, acquiring keywords contained in the keyword editing container, and correspondingly creating an initial report comprising all keyword fields in the keyword editing container according to the hypertext markup language code;
s1022, obtaining limiting parameters corresponding to each keyword, and generating limiting conditions of fields according to the corresponding hypertext markup language codes;
s1023, generating a target report according to the limiting conditions of the initial report and the fields.
In this embodiment, when generating the initial target report of unfilled data, an initial report including all the keyword fields in the keyword editing container is created according to the corresponding hypertext markup language code, and then the defining conditions of the fields are generated according to the corresponding hypertext markup language code. After the generation of the fields and the limiting conditions is completed, each data filled into the target report is detected by the limiting conditions of the fields corresponding to the cells filled correspondingly, and whether the data is legal data meeting the limiting conditions is judged. The method has the advantages that through setting of limiting conditions, the generated target report has a data self-checking function, and filling data which does not meet the limiting conditions can be detected rapidly.
In one embodiment, as shown in fig. 2, step S102 further includes:
s103, generating a data query script according to the corresponding field in the target report, extracting corresponding data from the target database according to the data query script, correspondingly generating a data insertion script, and correspondingly filling the extracted data into the target report according to the data insertion script.
In this embodiment, after the target report is generated, a data query script (i.e., an SQL script) may be generated according to one-to-one correspondence of each field included in the target report, corresponding data in the target database is queried according to query conditions set by the data query script, and then a data insertion script is generated according to extracting corresponding data from the target database, and the data extracted by the data query script is imported into the target report by the data insertion script. For example, 100 pieces of data are listed corresponding to the A field in the target database, the A field is also listed in the created target report, 100 pieces of data are all extracted from the corresponding column of the A field in the target database through the generated SQL script with the data query function, and the column corresponding to the A field in the target report is filled by the SQL script with the data insertion function. The data is automatically inserted into the target report form through the data insertion script, so that automation of data processing is realized, and data processing efficiency is improved.
The method realizes that when the report is developed, only the keyword is selected from the keyword container and placed in the report keyword editing container, the corresponding limiting parameter is set for each keyword, then the field of the report is automatically generated for the keyword through the hypertext markup language code to generate the target report, the report generation process is simplified, and the report can be rapidly generated by the self-defining field.
The embodiment of the invention also provides a report configuration device which is used for executing any embodiment of the report configuration method. Specifically, referring to fig. 6, fig. 6 is a schematic block diagram of a report configuration device according to an embodiment of the present invention. The report configuration device 100 may be configured in a management server or a terminal.
As shown in fig. 6, the report configuration apparatus 100 includes a keyword setting unit 101 and a target report generating unit 102.
The keyword setting unit 101 is configured to acquire a keyword selected in a keyword container created in advance through a report keyword editing container, and receive a definition parameter corresponding to the selected keyword.
In this embodiment, the limiting parameters at least include a data type, an input mode, an inspection rule, and a layout requirement of the keyword; for example, when the target report to be custom-generated by the user includes a field of order number, the keyword of order number is selected from the keyword container and is moved into the report keyword editing container, and then the limiting parameters set for the keyword of order number in the report keyword editing container are as follows: the data type is an integer, the input mode is a single-line text box, the checking rule comprises 20-bit characters, the first three characters are DDH, and the layout requirement is centered. Through the page type design mode, the development process of the report is simplified, and the development difficulty is reduced.
In one embodiment, as shown in fig. 7, the report configuration device 100 further includes:
the keyword container creation unit 101a is configured to create a keyword container in advance, and a hypertext markup language code for generating a report corresponding field corresponding to each keyword in the keyword container.
In this embodiment, each keyword in the keyword container created in advance may be regarded as a field, the sources of the fields may be data sets, and the fields in the report automatically generated for each keyword may be implemented by hypertext markup language code.
The data set is a field set and a data set which are obtained by statistics of historical business demand information and database scripts corresponding to the historical business demand information.
In an embodiment, as shown in fig. 8, the keyword container creation unit 101a includes:
a history requirement information obtaining unit 1001, configured to obtain history service requirement information and a database script corresponding to the history service requirement information;
a field statistics unit 1002, configured to obtain, according to a database script corresponding to the historical service requirement information, statistics of each single field in the script included in the database script, and frequencies of each single field, and obtain a data set corresponding to the field included in the database script;
The field extracting unit 1003 is configured to extract a field included in the data set, and store the extracted field in a keyword container.
In this embodiment, analysis of historical data is performed on the historical service requirement information and the corresponding database script, so that it can be known which field the requirement end has a relatively large requirement. And counting the database scripts corresponding to the historical service demand information, and obtaining each single field and the frequency of each single field in the scripts included in the database scripts by counting to obtain a data set corresponding to the fields included in the database scripts. For example, there is a query statement in the database script that "select field name A from data table," the frequency with which this field name A is queried may be increased by one. And the data set can be ordered in descending order according to the frequency of a single field, so that the data set capable of intuitively knowing the frequency of the field is obtained.
In creating hypertext markup language code (i.e., HTML code) corresponding to each keyword in a keyword container for generating a report corresponding field, the purpose is to generate a report on a web page interface. The report can be automatically created according to the keywords through the HTML codes, and corresponding fields are created in the report, so that the report generation efficiency is improved, and the report generation difficulty is reduced.
In an embodiment, as shown in fig. 9, the keyword setting unit 101 includes:
a limiting condition editing unit 1011, configured to correspondingly generate an editing area of a limiting parameter in a report keyword editing container according to the selected keyword;
the constraint condition acquisition unit 1012 is configured to receive a parameter value corresponding to each sub-constraint parameter of the constraint parameters, and fill the corresponding edit area.
In this embodiment, the keyword container may be placed in a region on the left side of the user operation interface corresponding to the application program for automatically generating a report, the report keyword editing container is placed in a region of the user operation interface corresponding to the application program for automatically generating a report, and the report keyword editing container is set in a form of multiple-line editing, that is, the editing region corresponding to each line may accommodate one keyword and the editing region of the limiting parameter corresponding to the keyword. The method comprises the steps that a user can drag keywords selected in a keyword container to a report keyword editing container in a keyword dragging mode, the keywords enter the report keyword editing container in an arrangement mode, the keywords are orderly arranged in the report keyword editing container from top to bottom according to the time sequence of the keywords dragged to the report keyword editing container, and each row in the report keyword editing container corresponds to an editing area of one keyword and limiting parameters of the keyword.
The limiting parameters of the keywords in each row in the report keyword editing container can be correspondingly set, for example, a user sets the keyword of an order number in a certain row of the report keyword editing container, the data type can be set as an integer in an editing area of the limiting parameters, the input mode is a single-row text box, the checking rule comprises 20 characters and the first three characters are DDH, the layout requirement is centered, and when setting of parameter values corresponding to each sub-limiting parameter in the limiting parameters is completed, each sub-limiting parameter is filled into the editing area corresponding to the row. By the mode, a user can complete quick configuration of report generation conditions only by selecting keywords and setting limiting conditions in the process of developing the report.
In an embodiment, as shown in fig. 9, the keyword setting unit 101 further includes:
unedited presentation unit 1013 for presenting a supplementary filling if the presence of the unedited child definition parameter is detected;
an unedited condition filling unit 1014 is configured to receive an entry value of a sub-defined parameter in an unedited state and fill the entry value into a corresponding edited region.
In this embodiment, after the user completes the configuration of the plurality of keywords and the defining parameters thereof, if there is an unedited state (i.e., a blank unedited state) in the sub-defining parameters, when the user clicks the virtual button for generating the report, the user is prompted to make up by means of a prompt box. And filling the input values of the sub-limiting parameters into the corresponding editing areas once the input values of the sub-limiting parameters in the unedited state are detected. Through the mode, the condition that limiting conditions set by a user are omitted can be effectively avoided.
The target report generating unit 102 is configured to parse the keywords included in the report keyword editing container and the limiting parameters corresponding to the keywords, and sequentially generate corresponding fields of the report by pre-created hypertext markup language codes according to the sequence of the keywords in the report keyword editing container, so as to generate a target report.
In this embodiment, after the user finishes selecting the keywords required for generating the target report and the limiting parameters corresponding to each keyword, corresponding fields of the report are sequentially generated by the pre-created hypertext markup language codes according to the sequence of the keywords selected by the user, so as to complete the rapid generation of the initial target report without filling data.
In one embodiment, as shown in fig. 10, the target report generating unit 102 includes:
report field generating unit 1021, configured to obtain keywords included in the keyword editing container, and correspondingly create an initial report including all the keyword fields in the keyword editing container according to the hypertext markup language code;
a limiting parameter generating unit 1022 for acquiring limiting parameters corresponding to each keyword and generating limiting conditions of fields according to the corresponding hypertext markup language code;
And the report generating unit 1023 is used for generating a target report according to the initial report and the limiting conditions of the fields.
In this embodiment, when generating the initial target report of unfilled data, an initial report including all the keyword fields in the keyword editing container is created according to the corresponding hypertext markup language code, and then the defining conditions of the fields are generated according to the corresponding hypertext markup language code. After the generation of the fields and the limiting conditions is completed, each data filled into the target report is detected by the limiting conditions of the fields corresponding to the cells filled correspondingly, and whether the data is legal data meeting the limiting conditions is judged. The method has the advantages that through setting of limiting conditions, the generated target report has a data self-checking function, and filling data which does not meet the limiting conditions can be detected rapidly.
In one embodiment, as shown in fig. 7, the report configuration device 100 further includes:
and the data filling unit 103 is used for generating a data query script according to the corresponding fields in the target report, extracting corresponding data from the target database according to the data query script and correspondingly generating a data insertion script, and correspondingly filling the extracted data into the target report according to the data insertion script.
In this embodiment, after the target report is generated, a data query script (i.e., an SQL script) may be generated according to one-to-one correspondence of each field included in the target report, corresponding data in the target database is queried according to query conditions set by the data query script, and then a data insertion script is generated according to extracting corresponding data from the target database, and the data extracted by the data query script is imported into the target report by the data insertion script. For example, 100 pieces of data are listed corresponding to the A field in the target database, the A field is also listed in the created target report, 100 pieces of data are all extracted from the corresponding column of the A field in the target database through the generated SQL script with the data query function, and the column corresponding to the A field in the target report is filled by the SQL script with the data insertion function. The data is automatically inserted into the target report form through the data insertion script, so that automation of data processing is realized, and data processing efficiency is improved.
The device realizes that when the report is developed, only the keyword is selected from the keyword container and placed in the report keyword editing container, the corresponding limiting parameter is set for each keyword, then the field of the report is automatically generated for the keyword through the hypertext markup language code to generate the target report, the report generation process is simplified, and the report can be rapidly generated by the self-defining field.
The report configuration means described above may be implemented in the form of a computer program which can be run on a computer device as shown in fig. 11.
Referring to fig. 11, fig. 11 is a schematic block diagram of a computer device according to an embodiment of the present invention.
With reference to FIG. 11, the computer device 500 includes a processor 502, memory, and a network interface 505 connected by a system bus 501, where the memory may include a non-volatile storage medium 503 and an internal memory 504.
The non-volatile storage medium 503 may store an operating system 5031 and a computer program 5032. The computer program 5032, when executed, may cause the processor 502 to perform a report configuration method.
The processor 502 is used to provide computing and control capabilities to support the operation of the overall computer device 500.
The internal memory 504 provides an environment for the execution of a computer program 5032 in the non-volatile storage medium 503, which computer program 5032, when executed by the processor 502, causes the processor 502 to perform a report configuration method.
The network interface 505 is used for network communication, such as providing for transmission of data information, etc. It will be appreciated by those skilled in the art that the structure shown in FIG. 11 is merely a block diagram of some of the structures associated with the present inventive arrangements and does not constitute a limitation of the computer device 500 to which the present inventive arrangements may be applied, and that a particular computer device 500 may include more or fewer components than shown, or may combine some of the components, or have a different arrangement of components.
Wherein the processor 502 is configured to execute a computer program 5032 stored in a memory to perform the following functions: acquiring selected keywords in a pre-created keyword container through a report keyword editing container, and receiving limiting parameters corresponding to the selected keywords; analyzing keywords and limiting parameters corresponding to the keywords in the report keyword editing container, and sequentially generating corresponding fields of the report by pre-created hypertext markup language codes according to the sequence of the keywords in the report keyword editing container so as to generate a target report.
In one embodiment, after executing the step of parsing the keywords included in the report keyword editing container and the defining parameters corresponding to the keywords, the processor 502 sequentially generates the corresponding fields of the report from the pre-created hypertext markup language code according to the sequence of the keywords in the report keyword editing container to generate the target report, the following operations are further executed: generating a data query script according to the corresponding fields in the target report, extracting corresponding data from the target database according to the data query script, correspondingly generating a data insertion script, and correspondingly filling the extracted data into the target report according to the data insertion script.
In one embodiment, the processor 502 further performs the following operations before performing the step of obtaining the selected keywords in the pre-created keyword containers through the report keyword editing container and receiving the defined parameters corresponding to the selected keywords: the method comprises the steps of creating a keyword container in advance and a hypertext markup language code corresponding to each keyword in the keyword container and used for generating a report corresponding field. The processor 502, when performing the step of creating a keyword container in advance, performs the following operations: acquiring historical service demand information and a database script corresponding to the historical service demand information; according to the database script corresponding to the historical service demand information, each single field in the script included in the database script and the frequency of each single field are obtained through statistics, and a data set corresponding to the field included in the database script is obtained; the fields included in the dataset are extracted and placed in a keyword container for storage.
In one embodiment, the processor 502, upon receiving the defined parameters corresponding to the selected keywords, performs the following operations: correspondingly generating an editing area of limiting parameters in a report keyword editing container according to the selected keywords; and receiving parameter values corresponding to each sub-limiting parameter in the limiting parameters, and filling the parameter values into corresponding editing areas.
In one embodiment, after performing the step of receiving parameter values corresponding to each sub-defined parameter of the defined parameters and filling the corresponding edit area, the processor 502 further performs the following operations: if the fact that the sub-limiting parameters in the unedited state exist is detected, a supplementary filling prompt is carried out; and receiving the input values of the sub-limiting parameters in the unedited state, and filling the input values into the corresponding editing areas.
In one embodiment, when executing the steps of parsing the keywords included in the report keyword editing container and the defining parameters corresponding to the keywords, the processor 502 sequentially generates the corresponding fields of the report from the pre-created hypertext markup language code according to the sequence of the keywords in the report keyword editing container, so as to generate the target report, the following operations are executed: acquiring keywords contained in a keyword editing container, and correspondingly creating an initial report comprising all keyword fields in the keyword editing container according to the hypertext markup language code; acquiring limiting parameters corresponding to each keyword, and generating limiting conditions of fields according to the corresponding hypertext markup language codes; and generating a target report according to the limiting conditions of the initial report and the fields.
Those skilled in the art will appreciate that the embodiment of the computer device shown in fig. 11 is not limiting of the specific construction of the computer device, and in other embodiments, the computer device may include more or less components than those shown, or certain components may be combined, or a different arrangement of components. For example, in some embodiments, the computer device may include only a memory and a processor, and in such embodiments, the structure and function of the memory and the processor are consistent with the embodiment shown in fig. 11, and will not be described again.
It should be appreciated that in embodiments of the present invention, the processor 502 may be a central processing unit (Central Processing Unit, CPU), the processor 502 may also be other general purpose processors, digital signal processors (Digital Signal Processor, DSP), application specific integrated circuits (Application Specific Integrated Circuit, ASIC), off-the-shelf Programmable gate arrays (FPGAs) or other Programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, or the like. Wherein the general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
In another embodiment of the present invention, a storage medium is provided. The storage medium may be a non-volatile computer readable storage medium. The storage medium stores a computer program, wherein the computer program when executed by a processor performs the steps of: acquiring selected keywords in a pre-created keyword container through a report keyword editing container, and receiving limiting parameters corresponding to the selected keywords; analyzing keywords and limiting parameters corresponding to the keywords in the report keyword editing container, and sequentially generating corresponding fields of the report by pre-created hypertext markup language codes according to the sequence of the keywords in the report keyword editing container so as to generate a target report.
In an embodiment, after the parsing the keywords included in the report keyword editing container and the limiting parameters corresponding to the keywords, sequentially generating corresponding fields of the report by pre-created hypertext markup language codes according to the sequence of the keywords in the report keyword editing container to generate the target report, the method further includes: generating a data query script according to the corresponding fields in the target report, extracting corresponding data from the target database according to the data query script, correspondingly generating a data insertion script, and correspondingly filling the extracted data into the target report according to the data insertion script.
In an embodiment, before the obtaining, by the report keyword editing container, the selected keyword in the pre-created keyword container and receiving the defining parameter corresponding to the selected keyword, the method further includes: pre-creating a keyword container and hypertext markup language codes corresponding to each keyword in the keyword container and used for generating corresponding fields of the report; wherein the pre-created keyword container includes: acquiring historical service demand information and a database script corresponding to the historical service demand information; according to the database script corresponding to the historical service demand information, each single field in the script included in the database script and the frequency of each single field are obtained through statistics, and a data set corresponding to the field included in the database script is obtained; the fields included in the dataset are extracted and placed in a keyword container for storage.
In an embodiment, the receiving the defined parameter corresponding to the selected keyword includes: correspondingly generating an editing area of limiting parameters in a report keyword editing container according to the selected keywords; and receiving parameter values corresponding to each sub-limiting parameter in the limiting parameters, and filling the parameter values into corresponding editing areas.
In an embodiment, after receiving the parameter value corresponding to each sub-defined parameter in the defined parameters and filling the parameter value into the corresponding editing area, the method further includes: if the fact that the sub-limiting parameters in the unedited state exist is detected, a supplementary filling prompt is carried out; and receiving the input values of the sub-limiting parameters in the unedited state, and filling the input values into the corresponding editing areas.
In an embodiment, the parsing the keywords included in the report keyword editing container and the limiting parameters corresponding to the keywords sequentially generates corresponding fields of the report by pre-created hypertext markup language codes according to the sequence of the keywords in the report keyword editing container to generate the target report, and the method includes: acquiring keywords contained in a keyword editing container, and correspondingly creating an initial report comprising all keyword fields in the keyword editing container according to the hypertext markup language code; acquiring limiting parameters corresponding to each keyword, and generating limiting conditions of fields according to the corresponding hypertext markup language codes; and generating a target report according to the limiting conditions of the initial report and the fields. .
It will be clearly understood by those skilled in the art that, for convenience and brevity of description, specific working procedures of the apparatus, device and unit described above may refer to corresponding procedures in the foregoing method embodiments, which are not repeated herein. Those of ordinary skill in the art will appreciate that the elements and algorithm steps described in connection with the embodiments disclosed herein may be embodied in electronic hardware, in computer software, or in a combination of the two, and that the elements and steps of the examples have been generally described in terms of function in the foregoing description to clearly illustrate the interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.
In the several embodiments provided by the present invention, it should be understood that the disclosed apparatus, device and method may be implemented in other manners. For example, the apparatus embodiments described above are merely illustrative, and for example, the division of the units is merely a logical function division, there may be another division manner in actual implementation, or units having the same function may be integrated into one unit, for example, multiple units or components may be combined or may be integrated into another system, or some features may be omitted, or not performed. In addition, the coupling or direct coupling or communication connection shown or discussed with each other may be an indirect coupling or communication connection via some interfaces, devices, or elements, or may be an electrical, mechanical, or other form of connection.
The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the embodiment of the present invention.
In addition, each functional unit in the embodiments of the present invention may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The integrated units may be stored in a storage medium if implemented in the form of software functional units and sold or used as stand-alone products. Based on such understanding, the technical solution of the present invention is essentially or a part contributing to the prior art, or all or part of the technical solution may be embodied in the form of a software product stored in a storage medium, comprising several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a magnetic disk, an optical disk, or other various media capable of storing program codes.
While the invention has been described with reference to certain preferred embodiments, it will be understood by those skilled in the art that various changes and substitutions of equivalents may be made and equivalents will be apparent to those skilled in the art without departing from the scope of the invention. Therefore, the protection scope of the invention is subject to the protection scope of the claims.
Claims (7)
1. A report configuration method, comprising:
acquiring selected keywords in a pre-created keyword container through a report keyword editing container, and receiving limiting parameters corresponding to the selected keywords;
analyzing keywords and limiting parameters corresponding to the keywords in the report keyword editing container, and sequentially generating corresponding fields of the report by pre-created hypertext markup language codes according to the sequence of the keywords in the report keyword editing container so as to generate a target report;
the method for editing the keywords through the report keyword comprises the steps of:
Pre-creating a keyword container and hypertext markup language codes corresponding to each keyword in the keyword container and used for generating corresponding fields of the report;
wherein the pre-created keyword container includes:
acquiring historical service demand information and a database script corresponding to the historical service demand information;
according to the database script corresponding to the historical service demand information, each single field in the script included in the database script and the frequency of each single field are obtained through statistics, and a data set corresponding to the field included in the database script is obtained;
extracting the fields included in the data set, and storing the extracted fields in a keyword container;
the receiving of the defined parameters corresponding to the selected keywords includes:
correspondingly generating an editing area of limiting parameters in a report keyword editing container according to the selected keywords;
receiving parameter values corresponding to each sub-limiting parameter in the limiting parameters, and filling the parameter values into corresponding editing areas;
the method further comprises the steps of after receiving the parameter value corresponding to each sub-limiting parameter in the limiting parameters and filling the parameter value into the corresponding editing area:
if the fact that the sub-limiting parameters in the unedited state exist is detected, a supplementary filling prompt is carried out;
And receiving the input values of the sub-limiting parameters in the unedited state, and filling the input values into the corresponding editing areas.
2. The report configuration method according to claim 1, wherein after the parsing the keywords included in the report keyword editing container and the defining parameters corresponding to the keywords, sequentially generating corresponding fields of the report from the pre-created hypertext markup language code according to the sequence of the keywords in the report keyword editing container to generate the target report, further comprising:
generating a data query script according to the corresponding fields in the target report, extracting corresponding data from the target database according to the data query script, correspondingly generating a data insertion script, and correspondingly filling the extracted data into the target report according to the data insertion script.
3. The report configuration method according to claim 1, wherein the parsing the keywords included in the report keyword editing container and the defining parameters corresponding to the keywords sequentially generates corresponding fields of the report from pre-created hypertext markup language codes according to the order of the keywords in the report keyword editing container to generate the target report, comprising:
Acquiring keywords contained in a keyword editing container, and correspondingly creating an initial report comprising all keyword fields in the keyword editing container according to the hypertext markup language code;
acquiring limiting parameters corresponding to each keyword, and generating limiting conditions of fields according to the corresponding hypertext markup language codes;
and generating a target report according to the limiting conditions of the initial report and the fields.
4. A report configuration device, comprising:
a keyword setting unit for acquiring the selected keywords in the pre-created keyword container through the report keyword editing container and receiving the limiting parameters corresponding to the selected keywords;
the target report generating unit is used for analyzing the keywords and the limiting parameters corresponding to the keywords in the report keyword editing container, and sequentially generating corresponding fields of the report by pre-created hypertext markup language codes according to the sequence of the keywords in the report keyword editing container so as to generate a target report;
the report configuration device further comprises:
the keyword container creation unit is used for creating a keyword container in advance and a hypertext markup language code which corresponds to each keyword in the keyword container and is used for generating a report corresponding field;
Wherein the keyword container creation unit includes:
the historical demand information acquisition unit is used for acquiring historical service demand information and database scripts corresponding to the historical service demand information;
the field statistics unit is used for obtaining all single fields in the scripts included in the database scripts and the frequencies of all the single fields according to the database scripts corresponding to the historical service demand information in a statistics mode, and obtaining a data set corresponding to the fields included in the database scripts;
the field extraction unit is used for extracting the fields included in the data set and storing the extracted fields in the keyword container;
the keyword setting unit includes:
the limiting condition editing unit is used for correspondingly generating an editing area of limiting parameters in the report keyword editing container according to the selected keywords;
the limiting condition acquisition unit is used for receiving parameter values corresponding to each sub-limiting parameter in the limiting parameters and filling the parameter values into the corresponding editing area;
the keyword setting unit further includes:
the unedited prompting unit is used for prompting supplementary filling if the sub-limiting parameters in the unedited state are detected;
And the unedited condition filling unit is used for receiving the input value of the sub-limiting parameter in the unedited state and filling the input value into the corresponding edited region.
5. The report configuration device of claim 4, further comprising:
and the data filling unit is used for generating a data query script according to the corresponding field in the target report, extracting corresponding data from the target database according to the data query script, correspondingly generating a data insertion script, and correspondingly filling the extracted data into the target report according to the data insertion script.
6. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the report configuration method of any of claims 1 to 3 when the computer program is executed by the processor.
7. A storage medium storing a computer program which, when executed by a processor, causes the processor to perform the report configuration method of any one of claims 1 to 3.
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 CN109597845A (en) | 2019-04-09 |
| CN109597845B true 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) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111797279B (en) * | 2020-07-17 | 2024-01-19 | 西安数据如金信息科技有限公司 | Method and device for storing data |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Family Cites Families (1)
| 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 |
-
2018
- 2018-10-23 CN CN201811236638.XA patent/CN109597845B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109597845A (en) | 2019-04-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110325961B (en) | Spreadsheet-based software application development | |
| CN103778234B (en) | The generation method and device of form | |
| CN107656914B (en) | Configurable table generation method and device, terminal equipment and storage medium | |
| CN108984172B (en) | Interface file generation method and device | |
| CN111079047B (en) | Web-oriented page construction system | |
| US20110231784A1 (en) | System and method for desktop application migration | |
| CN111126019B (en) | Report generation method and device based on mode customization and electronic equipment | |
| CN114035773A (en) | Configuration-based low-code form development method, system and device | |
| CN111966345A (en) | Drag-type webpage design method and device, computer equipment and storage medium | |
| CN115712413B (en) | Low code development method, device, equipment and storage medium | |
| US8732615B2 (en) | Unified interface for display and modification of data arrays | |
| JP7373563B2 (en) | Systems and methods for creating and processing configurable applications for website building systems | |
| CN108255479B (en) | Creation method, device, storage medium and the terminal of cube file | |
| CN108170654A (en) | A kind of electronic forms editing device and its development approach | |
| US20120233186A1 (en) | Exposing and using metadata and meta-metadata | |
| CN111625226A (en) | Prototype-based human-computer interaction design implementation method and system | |
| CN112558967A (en) | Page automatic generation method and device, electronic equipment and storage medium | |
| CN113535165A (en) | Interface generation method and device, electronic equipment and computer readable storage medium | |
| CN109739906A (en) | A kind of report form generation method and system | |
| CN113407254B (en) | Form generation method and device, electronic equipment and storage medium | |
| CN109597845B (en) | Report configuration method, report configuration device, computer equipment and storage medium | |
| WO2012141996A1 (en) | Portable business language and automated software application development system | |
| CN106502977B (en) | A kind of sheet disposal method and form system based on B/S framework | |
| CN117193728A (en) | Development method and device of software as-a-service platform | |
| CN111435300A (en) | Web system development method, device, equipment and storage medium |
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 |