Report template construction method, device, equipment and storage medium

Abstract

The present invention relates to the technical field of report construction, and discloses a report template construction method, device, equipment and storage medium. The method comprises: selecting a corresponding database management system according to the data type of the express business, and creating a database and a corresponding data table in the database management system; setting the layout of the Tab category in the data table; editing the data table configuration index, and setting the filtering component; adding horizontal scroll bars and vertical scroll bars to the long form in the data table; setting an aggregation function for calculating the back-end data to obtain key data at the corresponding position of the long form, and completing the construction of the report template. The present invention enables users to quickly locate and analyze the required data by setting the filtering function and the long form function in the report template, which greatly saves the time of report preparation and data analysis; users can customize the filtering conditions and data aggregation methods according to their own needs to meet different business analysis needs.

Description

Technical Field

[0001] The present invention relates to the technical field of report construction, and in particular to a report template construction method, device, equipment and storage medium. Background Art

[0002] With the rapid development of the express delivery industry, enterprises have an increasing demand for data management and analysis. Traditional report production methods are inefficient and difficult to meet the needs of complex data screening and long form processing. In order to improve the operational efficiency and decision-making accuracy of express delivery companies, an express delivery industry report template with screening and long form functions is needed.

[0003] Therefore, the prior art still needs to be improved and developed. Summary of the invention

[0004] The main purpose of the present invention is to solve the problem that existing reports are difficult to meet the needs of complex data screening and long form processing.

[0005] The first aspect of the present invention provides a report template construction method, including: selecting a corresponding database management system according to the type of express business data, and creating a database and a corresponding data table in the database management system; setting the layout of the Tab category in the data table; editing the configuration indicators of the data table, and setting the filtering component; adding horizontal scroll bars and vertical scroll bars to the long form in the data table; setting an aggregation function for calculating the back-end data to obtain key data at the corresponding position of the long form, and completing the construction of the report template.

[0006] Optionally, in a first implementation method of the first aspect of the present invention, the step of selecting a corresponding database management system according to the type of express business data, and creating a database and a corresponding data table in the database management system includes: selecting a corresponding database management system according to the type of express business data that needs to be stored, the express business data type including one or more of order information, delivery information and customer information; configuring the connection parameters of the database in the database management system, the connection parameters including host name, port number, user name and password; setting the security and permission management of the database according to business requirements; and creating a data table in the database for storing express business data.

[0007] Optionally, in a second implementation method of the first aspect of the present invention, the step of laying out the Tab categories in the data table includes: designing the number and names of the Tab categories in the data table according to business needs; selecting a geometric or equidistant distribution method to lay out the Tab categories, and at the same time setting the equally spaced adaptive distribution of the Tab category functions, so that different functional areas maintain consistent spacing and layout on the interface.

[0008] Optionally, in a third implementation method of the first aspect of the present invention, the steps of configuring indicator editing for the data table and setting filtering components include: customizing the fields and sorting methods of the data table through a preset indicator editing function according to the business requirements of the data table; setting appropriate region filtering components and date filtering components according to the business requirements of the data table, and selecting matching filtering components based on the hierarchical relationship of the data to ensure the accuracy and ease of use of the filtering function.

[0009] Optionally, in a fourth implementation method of the first aspect of the present invention, according to the business needs of the data table, the fields and sorting methods of the data table are customized through a preset indicator editing function, including the following steps: when the user needs to edit a single indicator in the data table, single-layer indicator editing is set and defined, and the new single-layer indicator editing definition is used in subsequent queries and analyses; when the user needs to edit multiple indicators in the data table, multi-module indicator editing is set and defined to implement batch operations on multiple indicators; when the user needs to sort a single indicator in the data table, a sorting function is added after setting the single-layer indicator editing to implement ascending or descending order of the indicators in the data table; when the user needs to sort multiple indicators in the data table, a sorting function is added after setting the multi-module indicator editing to implement ascending or descending order of the multiple indicators in the data table.

[0010] Optionally, in a fifth implementation of the first aspect of the present invention, the step of adding a horizontal scroll bar and a vertical scroll bar to a long form in a data table includes: inserting a horizontal scroll bar and a vertical scroll bar in the long form of the data table; setting the cell link properties of the horizontal scroll bar and the vertical scroll bar, and linking the scroll bar with the data area through the OFFSET function so that when the scroll bar is scrolled, the corresponding part of the data area is dynamically displayed.

[0011] Optionally, in a sixth implementation method of the first aspect of the present invention, an aggregate function for calculating the back-end data to obtain key data is set at a corresponding position in the long form to complete the construction of the report template, including the steps of: in the back-end database, using an aggregate function to calculate key data, the key data including one or more of a sum, an average, a maximum value, and a minimum value; importing the calculated key data into a data table, and using a formula or function to search for records matching the key data in the long form; based on the matching results, setting the aggregate function for calculating different key data to the corresponding position in the long form to complete the construction of the report template.

[0012] The second aspect of the present invention provides a report template construction device, including: a creation module, which is used to select a corresponding database management system according to the express business data type, and create a database and a corresponding data table in the database management system; a layout module, which is used to layout and set the Tab category in the data table; a configuration module, which is used to edit the data table configuration indicators and set the filtering component; an adding module, which is used to add horizontal scroll bars and vertical scroll bars to the long form in the data table; a function setting module, which is used to set an aggregation function for calculating the back-end data to obtain key data at the corresponding position of the long form, so as to complete the construction of the report template.

