A report management method, device, equipment and medium for grassroots governance

Abstract

The embodiments of this specification disclose a report management method, device, equipment and medium for grassroots governance, and the method includes: collecting demand data corresponding to grassroots governance in the current scenario, and customizing the ledger header of grassroots governance in the current scenario based on the demand data, and adding the fields corresponding to the ledger header to a preset custom database; based on the table creation request data of the preset work ledger, obtaining the existing fields of the preset custom database, and obtaining the existing fields corresponding to the table creation request data to determine the current initial work ledger; receiving the grassroots governance form data uploaded by the front end and filling in the initial work ledger, so as to obtain the created work ledger and store it in the grassroots governance database in the preset custom database; obtaining the temporary report issued by the upper-level user end, and filling in the temporary report according to the preset authority range and the business segment to which each field in the grassroots governance database belongs.

Description

Technical Field

[0001] This specification relates to the field of data processing, and in particular to a report management method, device, equipment and medium for grassroots governance. Background Art

[0002] While the level of informatization at the grassroots level has gradually improved in recent years, there's still no effective way to reduce the burden of form-filling, which accounts for the majority of daily work. When grassroots departments collect data based on reporting requirements from higher-level departments, they typically store their own data in formats like Excel spreadsheets, which lack structured data and makes data aggregation difficult. Furthermore, higher-level business departments frequently issue statistical forms and require grassroots departments to submit data accordingly, creating a significant workload. Therefore, addressing the data reporting challenges faced by grassroots departments when unstructured data is unavailable, and improving reporting efficiency, has become a crucial aspect of grassroots work.

[0003] Currently, most reporting applications with data analysis capabilities rely on secondary development within business platforms, resulting in long development, testing, and release cycles. Furthermore, due to the high demand for ad hoc reports from grassroots departments, the market for reporting fluctuates. Consequently, reporting based on fixed templates requires program upgrades whenever demand changes, resulting in a significant workload. Furthermore, there is a lack of management for reporting data with varying permissions, making data security difficult to ensure. Summary of the Invention

[0004] In order to solve the above technical problems, one or more embodiments of this specification provide a report management method, device, equipment and medium for grassroots governance.

[0005] One or more embodiments of this specification adopt the following technical solutions:

[0006] One or more embodiments of this specification provide a report management method for grassroots governance, the method comprising:

[0007] Collect the demand data corresponding to the grassroots governance in the current scenario, customize the ledger header of the grassroots governance in the current scenario based on the demand data, and add the fields corresponding to the ledger header to the preset custom database;

[0008] Based on the table creation request data of the preset work account, the existing fields of the preset custom database are obtained to obtain the existing fields corresponding to the table creation request data to determine the current initial work account;

[0009] Receive the grassroots governance form data uploaded by the front end and fill in the initial work log to obtain the created work log and store it in the grassroots governance database in the preset custom database;

[0010] Obtain the temporary report issued by the superior user end, and fill in the temporary report according to the preset authority range and the business segment to which each field in the grassroots governance database belongs.

[0011] Furthermore, in one or more embodiments of this specification, before collecting the demand data corresponding to the grassroots governance in the current scenario and customizing the ledger header of the grassroots governance in the current scenario based on the demand data and adding it to the preset custom database, the method further includes:

[0012] Initializing the preset custom database, obtaining entity attributes of the custom database, and determining an identifier corresponding to the preset custom database based on an automatically incremented primary key;

[0013] Input multiple business logics corresponding to the grassroots governance and the data requirements corresponding to each business logic into multiple expert terminals based on a preset interface to receive custom fields uploaded by the expert terminals; wherein the custom fields include: field name, entity attributes, and business segmentation information;

[0014] Associating roles with data management scopes based on the authority control of each role in the grassroots governance; determining the authority of each role based on the matching relationship between the data management scope and the business segmentation information in the custom field;

[0015] The constituent fields of the preset custom database corresponding to each data management scope are obtained, and an authority control path is determined according to the identifier, constituent fields and the constituent structure of the database corresponding to the preset custom database, so as to authorize the permissions of each role based on the authority control path.

[0016] Furthermore, in one or more embodiments of this specification, the demand data corresponding to the grassroots governance in the current scenario is collected, and the ledger header of the grassroots governance in the current scenario is customized and configured based on the demand data and added to the preset custom database, specifically including:

[0017] Obtaining demand data corresponding to grassroots governance in the current scenario, and extracting key fields from the demand data;

[0018] Based on the field names and data types corresponding to the key fields, generate the initial ledger header for grassroots governance in the current scenario;

[0019] Acquiring the storage structure and function of the preset custom database according to the identifier, configuring the initial ledger title based on the storage structure and the function, and obtaining a ledger header;

[0020] The ledger header and the data fields corresponding to the ledger header are added to the preset custom database.

[0021] Furthermore, in one or more embodiments of the present specification, based on the table creation request data of the preset work account, obtaining the existing fields of the preset custom database to obtain the existing fields corresponding to the table creation request data to determine the current initial work account specifically includes:

