Custom report collection method based on multiple dimensions

Abstract

The invention relates to the technical field of data processing, in particular to a multi-dimension-based custom report acquisition method, which is suitable for customizing one-dimensional and two-dimensional form fields and multi-level headers. The invention mainly aims to provide an efficient and flexible task management and data processing mode. The system has the functions of task splitting, father and child task starting, multi-user multi-level issuing, task filling reporting, withdrawing, rollback, child user filling data merging analysis and the like. According to the invention, the user can better organize and manage tasks, and the working efficiency and the data quality are improved. And meanwhile, a more accurate and valuable data analysis result is obtained.

Description

Technical Field

[0001] The present invention relates to the field of data processing technology, and in particular to a multi-dimensional custom report collection method, which is suitable for customizing one-dimensional and two-dimensional form fields and multi-level headers. Background Art

[0002] The existing report filling and display data are all obtained through the interface in the background to send a request to the service interface for the page. The service interface pushes the data to the page and uses the VUE componentized table for display. This model has become more and more limited in the process of more and more dynamic configuration and fast response display, and the code cannot be reused, which seriously affects the demand for fast response of the business and the user experience is not good. Therefore, it is necessary to introduce some new technologies to improve the responsive display speed of dynamically configured tables. Summary of the invention

[0003] The present invention discloses a method for collecting reports based on multi-dimensional custom reports, the main purpose of which is to provide an efficient and flexible task management and data processing method. The system has the functions of task decomposition, parent-child task opening, multi-user multi-level distribution, task filling and reporting, withdrawal, rollback, and sub-user filling and data merging and analysis. Through the present invention, users can better organize and manage tasks and improve work efficiency and data quality.

[0004] A method for collecting multi-dimensional custom reports includes the following steps: S1. Form design and report customization: The form field design module enables users to easily create one-dimensional and two-dimensional form fields according to their own needs, and can set multi-level headers to meet the needs of complex data structures. In template customization, users can select one-dimensional or two-dimensional blank templates according to their actual needs, and add header fields by themselves. The front end uses vue-easytable component technology for secondary development and encapsulation into components. The generated template can be directly selected on the page, and the user can customize the configuration; S2. Task distribution and disassembly: After the template is completed, the backend JAVA implements task classification, and the front end is responsible for display. It is divided into daily, monthly, quarterly and annual reports, which are automatically distributed by scheduled tasks; the distribution is carried out level by level; S3, Task reporting: After logging in, users report according to the tasks at this level. The superior user reviews the reports of the subordinates. The front end summarizes and modifies the reports through the VUE framework and JS technology. The back end connects to the database through the springboot technology framework and configuration files, saves the data, and returns the data to the page. The task reporting is actually reported according to the user's authority and usage. S4. Task summary and modification: The highest-level user with the greatest authority will review the data reported by subordinate users. If the data fails the review, it can be returned to the subordinate user for re-revision and re-report. If the data passes the review, it will be summarized, and secondary modifications and re-report will be made based on the data reported by the subordinate. Finally, all the data will be summarized to obtain the required data statistical results; S5. Task export: After the highest-level user logs in, he / she reviews and summarizes the reports submitted by the subordinates, and uses JAVA background technology to export the task report. Excel spreadsheet data is generated in the default folder to obtain all valuable data. Users at each level can only export the data summary of themselves and their subordinates, and so on. The highest-level authority is the greatest.

[0005] The sending is performed level by level or across levels.

[0006] The specific effects of the present invention are as follows: 1. The need for complex data structures: The form field design module supports users to define the name and data type of form fields according to specific needs, solving the need for users to customize the header according to actual needs.

[0007] 2. Applicability of multi-dimensional tables: Users can customize the dimensions of table templates according to actual needs. It can be a one-dimensional table or a two-dimensional table template, which increases the user's actual usage experience and applicability.