[0013] Optionally, in a first implementation method of the second aspect of the present invention, the creation module includes: a selection unit, used to select a corresponding database management system according to the type of express business data to be stored, the express business data type including one or more of order information, delivery information and customer information; a parameter configuration unit, used to configure the connection parameters of the database in the database management system, the connection parameters including host name, port number, user name and password; a permission setting unit, used to set the security and permission management of the database according to business requirements; a table creation unit, used to create a data table in the database for storing express business data.

[0014] Optionally, in a second implementation of the second aspect of the present invention, the layout module includes: a design unit, used to design the number and names of Tab categories in a data table according to business needs; a setting unit, used to select a proportional or equidistant distribution method to layout the Tab categories, and at the same time set the Tab category functions to be adaptively distributed with equal spacing, so that different functional areas maintain consistent spacing and layout on the interface.

[0015] Optionally, in a third implementation of the second aspect of the present invention, the configuration module includes: a customization unit, used to customize the fields and sorting methods of the data table according to the business requirements of the data table through a preset indicator editing function; a component setting unit, used to set appropriate region filtering components and date filtering components according to the business requirements of the data table, and select matching filtering components according to the hierarchical relationship of the data to ensure the accuracy and ease of use of the filtering function.

[0016] Optionally, in a fourth implementation method of the second aspect of the present invention, the custom unit includes: a first setting sub-unit, which is used to set single-layer indicator editing and define single-layer indicator editing when the user needs to edit a single indicator in the data table, and use the new single-layer indicator editing definition in subsequent queries and analyses; a second setting sub-unit, which is used to set multi-module indicator editing and define multi-module indicator editing when the user needs to edit multiple indicators in the data table, so as to implement batch operations on multiple indicators; a third setting sub-unit, which is used to add a sorting function after setting single-layer indicator editing when the user needs to sort a single indicator in the data table, so as to implement ascending or descending order for the indicators in the data table; a fourth setting sub-unit, which is used to add a sorting function after setting multi-module indicator editing when the user needs to sort multiple indicators in the data table, so as to implement ascending or descending order for multiple indicators in the data table.

[0017] Optionally, in a fifth implementation of the second aspect of the present invention, the adding module includes: an insertion unit for inserting a horizontal scroll bar and a vertical scroll bar in a long form of a data table; a link unit for setting the cell link properties of the horizontal scroll bar and the vertical scroll bar, and linking the scroll bar with the data area through an OFFSET function so that when the scroll bar is scrolled, the corresponding part of the data area is dynamically displayed.

[0018] Optionally, in a sixth implementation method of the second aspect of the present invention, the function setting module includes: a calculation unit, used to use aggregate functions to calculate key data in a back-end database, wherein the key data includes one or more of sum, average, maximum, and minimum values; a search unit, used to import the calculated key data into a data table, and use a formula or function to search for records matching the key data in a long form; a function setting unit, used to set the aggregate functions for calculating different key data to corresponding positions in the long form according to the matching results, to complete the construction of the report template.

[0019] The third aspect of the present invention provides a report template construction device, comprising: a memory and at least one processor, wherein the memory stores computer-readable instructions, and the memory and the at least one processor are interconnected via lines; the at least one processor calls the computer-readable instructions in the memory so that the report template construction device executes the various steps of the report template construction method as described above.

[0020] A fourth aspect of the present invention provides a computer-readable storage medium, in which computer-readable instructions are stored. When the computer-readable storage medium is run on a computer, the computer executes each step of the report template construction method described above.

[0021] Beneficial effects: In the technical solution of the present invention, a corresponding database management system is selected according to the type of express business data, and a database and a corresponding data table are created in the database management system; the Tab category in the data table is laid out; the data table configuration index is edited, and a filter component is set; a horizontal scroll bar and a vertical scroll bar are added to the long form in the data table; an aggregation function for calculating the back-end data to obtain key data is set at the corresponding position of the long form, and the construction of the report template is completed. The present invention provides a report template construction method with a filtering function and a long form function, which enables users to quickly locate and analyze the required data by setting the filtering function and the long form function in the report template, greatly saving the time of report preparation and data analysis; users can customize the filtering conditions and data aggregation methods according to their own needs to meet different business analysis needs. BRIEF DESCRIPTION OF THE DRAWINGS

[0022] Figure 1 A first flow chart of a report template construction method provided by an embodiment of the present invention;

[0023] Figure 2 A second flow chart of the report template construction method provided in an embodiment of the present invention;

[0024] Figure 3 A third flow chart of the report template construction method provided by an embodiment of the present invention;

[0025] Figure 4 A fourth flow chart of the report template construction method provided by an embodiment of the present invention;

[0026] Figure 5 A fifth flow chart of the report template construction method provided in an embodiment of the present invention;

[0027] Figure 6 A sixth flow chart of the report template construction method provided by an embodiment of the present invention;

[0028] Figure 7 A seventh flow chart of the report template construction method provided by the embodiment of the present invention;

[0029] Figure 8 A structural schematic diagram of a report template construction device provided in an embodiment of the present invention;

[0030] Fig. 9 Another structural schematic diagram of the report template construction device provided by an embodiment of the present invention;

[0031] Fig.10 A schematic diagram of the structure of a report template construction device provided in an embodiment of the present invention. DETAILED DESCRIPTION