[0022] Parse the table creation request data to obtain corresponding work account related information; wherein the work account related information includes: data table name, field name, data type;

[0023] Obtaining existing fields of the preset custom database, and determining existing fields corresponding to the table creation request data based on matching the existing fields with the work ledger related information;

[0024] The current initial work ledger is determined according to the existing fields corresponding to the table creation request data and the data table structure corresponding to the table creation request data.

[0025] Furthermore, in one or more embodiments of this specification, receiving the grassroots governance form data uploaded by the front end and filling in the initial work log to obtain the created work log stored in the grassroots governance database in the preset custom database specifically includes:

[0026] Receive one or more types of grassroots governance form data uploaded by the front end, and process the one or more grassroots governance form data based on the data type of the initial work log to obtain the grassroots governance form data to be filled in;

[0027] Based on the table headers corresponding to the data to be filled in the grassroots governance forms, the data to be filled in the grassroots governance forms are filled in the corresponding positions of the initial work ledger to obtain the created work ledger, and the created work ledger is stored in the grassroots governance database in the preset custom database.

[0028] Furthermore, in one or more embodiments of the present specification, obtaining a temporary report issued by a superior user terminal, and filling in the temporary report according to the preset authority range and the business segment to which each field in the grassroots governance database belongs, specifically includes:

[0029] Obtaining a temporary report issued by a superior user terminal based on a preset interface, parsing the received temporary report to determine information to be filled in the temporary report; wherein the information to be filled in includes: fields to be filled in, positions to be filled in, and data formats of each position to be filled in;

[0030] Obtain the matching relationship between the preset permission range and the current user's role, and determine the business segment corresponding to each field in the temporary report based on the business segment information of each field in the grassroots governance database;

[0031] Receive the intelligent filling method uploaded by the front end, obtain corresponding reporting data based on the intelligent filling method and the matching relationship between the preset authority range and the current user role and the business segment to which it belongs, and fill in the temporary report.

[0032] Furthermore, in one or more embodiments of the present specification, based on the intelligent filling mode and the matching relationship between the preset permission range and the current user's role and the business segment to which it belongs, corresponding reporting data is obtained and the temporary report is filled in, specifically including:

[0033] Receive intelligent filling methods triggered by the front end; wherein the intelligent filling methods include: batch intelligent filling, line-by-line intelligent filling, and reuse of cloud programs;

[0034] If it is determined that the smart filling mode is batch smart filling, then based on the matching relationship between the preset permission range and the role of the current user terminal and the business segment to which it belongs, the corresponding reporting data is obtained, and the reporting data is imported into the temporary report in batches;

[0035] If it is determined that the smart filling mode is row-by-row smart filling, a field query is performed within the preset permission range of the current user's role based on the search conditions uploaded by the front end to obtain the corresponding reporting data, and the reporting data is imported into the corresponding row of the temporary report;

[0036] If it is determined that the intelligent filling method is to reuse the cloud program, the matching data corresponding to the temporary report is determined based on the historical work log, and the matching data is updated based on the grassroots governance database to obtain the corresponding filling data, and the filling data is imported into the temporary report.

[0037] One or more embodiments of this specification provide a report management device for grassroots governance, the device comprising:

[0038] A custom unit is used to collect the demand data corresponding to the grassroots governance in the current scenario, and based on the demand data, customize the ledger header of the grassroots governance in the current scenario, and add the fields corresponding to the ledger header to the preset custom database;

[0039] A table header acquisition unit is configured to acquire existing fields of the preset custom database based on table creation request data of the preset work account, so as to acquire the existing fields corresponding to the table creation request data to determine the current initial work account;

[0040] A filling unit is used to receive the grassroots governance form data uploaded by the front end and fill in the initial work log to obtain the created work log and store it in the grassroots governance database in the preset custom database;

[0041] The temporary reporting unit is used to obtain the temporary report issued by the superior user terminal, so as to fill in the temporary report according to the preset authority range and the business segment to which each field in the grassroots governance database belongs.

[0042] One or more embodiments of this specification provide a report management device for grassroots governance, including:

[0043] at least one processor; and,

[0044] a memory communicatively connected to the at least one processor; wherein,

[0045] The memory stores instructions executable by the at least one processor, the instructions being executed by the at least one processor to enable the at least one processor to:

[0046] Collect the demand data corresponding to the grassroots governance in the current scenario, and based on the demand data, customize the ledger header of the grassroots governance in the current scenario, and add the fields corresponding to the ledger header to the preset custom database;

[0047] Based on the table creation request data of the preset work account, the existing fields of the preset custom database are obtained to obtain the existing fields corresponding to the table creation request data to determine the current initial work account;

[0048] Receive the grassroots governance form data uploaded by the front end and fill in the initial work log to obtain the created work log and store it in the grassroots governance database in the preset custom database;

[0049] Obtain the temporary report issued by the superior user end, and fill in the temporary report according to the preset authority range and the business segment to which each field in the grassroots governance database belongs.

[0050] One or more embodiments of this specification provide a non-volatile computer storage medium storing computer-executable instructions, wherein the computer-executable instructions are configured to:

