A method and system for information collection and query oriented to variable structure data

Abstract

The application discloses a method and system for information collection and query of variable structure data, and the method comprises the following steps: a management end customizes a variable structure data format according to collection requirements and saves the variable structure data format to a database; an application end selects information collection variable structure data formats corresponding to a collection interface, and renders the collection interface according to converted information collection variable structure data reports; the application end updates information collection variable structure data report information according to information filled by a user and saves the information to the database; the management end generates a query page according to information query variable structure data format information, filters in the database according to a query condition and a search condition, and displays a matching result after assembling data items corresponding to a display result in the information query variable structure data format, and the above steps are repeated if requirements change. The application efficiently deals with information change in information management through the variable structure data format, avoids repeated development when a report changes, and realizes a dynamic editable information management function.

Description

Technical Field

[0001] The present invention relates to the field of information management, and in particular to a method and system for information collection and querying for variable structure data. Background Art

[0002] Information management systems are essential information exchange systems for governments, banks, and businesses of all sizes. An excellent information management system is a crucial tool for improving information management efficiency. However, these systems face serious challenges with information changes, primarily in areas such as information collection and retrieval. First, traditional information management systems simply do not support structural changes to collected information. The templates used for information collection are essentially fixed, requiring system redevelopment to modify the collected information, a time-consuming, labor-intensive, and costly process. A similar problem exists with information retrieval: once the information changes, the corresponding search criteria and result display on the query page may need to be completely redeveloped. This exposes the shortcomings of traditional information management systems in their inability to adapt to the ever-changing nature of information. In this era of information explosion, the diversity, pluralism, and personalization of information are becoming increasingly apparent. Adapting to this diversity and pluralism is an inevitable trend in information management.

[0003] Therefore, a method and system for information collection and query for variable structure data are provided to solve the problem of adapting to information changes. Summary of the Invention

[0004] The purpose of the present invention is to provide a method and system for information collection and query for variable structure data, so as to efficiently respond to information changes in information management through variable structure data format, avoid repeated development when reports are changed, and realize dynamic and editable information management functions.

[0005] In a first aspect, the present invention provides a method for information collection and querying of variable structure data, comprising:

[0006] The management end receives the request for changes to the collected information content;

[0007] The management terminal customizes a variable structure data format according to preset steps for customizing a variable structure data format based on the requirements for changing the content of the collected information. The variable structure data format includes an information collection variable structure data format and an information query variable structure data format. The variable structure data format includes a format name, a format type, a format version, and data items. The data items include data features and display features. The data features include the data type, data storage field, and data verification method of the collected information. The display features include the data name, data display format, data form style, and data item display order of the collected information.

[0008] The management end saves the information collection variable structure data format information and the information query variable structure data format information into a database;

[0009] The database converts the information collection variable structure data format into an information collection variable structure data report and converts the information query variable structure data format into an information query variable structure data report;

[0010] The application end selects the information collection variable structure data format corresponding to the page version of the collection interface;

[0011] The application end renders the collection interface according to the information collection variable structure data report converted in the database according to the information collection variable structure data format;

[0012] After the user fills in the information in the collection interface, the application end updates the information collection variable structure data report information according to the information filled in by the user;

[0013] The application end saves the updated information collection variable structure data report information into the database;

[0014] The management end generates a query page according to the information query variable structure data report converted in the database according to the information query variable structure data format;

[0015] After the user inputs a search condition in the query page, the management end filters in the database according to the query condition of the query page and the search condition input by the user, assembles and displays the matching result according to the data item corresponding to the display result in the information query variable structure data format.

[0016] Further, the preset customized variable structure data format step comprises:

[0017] The management end edits the name and id of the variable structure data format;

[0018] Without adding data items, the management end saves the variable structure data format according to a new version, saves the basic information, format type information and format version information of the variable structure data format in the variable structure data table of the database, and saves the data characteristic information and display characteristic information of the data items of the variable structure data format in the data item table of the database;

[0019] In the case of adding data items, the management end adds data items and edits the data item name and id, selects the data type of the data item, edits the data form style of the data item, modifies the display row number and width in the data display form of the data item, modifies the display order of the data item, and edits the data verification method of the data item.

[0020] Further, the application end renders the collection interface according to the information collection variable structure data report table converted from the information collection variable structure data format in the database, including:

[0021] The application end determines whether there is a report data item in the information collection variable structure data report table; wherein the report data item in the information collection variable structure data report table includes the display feature and the data feature of the corresponding data item in the information collection variable structure data format, and the report data item in the information collection variable structure data report table further includes a value range;

[0022] If there is a report data item in the information collection variable structure data report table, the application end generates corresponding report content in the collection interface for each report data item in the information collection variable structure data report table;

[0023] If there is no report data item in the information collection variable structure data report table, the process is ended and exited.

[0024] Further, the application end generates corresponding report content in the collection interface for each report data item in the information collection variable structure data report table, including:

[0025] The application end displays the report data item name, the data rendering object, the rendering object width and the report data item arrangement order in the collection interface according to the display feature of the report data item in the information collection variable structure data report table;

[0026] The application end displays whether it is required to fill in according to the data feature of the report data item in the information collection variable structure data report table;

[0027] The application end processes the data type according to the data feature of the report data item in the information collection variable structure data report table.

[0028] Further, the database converts the information collection variable structure data format into the information collection variable structure data report table, including:

[0029] The database obtains the basic information and the format type information of the information collection variable structure data format from the variable structure data table;

[0030] The database fills the basic information into the report basic information table of the database as the basic information of the information collection variable structure data report table;

[0031] The database fills the format type information into the report type table of the database as the report type information of the information collection variable structure data report table;

[0032] The database reads the data feature information and the display feature information of the data item of the information collection variable structure data format from the data item table and fills them into the report data item table of the database as the data feature information and the display feature information of the report data item in the information collection variable structure data report table.

[0033] Further, the application end saves the updated information collection variable structure data report information into the database, including:

[0034] The application end saves the information filled by the user in the value range of the corresponding report data item;

[0035] The application end judges whether the value range information conforms to the data type of the report data item;

[0036] If the value range information conforms to the data type of the report data item, the application end retains the value range information;

[0037] The application end checks according to whether the data item is required to be filled and the data length, and judges whether the value range information conforms to the data verification mode of the report data item;

[0038] If the value range information conforms to the data verification mode of the report data item, the application end creates a report basic data record in the database;

[0039] The application end saves the information of the report data item in the information data item table of the database.

[0040] Further, the management end generates a query page according to the information query variable structure data report converted in the database according to the information query variable structure data format, including:

[0041] The management end judges whether there is a report data item in the information query variable structure data report; wherein the report data item includes the display feature and the data feature of the corresponding data item in the information query variable structure data format, and the report data item in the information query variable structure data report further includes a value range;

[0042] If there is a report data item in the information query variable structure data report, the management end respectively generates a corresponding query condition in the query page for each report data item in the information query variable structure data report.

[0043] Further, the management end respectively generates a corresponding query condition in the query page for each report data item in the information query variable structure data report, including:

[0044] The management end displays the data name, the data rendering object, the rendering object width and the data item display order in the query page according to the display feature of the report data item in the information query variable structure data report;

[0045] The management end displays whether it is required to be filled according to the data feature of the data item in the information query variable structure data format;

[0046] The management end performs data type processing according to the data feature of the report data item in the information query variable structure data report.

[0047] Further, the database converts the information query variable structure data format into an information query variable structure data report table, including:

[0048] The database obtains the basic information and format type information of the information query variable structure data format from the variable structure data table;

[0049] The database fills the basic information into the report table basic information table of the database as the basic information of the information query variable structure data report table;

[0050] The database fills the format type information into the report table type table of the database as the report table type information of the information query variable structure data report table;

[0051] The database reads the data feature information and display feature information of the data item of the information query variable structure data format from the data item table and fills them into the report table data item table of the database as the data feature information and display feature information in the report table data item of the information query variable structure data report table.

[0052] In a second aspect, the present application provides a system for information collection and query of variable structure data, including:

[0053] The management end is used for receiving a collection information content change requirement; according to the collection information content change requirement, a variable structure data format is customized according to a preset customized variable structure data format step, the variable structure data format includes an information collection variable structure data format and an information query variable structure data format; wherein the variable structure data format includes a format name, a format type, a format version and a data item, the data item includes a data feature and a display feature, the data feature includes a data type, a data storage field and a data verification mode of the collected information, the display feature includes a data name, a data display form, a data form style and a data item display order of the collected information; the information of the information collection variable structure data format and the information of the information query variable structure data format are saved into a database; an information query variable structure data report table is generated according to the information query variable structure data format converted in the database; after a user inputs a search condition on the query page, the database is screened according to the query condition of the query page and the search condition input by the user, and the matching result is displayed after being assembled according to the data item corresponding to the display result in the information query variable structure data format;

[0054] The database is used for converting the information collection variable structure data format into an information collection variable structure data report table and converting the information query variable structure data format into an information query variable structure data report table;

[0055] The application end is used for selecting information collection variable structure data format corresponding to a page version of a collection interface; rendering the collection interface according to information collection variable structure data report forms converted in the database according to the information collection variable structure data format; updating information collection variable structure data report form information according to the information filled by the user after the user fills information in the collection interface; and saving the updated information collection variable structure data report form information into the database.

[0056] The present application has the following advantages:

[0057] The method of the present application customizes information collection variable structure data format and information query variable structure data format according to requirements, and re-customizes if the requirements change. After each customization, the collection interface and the query page are generated according to the customized information collection variable structure data format and information query variable structure data format. In the face of common information system change problems, the information structure of the present application does not need to be redeveloped after the change, but can adapt to the change of data, thereby avoiding repeated development and saving the cost and efficiency of re-development.