[0008] 3. Template scalability and applicability: By creating templates, users can customize general multi-dimensional tables and provide a general business template table, which can be reused as a template instance by other users of different levels and the same business, reducing the burden of the process.

[0009] 4. Scalability and applicability: Provide a general and scalable differential model privacy protection system and method, which is suitable for different fields and different types of data analysis and sharing scenarios.

[0010] 5. Provide convenience for multi-user collaboration: Support multi-level distribution of tasks, users can fill in, report, withdraw and roll back tasks, which improves the flexibility of task execution.

[0011] 6. Data operability: It provides data merging and analysis functions. The superior user can automatically summarize the data reported by the subordinate users, or he can re-report by himself and summarize and analyze multiple sets of data. BRIEF DESCRIPTION OF THE DRAWINGS

[0012] Figure 1 Flowchart of the collection method for multi-dimensional custom reports; Figure 2 Refine the flow chart for multi-dimensional custom report collection methods; Figure 3 Schematic diagram for selecting template; Figure 4 Diagram for adding custom header fields; Figure 5 Automatically generate schematic diagrams for tasks; Figure 6 Issue schematic diagrams for tasks; Figure 7 Fill in the schematic diagram for task summary; Figure 8 A diagram summarizing the statistics of the task; DETAILED DESCRIPTION

[0013] The purpose of the present invention is to provide a method for implementing the collection of two-dimensional dynamic reports based on customization, which solves the problem that users of the collection platform can realize the filling, collection and reporting of one-dimensional and two-dimensional data according to the customized configuration header. The invention can provide users with an efficient and flexible task management and data processing method, and has the functions of task decomposition, parent-child task opening, multi-user multi-level distribution, task filling and reporting, withdrawal, rollback, and sub-user filling and data merging and analysis. Through the present invention, users can better organize and manage tasks, improve work efficiency and data quality, meet the needs of complex data structures, and improve user perception and recognition.

[0014] To solve the above technical problems, the present invention provides a customized two-dimensional dynamic report collection implementation method, including data statistics and task decomposition based on complex calculations in the Java background, connecting the database with the data application layer through the springboot technical framework, and redeveloping and generating components based on the vue-easytable encapsulation in the front end to realize dynamic configuration and collection of multi-level headers.

[0015] Specific method detailed technical description S1 Form design and report customization: The form field design module enables users to easily create one-dimensional and two-dimensional form fields according to their own needs, and can set multi-level headers to meet the needs of complex data structures. In template customization, users can choose one-dimensional or two-dimensional blank templates according to their actual needs, and add header fields by themselves. The front-end uses vue-easytable component technology for secondary development and encapsulation into components. The generated template can be directly selected on the page to facilitate user customized configuration. For example, if the user selects a two-dimensional template for operation, he can choose to add a two-dimensional template by himself, and then add it once according to the horizontal and vertical header settings. The fields can be defined according to the business. Unlike the previous table data that requires background staff to design and configure, the form design of the present invention can be completely designed and matched by the user. Figure 3 Select a template as shown, such as Figure 4 Add horizontal items and vertical headers as shown.

[0016] like Figure 5 As shown in S2, task distribution and decomposition: After the template is completed, the background JAVA implements task classification, and the front end is responsible for display. It can be divided into daily, monthly, and quarterly reports. The annual report is automatically distributed by the scheduled task. Figure 6 The distribution can be done level by level or across levels. For example, senior users can distribute to agricultural and animal husbandry users at the municipal level, or directly to the agricultural and animal husbandry bureaus at the district and county level under the municipal level, realizing multiple distribution and multi-level distribution operations. Compared with the traditional hierarchical distribution system, it greatly saves the user's operation workload and increases the user's practicality and experience.

[0017] S3 task reporting: After logging in, users report tasks at this level. The superior user reviews the reports of the subordinates. The front end uses the VUE framework and JS technology to summarize and modify the reports. The back end uses the springboot technology framework and configuration files to connect to the database, save the data, and return the data to the page. Task reporting is actually reported according to user permissions and usage. For example, the district and county level reports the configured forms, and the village level reports the actual data of the village.