[0051] Collect the demand data corresponding to the grassroots governance in the current scenario, and based on the demand data, customize the ledger header of the grassroots governance in the current scenario, and add the fields corresponding to the ledger header to the preset custom database;

[0052] Based on the table creation request data of the preset work account, the existing fields of the preset custom database are obtained to obtain the existing fields corresponding to the table creation request data to determine the current initial work account;

[0053] Receive the grassroots governance form data uploaded by the front end and fill in the initial work log to obtain the created work log and store it in the grassroots governance database in the preset custom database;

[0054] Obtain the temporary report issued by the superior user end, and fill in the temporary report according to the preset authority range and the business segment to which each field in the grassroots governance database belongs.

[0055] At least one of the above technical solutions adopted in the embodiments of this specification can achieve the following beneficial effects:

[0056] Customizing the header fields according to actual needs can ensure that the collected data accurately reflects the key indicators and information of grassroots governance, and improve the pertinence and practicality of the data. If business needs change, the ledger header can be easily adjusted and expanded without major modifications to the entire system, which is more adaptable to different scenarios and changes in governance needs. By using existing database fields to determine the initial work ledger, duplication of work can be avoided, and directly using existing valid fields can reduce the risk of errors introduced by creating new fields. Rapid filling of temporary reports based on preset authority ranges and the business segments to which they belong ensures the accuracy and rationality of the reported data, allowing grassroots staff to quickly fill in reports using authorized data, thereby reducing the burden on staff without changing the daily work processes at the grassroots level. BRIEF DESCRIPTION OF THE DRAWINGS

[0057] In order to more clearly illustrate the embodiments of this specification or the technical solutions in the prior art, the following briefly introduces the drawings required for the embodiments or the description of the prior art. Obviously, the drawings described below are only some of the embodiments described in this specification. For those skilled in the art, other drawings can be obtained based on these drawings without inventive work. In the drawings:

[0058] Figure 1 A flowchart of a report management method for grassroots governance provided in an embodiment of this specification;

[0059] Figure 2 A schematic diagram of the report management logic interaction of a grassroots governance provided in the embodiment of this specification;

[0060] Figure 3 A schematic diagram of a work log in an application scenario provided by an embodiment of this specification;

[0061] Figure 4 A schematic diagram showing an intelligent filling method in an application scenario provided by an embodiment of this specification;

[0062] Figure 5 A schematic diagram of the structure of a report management device for grassroots governance provided in an embodiment of this specification;

[0063] Figure 6 A schematic diagram of the structure of a report management device for grassroots governance provided in an embodiment of this specification;

[0064] Figure 7 A schematic diagram of the structure of a non-volatile storage medium provided in an embodiment of this specification. DETAILED DESCRIPTION

[0065] The embodiments of this specification provide a report management method, device, equipment and medium for grassroots governance.

[0066] To help those skilled in the art better understand the technical solutions in this specification, the following will provide a clear and complete description of the technical solutions in the embodiments of this specification, in conjunction with the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of this specification, not all of them. All other embodiments obtained by those skilled in the art based on the embodiments of this specification without creative work should fall within the scope of protection of this specification.

[0067] like Figure 1 As shown, the embodiment of this specification provides a flow chart of a report management method for grassroots governance. Figure 1 It can be seen that in one or more embodiments of this specification, a report management method for grassroots instructions includes the following steps:

[0068] S101: Collect the demand data corresponding to the grassroots governance in the current scenario, customize the ledger header of the grassroots governance in the current scenario based on the demand data, and add the fields corresponding to the ledger header to the preset custom database.

[0069] In order to be able to customize its own data asset library header based on the daily work flow of the grassroots, the tabular data generated during daily work is filled into the maintained daily ledger to update the data asset library. In the embodiment of this specification, the demand data corresponding to the grassroots governance in the current scenario is first collected, and the ledger header of the grassroots governance in the current scenario is customized based on the demand data, and the fields corresponding to the ledger header are added to the preset custom database, which facilitates the subsequent acquisition of the customized ledger header based on the preset custom database. In this specification, the header fields are customized according to actual needs, which can ensure that the collected data accurately reflects the key indicators and information of grassroots governance, and improve the pertinence and practicality of the data. And if the business needs change, the ledger header can be easily adjusted and expanded without major modifications to the entire system, which is more adaptable to changes in different scenarios and governance needs.

[0070] Furthermore, in one or more embodiments of this specification, before collecting the demand data corresponding to the grassroots governance in the current scenario and customizing the ledger header of the grassroots governance in the current scenario based on the demand data and adding it to the preset custom database, the method also includes the following process:

[0071] First, a pre-configured custom database is initialized and its entity attributes are retrieved. The identifier corresponding to the pre-configured custom database is then determined based on the auto-incrementing primary key. Then, the multiple business logics corresponding to grassroots governance and the corresponding data requirements for each business logic are input into multiple expert terminals based on a pre-configured interface, which then receives the custom fields uploaded by the experts. Custom fields include field names, entity attributes, and business segment information. The grassroots governance business logic and data requirements are input into multiple expert terminals, which then receive the custom fields uploaded by the experts. This fully leverages the experts' knowledge and experience, ensuring that the database design and customization meets actual business needs and improving data quality and accuracy. Then, based on the permissions of each role in grassroots governance, the roles are associated with the data management scope. The permissions for each role are determined based on the matching between the data management scope and the business segment information in the custom fields. This process, by associating roles with the data management scope and determining role permissions based on the business segment information in the custom fields, enables granular permission control over roles. This permission management mechanism helps ensure data security and compliance and avoids unnecessary data access and manipulation. Obtain the constituent fields of the preset custom database corresponding to each data management scope, determine the permission control path based on the identifier, constituent fields and database composition structure corresponding to the preset custom database, and grant permissions to each role based on the permission control path. After determining the permission control path, grant permissions to each role based on the path. This helps to improve the efficiency and accuracy of data management and ensures that each role can only access and manage data within its scope of authority. This can avoid data confusion and errors and improve data consistency and reliability. In addition, the needs and business logic of grassroots governance may change over time, and through expert participation and adjustment of permission control, it is ensured that the configuration of the database and permission management are always consistent with actual needs.

[0072] Specifically, in order to realize the customized design of the ledger header, in one or more embodiments of this specification, the demand data corresponding to the grassroots governance in the current scenario is collected, and the ledger header of the grassroots governance in the current scenario is customized and configured based on the demand data and added to the preset custom database, which specifically includes the following process:

[0073] First, obtain the demand data corresponding to grassroots governance in the current scenario, and then extract the demand data to obtain key fields. Then, based on the field name and data type corresponding to the key fields, generate the initial ledger header for grassroots governance in the current scenario. By customizing the configuration based on the demand data, it can adapt to changes in different scenarios and business needs. Then, according to the identifier, obtain the storage structure and function of the preset custom database, and configure the initial ledger title according to the storage structure and function to obtain the ledger header, and then add the ledger header and the data fields corresponding to the ledger header to the preset custom database.

[0074] S102: Based on the table creation request data of the preset work account, the existing fields of the preset custom database are obtained to obtain the existing fields corresponding to the table creation request data to determine the current initial work account.

[0075] After customizing the ledger header using the above steps, the embodiments of this specification retrieve existing fields from the pre-configured custom database based on the pre-set work ledger table creation request data. This retrieves the existing fields corresponding to the table creation request data to determine the current initial work ledger. By utilizing existing database fields, table creation time and effort can be saved, avoiding duplication of effort. Furthermore, directly using existing valid fields can reduce the risk of errors introduced by creating new fields.

[0076] Specifically, in one or more embodiments of the present specification, based on the table creation request data of the preset work ledger, obtaining existing fields of the preset custom database to obtain the existing fields corresponding to the table creation request data to determine the current initial work ledger specifically includes:

[0077] Parse the table creation request data to obtain the corresponding work ledger related information; wherein, the work ledger related information includes: data table name, field name, data type, and accurately parse the table creation request data to ensure that the work ledger related information obtained is accurate. Then obtain the existing fields of the preset custom database, and then match the existing fields with the work ledger related information to determine the existing fields corresponding to the table creation request data. Based on the matching of the existing fields with the work ledger related information, the existing fields corresponding to the table creation request data can be accurately determined. The current initial work ledger is determined based on the existing fields corresponding to the table creation request data and the data table structure corresponding to the table creation request data. Here, the existing fields are directly used without re-creation, which improves the efficiency of table creation and ensures the consistency and compatibility of the initial work ledger with the preset custom database.

[0078] S103: Receive the grassroots governance form data uploaded by the front end and fill in the initial work log to obtain the created work log and store it in the grassroots governance database in the preset custom database.

[0079] In order to realize the real-time automatic filling process of the report, in the embodiment of this specification, the grassroots governance form data uploaded by the front end is received and filled into the initial work ledger, so as to obtain the created work ledger and store it in the grassroots governance database in the preset custom database. Specifically, in one or more embodiments of this specification, the grassroots governance form data uploaded by the front end is received and filled into the initial work ledger, so as to obtain the created work ledger and store it in the grassroots governance database in the preset custom database, which specifically includes the following process:

[0080] First, one or more types of grassroots governance form data uploaded by the front end are received, and then one or more grassroots governance form data are processed according to the data type of the initial work log to obtain the grassroots governance form data to be filled in. By filling the processed grassroots governance form data uploaded by the front end into the initial work log, the standardization and consistency of the data can be ensured. At the same time, based on the table headers corresponding to each grassroots governance form data to be filled in, the grassroots governance form data to be filled in is filled in the corresponding position of the initial work log to obtain the created work log, and the created work log is stored in the grassroots governance database in the preset custom database. Based on the table headers corresponding to each grassroots governance form data to be filled in, the grassroots governance form data to be filled in is filled in the initial work log, ensuring that the grassroots governance data can be filled in the work log in a timely manner and stored in the grassroots governance database, achieving real-time report creation.

