CN115827644B - Report generation method, system and server based on visual view configuration - Google Patents
Report generation method, system and server based on visual view configuration Download PDFInfo
- Publication number
- CN115827644B CN115827644B CN202310106194.2A CN202310106194A CN115827644B CN 115827644 B CN115827644 B CN 115827644B CN 202310106194 A CN202310106194 A CN 202310106194A CN 115827644 B CN115827644 B CN 115827644B
- Authority
- CN
- China
- Prior art keywords
- field
- data sets
- target
- fields
- parameter value
- 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
Images
Classifications
-
- 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
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a report generating method, a system and a server based on visual view configuration, which are used for acquiring the existing data sets or selecting required fields to create the data sets in a database of a production manufacturing system, and carrying out two-by-two connection on each data set, wherein the two ends of the connection are respectively connected with target fields of two data sets, endow connection screening conditions and configure the combination relation of the two associated data sets, acquire target field parameter values meeting the requirements and corresponding other field parameter values according to the screening conditions, acquire output fields after the two associated data sets are combined and the screened corresponding field parameter values according to the field screening rules of the associated data sets, and then generate a visual report. The on-site implementation personnel can be configured in a connecting line mode on the front-end interface according to the data wanted by the on-site implementation personnel, further view sentences are automatically generated, and the data analysis and screening efficiency of the on-site implementation personnel is effectively provided.
Description
Technical Field
The invention relates to the technical field of information, in particular to a report generation method, a report generation system and a report generation server based on visual view configuration.
Background
Production manufacturing systems (MES) run on large amounts of data that are often stored and recorded in a large number of individual data tables. There may or may not be some association of fields between the various data record tables. Because the production manufacturing system belongs to an intermediate system in the whole production flow, the operation data has very large analysis value and statistical value, and can be used for processing analysis by a third party analysis tool. However, since these recorded data are discrete and do not meet their data requirements, the conventional mode is currently implemented by code customization or by a third party through a complex database language, which is cumbersome to operate, has poor versatility and consumes a lot of manpower and material resources.
Disclosure of Invention
Aiming at the defects in the prior art, the invention provides a report generation method based on visual view configuration, which comprises the following steps:
s1, acquiring an existing data set or selecting a required field to create a data set in a database of a production and manufacturing system to form an analysis data set consisting of a plurality of data sets, wherein the data sets comprise a plurality of field data which are mutually related;
s2, carrying out two-by-two connection on the data sets in the analysis data set, wherein the two ends of the connection are respectively connected with the target fields of the two data sets, endowing connection screening conditions, configuring the combination relation of the two associated data sets, wherein the screening conditions are configured as judgment selection rules for the parameter values of the target fields at the two ends of the connection, and the combination relation is a field screening rule required to be output after the associated data sets are combined;
s3, acquiring target field parameter values meeting requirements and other field parameter values corresponding to the target field parameter values in the data set according to screening conditions, acquiring output fields after the two associated data sets are combined and screened corresponding field parameter values according to field screening rules of the associated data sets, and generating a visual report.
Preferably, the judgment selection rule for each parameter value of the target fields at the two ends of the connection line includes, but is not limited to, that the parameter values of the two target fields are identical, that the parameter value of the first target field is greater than the parameter value of the second target field, or that the parameter value of the first target field is less than the parameter value of the second target field.
Preferably, the connection is configured with a direction identifier, and the judgment selection rule generates the judgment selection rule of the parameter values corresponding to the two target fields respectively by configuring the judgment logic and the direction of the direction identifier on the connection.
Preferably, the step S2 further includes recommending a corresponding judgment selection rule according to a type of the target field parameter value, where the type of the target field parameter value includes an attribute value and a variable value.
Preferably, the combination relation includes all fields including the associated data set, mainly the fields of the first data set at the wire end, mainly the fields of the second data set at the wire end, or mainly the target fields of the wire.
Preferably, the step S3 further includes: and generating a view result SQL statement according to the output field combined by the associated data set and the filtered corresponding field parameter value, checking the generated view result SQL statement according to the grammar of the SQL statement, and analyzing to generate a visual report.
The invention also discloses a report generating system based on the visual view configuration, which comprises: the data setting module is used for acquiring an existing data set or selecting a required field to create a data set in a database of the production and manufacturing system to form an analysis data set consisting of a plurality of data sets, wherein the data sets comprise a plurality of field data which are mutually related; the association module is used for carrying out two-by-two connection on the data sets in the analysis data set, the two ends of the connection are respectively connected with the target fields of the two data sets, the connection screening condition is given, the combination relation of the two association data sets is configured, the screening condition is configured to be a judgment selection rule for each parameter value of the target fields at the two ends of the connection, and the combination relation is a field screening rule required to be output after the association data sets are combined; and the screening module is used for acquiring the target field parameter values meeting the requirements and other field parameter values corresponding to the target field parameter values in the data set according to the screening conditions, acquiring the output field after the two associated data sets are combined and the screened corresponding field parameter values according to the field screening rules of the associated data sets, and generating a visual report.
Preferably, the judgment selection rule for each parameter value of the target fields at the two ends of the connection line includes, but is not limited to, that the parameter values of the two target fields are identical, that the parameter value of the first target field is greater than the parameter value of the second target field, or that the parameter value of the first target field is less than the parameter value of the second target field.
Preferably, the connection is configured with a direction identifier, and the judgment selection rule generates the judgment selection rule of the parameter values corresponding to the two target fields respectively by configuring the judgment logic and the direction of the direction identifier on the connection.
The invention also discloses a server, which comprises a memory, a processor and a computer program stored in the memory and capable of running on the processor, wherein the processor realizes the steps of the report generating method based on the visual view configuration when executing the computer program.
According to the report generation method, the system and the server based on the visual view configuration, through creating a plurality of field data sets, setting connection lines between fields respectively located in different data sets and giving connection screening conditions corresponding to the connection lines and a data set combination relation, rapid screening and two-data set combination of target fields in related data sets can be achieved by adjusting the connected fields and connection line attributes at two ends of the connection lines, and finally, required target fields and corresponding field parameter values are obtained, and a required visual report is generated according to the fields and the parameter values. The field implementation personnel can configure the front-end interface in a wired mode according to the data wanted by the field implementation personnel, and then view SQL sentences are automatically generated, so that the data analysis and screening efficiency of the field implementation personnel is effectively provided.
Additional aspects and advantages of the invention will be set forth in part in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiments of the invention and together with the description serve to explain the invention and do not constitute a limitation on the invention. In the drawings:
fig. 1 is a flow chart of a report generating method based on visual view configuration disclosed in this embodiment.
Fig. 2 is a schematic diagram of two data set connection disclosed in this embodiment.
Fig. 3 is a schematic diagram illustrating a rule setting for determining and selecting target fields at two ends of a connection line according to the present embodiment.
Fig. 4 is a specific flowchart of step S3 disclosed in this embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention more clear, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings of the embodiments of the present invention. It will be apparent that the described embodiments are some, but not all, embodiments of the invention. All other embodiments, which can be made by a person skilled in the art without creative efforts, based on the described embodiments of the present invention fall within the protection scope of the present invention.
Unless defined otherwise, technical or scientific terms used herein should be given the ordinary meaning as understood by one of ordinary skill in the art to which this invention belongs. The terms "first," "second," and the like in the description and in the claims, are not used for any order, quantity, or importance, but are used for distinguishing between different elements. Likewise, the terms "a" or "an" and the like do not denote a limitation of quantity, but rather denote the presence of at least one.
The MES is a production informatization management system facing the workshop execution layer of a manufacturing enterprise, is widely applied to the fields of metallurgy, pharmacy and the like, and can realize the acquisition and tracking of production data of products and parts, the management of operators, the real-time monitoring of production states and the quality control. Thus, MES systems can generate large amounts of data during operation, which are stored in a large number of individual data sets. The embodiment discloses a report generating method based on visual view configuration, which can be used for combining data wanted by a third party system by adopting a view configuration mode. Rather than by conventional code customization or by a third party through a complex database language. The report generation method can enable on-site implementation personnel to directly configure on an interface according to the data wanted by the on-site implementation personnel.
As shown in fig. 1, the report generating method based on the visual view configuration disclosed in this embodiment may include the following steps.
Step S1, acquiring an existing data set or selecting a required field to create a data set in a database of a production and manufacturing system to form an analysis data set consisting of a plurality of data sets, wherein the data sets comprise a plurality of field data with mutual correlation.
In the MES system, most of data sets generated by production are built in for the convenience of users to select. The user can select the data set according to the requirement, put the wanted data field in the database in one data set, or the user can randomly build the data set according to the requirement. In fig. 2, one data set is deviation record data, which includes data fields such as deviation identification, programming code, deviation status, product code, product name, product specification, etc., while the other data set is batch deviation data, which includes data fields such as deviation identification, product lot number, work order good, product name, etc. In this embodiment, the data set includes a plurality of fields reflecting characteristics of each production process arranged in a longitudinal direction, and each characteristic field in the data set is associated with each mutually corresponding characteristic data in the target object database.
And S2, carrying out two-by-two connection on the data sets in the analysis data set, wherein the two ends of the connection are respectively connected with the target fields of the two data sets, endowing the connection with screening conditions, configuring the combination relation of the two related data sets, wherein the screening conditions are configured as judgment selection rules for the parameter values of the target fields at the two ends of the connection, and the combination relation is a field screening rule required to be output after the related data sets are combined.
The judging and selecting rule for each parameter value of the target fields at the two ends of the connection line includes, but is not limited to, that the parameter values of the two target fields are identical, that the parameter value of the first target field is greater than the parameter value of the second target field, or that the parameter value of the first target field is smaller than the parameter value of the second target field. Wherein the combination relationship may include all fields including the associated data set, a primary field of the first data set at the link, a primary field of the second data set at the link, or a primary target field of the link. As shown in figure 2, two fields with logic relation in two data sets are connected through a connecting line, and then a judgment selection rule between the two fields and a combination relation of the two data sets are set. As shown in fig. 3, the judgment selection rule between the two fields may be equal to (=), greater than (>), greater than or equal to (> =) or the like. 4 kinds of combination relations can be set between two data sets, and the combination relations respectively correspond to inner join (no relation between two data sets) between every two data sets of the database table, left join (mainly data set on the left side of a connecting line), right join (mainly data set on the right side of the connecting line), full join (all fields of the data sets on the two sides of the connecting line).
In a specific embodiment, the connection between the data sets may also be configured with a direction identifier, and the judgment selection rule generates the judgment selection rule of the parameter values corresponding to the two target fields respectively by configuring the judgment logic and the direction of the direction identifier on the connection. Specifically, the judgment and selection rule may be set by using the directivity of the direction identifier, for example, the judgment and selection rule between two fields may be that the parameter value of the pointing target field on the direction identifier is greater than the parameter value of the starting target field, or the parameter value of the pointing target field is smaller than the parameter value of the starting target field, and so on. In addition, the combination relationship can be accurately set according to the direction identifier, for example, the combination relationship can be mainly composed of fields in the data set pointed by the connecting line arrow or mainly composed of fields in the data set started by the connecting line arrow.
In this embodiment, step S2 further includes recommending a corresponding judgment selection rule according to a type of the target field parameter value, where the type of the target field parameter value includes an attribute value and a variable value. In each data set, there is a field in which the type of the target field parameter value is an attribute value, that is, the content of the field parameter value is a text, letter or symbol, for example, a product name, operator, creator, work center name, etc.; in addition, most of the target field parameter value types are variable values, namely the field parameter value content consists of numbers, mathematical symbols and the like, and various mathematical logic judgment can be performed, such as fields of deviation state, product specification, working time, starting time and the like. When the parameter value type is an attribute value, only the judgment of whether the parameter values of the two target fields are the same is often performed, and when the parameter value type is a variable value, the comparison of the sizes of the parameter values of the target fields at the two ends of the connection line, even more complex weighting operation on the parameter values, and then the comparison with the equivalent complex mathematical judgment logic can be performed. Therefore, the server can firstly acquire the type of the parameter value of the target field, and then recommend the judgment and selection rule corresponding to each parameter value type according to different types of the parameter value of the target field, namely the attribute value or the variable value, so that the setting of the judgment and selection rule is more convenient for operators.
In another embodiment, whether the setting of the judgment selection rule of the connection input by the operator is correct or not can be checked according to the obtained type of the target field parameter values at the two ends of the connection, if the type of the target field parameter values is not suitable for the judgment selection rule, prompting is performed, and the matched judgment selection rule is selected from the rule database according to the type of the target field parameter values for recommendation display for the operator to select.
And S3, acquiring target field parameter values meeting the requirements and other field parameter values corresponding to the target field parameter values in the data set according to screening conditions, and acquiring output fields after the two associated data sets are combined and screened corresponding field parameter values according to field screening rules of the associated data sets to generate a visual report. Wherein as shown in fig. 4, this step may specifically include the following.
Step S31, inquiring the parameter values of the target fields at the two ends of the connecting line connecting the data sets in the database respectively.
Step S32, obtaining a judgment selection rule of the connection line, respectively comparing the parameter values belonging to the two target fields one by one according to the judgment selection rule, and obtaining the parameter value of the target field which accords with the judgment selection rule as a screening parameter value input field parameter value screening library.
Step S33, traversing each field contained in the two associated data sets, acquiring output fields after the two associated data sets are combined according to a field screening rule in a combination relation of the associated data sets, inquiring output field parameter values corresponding to the screening parameter values in a database according to the screening parameter values of target fields in a field parameter value screening library, and merging the acquired output fields and the screened output field parameter values to generate SQL sentences of view results.
For example, in the two connected data sets shown in fig. 2 and fig. 3, the selection rule is judged to be that the parameter values of the two fields at the two ends of the connection line are the same, that is, the parameter values of the fields with the same product name in the two data sets are selected. If the combination relation of the two data sets, namely, the field screening rule, selects the full join option, namely, all fields of the data sets on two sides of the connection line, all fields in the two data sets and parameter values of all fields corresponding to the same product name in the fields are acquired, and finally, the SQL statement generating the final view result is output. Thereby conveniently obtaining the desired result by the random combination relation. The view SQL statement is generated by configuration through the front-end interface connection mode, and the view is associated in the visual report service, so that the discrete associated data are finally displayed in various forms of a report, such as a pie chart, a histogram, a line graph and the like.
In an embodiment, step S3 further includes: and generating a view result SQL statement according to the output field combined by the associated data set and the filtered corresponding field parameter value, checking the generated view result SQL statement according to the grammar of the SQL statement, and analyzing to generate a visual report.
In this embodiment, the SQL sentence automatically generated by the system or the SQL sentence edited by the user may be checked according to the syntax of the SQL sentence. And analyzing the final SQL sentence according to an autonomously developed lexical analysis method. After verification is successful, the report form in the system or the third party external system can be directly used. Through lexical analysis, the sql statement edited by the user in a self-definition manner is analyzed and verified according to the keyword priority principle, and the method can specifically comprise the following contents.
A key word library of the SQL grammar is established, and all key words and functions of the SQL grammar are combined into a set. Dividing the SQL statement customized by the user according to the space as a separator to form an SQL statement linked list.
And performing keyword or function matching on the characters in the linked list, and marking the matched characters with keywords or functions. And prompting the random word strings according to the keyword and the function set and the highest matching degree, for example, if the word strings are in the form of sam, and prompting whether the word strings are sum.
And checking the next node of the linked list of the marked character string according to the rule of the SQL sentence. But where two keywords cannot be linked. If the key words are function expressions, function parameters in the sentence linked list are searched, and if the parameters do not meet the requirements, a prompt is given. And finally executing the whole SQL statement for creating the view.
In another embodiment, a plurality of links may be disposed between two data sets, where each link is provided with a judgment priority level in addition to a judgment selection rule. And screening and sorting the connection line between the two data sets according to the priority, comparing and selecting the parameter values of the fields at the two ends of the connection line according to the judging and selecting rule in sequence, and storing the field parameter values meeting the requirements as screening values and inputting the screening values into a field parameter value screening library.
And screening the fields at the two ends of the connecting lines with the same priority level according to the judging and selecting rules by acquiring the priority level in the attribute information attached to each connecting line, and inputting the field parameter values corresponding to the judging and selecting rules of a plurality of connecting lines simultaneously conforming to the same priority level into a field parameter value screening library.
And screening and sorting the connection lines with different priority levels according to the priority levels, comparing and selecting characteristic field parameter values at two ends of each connection line according to a judging and selecting rule, and supplementing the field parameter values meeting the requirements into a characteristic field parameter value screening library as screening values.
For the connection lines with different priority levels, if one end of a plurality of connection lines is connected with the same characteristic field in the same data set, the characteristic field parameter values which simultaneously accord with the corresponding judging and selecting rules of the plurality of connection lines are input into the characteristic field parameter value screening library.
If the attached attribute information of one connection has no judging priority, the highest priority is given to the attached attribute information to participate in screening and sorting processing of each connection identifier, the parameter values of the characteristic fields at the two ends of the connection identifier are compared and selected according to the judging and selecting rule of each connection identifier in sequence, and the field parameter values meeting the requirements are stored as screening values to be input into a field parameter value screening library.
In the above embodiment, in order to make the configuration of the connection line between two data sets and the incidental attribute information of the connection line more intuitive and faster, the incidental attribute information may be directly recorded according to the intersection condition of a plurality of connection lines arranged between two data sets, which may specifically include the following.
Constructing a first connection mark among a plurality of selected fields respectively positioned in two data sets, and inputting a selected judgment selection rule in the incidental attribute information of the connection mark; if the constructed first line identifier is intersected with a second line identifier existing between the two data sets, respectively inputting first selection rules into the incidental attribute information of the first line identifier and the second line identifier; if the constructed first line identifier is not intersected with the second line identifier existing between the two data sets, the second selection rule is respectively input into the incidental attribute information of the first line identifier and the second line identifier. The first selection rule is configured to take a corresponding field parameter value of a judgment selection rule conforming to any one of the intersected multiple line identifiers as a screening value group of the line identifiers. The second selection rule is configured to take a corresponding field parameter value of a judgment selection rule of any one of the line identifications without the intersecting feature as a screening value group of the line identifications.
In this embodiment, color marking may also be performed on the connection line identifiers in different states. Specifically, if the constructed first connection mark intersects with a second connection mark existing between the two data sets, giving a first color feature to two fields at two ends of the first connection mark and two fields at two ends of the second connection mark; and the fields at both ends of the other connection marks without the intersection form are endowed with the second color characteristic. When the intersection state of the line mark and the color feature is changed due to the fact that the line mark follows the end field to move up and down in the data set where the line mark is located, the line mark and the color feature are adjusted simultaneously, for example, the line mark is controlled to follow the end field to move up and down in the data set where the line mark is located so as to change the intersection condition of the line mark and other line marks; and after the intersection morphology of the line marks is changed and the update position confirmation of the end field is received, updating the attached attribute information of the related line marks and adjusting the corresponding color characteristics of the fields. Therefore, the selection relation among the connecting line fields can be visually judged through the field colors, and the configuration adjustment efficiency of field data in the data set is effectively improved.
And comparing and selecting the parameter values of the fields at the two ends of the connection mark according to the judging and selecting rule to obtain the field parameter values meeting the requirements as screening value groups of the connection mark, adjusting the screening value groups according to the selecting rule in the attached attribute information of each connection mark to obtain a plurality of target field parameter values, obtaining other field parameter values corresponding to the target field parameter values in respective data sets, and inputting the field parameter values into a field parameter value screening library.
According to the report generation method based on the visual view configuration, a plurality of field data sets are created, connection lines are arranged between fields respectively located in different data sets, connection screening conditions corresponding to the connection lines are given to the connection lines, and the combination relation of the data sets is given, so that rapid screening and combination of two data sets on target fields in the associated data sets can be achieved by adjusting the connected fields and the connection line attributes at two ends of the connection lines, and finally required target fields and corresponding field parameter values are obtained, and a required visual report is generated according to the fields and the parameter values. The field implementation personnel can configure the front-end interface in a wired mode according to the data wanted by the field implementation personnel, and then view SQL sentences are automatically generated, so that the data analysis and screening efficiency of the field implementation personnel is effectively provided.
In another embodiment, a report generating system based on visual view configuration is also disclosed, which comprises a data setting module, an association module and a screening module, wherein the data setting module is used for acquiring an existing data set or selecting a required field to create a data set in a database of a production and manufacturing system to form an analysis data set consisting of a plurality of data sets, and the data set comprises a plurality of field data with mutual association. The association module is used for carrying out two-by-two connection on the data sets in the analysis data set, the two ends of the connection are respectively connected with the target fields of the two data sets, the connection screening condition is given, the combination relation of the two association data sets is configured, the screening condition is configured to be a judgment selection rule for each parameter value of the target fields at the two ends of the connection, and the combination relation is a field screening rule required to be output after the association data sets are combined. And the screening module is used for acquiring the target field parameter values meeting the requirements and other field parameter values corresponding to the target field parameter values in the data set according to the screening conditions, acquiring the output field after the two associated data sets are combined and the screened corresponding field parameter values according to the field screening rules of the associated data sets, and generating a visual report.
In this embodiment, the judgment and selection rule for each parameter value of the target fields at both ends of the connection includes, but is not limited to, that the parameter values of the two target fields are the same, that the parameter value of the first target field is greater than the parameter value of the second target field, or that the parameter value of the first target field is less than the parameter value of the second target field. The connection line is configured with a direction mark, and the judgment selection rule generates the judgment selection rule of the parameter values corresponding to the two target fields respectively by configuring the judgment logic and the direction of the direction mark on the connection line.
It should be noted that, in the present description, each embodiment is described in a progressive manner, and each embodiment is mainly described in a different manner from other embodiments, and identical and similar parts between the embodiments are all enough to refer to each other. For the report generating system based on the visual view configuration disclosed by the embodiment, the description is simpler because the report generating system based on the visual view configuration corresponds to the report generating method based on the visual view configuration disclosed by the embodiment, and relevant parts refer to the description of the method part.
In other embodiments, there is also provided a server comprising a memory, a processor and a computer program stored in the memory and executable on the processor, the processor implementing the steps of the visual view configuration based report generation method as described in the embodiments above when the computer program is executed.
Finally, it should be noted that: the above embodiments are only for illustrating the technical solution of the present invention, and are not limiting; although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit of the invention.
In summary, the foregoing description is only of the preferred embodiments of the present invention, and all equivalent changes and modifications made in accordance with the claims should be construed to fall within the scope of the invention.
Claims (10)
1. A report generation method based on visual view configuration is characterized by comprising the following steps:
s1, acquiring an existing data set or selecting a required field to create a data set in a database of a production and manufacturing system to form an analysis data set consisting of a plurality of data sets, wherein the data sets comprise a plurality of field data which are mutually related;
s2, carrying out two-by-two connection on the data sets in the analysis data set, wherein the two ends of the connection are respectively connected with the target fields of the two data sets, endowing connection screening conditions, configuring the combination relation of the two associated data sets, wherein the screening conditions are configured as judgment selection rules for the parameter values of the target fields at the two ends of the connection, and the combination relation is a field screening rule required to be output after the associated data sets are combined;
s3, acquiring target field parameter values meeting requirements and other field parameter values corresponding to the target field parameter values in the data set where the target field is located according to screening conditions, and acquiring output fields after the two associated data sets are combined and screened corresponding field parameter values according to field screening rules of the associated data sets to generate a visual report.
2. The visual view configuration-based report generating method as claimed in claim 1, wherein: the judging and selecting rule for each parameter value of the target fields at the two ends of the connection line includes, but is not limited to, that the parameter values of the two target fields are identical, that the parameter value of the first target field is greater than the parameter value of the second target field, or that the parameter value of the first target field is smaller than the parameter value of the second target field.
3. The visual view configuration-based report generating method as claimed in claim 2, wherein: the connection line is configured with a direction mark, and the judgment selection rule generates the judgment selection rule of the parameter values corresponding to the two target fields respectively by configuring the judgment logic and the direction of the direction mark on the connection line.
4. A visual view configuration-based report generating method as claimed in claim 3, wherein: the step S2 further includes recommending a corresponding judgment selection rule according to a type of the target field parameter value, where the type of the target field parameter value includes an attribute value and a variable value.
5. The report generating method based on the visual view configuration according to any one of claims 1 to 4, wherein: the combination relation comprises all fields comprising the associated data set, the fields of the first data set at the wire end are mainly used, the fields of the second data set at the wire end are mainly used, or the target fields of the wire are mainly used.
6. The report generating method based on the visual view configuration of claim 5, wherein the step S3 further comprises:
and generating a view result SQL statement according to the output field combined by the associated data set and the filtered corresponding field parameter value, checking the generated view result SQL statement according to the grammar of the SQL statement, and analyzing to generate a visual report.
7. A report generation system based on visual view configuration, comprising:
the data setting module is used for acquiring an existing data set or selecting a required field to create a data set in a database of the production and manufacturing system to form an analysis data set consisting of a plurality of data sets, wherein the data sets comprise a plurality of field data which are mutually related;
the association module is used for carrying out two-by-two connection on the data sets in the analysis data set, wherein the two ends of the connection are respectively connected with the target fields of the two data sets, the connection screening condition is given, the combination relation of the two association data sets is configured, the screening condition is configured to be a judgment selection rule for each parameter value of the target fields at the two ends of the connection, and the combination relation is a field screening rule required to be output after the association data sets are combined;
and the screening module is used for acquiring the target field parameter value meeting the requirements and other field parameter values corresponding to the target field parameter value in the data set where the target field is located according to the screening conditions, acquiring the output field after the two associated data sets are combined and the screened corresponding field parameter value according to the field screening rule of the associated data set, and generating a visual report.
8. The visual view configuration-based report generating system of claim 7, wherein: the judging and selecting rule for each parameter value of the target fields at the two ends of the connection line includes, but is not limited to, that the parameter values of the two target fields are identical, that the parameter value of the first target field is greater than the parameter value of the second target field, or that the parameter value of the first target field is smaller than the parameter value of the second target field.
9. The visual view configuration-based report generating system of claim 8, wherein: the connection line is configured with a direction mark, and the judgment selection rule generates the judgment selection rule of the parameter values corresponding to the two target fields respectively by configuring the judgment logic and the direction of the direction mark on the connection line.
10. A server comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized by: the processor, when executing the computer program, implements the steps of the method according to any one of claims 1-6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310106194.2A CN115827644B (en) | 2023-02-13 | 2023-02-13 | Report generation method, system and server based on visual view configuration |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310106194.2A CN115827644B (en) | 2023-02-13 | 2023-02-13 | Report generation method, system and server based on visual view configuration |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115827644A CN115827644A (en) | 2023-03-21 |
| CN115827644B true CN115827644B (en) | 2023-06-09 |
Family
ID=85521121
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310106194.2A Active CN115827644B (en) | 2023-02-13 | 2023-02-13 | Report generation method, system and server based on visual view configuration |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115827644B (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109471890A (en) * | 2018-10-16 | 2019-03-15 | 深圳壹账通智能科技有限公司 | Generation method, terminal device and the medium of report file |
| CN114896248A (en) * | 2022-05-16 | 2022-08-12 | 翁秀萍 | Method and device for generating sql by automatic splicing based on association pool data table |
Family Cites Families (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10255320B1 (en) * | 2014-01-27 | 2019-04-09 | Microstrategy Incorporated | Search integration |
| US11269889B1 (en) * | 2018-05-09 | 2022-03-08 | Christopher James Aversano | Graphical user interface driven programming development environment |
| CN111309721A (en) * | 2018-12-11 | 2020-06-19 | 北京京东尚科信息技术有限公司 | Method and device for determining association relation of data table |
| CN109992589B (en) * | 2019-04-11 | 2020-04-10 | 北京启迪区块链科技发展有限公司 | Method, device, server and medium for generating SQL (structured query language) statements based on visual page |
| CN113138996A (en) * | 2020-01-16 | 2021-07-20 | 腾讯科技（深圳）有限公司 | Statement generation method and device |
| US11886399B2 (en) * | 2020-02-26 | 2024-01-30 | Ab Initio Technology Llc | Generating rules for data processing values of data fields from semantic labels of the data fields |
| CN111782651A (en) * | 2020-06-30 | 2020-10-16 | 平安国际智慧城市科技股份有限公司 | Visual editing method, device and equipment for data association relation and storage medium |
| CN115495508A (en) * | 2022-09-23 | 2022-12-20 | 中国建设银行股份有限公司 | Generating method and device of SQL (structured query language) statement for report and electronic equipment |
-
2023
- 2023-02-13 CN CN202310106194.2A patent/CN115827644B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109471890A (en) * | 2018-10-16 | 2019-03-15 | 深圳壹账通智能科技有限公司 | Generation method, terminal device and the medium of report file |
| CN114896248A (en) * | 2022-05-16 | 2022-08-12 | 翁秀萍 | Method and device for generating sql by automatic splicing based on association pool data table |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115827644A (en) | 2023-03-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10031938B2 (en) | Determining Boolean logic and operator precedence of query conditions | |
| US7644055B2 (en) | Rule-based database object matching with comparison certainty | |
| EP2369506B1 (en) | System and method of optimizing performance of schema matching | |
| CN112650766B (en) | Database data operation method, system and server | |
| US8326869B2 (en) | Analysis of object structures such as benefits and provider contracts | |
| US20070226754A1 (en) | Methods and Apparatus for Creation of Parsing Rules | |
| CN104636478A (en) | Information query method and device | |
| US10657206B2 (en) | Graphical user interface system and method for natural language generation editing | |
| US20080163158A1 (en) | System and method for efficient development of configurable software systems in a large software development community | |
| US8756205B2 (en) | System and method for rule-based data object matching | |
| US20120209867A1 (en) | Verifying consistency among device configurations based on comparing configuration files | |
| CN111814458A (en) | Rule engine system optimization method and device, computer equipment and storage medium | |
| US20220245153A1 (en) | Automated code generation for computer software | |
| Cil et al. | Linking of manufacturing strategy, market requirements and manufacturing attributes in technology choice: an expert system approach | |
| CN110322217A (en) | Manufacture cloud service Requirement Decomposition system and method based on template | |
| CN115827644B (en) | Report generation method, system and server based on visual view configuration | |
| WO2020085114A1 (en) | Information processing device, information processing method, and program | |
| CN116361546A (en) | Method and device for processing search request, electronic equipment and storage medium | |
| JP2004038656A (en) | Product design support device and method | |
| GB2463545A (en) | Rule creation for an apparatus including a Configuration Management Database (CMDB) | |
| US11308245B2 (en) | Systems and methods for facilitating evaluation of characteristics related to quality | |
| US8347236B1 (en) | Client server interface for a knowledge management system | |
| US20200218785A1 (en) | System and Method for Evaluating Quality Involving Data Nodes | |
| US20220207416A1 (en) | System and method of providing correction assistance on machine learning workflow predictions | |
| CN116226214A (en) | Screening management method, system and storage medium for field data set |
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 |