[0018] like Figure 7 S4 task summary and modification: The highest-level user with the greatest authority can review the data reported by subordinate users. If the data fails the review, it can be returned to the subordinate user for re-revision and re-reporting. If the data passes the review, it can be summarized. It can also be modified and re-reported based on the subordinate data. Finally, all the data are summarized to obtain the required data statistics results. By using the present invention, users can organize and manage tasks more efficiently, improve work efficiency, help users better understand and analyze the data reported by sub-users, and obtain more accurate and valuable data analysis results.

[0019] like Figure 8 S5 task export shown: After the highest-level user logs in, he reviews and summarizes the reports submitted by the subordinates. Using JAVA background technology, he can export the task report, generate Excel spreadsheet data in the default folder of the local machine, and obtain all valuable data. Each level of user can only export the data summary of the user at this level and the subordinates, and so on. The highest-level user has the highest authority.

[0020] The following is the design process for fishery systems: In enterprise management and data analysis, the customization, issuance, allocation, reporting and review of report tasks and data statistics are a systematic process. According to the needs of the system prototype, the overall solution design detailed steps: 1. Customization of report tasks: Demand analysis: clarify the purpose, audience, required data and other information of the report. Design report template: design the style, format and presentation of the report according to the requirements.

[0021] 2. Issuance of report tasks: Determine the recipients: clarify which departments or personnel need to receive and process this report task. Issue notifications: notify relevant personnel through email, internal systems or meetings. Provide necessary instructions and guidance: ensure that the recipients understand the report requirements and operation procedures.

[0022] 3. Allocation of report tasks: Task division: assign tasks to different people or teams based on the complexity and workload of the report. Clarify responsibilities and deadlines: ensure that everyone knows their responsibilities and deadlines. Provide necessary resources and support: such as data access rights, etc.

[0023] 4. Report submission: Collect data: The recipient collects and organizes data according to the assigned tasks. Fill in the report: Fill in the data in the report template to ensure the accuracy and completeness of the data. Submit the report: Click to submit the report through the system.

[0024] 5. Audit of the report: Preliminary review: Check the completeness, accuracy and format of the report to see if it meets the requirements. Data analysis: Conduct in-depth analysis of the data in the report to check if there are any anomalies or unreasonableness. Feedback and modification: If any problems are found, notify the relevant personnel in time to make modifications and resubmit. Final review: After the modifications, review the report again to ensure that there are no problems before approving it.

[0025] 6. Data statistics: Data collation: Organize the data in the report into a unified format and structure for subsequent analysis. Data analysis: Use statistical methods, data mining techniques, etc. to conduct in-depth analysis of the data to discover patterns and trends in the data. Data visualization: Display the data in a table format by exporting to Excel for intuitive understanding and communication.

[0026] During the whole process, you need to pay attention to the following points: Confidentiality: Ensure the security and confidentiality of reports and data to avoid leakage of sensitive information.

[0027] Timeliness: Ensure the timeliness and accuracy of reports to avoid delayed decisions or losses.

[0028] Communication and collaboration: Strengthen communication and collaboration between departments to ensure the smooth completion of reporting tasks.

[0029] Continuous optimization: Continuously optimize report design and processes based on feedback and actual conditions to improve efficiency and accuracy.

[0030] In addition, the data is combined with the background algorithm, and the background node algorithm is used to start the loop. When encountering a null, the pointer moves to the right. Each branch compares whether oldStart and newStart are consistent. If they are consistent, the two pointers move to the right. When clicking to generate the dimension table, the function is used to loop so that the pointer moves to the correct position, that is, the dimension required by the user. For example, oldStart is exactly the same as newStart in relative order. Although there are two nulls in the data structure, the actual DOM structure has been moved to the correct position. Null corresponds to nothing in the DOM, so this movement is correct, and the user dimension field is generated successfully.