[0081] S104: Obtain a temporary report issued by the superior user terminal, and fill in the temporary report according to the preset authority range and the business segment to which each field in the grassroots governance database belongs.

[0082] The grassroots governance environment is affected by sudden tasks and there will be a large number of temporary reports. At this time, in order to respond to the temporary reports in a timely manner, the temporary reports issued by the superior user end will be obtained, and the temporary reports will be filled in according to the preset authority range and the business segment to which each field in the grassroots governance database belongs. Specifically, in one or more embodiments of this specification, the temporary reports issued by the superior user end are obtained, and the temporary reports are filled in according to the preset authority range and the business segment to which each field in the grassroots governance database belongs, specifically including:

[0083] Based on a preset interface, the system retrieves temporary reports issued by the superior user and parses them to determine the required information. This information includes the fields to be filled in, the locations to be filled in, and the data format for each location. It then determines the matching relationship between the preset permission range and the current user's role. Based on the business segment information for each field in the grassroots governance database, it determines the business segment corresponding to each field in the temporary report. It then receives the intelligent fill method uploaded by the front-end and, based on the matching relationship between the preset permission range and the current user's role and business segment, retrieves the corresponding reporting data and fills the temporary report. This process ensures the accuracy and rationality of the reported data based on the preset permission range and business segment, allowing grassroots staff to quickly fill in reports using authorized data, thereby effectively reducing the workload without changing daily grassroots workflows. Furthermore, intelligent fill-in-place reduces errors that can occur with manual input and adapts to the flexible needs of multiple scenarios.

[0084] Furthermore, in one or more embodiments of the present specification, based on the intelligent filling mode and the matching relationship between the preset permission range and the current user's role and the business segment to which it belongs, the corresponding reporting data is obtained and the temporary report is filled in, which specifically includes the following process:

[0085] First, receive the intelligent filling method triggered by the front end; wherein the intelligent filling method is as follows Figure 4 The following are shown: batch intelligent filling, line-by-line intelligent filling, and reuse of cloud programs. If it is determined that the intelligent filling method is batch intelligent filling, then the corresponding reporting data is obtained according to the matching relationship between the preset permission range and the role of the current user end and the business segment to which it belongs, and the reporting data is imported into the temporary report in batches. If it is determined that the intelligent filling method is line-by-line intelligent filling, then the field query is performed within the preset permission range of the matching role of the current user end according to the retrieval conditions uploaded by the front end to obtain the corresponding reporting data, and the reporting data is imported into the corresponding row of the temporary report. If it is determined that the intelligent filling method is to reuse cloud programs, then the matching data corresponding to the temporary report is determined based on the historical work ledger, and the matching data is updated based on the grassroots governance database to obtain the corresponding reporting data, and the reporting data is imported into the temporary report. The three methods cover various filling situations, and the staff can choose different methods according to the specific situation. The data comes from the grassroots database, and the authenticity and timeliness are guaranteed.

[0086] like Figure 2It can be seen from the logical interaction diagram that in a certain application scenario of this manual, the overall function is composed of three modules: work ledger, custom database, and temporary report. These three modules and their sub-functions generate data exchange with the grassroots database, and use the existing data to update the business data. First, after the custom database is initialized, the staff can use the configuration page to manage the database fields and the business segments to which the fields belong. Then create a work ledger, select the existing fields in the custom database as the header of the work ledger, fill in the data in the daily work file, and update it into the grassroots governance database after the built-in format and value range verification. Temporary reports issued by superiors can use the intelligent filling mechanism to obtain data that meets the requirements from the grassroots governance database, fill in, and submit the report.

[0087] like Figure 5 As shown, in an embodiment of this specification, a report management device for grassroots governance is provided, and the device includes:

[0088] A customization unit 501 is used to collect demand data corresponding to grassroots governance in the current scenario, customize the ledger header of grassroots governance in the current scenario based on the demand data, and add the fields corresponding to the ledger header to a preset custom database;

[0089] The header acquisition unit 502 is configured to acquire existing fields of the preset custom database based on the table creation request data of the preset work account, so as to obtain the existing fields corresponding to the table creation request data to determine the current initial work account;

[0090] Filling unit 503, for receiving the grassroots governance form data uploaded by the front end and filling in the initial work log, so as to obtain the created work log and store it in the grassroots governance database in the preset custom database;

[0091] The temporary reporting unit 504 is used to obtain the temporary report issued by the upper-level user terminal, and to fill in the temporary report according to the preset authority range and the business segment to which each field in the grassroots governance database belongs.

[0092] like Figure 6 As shown in FIG, the embodiment of this specification provides a schematic diagram of the internal structure of a report management device for grassroots governance. Figure 6 It can be seen that one or more embodiments of this specification provide a report management device for grassroots governance, the device including:

[0093] at least one processor; and,

[0094] a memory communicatively connected to the at least one processor; wherein,

[0095] The memory stores instructions executable by the at least one processor, the instructions being executed by the at least one processor to enable the at least one processor to:

[0096] Collect the demand data corresponding to the grassroots governance in the current scenario, and based on the demand data, customize the ledger header of the grassroots governance in the current scenario, and add the fields corresponding to the ledger header to the preset custom database;