[0032] The embodiment of the present invention provides a report template construction method, device, equipment and storage medium, selects a corresponding database management system according to the express business data type, and creates a database and a corresponding data table in the database management system; performs layout setting on the Tab category in the data table; edits the configuration index of the data table, and sets a filter component; adds horizontal scroll bars and vertical scroll bars to the long form in the data table; sets an aggregation function for calculating the back-end data to obtain key data at the corresponding position of the long form, and completes the construction of the report template. The present invention enables users to quickly locate and analyze the required data by setting the filter function and the long form function in the report template, which greatly saves the time of report preparation and data analysis; users can customize the filter conditions and data aggregation methods according to their own needs to meet different business analysis needs.

[0033] The terms "first", "second", "third", "fourth", etc. (if any) in the specification and claims of the present invention and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments described herein can be implemented in an order other than that illustrated or described herein. In addition, the terms "including" or "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units that are clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0034] For ease of understanding, the specific process of the embodiment of the present invention is described below. Figure 1 The first embodiment of the report template construction method in the embodiment of the present invention includes:

[0035] S100, selecting a corresponding database management system according to the type of express business data, and creating a database and corresponding data tables in the database management system;

[0036] In this embodiment, according to the characteristics of express delivery business data, such as large data volume, need for efficient query, concurrent access, etc., a suitable database management system (DBMS), such as MySQL, PostgreSQL or MongoDB, etc., is selected. In the selected DBMS, a new database is created to store express delivery business data. At the same time, according to the specific needs of the express delivery business, multiple data tables are designed and created, such as order tables, customer information tables, logistics information tables, etc.; each table should contain necessary fields, such as order ID, customer name, shipping address, receiving address, logistics status, etc. This embodiment can efficiently store and manage a large amount of data and improve data access speed by selecting a suitable DBMS. The clear database structure is conducive to the organization and management of data, which is convenient for subsequent data analysis and report generation.

[0037] S200, performing layout setting on the Tab categories in the data table;

[0038] According to the actual needs of the express delivery business, this embodiment divides the data table into multiple Tab categories, such as order details, customer information, logistics tracks, etc. In each Tab category, according to the type of data and display requirements, set a suitable layout, such as table spacing layout, list layout, etc. In this embodiment, clear Tab category division helps to improve the friendliness and ease of use of the user interface, and at the same time, the appropriate layout setting can intuitively display data, making it convenient for users to quickly obtain the required information.

[0039] S300, editing the data table configuration index and setting a screening component;

[0040] According to the analysis requirements of the express delivery business, this embodiment configures corresponding indicators for the data table, such as order volume, average customer price, average logistics time, etc.; above or on the side of the data table, a filtering component, such as a date selector, a drop-down box, a text box, etc., is set to filter data. This embodiment can provide users with intuitive data analysis results by configuring indicator editing, which is helpful for business decision-making; setting filtering components can help users quickly locate the required data and improve the efficiency of data query.

[0041] S400. Add horizontal and vertical scroll bars for long forms in data tables;

[0042] For long forms in data tables, this embodiment adds horizontal and vertical scroll bars according to the layout and display requirements of the page. The scroll bars can solve the problem of displaying long forms in limited page space, improve the usability of the user interface, and make it easier for users to view all the contents in the form to avoid missing information.

[0043] S500. An aggregation function for calculating backend data to obtain key data is set at a corresponding position of the long form, thereby completing the construction of the report template.

[0044] In this embodiment, at the corresponding position of the long form, according to the business analysis needs, aggregation functions such as sum, average, maximum, minimum, etc. are set to calculate the back-end data to obtain key data. The aggregation function can provide users with the calculation results of key data, which is helpful for business analysis and decision-making; by integrating the configured data tables, Tab categories, indicator editing, filtering components and aggregation functions into a report template, an efficient, easy-to-use and powerful express business data reporting system can be built, which greatly saves the time of report preparation and data analysis; users can customize the filtering conditions and data aggregation methods according to their own needs to meet different business analysis needs and provide strong support for the company's business analysis and decision-making.

[0045] See also Figure 2 The second embodiment of the report template construction method in the embodiment of the present invention includes:

[0046] S110, selecting a corresponding database management system according to the type of express business data to be stored, wherein the express business data type includes one or more of order information, delivery information, and customer information;

[0047] S120, configuring connection parameters of the database in the database management system, wherein the connection parameters include a host name, a port number, a user name, and a password;

[0048] S130. Set up database security and authority management according to business requirements;

[0049] S140: Create a data table in the database for storing express delivery service data.

[0050] This embodiment first clarifies the types of express business data that need to be stored, such as order information (including order ID, customer ID, product details, order time, etc.), delivery information (including delivery ID, order ID, delivery person ID, delivery time, delivery status, etc.) and customer information (including customer ID, name, contact information, address, etc.); based on the data type and storage requirements, select a suitable database management system. For example, if the data requires high consistency and transaction support, you can choose a relational database such as MySQL or PostgreSQL; if the data model is more flexible and requires rapid iteration, you can consider using a NoSQL database such as MongoDB. Choosing a suitable database management system can ensure efficient storage and query of data while meeting the specific needs of the business for data; different types of database management systems have their own advantages in terms of performance, scalability, ease of use, etc., and proper selection can reduce costs and improve system efficiency.