[0058] In the method of the present application, the customized variable structure data format includes customization of data items. The collection interface generates corresponding fill-in content according to the data items, and the query page generates corresponding query conditions according to the data items, which can dynamically design the displayed page and realize what you see is what you get.

[0059] In the method of the present application, the customized variable structure data format includes information collection variable structure data format and information query variable structure data format, which can be saved according to different versions, provide multi-type and multi-version model concepts, and can cope with the variability and diversity of data, and cope with the characteristics of data individualization and multi-level, which also improves the efficiency of information collection management.

[0060] In the present application, the database design can adapt to variable structure data, and the database can save the customized variable structure data format of different types and versions, thereby saving the style change of the collection interface and the query page and the change of the collected information itself, meeting the requirements of interface change and the needs of data change, and realizing the compatibility of new and old data.

[0061] In the present application, the query page can also adapt to variable structure data. When the data changes, the query conditions and display results of the query page can be adjusted according to the customized information query variable structure data format, the matching results obtained by database query according to the query conditions are dynamically assembled, and the desired data is finally presented to the user. BRIEF DESCRIPTION OF DRAWINGS

[0062] In order to make the technical solutions in the embodiments of the present application or the prior art clearer, the accompanying drawings needed in the embodiments will be briefly introduced. Obviously, the accompanying drawings in the following description only need to be some embodiments of the present application, and for those skilled in the art, other drawings can be obtained without creative work based on these drawings.

[0063] Figure 1 ER diagram of the variable structure data format and the variable structure data report in the present application.

[0064] Figure 2 Schematic diagram of the system in the embodiment of the present application.

[0065] Figure 3 Flowchart of the method in the embodiment of the present application.

[0066] Figure 4 Step flowchart of customizing the variable structure data format in the embodiment of the present application.

[0067] Figure 5 Operation flowchart of the rendering of the collection interface in the embodiment of the present application.

[0068] Figure 6 Operation flowchart of saving the information in the embodiment of the present application.

[0069] Figure 7 Flowchart of viewing the variable structure data format information in the embodiment of the present application. DETAILED DESCRIPTION

[0070] It should be noted that the embodiments in the present application and the features in the embodiments can be combined with each other without conflict. The present application will be described in detail below with reference to the accompanying drawings and in combination with the embodiments. It should be pointed out that the following detailed description is exemplary and is intended to provide further description of the present application. Unless otherwise specified, all technical and scientific terms used herein have the same meaning as generally understood by those skilled in the art. The present application will be further described below in combination with the accompanying drawings and specific preferred embodiments, but it should not be limited to the protection scope of the present application.

[0071] The core idea of the present application is to abstract the collected content into a variable structure data format, abstract the collected information entries into data items, and use the variable structure data format to store information to cope with the changes of the collection function of the information management system and the diversity of the collected information content.

[0072] In information collection, the page style and the content of the collected data items are easy to change. In order to solve this variable structure problem, for example, Figure 1As shown, the present invention proposes a variable structure data format, which is an abstraction of information in an information system. The variable structure data format has basic attributes of an object, including basic information such as structure name, structure type, and structure version. It also includes data items, which are abstractions of each piece of information in the information collection and have data characteristics and display characteristics. Display characteristics are user-defined style information of the variable structure data format, providing display functions, including the data name of the collected information, data display format, data form style, data item display order, etc. The data characteristics are user-defined verification rules for the data item values ​​of the variable structure data format, including the data type of the collected information, data storage field, data verification method, etc.

[0073] like Figure 1 As shown, the present invention is expanded on the basis of the variable structure data format to obtain a variable structure data report. The variable structure data report expands the name information, time information, and report filling unit information of the report information. The variable structure data report includes report data items. The report data items contain all data items in the variable structure data format and the data characteristics and display characteristics of each data item. At the same time, the value storage of the data items is expanded. The report data items also include value fields that are not included in the data items in the variable structure data format, which are used to save the specific data values ​​entered by the user when filling in the information.

[0074] A set of data items constitutes a variable structure data format, and a set of report data items constitutes different versions of data reports. Each variable structure data report belongs to a specific variable structure data format. By abstracting report data items into objects that need to be managed, each data item is saved as a corresponding record at the database level, storing its data feature information and display feature information. Even if the data item changes, it can be stored without the need to redevelop the information management system.

[0075] Based on the proposed variable structure data format and variable structure data report, such as Figure 2 As shown, this embodiment proposes a system for information collection and querying of variable structure data, including:

[0076] The management end is used to receive the change requirements of the collected information content; according to the change requirements of the collected information content, customize the variable structure data format according to the preset customization variable structure data format steps, the variable structure data format includes the information collection variable structure data format and the information query variable structure data format; wherein, the variable structure data format includes a format name, a format type, a format version and a data item, and the data item includes a data feature and a display feature, the data feature includes the data type, data storage field and data verification method of the collected information, and the display feature includes the data name, data display form, data form style and data item display order of the collected information; the information of the information collection variable structure data format and the information of the information query variable structure data format are saved in a database; a query page is generated according to the information query variable structure data report converted in the database from the information query variable structure data format; after the user enters the search conditions on the query page, the database is screened according to the query conditions on the query page and the search conditions entered by the user, and the matching results are assembled and displayed according to the data items corresponding to the display results in the information query variable structure data format.