[0031] Meanwhile, for the table dimensionality relation, the relation between the dimension of the sum of the table spaces V and U and their respective dimensions and the dimension of their intersection is processed.

[0032] dim(V+U) = dimV + dimU - dim(V∩U).

[0033] For node calculation, the spatial dimension corresponding to its dimension can be correctly found, combined with the use of dimension fields, and finally the correct multi-dimensional table body can be generated according to the user-generated dimension situation and header fields.

[0034] The technical points involved in this plan include: 1. The front end uses componentized encapsulation to generate methods that can dynamically design and process table headers, support the generation of one-dimensional and two-dimensional tables, and solve the cumbersome process of users configuring dynamic forms. The customized templates it generates can be used in multiple ways according to needs.

[0035] 2. Dynamic data processing mechanism: All data reported by subordinate users undergo complex calculations in the background, and the highest-level users can summarize them with one click as needed. At the same time, the front-end technology supports the functions of modification and right-click insertion to realize the feasibility of dynamic data processing.

[0036] 3. Task splitting and issuing mechanism: It supports multi-level issuing of tasks. Users can fill in, report, withdraw and roll back tasks, which improves the flexibility of task execution. It also provides a powerful task decomposition function, which allows tasks to be decomposed into multiple subtasks, supports the opening and association of parent and child tasks, and facilitates hierarchical management of tasks.

[0037] 4. Permission management function: You can specify the user's permission level and set each level of users to be issued by the process to ensure that only authorized users can fill in and operate tasks.

[0038] The present invention has wide applications in the fields of project management, data collection, business process optimization, etc. Its advantages include improving task management efficiency, enhancing data quality control, promoting team collaboration, etc. In practical applications, the present invention can be applied to various industries and scenarios, such as enterprise project management, market research, education and teaching, etc. By using the system of the present invention, users can organize and manage tasks more efficiently, improve work efficiency, and obtain more accurate and valuable data analysis results.

[0039] Glossary Multidimensional Table: refers to the complex table design through customized one-dimensional horizontal header and two-dimensional vertical header to meet the needs of multi-angle data collection.

Claims

1. A method for collecting reports based on multi-dimensional custom reports, characterized in that The steps include: S1. Form design and report customization: The form field design module enables users to easily create one-dimensional and two-dimensional form fields according to their own needs, and can set multi-level headers to meet the needs of complex data structures. In template customization, users can select one-dimensional or two-dimensional blank templates according to their actual needs, and add header fields by themselves. The front end uses vue-easytable component technology for secondary development and encapsulation into components. The generated template can be directly selected on the page, and the user can customize the configuration; S2. Task distribution and disassembly: After the template is completed, the backend JAVA implements task classification, which is divided into daily, monthly, quarterly and annual reports, which are automatically distributed by scheduled tasks; the distribution is carried out level by level; S3, Task reporting: After logging in, users report according to the tasks at this level. The superior user reviews the reports of the subordinates. The front end summarizes and modifies the reports through the VUE framework and JS technology. The back end connects to the database through the springboot technology framework and configuration files, saves the data, and returns the data to the page. The task reporting is actually reported according to the user's authority and usage. S4. Task summary and modification: The highest-level user with the greatest authority will review the data reported by subordinate users. If the data fails the review, it can be returned to the subordinate user for re-revision and re-report. If the data passes the review, it will be summarized, and secondary modifications and re-report will be made based on the data reported by the subordinate. Finally, all the data will be summarized to obtain the required data statistical results; S5. Task export: After the highest-level user logs in, he / she reviews and summarizes the reports submitted by the subordinates, and uses JAVA background technology to export the task report. Excel spreadsheet data is generated in the default folder to obtain all valuable data. Users at each level can only export the data summary of themselves and their subordinates, and so on. The highest-level authority is the greatest.

2. According to claim 1, a method for collecting multi-dimensional custom reports is characterized in that The issuance can be carried out step by step or across levels.

Images