[0051] Next, obtain the database server's host name, port number, user name, and password from the database administrator or service provider, and set these connection parameters in the database management system's configuration file (such as MySQL's configuration file my.cnf or MongoDB's configuration file mongod.conf), or in the application's database connection configuration. Use the database client tool or the application's test function to verify whether the database connection is successful. Configuring the correct connection parameters ensures that the application can successfully connect to the database server and perform data read and write operations. By testing the connection, you can discover and resolve connection problems in advance and avoid data access failures in the production environment.

[0052] This embodiment creates a dedicated database user for an application or user in the database management system; according to business needs, appropriate database permissions are assigned to these users, such as query permissions, insert permissions, update permissions, and delete permissions, etc., and the database encryption function is enabled, firewall rules are configured, and the database is backed up regularly to improve the security of the database. By setting security and permission management, the database can be protected from unauthorized access and malicious attacks. Assigning appropriate permissions can ensure that users can only access and operate the data they need, improving the security and controllability of the data.

[0053] According to the data type and storage requirements of the express business, the structure of the data table is designed, including the table name, field name, field type, field length, etc.; the SQL statement or graphical interface tool of the database management system is used to create these data tables; appropriate indexes and constraints are set for the data tables to improve query performance and ensure data integrity. This embodiment creates a suitable data table to ensure orderly storage and efficient query of express business data.

[0054] As an example, suppose you choose MySQL as your database management system and need to store order information, delivery information, and customer information. You can follow these steps:

[0055] 1. Select MySQL: According to the data volume, concurrent access requirements, data consistency requirements and other factors of the express delivery business, select a suitable database management system. If the data volume is large and the transaction processing requirements are high, select a relational database such as MySQL or Oracle. If you need to process a large amount of unstructured data, you may choose a non-relational database such as MongoDB. This embodiment takes MySQL as an example. MySQL is a popular relational database management system that provides efficient data storage and query functions, supports transaction processing, and is suitable for storing express delivery business data; 2. Configure connection parameters: Set the host name (such as localhost), port number (such as 3306), user name (such as root) and password (such as yourpassword) in the MySQL configuration file. Then, in the database connection configuration of the application, use these parameters to establish a connection with the MySQL database; 3. Set security and permission management: Create a user named "courier_user" in MySQL and assign it permissions to query, insert, update and delete order information, delivery information and customer information. At the same time, enable the SSL encryption function of MySQL and configure firewall rules to limit access to the MySQL server. 4. Create data tables: various types of data related to the express delivery business process, covering all information from order creation to completion of delivery, such as order information (including order number, order time, sender and recipient information, etc.), delivery information (such as delivery personnel information, delivery status, estimated delivery time, etc.), customer information (such as customer name, contact information, address, etc.).For order information, use SQL statements to create a table named "orders", including fields such as "order_id" (order number, set as primary key to uniquely identify each order), "order_time" (order time), "sender_name" (sender name), "sender_address" (sender address), "receiver_name" (recipient name), "receiver_address" (recipient address), etc.; similarly, design a "deliveries" table for delivery information, including "delivery_id" (delivery number), "order_id" (associated order number, For establishing a connection with the order table), "delivery_man_id" (delivery man number), "delivery_status" (delivery status, such as received, in transit, delivered, etc.), "estimated_delivery_time" (estimated delivery time) and other fields; for customer information, design the "customers" table, including "customer_id" (customer number), "customer_name" (customer name), "customer_phone" (customer phone), "customer_address" (customer address) and other fields; at the same time, appropriate indexes and constraints can be set in each table. Through these steps, we can successfully configure the database management system and create data tables for storing express business data, providing a solid foundation for subsequent data operations and analysis.

[0056] See also Figure 3 , a third embodiment of the report template construction method in the embodiment of the present invention includes:

[0057] S210. Design the number and name of Tab categories in the data table according to business requirements;

[0058] S220, select a proportional or equidistant distribution method to set the layout of the Tab categories, and set the Tab category functions to be distributed adaptively with equal spacing, so that different functional areas maintain consistent spacing and layout on the interface.

[0059] This embodiment requires an in-depth understanding of business needs, including what types of information users need to view, the organizational structure of information, user operation habits, etc., which will directly determine the number and name of Tab categories. According to the analysis results, the number and name of Tab categories are designed. In terms of quantity, it should be ensured that users can easily find the required information to avoid too much information causing users to get lost, and too little information may not be integrated enough. In terms of name, it should be concise and clear, and can intuitively reflect the type of information represented by the Tab category. According to the interface design and user experience requirements, select a geometric or equidistant distribution method. In the geometric distribution method, the size of the Tab category will be dynamically adjusted according to its content or importance; in the equidistant distribution method, the Tab category will maintain the same spacing, and the size may be the same or adjusted according to the content; when implementing the Tab category layout, it is necessary to ensure that different functional areas maintain consistent spacing and layout on the interface. This can be achieved by setting an adaptive layout, that is, dynamically adjusting the spacing and size of the Tab category according to factors such as screen size and resolution, so that it can maintain good visual effects and user experience on different devices.

[0060] The proportional or equidistant distribution method of this embodiment can make the Tab categories present a neat and orderly layout on the interface, improving the aesthetics and readability of the interface; setting the Tab category functions to be adaptively distributed with equal spacing can ensure that different functional areas maintain consistent spacing and layout on the interface, avoiding discomfort or confusion for users when switching Tab categories.