[0077] The database is used to convert the information collection variable structure data format into an information collection variable structure data report, and convert the information query variable structure data format into an information query variable structure data report.

[0078] The application end is used to select the information collection variable structure data format corresponding to the page version of the collection interface; render the collection interface according to the information collection variable structure data report converted in the database according to the information collection variable structure data format; after the user fills in the information on the collection interface, update the information collection variable structure data report information according to the information filled in by the user; save the updated information collection variable structure data report information in the database.

[0079] In this embodiment, the management end includes a data query and analysis module, which is used to generate corresponding query conditions in the query page based on the report data items in the information query variable structure data report, filter in the database according to the query conditions and the retrieval conditions entered by the user, and assemble the matching results according to the data items corresponding to the display results in the information query variable structure data format for display.

[0080] This embodiment abstracts the submitted reports and submitted data items into objects with multiple attributes to facilitate database storage and management. A two-layer data table structure is constructed. The database is designed from the perspectives of variable structure data format management and report management. The variable structure data format management is designed to have a two-level table structure, including:

[0081] Variable structure data table, used to store basic information, structure type information, and structure version information of information acquisition variable structure data format and information query variable structure data format;

[0082] A data item table is used to store data characteristic information and display characteristic information of each data item in the information acquisition variable structure data format and the information query variable structure data format;

[0083] Report management designs a three-level table structure, including:

[0084] Report basic information table, used to store basic information, time information, and report filling unit information of information collection variable structure data reports and information query variable structure data reports;

[0085] Report type table, used to store report type information of information collection variable structure data report and information query variable structure data report;

[0086] The report data item table is used to store the value range information, data feature information and display feature information in the report data items of the information collection variable structure data report and the information query variable structure data report.

[0087] In this embodiment, in order to better cope with the diversity of information, the management end and the application end include a data collection unit, and the data collection unit includes:

[0088] The text input component is used to provide a text box according to the data form style of the data items in the information collection variable structure data format and the information query variable structure data format published by the management end;

[0089] The constant input component is used to provide a constant input box based on the data type of the data item in the information collection variable structure data format and the information query variable structure data format published by the management terminal;

[0090] The radio button input component is used to provide radio buttons based on the data form style of the data items in the information collection variable structure data format and the information query variable structure data format published by the management end;

[0091] A checkbox input component is used to provide a checkbox according to the data form style of the data item in the information collection variable structure data format and the information query variable structure data format published by the management end;

[0092] A drop-down box input component is used to provide a drop-down box based on the data form style of the data items in the information collection variable structure data format and the information query variable structure data format published by the management end;

[0093] The secondary linkage pull-down box input component is used for providing a secondary linkage pull-down box according to a data form style of a data item in an information collection variable structure data format and an information query variable structure data format released by a management terminal.

[0094] As shown in Figure 3 Based on the proposed variable structure data format, variable structure data report and information collection and query system, the embodiment proposes an information collection and query method for variable structure data, including the following steps:

[0095] S1, the management terminal receives a collection information content change requirement;

[0096] S2, the management terminal customizes a variable structure data format according to a preset customized variable structure data format step according to the collection information content change requirement, the variable structure data format includes an information collection variable structure data format and an information query variable structure data format; wherein the variable structure data format includes a format name, a format type, a format version and a data item, the data item includes a data feature and a display feature, the data feature includes a data type, a data storage field and a data verification method of the collected information, the display feature includes a data name, a data display form, a data form style and a data item display order of the collected information;

[0097] S3, the management terminal saves information of the information collection variable structure data format and information of the information query variable structure data format into a database;

[0098] S4, the database converts the information collection variable structure data format into an information collection variable structure data report and converts the information query variable structure data format into an information query variable structure data report;

[0099] S5, the application terminal selects an information collection variable structure data format corresponding to a page version of a collection interface;

[0100] S6, the application terminal renders a collection interface according to an information collection variable structure data report obtained by converting the information collection variable structure data format in the database;

[0101] S7, after a user fills in information in the collection interface, the application terminal updates information collection variable structure data report information according to the information filled in by the user;

[0102] S8, the application terminal saves the updated information collection variable structure data report information into the database;

[0103] S9, the management terminal generates a query page according to an information query variable structure data report obtained by converting the information query variable structure data format in the database;

[0104] S10, after the user inputs the search condition in the query page, the management end screens in the database according to the query condition of the query page and the search condition input by the user, assembles and displays the matching result according to the data item corresponding to the display result in the information query variable structure data format.

