CN110717320A - Form/report designer and method suitable for multiple platforms and information management system - Google Patents
Form/report designer and method suitable for multiple platforms and information management system Download PDFInfo
- Publication number
- CN110717320A CN110717320A CN201910962078.4A CN201910962078A CN110717320A CN 110717320 A CN110717320 A CN 110717320A CN 201910962078 A CN201910962078 A CN 201910962078A CN 110717320 A CN110717320 A CN 110717320A
- Authority
- CN
- China
- Prior art keywords
- report
- configuration
- designer
- data
- unit
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 38
- 238000004458 analytical method Methods 0.000 claims abstract description 21
- 238000013461 design Methods 0.000 claims description 47
- 238000007726 management method Methods 0.000 claims description 33
- 238000012545 processing Methods 0.000 claims description 19
- 238000013502 data validation Methods 0.000 claims description 4
- 238000005457 optimization Methods 0.000 claims description 4
- 238000000605 extraction Methods 0.000 claims description 3
- 230000004927 fusion Effects 0.000 claims description 3
- 238000010586 diagram Methods 0.000 description 15
- 230000008569 process Effects 0.000 description 11
- 230000018109 developmental process Effects 0.000 description 5
- 239000000047 product Substances 0.000 description 5
- 238000009877 rendering Methods 0.000 description 5
- 230000008901 benefit Effects 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000011218 segmentation Effects 0.000 description 2
- 239000013589 supplement Substances 0.000 description 2
- 230000002776 aggregation Effects 0.000 description 1
- 238000004220 aggregation Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000013479 data entry Methods 0.000 description 1
- 238000013075 data extraction Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 239000000463 material Substances 0.000 description 1
- 235000012054 meals Nutrition 0.000 description 1
- 230000006855 networking Effects 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 238000007619 statistical method Methods 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
Images
Abstract
The invention discloses a form/report designer, a method and an information management system suitable for multiple platforms, wherein the form designer comprises the following components: the acquisition unit is used for acquiring the content of a form template file formed on the basis of form software; the analysis unit is used for analyzing the acquired form template file to acquire the form elements in the form template file; the configuration unit is used for adjusting and configuring the attributes of the form elements in the form template file according to user requirements to obtain an editable configuration file; the form generation unit is used for generating a corresponding form according to the analysis result of the analysis unit and the configuration file configuration of the corresponding configuration unit and storing the form into the server.
Description
Technical Field
The invention relates to the technical field of computer data processing, in particular to a form/report designer and method suitable for multiple platforms and an information management system.
Background
Since the knowledge economy of 21 st century, the traditional operation mode of enterprises is subverted by a computer, the computer becomes an important tool for enterprise management in modern enterprise management, the enterprise informatization era comes, and the enterprises are aware of the fact that the information technology is required to be applied to improve the enterprise competitiveness under the background of globalization, digitization and networking.
The information management system is defined as follows: according to the authority of different members in the organization, data is shared and transmitted among different members by using a proper workflow, so that various business targets are served. Enterprise informatization is essentially to digitize the production process, material movement, transaction processing, cash flow, customer interaction and other business processes of an enterprise, generate new information resources through various information system network processing, provide people at various levels with insight and observation of all information in various dynamic businesses, make a decision beneficial to production element combination optimization, make reasonable allocation of enterprise resources, so that the enterprise can adapt to the ever-changing market economic competition environment, and obtain the maximum economic benefit.
The form is an important ring in enterprise information management, different enterprises or fields often have special requirements on the form, and then managers can make enterprise decisions and management better. Forms are different from enterprise reports, which are often based on data aggregation and processing, and forms are often used to record daily management of an enterprise, and are complex in that they must be interactive and capable of being circulated among departments and personnel of the enterprise.
The design of a form often contains two parts: layout and data processing. The layout determines the display structure of the data, and the final purpose of the form is to provide an interface which is easy to use, convenient to enter and clear in data feedback for a user; data processing is used to maintain the data of forms, and in daily processing, forms not only require simple text entry, but often require processing of multiple data types, such as dates, drop-down boxes, file uploads, and the like.
At present, in the process of enterprise form design, most of the existing technical schemes are that a client writes service requirements, then a development or implementer customizes according to the requirements of the client, the development worker analyzes service logic, writes codes and deploys, and needs to understand the services and processes of the client in the period, so that not only is the communication cost very high and the implementation period very long, but also the mode is difficult to expand through configuration, a large amount of data extraction and processing, grouping and classification, form layout design and other work need to be carried out, and compiling, testing and deploying are needed after the compiling is finished, and a large amount of professional manpower and time need to be consumed for new increase or adjustment.
Disclosure of Invention
In order to overcome the defects of the prior art, the invention aims to provide a form/report designer, a method and an information management system which are suitable for multiple platforms, so that a user can automatically generate forms, reports and business logic of the information management system without understanding software development, and the information management system suitable for actual requirements of various enterprise and public institution organizations is quickly formed.
To achieve the above and other objects, the present invention provides a form designer suitable for multiple platforms, comprising:
the acquisition unit is used for acquiring the content of a form template file formed on the basis of form software;
the analysis unit is used for analyzing the acquired form template file content to acquire form elements in the form template file content;
the configuration unit is used for adjusting and configuring the attributes of the form elements in the form template file according to user requirements to obtain an editable configuration file;
and the form generation unit is used for generating a corresponding form according to the analysis result of the analysis unit and the configuration file configuration of the corresponding configuration unit and storing the corresponding form in the server.
Preferably, the parsing unit is specifically configured to:
extracting a form name according to the first line of the text content of the form template file;
extracting main data fields or detail fields according to the continuity of the form template file;
and respectively determining the attribute of each field according to the extracted main data field or detail field.
Preferably, the attributes include, but are not limited to, field location, data type, default values, data validation rules.
Preferably, the configuration unit is specifically configured to:
generating a configuration interface, wherein the configuration interface can provide the operation of configuring each main data field and detail field of the form element in a list form;
and acquiring configuration operation of each field information of the form element, and determining a configuration result of each field information according to the configuration operation to form the configuration file.
Preferably, the configuration unit further sets a unique primary key attribute for the form to be generated, the unique primary key attribute includes a unique number format and a unique number format, the uniqueness of the form represents a basis for determining the uniqueness of data, and the unique number format is used for a method for standardizing a number rule and a method for automatically numbering; data ordering is by field.
In order to achieve the above object, the present invention further provides a form design method suitable for multiple platforms, comprising the following steps:
step S1, acquiring a form template file formed based on form software;
step S2, analyzing the obtained form template file to obtain form elements therein;
step S3, adjusting and configuring the attributes of form elements in the form template file according to the user requirements to obtain an editable configuration file;
and S4, generating a corresponding form according to the analysis result of the step S2 and the corresponding configuration file configuration.
In order to achieve the above object, the present invention further provides a report designer suitable for multiple platforms, comprising:
a data source obtaining unit, configured to obtain multiple or single forms implemented by using a form designer as a data source;
the data field extraction unit is used for establishing an association relation and acquiring a corresponding field according to the selected data field required by the generated report;
the data field extraction unit is used for selecting corresponding fields according to the data fields required by the generated report, and establishing data acquisition rules of a plurality of forms by establishing the association relationship among the forms;
and the report generation unit is used for acquiring corresponding content according to the acquired field to generate a report and storing the report in the server.
Preferably, the report designer adaptable to multiple platforms as recited in claim 7, the report designer further comprising:
and the optimization unit is used for adding a function formula, a chart or a perspective table of the Excel in the report according to the requirement.
In order to achieve the above object, the present invention further provides a report design method suitable for multiple platforms, including:
step S1, acquiring a plurality of or a single form realized by the form designer as a data source;
and step S2, establishing the association relationship, acquiring the corresponding field generated report according to the selected data field required by the generated report, and storing the generated report in the server.
In order to achieve the above object, the present invention further provides an information management system, including:
the form design module is used for designing a plurality of forms by utilizing a form designer;
the report design module is used for designing a report by using a report designer;
the role authority design module is used for setting users, roles and authorities based on the RBAC management function so as to determine the users, roles and corresponding authorities of all the business processing flows;
the workflow design module is used for designing a workflow so as to serially connect the personnel, data and business processing flows of different forms;
and the fusion module is used for fusing the form design module, the report design module, the role authority design module and the workflow design module to form an information management system suitable for actual requirements of various enterprise and public institution organizations.
Compared with the prior art, the form/report designer, the method and the information management system suitable for multiple platforms acquire the form template file formed based on form software by using the acquisition unit, analyze the acquired form template file by using the analysis unit to acquire the form elements therein, adjust and configure the attributes of the form elements in the form template file according to the user requirements by using the configuration unit to obtain an editable configuration file, finally generate a corresponding form according to the analysis result of the analysis unit and the configuration file configuration of the corresponding configuration unit by using the form generation unit and store the corresponding form in the service end, the form, the report form and the business logic of the information management system can be automatically generated by a user without understanding software development, and the information management system suitable for actual requirements of various enterprise and public institution organizations is quickly formed.
Drawings
FIG. 1 is a system diagram of a form designer for multiple platforms according to a first embodiment of the present invention;
FIG. 2-1 is a diagram illustrating a form template drawn by Excel software according to an embodiment of the present invention;
FIG. 2-2 is a diagram of a form including a main data field and a detail field in accordance with an embodiment of the present invention;
FIG. 3 is a schematic diagram of a configuration interface of a configuration unit in an embodiment of the invention;
FIG. 4 is a diagram illustrating data field association in an embodiment of the present invention;
FIGS. 5-A, 5-B, and 5-C are diagrams illustrating a form set ordering function and unique primary key attributes according to embodiments of the present invention;
6-1, 6-2, 6-3, 6-4 are display interfaces of a list designer with an overtime registry as an example list in an embodiment of the present invention;
FIG. 7 is a flowchart of a form design method for multiple platforms according to a second embodiment of the present invention;
FIG. 8 is a system architecture diagram of a report designer for multiple platforms according to a third embodiment of the present invention;
FIG. 8-A is a diagram illustrating the establishment of an association relationship in an embodiment of the present invention;
FIG. 9 is a flowchart illustrating a report design method applicable to multiple platforms according to a fourth embodiment of the present invention;
FIG. 10 is a diagram of a system architecture of an information management system according to a fifth embodiment of the present invention;
FIG. 11 is a diagram illustrating an implementation of a form designer in an embodiment of the present invention;
FIG. 12 is a diagram illustrating an implementation process of a report designer in an embodiment of the present invention;
fig. 13 is a diagram of an implementation process of the information management system in the embodiment of the present invention.
Detailed Description
Other advantages and capabilities of the present invention will be readily apparent to those skilled in the art from the present disclosure by describing the embodiments of the present invention with specific embodiments thereof in conjunction with the accompanying drawings. The invention is capable of other and different embodiments and its several details are capable of modification in various other respects, all without departing from the spirit and scope of the present invention.
FIG. 1 is a system diagram of a form designer for multiple platforms according to a first embodiment of the invention. As shown in FIG. 1, the invention provides a form designer suitable for multiple platforms, comprising:
an obtaining unit 101 is configured to obtain the content of a form template file formed based on form class software. In an embodiment of the present invention, the form software may be an Excel software product of microsoft or a WPS software product of jinshan, that is, the user may draw a form template including a plurality of form elements based on the Excel software product of microsoft or the WPS software product of jinshan. In the embodiment of the present invention, taking the generation of an overtime registry as an example, an Excel software is used to draw a form template including a plurality of form elements, as shown in fig. 2-1, in the embodiment, the form elements of the overtime registry include departments, personnel, overtime dates, hours, supplements, remarks, and the like, and when the drawing is completed, a form template file is obtained, and the extension of the form template file is xlsx.
And the analyzing unit 102 is configured to analyze the obtained form template file to obtain a form element therein. Specifically, the parsing unit 102 obtains the text content, the position, the arrangement order, the cell format, and the like of the table elements by parsing the table template file.
In an embodiment of the present invention, the parsing process of the parsing unit 102 is as follows:
and extracting the form name according to the first line of the text content of the form template file. In the specific embodiment of the present invention, the form name is extracted according to the first line of the text content of the form template file: overtime registration form;
and extracting main data fields or detail fields according to the continuity of the form template file. In general, forms can be divided into two broad categories: one type is a form in which all form elements are main data fields, as shown in fig. 2-1, the second type is a form in which part of the form elements are main data fields and detailed fields are attached, as shown in fig. 2-2, the sales order includes main data fields (serial number, purchase date, status, customer number, customer name, contact number, remarks, and total amount), and detailed fields (product number, product name, quantity/station, price, subtotal, description, and the like). In the present invention, the main data field refers to a field that needs to be filled in only once in a form, and the detail field is characterized by containing a plurality of data with the same structure, such as a plurality of products in an order.
According to the extracted main data field or detail field, determining the attribute of each field respectively, in the specific embodiment of the present invention, the attribute of each field includes but is not limited to a field position, a data type, a default value, and a data validation rule (mandatory item, for example, greater than 0, uniqueness, etc.), and the data type of the field includes but is not limited to text, number, date, barcode, picture, drop-down selection, multiple selections, formula, progress bar type, etc. In the actual resolving process, the table element is resolved locally, and for uncertain contents sent to the server and fed back by the server according to historical resolving results, the field type and the like can be automatically determined in most cases, and only a few cases may need manual determination.
The configuration unit 103 adjusts and configures attributes of form elements in the form template file according to user requirements, so as to obtain an editable configuration file. That is, the attributes of the form elements can be configured by the user according to the actual situation of the form, so as to obtain the form meeting the user requirements.
In this embodiment, the form designer of the present invention needs to be associated with Excel software, and in the Excel software, the form designer is used to configure form elements in the form template file according to the analysis result.
Specifically, the configuration process of the configuration unit 103 is as follows:
generating a configuration interface, wherein the configuration interface can provide an operation for configuring each main data field and detail field of a form element in a list form, as shown in fig. 3;
specifically, a user can configure the form element according to requirements, for example, the data type of each form element is set, for example, for departments, the data type of each form element can be set as characters, for overtime dates, the data type of each form element can be set as a date type, preferably, for some special data types, corresponding contents need to be input, for example, the data type of a formula, a formula field is generated corresponding to the corresponding form element, and for the data type of a pull-down menu, a default value needs to be input, and comma segmentation is performed. The configuration may also include operations to add or delete a field, such as adding or deleting a field. The configuration may also include setting a corresponding association relationship for the field, and setting the data content to be taken out, for example, setting an association relationship between the person field and the department, so that when the person field is input, the association relationship of the department is automatically taken out, as shown in fig. 4.
Preferably, the configuration unit 103 can further set a unique primary key attribute for the form, including a unique and unique number format, the uniqueness of the form represents a data for determining a unique basis, such as an order number in an order, an item number of an item, and the like, the unique number format, a method for specifying a number rule and a method for automatic numbering, and an attribute for setting fields and an order of sorting basis and a reverse order, for example, a form sorting function is set by further setting of the form as shown in fig. 5-a and 5-B. Preferably, the configuration unit 103 may further set the form to be grouped so that it can be grouped and displayed in different terminals, for example, an Excel/WPS terminal, a Web terminal, and a mobile phone terminal, taking a project plan dispatch table as an example, as shown in fig. 5-C.
And the form generating unit 104 is configured to generate a corresponding form according to the analysis result of the analyzing unit 102 and the configuration file configuration of the corresponding configuration unit 103, and store the corresponding form in the server. In an embodiment of the present invention, the form generating unit 104 may generate a form according to a pre-designed form engine and according to an analysis result of the form template file and a configuration result of the configuration unit, and store the form in the server. After the form design is completed, the user can fill in the content according to the form style.
Preferably, the form designer of the present invention further comprises:
and the rendering unit 105 is configured to render the configured form according to different display platforms, so as to form a work form that can be accessed by each terminal. That is, the present invention designs various client products for different platforms, and then the client generates relevant codes for the platform where the client is located after obtaining contents such as form design configuration items, thereby executing various functions.
Specifically, the rendering unit 105 first generates program functions rendered by different terminals, such as web (html), applet (wxxml), then reads the form, and finally renders to produce an interface that the terminals can interact with. When the method is implemented in different terminals, for example, the operation behavior of the user is "view", the form configuration is firstly obtained, the form name of the form configuration item is displayed at a specified position, and finally specified codes are obtained according to field types (for example, 1.jpg, for HTML, img label is produced, for win32, picturebox component is produced, which is equivalent to the mode that the same information is analyzed to different platforms to be analyzed or displayed or interacted)
Taking an overtime registry as an example, the form template can be configured to a server side through the invention, then different clients perform interface generation service according to various platforms, for example, a display interface of a web page version client side is shown in fig. 6-1, when a user clicks a list, a list page is generated according to form template configuration content, when the user clicks creation, a data entry page is generated according to form template configuration, for example, as shown in fig. 6-2, and when the user clicks a certain data item (as shown in fig. 6-3), a viewing page (as shown in fig. 6-4) is rendered.
FIG. 7 is a flowchart illustrating a method for designing a form for multiple platforms according to a second embodiment of the present invention. As shown in fig. 7, the form design method of the present invention includes the following steps:
step S701, obtaining the content of the form template file formed based on the form software. In an embodiment of the present invention, the form software may be an Excel software product of microsoft or a WPS software product of jinshan, that is, the user may draw a form template including form elements based on the Excel software product of microsoft or the WPS software product of jinshan. In the embodiment of the present invention, taking the generation of an overtime registry as an example, an Excel software is used to draw a form template containing form elements, in this embodiment, the form elements of the overtime registry include departments, personnel, overtime dates, hours, meal supplements, remarks, and the like, and when the drawing is completed, a form template file is obtained, and the extension of the form template file is xlsx.
Step S702, analyzing the obtained form template file to obtain the form elements therein. Specifically, through parsing the table template file, the text content, the position and the arrangement order of the table elements, the cell format, and the like are obtained.
In the embodiment of the present invention, the parsing process of step S702 is as follows:
and extracting the form name according to the first line of the text content of the form template file. In the specific embodiment of the present invention, the form name is extracted according to the first line of the text content of the form template file: overtime registration form;
and extracting main data fields or detail fields according to the continuity of the form template file. In general, forms can be divided into two broad categories: one type is a form with all form elements as primary data fields, and the second type is a form with part of the form elements as primary data fields, with the addition of detail fields.
According to the extracted main data field or detail field, determining the attribute of each field respectively, in the specific embodiment of the present invention, the attribute of each field includes but is not limited to a field position, a data type, a default value, and a data validation rule (mandatory item, for example, greater than 0, uniqueness, etc.), and the data type of the field includes but is not limited to text, number, date, barcode, picture, drop-down selection, multiple selections, formula, progress bar type, etc.
Step S703 is to adjust and configure the attributes of the form elements in the form template file according to the user requirements, so as to obtain an editable configuration file. That is, the attributes of the form elements can be configured by the user according to the actual situation of the form, so as to obtain the form meeting the user requirements.
In this embodiment, the form designer of the present invention needs to be associated with Excel software, and in the Excel software, the form designer is used to configure form elements in the form template file according to the analysis result.
Specifically, the configuration process of step S703 is as follows:
generating a configuration interface, wherein the configuration interface can provide the operation of configuring each main data field and detail field of the form element in a list form;
specifically, a user can configure the form element according to requirements, for example, the data type of each form element is set, for example, for departments, the data type of each form element can be set as characters, for overtime dates, the data type of each form element can be set as a date type, preferably, for some special data types, corresponding contents need to be input, for example, the data type of a formula, a formula field is generated corresponding to the corresponding form element, and for the data type of a pull-down menu, a default value needs to be input, and comma segmentation is performed. The configuration may also include operations to add or delete a field, such as adding or deleting a field. The configuration may further include setting a corresponding association relationship for the field, and setting the data content to be taken out, for example, setting an association relationship between the person field and the department, so that when the person field is input, the association relationship of the department is automatically taken out, as shown in fig. 5.
Preferably, in step S703, a unique primary key attribute may be further set for the form, including a unique and a unique number format, where the uniqueness of the form represents a data for determining a unique basis, such as an order number in an order, an item number of an item, and the like, the unique number format, a method for specifying a number rule, and an automatic number method; and setting the fields according to the sorting and the attributes of the sequence and the reverse order. Preferably, in step S703, the form may be further grouped, so that the form may be grouped and displayed in different terminals, for example, an Excel/WPS terminal, a Web terminal, and a mobile phone terminal.
Step S704, generating a corresponding form according to the analysis result of step S702 and the corresponding configuration file configuration of step S703, and storing the corresponding form in the server. In the embodiment of the invention, the form can be generated according to the analysis result of the form template file and the configuration result of the configuration unit by a pre-designed form engine.
Preferably, the form designer of the present invention further comprises:
step S705, the configured form is rendered according to different display platforms, and a working form which can be accessed by each terminal is formed. That is, the present invention designs various client products for different platforms, and then the client generates relevant codes for the platform where the client is located after obtaining contents such as form design configuration items, thereby executing various functions.
FIG. 8 is a system architecture diagram of a report designer for multiple platforms according to a third embodiment of the present invention. As shown in fig. 8, the report designer applicable to multiple platforms in the present invention includes:
a data source acquiring unit 801, configured to acquire multiple or single forms implemented by using the aforementioned form designer as a data source. In the present invention, a plurality of forms may be implemented by using the aforementioned form designer and stored in the form library, and the data source obtaining unit 801 may obtain a plurality of or a single form in the form library.
The data field extracting unit 802 is configured to establish an association relationship, select a corresponding field according to the selected data field required for generating the report, and construct a data obtaining rule of a plurality of forms by establishing an association relationship between the forms.
The rule for establishing the incidence relation, namely the splicing of different table data, such as a collection invoice table and a customer information table, is required to be used as a part of data source of the report. The set association relationship is the number of the customer table, which is the customer code in the collection billing table, as shown in fig. 8-a.
The report generating unit 803 obtains the corresponding content according to the obtained field to generate a report, and stores the report in the server.
Preferably, the report designer of the present invention further comprises:
and the optimization unit is used for adding a function formula, a chart or a perspective table of the Excel in the report according to requirements so as to combine the functions of the formula, the chart, the perspective table and the like of the Excel to enable the report to better show the data significance. In particular embodiments of the invention, this may be done manually as desired.
FIG. 9 is a flowchart illustrating a report design method applicable to multiple platforms according to a fourth embodiment of the present invention. As shown in fig. 9, the report design method applicable to multiple platforms of the present invention includes:
in step S901, multiple or single forms implemented by the form designer are acquired as data sources. In the invention, a plurality of forms can be realized by utilizing the form designer and stored in the form library, and a plurality of or a single form can be obtained from the form library.
And step S902, establishing an association relation, acquiring corresponding fields according to the selected data fields required for generating the report, and storing the report in the server. As shown in fig. 9, assuming that the acquired data source is a sales order table,
preferably, the report design method applicable to multiple platforms of the present invention further includes:
step S903, adding a functional formula, a graph or a perspective table of the Excel in the report according to requirements, and combining the functions of the formula, the graph, the perspective table and the like of the Excel to enable the report to better show data significance.
Fig. 10 is a system architecture diagram of an information management system according to a fifth embodiment of the present invention. As shown in fig. 10, an information management system according to the present invention includes:
a form design module 10 for designing a plurality of forms using a form designer. The form designer is as described above and will not be described in detail herein.
The report design module 11 is configured to design a report by using a report designer, where the report designer is as described above and is not described herein again.
And a Role-based access Control (RBAC) -based management function, the Role-based access Control module 12 is configured to set users, roles, and permissions to determine users, roles, and corresponding permissions of each service processing flow, and only users or roles having corresponding permissions can process corresponding service flows.
And the workflow design module 13 is used for designing a workflow so as to serially connect the personnel, data and business processing flows of different forms. Generally, for a project, design workflow can be integrally linked to each other, so that related personnel can efficiently cooperate to complete the project. Assume that the complete workflow of a project is as follows: and (4) performing contract input, construction arrangement, project acceptance and collection execution, and designing the workflow for the form of each business flow to perform serial processing.
And the fusion module 14 is used for fusing the form design module 10, the report design module 11, the role authority design module 12 and the workflow design module 13 to form an information management system suitable for actual requirements of various enterprise and public institution organizations.
Example 1
As shown in FIG. 11, the form designer implements the following:
1. designing a form template by using a form software product, such as Excel software;
2. analyzing the table contents in the form template by a local server side to analyze the table elements in the form template;
3. extracting the analyzed form template content (namely the extracted form elements) into the form elements of the form to be generated;
4. the user adjusts according to the requirement, and configures the attribute of the form element according to the requirement;
5. completing the configuration of the form single element attributes, and generating a corresponding form according to the form single elements and the corresponding configuration;
6. storing the form to a server;
7. rendering processing is provided for different platforms, so that the form can run on various platforms;
8. the user can carry out operations such as data adding, deleting, checking, importing and exporting through each client.
Example 2:
as shown in FIG. 12, the report designer implements the following:
1. obtaining one or more forms implemented using a form designer;
2. establishing an association relation and extracting required data fields;
3. adding a function formula, a chart or a perspective table of the Excel according to the requirement, and combining the functions of the Excel such as the formula, the chart and the perspective table to enable the report to better show the data significance;
4. rendering processing is provided for different platforms, so that the report can run on various platforms;
5. the user can use the report form to carry out statistical analysis by each client.
Example 3
As shown in figure 13 of the drawings, in which,in this embodiment, the information management system of the present invention includes a combination of a form design module, a report design module, a role authority design module, and a workflow design module, and can quickly form an information management system suitable for actual needs of various enterprise and public institution, and meanwhile, the present invention can make designed information management system by providing rendering processing on different platformsThe information management system can run on various platforms.
In summary, the form/report designer, method and information management system suitable for multiple platforms of the present invention obtain a form template file formed based on form software by using an obtaining unit, analyze the obtained form template file by using an analyzing unit to obtain form elements therein, adjust and configure attributes of the form elements in the form template file according to user requirements by using a configuring unit to obtain an editable configuration file, finally generate a corresponding form according to an analysis result of the analyzing unit and a configuration file configuration of a corresponding configuring unit by using a form generating unit and store the corresponding form in a server, the form, the report form and the business logic of the information management system can be automatically generated by a user without understanding software development, and the information management system suitable for actual requirements of various enterprise and public institution organizations is quickly formed.
The foregoing embodiments are merely illustrative of the principles and utilities of the present invention and are not intended to limit the invention. Modifications and variations can be made to the above-described embodiments by those skilled in the art without departing from the spirit and scope of the present invention. Therefore, the scope of the invention should be determined from the following claims.
Claims (10)
1. A form designer adapted for multiple platforms, comprising:
the acquisition unit is used for acquiring the content of a form template file formed on the basis of form software;
the analysis unit is used for analyzing the acquired form template file to acquire the form elements in the form template file;
the configuration unit is used for adjusting and configuring the attributes of the form elements in the form template file according to user requirements to obtain an editable configuration file;
and the form generation unit is used for generating a corresponding form according to the analysis result of the analysis unit and the configuration file configuration of the corresponding configuration unit and storing the corresponding form in the server.
2. The form designer for multiple platforms as recited in claim 1, wherein the parsing unit is specifically configured to:
extracting a form name according to the first line of the text content of the form template file;
extracting main data fields or detail fields according to the continuity of the form template file;
and respectively determining the attribute of each field according to the extracted main data field or detail field.
3. The form designer for multiple platforms according to claim 2, wherein: the attributes include, but are not limited to, field location, data type, default values, and data validation rules.
4. The form designer for multiple platforms according to claim 2, wherein: the configuration unit is specifically configured to:
generating a configuration interface, wherein the configuration interface can provide the operation of configuring each main data field and detail field of the form element in a list form;
and acquiring configuration operation of each field information of the form element, and determining a configuration result of each field information according to the configuration operation to form the configuration file.
5. The form designer for multiple platforms according to claim 4, wherein: the configuration unit also sets a unique main key attribute for the form to be generated, wherein the unique main key attribute comprises a unique number format and a unique number format, the uniqueness of the form represents a data basis for determining a unique number, and the unique number format is used for a method for standardizing a number rule and a method for automatically numbering; and setting the fields according to the sorting and the attributes of the sequence and the reverse order.
6. A form design method suitable for multiple platforms comprises the following steps:
step S1, obtaining the content of the form template file formed based on the form software;
step S2, analyzing the acquired form template file content to acquire form elements therein;
step S3, adjusting and configuring the attributes of form elements in the form template file according to the user requirements to obtain an editable configuration file;
and S4, generating a corresponding form according to the analysis result of the step S2 and the corresponding configuration file configuration.
7. A report designer adapted for multiple platforms, comprising:
a data source obtaining unit, configured to obtain multiple or single forms implemented by using a form designer as a data source;
the data field extraction unit is used for selecting corresponding fields according to the data fields required by the generated report, and establishing data acquisition rules of a plurality of forms by establishing the association relationship among the forms;
and the report generation unit is used for acquiring corresponding content according to the acquired field to generate a report and storing the report in the server.
8. The report designer for multiple platforms according to claim 7, wherein the report designer further comprises:
and the optimization unit is used for adding a function formula, a chart or a perspective table of the Excel in the report according to the requirement.
9. A report design method suitable for multiple platforms comprises the following steps:
step S1, acquiring a plurality of or a single form realized by the form designer as a data source;
and step S2, establishing the association relationship, acquiring the corresponding field generated report according to the selected data field required by the generated report, and storing the generated report in the server.
10. An informatization management system, comprising:
the form design module is used for designing a plurality of forms by utilizing a form designer;
the report design module is used for designing a report by using a report designer;
the role authority design module is used for setting users, roles and authorities based on the RBAC management function so as to determine the users, roles and corresponding authorities of all the business processing flows;
the workflow design module is used for designing a workflow so as to serially connect the personnel, data and business processing flows of different forms;
and the fusion module is used for fusing the form design module, the report design module, the role authority design module and the workflow design module to form an information management system suitable for actual requirements of various enterprise and public institution organizations.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910962078.4A CN110717320A (en) | 2019-10-11 | 2019-10-11 | Form/report designer and method suitable for multiple platforms and information management system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910962078.4A CN110717320A (en) | 2019-10-11 | 2019-10-11 | Form/report designer and method suitable for multiple platforms and information management system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110717320A true CN110717320A (en) | 2020-01-21 |
Family
ID=69212479
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910962078.4A Pending CN110717320A (en) | 2019-10-11 | 2019-10-11 | Form/report designer and method suitable for multiple platforms and information management system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110717320A (en) |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111475513A (en) * | 2020-06-28 | 2020-07-31 | 平安国际智慧城市科技股份有限公司 | Form generation method and device, electronic equipment and medium |
| CN111709218A (en) * | 2020-05-28 | 2020-09-25 | 武汉比邻软件有限公司 | Intelligent reporting platform and intelligent reporting method based on dynamic multiple data sources |
| CN111737963A (en) * | 2020-07-21 | 2020-10-02 | 平安国际智慧城市科技股份有限公司 | Configuration file based form filling method and device and computer equipment |
| CN111859891A (en) * | 2020-07-30 | 2020-10-30 | 广东飞企互联科技股份有限公司 | System and method for quickly generating business form based on Word template |
| CN112711414A (en) * | 2020-12-28 | 2021-04-27 | 山东浪潮通软信息科技有限公司 | Form interface adaptation display method and device and storage medium |
| CN112989769A (en) * | 2021-02-08 | 2021-06-18 | 北京金和网络股份有限公司 | Method, device and platform for constructing multi-data-source form based on form engine |
| CN112989770A (en) * | 2021-04-07 | 2021-06-18 | 北京京东振世信息技术有限公司 | Form generation method, device and system, electronic equipment and storage medium |
| CN113011769A (en) * | 2021-03-31 | 2021-06-22 | 建信金融科技有限责任公司 | Item reservation method and device |
| CN113495887A (en) * | 2020-03-20 | 2021-10-12 | 北京沃东天骏信息技术有限公司 | Data form processing method, device and system |
| CN113591448A (en) * | 2021-08-03 | 2021-11-02 | 京东科技控股股份有限公司 | Report generation method and device and storage medium |
| CN113610396A (en) * | 2021-08-06 | 2021-11-05 | 三峡高科信息技术有限责任公司 | Method and system for structuring matrix designer based on construction quality acceptance table |
| CN113805853A (en) * | 2021-09-28 | 2021-12-17 | 重庆允成互联网科技有限公司 | Software product development system based on industrial internet |
| WO2022068396A1 (en) * | 2020-09-30 | 2022-04-07 | 京东方科技集团股份有限公司 | Follow-up form management method applied to health management system, health management system |
| CN114372177A (en) * | 2022-03-22 | 2022-04-19 | 创意信息技术股份有限公司 | Excel table data matching method |
| CN116402479A (en) * | 2023-06-07 | 2023-07-07 | 成都普朗克科技有限公司 | Method and system for generating inventory based on automatic modeling of order feature recognition |
| CN117453268A (en) * | 2023-12-26 | 2024-01-26 | 菲特（天津）检测技术有限公司 | Quick development platform for data management |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2801659A1 (en) * | 2012-01-09 | 2013-07-09 | Ezshield, Inc. | Identity management system and method including architecture for the same |
| CN103778107A (en) * | 2012-10-25 | 2014-05-07 | 上海宝信软件股份有限公司 | Method and platform for quickly and dynamically generating form based on EXCEL |
| CN104281447A (en) * | 2014-09-01 | 2015-01-14 | 国家电网公司 | Report form fast generating and issuing system and method |
| CN106649225A (en) * | 2016-12-30 | 2017-05-10 | 冶金自动化研究设计院 | JSON self-definition-based report generation system and method |
| CN108279879A (en) * | 2018-01-25 | 2018-07-13 | 北京卓越智软科技有限公司 | Applied software development method towards engine |
-
2019
- 2019-10-11 CN CN201910962078.4A patent/CN110717320A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2801659A1 (en) * | 2012-01-09 | 2013-07-09 | Ezshield, Inc. | Identity management system and method including architecture for the same |
| CN103778107A (en) * | 2012-10-25 | 2014-05-07 | 上海宝信软件股份有限公司 | Method and platform for quickly and dynamically generating form based on EXCEL |
| CN104281447A (en) * | 2014-09-01 | 2015-01-14 | 国家电网公司 | Report form fast generating and issuing system and method |
| CN106649225A (en) * | 2016-12-30 | 2017-05-10 | 冶金自动化研究设计院 | JSON self-definition-based report generation system and method |
| CN108279879A (en) * | 2018-01-25 | 2018-07-13 | 北京卓越智软科技有限公司 | Applied software development method towards engine |
Cited By (21)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113495887A (en) * | 2020-03-20 | 2021-10-12 | 北京沃东天骏信息技术有限公司 | Data form processing method, device and system |
| CN111709218A (en) * | 2020-05-28 | 2020-09-25 | 武汉比邻软件有限公司 | Intelligent reporting platform and intelligent reporting method based on dynamic multiple data sources |
| CN111475513A (en) * | 2020-06-28 | 2020-07-31 | 平安国际智慧城市科技股份有限公司 | Form generation method and device, electronic equipment and medium |
| CN111475513B (en) * | 2020-06-28 | 2020-10-02 | 平安国际智慧城市科技股份有限公司 | Form generation method and device, electronic equipment and medium |
| CN111737963B (en) * | 2020-07-21 | 2020-12-04 | 平安国际智慧城市科技股份有限公司 | Configuration file based form filling method and device and computer equipment |
| CN111737963A (en) * | 2020-07-21 | 2020-10-02 | 平安国际智慧城市科技股份有限公司 | Configuration file based form filling method and device and computer equipment |
| CN111859891A (en) * | 2020-07-30 | 2020-10-30 | 广东飞企互联科技股份有限公司 | System and method for quickly generating business form based on Word template |
| WO2022068396A1 (en) * | 2020-09-30 | 2022-04-07 | 京东方科技集团股份有限公司 | Follow-up form management method applied to health management system, health management system |
| CN112711414A (en) * | 2020-12-28 | 2021-04-27 | 山东浪潮通软信息科技有限公司 | Form interface adaptation display method and device and storage medium |
| CN112711414B (en) * | 2020-12-28 | 2022-10-11 | 浪潮通用软件有限公司 | Form interface adaptation display method and device and storage medium |
| CN112989769A (en) * | 2021-02-08 | 2021-06-18 | 北京金和网络股份有限公司 | Method, device and platform for constructing multi-data-source form based on form engine |
| CN113011769A (en) * | 2021-03-31 | 2021-06-22 | 建信金融科技有限责任公司 | Item reservation method and device |
| CN112989770A (en) * | 2021-04-07 | 2021-06-18 | 北京京东振世信息技术有限公司 | Form generation method, device and system, electronic equipment and storage medium |
| CN113591448A (en) * | 2021-08-03 | 2021-11-02 | 京东科技控股股份有限公司 | Report generation method and device and storage medium |
| CN113610396A (en) * | 2021-08-06 | 2021-11-05 | 三峡高科信息技术有限责任公司 | Method and system for structuring matrix designer based on construction quality acceptance table |
| CN113610396B (en) * | 2021-08-06 | 2022-02-11 | 三峡高科信息技术有限责任公司 | Method and system for structuring matrix designer based on construction quality acceptance table |
| CN113805853A (en) * | 2021-09-28 | 2021-12-17 | 重庆允成互联网科技有限公司 | Software product development system based on industrial internet |
| CN114372177A (en) * | 2022-03-22 | 2022-04-19 | 创意信息技术股份有限公司 | Excel table data matching method |
| CN116402479A (en) * | 2023-06-07 | 2023-07-07 | 成都普朗克科技有限公司 | Method and system for generating inventory based on automatic modeling of order feature recognition |
| CN116402479B (en) * | 2023-06-07 | 2023-09-19 | 成都普朗克科技有限公司 | Method and system for generating inventory based on automatic modeling of order feature recognition |
| CN117453268A (en) * | 2023-12-26 | 2024-01-26 | 菲特（天津）检测技术有限公司 | Quick development platform for data management |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110717320A (en) | Form/report designer and method suitable for multiple platforms and information management system | |
| US8996494B2 (en) | Systems and methods for modeling costed entities and performing a value chain analysis | |
| CN111125560B (en) | Data visualization processing method, device and computer system | |
| JP5475203B1 (en) | Workflow management apparatus and workflow management method | |
| CN111506444A (en) | Form approval method and device, storage medium and electronic equipment | |
| US20070136357A1 (en) | Methods and apparatus for designing a workflow process using inheritance | |
| US8224853B2 (en) | Methods and apparatus for updating a plurality of data fields in an electronic form | |
| WO2012000117A1 (en) | System and method for an integraged workflow process, social, contact and web marketing solution | |
| CN111401008A (en) | Document auditing system, document auditing method and device | |
| KR102221863B1 (en) | Server and system for it service management, and method thereof | |
| CN110796458B (en) | Information management system | |
| CN104182225A (en) | General mobile information system adaptation method and device | |
| CN114240340A (en) | Service data processing method and device, electronic equipment and readable storage medium | |
| US7996758B2 (en) | Methods and apparatus for storing data associated with an electronic form | |
| CN104182226A (en) | General mobile information system adaptation method and device | |
| JP2003114813A (en) | Analysis server, program analysis network system and program analysis method | |
| WO2007056656A2 (en) | Methods and apparatus for processing business objects, electronic forms, and workflows | |
| CN111984882A (en) | Data processing method, system and equipment | |
| CN104199648B (en) | A kind of General Mobile information system adaptation method and device | |
| CN111881038B (en) | Test case management method and device and electronic equipment | |
| AU2015204370A1 (en) | A modelling system and method for modelling a process or system | |
| US20070143711A1 (en) | Methods and apparatus for displaying a setup sequence | |
| JP2015095011A (en) | Document data management server, document data management program, and document data management device | |
| US20140372386A1 (en) | Detecting wasteful data collection | |
| US20070130138A1 (en) | Methods and apparatus for storing a collaboratively designed workflow process |
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 | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20200121 |