[0061] See also Figure 4 The fourth embodiment of the method for constructing a report template for an express delivery in the embodiment of the present invention includes:

[0062] S310. Customize the fields and sorting methods of the data table through the preset indicator editing function according to the business requirements of the data table;

[0063] S320. According to the business requirements of the data table, set appropriate region filter components and date filter components, and select matching filter components according to the hierarchical relationship of the data to ensure the accuracy and ease of use of the filter function.

[0064] In this embodiment, the purpose, user groups, key indicators, etc. of the data table are deeply understood, and the data fields, data types and data formats that need to be displayed are determined; the indicator editing function of the data table is used to add, delete or modify the fields in the data table according to business needs; according to business needs, the default sorting fields and sorting order (ascending or descending) are selected, and the sorting method can also be customized as needed, such as sorting by date, amount, quantity and other fields, providing convenience of sorting operations, such as one-click sorting, drag-and-drop sorting, etc. The custom fields and sorting methods provided in this embodiment can more accurately reflect business data and user needs, and improve the practicality and value of the data table; users can customize the display content and sorting methods of the data table according to their own needs to improve the user experience and satisfaction. Through custom fields and sorting methods, data can be extracted, analyzed and displayed more effectively, and data processing efficiency and accuracy can be improved.

[0065] Have a deep understanding of the hierarchical structure and relationship of the data in the data table, determine the data fields and filtering conditions that need to be filtered; according to business needs, select appropriate regional filtering components, such as drop-down lists, map selections, etc., to ensure that the regional filtering components contain all possible regional options, and the options are clear and accurate, and provide multi-level regional filtering functions, such as filtering by province, city, district, etc. According to business needs, select appropriate date filtering components, such as date selectors, timelines, etc., provide a variety of date filtering methods, such as filtering by day, week, month, year, etc., and allow users to customize the date range to improve the flexibility and accuracy of filtering.

[0066] By setting appropriate region filtering components and date filtering components, this embodiment allows users to filter out required data more quickly and accurately, thereby improving data filtering efficiency; through multi-level region filtering and multiple date filtering methods, it can support more complex data analysis needs and improve the practicality and value of data tables.

[0067] As an example, for date filtering, a date selection component is provided on the user interface, through which the user can select a specific date range. After the user makes a selection, the system passes the date range information to the back-end processing program, and the back-end program uses conditional statements in the database query language, such as the BETWEEN operator in SQL, to filter out data that meets the date range; if the user selects the date range from June 1, 2024 to June 30, 2024, the back-end program will generate a query statement similar to "SELECT*FROM table_name WHERE date_column BETWEEN'2024-06-01'AND'2024-06-30'" to filter out the corresponding data from the database.

[0068] For regional filtering, the delivery region information is stored for each order record, and a region selection component, such as a drop-down menu or a checkbox, is provided on the user interface. After the user selects a specific region, the system passes the region information to the backend, and the backend filters the order data in the region through the WHERE clause in the database query statement; if the user selects "Province A", the backend program will generate a query statement of "SELECT * FROM table_name WHERE region_column = 'Province A'" to filter the data.

[0069] See also Figure 5 The fifth embodiment of the method for constructing a report template for an express delivery in the embodiment of the present invention includes:

[0070] S311. When the user needs to edit a single indicator in the data table, the single-layer indicator editing is set and defined, and the new single-layer indicator editing definition is used in subsequent query and analysis;

[0071] S312. When the user needs to edit multiple indicators in the data table, multi-module indicator editing is set and defined to implement batch operations on multiple indicators;

[0072] S313. When the user needs to sort a single indicator in the data table, a sorting function is added after setting the single-layer indicator editing to achieve ascending or descending order of the indicators in the data table;

[0073] S314. When the user needs to sort multiple indicators in the data table, a sorting function is added after setting the multi-module indicator editing to achieve ascending or descending order of the multiple indicators in the data table.

[0074] In this embodiment, an edit button is added next to each cell in the data table. When the user clicks the edit button, the cell enters edit mode, allowing the user to modify the content. After the user completes the editing, the modification is saved by clicking the confirmation button, the user's editing operation is recorded in the background, and the corresponding record in the data table is updated. Of course, a check box or selection tool can also be provided in the data table to allow the user to select multiple cells or rows. When the user selects multiple cells or rows, a unified editing interface or pop-up window is provided to allow the user to make batch modifications. After the user confirms the modification, the system applies the modifications to all selected cells or rows, records the batch modifications in the background, and updates the data table. This can significantly reduce the time required for users to edit multiple indicators and reduce errors through a unified editing interface.

[0075] In this embodiment, ascending and descending sorting buttons can also be added next to the column headings of the data table. When the user clicks the sorting button, the data table is sorted according to the selected order (ascending or descending). After sorting, the data table maintains the new order until the user sorts it again. The user can sort the data by simply clicking, and the sorted data table is more intuitive, which helps the user quickly find the required information.

[0076] In this embodiment, the user can select multiple columns and specify a sorting order (ascending or descending) for each column. The system sorts the data according to the multiple columns and orders specified by the user; the user can save the current sorting configuration as the default setting so that it can be used directly the next time the query is made. Through multi-column sorting, the user can analyze the data from multiple angles; the user can save his or her own sorting configuration to create a personalized data view.