[0105] Facing the common information system change problem, the embodiment makes the information structure change without redeveloping the system, but makes the system self-adapt to the change of data, thereby avoiding repeated development and saving the cost and efficiency of re-development. The customization of the variable structure data format in the embodiment includes two types, one is the customization of the information collection variable structure data format, and the other is the customization of the information query variable structure data format. The data item related to the report content is customized in the customization process of the information collection variable structure data format, and the data item related to the query condition and the display result is customized in the customization process of the information query variable result data format, so that the collection interface and the query page can also adapt to the variable structure data. When the data item changes, the collection interface can adjust the report content, the query page can adjust the query condition and the display result, the query result is dynamically assembled according to the data item corresponding to the display result in the information query variable structure data format, and finally the desired data is presented to the user.

[0106] The above steps ensure that the collected information content is from the design idea of the user, and the information filled in is the information customized to be filled in. This solves the problems of dynamic customization, timely release and what-you-see-is-what-you-get information customization. If the collected information needs to be changed, the information collection variable structure data format is directly re-customized, and the collection interface is rendered according to the latest customized information collection variable structure data format for the user to fill in. This solves the problem of re-development in response to information change.

[0107] In the embodiment, the preset customization variable structure data format step includes:

[0108] S11) edit the name and id of the variable structure data format, and edit the category of the variable structure data format to adapt to different interfaces;

[0109] S12) if a data item needs to be added, step S13) is executed, otherwise the variable structure data format is saved according to the new version, the basic information, format type information and format version information of the variable structure data format are saved in the variable structure data table of the database, the data characteristic information and display characteristic information of the data item of the variable structure data format are saved in the data item table of the database, and the process is ended and exited;

[0110] S13) adding a data item and editing the data item name and id, then selecting the data type of the data item such as numerical variable, character variable, constant, etc.; editing the data form style of the data item such as text box, single selection box, check box, drop-down box, two-level linkage drop-down box, etc.; modifying the data display form of the data item, including modifying the display row number and width, modifying the data item display order; finally editing the data verification mode of the data item, including whether the data item is required and the data length, etc.; returning to step S12).

[0111] Through the above steps, different information collection variable structure data formats can be customized according to different needs, and corresponding information collection variable structure data formats can be selected on different collection pages for publication for ordinary users to fill in, which is simple and convenient to operate without the need for re-development. This solves the problem of adaptability of information management systems to data diversity.

[0112] Through the above steps, the same type of variable structure data format can have different versions, and users can switch according to needs in subsequent steps to reduce repetitive work of customizing variable structure data formats and improve efficiency. For different versions of variable structure data formats, the same data items are all obtained by abstracting the collected information, so different versions of variable structure data formats can collect the same information data, realizing compatibility of new and old data. Using the idea of multiple versions of variable structure data formats solves the problem of compatibility of new and old data and reduces the repetitive work of repeated customization.

[0113] In the embodiment, the application end renders a collection interface according to the information collection variable structure data report table converted from the information collection variable structure data format in the database, including:

[0114] S21) obtaining the variable structure data format id and the page version of the collection interface and matching the database to obtain the corresponding information collection variable structure data format;

[0115] S22) converting the information of the information collection variable structure data format into an information collection variable structure data report table, wherein the report table data item in the information collection variable structure data report table includes the display characteristics and data characteristics of the corresponding data item in the information collection variable structure data format, and the report table data item in the information collection variable structure data report table also includes the value range not contained in the corresponding data item in the information collection variable structure data format, for saving the specific data value input by the user when filling in the information;

[0116] S23) if there is no report table data item in the information collection variable structure data report table, ending and exiting, otherwise executing step S24);

[0117] S24) generating the corresponding filling content in the collection interface for each report data item in the information collection variable structure data report, specifically including: displaying the report data item name in the collection interface according to the display characteristics of the report data item in the information collection variable structure data report, loading the corresponding data collection unit according to the display style type set in the variable structure data report corresponding format to perform page rendering, data rendering object, rendering object width and report data item arrangement order, displaying whether it is required according to the data characteristics of the report data item in the information collection variable structure data report, performing data type processing according to the data characteristics of the report data item in the information collection variable structure data report, and if it is a filled data item, it will also be converted according to the data type according to the filled data value and echoed to the page.

[0118] Step S22) of the embodiment specifically includes: obtaining the basic information and format type information of the information collection variable structure data format from the variable structure data table, filling the basic information to the report basic information table of the database as the basic information of the information collection variable structure data report, filling the format type information to the report type table of the database as the report type information of the information collection variable structure data report, reading the data characteristic information and display characteristic information of the data item of the information collection variable structure data format from the data item table and filling to the report data item table of the database as the data characteristic information and display characteristic information in the report data item of the information collection variable structure data report.

[0119] In the embodiment, the application end saves the updated information collection variable structure data report information to the database, including:

[0120] S31) if the user continues to fill in, step S32) is performed, otherwise step S34) is performed;

[0121] S32) saving the information filled by the user in the value domain of the corresponding report data item;

[0122] S33) judging whether the value domain information conforms to the data type of the report data item, and if yes, retaining the value domain information;