[0097] Based on the table creation request data of the preset work account, the existing fields of the preset custom database are obtained to obtain the existing fields corresponding to the table creation request data to determine the current initial work account;

[0098] Receive the grassroots governance form data uploaded by the front end and fill in the initial work log to obtain the created work log and store it in the grassroots governance database in the preset custom database;

[0099] Obtain the temporary report issued by the superior user end, and fill in the temporary report according to the preset authority range and the business segment to which each field in the grassroots governance database belongs.

[0100] like Figure 7 As shown in FIG, the embodiment of this specification provides a schematic diagram of the structure of a non-volatile storage medium. Figure 7 It can be seen that one or more embodiments of this specification provide a non-volatile storage medium storing computer-executable instructions 701. The computer-executable instructions 701 can:

[0101] Collect the demand data corresponding to the grassroots governance in the current scenario, and based on the demand data, customize the ledger header of the grassroots governance in the current scenario, and add the fields corresponding to the ledger header to the preset custom database;

[0102] Based on the table creation request data of the preset work account, the existing fields of the preset custom database are obtained to obtain the existing fields corresponding to the table creation request data to determine the current initial work account;

[0103] Receive the grassroots governance form data uploaded by the front end and fill in the initial work log to obtain the created work log and store it in the grassroots governance database in the preset custom database;

[0104] Obtain the temporary report issued by the superior user end, and fill in the temporary report according to the preset authority range and the business segment to which each field in the grassroots governance database belongs.

[0105] The various embodiments in this specification are described in a progressive manner. Similar portions between the various embodiments can be referenced to each other, and each embodiment focuses on the differences from the other embodiments. In particular, the device, apparatus, and non-volatile computer storage medium embodiments are generally similar to the method embodiments, so their descriptions are relatively simplified. For relevant details, refer to the descriptions of the method embodiments.

[0106] The foregoing description of this specification describes specific embodiments. Other embodiments are within the scope of the appended claims. In some cases, the actions or steps recited in the claims can be performed in an order different from that described in the embodiments and still achieve the desired results. Furthermore, the processes depicted in the accompanying drawings do not necessarily require the specific order shown or the sequential order to achieve the desired results. In certain embodiments, multitasking and parallel processing are also possible or may be advantageous.

[0107] The foregoing description is merely one or more embodiments of this specification and is not intended to limit this specification. It will be apparent to those skilled in the art that various modifications and variations may be made to one or more embodiments of this specification. Any modifications, equivalent substitutions, or improvements made within the spirit and principles of one or more embodiments of this specification are intended to be within the scope of the claims of this specification.

Claims

1. A report management method for grassroots governance, characterized in that: The method comprises: Collect the demand data corresponding to the grassroots governance in the current scenario, customize the ledger header of the grassroots governance in the current scenario based on the demand data, and add the fields corresponding to the ledger header to the preset custom database; Based on the table creation request data of the preset work account, the existing fields of the preset custom database are obtained to obtain the existing fields corresponding to the table creation request data to determine the current initial work account; Receive the grassroots governance form data uploaded by the front end and fill in the initial work log to obtain the created work log and store it in the grassroots governance database in the preset custom database; Obtaining a temporary report issued by a superior user terminal, and filling in the temporary report according to the preset authority range and the business segment to which each field in the grassroots governance database belongs; Before collecting the demand data corresponding to the grassroots governance in the current scenario and customizing the ledger header of the grassroots governance in the current scenario based on the demand data and adding it to the preset custom database, the method further includes: Initializing the preset custom database, obtaining entity attributes of the custom database, and determining an identifier corresponding to the preset custom database based on an automatically incremented primary key; Input multiple business logics corresponding to the grassroots governance and the data requirements corresponding to each business logic into multiple expert terminals based on a preset interface to receive custom fields uploaded by the expert terminals; wherein the custom fields include: field name, entity attributes, and business segmentation information; Associating roles with data management scopes based on the authority control of each role in the grassroots governance; determining the authority of each role based on the matching relationship between the data management scope and the business segmentation information in the custom field; Obtaining constituent fields of the preset custom database corresponding to each data management scope, determining an authority control path according to the identifier, constituent fields, and the composition structure of the database corresponding to the preset custom database, and authorizing each role based on the authority control path; Collect the demand data corresponding to the grassroots governance in the current scenario, and customize the ledger header of the grassroots governance in the current scenario based on the demand data and add it to the preset custom database, specifically including: Obtaining demand data corresponding to grassroots governance in the current scenario, and extracting key fields from the demand data; Based on the field names and data types corresponding to the key fields, generate the initial ledger header for grassroots governance in the current scenario; Acquiring the storage structure and function of the preset custom database according to the identifier, configuring the initial ledger title based on the storage structure and the function, and obtaining a ledger header; The ledger header and the data fields corresponding to the ledger header are added to the preset custom database.