[0077] See also Figure 6 The sixth embodiment of the method for constructing a report template for an express delivery in the embodiment of the present invention includes:

[0078] S410, inserting a horizontal scroll bar and a vertical scroll bar into the long form of the data table;

[0079] S420. Set the cell link properties of the horizontal scroll bar and the vertical scroll bar, and link the scroll bar to the data area through the OFFSET function so that when the scroll bar is scrolled, the corresponding part in the data area is dynamically displayed.

[0080] Specifically, in the application interface, a form containing a large number of data rows and columns may not be fully displayed on one screen due to the large amount of data. Therefore, horizontal and vertical scroll bars are inserted into the long form of the data table to view the undisplayed part by scrolling when the content exceeds the display area. The horizontal scroll bar is used to scroll left and right to view the content that exceeds the horizontal display range, and the vertical scroll bar is used to scroll up and down to view the content that exceeds the vertical display range. For a long form in the form of a table containing a large number of data rows and columns (assuming its HTML tag is

[0081]

[0082]

[0083]

[0084] Figure 7

[0085]

[0086]

[0087]

[0088]

[0089]

[0090] Figure 8

[0091]

[0092]

[0093]

[0094]

[0095]

[0096]

[0097] Fig. 9

[0098]

[0099]

[0100]

[0101]

[0102]

[0103]

[0104]

[0105]

[0106]

[0107]

[0108]

[0109]

[0110]

[0111]

[0112]

[0113]

[0114]

[0115]

[0116]

[0117]

[0118]

[0119]

[0120]

[0121]

[0122]

[0123]

[0124]

[0125]

[0126]

[0127] Figure 8 Fig. 9

[0128] Fig.10

[0129] Fig.10

[0130]

[0131]

[0132]

[0133] <table id＝"long_form_table">), which can be achieved by setting CSS style. In the implementation process, right-click the vertical scroll bar in E1, select "Format Control", and in the "Control" tab, find the "Cell Link" option; click the blank box on the right, and then select a blank cell (such as F1), which will be the link cell of the vertical scroll bar; set the minimum value to 1 (indicates the first row of the data table), the maximum value to 100 (indicates the last row of the data table), and the step length can be set as needed, such as 1 or 5. Right-click the horizontal scroll bar in E2, select "Format Control", and also in the "Control" tab, find the "Cell Link" option, click the blank box on the right, and then select a blank cell (such as G1), which will be the link cell of the horizontal scroll bar; set the minimum value to 1 (indicates the first column of the data table), the maximum value to 4 (indicates the last column D of the data table), and the step length can be set as needed, such as 1. Use the OFFSET function to display dynamic data range: Select a range (such as H1:K10) to display dynamic data. Enter the following formula in cell H1: OFFSET($A$1,$F$1-1,$G$1-1,10,4) This formula means: starting from cell A1, shift down by F1-1 rows, shift right by G1-1 columns, and then select an area with 10 rows and 4 columns. Drag the formula in cell H1 to the right and copy it to K1, then drag it down and copy it to the H1:K10 area. This embodiment can provide users with a more intuitive, flexible and efficient data viewing and analysis tool by inserting a scroll bar and using the OFFSET function to link data areas. Please refer to the seventh embodiment of the report template construction method for express delivery in the embodiment of the present invention, including: S510, in the back-end database, using an aggregate function to calculate key data, the key data including one or more of the sum, average, maximum value and minimum value; S520, importing the calculated key data into a data table, using a formula or function to find records matching the key data in a long form; S530, according to the matching results, setting the aggregate function for calculating different key data to the corresponding position in the long form to complete the construction of the report template. Specifically, use an appropriate database connection tool such as MySQL to connect to the backend database, and use aggregate functions (such as SUM, AVG, MAX, MIN) in SQL query statements to calculate key data. Directly calculating key data through the backend database can improve the accuracy and consistency of the data, and the use of aggregate functions can simplify complex data analysis tasks. Import the key data calculated in step S510 into a data table (such as Excel, Google Sheets, etc.), which can be copied and pasted manually, or use a data import tool (such as Excel's "Get and Transform Data" function) to use formulas or functions in a long form to find records that match the key data.For example, in Excel, VLOOKUP or INDEX-MATCH functions can be used to find records that match key data. According to the matching results, aggregate functions are set at corresponding positions in the long form. For example, in Excel, SUMIF, AVERAGEIF, MAXIF and MINIF (or similar custom functions) can be used to calculate the aggregate data of matching records. Report templates can be automatically generated, reducing the workload of manual calculation and input; the use of aggregate functions makes reports more intuitive and easy to understand, which helps decision makers make decisions quickly; report templates can be reused, improving work efficiency and consistency. The present invention provides a report template construction method with a screening function and a long form function. By setting the screening function and the long form function in the report template, users can quickly locate and analyze the required data, greatly saving the time of report preparation and data analysis; users can customize the screening conditions and data aggregation methods according to their own needs to meet different business analysis needs. The report template construction method in the embodiment of the present invention is described above. The report template construction device in the embodiment of the present invention is described below. Please refer to the report template construction device in the embodiment of the present invention. One embodiment includes: a creation module 10, which is used to select a corresponding database management system according to the express business data type, and create a database and a corresponding data table in the database management system; a layout module 20, which is used to set the layout of the Tab category in the data table; a configuration module 30, which is used to edit the configuration index of the data table and set the filter component; an addition module 40, which is used to add horizontal scroll bars and vertical scroll bars to the long form in the data table; a function setting module 50, which is used to set the aggregation function for calculating the back-end data to obtain key data at the corresponding position of the long form, and complete the construction of the report template. In this embodiment, by setting the filtering function and the long form function in the report template, the user can quickly locate and analyze the required data, which greatly saves the time of report preparation and data analysis; the user can customize the filtering conditions and data aggregation methods according to their own needs to meet different business analysis needs. Please refer to another embodiment of the report template construction device in the embodiment of the present invention, which includes: a creation module 10, which is used to select a corresponding database management system according to the express business data type, and create a database and a corresponding data table in the database management system; a layout module 20, which is used to set the layout of the Tab category in the data table; a configuration module 30, which is used to edit the configuration indicators of the data table and set the filter component; an adding module 40, which is used to add horizontal scroll bars and vertical scroll bars to the long form in the data table; a function setting module 50, which is used to set an aggregation function for calculating the back-end data to obtain key data at the corresponding position of the long form, so as to complete the construction of the report template.In this embodiment, the creation module 10 includes: a selection unit 11, which is used to select a corresponding database management system according to the type of express business data to be stored, and the express business data type includes one or more of order information, delivery information and customer information; a parameter configuration unit 12, which is used to configure the connection parameters of the database in the database management system, and the connection parameters include host name, port number, user name and password; a permission setting unit 13, which is used to set the security and permission management of the database according to business needs; a table creation unit 14, which is used to create a data table in the database for storing express business data. In this embodiment, the layout module 20 includes: a design unit 21, which is used to design the number and name of Tab categories in the data table according to business needs; a setting unit 22, which is used to select a geometric or equidistant distribution method to layout the Tab categories, and at the same time set the Tab category functions to be equidistantly distributed adaptively, so that different functional areas maintain consistent spacing and layout on the interface. In this embodiment, the configuration module 30 includes: a customization unit 31, which is used to customize the fields and sorting methods of the data table through a preset indicator editing function according to the business needs of the data table; a component setting unit 32, which is used to set appropriate regional filtering components and date filtering components according to the business needs of the data table, and select matching filtering components according to the hierarchical relationship of the data to ensure the accuracy and ease of use of the filtering function. In this embodiment, the customization unit 31 includes: a first setting subunit 311, which is used to set single-layer indicator editing and define single-layer indicator editing when the user needs to edit a single indicator in the data table, and use the new single-layer indicator editing definition in subsequent queries and analyses; a second setting subunit 312, which is used to set multi-module indicator editing and define multi-module indicator editing when the user needs to edit multiple indicators in the data table, so as to realize batch operations on multiple indicators; a third setting subunit 313, which is used to add a sorting function after setting single-layer indicator editing when the user needs to sort a single indicator in the data table, so as to realize ascending or descending order of the indicators in the data table; a fourth setting subunit 314, which is used to add a sorting function after setting multi-module indicator editing when the user needs to sort multiple indicators in the data table, so as to realize ascending or descending order of multiple indicators in the data table. In this embodiment, the adding module 40 includes: an inserting unit 41, used to insert a horizontal scroll bar and a vertical scroll bar in a long form of a data table; a linking unit 42, used to set the cell linking properties of the horizontal scroll bar and the vertical scroll bar, and link the scroll bar with the data area through the OFFSET function, so that when the scroll bar is scrolled, the corresponding part in the data area is dynamically displayed.In this embodiment, the function setting module 50 includes: a calculation unit 51, which is used to use an aggregate function to calculate key data in a backend database, and the key data includes one or more of a sum, an average value, a maximum value, and a minimum value; a search unit 52, which is used to import the calculated key data into a data table, and use a formula or function to find records matching the key data in a long form; a function setting unit 53, which is used to set the aggregate function for calculating different key data to the corresponding position in the long form according to the matching result, so as to complete the construction of the report template. The present invention provides a report template construction device, which enables users to quickly locate and analyze required data by setting a filtering function and a long form function in the report template, greatly saving the time of report preparation and data analysis; users can customize filtering conditions and data aggregation methods according to their own needs to meet different business analysis needs. . The report template construction device in the embodiment of the present invention is described in detail above and from the perspective of modular functional entities, and the report template construction device in the embodiment of the present invention is described in detail below from the perspective of hardware processing. It is a structural schematic diagram of a report template construction device provided by an embodiment of the present invention. The report template construction device 10 may have relatively large differences due to different configurations or performances, and may include one or more processors (central processing units, CPU) 11 (for example, one or more processors) and a memory 12, and one or more storage media 13 (for example, one or more massive storage devices) storing application programs 133 or data 132. Among them, the memory 12 and the storage medium 13 can be short-term storage or permanent storage. The program stored in the storage medium 13 may include one or more modules (not shown in the figure), and each module may include a series of instruction operations in the report template construction device 10. Furthermore, the processor 11 can be configured to communicate with the storage medium 13 to execute a series of instruction operations in the storage medium 13 on the report template construction device 10. The report template construction device 10 may also include one or more power supplies 14, one or more wired or wireless network interfaces 15, one or more input and output interfaces 16, and / or one or more operating systems 131, such as Windows Serve, Mac OS X, Unix, Linux, FreeBSD, etc. Those skilled in the art will appreciate that the device structure shown does not constitute a limitation on the report template construction device 10, and may include more or fewer components than shown in the figure, or combine certain components, or arrange the components differently.The present invention also provides a computer-readable storage medium, which may be a non-volatile computer-readable storage medium, or a volatile computer-readable storage medium, wherein instructions are stored in the computer-readable storage medium, and when the instructions are executed on a computer, the computer executes the steps of the report template construction method. A person skilled in the art can clearly understand that, for the convenience and simplicity of description, the specific working process of the system, device, or unit described above can refer to the corresponding process in the aforementioned method embodiment, and will not be repeated here. If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on such an understanding, the technical solution of the present invention is essentially or partly contributed to the prior art or all or part of the technical solution can be embodied in the form of a software product, which is stored in a storage medium and includes several instructions to enable a computer device (which may be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM), random access memory (RAM), magnetic disk or optical disk and other media that can store program code. As mentioned above, the above embodiments are only used to illustrate the technical solution of the present invention, but not to limit it; although the present invention is described in detail with reference to the above embodiments, ordinary technicians in this field should understand that: it is still possible to modify the technical solutions recorded in the above embodiments, or to replace some of the technical features therein; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A report template construction method, characterized in that: The report template construction method comprises: Select a corresponding database management system according to the type of express business data, and create a database and corresponding data tables in the database management system; Perform layout settings for the Tab categories in the data table; Editing the data table configuration indicators and setting the filter components; Add horizontal and vertical scroll bars for long forms in data tables; Set the aggregation function used to calculate the backend data to obtain key data at the corresponding position of the long form to complete the construction of the report template.

2. The report template construction method according to claim 1, characterized in that: The step of selecting a corresponding database management system according to the type of express business data and creating a database and a corresponding data table in the database management system comprises: Selecting a corresponding database management system according to the type of express business data to be stored, wherein the express business data type includes one or more of order information, delivery information and customer information; Configuring connection parameters of the database in the database management system, the connection parameters including host name, port number, user name and password; Set up database security and permission management according to business needs; A data table for storing express service data is created in the database.

3. The report template construction method according to claim 1, characterized in that: The step of setting the layout of the Tab categories in the data table includes: Design the number and names of Tab categories in the data table according to business needs; Select the proportional or equidistant distribution method to set the layout of the Tab categories, and set the equal-distance adaptive distribution of the Tab category functions to ensure that different functional areas maintain consistent spacing and layout on the interface.

4. The report template construction method according to claim 1, characterized in that: The steps of configuring the index editing of the data table and setting the screening component include: According to the business needs of the data table, customize the fields and sorting methods of the data table through the preset indicator editing function; According to the business needs of the data table, set appropriate region filter components and date filter components, and select matching filter components based on the hierarchical relationship of the data to ensure the accuracy and ease of use of the filtering function.

5. The report template construction method according to claim 4, characterized in that: According to the business needs of the data table, customize the fields and sorting methods of the data table through the preset indicator editing function, including the following steps: When the user needs to edit a single indicator in the data table, set up single-layer indicator editing and define the single-layer indicator editing, and use the new single-layer indicator editing definition in subsequent queries and analyses; When the user needs to edit multiple indicators in the data table, set up multi-module indicator editing and define multi-module indicator editing to achieve batch operations on multiple indicators; When the user needs to sort a single indicator in the data table, the sorting function is added after setting the single-layer indicator editing to realize the ascending or descending order of the indicators in the data table; When the user needs to sort multiple indicators in the data table, the sorting function is added after setting up the multi-module indicator editing to achieve ascending or descending order of multiple indicators in the data table.

6. The report template construction method according to claim 1, characterized in that: The steps to add horizontal and vertical scroll bars to a long form in a data table include: Insert horizontal and vertical scroll bars in long forms of data tables; Set the cell link properties of the horizontal scroll bar and the vertical scroll bar, and link the scroll bar with the data area through the OFFSET function so that when the scroll bar is scrolled, the corresponding part of the data area is dynamically displayed.

7. The report template construction method according to claim 1, characterized in that: Set the aggregation function used to calculate the backend data to obtain the key data at the corresponding position of the long form to complete the construction of the report template, including the following steps: In the backend database, an aggregate function is used to calculate key data, where the key data includes one or more of a sum, an average value, a maximum value, and a minimum value; Import the calculated key data into a data table and use formulas or functions to find records matching the key data in the long form; According to the matching results, the aggregation functions for calculating different key data are set to the corresponding positions in the long form to complete the construction of the report template.

8. A report template construction device, characterized in that: include: A creation module, used to select a corresponding database management system according to the type of express business data, and create a database and corresponding data tables in the database management system; A layout module, used to set the layout of the Tab categories in the data table; A configuration module, used to edit the configuration indicators of the data table and set the screening components; Added a module for adding horizontal and vertical scroll bars for long forms in data tables; The function setting module sets the aggregation function used to calculate the backend data to obtain key data at the corresponding position of the long form, completing the construction of the report template.

9. A report template construction device, characterized in that: comprising a memory and at least one processor, wherein the memory has computer-readable instructions stored therein; The at least one processor calls the computer-readable instructions in the memory to execute each step of the report template construction method according to any one of claims 1 to 7.

10. A computer-readable storage medium having computer-readable instructions stored thereon, characterized in that: When the computer-readable instructions are executed by a processor, the steps of the report template construction method according to any one of claims 1 to 7 are implemented.

Images