[0123] S34) judging whether the value domain information conforms to the data verification mode of the report data item, and verifying according to whether the data item is required and the data length, and if the verification is successful, step S35) is performed, otherwise ending and exiting;

[0124] S35) creating a report basic data record in the database, and saving the information of the report data item in the information data item table of the database.

[0125] In the embodiment, the management end generates a query page according to the information query variable structure data report converted in the database according to the information query variable structure data format, including:

[0126] S41) Obtain the variable structure data format id and match the database to obtain the corresponding information query variable structure data format;

[0127] S42) Convert the information of the information query variable structure data format into an information query variable structure data report form, wherein the report data item in the information query variable structure data report form includes the display feature and data feature of the corresponding data item in the information query variable structure data format, and the report data item in the information query variable structure data report form further includes a value range not contained in the corresponding data item in the information query variable structure data format, used for saving the search condition input by the user;

[0128] S43) If the report data item does not exist in the information query variable structure data report form, end and exit, otherwise execute step S44);

[0129] S44) Generate the corresponding search condition in the query page for each report data item in the information query variable structure data report form, specifically including: displaying the data name, data rendering object, rendering object width and data item display order in the query page according to the display feature of the report data item in the information query variable structure data report form, displaying whether it is required to fill according to the data feature of the data item in the information query variable structure data format, and performing data type processing according to the data feature of the report data item in the information query variable structure data report form.

[0130] The step S42) of the embodiment specifically includes: obtaining the basic information and format type information of the information query variable structure data format from the variable structure data table, filling the basic information into the report basic information table of the database as the basic information of the information query variable structure data report form, filling the format type information into the report type table of the database as the report type information of the information query variable structure data report form, reading the data feature information and display feature information of the data item of the information query variable structure data format from the data item table and filling them into the report data item table of the database as the data feature information and display feature information of the report data item in the information query variable structure data report form.

[0131] The method and system of the embodiment can be applied to the management of enterprise information and enterprise project information by the government, which will be described below with specific examples:

[0132] The management user can customize and publish the information collection variable structure data format and the information query variable structure data format according to the demand content on the management end, the application end selects the corresponding information collection variable structure data format, the information in the information collection variable structure data format is converted into an information collection variable structure data report in the database, and the information collection interface is rendered according to the information collection variable structure data report, so as to display the information that the management user needs the ordinary user to fill in. After the ordinary user fills in, the application end updates the information collection variable structure data report information and saves it to the database. At this time, the management end generates a query page according to the information query variable structure data format information, which can be used by the management user to query the required results. The customized information collection variable structure data format and the information query variable structure data format are not fixed once customized, but can be modified by the management user according to the demand content on the management end. Once modified, the ordinary user of the application end will fill in according to the latest fill-in content next time. Thus, the information intercommunication is greatly improved, and the work efficiency of the information management system itself and the related personnel is improved.

[0133] For example, the management end is the management end of a certain provincial industrial development comprehensive dispatching platform, which is mainly used for information management of various enterprises and various projects in the system, monthly report information management, customized design of monthly report data, innovation platform data, expert information filling and display of the management end and enterprise end, statistical analysis and retrieval display of enterprise data and project data in the system. The system adheres to humanized design and provides customized filling design of data and customized design of data display, mainly including:

[0134] Monthly report design: customized design of enterprise monthly report filling, customized design of enterprise monthly report display page, customized design of project monthly report filling, and customized design of project monthly report display page;

[0135] Innovation platform design (platform design): customized design of innovation platform filling, customized design of data display of innovation platform audit, authentication and reservation page;

[0136] Expert design: design of expert information input, and customized design of expert data query display.

[0137] Customized design of data dictionary in the system: in the system management, the modification of the customizable data dictionary of the system is provided, including management of enterprise nature, management of project nature, management of industry classification, management of demand type, management of administrative region, management of industrial chain, and management of expert specialty.

[0138] The management of data permissions in the system is an important humanized design of the system. Administrators can create more users, provide different system permissions for user accounts, grant required functional permissions, and implement permission settings for user-managed data.

[0139] The management terminal has the following functions:

[0140] 1. Monthly Report Design

[0141] Customization of corporate monthly report filling:

[0142] The monthly report currently consists of three parts: basic information of the enterprise, monthly operation status and monthly service requirements. Among them, all fields of basic information of the enterprise can be customized; monthly operation status provides format customization for a single product; monthly service requirements customization provides input style customization for a requirement. Click the "Add" button to add an editable field in the section. The specific configurable properties include: 1. Name, which refers to the field name when the field is displayed on the page. For those who need to customize the format according to the format,

[0143] The name of the time change can be configured in the following ways:

[0144] i.Current month: ${month.current};

[0145] ii.January to the current month: ${month.until};

[0146] 2. Type, which refers to the type of the field, including the following types:

[0147] i. Constants, generally used to display content that cannot be modified by the client, such as enterprise name and project name. Currently, only enterprise name and project name are supported, represented by ${enterprise.name} and ${project.name} respectively;

[0148] ii. Text box, used to enter text;