2. A report management method for grassroots governance according to claim 1, characterized in that: Based on the table creation request data of the preset work account, obtaining existing fields of the preset custom database to obtain the existing fields corresponding to the table creation request data to determine the current initial work account specifically includes: Parse the table creation request data to obtain corresponding work account related information; wherein the work account related information includes: data table name, field name, data type; Obtaining existing fields of the preset custom database, and determining existing fields corresponding to the table creation request data based on matching the existing fields with the work ledger related information; The current initial work ledger is determined according to the existing fields corresponding to the table creation request data and the data table structure corresponding to the table creation request data.

3. A report management method for grassroots governance according to claim 1, characterized in that: Receive the grassroots governance form data uploaded by the front end and fill in the initial work log to obtain the created work log and store it in the grassroots governance database in the preset custom database, specifically including: Receive one or more types of grassroots governance form data uploaded by the front end, and process the one or more grassroots governance form data based on the data type of the initial work log to obtain the grassroots governance form data to be filled in; Based on the table headers corresponding to the data to be filled in the grassroots governance forms, the data to be filled in the grassroots governance forms are filled in the corresponding positions of the initial work ledger to obtain the created work ledger, and the created work ledger is stored in the grassroots governance database in the preset custom database.

4. A report management method for grassroots governance according to claim 1, characterized in that: Obtaining a temporary report issued by a superior user end, and filling in the temporary report according to the preset authority range and the business segment to which each field in the grassroots governance database belongs, specifically including: Obtaining a temporary report issued by a superior user terminal based on a preset interface, parsing the received temporary report to determine information to be filled in the temporary report; wherein the information to be filled in includes: fields to be filled in, positions to be filled in, and data formats of each position to be filled in; Obtain the matching relationship between the preset permission range and the current user's role, and determine the business segment corresponding to each field in the temporary report based on the business segment information of each field in the grassroots governance database; Receive the intelligent filling method uploaded by the front end, obtain corresponding reporting data based on the intelligent filling method and the matching relationship between the preset authority range and the current user role and the business segment to which it belongs, and fill in the temporary report.

5. A report management method for grassroots governance according to claim 4, characterized in that: Based on the intelligent filling mode and the matching relationship between the preset permission range and the current user's role and the business segment, corresponding reporting data is obtained and the temporary report is filled in, specifically including: Receive intelligent filling methods triggered by the front end; wherein the intelligent filling methods include: batch intelligent filling, line-by-line intelligent filling, and reuse of cloud programs; If it is determined that the smart filling mode is batch smart filling, then based on the matching relationship between the preset permission range and the role of the current user terminal and the business segment to which it belongs, the corresponding reporting data is obtained, and the reporting data is imported into the temporary report in batches; If it is determined that the smart filling mode is row-by-row smart filling, a field query is performed within the preset permission range of the current user's role based on the search conditions uploaded by the front end to obtain the corresponding reporting data, and the reporting data is imported into the corresponding row of the temporary report; If it is determined that the intelligent filling method is to reuse the cloud program, the matching data corresponding to the temporary report is determined based on the historical work log, and the matching data is updated based on the grassroots governance database to obtain the corresponding filling data, and the filling data is imported into the temporary report.

6. A report management device for grassroots governance, characterized in that: The device comprises: A custom unit is used to collect the demand data corresponding to the grassroots governance in the current scenario, and based on the demand data, customize the ledger header of the grassroots governance in the current scenario, and add the fields corresponding to the ledger header to the preset custom database; A table header acquisition unit is configured to acquire existing fields of the preset custom database based on table creation request data of the preset work account, so as to acquire the existing fields corresponding to the table creation request data to determine the current initial work account; A filling unit is used to receive the grassroots governance form data uploaded by the front end and fill in the initial work log to obtain the created work log and store it in the grassroots governance database in the preset custom database; A temporary reporting unit, configured to obtain a temporary report issued by a superior user terminal, and to fill in the temporary report according to a preset authority range and the business segment to which each field in the grassroots governance database belongs; Collect the demand data corresponding to the grassroots governance in the current scenario, and customize the ledger header of the grassroots governance in the current scenario based on the demand data before adding it to the preset custom database, and also include: Initializing the preset custom database, obtaining entity attributes of the custom database, and determining an identifier corresponding to the preset custom database based on an automatically incremented primary key; Input multiple business logics corresponding to the grassroots governance and the data requirements corresponding to each business logic into multiple expert terminals based on a preset interface to receive custom fields uploaded by the expert terminals; wherein the custom fields include: field name, entity attributes, and business segmentation information; Associating roles with data management scopes based on the authority control of each role in the grassroots governance; determining the authority of each role based on the matching relationship between the data management scope and the business segmentation information in the custom field; Obtaining constituent fields of the preset custom database corresponding to each data management scope, determining an authority control path according to the identifier, constituent fields, and the composition structure of the database corresponding to the preset custom database, and authorizing each role based on the authority control path; Collect the demand data corresponding to the grassroots governance in the current scenario, and customize the ledger header of the grassroots governance in the current scenario based on the demand data and add it to the preset custom database, specifically including: Obtaining demand data corresponding to grassroots governance in the current scenario, and extracting key fields from the demand data; Based on the field names and data types corresponding to the key fields, generate the initial ledger header for grassroots governance in the current scenario; Acquiring the storage structure and function of the preset custom database according to the identifier, configuring the initial ledger title based on the storage structure and the function, and obtaining a ledger header; The ledger header and the data fields corresponding to the ledger header are added to the preset custom database.

7. A report management device for grassroots governance, characterized in that: The device comprises: at least one processor; and, a memory communicatively connected to the at least one processor; wherein, The memory stores instructions executable by the at least one processor, the instructions being executed by the at least one processor to enable the at least one processor to: Collect the demand data corresponding to the grassroots governance in the current scenario, and based on the demand data, customize the ledger header of the grassroots governance in the current scenario, and add the fields corresponding to the ledger header to the preset custom database; Based on the table creation request data of the preset work account, the existing fields of the preset custom database are obtained to obtain the existing fields corresponding to the table creation request data to determine the current initial work account; Receive the grassroots governance form data uploaded by the front end and fill in the initial work log to obtain the created work log and store it in the grassroots governance database in the preset custom database; Obtaining a temporary report issued by a superior user terminal, and filling in the temporary report according to the preset authority range and the business segment to which each field in the grassroots governance database belongs; Collect the demand data corresponding to the grassroots governance in the current scenario, and customize the ledger header of the grassroots governance in the current scenario based on the demand data before adding it to the preset custom database, and also include: Initializing the preset custom database, obtaining entity attributes of the custom database, and determining an identifier corresponding to the preset custom database based on an automatically incremented primary key; Input multiple business logics corresponding to the grassroots governance and the data requirements corresponding to each business logic into multiple expert terminals based on a preset interface to receive custom fields uploaded by the expert terminals; wherein the custom fields include: field name, entity attributes, and business segmentation information; Associating roles with data management scopes based on the authority control of each role in the grassroots governance; determining the authority of each role based on the matching relationship between the data management scope and the business segmentation information in the custom field; Obtaining constituent fields of the preset custom database corresponding to each data management scope, determining an authority control path according to the identifier, constituent fields, and the composition structure of the database corresponding to the preset custom database, and authorizing each role based on the authority control path; Collect the demand data corresponding to the grassroots governance in the current scenario, and customize the ledger header of the grassroots governance in the current scenario based on the demand data and add it to the preset custom database, specifically including: Obtaining demand data corresponding to grassroots governance in the current scenario, and extracting key fields from the demand data; Based on the field names and data types corresponding to the key fields, generate the initial ledger header for grassroots governance in the current scenario; Acquiring the storage structure and function of the preset custom database according to the identifier, configuring the initial ledger title based on the storage structure and the function, and obtaining a ledger header; The ledger header and the data fields corresponding to the ledger header are added to the preset custom database.

8. A non-volatile storage medium storing computer-executable instructions, characterized in that: The computer executable instructions are capable of: Collect the demand data corresponding to the grassroots governance in the current scenario, and based on the demand data, customize the ledger header of the grassroots governance in the current scenario, and add the fields corresponding to the ledger header to the preset custom database; Based on the table creation request data of the preset work account, the existing fields of the preset custom database are obtained to obtain the existing fields corresponding to the table creation request data to determine the current initial work account; Receive the grassroots governance form data uploaded by the front end and fill in the initial work log to obtain the created work log and store it in the grassroots governance database in the preset custom database; Obtaining a temporary report issued by a superior user terminal, and filling in the temporary report according to the preset authority range and the business segment to which each field in the grassroots governance database belongs; Collect the demand data corresponding to the grassroots governance in the current scenario, and customize the ledger header of the grassroots governance in the current scenario based on the demand data before adding it to the preset custom database, and also include: Initializing the preset custom database, obtaining entity attributes of the custom database, and determining an identifier corresponding to the preset custom database based on an automatically incremented primary key; Input multiple business logics corresponding to the grassroots governance and the data requirements corresponding to each business logic into multiple expert terminals based on a preset interface to receive custom fields uploaded by the expert terminals; wherein the custom fields include: field name, entity attributes, and business segmentation information; Associating roles with data management scopes based on the authority control of each role in the grassroots governance; determining the authority of each role based on the matching relationship between the data management scope and the business segmentation information in the custom field; Obtaining constituent fields of the preset custom database corresponding to each data management scope, determining an authority control path according to the identifier, constituent fields, and the composition structure of the database corresponding to the preset custom database, and authorizing each role based on the authority control path; Collect the demand data corresponding to the grassroots governance in the current scenario, and customize the ledger header of the grassroots governance in the current scenario based on the demand data and add it to the preset custom database, specifically including: Obtaining demand data corresponding to grassroots governance in the current scenario, and extracting key fields from the demand data; Based on the field names and data types corresponding to the key fields, generate the initial ledger header for grassroots governance in the current scenario; Acquiring the storage structure and function of the preset custom database according to the identifier, configuring the initial ledger title based on the storage structure and the function, and obtaining a ledger header; The ledger header and the data fields corresponding to the ledger header are added to the preset custom database.

Images