[0149] iii. Radio button, you can specify specific options through a dictionary;

[0150] iv. Drop-down boxes and secondary drop-down boxes can specify specific options through dictionaries. 3. Key values, for different types of specific settings, for example, "constant" refers to a specific constant value; "text" refers to the number of rows in a specific input box; "radio box" refers to a specific dictionary code. The current system built-in dictionaries include:

[0151] i. Nature of enterprise: property;

[0152] ii. Project property: project_property;

[0153] iii. Industry classification: industry;

[0154] iv. Industry chain: chain;

[0155] v. Requirement type: requirement;

[0156] 4. Width, refers to the width percentage of the field displayed on the page. Generally speaking, two adjacent 50% width fields will be displayed in a row.

[0157] Project monthly report filling customization:

[0158] This page customizes the filling content of the project monthly report filled by the client enterprise. The customization process is the same as that of the project monthly report. It should be noted that the system distinguishes between high-tech projects and industrial projects, so when customizing the project monthly report, the customization pages of the two are also separated. The customization functions are exactly the same, making it convenient for the two types of projects to customize different filling content and monthly report query pages.

[0159] Enterprise monthly report query customization page:

[0160] This customization function customizes the display content of the enterprise monthly report query page in the management end, including the customization of query conditions and the display information of the query page table. The specific operation is similar to the monthly report customization. The difference is that the query result display is a table, and the width of the data column in the table is not a percentage, but a pixel value. Special case: a width of 0 indicates adaptive width. Finally, by clicking the Save button, the customization information can be saved, and thereafter the monthly report query page of the management end will generate the corresponding display page according to the customization information.

[0161] Project monthly report query customization page:

[0162] This page is to customize the display page of the project monthly report query in the management end. The specific customization process is the same as that of the enterprise monthly report customization page.

[0163] After the monthly report query page is customized, the enterprise monthly report and project monthly report pages will generate specific layouts according to the customization results, display the customized related information. Then you can enter the query conditions and click the filter button to query the matching related enterprise monthly report and project monthly report. You can click the EXCEL export button in the lower left corner of the table to export the data to the local for saving.

[0164] II. Monthly report search

[0165] Search monthly report, monthly report search is similar to baidu search search function, by inputting the corresponding search word, click Enter key after automatic to database search corresponding information. Monthly report search supports multi-keyword search, each keyword is separated by space. The search range of the system mainly involves the monthly report information in the system, input the information you want to search as the search word. Click enter will find the corresponding enterprise monthly report information and project monthly report information.

[0166] The above only describes preferred embodiments of the present application and is not intended to limit the present application. Various modifications and changes can be made by those skilled in the art to the present application. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application shall be included in the protection scope of the present application.

Claims

1. A method for information collection and querying of variable structure data, characterized in that: include: The management end receives the request for changes to the collected information content; The management terminal customizes a variable structure data format according to preset steps for customizing a variable structure data format based on the requirements for changing the content of the collected information. The variable structure data format includes an information collection variable structure data format and an information query variable structure data format. The variable structure data format includes a format name, a format type, a format version, and data items. The data items include data features and display features. The data features include the data type, data storage field, and data verification method of the collected information. The display features include the data name, data display format, data form style, and data item display order of the collected information. The management terminal saves the information in the information acquisition variable structure data format and the information in the information query variable structure data format into a database; The database converts the information collection variable structure data format into an information collection variable structure data report, and converts the information query variable structure data format into an information query variable structure data report; The application side selects the information collection variable structure data format corresponding to the page version of the collection interface; The application end renders the acquisition interface of the information acquisition variable structure data report obtained by converting the information acquisition variable structure data format in the database; After the user fills in the information on the collection interface, the application updates the information collection variable structure data report information based on the information filled in by the user; The application end saves the updated information collection variable structure data report information into the database; The management end generates a query page according to the information query variable structure data report converted in the database according to the information query variable structure data format; After the user enters the search conditions on the query page, the management terminal screens the database according to the query conditions on the query page and the search conditions entered by the user, and assembles the matching results according to the data items corresponding to the display results in the information query variable structure data format and displays them.

2. The method for information collection and querying of variable structure data according to claim 1, characterized in that: The preset custom variable structure data format step includes: The management end edits the name and id of the variable structure data format; In the case where no data items need to be added, the management end saves the variable structure data format according to the new version, saves the basic information, format type information and format version information of the variable structure data format in the variable structure data table of the database, and saves the data feature information and display feature information of the data items of the variable structure data format in the data item table of the database; When adding data items, the administrator adds the data items and edits the data item name and ID, selects the data type of the data item, edits the data form style of the data item, modifies the number of display rows and width in the data display format of the data item, modifies the display order of the data items, and edits the data validation method of the data item.

3. The method for information collection and querying of variable structure data according to claim 2, characterized in that: The application end renders the information collection variable structure data report acquisition interface obtained by converting the information collection variable structure data format in the database, including: The application end determines whether a report data item exists in the information collection variable structure data report; wherein the report data item in the information collection variable structure data report includes display characteristics and data characteristics of the corresponding data item in the information collection variable structure data format, and the report data item in the information collection variable structure data report also includes a value range; If there are report data items in the information collection variable structure data report, the application side generates corresponding filling content in the collection interface for each report data item in the information collection variable structure data report; If the report data item does not exist in the information collection variable structure data report, end and exit.

4. The method for information collection and querying of variable structure data according to claim 3, characterized in that: The application generates corresponding reporting content in the collection interface for each report data item in the information collection variable structure data report, including: The application side displays the report data item name, data rendering object, rendering object width and report data item arrangement order on the collection interface according to the display characteristics of the report data item in the information collection variable structure data report; The application side displays whether a field is required based on the data characteristics of the report data item in the information collection variable structure data report; The application side performs data type processing based on the data characteristics of the report data items in the information collection variable structure data report.

5. The method for information collection and querying of variable structure data according to claim 4, characterized in that: The database converts the information collection variable structure data format into an information collection variable structure data report, including: The database obtains information from the variable structure data table to collect basic information and format type information of the variable structure data format; The database fills the basic information into the report basic information table of the database as the basic information of the information collection variable structure data report; The database fills the format type information into the report type table of the database as the report type information of the information collection variable structure data report; The database reads data characteristic information and display characteristic information of the data item in the information collection variable structure data format from the data item table and fills it into the report data item table of the database as the data characteristic information and display characteristic information in the report data item of the information collection variable structure data report.

6. The method for information collection and querying of variable structure data according to claim 5, characterized in that: The application end saves the updated information collection variable structure data report information into the database, including: The application saves the information filled in by the user in the value field of the corresponding report data item; The application side determines whether the value range information conforms to the data type of the report data item; If the value range information matches the data type of the report data item, the application side retains the value range information; The application side verifies whether the data item is required and the data length to determine whether the value range information complies with the data validation method of the report data item; If the value range information meets the data validation method of the report data item, the application creates a basic data record for the report in the database; The application side saves the information of the report data item in the information data item table of the database.

7. The method for information collection and querying of variable structure data according to claim 6, characterized in that: The management end generates a query page based on the information query variable structure data report converted in the database according to the information query variable structure data format, including: The management terminal determines whether a report data item exists in the information query variable structure data report; wherein the report data item includes display characteristics and data characteristics of the corresponding data item in the information query variable structure data format, and the report data item in the information query variable structure data report also includes a value range; If there are report data items in the information query variable structure data report, the management end generates corresponding query conditions on the query page for each report data item in the information query variable structure data report.

8. The method for information collection and querying of variable structure data according to claim 7, characterized in that: The management end generates corresponding query conditions on the query page for each report data item in the information query variable structure data report, including: The management end displays the data name, data rendering object, rendering object width and data item display order on the query page according to the display characteristics of the report data items in the information query variable structure data report; The management terminal displays whether a field is required based on the data characteristics of the data item in the information query variable structure data format; The management end performs data type processing based on the data characteristics of the report data items in the information query variable structure data report.

9. The method for information collection and querying of variable structure data according to claim 8, characterized in that: The database converts the information query variable structure data format into an information query variable structure data report, including: The database obtains information from the variable structure data table to query the basic information and format type information of the variable structure data format; The database fills the basic information into the report basic information table of the database as the basic information for information query variable structure data report; The database fills the format type information into the report type table of the database as the report type information of the information query variable structure data report; The database reads data characteristic information and display characteristic information of the data item in the information query variable structure data format from the data item table and fills it into the report data item table of the database as the data characteristic information and display characteristic information in the report data item of the information query variable structure data report.

10. A system for information collection and query of variable structure data, characterized in that: include: The management side is used to receive changes to the collected information content; According to the change requirements of the collected information content, the variable structure data format is customized according to the preset steps of customizing the variable structure data format, the variable structure data format includes the information collection variable structure data format and the information query variable structure data format; wherein, the variable structure data format includes a format name, a format type, a format version and data items, the data items include data features and display features, the data features include the data type of the collected information, the data storage field, and the data verification method, and the display features include the data name of the collected information, the data display form, the data form style, and the data item display order; the information of the information collection variable structure data format and the information of the information query variable structure data format are saved in a database; a query page is generated according to the information query variable structure data report converted in the database from the information query variable structure data format; after the user enters the search conditions on the query page, the database is screened according to the query conditions of the query page and the search conditions entered by the user, and the matching results are assembled and displayed according to the data items corresponding to the display results in the information query variable structure data format; A database for converting the information collection variable structure data format into an information collection variable structure data report, and converting the information query variable structure data format into an information query variable structure data report; The application end is used to select the information collection variable structure data format corresponding to the page version of the collection interface; render the collection interface according to the information collection variable structure data report converted in the database according to the information collection variable structure data format; after the user fills in the information on the collection interface, update the information collection variable structure data report information according to the information filled in by the user; save the updated information collection variable structure data report information in the database.

Images